How to Add SQL Database in ASP.NET Website

How to Add SQL Database (.mdf) in ASP.NET Website 

 

You can easily  Add .mdf Database in ASP.NET Application.You can perform Insertion Deletion and Updation operation on Database(.mdf).You can easily deploy your ASP.NET Application on any system without any problem.If you are facing any Type of   problem to Add .mdf Database then Read .

• Solve problem Add .mdf Database in ASP.NET

There are some steps to Add SQL Database (.mdf) in ASP.NET Website. Which are given below:

Step1:- First open your visual studio 2010-> go File-> click New Website->Select ASP.NET Empty website->click OK.

Go Solution Explorer->Add New web form(Default.aspx)-->Drag and drop some controls as shown below :-

see it:- 

 

Step2:- Now open Solution Explorer-> Right mouse click on website(Application) which is as shown below:- See it:-

Now Select SQL Server Database->click Add button ,which is shown below:- see it:-

Step3:- Now Double click on Database.mdf File in Solution Explorer->Now Right click on Tables Click Add New Table->Now Write required column Name-> Click save button ->Write the table NAME-> Click OK. which is as shown below :- see it:-
Step4:-  Now Double click on Submit Button -> Write the following code for Database connectivity which are given below:-

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34

using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using System.Data.SqlClient; public partial class _Default : System.Web.UI.Page {     protected void Page_Load(object sender, EventArgs e)     {     }     protected void Button1_Click(object sender, EventArgs e)     {         SqlConnection con = new SqlConnection(@"Data Source=RAMASHANKER-PC;AttachDbFilename=|DataDirectory|\Database.mdf;Integrated Security=True;User Instance=True;");     con.Open();     String str = "INSERT INTO login (username,password) VALUES ('" + TextBox1.Text + "','" + TextBox2.Text + "')";     SqlCommand cmd = new SqlCommand(str, con);     int OBJ = Convert.ToInt32(cmd.ExecuteNonQuery());     if (OBJ > 0)     {         Label3.Text = "Data is successfully inserted in database";     }     else     {         Label3.Text = "Data is not inserted in database";      }     con.Close();     } }

see it:-
Step5:-  Run the Application(Press F5).Which are shown below:
Output:-
Step6:- Now you can see the inserted data in Database.
see it:-