OleDbConnection myConnection = new OleDbConnection();
OleDbDataAdapter myCommand = new OleDbDataAdapter();

myConnection = new OleDbConnection("Provider=SQLOLEDB;Data Source=192.168.1.1; Initial Catalog=TuoDB; User Id=TuoID; Password=TuaPwd");
myConnection.Open();

myCommand = new OleDbDataAdapter("SELECT * FROM TuaTabella",myConnection);

DataSet ds = new DataSet();

myCommand.Fill(ds, "TuaTabella");
dataGridView1.DataSource = ds.Tables["TuaTabella"].DefaultView;