Operand type clash: nvarchar is incompatible with image

Question

Hi  Operand type clash: nvarchar is incompatible with image  am getting this error when am tring to update my list in listview. what it means and why this error occuring.. please help to me. thank you

Shivanand Arur · Answer

Let us know if it works... and please mark the answer as accepted if my reply helped you!!! Thank you...

Prabhakar Reddy · Answer

Okay Okay i will try with that datatype.. Thank you thank you alots..

Shivanand Arur · Answer

Check out this link... http://forums.asp.net/t/1536958.aspx/1

Shivanand Arur · Answer

Hey basically the Image datatype is taken as a VarBinary datatype internally... So instead of keeping the data type as Image change it to a varchar(200). May be it will help you out!!!

Prabhakar Reddy · Answer

This is my Admin page to control Edit and Delete Records: DataSourceID=SqlDataSource1> AdId: ' /> Locality: ' /> AdTitle: ' /> AdDescription: Text=' ' /> AdKeywords: Text=' ' /> AdImage: ' /> SiteId: ' /> IPAddress: ' /> ContactEmail: Text=' ' /> AdCategory: Text=' ' /> AdEntryDate: Text=' ' /> UserId: ' /> Contactcell: Text=' ' /> ContactAddress: Text=' ' /> Text=Delete /> AdId: ' /> Locality: ' /> AdTitle: ' /> AdDescription: Text=' ' /> AdKeywords: Text=' ' /> AdImage: ' /> SiteId: ' /> IPAddress: ' /> ContactEmail: Text=' ' /> AdCategory: Text=' ' /> AdEntryDate: Text=' ' /> UserId: ' /> Contactcell: Text=' ' /> ContactAddress: Text=' ' /> Text=Delete /> No data was returned. Locality: Text=' ' /> AdTitle: ' /> AdDescription: Text=' ' /> AdKeywords: Text=' ' /> AdImage: ' /> SiteId: ' /> IPAddress: Text=' ' /> ContactEmail: Text=' ' /> AdCategory: Text=' ' /> AdEntryDate: Text=' ' /> UserId: ' /> Contactcell: Text=' ' /> ContactAddress: Text=' ' /> Text=Insert /> Text=Clear /> ShowNextPageButton=False ShowPreviousPageButton=False /> ShowNextPageButton=False ShowPreviousPageButton=False /> AdId: ' /> Locality: Text=' ' /> AdTitle: ' /> AdDescription: Text=' ' /> AdKeywords: Text=' ' /> AdImage: ' /> SiteId: ' /> IPAddress: Text=' ' /> ContactEmail: Text=' ' /> AdCategory: Text=' ' /> AdEntryDate: Text=' ' /> UserId: ' /> Contactcell: Text=' ' /> ContactAddress: Text=' ' /> Text=Update /> Text=Cancel /> AdId: ' /> Locality: ' /> AdTitle: ' /> AdDescription: Text=' ' /> AdKeywords: Text=' ' /> AdImage: ' /> SiteId: ' /> IPAddress: ' /> ContactEmail: Text=' ' /> AdCategory: Text=' ' /> AdEntryDate: Text=' ' /> UserId: ' /> Contactcell: Text=' ' /> ContactAddress: Text=' ' /> ConnectionString=  SelectCommand=SELECT * FROM [ClassifiedAds] UpdateCommand =UPDATE [ClassifiedAds] SET [ContactEmail]=@ContactEmail [AdTitle]=@AdTitle [AdImage]=@AdImage [ContactAddress]=@ContactAddress [IPAddress]=@IPAddress [Locality]=@Locality [AdKeywords]=@AdKeywords [UserId]=@UserId [AdDescription]=@AdDescription [AdCategory]=@AdCategory [Contactcell]=@Contactcell where [AdId]=@AdId DeleteCommand =DELETE FROM [ClassifiedAds] where [AdId]=@AdId>

Prabhakar Reddy · Answer

