Hello,

I used the following c# coding to connect SQL SERVER 2005 with Visual Web Developer 2005 ASP.Net website I'm developing.

SqlConnection con = new SqlConnection("Server=.\SQLEXPRESS;Database=bsbc.mdf;Trusted_Connectopn=True");
SqlCommand cmd = new SqlCommand("INSERT INTO customer VALUES('"+txtCusId.Text+"', '"+txtCusName.Text+"', '"+txtContactNo.Text+"', '"+txtAddSt1.Text+", "+txtAddSt2+", "+txtAddCity+"', '"+txtCusEmail.Text+"')");
con.Open();
DataSet ds = new DataSet(cmd, con);
SqlDataAdapter da = new SqlDataAdapter();
da.Fill(ds);
con.Close();

But it doesn't get compiled and says, 'Could not find schema information for the element' in the Web.config file. Do I have to add any code in the Web.config file? Greatly appreciate support in fixing this problem. I cannot proceed with any other work without the database connectivity done.

Advance thanks

Configuration: Windows XP
Firefox 3.0.10