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);

        dr = cm.ExecuteReader();

        DetailsView1.DataSource = dr;

        DetailsView1.DataBind();

        dr.Close();

    }

    protected void detailcommand(object sender, DetailsViewCommandEventArgs e)

    {

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

        cn = new SqlConnection(k);

        cn.Open();

        if (e.CommandName == "viewdata")

        {

            TextBox t1 = (TextBox)DetailsView1.FindControl("TextBox1");

            //Response.Write(t1.Text); 

            //Response.Write(DetailsView1.Rows[0].Cells[1].Text);

            string k2= "update student set name=@name1 where roll=@roll1";

            cm = new SqlCommand(k2, cn);

            cm.Parameters.AddWithValue("name1", t1.Text);

            cm.Parameters.AddWithValue("roll1", DetailsView1.Rows[0].Cells[1].Text);

            cm.ExecuteNonQuery();

        }

    }

}

• 2nd example

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);

        dr = cm.ExecuteReader();

        DetailsView1.DataSource = dr;

        DetailsView1.DataBind();

        dr.Close();