小记 SqlHelper

using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Web;
using System.Data.SqlClient;
using System.Configuration;

namespace sqlHelper.APP_Cord
{
public class sqlHelper
{

public static string strConn = ConfigurationManager.ConnectionStrings["DB"].ConnectionString;
public static DataTable ExecuteDataTable(string cmdText, params SqlParameter[] prms)
{
DataTable dt = new DataTable();
SqlConnection conn = new SqlConnection(strConn);
SqlDataAdapter sda = new SqlDataAdapter(cmdText, conn);
if (prms != null && prms.Length > 0)
{
foreach (var item in prms)
{
sda.SelectCommand.Parameters.Add(item);

}
}
sda.Fill(dt);

return dt;

}
}

 

}