//数据库查询调用方法,将返回的查询结果转换成一个二维数组
public static string[,] getData(string sql, string[,] parms)
{
SqlConnection conn = new SqlConnection();
conn.ConnectionString = "Data Source=*\\SQLEXPRESS;"
+ "Initial Catalog=Study;Integrated Security=true";
conn.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandType = CommandType.Text;
cmd.CommandText = sql;
if (parms != null && parms.GetLength(0) > 0)
{
SqlParameter[] paramaters = new SqlParameter[parms.GetLength(0)];
for (int i = 0; i < parms.GetLength(0); i++)
{
paramaters[i] = new SqlParameter(parms[i, 0], parms[i, 1]);
}
cmd.Parameters.AddRange(paramaters);
C# SQL SEVER数据库查询
最新推荐文章于 2024-05-07 14:34:15 发布