System.Data.SqlClient.SqlConnection sqlConnection1; //System.Data.SqlClient.SqlCommand sqlCommand1; System.Data.SqlClient.SqlDataAdapter sqlDataAdapter1; System.Data.DataSet ds; string strConn, strSql; strSql = "Select * from WZ"; strConn = "workstation id = SHIPFI; packet size = 4096; user id = sa; data source = SHIPFI; persist secu" "rity info = False; initial catalog = xiaoxiao"; sqlConnection1 = new System.Data.SqlClient.SqlConnection ( strConn); // sqlCommand1 = new System.Data.SqlClient.SqlCommand (); sqlDataAdapter1 = new System.Data.SqlClient.SqlDataAdapter (); sqlDataAdapter1.SelectCommand = new System.Data.SqlClient.SqlCommand (strSql, sqlConnection1); sqlDataAdapter1 .TableMappings.add ("Table", "WZ"); DS = New Dataset ("WZ"); SqlDataAdapter1.fill (DS);
DataGrid1.datasource = DS.TABLES ["WZ"]. DefaultView; datagrid1.database ();