Insert, Update and Delete_Query

-

INSERT-

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 Registration : System.Web.UI.Page

{   SqlConnection cn;

    SqlCommand cm;

    SqlDataReader dr;


    protected void Page_Load(object sender, EventArgs e)

   { 

   }

    protected void Button1_Click(object sender, EventArgs e)

 { //step 1- connection to database

 string path =@"Data Source=49.50.88.43;Initial Catalog=grkistdb;Persist Security Info=True;User ID=grkistuser;Password=q2oR5w_356";

     cn = new SqlConnection(path);

     cn.Open();


//step 2- Command (write a query)

        string q = " insert into Chitransh_stu values ('"+TextBox1.Text+"', '"+TextBox2.Text+"', '"+TextBox3.Text+"', )" 

cm = new SqlCommand(q, cn);


//step 3- execute the query 

cm.ExecuteNonQuery();

}

}


UPDATE-

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 Registration : System.Web.UI.Page

{   SqlConnection cn;

    SqlCommand cm;

    SqlDataReader dr;


    protected void Page_Load(object sender, EventArgs e)

   { 

   }

    protected void Button1_Click(object sender, EventArgs e)

 { //step 1- connection to database

 string path =@"Data Source=49.50.88.43;Initial Catalog=grkistdb;Persist Security Info=True;User ID=grkistuser;Password=q2oR5w_356";

     cn = new SqlConnection(path);

     cn.Open();


//step 2- Command (write a query)

        string q = " update from Chitransh_stu set column_name='"+control_name.Text+"' where id='"+control_name.Text+"'" 

cm = new SqlCommand(q, cn);


//step 3- execute the query 

cm.ExecuteNonQuery();

}

}


How update query executes-  

 " update from Table_name set 

column_name='"+control_name.Text+"' where 

id='"+control_name.Text+"'" 

Column_name- here we give the columns those we want to update.

Control_name- the control data is supplied to data base like textbox.

Where condition- here we give the reference to update the particular row / record like roll no, id etc.

 It is execute non query.

DELETE- 

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 Registration : System.Web.UI.Page

{   SqlConnection cn;

    SqlCommand cm;

    SqlDataReader dr;


    protected void Page_Load(object sender, EventArgs e)

   { 

   }

    protected void Button1_Click(object sender, EventArgs e)

 { //step 1- connection to database

 string path =@"Data Source=49.50.88.43;Initial Catalog=grkistdb;Persist Security Info=True;User ID=grkistuser;Password=q2oR5w_356";

     cn = new SqlConnection(path);

     cn.Open();


//step 2- Command (write a query)

        string q = " delete from Chitransh_stu "' where id='"+control_name.Text+"'" 

cm = new SqlCommand(q, cn);


//step 3- execute the query 

cm.ExecuteNonQuery();

}

}

How it works- 

delete query is used to delete the entire row with reference to any column using where condition or the entire table.

It is also execute non query.

Comments

Post a Comment

Popular posts from this blog

Parameter Query

-
If we pass the value with (, ' " ! $) symbols in the control that will not be accepted through normal query. Parameter Query is used to accept the value with special symbols in the control like textbox. Parameter Query use a user defined variable with an @ sign.  In Parameter Query control is written in a different syntax. Column name and variable name can not be the same. Without column_name we can not perform Parameter query. Syntax- Insert- string s= "insert into Table_name (Column_name) values (@variable_name)"; cm = new SqlCommand(s,cn); cm.Parameters.AddWithValue("variable_name", control_name); cm.ExecuteNonQuery(); Update- string q = "update Proc_table set name=@name1 where email = @email1"; cm = new SqlCommand(q, cn); cm.Parameters.AddWithValue("name1", TextBox1.Text); cm.Parameters.AddWithValue("email1", TextBox2.Text); cm.ExecuteNonQuery();  
Read more

Final Project

-
Image
Registration form project   CODING- 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; using System.Configuration; public partial class RegPage : System.Web.UI.Page {     SqlConnection cn;     SqlCommand cm;     SqlDataReader dr;     FinalClass fc = new FinalClass();     protected void Page_Load(object sender, EventArgs e)     {         if (!IsPostBack)         {             statedisplay();         }     }     protected void connect()     {         string s = ConfigurationManager.AppSettings["Ch_Db"];         cn = new SqlConnection(s);         cn.Open();          }     protected void statedisplay...
Read more

Grid View Paging

-
  Grid View paging- Grid view paging is used when we have to read the data in bulk then we divide the complete data records into pages consists 10 records in one page. SqlDataAdapter - It is used for Grid View Paging Data Adapter reads data in group of 10 records unlike DataReader which reads the data line by line. DataSet - DataSet Object is created, it accepts the data in bulk. Fill() - Fill() is used. CODE - protected void display() { //Connection Code string s = ConfigurationManager.AppSettings["db"]; cn = new SqlConnection(s); cn.Open(); //DataSet Object DataSet ds = new DataSet(); string s = "select * from Videodb"; //SqlDataAdapter object SqlDataReader adp = new SqlDataAdapter(); adp.Fill(ds); GridView1.DataSoruce = ds; GridView1.DataBind(); } Source code-   <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"              Height="589px" Width="483px" OnPageIndexChanging="click...
Read more