class SqlHelper
{
public static DataTable executeDataTable(string queryStr, params SqlParameter[] sqlParameter)
{
string config = ConfigurationManager.AppSettings["connectString"];
using (SqlConnection conn = new SqlConnection(config))
{
conn.Open();
using (SqlCommand command = conn.CreateCommand())
{
command.CommandText = queryStr;
foreach (SqlParameter param in sqlParameter)
{
command.Parameters.Add(param);
}
DataSet dataSet = new DataSet();
SqlDataAdapter dataAdapter = new SqlDataAdapter(command);
dataAdapter.Fill(dataSet);
DataTable dataTable = dataSet.Tables[0];
return dataTable;
}
}
}
}
调用方法后得到dataTable,并输出所得值:
for (int i = 0; i < dataTable.Rows.Count; i++)
{
DataRow row = dataTable.Rows[i];
string name = Convert.ToString(row["name"]);
Console.WriteLine(name);
}