Click here to Skip to main content
11,640,297 members (66,568 online)
Rate this: bad
good
Please Sign up or sign in to vote.
See more: C# ASP.NET VB.NET
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
waj1206712

1 solution

Rate this: bad
good
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))
            {
                con.Open();
 
                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;
 
                try
                {
                    cmd.ExecuteNonQuery();
                }
                catch { }
 
                con.Close();
            }
        }
    }
}
  Permalink  
Comments
debkumar@codeproject at 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
0 Suvendu Shekhar Giri 225
1 CPallini 192
2 Mika Wendelius 188
3 F-ES Sitecore 150
4 Sergey Alexandrovich Kryukov 139


Advertise | Privacy | Mobile
Web01 | 2.8.150731.1 | Last Updated 11 May 2013
Copyright © CodeProject, 1999-2015
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