This is only for edit
ALTER procedure [dbo].[editstudent] @sid int, @firstname varchar(50),@lastname varchar(50),@gender varchar(50),@address varchar(50),@phone varchar(50),@dob datetime,@email varchar(50)
as
update student set firstname=@firstname, lastname=@lastname, gender=@gender, address=@address, phone=@phone, dob=@dob, email=@email where sid=@sid
*************************************************
this is only for selection
create procedure [dbo].[selectstudent]
@sid int
begin
select firstname,lastname,gender,address,phone,dob,email from student where
sid=@sid
end
and aspx.cs page for that link button look like.....
protected void linkedit_Click(object sender, EventArgs e)
{
LinkButton lnkButton = sender as LinkButton;
GridViewRow row = (GridViewRow)lnkButton.NamingContainer;
txtsid.Text = row.Cells[2].Text;
SqlCommand cm = new SqlCommand("selectstudent", cn);
cm.CommandType = CommandType.StoredProcedure;
cm.Parameters.Add("@sid", SqlDbType.Int).Value = Convert.Int32(txtsid.Text.ToString());
cn.Open();
SqlDataReader dr = cm.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
txtfirstname.Text = dr["Firstname"].ToString();
txtlastname.Text = dr["Lastname"].ToString();
txtgender.Text = dr["Gender"].ToString();
txtaddress.Text = dr["Address"].ToString();
txtphone.Text = dr["Phone"].ToString();
txtdob.Text = dr["Dob"].ToString();
txtemail.Text = dr["Email"].ToString();
}
dr.Close();
SqlCommand cmd = new SqlCommand("editstudent", cn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@sid", SqlDbType.Int).Value = Convert.Int32(txtsid.Text.ToString());
cmd.Parameters.Add("@firstname", SqlDbType.Varchar).Value = txtfirstname.Text;
cmd.Parameters.Add("@lastname", SqlDbType.Varchar).Value = txtlastname.Text;
cmd.Parameters.Add("@gender", SqlDbType.Varchar).Value = txtgender.Text;
cmd.Parameters.Add("@address", SqlDbType.Varchar).Value = txtaddress.Text;
cmd.Parameters.Add("@phone", SqlDbType.Varchar).Value = txtphone.Text;
cmd.Parameters.Add("@dob", SqlDbType.DaeTime).Value = txtdob.Text;
cmd.Parameters.Add("@email", SqlDbType.Varchar).Value = txtemail.Text;
cmd.ExecutNonQuery()
cn.Close();
fillgrid();
}
else
{
Response.Write("there is no data to edit");
}
}
Hopefully It will help to understand using stored procedure.