string CPXBMC = e.Item.Cells[0].Text.ToString();
Textbox2.Text = CPXBMC;
String SQL = "Select * From HR_SQXLJY Where CSQRYBH = '" + Textbox2.Text + "'";
SqlConnection cnn = new SqlConnection("Data Source=BK02;Initial Catalog=pxfz;User Id=sa;Password=;" );
SqlCommand cmd = new SqlCommand(SQL, cnn);
cnn.Open();
SqlDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
if (dr.Read())
{ Textbox4.Text = dr["CXM"].ToString();
Textbox5.Text = dr["CXB"].ToString();
Textbox6.Text = dr["CXYWHCD"].ToString();
Textbox7.Text = dr["CNBXLCC"].ToString();
Textbox8.Text = dr["CXXXS"].ToString();
Textbox12.Text = dr["CYDTJ"].ToString();
Textbox13.Text = dr["CBMYJ"].ToString();
Textbox14.Text = dr["CRLZYBMYJ"].ToString();
TextBox3.Text = dr["CZT"].ToString();
}
dr.Close();
cnn.Open();
SqlCommand cma=new SqlCommand("delete from HR_SQXLJY_L",cnn);
cma.ExecuteNonQuery();
string SqlInsertStr1 = "INSERT INTO HR_SQXLJY_L (CSQRYBH, CXM, CXB, CXYWHCD, CNBXLCC, CXXXS, CYDTJ, CBMYJ, CRLZYBMYJ, CZT) "+" Values ('"+Textbox4.Text+"','"+Textbox4.Text+"','"+Textbox5.Text+"','"+Textbox6.Text+"','"+Textbox7.Text+"','"+Textbox8.Text+"','"+Textbox12.Text+"','"+Textbox13.Text+"','"+Textbox14.Text+"','"+TextBox3.Text+"')";
SqlCommand insert_cmd = new SqlCommand(SqlInsertStr1,cnn);
insert_cmd.CommandType=CommandType.Text;
insert_cmd.ExecuteNonQuery();
cnn.Close();
if(e.CommandName=="Edit")
{
Response.Redirect("PX_SQXLJY_PF.aspx?ViewType=2",false);
}
if(e.CommandName=="Test")
{
Response.Redirect("PX_SQXLJY_NEW.aspx?ViewType=2",false);
}完整代码,谢谢
Textbox2.Text = CPXBMC;
String SQL = "Select * From HR_SQXLJY Where CSQRYBH = '" + Textbox2.Text + "'";
SqlConnection cnn = new SqlConnection("Data Source=BK02;Initial Catalog=pxfz;User Id=sa;Password=;" );
SqlCommand cmd = new SqlCommand(SQL, cnn);
cnn.Open();
SqlDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
if (dr.Read())
{ Textbox4.Text = dr["CXM"].ToString();
Textbox5.Text = dr["CXB"].ToString();
Textbox6.Text = dr["CXYWHCD"].ToString();
Textbox7.Text = dr["CNBXLCC"].ToString();
Textbox8.Text = dr["CXXXS"].ToString();
Textbox12.Text = dr["CYDTJ"].ToString();
Textbox13.Text = dr["CBMYJ"].ToString();
Textbox14.Text = dr["CRLZYBMYJ"].ToString();
TextBox3.Text = dr["CZT"].ToString();
}
dr.Close();
cnn.Open();
SqlCommand cma=new SqlCommand("delete from HR_SQXLJY_L",cnn);
cma.ExecuteNonQuery();
string SqlInsertStr1 = "INSERT INTO HR_SQXLJY_L (CSQRYBH, CXM, CXB, CXYWHCD, CNBXLCC, CXXXS, CYDTJ, CBMYJ, CRLZYBMYJ, CZT) "+" Values ('"+Textbox4.Text+"','"+Textbox4.Text+"','"+Textbox5.Text+"','"+Textbox6.Text+"','"+Textbox7.Text+"','"+Textbox8.Text+"','"+Textbox12.Text+"','"+Textbox13.Text+"','"+Textbox14.Text+"','"+TextBox3.Text+"')";
SqlCommand insert_cmd = new SqlCommand(SqlInsertStr1,cnn);
insert_cmd.CommandType=CommandType.Text;
insert_cmd.ExecuteNonQuery();
cnn.Close();
if(e.CommandName=="Edit")
{
Response.Redirect("PX_SQXLJY_PF.aspx?ViewType=2",false);
}
if(e.CommandName=="Test")
{
Response.Redirect("PX_SQXLJY_NEW.aspx?ViewType=2",false);
}完整代码,谢谢
你的前面aspx的赋OnCommand="Edit"无误?
还是找不出来的话把这部分的aspx页面贴出来
<TR>
<TD><FONT face="宋体"><asp:datagrid class=TableGrid id=DataGrid1 runat="server" Height="100%" Width="100%" DataKeyField="CSQRYBH" AutoGenerateColumns="False" ShowFooter="True" AllowPaging="True" DataSource="<%# dataView1 %>" AllowSorting="True">
<Columns>
<asp:BoundColumn DataField="CSQRYBH" SortExpression="CSQRYBH" HeaderText="申请人员编号"></asp:BoundColumn>
<asp:BoundColumn DataField="CXM" SortExpression="CXM" HeaderText="姓名"></asp:BoundColumn>
<asp:BoundColumn DataField="CXB" SortExpression="CXB" HeaderText="性别"></asp:BoundColumn>
<asp:BoundColumn DataField="CXYWHCD" SortExpression="CXYWHCD" HeaderText="现有文化程度"></asp:BoundColumn>
<asp:BoundColumn DataField="CNBXLCC" HeaderText="拟报考学历层次"></asp:BoundColumn>
<asp:BoundColumn DataField="CXXXS" HeaderText="学习形式"></asp:BoundColumn>
<asp:BoundColumn DataField="CYDTJ" HeaderText="约定条件"></asp:BoundColumn>
<asp:BoundColumn DataField="CBMYJ" HeaderText="部门意见"></asp:BoundColumn>
<asp:BoundColumn DataField="CRLZYBMYJ" HeaderText="人力资源部门意见"></asp:BoundColumn>
<asp:BoundColumn DataField="CZT" SortExpression="CZT" HeaderText="状态"></asp:BoundColumn>
<asp:ButtonColumn Text="人力资源部意见" HeaderText="人力资源部意见" CommandName="Test"></asp:ButtonColumn>
<asp:ButtonColumn Text="详细及修改" HeaderText="详细及修改" CommandName="Edit"></asp:ButtonColumn>
<asp:ButtonColumn Text="<div id="de" onclick="javascript:return confirm('你确定要删除此条记录吗?')">删除</div>"
HeaderText="删除" CommandName="Delete"></asp:ButtonColumn>
</Columns>
<PagerStyle NextPageText="下一页&gt&gt" PrevPageText="&lt&lt上一页" Position="TopAndBottom"></PagerStyle>
</asp:datagrid></FONT></TD>
</TR>
Response.Redirect("PX_SQXLJY_PF.aspx?ViewType=2",false);
}
else{
Response.Redirect("PX_SQXLJY_NEW.aspx?ViewType=2",false);
}