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

Question

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怎么不能继承这个类?

Answer 1

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

Answer 2

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

Answer 3

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

Answer 4

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

Answer 5

SqlConnection myConnect = new SqlConnection();
myConnection.ConnectionString=strConn;
==========================================楼主，你点不出来属性的时候代码就不用敲下去了...还有，你这种判断存在典型的SQL注入漏洞

Answer 6

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