Our Training Programs

View all

AI & Machine Learning
Mastering Large Language Models
Mastering Prompt Engineering
Certified Vibe Coder
Github Copilot Training
Generative AI for Beginners
n8n Automation & AI Agents Training

About Us Contact Us Privacy Policy Terms Brand Guidelines Partners C# Tutorials Consultants Ideas Report A Bug FAQs Sitemap Stories CSharp TV DB Talks Web3 Universe Jumpstart Blockchain

All contents are copyright of their authors.

how to make sql command to update ,string using vb.net?

Home
Forums
Visual Basic .NET

how to make sql command to update ,string using vb.net?

King Umar

11yAsked Aug 10, 2015, 8:25 PM2.1kVisual Basic .NET

my current sql command is like ->

but it could not read it and have error saying " invalid column name "exp : xxx"

but this is happen only to String updates not for my update for integer with the same codes..i'm using microsoft visual studio (vb.net) and sql server management studio..can anyone help

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

It is the same account you read, post and publish with — and you will come straight back to this page.

Jignesh Trivedi11y ago
Accepted answer
Hi,
I think you need to put single quote (') before and after your string value.
so code becomes
Query = "UPDATE [MISInventory].[dbo].[AddItem] SET vendorr = '" & TextBox3.Text "' where Id = " & value
hope this will help you.
Raja T11y ago
Hi, Invalid column name error means on ur table declared column name not existing please check ur columns names in db.

For updating with string using please check bellow URLs

http://www.aspsnippets.com/Articles/Using-Parameterized-queries-to-prevent-SQL-Injection-Attacks-in-SQL-Server.aspx

http://vb.net-informations.com/ado.net-dataproviders/ado.net-sqlconnection.htm

https://support.microsoft.com/en-us/kb/308055

http://www.dreamincode.net/forums/topic/54489-sql-update-statement/