函数内需要获取数据库,需要循环调用该函数,怎样把获取数据库的代码提出去,只留下获取的Table,以提高效率
public void init(HttpContext context)
{
string connString = "Integrated Security=false;data source=192.1.3.134;initial catalog=ProWM;user id=sa;pwd=Tuopu123";
SqlConnection sqlConnection = new SqlConnection(connString);
string sql = "select C1,C2,C3,C4,C5,C6,C7,C8,C9,C10 from ProWM.dbo.Matrix";
SqlDataAdapter da = new SqlDataAdapter(sql, sqlConnection);
DataTable dt = new DataTable();
da.Fill(dt);
var row = context.Request.Params["row"];
var col = context.Request.Params["col"];
if (dt.Rows[Convert.ToInt32(row)-1][Convert.ToInt32(col)-1].ToString() == "1")
{
context.Response.Write("√");
}
else
{
context.Response.Write("");
}
}