调用User的页面WebForm1:
using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using Mis.DbBase;namespace TheBook
{
/// <summary>
/// WebForm1 的摘要说明。
/// </summary>
public class WebForm1 : System.Web.UI.Page
{
protected System.Web.UI.WebControls.TextBox TextBox1;
protected System.Web.UI.WebControls.TextBox TextBox2;
protected System.Web.UI.WebControls.TextBox TextBox3;
protected System.Web.UI.WebControls.Label Label1;
protected System.Web.UI.WebControls.TextBox TextBox4;
protected System.Web.UI.WebControls.Button btnInsert;
protected System.Web.UI.WebControls.Button btnUpdate;
protected System.Web.UI.WebControls.Button btnDelete;
protected System.Web.UI.WebControls.DataGrid DataGrid1;
protected System.Web.UI.WebControls.DropDownList ddlSex;
protected System.Web.UI.WebControls.DropDownList DropDownList1;
protected System.Web.UI.WebControls.Button Button1;
protected System.Web.UI.WebControls.DropDownList DropDownList2;
protected System.Web.UI.WebControls.DropDownList ddlDuty;
protected System.Web.UI.WebControls.TextBox TextBox5;
protected System.Web.UI.WebControls.Label Label2;
protected System.Web.UI.WebControls.Label Label3;
protected System.Web.UI.WebControls.Label Label4;
protected System.Web.UI.WebControls.Label Label5;
protected System.Web.UI.WebControls.DropDownList DropDownList3;
private void Page_Load(object sender, System.EventArgs e)
{
// 在此处放置用户代码以初始化页面
} #region Web 窗体设计器生成的代码
override protected void OnInit(EventArgs e)
{
//
// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
//
InitializeComponent();
base.OnInit(e);
}
/// <summary>
/// 设计器支持所需的方法 - 不要使用代码编辑器修改
/// 此方法的内容。
/// </summary>
private void InitializeComponent()
{
this.TextBox1.TextChanged += new System.EventHandler(this.TextBox1_TextChanged);
this.DropDownList2.SelectedIndexChanged += new System.EventHandler(this.DropDownList2_SelectedIndexChanged);
this.btnDelete.Click += new System.EventHandler(this.btnDelete_Click);
this.btnUpdate.Click += new System.EventHandler(this.btnUpdate_Click);
this.btnInsert.Click += new System.EventHandler(this.btnInsert_Click);
this.TextBox3.TextChanged += new System.EventHandler(this.TextBox3_TextChanged);
this.Button1.Click += new System.EventHandler(this.Button1_Click);
this.ddlSex.SelectedIndexChanged += new System.EventHandler(this.ddlSex_SelectedIndexChanged);
this.DataGrid1.SelectedIndexChanged += new System.EventHandler(this.DataGrid1_SelectedIndexChanged);
this.DropDownList1.SelectedIndexChanged += new System.EventHandler(this.DropDownList1_SelectedIndexChanged);
this.Load += new System.EventHandler(this.Page_Load); }
#endregion private void Button1_Click(object sender, System.EventArgs e)
{
try
{
Mis.DbBase.User user=new Mis.DbBase.User();
DataSet dsUser=user.Query(TextBox1.Text);
this.DataGrid1.DataSource=dsUser.Tables[0].DefaultView;
this.DataGrid1.DataBind();
this.Label1.Text=dsUser.Tables[0].Rows[0][1].ToString();
}
catch(Exception ex)
{
Label1.Text=ex.Message;
}
} private void TextBox3_TextChanged(object sender, System.EventArgs e)
{
} private void TextBox1_TextChanged(object sender, System.EventArgs e)
{
} private void btnUpdate_Click(object sender, System.EventArgs e)
{
} private void btnInsert_Click(object sender, System.EventArgs e)
{
//DateTime dat;
//dat=Convert.ToDateTime(DropDownList1.SelectedItem.Text+"-"+DropDownList2.SelectedItem.Text+"-"+DropDownList3.SelectedItem.Text);
try
{
Mis.DbBase.User user=new Mis.DbBase.User();
user.Emp_Id=TextBox1.Text;
user.Name=TextBox2.Text;
user.Password=TextBox3.Text;
user.Add(TextBox1.Text,TextBox2.Text,Convert.ToString(ddlSex.SelectedIndex),Convert.ToString(TextBox4.Text),TextBox3.Text,Convert.ToString(ddlDuty.SelectedIndex),TextBox5.Text);
//user.Add(TextBox1.Text,TextBox2.Text,Convert.ToString(ddlSex.SelectedIndex),TextBox4.Text,TextBox3.Text,Convert.ToString(ddlDuty.SelectedIndex),TextBox5.Text);
//user.Add(TextBox1.Text,TextBox2.Text,TextBox3.Text,dplSex.SelectedItem.Text);
//user.Add(TextBox1.Text,TextBox2.Text,TextBox3.Text);
//user.Add(user.Emp_Id,user.Name,user.Password);
Label1.Text="增加成功";
}
catch(Exception ex)
{Label1.Text=ex.Message;}
} private void btnDelete_Click(object sender, System.EventArgs e)
{
Mis.DbBase.User.Delete(TextBox1.Text);
} private void Calendar1_SelectionChanged(object sender, System.EventArgs e)
{
} private void DropDownList1_SelectedIndexChanged(object sender, System.EventArgs e)
{
} private void DataGrid1_SelectedIndexChanged(object sender, System.EventArgs e)
{
} private void DropDownList2_SelectedIndexChanged(object sender, System.EventArgs e)
{
} private void ddlSex_SelectedIndexChanged(object sender, System.EventArgs e)
{
}
}
}
using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using Mis.DbBase;namespace TheBook
{
/// <summary>
/// WebForm1 的摘要说明。
/// </summary>
public class WebForm1 : System.Web.UI.Page
{
protected System.Web.UI.WebControls.TextBox TextBox1;
protected System.Web.UI.WebControls.TextBox TextBox2;
protected System.Web.UI.WebControls.TextBox TextBox3;
protected System.Web.UI.WebControls.Label Label1;
protected System.Web.UI.WebControls.TextBox TextBox4;
protected System.Web.UI.WebControls.Button btnInsert;
protected System.Web.UI.WebControls.Button btnUpdate;
protected System.Web.UI.WebControls.Button btnDelete;
protected System.Web.UI.WebControls.DataGrid DataGrid1;
protected System.Web.UI.WebControls.DropDownList ddlSex;
protected System.Web.UI.WebControls.DropDownList DropDownList1;
protected System.Web.UI.WebControls.Button Button1;
protected System.Web.UI.WebControls.DropDownList DropDownList2;
protected System.Web.UI.WebControls.DropDownList ddlDuty;
protected System.Web.UI.WebControls.TextBox TextBox5;
protected System.Web.UI.WebControls.Label Label2;
protected System.Web.UI.WebControls.Label Label3;
protected System.Web.UI.WebControls.Label Label4;
protected System.Web.UI.WebControls.Label Label5;
protected System.Web.UI.WebControls.DropDownList DropDownList3;
private void Page_Load(object sender, System.EventArgs e)
{
// 在此处放置用户代码以初始化页面
} #region Web 窗体设计器生成的代码
override protected void OnInit(EventArgs e)
{
//
// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
//
InitializeComponent();
base.OnInit(e);
}
/// <summary>
/// 设计器支持所需的方法 - 不要使用代码编辑器修改
/// 此方法的内容。
/// </summary>
private void InitializeComponent()
{
this.TextBox1.TextChanged += new System.EventHandler(this.TextBox1_TextChanged);
this.DropDownList2.SelectedIndexChanged += new System.EventHandler(this.DropDownList2_SelectedIndexChanged);
this.btnDelete.Click += new System.EventHandler(this.btnDelete_Click);
this.btnUpdate.Click += new System.EventHandler(this.btnUpdate_Click);
this.btnInsert.Click += new System.EventHandler(this.btnInsert_Click);
this.TextBox3.TextChanged += new System.EventHandler(this.TextBox3_TextChanged);
this.Button1.Click += new System.EventHandler(this.Button1_Click);
this.ddlSex.SelectedIndexChanged += new System.EventHandler(this.ddlSex_SelectedIndexChanged);
this.DataGrid1.SelectedIndexChanged += new System.EventHandler(this.DataGrid1_SelectedIndexChanged);
this.DropDownList1.SelectedIndexChanged += new System.EventHandler(this.DropDownList1_SelectedIndexChanged);
this.Load += new System.EventHandler(this.Page_Load); }
#endregion private void Button1_Click(object sender, System.EventArgs e)
{
try
{
Mis.DbBase.User user=new Mis.DbBase.User();
DataSet dsUser=user.Query(TextBox1.Text);
this.DataGrid1.DataSource=dsUser.Tables[0].DefaultView;
this.DataGrid1.DataBind();
this.Label1.Text=dsUser.Tables[0].Rows[0][1].ToString();
}
catch(Exception ex)
{
Label1.Text=ex.Message;
}
} private void TextBox3_TextChanged(object sender, System.EventArgs e)
{
} private void TextBox1_TextChanged(object sender, System.EventArgs e)
{
} private void btnUpdate_Click(object sender, System.EventArgs e)
{
} private void btnInsert_Click(object sender, System.EventArgs e)
{
//DateTime dat;
//dat=Convert.ToDateTime(DropDownList1.SelectedItem.Text+"-"+DropDownList2.SelectedItem.Text+"-"+DropDownList3.SelectedItem.Text);
try
{
Mis.DbBase.User user=new Mis.DbBase.User();
user.Emp_Id=TextBox1.Text;
user.Name=TextBox2.Text;
user.Password=TextBox3.Text;
user.Add(TextBox1.Text,TextBox2.Text,Convert.ToString(ddlSex.SelectedIndex),Convert.ToString(TextBox4.Text),TextBox3.Text,Convert.ToString(ddlDuty.SelectedIndex),TextBox5.Text);
//user.Add(TextBox1.Text,TextBox2.Text,Convert.ToString(ddlSex.SelectedIndex),TextBox4.Text,TextBox3.Text,Convert.ToString(ddlDuty.SelectedIndex),TextBox5.Text);
//user.Add(TextBox1.Text,TextBox2.Text,TextBox3.Text,dplSex.SelectedItem.Text);
//user.Add(TextBox1.Text,TextBox2.Text,TextBox3.Text);
//user.Add(user.Emp_Id,user.Name,user.Password);
Label1.Text="增加成功";
}
catch(Exception ex)
{Label1.Text=ex.Message;}
} private void btnDelete_Click(object sender, System.EventArgs e)
{
Mis.DbBase.User.Delete(TextBox1.Text);
} private void Calendar1_SelectionChanged(object sender, System.EventArgs e)
{
} private void DropDownList1_SelectedIndexChanged(object sender, System.EventArgs e)
{
} private void DataGrid1_SelectedIndexChanged(object sender, System.EventArgs e)
{
} private void DropDownList2_SelectedIndexChanged(object sender, System.EventArgs e)
{
} private void ddlSex_SelectedIndexChanged(object sender, System.EventArgs e)
{
}
}
}
使用单引号',其他部分类似。
strSQL ="Insert into t_emp_info(emp_id,emp_name,flag,emp_sex,emp_birth,password) values("
+"'"+emp_id+"',"
+"'"+name+"',"
+"1"+","
+"'"+sex+"',"
+"'"+dat+"',"
+"'"+password+"')";
strSQL ="Insert into t_emp_info(emp_id,emp_name,flag,emp_sex,emp_birth,password,emp_duty,description) values('"
+emp_id+"','"
+name+"',"
+"1"+",'"
+sex+"','"
+dat+"','"
+password+"','"
+emp_duty+"','"
+description+"')";
若是值类型则SQL语句增加参数时不需要用''
若是字符类型则SQL语句增加参数时需要用''
若是日期类型则SQL语句增加参数时需要用''
sql server 用"'"+DateTime.Now.ToString()+"'"
access用"#"+DateTime.Now.ToString()+"#"