Question

关于GridView的数据更新

protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
SqlConnection conn = new SqlConnection("server=.;database=Graduation Design;uid=sa;pwd=sa");
string givejobID = GridView1.DataKeys[e.RowIndex].Value.ToString();
string partner = ((TextBox)(GridView1.Rows[e.RowIndex].Cells[2].Controls[0])).Text.ToString();
string jobdirection = ((TextBox)(GridView1.Rows[e.RowIndex].Cells[3].Controls[0])).Text.ToString();
string province = ((TextBox)(GridView1.Rows[e.RowIndex].Cells[4].Controls[0])).Text.ToString();
string city = ((TextBox)(GridView1.Rows[e.RowIndex].Cells[5].Controls[0])).Text.ToString();
string number = ((TextBox)(GridView1.Rows[e.RowIndex].Cells[6].Controls[0])).Text.ToString();
string sex = ((TextBox)(GridView1.Rows[e.RowIndex].Cells[7].Controls[0])).Text.ToString();
string agemin = ((TextBox)(GridView1.Rows[e.RowIndex].Cells[8].Controls[0])).Text.ToString();
string agemax = ((TextBox)(GridView1.Rows[e.RowIndex].Cells[9].Controls[0])).Text.ToString();
string qualification = ((TextBox)(GridView1.Rows[e.RowIndex].Cells[10].Controls[0])).Text.ToString();
string foreignlanguage = ((TextBox)(GridView1.Rows[e.RowIndex].Cells[11].Controls[0])).Text.ToString();
string fllevel = ((TextBox)(GridView1.Rows[e.RowIndex].Cells[12].Controls[0])).Text.ToString();
string jexperience = ((TextBox)(GridView1.Rows[e.RowIndex].Cells[13].Controls[0])).Text.ToString();
string wage = ((TextBox)(GridView1.Rows[e.RowIndex].Cells[14].Controls[0])).Text.ToString();
string validity = ((TextBox)(GridView1.Rows[e.RowIndex].Cells[15].Controls[0])).Text.ToString();
string request = ((TextBox)(GridView1.Rows[e.RowIndex].Cells[16].Controls[0])).Text.ToString();
string mystr = "update givejob set partner='"+partner+"',jobdirection='"+jobdirection+"',province='"+province+"',city='"+
city+"',number='"+number+"',sex='"+sex+"',agemin='"+agemin+"',agemax='"+agemax+"',qualification='"+qualification+"',foreignlanguage='"+
foreignlanguage+"',fllevel='"+fllevel+"',jexperience='"+jexperience+"',wage='"+wage+"',validity='"+
validity+"',request='"+request+"' where givejobID="+givejobID;
conn.Open();
SqlCommand cmd = new SqlCommand(mystr, conn);
cmd.ExecuteNonQuery();
cmd.Dispose();
conn.Close();
GridView1.EditIndex = -1;
bind();
}

出错的地方是：cmd.ExecuteNonQuery();
出错提示为：将数据类型 varchar 转换为 numeric 时出错。
应该怎么改啊？可以加分！

Answer 1

要看你数据库givejob表里字段的类型才知道了
应该是你数据库里面有字段是numeric类型而参数mystr中传的全部是string
你看看书哪个字段嘛
其实设计数据库 没必要用numeric吧？
用float啊double啊都可以了嘛
把参数类型转换为数据库中对应类型就可以了