0

I have created Table in SQL server with visual studio 2005 Table name Student
and table data ID,name, surname, indeks, years,
I have this code in C#

protected void Button1_Click(object sender, EventArgs e)
    {
       // try
        //{
        SqlConnection conn = new SqlConnection("Data Source=.\\SQLEXPRESS;AttachDbFilename=\"|DataDirectory|\\db_lab8.mdf\";Integrated Security=True;Connect Timeout=30;User Instance=True");
              //                                   ("Data Source=.\\SQLEXPRESS;AttachDbFilename=\"|DataDirectory|\\db_lab8.mdf\";Integrated Security=True;Connect Timeout=30;User Instance=True");
            conn.Open();
            //              
            SqlCommand a = new SqlCommand("INSERT INTO Student(ID,name, surname, indeks, years) VALUES ('" + TextBox5.Text + "','" + TextBox1.Text + "','" + TextBox2.Text + "','" + TextBox3.Text + "','" + TextBox4.Text + "')", conn);
            a.Connection.Open();
            a.ExecuteNonQuery();
            a.Dispose();
            a.Connection.Close();
            conn.Close();
            Response.Redirect("Default.aspx");
       // }
        //catch (Exception eee)
        //{
         //   Console.WriteLine("Generic Exception Handler: {0}", eee.ToString());
        //}

        
    }

I have tried with try and catch but it doesn't works OK
it just shows the browser and it executes the catch block

without try and catch it shows bug at the line: conn.Open();
and it says

A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.

3
Contributors
3
Replies
4
Views
7 Years
Discussion Span
Last Post by tonief
0

Database file is not found.

SqlConnection conn;
conn= new SqlConnection("Data Source=.\\SQLEXPRESS;AttachDbFilename=|DataDirectory|\\db_lab8.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True");
This question has already been answered. Start a new discussion instead.
Take the time to help us to help you. Please be thoughtful and detailed and be sure to adhere to our posting rules.