protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
SqlConnection conn = new SqlConnection();
//设置数据库连接字符串属性值
conn.ConnectionString = @"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\MyDatabase.mdf;Integrated Security=True;User Instance=True";
string drugKey = GridView1.DataKeys[e.RowIndex].Value.ToString();
////取得文本框中的输入内容
string drugID = ((TextBox)(GridView1.Rows[e.RowIndex].Cells[1].Controls[0])).Text.ToString().Trim();
string drugName = ((TextBox)(GridView1.Rows[e.RowIndex].Cells[2].Controls[0])).Text.ToString().Trim();
string drugType = ((TextBox)(GridView1.Rows[e.RowIndex].Cells[3].Controls[0])).Text.ToString().Trim();
string drugBuyPrice = ((TextBox)(GridView1.Rows[e.RowIndex].Cells[4].Controls[0])).Text.ToString().Trim();
string drugCompany = ((TextBox)(GridView1.Rows[e.RowIndex].Cells[5].Controls[0])).Text.ToString().Trim();
string drugFactory = ((TextBox)(GridView1.Rows[e.RowIndex].Cells[6].Controls[0])).Text.ToString().Trim();
string drugBuyCount = ((TextBox)(GridView1.Rows[e.RowIndex].Cells[7].Controls[0])).Text.ToString().Trim();
string drugBuyData = ((TextBox)(GridView1.Rows[e.RowIndex].Cells[8].Controls[0])).Text.ToString().Trim();
string sqlStr = "update BuyTable set DrugID='" + drugID + "',DrugName='" + drugName + "',DrugType='" + drugBuyPrice + "',DrugCompany='" + drugCompany + "',DrugFactory='" + drugFactory + "',DrugBuyCount='" + drugBuyCount + "',DrugBuyData='" + drugBuyData + "' where ID='" + drugKey + "'";
SqlCommand comm = new SqlCommand("sqlStr",conn);
conn.Open();
comm.ExecuteNonQuery();
GridView1.EditIndex = -1;
conn.Close();
BindGrid();
}
下面是我的数据库表
GRIDVIEW中编辑更新的时候总是提示索引超出范围。必须为非负值并小于集合大小
答案:2 悬赏:60
解决时间 2021-03-03 07:00
- 提问者网友:恋你成殇
- 2021-03-02 12:45
最佳答案
- 二级知识专家网友:陪我到地狱流浪
- 2021-03-02 13:38
在Gridview中第一列是ID还是drugID?如果是drugID的话,你后面的索引应该是从0开始而不是从1开始,如果不是,那么仔细检查你的Gridview列种是否有漏的情况
全部回答
- 1楼网友:野性且迷人
- 2021-03-02 15:06
string did = ((label)(this.gridview1.rows[e.rowindex].cells[0].controls[0])).text.tostring();
controls[0]是第一个控件
我要举报
如以上问答内容为低俗、色情、不良、暴力、侵权、涉及违法等信息,可以点下面链接进行举报!
大家都在看
推荐资讯