如何使用codebehind中的sql查询为数据库创建数据库，表和存储过程以及用户定义的函数. [英] how to create database,tables and stored procedures and userdefined functions for a database using sql query from codebehind .

问题描述

如何使用c#.net从代码背后使用sqlquery为sqlserver数据库创建数据库，表和存储过程以及用户定义的函数.

how to create database,tables and stored procedures and userdefined functions for a sqlserver database using sqlquery from codebehind using c#.net.

推荐答案

要创建数据库: http://www.w3schools.com/sql/sql_create_db.asp [ http://msdn.microsoft.com/zh-cn/library/aa258259％28v = sql.80％29.aspx [ http://www.csharp-station.com/Tutorials/AdoDotNet/Lesson03 .aspx [ ^ ]

To create a database : http://www.w3schools.com/sql/sql_create_db.asp[^]

To create a stored procedure : http://msdn.microsoft.com/en-us/library/aa258259%28v=sql.80%29.aspx[^]

To execute sql commands in c# : http://www.csharp-station.com/Tutorials/AdoDotNet/Lesson03.aspx[^]

您可以构建适当的SQL语句并执行它们.有没有特定的问题?您尝试了什么?

You construct the proper SQL statements and execute them. Is there a specific problem? What have you tried?

创建数据库-

Sqlconnection con =新的SqlConnection();
con.ConnectionString ="SERVER = FTCPU2144; DATABASE =主服务器；
用户ID = sa; Pwd = sa;
con.Open();
字符串sCreateDataBase ="CREATE DATABASE db_DataBase";
SqlCommand cmd =新的SqlCommand(sCreateDataBase，con);
cmd.ExecuteNonQuery();

创建表-

Sqlconnection con =新的SqlConnection();
con.ConnectionString ="SERVER = FTCPU2144; DATABASE =主服务器;
用户ID = sa; Pwd = sa;
con.Open();
字符串sCreateDataBase =创建表tb_Test(n_Id int，s_Name VARCHAR(20))";
SqlCommand cmd =新的SqlCommand(sCreateDataBase，con);
cmd.ExecuteNonQuery();


创建表-

Sqlconnection con =新的SqlConnection();
con.Open();
字符串sCreateDataBase =创建表tb_Test(n_Id int，s_Name VARCHAR(20))";
SqlCommand cmd =新的SqlCommand(sCreateDataBase，con);
cmd.ExecuteNonQuery();

要创建存储过程，请通过belo链接

http://msdn.microsoft.com/zh-cn/library/zxsa8hkf(v=vs.80).aspx

要使用户定义的功能"蔓延，请通过下面的链接

http://msdn.microsoft.com/zh-cn/library/w2kae45k(v = vs.80).aspx

To Create Data Base-

Sqlconnection con=new SqlConnection();
con.ConnectionString = "SERVER = FTCPU2144; DATABASE = master;
User ID = sa; Pwd = sa";
con.Open();
string sCreateDataBase="CREATE DATABASE db_DataBase";
SqlCommand cmd=new SqlCommand(sCreateDataBase,con);
cmd.ExecuteNonQuery();

To Create Tables-

Sqlconnection con=new SqlConnection();
con.ConnectionString ="SERVER = FTCPU2144; DATABASE = master;
User ID = sa; Pwd = sa";
con.Open();
string sCreateDataBase="CREATE TABLE tb_Test(n_Id int,s_Name VARCHAR(20) )";
SqlCommand cmd=new SqlCommand(sCreateDataBase,con);
cmd.ExecuteNonQuery();


To Create Tables-

Sqlconnection con=new SqlConnection();
con.Open();
string sCreateDataBase="CREATE TABLE tb_Test(n_Id int,s_Name VARCHAR(20) )";
SqlCommand cmd=new SqlCommand(sCreateDataBase,con);
cmd.ExecuteNonQuery();

To Create Stored Procedures go through the belo link

http://msdn.microsoft.com/en-us/library/zxsa8hkf(v=vs.80).aspx

To Craete User Defined functions go through below link

http://msdn.microsoft.com/en-us/library/w2kae45k(v=vs.80).aspx

这篇关于如何使用codebehind中的sql查询为数据库创建数据库，表和存储过程以及用户定义的函数.的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！