473,407 Members | 2,326 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,407 software developers and data experts.

How to create a Stored Procedure programmatically using C#

Hi every one I have tried to search for any links, hints clues on how to
create a Stored Procedure programmatically using C# but came back with empty
handed :-(
I know it is definitly possible (i.e. what the Query Analyzer can do).
I will appreciate any help.
thanks

Abdulla
Jul 21 '05 #1
3 9006
Abdullah,

Just create the SQL strings and execute those using the executenonquerry

I hope this helps?

Cor
Hi every one I have tried to search for any links, hints clues on how to
create a Stored Procedure programmatically using C# but came back with
empty handed :-(
I know it is definitly possible (i.e. what the Query Analyzer can do).
I will appreciate any help.
thanks

Jul 21 '05 #2
Hi Abdullah

Do you mean to create a stored procedure for a table? If yes, you can refer
to the Code Smith site (http://www.ericjsmith.net/codesmith/default.aspx).
The tool is a templated based code generator which will also gives the Stored
Procedure outputs.

Regards
Sooraj
Microsoft Community Star

"Abdulla Herzallah" wrote:
Hi every one I have tried to search for any links, hints clues on how to
create a Stored Procedure programmatically using C# but came back with empty
handed :-(
I know it is definitly possible (i.e. what the Query Analyzer can do).
I will appreciate any help.
thanks

Abdulla

Jul 21 '05 #3
Check out
http://www.c-sharpcorner.com/Code/20...icDatabase.asp
Sijin Joseph
http://www.indiangeek.net
http://weblogs.asp.net/sjoseph
Abdulla Herzallah wrote:
Hi every one I have tried to search for any links, hints clues on how to
create a Stored Procedure programmatically using C# but came back with empty
handed :-(
I know it is definitly possible (i.e. what the Query Analyzer can do).
I will appreciate any help.
thanks

Abdulla

Jul 21 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

9
by: Lauren Quantrell | last post by:
Is there a way to create a text file (such as a Windows Notepad file) by using a trigger on a table? What I want to do is to send a row of information to a table where the table: tblFileData has...
4
by: MD | last post by:
I am trying to create a dynamic SQL statement to create a view. I have a stored procedure, which based on the parameters passed calls different stored procedures. Each of this sub stored procedure...
10
by: serge | last post by:
I can not create a stored procedure that calls another not yet created stored procedure? In MS SQL I get a warning that the calling procedure does not exist but the new stored Procedure gets...
3
by: Abdulla Herzallah | last post by:
Hi every one I have tried to search for any links, hints clues on how to create a Stored Procedure programmatically using C# but came back with empty handed :-( I know it is definitly possible...
2
by: Chris | last post by:
I installed SQLServer 2005 Standard Edition and tried to created a stored procedure in VB. From START/PROGRAMS/MICROSOFT VISUAL STUDIO 2005, I created a blank solution. What type of project shall I...
10
by: J. S. EDV | last post by:
Hello, I have got a little problem with stored procedures and C#. I have got a stored procedure which should only insert something in a table. For example: ALTER PROCEDURE DBO.PROC1 AS...
2
by: Mukesh | last post by:
Hi all I m Using SQL SERVER 2005 I have a requirement to store some data in xmldatatype using stored procedure , Here is example
6
by: Shiller | last post by:
I want my application to create a new database/tables when run for the first time. I have created a stored procedure to create the new database named "budget". When I run the stored procedure, it...
11
by: raylopez99 | last post by:
Keep in mind this is my first compiled SQL program Stored Procedure (SP), copied from a book by Frasier Visual C++.NET in Visual Studio 2005 (Chap12). So far, so theory, except for one bug...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.