C#中如何监控类属性更改的代码案例分享

2025-02-24 00:52:59
推荐回答(1个)
回答1:

写好此方法后调用的时候就直接传递表名和SQL语句过来就OK了!
public class AnonymousSqlClient
{
private static string connectionString = global::DataAccess.Properties.Settings.Default.ERPDBConnectionString;

public static DataSet SelectRows(string tableName, string query)
{
DataSet dataset = new DataSet();
dataset.Tables.Add(tableName);

using (SqlConnection connection = new SqlConnection(connectionString))
{
SqlDataAdapter adapter = new SqlDataAdapter();
adapter.SelectCommand = new SqlCommand(query, connection);
adapter.Fill(dataset.Tables[0]);
return dataset;
}
}
}