public class RunCmd
{
static private SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["NaXinCon"].ToString());
static private SqlCommand cmd = new SqlCommand();
public static string run(string sql, SqlParameter[] sp, string resultFlag)
{
cmd.Parameters.Clear();
cmd.Connection = con;
for (int i = 0; i < sp.Length; ++i)
cmd.Parameters.Add(sp[i]);
cmd.CommandText = sql;
con.Open();
string result = string.Empty;
if (resultFlag == "yes")
result = cmd.ExecuteScalar().ToString();
else
cmd.ExecuteNonQuery();
con.Close();
return result;
}
}protected void btn_Click(object sender, EventArgs e)
{
StringBuilder sql = new StringBuilder();
sql.Append("select qx from admin ");
sql.Append("where loginName = @ln and passWord=@pwd");
SqlParameter[] sp = {new SqlParameter("@ln",SqlDbType.NVarChar),
new SqlParameter("@pwd",SqlDbType.NVarChar)};
sp[0].Value = name.Value;
sp[1].Value = pwd.Value; string result = RunCmd.run(sql.ToString(), sp, "yes");
}
我只在一个地方打开连接啊, 怎么说连接已经打开了??
{
static private SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["NaXinCon"].ToString());
static private SqlCommand cmd = new SqlCommand();
public static string run(string sql, SqlParameter[] sp, string resultFlag)
{
cmd.Parameters.Clear();
cmd.Connection = con;
for (int i = 0; i < sp.Length; ++i)
cmd.Parameters.Add(sp[i]);
cmd.CommandText = sql;
con.Open();
string result = string.Empty;
if (resultFlag == "yes")
result = cmd.ExecuteScalar().ToString();
else
cmd.ExecuteNonQuery();
con.Close();
return result;
}
}protected void btn_Click(object sender, EventArgs e)
{
StringBuilder sql = new StringBuilder();
sql.Append("select qx from admin ");
sql.Append("where loginName = @ln and passWord=@pwd");
SqlParameter[] sp = {new SqlParameter("@ln",SqlDbType.NVarChar),
new SqlParameter("@pwd",SqlDbType.NVarChar)};
sp[0].Value = name.Value;
sp[1].Value = pwd.Value; string result = RunCmd.run(sql.ToString(), sp, "yes");
}
我只在一个地方打开连接啊, 怎么说连接已经打开了??
解决方案 »
- 大家在向网上购买域名的服务器发送网站文件后,有没有遇到在应用程序级别之外使用注册为 allowDefinition='MachineToApplication'
- 软件打包和那打印谁有小列子咯。。。。谢谢
- Session["ssbmid"]和Session["ssbmid"].TOString()有什么区别!
- 怎样实现这样的排序SELECT * FROM TABLE WHERE ID IN (-1,200795,200032,200037,200048,200063)
- GridView用圖表進行統計數據並顯示出來
- OutputCache 问题,大家帮忙看看啊!
- 连接数据库时配置文件出错,高手请进
- 上海盛大网络科技有限公司运营网络部技术总监-杨华前来为您答疑
- ACCESS中的备注字段对应C#OLEDBTYPE的什么类型?
- 表单提交的问题
- 用Javascript实现鼠标颜色
- 一個奇怪的</script>的問題。
if(没打开)
连接.打开();