Ads Posting Page code: .padding { padding-bottom:30px; padding-left:10px; } Public Function GetConnectionString() As String 'sets the connection string from your web config file ConnString is the name of your Connection String Return System.Configuration.ConfigurationManager.ConnectionStrings(ClassifiedsHHConnectionString).ConnectionString End Function Dim conn As New SqlConnection(GetConnectionString()) Dim cmdlist As SqlCommand Dim da As SqlDataAdapter Dim ds As New DataSet() Protected Sub Page_Load(ByVal sender As Object ByVal e As EventArgs) If Not IsPostBack Then End If End Sub 'Private Sub ExecuteInsert(ByVal Email As String ByVal Locality As String ByVal Category As String ByVal Title As String ByVal Description As String ByVal Keywords As String) Protected Sub Button1_Click(ByVal sender As Object ByVal e As EventArgs) If imageupload.PostedFile IsNot Nothing AndAlso imageupload.PostedFile.FileName  Then Dim imageSize As Byte() = New Byte(imageupload.PostedFile.ContentLength - 1) {} Dim uploadImage As HttpPostedFile = imageupload.PostedFile uploadImage.InputStream.Read(imageSize 0 Int(imageupload.PostedFile.ContentLength)) Dim con As New SqlConnection(ConfigurationManager.ConnectionStrings(ClassifiedsHHConnectionString).ConnectionString) Dim sql As String = INSERT INTO ClassifiedAds (AdIdContactEmailLocality AdCategory AdTitleAdEntryDateContactcellUserId AdDescriptionAdKeywordsAdImageContactAddressIPAddress) VALUES  &  (@AdId@ContactEmail@Locality @AdCategory @AdTitle@AdEntryDate@Contactcell@UserId @AdDescription@AdKeywords@AdImage@ContactAddress@IPAddress) 'Try conn.Open() Dim cmd As New SqlCommand(sql conn) 'Dim param As SqlParameter() = New SqlParameter(6) {} 'param[0] = new SqlParameter(@id SqlDbType.Int 20); 'param(0) = New SqlParameter(@Email SqlDbType.VarChar 50) 'param(1) = New SqlParameter(@Locality SqlDbType.VarChar 50) 'param(2) = New SqlParameter(@Category SqlDbType.VarChar 50) 'param(3) = New SqlParameter(@Title SqlDbType.VarChar 100) 'param(4) = New SqlParameter(@Description SqlDbType.VarChar 500) 'param(5) = New SqlParameter(@Keywords SqlDbType.VarChar 100) 'param(0).Value = Email 'param(1).Value = Locality 'param(2).Value = Category 'param(3).Value = Title 'param(4).Value = Description 'param(5).Value = Keywords 'For i As Integer = 0 To param.Length - 1 ' cmd.Parameters.Add(param(i)) 'Next cmd.Parameters.AddWithValue(@ContactEmail TxtEmail.Text) cmd.Parameters.AddWithValue(@Locality DropDownList1.SelectedItem.Text) cmd.Parameters.AddWithValue(@AdCategory LstCategory.SelectedItem.Text) cmd.Parameters.AddWithValue(@AdTitle TxtTitle.Text) cmd.Parameters.AddWithValue(@AdDescription FreeTextBox1.Text) cmd.Parameters.AddWithValue(@AdKeywords TxtKeywords.Text) cmd.Parameters.AddWithValue(@ADImage SqlDbType.Image) cmd.Parameters.AddWithValue(@AdEntryDate DateTime.Now.ToString) cmd.Parameters.AddWithValue(@Contactcell TxtCell.Text) cmd.Parameters.AddWithValue(@ContactAddress TxtAddress.Text) cmd.Parameters.AddWithValue(@UserId TxtUserId.Text) cmd.Parameters.AddWithValue(@IPAddress txtIPaddress.Value = Request.Url.AbsoluteUri.ToString) cmd.CommandType = CommandType.Text cmd.ExecuteNonQuery() Response.Write(Inserted Successfully!       ) Response.Write(Request.Url.AbsoluteUri) 'Catch ex As Exception 'Response.Write(ex .sqlexcepion) conn.Close() ClearTextBox(Me) 'End Try End If 'call the method to execute insert to the database 'ExecuteInsert(TxtEmail.Text DropDownList1.SelectedItem.Text LstCategory.SelectedItem.Text TxtTitle.Text FreeTextBox1.Text TxtKeywords.Text) 'Response.Write(Record was successfully added!) 'ClearControls(Page) End Sub Public Sub ClearTextBox(ByVal root As Control) For Each ctrl As Control In root.Controls ClearTextBox(ctrl) If TypeOf ctrl Is TextBox Then CType(ctrl TextBox).Text = String.Empty End If Next ctrl End Sub function Validate() { if (document.getElementById( ).value == ) { alert(Email id can not be blank); document.getElementById( ).focus(); return false; } var emailPat = /^(([^ ()[\]\.;:\s@\]+(\.[^ ()[\]\.;:\s@\]+)*)|(\.+\))@(($$[0-9]{13}\.[0-9]{13}\.[0-9]{13}\.[0-9]{13}$$)|(([a-zA-Z\-0-9]+\.)+[a-zA-Z]{2}))$/; var emailid = document.getElementById( ).value; var matchArray = emailid.match(emailPat); if (matchArray == null) { alert(Your email address seems incorrect. Please try again.); document.getElementById( ).focus(); return false; } if (document.getElementById( ).value == ) { alert(Locality cannot be blank); document.getElementById( ).focus(); return false; } if (document.getElementById( ).value == ) { alert(Category Cannot be Blank.); document.getElementById( ).focus(); return false; } if (document.getElementById( ).value == ) { alert(Title cannot be blank); document.getElementById( ).focus(); return false; } } Please DO NOT post multiple ads for the same items or service. All duplicate spam and wrongly categorized ads will be deleted. google_ad_client = pub-8032204952597608; /* 120x600 created 3/13/08 */ google_ad_slot = 1169687000; google_ad_width = 120; google_ad_height = 600; //--> src=http://pagead2.googlesyndication.com/pagead/show_ads.js> google_ad_client = pub-8032204952597608; /* 728x90 created 4/27/11 */ google_ad_slot = 5041571760; google_ad_width = 728; google_ad_height = 90; //--> src=http://pagead2.googlesyndication.com/pagead/show_ads.js> User Id : Email : Locality : Select   Locality Hyderabad Secenderabad Narayanaguda Tarnaka Uppal Contact Number : Contact Address : Select Category : Select Category Items Electronic/Computers Home & Household Services Jobs Arts & Entertainment Business & Retail Automobiles Toys Kids & Babies Tours & Travels Education & Learning Health & Sports Clothing & Jewelry Pets & Petcare Beauty & Selfcare Food & Beverage Michinery Movies Music & Games Events & Community Personals Real Estate Title : Description : Upload Image : Related Keywords : google_ad_client = pub-8032204952597608; /* 120x600 created 3/13/08 */ google_ad_slot = 1169687000; google_ad_width = 120; google_ad_height = 600; //--> src=http://pagead2.googlesyndication.com/pagead/show_ads.js>

Prabhakar Reddy · Answer

This is my Database Name :Classifieds This is my table name and query. Create table ClassifiedAds(AdId int primary key identity(11) Not null SiteId varchar(10) IPAddress varchar(40) ContactEmail Varchar(50) Locality Varchar(50) AdCategory Varchar (50) AdTitle Varchar(100) AdDescription Varchar(Max) AdKeywords Varchar(100) AdEntryDate datetime AdImage ImageUserId varchar(40)Contactcell varchar(15) ContactAddress varchar(100))

Prabhakar Reddy · Answer

Ya yes am storing image in my application and image data type i used...

Shivanand Arur · Answer

Are u trying to store an image in your application??? If yes then what data type are you using at the backend for storing the image? And also check the order of the column names in which u are storing your information... (In the insert query!!!) If possible then post your code here so that we can understand it better. Thanks!!!

Shivanand Arur · Answer

Can u post your entire code here so that I could understand it better!!! Also list down the column names of your database table along with its datatype...