我没有得到任何错误。但不能更新表中的数据 [英] i dont get any error.but cant update data in table

问题描述

MY ROW更新代码如下





protected void GridView1_RowUpdating（object sender，GridViewUpdateEventArgs e）

{

TextBox txtname =（TextBox）GridView1.Rows [e.RowIndex] .FindControl（textbox7）;

TextBox txtcity = （TextBox）GridView1.Rows [e.RowIndex] .FindControl（textbox8）;

TextBox txtstate =（TextBox）GridView1.Rows [e.RowIndex] .FindControl（textbox9）;

TextBox txtbirthdate =（TextBox）GridView1.Rows [e.RowIndex] .FindControl（textbox10）;

TextBox txteducation =（TextBox）GridView1.Rows [e.RowIndex ] .FindControl（textbox11）;

TextBox txtaddress =（TextBox）GridView1.Rows [e.RowIndex] .FindControl（textbox12）;

TextBox txthobby = （TextBox）GridView1.Rows [e.RowIndex] .FindControl（textbox13）;

RadioButtonList rgender =（RadioButtonList）GridView1.Rows [e.RowIndex] .FindControl（radiobuttonlist2） ;

prop.name = txtname.Text;

prop.city = txtcity.Text;

prop.state = txtstate.Text;

prop.birthdate = txtbirthdate.Text;

prop.education = txteducation.Text;

prop.address = txtaddress.Text;

prop.gender = rgender.Text;

prop.hobby = txthobby.Text;

data.update（prop）;

GridView1.EditIndex = -1;

fillgrid（）;

}

protected void GridView1_RowCancelingEdit（object sender，GridViewCancelEditEventArgs e）

{

GridView1.EditIndex = -1;

fillgrid（）;

}

}





更新存储过程

MY ROW UPDATING CODE IS BELOW


protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
TextBox txtname = (TextBox)GridView1.Rows[e.RowIndex].FindControl("textbox7");
TextBox txtcity = (TextBox)GridView1.Rows[e.RowIndex].FindControl("textbox8");
TextBox txtstate = (TextBox)GridView1.Rows[e.RowIndex].FindControl("textbox9");
TextBox txtbirthdate = (TextBox)GridView1.Rows[e.RowIndex].FindControl("textbox10");
TextBox txteducation = (TextBox)GridView1.Rows[e.RowIndex].FindControl("textbox11");
TextBox txtaddress = (TextBox)GridView1.Rows[e.RowIndex].FindControl("textbox12");
TextBox txthobby = (TextBox)GridView1.Rows[e.RowIndex].FindControl("textbox13");
RadioButtonList rgender = (RadioButtonList)GridView1.Rows[e.RowIndex].FindControl("radiobuttonlist2");
prop.name = txtname.Text;
prop.city = txtcity.Text;
prop.state = txtstate.Text;
prop.birthdate = txtbirthdate.Text;
prop.education = txteducation.Text;
prop.address = txtaddress.Text;
prop.gender = rgender.Text;
prop.hobby = txthobby.Text;
data.update(prop);
GridView1.EditIndex = -1;
fillgrid();
}
protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
{
GridView1.EditIndex = -1;
fillgrid();
}
}


update stored procedure

ALTER PROCEDURE dbo.updatedata

	
	@id int,
	 @name varchar(50),
	@city varchar(50),
	@state varchar(50),
	@birthdate varchar(50),
	@education varchar(50),
	@address varchar(50),
	@gender varchar(50),
	@hobby varchar(50)


AS
	update info set name=@name,city=@city,state=@state,birthdate=@birthdate,education=@education,address=@address,gender=@gender,hobby=@hobby where id=@id
	RETURN

添加的代码块 - OriginalGriff [/ edit]

[edit]Code blocks added - OriginalGriff[/edit]

推荐答案

你需要在sp中传递一些独特的东西。你想要更新特定行的地方

如'ID'

You need to pass something unique in sp. where you want to update particular row
like 'ID'

这篇关于我没有得到任何错误。但不能更新表中的数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！