Compiler Error Message: CS0117: "string" does not contain a definition for "myConnection"

狂人楚

using System;
using System.Data;
using System.Configuration;
using System.Collections;
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 lx2: System.Web.UI.Page
{
    protected void Page_Load (object sender, EventArgs e)
    {
        string connStr = System.Configuration.ConfigurationSettings.AppSettings ["connString"];

        SqlConnection myConnection = new SqlConnection (connStr);

        string queryStr = "select * from DA";

   Line 22 SqlDataAdapter myDataAdapter = new SqlDataAdapter (queryStr.myConnection);
    }

}
I am a newbie and just learned ASP.NET. I have some problems when practicing ADO.NET database connection, please help me?

The error was: Compiler error message: CS0117: "string" does not contain a definition of "myConnection"

Line 22

xinyu5460

SqlDataAdapter myDataAdapter = new SqlDataAdapter (queryStr.myConnection);
should be

SqlDataAdapter myDataAdapter = new SqlDataAdapter (queryStr, myConnection);
You have written the comma as a dot, the system judges that myConnection is a member of queryStr, so this compilation error occurs

cqgang

Positive Solutions Upstairs

狂人楚

Fainted, Fan made such a small mistake, hehe, but thank you ~~~