2.SqlCommand操作sql2012

来源：互联网发布：怎么进入淘宝网开店编辑：程序博客网时间：2024/04/29 08:56

            string sqlconstr = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;            sqlconn = new SqlConnection(sqlconstr);//1.初始化连接            sqlcom = new SqlCommand();//2.新建command对象

        protected void UseData() {                sqlcom.Connection = sqlconn;            sqlcom.CommandText = "insert into UserDate(name,address,phone,image) values(@name,@address,@phone,@image)";            string NameText = this.NameText.Text;            string AddressText = this.AddressText.Text;            string PhoneText = this.PhoneText.Text;            string ImageName = this.ImageUploadId.FileName;            sqlcom.Parameters.AddWithValue("@name", NameText);            sqlcom.Parameters.AddWithValue("@address", AddressText);            sqlcom.Parameters.AddWithValue("@phone", PhoneText);            sqlcom.Parameters.AddWithValue("@image", ImageName);            sqlconn.Open();            SqlTransaction tran = sqlconn.BeginTransaction();            sqlcom.Transaction = tran;            sqlcom.ExecuteNonQuery();            tran.Commit();            try            {                if (ImageUploadId.HasFile == true)                {                    ImageUploadId.SaveAs(Server.MapPath("~/UserIco/") + ImageUploadId.FileName);                }            <pre name="code" class="html">                Label1.Text = "添加用户成功...";

} catch (Exception ex) { Label1.Text = "添加用户失败..."; } finally { } }

0 0