There are some connection strings in asp.net for database connectivity.There are mainly two architecture are used in ADO.NET for database connectivity in asp.net application.
Step 2:-Now open your Sql server Database -->create a students table and a stored procedure prcinsert as shown below:-
If we add .mdf file(database) in asp.net application(website) or create table in sql server database then we can use different connection strings for database connectivity.I have seen many students face problem in database connectivity in asp.net application. that's why i am going to explain database connectivity in asp.net application.In this tutorial i am going to insert some values in table with help of different-different connection strings.You can use any of one connection strings to perform the insertion,deletion and updation operations in database.It is very easy concept.If you understand this whole concept which i have explained below then you never face any type of connectivity problem in database in future.
In below application i have performed only insertion operation with the help of different connection strings.In this application i have used six different connection strings(only four main strings) which are given below.
There are some steps to implement this whole concepts which are given below:-
Step 1:-First open your visual studio -->File -->New -->Website -->Select ASP.NET Empty website --> OK-->Drag and Drop Text Box,Label ,Button ,SqlDataSource and two Gridview controls as shown below.
Step 3:-Now Double click on page (or press F7) -->Write the below codes on page load as given below:-
using System;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Configuration;
using System.Data;
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
//----------------------------------Conneted architecture codes------------------------------------------------
//SqlConnection con = new SqlConnection("data source=DIAMOND-PC;Integrated Security=Yes;Database=master");
//con.Open();
//SqlCommand cmd = new SqlCommand("select*from students",con);
//SqlDataReader dr = cmd.ExecuteReader();
//DataTable dt =new DataTable();
//DataColumn dcname=new DataColumn("name",typeof(String));
//DataColumn dcage=new DataColumn("age",typeof(int));
//DataColumn dcloc=new DataColumn("location",typeof(String));
//dt.Columns.Add(dcname);
//dt.Columns.Add(dcage);
//dt.Columns.Add(dcloc);
//while (dr.Read())
//{
// dt.Rows.Add(dr[0], dr[1], dr[2]);
//}
//GridView1.DataSource = dt;
//GridView1.DataBind();
//con.Close();
//----------------------------------Disconneted architecture codes------------------------------------------------
SqlConnection con = new SqlConnection("data source=DIAMOND-PC;Integrated Security=Yes;Database=master");
con.Open();
SqlDataAdapter da =new SqlDataAdapter("select*from students", con);
DataSet ds = new DataSet();
da.Fill(ds);
GridView1.DataSource = ds;
GridView1.DataBind();
}
Description :- Here i have used connected and Disconnected architecture for Binding the table ( students) data in Gridview1 control.You can use any of one connection.
Step 4:- Now Double click on submit 1 ,submit 2 ,submit 3 button -->write the following codes as given below.
protected void Button1_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection("data source=DIAMOND-PC;Integrated Security=Yes;Database=master");
con.Open();
SqlCommand cmd = new SqlCommand("insert into students values(@a,@b,@c)",con);
cmd.Parameters.AddWithValue("a", txtname.Text);
cmd.Parameters.AddWithValue("b", textage.Text);
cmd.Parameters.AddWithValue("c", txtloc.Text);
int i = cmd.ExecuteNonQuery();
if (i > 0)
{
Label1.Text = "Data inserted successfully";
}
}
protected void Button2_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection("data source=DIAMOND-PC;Integrated Security=Yes;Database=master");
con.Open();
SqlCommand cmd = new SqlCommand("insert into students values('" + txtname.Text + "','" + textage.Text + "','" + txtloc.Text + "')", con);
int i = cmd.ExecuteNonQuery();
if (i > 0)
{
Label1.Text = "Data inserted successfully";
}
}
protected void Button3_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection("data source=DIAMOND-PC;Integrated Security=Yes;Database=master");
con.Open();
SqlCommand cmd = new SqlCommand("prcinsert",con);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("name", txtname.Text);
cmd.Parameters.AddWithValue("age", textage.Text);
cmd.Parameters.AddWithValue("location", txtloc.Text);
int i = cmd.ExecuteNonQuery();
if (i > 0)
{
Label1.Text = "Data inserted successfully";
}
}
Step 5:- Now open your Solution Explorer -->Add Database.mdf file on your application-->create a student 1 table as shown below:-
Step 6:- Now configure your sql server Database and follow the Next -->Next-->Test Query -->Finish as shown below:-
Step 7:- Now Double click on submit 4 ,submit 5 ,submit 6 button -->write the following codes as given below:-
protected void Button4_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection(@"Data Source=.\;AttachDbFilename=|DataDirectory|\Database.mdf;Integrated Security=True;User Instance=True;");
con.Open();
SqlCommand cmd = new SqlCommand("insert into student1 values(@a,@b,@c)", con);
cmd.Parameters.AddWithValue("a", txtname.Text);
cmd.Parameters.AddWithValue("b", textage.Text);
cmd.Parameters.AddWithValue("c", txtloc.Text);
int i = cmd.ExecuteNonQuery();
if (i > 0)
{
Label1.Text = "Data inserted successfully";
}
}
protected void Button5_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
con.Open();
SqlCommand cmd = new SqlCommand("insert into student1 values(@a,@b,@c)", con);
cmd.Parameters.AddWithValue("a", txtname.Text);
cmd.Parameters.AddWithValue("b", textage.Text);
cmd.Parameters.AddWithValue("c", txtloc.Text);
int i = cmd.ExecuteNonQuery();
if (i > 0)
{
Label1.Text = "Data inserted successfully";
}
}
protected void Button6_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
con.Open();
SqlCommand cmd = new SqlCommand("insert into student1 values('" + txtname.Text + "','" + textage.Text + "','" + txtloc.Text + "')", con);
int i = cmd.ExecuteNonQuery();
if (i > 0)
{
Label1.Text = "Data inserted successfully";
}
}
Step 8:-Now Run the Application (press F5) --> Enter Text Box values (name,age,location) --> press any of one Submit button --> Data will be inserted in table successfully as shown below:-
Description :- In this application i have performed only insert operation in database.You can perform delete and Update operations also in database.
- When you click Submit 1 ,Submit 2 and Submit 3 button then data will be inserted in students table which is already created in sql server Database.
- When you click Submit 3 ,Submit 4 and Submit 5 button then data will be inserted in student 1 table which is already created in this website (.mdf).
- Page load code is used when you want to display the table (students or student 1) data in Gridview control.
- If you want to display the Database.mdf file's table data then you will have to bind the table data in Gridview control by configuring the SqlDataSource.
- For Real knowledge of insertion ,deletion and updation follow Data List control
- Create dll file for asp.net application
- Data set and Data Adapter in ado.net
- Create Data set and Data Adapter using Menu
- Abstract class and abstract method
- Make xml Document at RunTime
- Page Directives and page properties in asp.net
- Display the XML data in Gridview control
- Properties in c#
- Structure and classes in c#
- Generate Unique Number in asp.net application
To Get the Latest Free Updates Subscribe
Download whole Attached file From below
Download
0 comments:
Post a Comment