System.Data.SqlClient.SqlConnection sqlConnection1 = new System.Data.SqlClient.SqlConnection( "integrated security=SSPI;data source=\"PX-SQL-SVR\";persist security info=False;initial catalog=PallHubMain"); System.Data.SqlClient.SqlCommand sqlSelectCommand1 = new System.Data.SqlClient.SqlCommand( "SELECT * FROM H_Today", sqlConnection1 ); System.Data.SqlClient.SqlDataAdapter sqlDataAdapter1 = new System.Data.SqlClient.SqlDataAdapter( sqlSelectCommand1 ); System.Data.DataSet dataSet = new DataSet(); try { sqlConnection1.Open(); sqlDataAdapter1.Fill( dataSet, "H_Today" ); dataGrid1.SetDataBinding( dataSet, "H_Today" ); } catch (Exception E) { MessageBox.Show( E.Message ); }