hi this is my ImageButton event code
protected void ImageButton_Click1(object sender, ImageClickEventArgs e)
{
string data = Server.UrlDecode(Request.QueryString["BehCode2"]);
SqlCommand _cmd = new SqlCommand("insertinfo", _cn);
_cmd.CommandType = CommandType.StoredProcedure;
_cn.Open();
_cmd.Parameters.AddWithValue("@Name", txtstore.Text);
_cmd.Parameters.AddWithValue("@Ownername", Txtname.Text);
_cmd.Parameters.AddWithValue("@Description", CKEditorControl1.Text);
_cmd.Parameters.AddWithValue("@address", Txtadd.Text);
_cmd.Parameters.AddWithValue("@City", DDL1.SelectedItem.Text);
_cmd.Parameters.AddWithValue("@Region", DDL2.SelectedItem.Text);
_cmd.Parameters.AddWithValue("@ShoppingCenter", DDL3.SelectedItem.Text);
_cmd.Parameters.AddWithValue("@tell", txttell.Text);
_cmd.Parameters.AddWithValue("@tell1", Txttell2.Text);
_cmd.Parameters.AddWithValue("@code", txtcode.Text);
_cmd.Parameters.AddWithValue("@fax", Txtfax.Text);
_cmd.Parameters.AddWithValue("@Mobile", Txtmob.Text);
_cmd.Parameters.AddWithValue("@Email", Txtemail.Text);
_cmd.Parameters.AddWithValue("@Web", Txtweb.Text);
_cmd.Parameters.AddWithValue("@Service1", TxtMT1.Text);
_cmd.Parameters.AddWithValue("@Service2", TxtMT2.Text);
_cmd.Parameters.AddWithValue("@Service3", TxtMT3.Text);
_cmd.Parameters.AddWithValue("@Service4", TxtMT4.Text);
_cmd.Parameters.AddWithValue("@Service5", TxtMT5.Text);
_cmd.Parameters.AddWithValue("@Service6", TxtMT6.Text);
_cmd.Parameters.AddWithValue("@Service7", TxtMT7.Text);
_cmd.Parameters.AddWithValue("@Service8", TxtMT8.Text);
_cmd.Parameters.AddWithValue("@behcode", data);
_cmd.ExecuteNonQuery();
_cn.Close();
Response.Redirect(Request.Url.AbsoluteUri);
}
}
when i click on button to insert data in database this error occur
Server Error in '/behtop website' Application.
String or binary data would be truncated.
The statement has been terminated.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: String or binary data would be truncated.
The statement has been terminated.
Source Error:
Line 794: _cmd.Parameters.AddWithValue("@behcode", data);
Line 795:
Line 796: _cmd.ExecuteNonQuery(); Line 797:
Line 798: _cn.Close();
|
SP
LTER procedure [dbo].[insertinfo]
@Name nvarchar(30),@Ownername nvarchar(30),@Behcode nvarchar(10)
,@City nvarchar(30),@Region varchar(10),@address nvarchar(max),@ShoppingCenter nvarchar(50)
,@tell varchar(15),@tell1 varchar(15),@code varchar(15),@Fax varchar(10),@Mobile varchar(15),
@Email varchar(MAX),@Web varchar(MAX),@Description nvarchar(MAX),@Service1 nvarchar(20),
@Service2 nvarchar(20),@Service3 nvarchar(20),@Service4 nvarchar(20),@Service5 nvarchar(20)
,@Service6 nvarchar(20),@Service7 nvarchar(20),@Service8 nvarchar(20)
as
begin
update House_info set Name=@Name,Date=GETDATE(),Ownername=@Ownername,BehCode=@Behcode
,City=@City,Region=@Region,address=@address,ShoppingCenter=@ShoppingCenter,Tell=@tell,Tell1=@tell1
,Code=@code,fax=@Fax,email=@Email,web=@Web,Description=@Description,Service1=@Service1,Service2=@Service2,Service3=@Service3
,Service4=@Service4,Service5=@Service5,Service6=@Service6,Service7=@Service7,Service8=@Service8
where BehCode=@Behcode
end
best regards