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 (AdId,ContactEmail,Locality, AdCategory, AdTitle,AdEntryDate,Contactcell,UserId, AdDescription,AdKeywords,AdImage,ContactAddress,IPAddress) 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]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}$$)|(([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(1,1) 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 Image,UserId 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...

Operand type clash: nvarchar is incompatible with image

Answers (10)