Click here to Skip to main content
13,145,068 members (56,245 online)
Rate this:
Please Sign up or sign in to vote.
See more:
Hi Everyone,

Consider i have a webpage with two textboxes and one button.
If i enter Spname,EmpName,EmpSalary in the textboxes and click on Save then
An sp should be created in the Sqlserver with Spname and should have a select
statement in the sp.

Is it possible?

Thanks All
Awaiting your response....
Posted 10-May-13 18:17pm

1 solution

Rate this: bad
Please Sign up or sign in to vote.

Solution 1

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.Sql;
using System.Data.SqlClient;
namespace ConsoleApplication1
    class Program
        static void Main(string[] args)
            string __conStr = @"Data Source=(local)\S2005;Initial Catalog=Demo;Integrated Security=SSPI";
            using (SqlConnection con = new SqlConnection(__conStr))
                string __spName = "MyUsp";
                string __tblName = "Customers";
                string __sQuery = "";
                __sQuery += "CREATE PROCEDURE " + __spName + "\r\nAS\r\n";
                __sQuery += "Begin\r\n";
                __sQuery += "SELECT * FROM " + __tblName + "\r\n";
                __sQuery += "End\r\n";
                SqlCommand cmd = con.CreateCommand();
                cmd.CommandType = CommandType.Text;
                cmd.CommandText = __sQuery;
                catch { }
debkumar@codeproject 11-May-13 6:29am
We should avoid such DDL statements from UI. This could be a security threat.

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

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy |
Web01 | 2.8.170915.1 | Last Updated 11 May 2013
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100