Company/UpdateJobInfo.aspx.cs

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
public partial class Company_UpdateJobInfo : System.Web.UI.Page
{
    DB db = new DB();
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            SqlDataReader da;
            da = db.GetDataReader("select  * from  Job  where Id='" + Request.QueryString["id"].ToString() + "'");
            da.Read();

            txtjobname.Text = da["jobname"].ToString();
            dpjobclass.Items[0].Text = da["jobclass"].ToString();
            txtjobnum.Text = da["jobnum"].ToString();
            dpsealarytype.Items[0].Text = da["sealarytpe"].ToString();
            txtsealary.Text = da["sealary"].ToString();
            DropShengfen.Text = da["privances"].ToString();
            txtaddress.Text = da["address"].ToString();
            txtdes.Text = da["descriptions"].ToString();
        }
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        string sql = "update  Job set  jobname='" + txtjobname.Text + "', jobclass='" + dpjobclass.SelectedValue + "',jobnum='" + txtjobnum.Text + "',sealarytpe='" + dpsealarytype.SelectedValue + "',privances='" + txtaddress.Text + "',address='" + txtaddress.Text + "',descriptions='"+txtdes.Text+"' where id="+Request.QueryString["id"].ToString();
        db.RunSql(sql);
        js.AlertAndRedirect("修改成功", "JobManger.aspx");
    }
}