Basic Query program(insert,update,delete,select)

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

{

    SqlConnection cn;

    SqlCommand cm;

    SqlDataReader dr;

    protected void Page_Load(object sender, EventArgs e)

    {

        if(!IsPostBack)

        {

        }

    }

    protected void Button1_Click(object sender, EventArgs e)

    {

        string k = @"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\college.mdf;Integrated Security=True;User Instance=True";

        cn = new SqlConnection(k);

        cn.Open();


        string k1="insert into student values('"+TextBox1.Text+"', '"+TextBox2.Text+"', '"+TextBox3.Text+"','"+TextBox4.Text+"')";

       cm = new SqlCommand(k1,cn); 

       cm.ExecuteNonQuery();

       TextBox1.Text = "";

       TextBox2.Text = "";

       TextBox3.Text = "";

       TextBox4.Text = "";

       Response.Write("record save successfully");  

    

    }

    protected void Button2_Click(object sender, EventArgs e)

    {

        string k = @"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\college.mdf;Integrated Security=True;User Instance=True";

        cn = new SqlConnection(k);

        cn.Open();


        string k3 = "update student SET city='"+TextBox1.Text+"'  where roll='"+TextBox3.Text+"' ";

        cm = new SqlCommand(k3, cn);

        cm.ExecuteNonQuery();

        TextBox1.Text = "";

        TextBox2.Text = "";

        TextBox3.Text = "";

        TextBox4.Text = "";

        Response.Write("update successfully");



    }

    protected void Button3_Click(object sender, EventArgs e)

    {

        string k = @"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\college.mdf;Integrated Security=True;User Instance=True";

        cn = new SqlConnection(k);

        cn.Open();


        string k3 = "delete from student where name= '" + TextBox2.Text + "' ";

        cm = new SqlCommand(k3, cn);

        cm.ExecuteNonQuery();

        TextBox1.Text = "";

        TextBox2.Text = "";

        TextBox3.Text = "";

        TextBox4.Text = "";

        Response.Write("deleted");


    }

    protected void Button4_Click(object sender, EventArgs e)

    {

        string k = @"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\college.mdf;Integrated Security=True;User Instance=True";

        cn = new SqlConnection(k);

        cn.Open();


        string k4 = "select * from student";

        cm = new SqlCommand(k4, cn);

        TextBox1.Text = "";

        TextBox2.Text = "";

        TextBox3.Text = "";

        TextBox4.Text = "";

        Response.Write("done");



    }

}

Comments

Post a Comment

Popular posts from this blog

Data transmission and query string

Data Transmission State management  session expire  query string  view state  cokkies application state session  1. Secure data transfermation  2. 60 sec of default time  3. how to create session      syntax            session["variable"]=control;           session["email"]=textbox1.text;    session is to be access in all website.  Q.how to access session?     All types of session is to be access inside the page load event  Query String 1. Query string is used to transfer data with URL 2. Query string does not use secure data tranfermation  3. Query string variable represent que mark.      Syntax Response.redirect("page.aspx?variable="+control); control=request.querystring["variable"]; Query string is to be acess in page load event   *Multiple variable in query string      (&)mpercent
Read more

Detailview(program)

 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 Dview1 : System.Web.UI.Page {     SqlConnection cn;     SqlCommand cm;     SqlDataReader dr;     protected void Page_Load(object sender, EventArgs e)     {         if (!IsPostBack)         {         }     }     protected void Button1_Click(object sender, EventArgs e)     {         string k = @"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\college.mdf;Integrated Security=True;User Instance=True";         cn = new SqlConnection(k);         cn.Open();         string k1 = "select * from student";         cm = new SqlCommand(k1, cn);     ...
Read more