plz帮助更新quary是行不通的 [英] plz help update quary is not work
本文介绍了plz帮助更新quary是行不通的的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
protected void savebtn_Click(对象发件人,ImageClickEventArgs e)
{
con.Open();
int imagefilelenth = FileUpload1.PostedFile.ContentLength;
byte [] imgarray = new byte < /跨度> [imagefilelenth];
HttpPostedFile image = FileUpload1.PostedFile;
image.InputStream.Read(imgarray, 0 ,imagefilelenth);
SqlCommand cmd = new SqlCommand( [更新],con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue( @ email ,pemail.Text.ToString());
cmd.Parameters.AddWithValue( @ dob,pdob.Text.ToString() );
cmd.Parameters.AddWithValue( @ gender,pgender.Text.ToString() );
cmd.Parameters.AddWithValue( @ city,city.Text.ToString() );
cmd.Parameters.AddWithValue( @ state,state.Text.ToString() );
cmd.Parameters.AddWithValue( @ country,country.Text.ToString() );
cmd.Parameters.AddWithValue( @ about,about.Text.ToString() );
cmd.Parameters.AddWithValue( @ books,books.Text.ToString() );
cmd.Parameters.AddWithValue( @ qualification,qualification.Text.ToString() );
cmd.Parameters.AddWithValue( @ number,number.Text.ToString() );
cmd.Parameters.AddWithValue( @ image,imgarray);
cmd.Parameters.AddWithValue( @ username,pname.Text.ToString() );
cmd.Parameters.AddWithValue( @ designation,designation.Text.ToString() );
cmd.Parameters.AddWithValue( @ interest,interest.Text.ToString() );
cmd.ExecuteNonQuery();
con.Close();
存储过程是
ALTER PROCEDURE [dbo]。[ update ]
@ username varchar ( 50 ), @ email varchar ( 50 ), @ dob date , @ gender varchar ( 50 ), @ city varchar ( 50 ), @ state varchar ( 50 ), @cou ntry varchar ( 50 ), @ designation varchar ( 50 ), @ qualification varchar ( 50 ), @ about varchar ( 50 ), @ interest varchar ( 50 ), @ books varchar ( 50 ), @ number < span class =code-keyword> int , @ image image
AS
BEGIN
- 添加SET NOCOUNT ON以防止额外的结果集
- 干扰SELECT语句。
SET NOCOUNT ON ;
更新注册设置电子邮件= @ email,dob = @ dob,性别= @性别,城市= @市,[状态] = @州,国家= @国家,指定= @名称,资质= @资质,约= @一下,利息= @兴趣,书籍= @书,数= @号,[ image ] = @ image 其中用户名= @ username
结束
}
解决方案
protected void savebtn_Click( object sender,ImageClickEventArgs e)
{
con.Open();
int imagefilelenth = FileUpload1.PostedFile.ContentLength;
byte [] imgarray = new byte < /跨度> [imagefilelenth];
HttpPostedFile image = FileUpload1.PostedFile;
image.InputStream.Read(imgarray, 0 ,imagefilelenth);
SqlCommand cmd = new SqlCommand( [更新],con);
cmd.CommandType = CommandType.StoredProcedure;
IFormatProvider provider1 = new System.Globalization.CultureInfo( en-CA, true );
String datetime1 = pdob.Text.ToString();
DateTime dt1 = DateTime.Parse(datetime1,provider1,System.Globalization.DateTimeStyles.NoCurrentDateDefault);
cmd.Parameters.AddWithValue( @ email ,pemail.Text.ToString());
cmd.Parameters.AddWithValue( @ dob,dt1);
cmd.Parameters.AddWithValue( @ gender,pgender.Text.ToString() );
cmd.Parameters.AddWithValue( @ city,city.Text.ToString() );
cmd.Parameters.AddWithValue( @ state,state.Text.ToString() );
cmd.Parameters.AddWithValue( @ country,country.Text.ToString() );
cmd.Parameters.AddWithValue( @ about,about.Text.ToString() );
cmd.Parameters.AddWithValue( @ books,books.Text.ToString() );
cmd.Parameters.AddWithValue( @ qualification,qualification.Text.ToString() );
cmd.Parameters.AddWithValue( @ number,number.Text.ToString() );
cmd.Parameters.AddWithValue( @ image,imgarray);
cmd.Parameters.AddWithValue( @ username,pname.Text.ToString() );
cmd.Parameters.AddWithValue( @ designation,designation.Text.ToString() );
cmd.Parameters.AddWithValue( @ interest,interest.Text.ToString() );
cmd.ExecuteNonQuery();
con.Close();
存储过程
ALTER 程序 [dbo] 。[ update ]
@ username varchar ( 50 ), @ email varchar ( 50 ), @ dob DateTime , @ gender varchar ( 50 ) , @ city varchar ( 50 ), @ state varchar ( 50 ),< span class =code-sdkkeyword> @ countryvarchar ( 50 ), @ designation varchar ( 50 ), @qualification varchar ( 50 ), @ about varchar ( 50 ), @ interest varchar ( 50 ), @ books varchar ( 50 ), @ number varchar ( 50 ), @ image image
AS
BEGIN
- 添加SET NOCOUNT ON以防止额外的结果集
- 干扰SELECT语句。
SET NOCOUNT ON ;
更新注册设置电子邮件= @ email,dob = @ dob,性别= @性别,城市= @市,[状态] = @州,国家= @国家,指定= @名称,资质= @资质,约= @一下,利息= @兴趣,书籍= @书,数= @号,[ image ] = @ image 其中用户名= @ username
END 跨度>
protected void savebtn_Click(object sender, ImageClickEventArgs e)
{
con.Open();
int imagefilelenth = FileUpload1.PostedFile.ContentLength;
byte[] imgarray = new byte[imagefilelenth];
HttpPostedFile image = FileUpload1.PostedFile;
image.InputStream.Read(imgarray, 0, imagefilelenth);
SqlCommand cmd = new SqlCommand("[update]", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@email", pemail.Text.ToString());
cmd.Parameters.AddWithValue("@dob", pdob.Text.ToString());
cmd.Parameters.AddWithValue("@gender", pgender.Text.ToString());
cmd.Parameters.AddWithValue("@city", city.Text.ToString());
cmd.Parameters.AddWithValue("@state", state.Text.ToString());
cmd.Parameters.AddWithValue("@country", country.Text.ToString());
cmd.Parameters.AddWithValue("@about", about.Text.ToString());
cmd.Parameters.AddWithValue("@books", books.Text.ToString());
cmd.Parameters.AddWithValue("@qualification", qualification.Text.ToString());
cmd.Parameters.AddWithValue("@number", number.Text.ToString());
cmd.Parameters.AddWithValue("@image",imgarray);
cmd.Parameters.AddWithValue("@username", pname.Text.ToString());
cmd.Parameters.AddWithValue("@designation", designation.Text.ToString());
cmd.Parameters.AddWithValue("@interest", interest.Text.ToString());
cmd.ExecuteNonQuery();
con.Close();
stored procedure is
ALTER PROCEDURE[dbo].[update]
@username varchar(50),@email varchar(50),@dob date,@gender varchar(50),@city varchar(50),@state varchar(50),@country varchar(50),@designation varchar(50),@qualification varchar(50),@about varchar(50),@interest varchar(50),@books varchar(50),@number int,@image image
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
update registration set email=@email,dob=@dob,gender=@gender,city=@city,[state]=@state,country=@country,designation=@designation,qualification=@qualification,about=@about,interest=@interest,books=@books,number=@number,[image]=@image where username=@username
END
}
解决方案
protected void savebtn_Click(object sender, ImageClickEventArgs e) { con.Open(); int imagefilelenth = FileUpload1.PostedFile.ContentLength; byte[] imgarray = new byte[imagefilelenth]; HttpPostedFile image = FileUpload1.PostedFile; image.InputStream.Read(imgarray, 0, imagefilelenth); SqlCommand cmd = new SqlCommand("[update]", con); cmd.CommandType = CommandType.StoredProcedure; IFormatProvider provider1 = new System.Globalization.CultureInfo("en-CA", true); String datetime1 = pdob.Text.ToString(); DateTime dt1 = DateTime.Parse(datetime1, provider1, System.Globalization.DateTimeStyles.NoCurrentDateDefault); cmd.Parameters.AddWithValue("@email", pemail.Text.ToString()); cmd.Parameters.AddWithValue("@dob", dt1); cmd.Parameters.AddWithValue("@gender", pgender.Text.ToString()); cmd.Parameters.AddWithValue("@city", city.Text.ToString()); cmd.Parameters.AddWithValue("@state", state.Text.ToString()); cmd.Parameters.AddWithValue("@country", country.Text.ToString()); cmd.Parameters.AddWithValue("@about", about.Text.ToString()); cmd.Parameters.AddWithValue("@books", books.Text.ToString()); cmd.Parameters.AddWithValue("@qualification", qualification.Text.ToString()); cmd.Parameters.AddWithValue("@number", number.Text.ToString()); cmd.Parameters.AddWithValue("@image",imgarray); cmd.Parameters.AddWithValue("@username", pname.Text.ToString()); cmd.Parameters.AddWithValue("@designation", designation.Text.ToString()); cmd.Parameters.AddWithValue("@interest", interest.Text.ToString()); cmd.ExecuteNonQuery(); con.Close();
stored procedure
ALTER PROCEDURE[dbo].[update] @username varchar(50),@email varchar(50),@dob DateTime,@gender varchar(50),@city varchar(50),@state varchar(50),@country varchar(50),@designation varchar(50),@qualification varchar(50),@about varchar(50),@interest varchar(50),@books varchar(50),@number varchar(50),@image image AS BEGIN -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT statements. SET NOCOUNT ON; update registration set email=@email,dob=@dob,gender=@gender,city=@city,[state]=@state,country=@country,designation=@designation,qualification=@qualification,about=@about,interest=@interest,books=@books,number=@number,[image]=@image where username=@username END
这篇关于plz帮助更新quary是行不通的的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文