2.SqlCommand操作sql2012

            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 { } }