Update Table on SQL Server from Windows console Program

Question

0.00/5 (No votes)

See more:

SQL-Server-2008R2

Hello All,

i am trying or i am learning on how to insert/update data on SQL server.. Currently i have got database on the sql server named 'People' this db has a table called 'Persons'
the table on had an Id column and Persons name column.

What i am trying to do or learn is how i can update a persons name from windows console program. just something hard coded to say Update persons set name 'anything here' where id = 'something' .. basically what i am looking for in this how the console program has been been connected to sql server and also how its quering to the right database.
Any ideas on h ow to do this?

PS. I know sql statements and that.

Thank you for your time.

Posted 4-Dec-14 22:34pm

1Future

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Harsh Athalye · Accepted Answer · 2014-12-04T23:01:00

You need to use SqlConnection object which is passed connection string which points it to connect to the appropriate database.

Once you got connection object ready, you can create SqlCommand object which contains the actual insert/update/delete/select command to be executed.

You can do it as below:

C#

SqlConnection conn = new SQLConnection("Server=myServerAddress;Database=myDataBase;Trusted_Connection=True;");
SqlCommand cmd = new SqlCommand("update persons set name='abc' where id =2 ");
cmd.Connection = conn;
cmd.ExecuteNonQuery();

To run the above code, you need to include import System.Data.SqlClient reference in your class.

Marcin Kozub · Accepted Answer · 2014-12-04T23:05:00

Solution 2

.NET has technology called ADO.NET to handle databases. You can find many examples on how to use ADO.NET here on CodeProject.

Look at this tutorial:
A Beginner's Tutorial for Understanding ADO.NET[^]

Good luck!

Posted 4-Dec-14 23:05pm

Marcin Kozub

Comments

1Future 5-Dec-14 7:33am

thank you

Marcin Kozub 5-Dec-14 7:34am

You're welcome