how to update sql server table from c sharp

Question

0.00/5 (No votes)

See more:

i have one stored procedure name "proc_function"

with three arguments

@u_id
@u_name
@u_ip

and now from c sharp i have to update my table by "proc_function"

here is the code which i wrote it but i don't know what to do next to

update my table

sql_string = ("Data Source=23423423423;Initial Catalog=sdfgsdf;User Id=dsfsdsa;Password=sdfsdf;");
 SqlConnection conn = new SqlConnection(sql_string);
 SqlCommand command = new SqlCommand("proc_function", conn);
 conn.Open();
 command.CommandType = CommandType.StoredProcedure;
 command.Parameters.AddWithValue("@usd", u_id);
 command.Parameters.AddWithValue("@uname", u_name );
 command.Parameters.AddWithValue("@uip", local_ip);

what to do next ...............

Posted 16-Jul-11 21:12pm

kami124

Updated 16-Jul-11 21:35pm

thatraja

v2

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)

RaisKazi · Accepted Answer · 2011-07-16T21:19:00

Solution 1

Write this below your code. It should then work.

command.ExecuteNonQuery();
command.Dispose();
conn.Close();

Posted 16-Jul-11 21:19pm

RaisKazi

Comments

kami124 17-Jul-11 3:42am

no, its still not working
what to do

walterhevedeich 17-Jul-11 3:51am

Dont just say its not working. Instead, specify the error messages you are getting, if any. A statement like 'its not working' without any details wont bring you much help.

kami124 17-Jul-11 4:02am

here is the error
execute a transact SQL statements against the connection and returns the number of rows effected

Uday P.Singh 17-Jul-11 4:51am

Its not an error message: this is the description what ExecuteNonQuery() does. Post your error message or you can take the screenshot when error occurs and post that screenshot, then we can help you properly

RaisKazi 17-Jul-11 4:54am

Agree with Uday.

kami124 17-Jul-11 4:03am

here is my stored procedure

USE [GCERP_SEC]
GO
/****** Object: StoredProcedure [dbo].[proc_userinfo] Script Date: 07/17/2011 08:04:30 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER procedure [dbo].[proc_userinfo] (@uid nvarchar(50),@uname nvarchar (50), @uip nvarchar (50) )
as
INSERT INTO [GCERP_SEC].[dbo].[sec_users]
([userid_vc]
,[username_vc]
,[createdby_vc]
,[creationdate_dt]
,[modifiedby_vc]
,[modificationdate_dt]
,[ipadd_vc]
,[pcname_vc])
VALUES
(@uid, @uname, @uname, GETDATE(), @uname,GETDATE(),@uip, HOST_NAME())

RaisKazi 17-Jul-11 4:33am

1) Your Procedure is having parameter "@uid" whereas in code you have specified it as "@usd".
2)Make sure your Insert query is correct.

kami124 17-Jul-11 4:37am

ya its correct it was mistake here
in my code its correct

RaisKazi 17-Jul-11 4:40am

Cheers. Please don't forget to "Accept Answer" if it helps you.

RaisKazi 17-Jul-11 4:41am

So now your code is working or not?

kami124 17-Jul-11 4:49am

no the problem is still there
i told you that its not a mistake in my code i wrote correct over there
but here i didnt write correct
in my code its already "@uid" in cs and in sp
problem is some where else
offcourse i will cheers and your answer if i got the solution

RaisKazi 17-Jul-11 4:52am

Could you please make correction in your Question then? Because you may get same reply from other CodeProject readers also.

kami124 17-Jul-11 4:54am

ok
ok please
here is my stored procedure

USE [GCERP_SEC]
GO
/****** Object: StoredProcedure [dbo].[proc_userinfo] Script Date: 07/17/2011 08:04:30 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER procedure [dbo].[proc_userinfo] (@uid nvarchar(50),@uname nvarchar (50), @uip nvarchar (50) )
as
INSERT INTO [GCERP_SEC].[dbo].[sec_users]
([userid_vc]
,[username_vc]
,[createdby_vc]
,[creationdate_dt]
,[modifiedby_vc]
,[modificationdate_dt]
,[ipadd_vc]
,[pcname_vc])
VALUES
(@uid, @uname, @uname, GETDATE(), @uname,GETDATE(),@uip, HOST_NAME())

what code i have to write in c sharp to update my table,

Espen Harlinn 17-Jul-11 16:45pm

Great effort, I get the feeling we are going to see a lot of good answers from you :)