C#SqlDataAdapter类 [英] C# SqlDataAdapter Class

问题描述

大家好，
如何从我网站的其他页面上调用该课程，
每个页面(客户，供应商，产品)的SQL查询都不相同
谢谢

Hi everyone,
how can i call this class from other pages in my website,
SQL query is different in every page( customer, vendors, products)
thanks

 public static DataSet SelectRows(DataSet dataset,
    string connectionString,string queryString) 
{
    using (SqlConnection connection = 
        new SqlConnection(ConfigurationManager.ConnectionStrings["MyLocal"].ConnectionString))
    {
        SqlDataAdapter adapter = new SqlDataAdapter();
        adapter.SelectCommand = new SqlCommand(
            queryString, connection);
        adapter.Fill(dataset);
        return dataset;
    }
}

推荐答案

您将使用此库以及您在项目中引用的任何其他类创建一个库，并根据需要实例化和调用.很基本的东西.

You create a library with this, and any other classes, which you reference in your project and instantiate and call as necessary. Pretty basic stuff.

这篇关于C#SqlDataAdapter类的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！