如何更新gridview的状态值? [英] How to update status value in gridview?
问题描述
在我的数据库我有表tblstatus和tblemployeereimbursmenttable。
在这里的地位都是这种格式
1与职工结果待定
2经理待定结果
3通过管理器发送回结果
4财务结果待定
5发送回财务结果
6帐户头结果待定
7发送回来的帐户头结果
8批准
块引用>和给定的PK和FK两个表的关系
在这里,当按钮在GridView控件比状态更新点击为2。如果(会话[statusID] == 1)
{
使用(SqlConnection的CON =新的SqlConnection(的ConnectionString))//设置的ConnectionString
{
使用(CMD的SqlCommand =新的SqlCommand(从表更新设置statusID = 2,其中expenesesid = @ expensesid,CON))//设置适当的查询
{
sqldatadapter DA =新sqldatadapter(CMD);
con.Open();
cmd.ExecuteNonQuery();
}
}
}但它显示的错误任何一个可以帮助我,请....
解决方案您需要转换会话数据:
存储在会话中的项目的类型为对象;你总是需要
它转换为实际的类型,当你找回它。
块引用>INT statusID = 0;如果(会话[statusID] = NULL&放大器;!&安培; int.TryParse(会话[statusID]的ToString(),出statusID)及&安培; statusID == 1)
{
使用(SqlConnection的CON =新的SqlConnection(的ConnectionString))//设置的ConnectionString
{
使用(CMD的SqlCommand =新的SqlCommand(更新tblstatus设置statusID = 2,其中expenesesid = @ expensesid,CON))//设置适当的查询
{
sqldatadapter DA =新sqldatadapter(CMD);
con.Open();
cmd.ExecuteNonQuery();
}
}
}In my database i had table with "tblstatus" and "tblemployeereimbursmenttable".
here status are in this format
1 Pending with employee
2 Pending with Manager
3 Send back by Manager
4 Pending with Finance
5 Send back by Finance
6 Pending with Account head
7 Send back by Account head
8 ApprovedAnd Given PK and FK relationship to two tables Here when the button clicked than status update to 2 in gridview.
if(Session["statusID"] == 1) { using(SqlConnection con = new SqlConnection(ConnectionString))// set ConnectionString { using(SqlCommand cmd = new SqlCommand("update from table set statusID=2 where expenesesid=@expensesid",con)) // set appropriate query { sqldatadapter da=new sqldatadapter(cmd) ; con.Open(); cmd.ExecuteNonQuery(); } } }
But it's showing error can any one help me please....
解决方案You need to cast session data:
the type of an item stored in the session is Object; you always need to cast it to its actual type when you retrieve it.
int statusID =0; if(Session["statusID"] != null && int.TryParse(Session["statusID"].ToString(), out statusID) && statusID ==1) { using(SqlConnection con = new SqlConnection(ConnectionString))// set ConnectionString { using(SqlCommand cmd = new SqlCommand("update tblstatus set statusID=2 where expenesesid=@expensesid",con)) // set appropriate query { sqldatadapter da=new sqldatadapter(cmd) ; con.Open(); cmd.ExecuteNonQuery(); } } }
这篇关于如何更新gridview的状态值?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!