The data types text and varchar are incompatible in the equal to operator in C#

You can’t compare text to varchar, but as an answer to anyone in the future with this problem simply convert the text column to varchar for the query.

SELECT * FROM  EmployeeTable WHERE CONVERT(VARCHAR, empname) = '" + comboBox1.Text + "' ;";

Always use parameters

SELECT * FROM  EmployeeTable WHERE CONVERT(VARCHAR, empname) = @comboBox";

Related Posts:

  1. What is a NullReferenceException, and how do I fix it?
  2. How do I get a random YouTube video with the YouTube API?
  3. How can I convert String to Int?
  4. What is a NullReferenceException, and how do I fix it?
  5. CS0120: An object reference is required for the nonstatic field, method, or property ‘foo’
  6. How to find child of a GameObject or the script attached to child GameObject via script
  7. Process cannot access the file because it is being used by another proess
  8. How to convert JSON to XML or XML to JSON?
  9. Virustotal Trapmine suspicious.low.ml.score
  10. Convert int to string?
  11. Unity OnTriggerEnter2D not registering
  12. How to Sort a List by a property in the object
  13. The page was not displayed because the request entity is too large on IIS
  14. ‘do…while’ vs. ‘while’
  15. Visual Studio /**/ comment shortcut?
  16. Unable to resolve service for type while attempting to activate
  17. Multiple Inheritance in C#
  18. Extension methods must be defined in a non-generic static class
  19. Return multiple values to a method caller
  20. Regex that accepts only numbers (0-9) and NO characters
  21. How to resolve this System.IO.FileNotFoundException
  22. Associating enums with strings in C#
  23. Fire ontextchanged() event of an asp:TextBox via Javascript
  24. Proper Linq where clauses
  25. Validation failed for one or more entities. See ‘EntityValidationErrors’ property for more details
  26. How to resolve this System.IO.FileNotFoundException
  27. What is the best way to implement a “timer”?
  28. C# Gridview CheckBox Field VS (Template Field + CheckBox)
  29. Extension methods must be defined in a non-generic static class
  30. Convert char to int in C#
  31. SmtpException: Unable to read data from the transport connection: net_io_connectionclosed
  32. The remote server returned an error: (403) Forbidden
  33. How can I get the application’s path in a .NET console application?
  34. How to add a delay for a 2 or 3 seconds
  35. Multiple file-extensions searchPattern for System.IO.Directory.GetFiles
  36. calling javascript function on OnClientClick event of a Submit button
  37. C# – Illegal characters in path
  38. Getting The ASCII Value of a character in a C# string
  39. Process exists with ExitCode 255
  40. What is 0x10 in decimal?
  41. Visual Studio: The Operation could not be completed. The parameter is incorrect
  42. IEnumerable vs List – What to Use? How do they work?
  43. Member ‘‘ cannot be accessed with an instance reference
  44. Sequence contains no matching element
  45. when do you need .ascx files and how would you use them?
  46. How to convert code from C# to PHP
  47. How to open a new form from another form
  48. C# – How to convert string to char?
  49. The entity type is not part of the model for the current context
  50. Recommendation for C# Matrix Library
  51. Could not load file or assembly ‘Microsoft.Web.Infrastructure,
  52. Deep cloning objects
  53. Where to place native DLL to use Pocket PC emulator?
  54. Regular expression “^[a-zA-Z]” or “[^a-zA-Z]”
  55. What is the purpose of the vshost.exe file?
  56. System.ComponentModel.Win32Exception: Access is denied Error
  57. Excel “External table is not in the expected format.”
  58. .NET graph library around?
  59. Input string was not in a correct format
  60. MSSQL Error ‘The underlying provider failed on Open’
  61. An object reference is required to access a non-static member
  62. Verify a method call using Moq
  63. XmlSerializer – There was an error reflecting type
  64. How to download a file from a URL in C#?
  65. Run Command Prompt Commands
  66. Cannot implicitly convert type ‘System.Collections.Generic.List< >‘ to ‘System.Collections.Generic.IList< >‘
  67. Calculate a MD5 hash from a string
  68. How can I wait for a thread to finish with .NET?
  69. The model item passed into the dictionary is of type .. but this dictionary requires a model item of type
  70. How can I get the active screen dimensions?
  71. WebException (Status: Protocol Error)
  72. How to add a new row to datagridview programmatically
  73. Unexpected character encountered while parsing value
  74. How do I exit a WPF application programmatically?
  75. OnCollisionEnter is not called in unity
  76. The name ‘ViewBag’ does not exist in the current context – Visual Studio 2015
  77. How can we prepend strings with StringBuilder?
  78. C# conditional operator error Only assignment, call, increment, decrement, await, and new object expressions can be used as a statement
  79. How to create a new object instance from a Type
  80. Cannot drop database because it is currently in use
  81. Troubleshooting “program does not contain a static ‘Main’ method” when it clearly does…?
  82. does not implement interface member
  83. Unity 5.2.2 changing Visual Studio back to MonoDevelop
  84. Differences between SFTP and “FTP over SSH”
  85. When should I use a List vs a LinkedList
  86. Remove punctuation from string with Regex
  87. Unity – How to stop Play Mode in case of infinite loop?
  88. Go To Definition: “Cannot navigate to the symbol under the caret.”
  89. Why am I getting an Exception with the message “Invalid setup on a non-virtual (overridable in VB) member…”?
  90. Is there a keyboard shortcut to maximize the Game window in Unity in Play Mode?
  91. IF Statement multiple conditions, same statement
  92. What is the easiest way to handle associative array in c#?
  93. What does the M stand for in C# Decimal literal notation?
  94. Iif equivalent in C#
  95. Convert an array to string
  96. Quickest way to compare two generic lists for differences
  97. What is the easiest way to encrypt a password when I save it to the registry?
  98. LINQ query on a DataTable
  99. is inaccessible due to its protection level
  100. Memory Leak caused by System.Drawing.Internal.GPStream

Leave a Comment