string sCommand = "SELECT * FROM Client" ; SqlConnection oConnection = new SqlConnection("SERVER=(local);UID=MyUserName;PWD=MyPassword;DATABASE=MyDatabase") ; SqlCommand oCommand = new SqlCommand("",oConnection) ; SqlDataAdapter oAdapter = new SqlDataAdapter(oCommand) ; oCommand.CommandType = CommandType.Text ; oCommand.CommandText = sCommand ; DataSet ds = new DataSet(); oAdapter.Fill(ds,"Campaign") ;ds is the result of your SQL command