sql server中有一个员工数据表，现在希望写一个页面对这个员工数据表进行维护，要具有新增和修改功能！

Question

哪位兄弟有这样的示例代码请发给我或帖出来，非常感谢！

Answer 1

太笼统了 我这个你参考一下吧
private void additem_Click(object sender, System.Web.UI.ImageClickEventArgs e)
{
string sql;
sql="insert into RY (bh,xm,tel,yzdz,yzbm,dzyx,jl,jgid) values ("+"'"+rybh.Text+"'"+","+"'"+ryxm.Text+"'"+","+"'"+dh.Text+"'"+","+"'"+dz.Text+"'"+","+"'"+yb.Text+"'"+","+"'"+email.Text+"'"+","+"'"+jl.Text+"'"+","+"'"+jgid+"'"+")";
SqlCommand cmd_add=new  SqlCommand(sql,Conn);
try
{
this.Conn.Open();
cmd_add.ExecuteNonQuery();
}
catch(SqlException ex)
{
throw(new Exception("数据添加失败，原因:"+ex.Message));
}
finally
{
this.Conn.Close();
Response.Redirect(url);
}-----------------------------------------------------------------------
private void updata_Click(object sender, System.Web.UI.ImageClickEventArgs e)
{
string sql;
sql="update JG set jgbh="+"'"+jgbh.Text+"'"+",jgmc="+"'"+jgmc.Text+"'"+",dh="+"'"+dh.Text+"'"+",dz="+"'"+dz.Text+"'"+",yb="+"'"+yb.Text+"'"+",email="+"'"+email.Text+"'"+",jl="+"'"+jl.Text+"'"+"where jgid="+jgid;
SqlCommand cmd_add=new  SqlCommand(sql,Conn);
try
{
this.Conn.Open();
cmd_add.ExecuteNonQuery();
}
catch(SqlException ex)
{
throw(new Exception("数据添加失败，原因:"+ex.Message));
}
finally
{
this.Conn.Close();
}
Response.Write ("<script language=javascript>window.alert('机构信息已经修改，点击确定返回！')</script>");
Response.Write ("<script language=javascript>parent.location.reload()</script>");
}

Answer 2

很基本的操作啊，用 nekiy(蓝之焰)的代码就可以搞定了

Answer 3

可以用DataGrid轻松实现时间原因,贴一个大体的代码private void DataGrid1_SelectedIndexChanged(object sender, System.EventArgs e)
    {
      DataGrid1.SelectedItem.BackColor = Color.LightGreen;
    }    private void DataGrid1_EditCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
    {
      DataGrid1.EditItemIndex = e.Item.ItemIndex;
      Bind_DataGrid1();
    }    private void DataGrid1_CancelCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
    {
      DataGrid1.EditItemIndex = -1;
      Bind_DataGrid1();
    }    private void DataGrid1_UpdateCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
    {
      oleDbConnection1.Open();
      objCommand1.Connection = oleDbConnection1;
      objCommand1.CommandText = "Update colleges Set college_name=@CollegeName Where college_ID=@CollegeID";
      objCommand1.Parameters.Add("@CollegeName",((TextBox)e.Item.Cells[1].Controls[0]).Text.Trim());
      objCommand1.Parameters.Add("@CollegeID",e.Item.Cells[0].Text.Trim());
      objCommand1.ExecuteNonQuery();
      DataGrid1.EditItemIndex = -1;
      Bind_DataGrid1();
    }    private void Button1_Click(object sender, System.EventArgs e)
    {
      oleDbConnection1.Open();
      objCommand1.Connection = oleDbConnection1;
      objCommand1.CommandText = "Insert Into colleges(college_ID,college_name) Values(@CollegeID,@CollegeName)";
      objCommand1.Parameters.Add("@CollegeID",TextBox2.Text.Trim());
      objCommand1.Parameters.Add("@CollegeName",TextBox1.Text.Trim());
      objCommand1.ExecuteNonQuery();
      Bind_DataGrid1();
    }    private void DataGrid1_DeleteCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
    {
      oleDbConnection1.Open();
      objCommand1.Connection = oleDbConnection1;
      objCommand1.CommandText = "Delete From colleges Where college_ID=@CollegeID";
      objCommand1.Parameters.Add("@CollegeID",e.Item.Cells[0].Text.Trim());
      objCommand1.ExecuteNonQuery();
      Bind_DataGrid1();
    }    private void DataGrid1_PageIndexChanged(object source, System.Web.UI.WebControls.DataGridPageChangedEventArgs e)
    {
      DataGrid1.CurrentPageIndex = e.NewPageIndex;
      Bind_DataGrid1();
    }