Connect to sql database

Question

I'm trying to retrieve data from a database to a datagridview but i'm getting an exception,

The ConnectionString property has not been initialized.

using (conn = new SqlConnection(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=""C:\Users\BOB\Documents\Visual Studio 2012\Projects\Login\Login\Student_Marks.mdf"";Integrated Security=True"));
{
     using (adap = new SqlDataAdapter("select * from tbl_Students_Marks", conn))
     {
          DataSet das = new DataSet();
          adap.Fill(das);
          dataGridView1.DataSource = ds.Tables[0];
     }
}

You can check this http://stackoverflow.com/questions/1007786/how-to-fix-the-connectionstring-property-has-not-been-initialized — Karthik, Aug 03 '15 at 06:22
Can you debug and check whether the status of your connection ( opened or not ) — Bakri Bitar, Aug 03 '15 at 06:24
Are you sure? It seems fine to me. On which line you get this exception? — Soner Gönül, Aug 03 '15 at 06:25

score 1 · Accepted Answer · answered Aug 03 '15 at 06:43

i see your code and found that you placed ";" and the end of your first using statement where you initiating conn

using (conn = new SqlConnection(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=""C:\Users\BOB\Documents\Visual Studio 2012\Projects\Login\Login\Student_Marks.mdf"";Integrated Security=True"))//; this was the issue
{
     using (adap = new SqlDataAdapter("select * from tbl_Students_Marks", conn))
     {
          DataSet das = new DataSet();
          adap.Fill(das);
          dataGridView1.DataSource = das.Tables[0];//this must be das not ds
     }
}

Connect to sql database

1 Answers1