Click here to Skip to main content
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 19:17pm
waj1206681

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 OriginalGriff 390
1 Jochen Arndt 150
2 Richard MacCutchan 135
3 DamithSL 95
4 Garth J Lancaster 90
0 OriginalGriff 6,045
1 DamithSL 4,601
2 Maciej Los 4,087
3 Kornfeld Eliyahu Peter 3,480
4 Sergey Alexandrovich Kryukov 3,260


Advertise | Privacy | Mobile
Web03 | 2.8.141220.1 | Last Updated 11 May 2013
Copyright © CodeProject, 1999-2014
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