i can'n perform record update using RowUpdating in gridview?

Dhimesh Parmar

8y856Learn iOS Programming

protected void gridStud_RowUpdating(object sender, GridViewUpdateEventArgs e)

{

LinkButton btn = (LinkButton)gridStud.Rows[e.RowIndex].FindControl("linkUpdate");

int studentId = Convert.ToInt32(gridStud.DataKeys[e.RowIndex].Value.ToString());

TextBox txtStudName = (TextBox)gridStud.Rows[e.RowIndex].FindControl("txtStud");

RadioButton rd1 = (RadioButton)gridStud.Rows[e.RowIndex].FindControl("RadioButton3");

RadioButton rd2 = (RadioButton)gridStud.Rows[e.RowIndex].FindControl("RadioButton4");

TextBox txtBirthdate = (TextBox)gridStud.Rows[e.RowIndex].FindControl("txtDate");

TextBox txtEmail = (TextBox)gridStud.Rows[e.RowIndex].FindControl("txtEmail");

TextBox txtMobile = (TextBox)gridStud.Rows[e.RowIndex].FindControl("txtmob");

studentCommon c = new studentCommon();

SqlCommand cmd = new SqlCommand("studIUD");

cmd.CommandType = CommandType.StoredProcedure;

cmd.Parameters.AddWithValue("StatementType", "UPDATE");

// cmd.Parameters.AddWithValue("studentId", studentId);

cmd.Parameters.AddWithValue("name", txtStudName);

if (rd1.Checked)

{

cmd.Parameters.AddWithValue("gender", "Male");

}

else

{

cmd.Parameters.AddWithValue("gender", "Female");

}

cmd.Parameters.AddWithValue("brithDate", txtBirthdate);

cmd.Parameters.AddWithValue("emailid", txtEmail);

cmd.Parameters.AddWithValue("mobilenumber", txtMobile);

c.ExecuteNonQueryByCommand(cmd);

gridStud.EditIndex = -1;

gridStud.DataBind();

}

8 Replies

Know the answer? Post it — somebody with the same question will find it here.

Dhimesh Parmar8y ago
It's Working Thank You Rajneesh Sir
Rajneesh Chaubey8y ago
Do this:
if (rd1.Checked)
       {
           gender = "Male"; //do this in you row updating event

       }
       else
       {

           gender = "Female";

       }
Dhimesh Parmar8y ago
Rajneesh sir update time radiobutton data in not display in grid view
Rajneesh Chaubey8y ago
Hi @Dhimesh,

I am attaching your project it is properly working.

Some of changes you have to do:

1.You have given inappropriate procedure name while inserting.
CREATE PROCEDURE studentIUD

(

@StatementType nvarchar(255)='',

@studentId int,

@name varchar(30),

@gender varchar(6),

@brithDate date,

@emailid varchar(50),

@mobilenumber varchar(10),

@status int,

@createOn datetime,

@modifyOn datetime

)

as

begin

if @StatementType ='INSERT'

begin

INSERT into stud (name,gender,brithDate,emailid,mobilenumber,status,createOn,modifyOn) values (@name,@gender,@brithDate,@emailid,@mobilenumber,@status,@createOn,@modifyOn)

end

else if @StatementType ='SELECT'

begin

SELECT * FROM STUD

end

else if @StatementType ='UPDATE'

begin

UPDATE stud set name=@name ,gender=@gender,brithDate=@brithDate, emailid=@emailid,mobilenumber=@mobilenumber,createOn=@createOn,modifyOn=@modifyOn where studentId=@studentId

end

else if @StatementType ='DELETE'

begin

DELETE stud where studentId=@studentId

end

end
2.While updating you have just declaring entities of class but not assigning values to them.

and hence it is going empty in stored procedure.

Everything else is fine. I am attaching code it is properly working.

Hope you get it.

If it is helpful to you then accept this as your answer.

Thanks.
Dhimesh Parmar8y ago
Rajneesh sir
file atteched therer
db store as a sctipt.txt and tablecode.txt
Rajneesh Chaubey8y ago
Hi Dhimesh, Can you share your full code along with database??
So that we'll get to know where you are stucking and what are those errors??
Laxmidhar Sahoo8y ago
Actual the value that pass will be like txtBirthday.text
Laxmidhar Sahoo8y ago
Cmd.add with parameter('@sqlparametername',txtdate.text);