public SqlConnection myconn;
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
myconn = new SqlConnection(ConfigurationManager.ConnectionStrings["LocalSqlServer"].ConnectionString);
}
} protected void Button1_Click(object sender, EventArgs e)
{
string str="select * from aspnet_Users";
SqlCommand cmd = new SqlCommand(str, myconn);
myconn.Open();
this.GridView1.DataSource = cmd.ExecuteReader(CommandBehavior.CloseConnection);
this.GridView1.DataBind();
}通过ConfigurationManager.ConnectionStrings["LocalSqlServer"].ConnectionString抓取到本项目中的数据库连接字符串,单步调试,查看有myconn有值,可当执行Button1_Click事件时,SqlCommand cmd = new SqlCommand(str, myconn);语句中的myconn此时却为空?为什么?如何改?
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
myconn = new SqlConnection(ConfigurationManager.ConnectionStrings["LocalSqlServer"].ConnectionString);
}
} protected void Button1_Click(object sender, EventArgs e)
{
string str="select * from aspnet_Users";
SqlCommand cmd = new SqlCommand(str, myconn);
myconn.Open();
this.GridView1.DataSource = cmd.ExecuteReader(CommandBehavior.CloseConnection);
this.GridView1.DataBind();
}通过ConfigurationManager.ConnectionStrings["LocalSqlServer"].ConnectionString抓取到本项目中的数据库连接字符串,单步调试,查看有myconn有值,可当执行Button1_Click事件时,SqlCommand cmd = new SqlCommand(str, myconn);语句中的myconn此时却为空?为什么?如何改?
解决方案 »
- 为什么判断MIME内容无效? 依旧可以上传
- 像天空软件站的下载系统显示服务器忙闲中是怎么实现的
- 客户端控件的问题?
- *******asp.net 要从那些方面防sql注入?*******
- 怎么解析这串字符:ĬÈϲ¿ÃÅ
- FileUpload组件的文件一次上传多个文件的问题!
- 如何去掉vs2005中空白处的好多小点
- 网页当中的即时消息怎么做的?
- 请教:哪有ReaPlayer控件的参考手册
- 麻烦高手给我解释一下下面这个句子(web.config里边的)
- System.Security.SecurityException: 不允许所请求的注册表访问权
- 求一本ASP.NET的好书
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
}
} protected void Button1_Click(object sender, EventArgs e)
{
myconn = new SqlConnection(ConfigurationManager.ConnectionStrings["LocalSqlServer"].ConnectionString);
string str="select * from aspnet_Users";
SqlCommand cmd = new SqlCommand(str, myconn);
myconn.Open();
this.GridView1.DataSource = cmd.ExecuteReader(CommandBehavior.CloseConnection);
this.GridView1.DataBind();
}改成这样试试
里的执行不到。所以没值。WEB是无状态的。