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 InsertProc : System.Web.UI.Page
...{
protected void Page_Load(object sender, EventArgs e)
...{
}
public void InsertAutors(string Id, string Lname, string Fname, string Phone, string Address, string City, string State, string Zip, bool Contract)
...{
//创建数据库连接对像
SqlConnection myConnection = new SqlConnection(ConfigurationSettings.AppSettings["ConnectionString"]);
SqlCommand myCommand = new SqlCommand("InsertAutor", myConnection);
//指明命令为过程
myCommand.CommandType = CommandType.StoredProcedure;
//填加参数
SqlParameter parameterid = new SqlParameter("@Id",SqlDbType.VarChar,11);
parameterid.Value = Id;
myCommand.Parameters.Add(parameterid);
SqlParameter parameterlname = new SqlParameter("@Lname",SqlDbType.VarChar,40);
parameterlname.Value = Lname;
myCommand.Parameters.Add(parameterlname);
SqlParameter parameterfname = new SqlParameter("@Fname",SqlDbType.VarChar,20);
parameterfname.Value = Fname;
myCommand.Parameters.Add(parameterfname);
SqlParameter parameterphone = new SqlParameter("@Phone",SqlDbType.Char,12);
parameterphone.Value = Phone;
myCommand.Parameters.Add(parameterphone);
SqlParameter parameteraddress = new SqlParameter("@Address",SqlDbType.VarChar,40);
parameteraddress.Value = Address;
myCommand.Parameters.Add(parameteraddress);
SqlParameter parametercity = new SqlParameter("@City",SqlDbType.VarChar,20);
parametercity.Value = City;
myCommand.Parameters.Add(parametercity);
SqlParameter parameterstate = new SqlParameter("@State",SqlDbType.Char,2);
parameterstate.Value = State;
myCommand.Parameters.Add(parameterstate);
SqlParameter parameterzip = new SqlParameter("@Zip",SqlDbType.Char,20);
parameterzip.Value = Zip;
myCommand.Parameters.Add(parameterzip);
SqlParameter parameterContract = new SqlParameter("@Contract",SqlDbType.Bit,1);
parameterContract.Value = Contract;
myCommand.Parameters.Add(parameterContract);
try
...{
//打开数据库
myConnection.Open();
myCommand.ExecuteNonQuery();
//关闭连接
myConnection.Close();
Info.Text = "数据操作成功!";
}
catch (Exception ex)
...{
Info.Text = ex.ToString();
}
}
protected void Button1_Click(object sender, EventArgs e)
...{
string Id = au_id_textBox.Text;
string Lname = au_lname_textBox.Text;
string Fname = au_fname_textBox.Text;
string Phone = phone_textBox.Text;
string Address = address_textBox.Text;
string City = city_textBox.Text;
string State = state_textBox.Text;
string Zip = zip_textBox.Text;
bool Contract = true;
if (contract_RadioBtn.Checked)
...{
Contract = true;
}
else
...{
Contract = false;
}
InsertAutors(Id, Lname, Fname, Phone, Address, City, State, Zip, Contract);
}
}
create proc InsertAutor
(
@Id varchar(11),
@Lname varchar(40),
@Fname varchar(20),
@Phone char(12),
@Address varchar(40),
@City varchar(20),
@State char(2),
@Zip char(5),
@Contract int
)
As
Insert Into authors
(
au_id,
au_lname,
au_fname,
phone,
address,
city,
state,
zip,
contract
)
Values
(
@Id,
@Lname,
@Fname,
@Phone,
@Address,
@City,
@State,
@Zip,
@Contract
)
c#.net调用存储过程
最新推荐文章于 2018-07-06 10:55:06 发布