update and delete parameter query

Question

0.00/5 (No votes)

See more:

following is the insert query ,i want update and delete parameter query..

VB

Dim cmdtext As String
        cmdtext = "insert into emp1([no],name,[phone],city) values (@no,@name,@phone,@city)"
        cmd = New SqlCommand(cmdtext, cn)
        cmd.Parameters.Add(New SqlParameter("@no", TextBox1.Text))
        cmd.Parameters.Add(New SqlParameter("@name", TextBox2.Text))
        cmd.Parameters.Add(New SqlParameter("@phone", TextBox3.Text))
        cmd.Parameters.Add(New SqlParameter("@city", TextBox4.Text))
        cmd.ExecuteNonQuery()

Posted 23-Feb-11 19:35pm

sima2011

Add a Solution

1 solution

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)

Prerak Patel · Answer 1 · 2011-02-23T19:39:00

Solution 1

VB

cmdtext = "update emp1 set name=@name,[phone]=@phone,city=@city where [no]=@no"
        cmd = New SqlCommand(cmdtext, cn)
        cmd.Parameters.Add(New SqlParameter("@no", TextBox1.Text))
        cmd.Parameters.Add(New SqlParameter("@name", TextBox2.Text))
        cmd.Parameters.Add(New SqlParameter("@phone", TextBox3.Text))
        cmd.Parameters.Add(New SqlParameter("@city", TextBox4.Text))
        cmd.ExecuteNonQuery()

MIDL

cmdtext = "delete from emp1 where [no]=@no"
        cmd = New SqlCommand(cmdtext, cn)
        cmd.Parameters.Add(New SqlParameter("@no", TextBox1.Text))
        cmd.ExecuteNonQuery()

Posted 23-Feb-11 19:39pm

Prerak Patel

Comments

sima2011 24-Feb-11 1:47am

thank you prerak sir tell me 1 thing,what is the benefit of using parameters query??

Prerak Patel 24-Feb-11 1:54am

mainly to prevent sql injection

Obaid Ahmed 24-Feb-11 2:05am

parameters is for like a argument variables for sql query or you can say that, it is use for binding table's column with our giving variables for input through query

sima2011 24-Feb-11 2:09am

how do i write query in class ,and how do i call them in button click??? please help me

Obaid Ahmed 24-Feb-11 2:18am

what do you mean by query in class ??
above code is, for a class for executing the sql commands from csharp or asp.net
what else you need?

sima2011 24-Feb-11 2:33am

but i directly write code on button..thanks for it,how do i call it in button?after creating insert obj??

Obaid Ahmed 24-Feb-11 2:40am

hmmm OK.. you need full working code :)
give me awhile, i Google for you!

Obaid Ahmed 24-Feb-11 2:57am

go at here, and read full thread
http://social.msdn.microsoft.com/Forums/en/csharpgeneral/thread/91bd10ce-c83b-4766-920b-2137ddc29908

sima2011 24-Feb-11 3:04am

yes Mr ahmed i need full working code..thanx for suggest class code mention above.now how to call them in button click event?