示例代码：填充DataSet-详细的C#数据库操作总结

SQLServer 10

1.07MB 2024-07-12

#C#数据库操作 #详细代码示例 #数据集填充

示例代码：填充DataSet

public void TestDataSet() {
    DataSet ds = new DataSet();
    string sql = \"select GBBH, XM, XB, CSNY from GBXX\";
    SqlConnection connection = new SqlConnection(connectionString);
    connection.Open();
    SqlCommand cmd = new SqlCommand(sql, connection);
    SqlDataAdapter adapter = new SqlDataAdapter(cmd);
    adapter.Fill(ds);
    connection.Close();
}