C# insert into two tables using a procedure

Question

0.00/5 (No votes)

See more:

Hello,

How can I insert data from a C# form into two tables using a procedure? I've created this procedure:

SQL

create or replace procedure insereaza
(den_furnizor varchar2, den_banca varchar2, explicate VARCHAR2, suma_facturata NUMBER) is
sqlstmt varchar2(4000);
begin

sqlstm:= insert into comanda (den_furnizor, den_banca)
          values (|| den_furnizor, den_banca||);
execute sqlstmt;
commit;

sqlstm:= insert into tabela2 (explicatie, suma_facturata)
values (|| explicate, suma_facturata||);

execute sqlstmt;
commit;

end insereaza;

But I don't know how I can run this stored procedure from my Windows Form. The parameters are also textbox in my form.

Posted 24-May-10 4:45am

kripco

Updated 26-May-10 5:44am

Deeksha Shenoy

v4

Add a Solution

3 solutions

Solution 3

SqlConnection con=new SqlConnection("Specify ConnectionString");
con.open();
SqlCommand cmd=new SqlCommand();
cmd.Connection=con;
cmd.CommandType=CommandType.StoredProcedure;
cmd.CommandText="Stored Procedure Name";
SqlParameter[] param=new SqlParamter[4]; -- Define Parameter size
param[0]=new SqlParameter("@ParamterName",textbox1.Text);
same as Param[1],Param[2],Param[3], as.. so on
cmd.Paramter.AddRange(param);
then
int result=cmd.executenonquery();
then it will return 1 if result is inserted.

hope it will help u.

Thanks

Lalit Kumar
India

Posted 26-May-10 5:05am

Lalit Kumar 5733

Comments

Husain Ahmad Khalid 27-May-10 5:28am

Sorry Kumar Jee,

Your code will not work for him, he is not using Microsoft SQL Server, if you can observe from his code probably he is using MySql, so instead of SqlConnection class he can use MySqlConnection class which is a separate library and he can download it from http://www.mysql.com

Thanks

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)

Abhinav S · Accepted Answer · 2010-05-24T05:13:00

Solution 1

If you want to use ODBC, see here.

Posted 24-May-10 5:13am

Abhinav S

#realJSOP · Accepted Answer · 2010-05-24T05:13:00

Solution 2

Yes, you can call a stored procedure from any .Net app that has the correct references added to it.

Specifically, you need to look up the SqlConnection, SqlCommand, and SqlParameter classes. Google is your friend.

Posted 24-May-10 5:13am

#realJSOP