For working with Data Adapter no need to Connection Object ,means if you are using connect Object no need to connection Open. try
String sql = "SELECT * FROM MIS.dbo.ListEmployee";
String
sql =
"SELECT * FROM MIS.dbo.ListEmployee"
;
String sConnectionString = "ConnectionString"; DataSet ds = new DataSet(); SqlDataAdapter adapter = new SqlDataAdapter(sql ,sConnectionString);adapter.Fill(ds);
String sConnectionString = "ConnectionString";
sConnectionString
=
"ConnectionString"
DataSet
ds =
new
();
SqlDataAdapter
adapter =
(sql ,sConnectionString);
adapter.
Fill
(ds);