How to create connection Ado.net and SqlServer 2008

Question

I want to create connection to insert data into database

Satyapriya Nayak · Answer

Untitled Page User Registration Form First Name: Last Name: Username: Password: Address: onclick=btnSubmit_Click />   Text=Reset onclick=btnReset_Click /> using System; using System.Collections; using System.Configuration; using System.Data; using System.Linq; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.HtmlControls; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Xml.Linq; using System.Data.SqlClient; namespace Login_and_signup { public partial class Registration : System.Web.UI.Page { protected void btnSubmit_Click(object sender EventArgs e) { string connStr = ConfigurationManager.ConnectionStrings[ConnectionString].ConnectionString; SqlConnection sqlConnection = new SqlConnection(connStr); //sqlConnection.ConnectionString = @Data Source=SS438\SQLEXPRESS;Initial Catalog=Examples;Integrated Security=true;; sqlConnection.Open(); string sqlQuery = INSERT INTO Users(FirstNameLastNameUserNamePasswordAddress) VALUES(@FirstName@LastName@UserName@Password@Address); SqlCommand sqlCommand = new SqlCommand(sqlQuery sqlConnection); sqlCommand.CommandType = CommandType.Text; sqlCommand.Parameters.Add(@FirstName SqlDbType.VarChar).Value = txtFirstName.Text.Trim(); sqlCommand.Parameters.Add(@LastName SqlDbType.VarChar).Value = txtLastName.Text.Trim(); sqlCommand.Parameters.Add(@UserName SqlDbType.VarChar).Value = txtUserName.Text.Trim(); sqlCommand.Parameters.Add(@Password SqlDbType.VarChar).Value = txtPassword.Text.Trim(); sqlCommand.Parameters.Add(@Address SqlDbType.VarChar).Value = txtAddress.Text.Trim(); int irows = sqlCommand.ExecuteNonQuery(); lblMessage.Text = User inserted successfully...; ClearFields(); } protected void btnReset_Click(object sender EventArgs e) { ClearFields(); } private void ClearFields() { txtFirstName.Text = ; txtLastName.Text = ; txtUserName.Text = ; txtPassword.Text = ; txtAddress.Text = ; } } }