62,265
社区成员
发帖
与我相关
我的任务
分享
protected void Button3_Click(object sender, EventArgs e)
{
string partNumber = this.TextBox3.Text;
string partGroup = this.DropDownList1.SelectedValue;
string responsibleAE = this.DropDownList2.SelectedValue;
//***数据库操作***
//连接字符串
string connstr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("~/App_Data/db.mdb ");
//建立连接对象
OleDbConnection myConn = new OleDbConnection(connstr);
//定义SQL语句
string myInsertQuery = String.Format("insert into [part]([PartNumber],[PartGroup],[ResponsibleAE]) values ( '{0} ', '{1} ','{2} ' ) ", partNumber, partGroup,responsibleAE);
//建立OleDbCommand对象
OleDbCommand myOleDbCommand = new OleDbCommand(myInsertQuery, myConn);
//打开连接对象
myConn.Open();
//执行SQL语句
myOleDbCommand.ExecuteNonQuery();
//关闭连接对象
myConn.Close();
Response.Redirect("Admin.aspx");
}
page.RegisterStartupScript("message", "<script language='javascript' defer>alert(' 插入成功!');</script>");
}
page.RegisterStartupScript("message", "<script language='javascript' defer>alert('" + msg.ToString() + "');</script>"); /// <summary>
/// 显示消息提示对话框
/// </summary>
/// <param name="page">当前页面指针,一般为this</param>
/// <param name="msg">提示信息</param>
public static void Show(System.Web.UI.Page page, string msg)
{
page.RegisterStartupScript("message", "<script language='javascript' defer>alert('" + msg.ToString() + "');</script>");
}