?? createdb.cs
字號:
using System;
using System.Data;
using System.Data.SqlClient ;
namespace Final_Project_Alpha
{
/// <summary>
/// Summary description for createdb.
/// </summary>
public class createdb
{
connect objconn = new connect();
public createdb()
{
//
// TODO: Add constructor logic here
//
}
public void create_user_db(String name)
{
try
{
string dbname = name;
dbname +="_ticket";
objconn.openDb();
string query = "CREATE TABLE " + dbname + " ( [ticket_id] [varchar](35)PRIMARY KEY CLUSTERED ,"+
"[post_date] [varchar](15),[post_time] [varchar](15),"+
"[description] [varchar](100),"+
"[dept] [varchar] (15) REFERENCES department(department_name),"+
"[category] [varchar] (15) REFERENCES category(category_name),"+
"[sub_category] [varchar] (30) REFERENCES sub_category(sub_category_name),"+
"[priority] [varchar](10),[assigned_to] [varchar](15),"+
"[status] [varchar] (15),"+
"[gname] [varchar](15) REFERENCES groups(group_name),"+
"[action_id] [varchar] (20)REFERENCES actions(action_id))";
SqlConnection cr_conn = objconn.conn();
cr_conn.Open();
SqlCommand dbcomm = new SqlCommand(query,cr_conn);
dbcomm.ExecuteNonQuery();
cr_conn.Close();
}
catch (Exception ex)
{
Console.Write("Create Error: " + ex.Message ) ;
}
}
}
}
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -