编译器错误信息: CS0103: 当前上下文中不存在名称“myConnection”

[magicevy]

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;

public partial class _Default : System.Web.UI.Page
{

protected void Button1_Click(object sender, EventArgs e)
{
string strConn = "server=Localhost;uid=sa;pwd=;database=dzmusic";
string strCmd="select count(*) from admin where Username ='"+ TextBox1.Text +"' and Password = '"+ TextBox2.Text +"'";
SqlConnection myConnect = new SqlConnection();
myConnection.ConnectionString=strConn;
myConnection.Command=new sqlCommand(strCmd,myConnection);
myCommand.Connection.open();

int flag=(int)myCommand.ExecuteScalar();
myConnection.Connection.Close();
if (flag>0)
{
Session["username"]=TextBox1.Text;
Response.Redirect("default2.aspx");
}
else
{
Lable1.Text="对不起！";
TextBox2.Text="";
}
}
}


怎么修改?using System.Data.SqlClient.SqlConnection怎么不能继承这个类?

[lxmfll2000]

string connString = ConfigurationManager.ConnectionStrings["ConnectionString1"].ToString();
SqlConnection conn = new SqlConnection(connString);
conn.Open();
SqlCommand Cmd = new SqlCommand(SQL, conn);
SqlDataAdapter da = new SqlDataAdapter(Cmd);

[bingchener]

SqlConnection myConnect = new SqlConnection();
你定义的是myConnect没有定义myConnection

[bingchener]

款且你的写法格式还存在些小问题，介意看下msdn

[ProgramIsLife]

就是的啊，LZ你代码写错了，把myConnection写成了myConnect

[amandag]

SqlConnection myConnect = new SqlConnection();
myConnection.ConnectionString=strConn;
==========================================

楼主，你点不出来属性的时候代码就不用敲下去了...

还有，你这种判断存在典型的SQL注入漏洞

[wjp8271]

SqlConnection myConnect = new SqlConnection();
myConnection.ConnectionString=strConn;//改为myConnect.ConnectionString=strConn;//