how to add stored procedures from c# application?

Question

0.00/5 (No votes)

See more:

I have folder which has stored procedures . I want to create one c# form application where "add" button, "database name" , "server name" and browse for " stored procedures file location" are the inputs. The task i want to do is when i fill "dbname" , "servername" and browse folder of stored procedures. and click "add" button , all stored procedures from folder gets add to stored procedure folder of database.
Is this possible?

if yes ,Suggest me ways to achieve this task.
thanks !

edited :
code below

C#

SqlConnection con = new SqlConnection("myconstring");
              string filePath = txtsend.Text +"\\";
          string[] files = Directory.GetFiles((filePath));

          foreach (string path in files)
          {
              string proc = File.ReadAllText(path);

              SqlCommand cmd = new SqlCommand(proc,con);

               con.Open();
               cmd.ExecuteNonQuery();
               MessageBox.Show("procedures added");
               con.Close();
           }
         }

Posted 29-Oct-15 20:12pm

Member 11543226

Updated 30-Oct-15 21:39pm

v2

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)

**Debojyoti Saha** · Answer 1 · 2015-10-29T20:30:00

Solution 1

Yes, Its possible and simple.
Just read the all files into the folder one by one and execute the file string into database.

C#

string[] filePaths = Directory.GetFiles(Server.MapPath("your Procedure folder path"));
foreach (string filePath in filePaths)
{
     string proc= File.ReadAllText(filePath);
     //Connect DataBase
     //Pass the "proc" string on executenonquery() methode.
}

Posted 29-Oct-15 20:30pm

Debojyoti Saha

Comments

Member 11543226 30-Oct-15 7:15am

it works for some procedures but shows error for some "incorrect syntax near GO" , but all procedures does fine job.

Dave Kreskowiak 30-Oct-15 9:22am

You cannot use GO in the scripts if you execute the from your code.

You have to remove those lines from the scripts before you execute them.

Member 11543226 31-Oct-15 2:56am

I remove go and all now program run succsessfully but procedures not added to database

Naveen.Sanagasetti · Answer 2 · 2015-10-30T02:41:00

Solution 2

Yes, It's possible.

As per your comment it's working for few procedures and for few it's throwing some error?

Then which are the procedures you got error, those procedures contains some syntactical errors. Please resolve those first and then execute your application.

Posted 30-Oct-15 2:41am

Naveen.Sanagasetti

Comments

Member 11543226 31-Oct-15 3:34am

No errors in procedures when i execute it from managment studio it executes without errors but from program it not added to database->programmability->stored procedure