protected void Button1_Click(object sender, EventArgs e)
{
//設定連線的SQLDATASOURCE
if (!javascript_check())
{
return;
}
sysdb append_emp = new sysdb();
append_emp.Inserted += new SqlDataSourceStatusEventHandler(this.Clear_Textbox);
append_emp.InsertCommand = "INSERT INTO [Employee] ([emp002], [emp003], [emp004], [emp005], [emp006], [emp008], [emp009]) " +
"VALUES (@emp002, @emp003, @emp004, @emp005, @emp006, @emp008, @emp009)";
append_emp.InsertParameters.Add("emp002", TextBox1.Text);
append_emp.InsertParameters.Add("emp003", TextBox2.Text);
append_emp.InsertParameters.Add("emp004", DropDownList1.SelectedValue);
append_emp.InsertParameters.Add("emp005", TextBox3.Text);
append_emp.InsertParameters.Add("emp006", DropDownList3.SelectedValue);
append_emp.InsertParameters.Add("emp008", TextBox5.Text);
append_emp.InsertParameters.Add("emp009", DropDownList2.SelectedValue);
try
{
append_emp.Insert();
showmsg("新增成功");
}
catch (Exception)
{
showmsg("新增失敗");
}
}
private bool get_data(string secenePK_Key)
{
sysdb db = new sysdb();
db.SelectCommand = "SELECT [emp001],[emp002] ,[emp003] , [emp004],[emp005] ,[emp006],[emp008] ,[emp009] ";
db.SelectCommand += " FROM[dbo].[Employee] where [emp001]=@emp001 ";
db.SelectParameters.Add("emp001", secenePK_Key);
DataSourceSelectArguments para = new DataSourceSelectArguments();
this.dv = (DataView)db.Select(para);
if (this.dv.Count > 0)
{
return(true);
}
else
{
return(false);
}
}
