using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Data.SqlClient;
public partial class al : System.Web.UI.Page
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["CMSConnectionString"].ToString());
SqlConnection con2 = new SqlConnection(ConfigurationManager.ConnectionStrings["CMSConnectionString"].ToString());
protected void Page_Load(object sender, EventArgs e)
{
lblfinish.Text = "";
try
{
//SqlCommand cmd = new SqlCommand("CREATE TABLE [dbo].[tbl_StuShow]([Code] [int] IDENTITY(1,1) NOT NULL,[Name] [nvarchar](150) COLLATE Arabic_CI_AS NOT NULL,[Stu_Email] [nvarchar](150) COLLATE Arabic_CI_AS NULL,[Stu_No] [nvarchar](50) COLLATE Arabic_CI_AS NOT NULL,[Stu_Uni] [int] NOT NULL ,[Stu_Fac] [int] NOT NULL,[Stu_Level] [int] NOT NULL,[Stu_AutoDate] [datetime] NOT NULL CONSTRAINT [DF_StuShow_Stu_AutoDate] DEFAULT (getdate()),CONSTRAINT [PK_StuShow] PRIMARY KEY CLUSTERED ([Code] ASC)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]) ON [PRIMARY]" +
// " " +
// " ", con);
//con.Open();
//cmd.ExecuteNonQuery();
//lblfinish.Text += "Table Added tbl_StuShow";
//con.Close();
//SqlCommand cmdi = new SqlCommand("CREATE TABLE [dbo].[Pro_StuShow]([Code] [int] IDENTITY(1,1) NOT NULL,[Stu_No] [int] NOT NULL ,[Pro_No] [int] NOT NULL,[Stu_AutoDate] [datetime] NOT NULL CONSTRAINT [DF_Pro_StuShow_Stu_AutoDate] DEFAULT (getdate()),CONSTRAINT [PK_Pro_StuShow] PRIMARY KEY CLUSTERED ([Code] ASC)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]) ON [PRIMARY] " +
// " " +
// " ", con);
//con.Open();
//cmdi.ExecuteNonQuery();
//lblfinish.Text += "
Table Added Pro_StuShow";
//con.Close();
//SqlCommand cmd22 = new SqlCommand("CREATE TABLE [dbo].[Level]([Code] [int] IDENTITY(1,1) NOT NULL,[Name] [nvarchar](150) COLLATE Arabic_CI_AS NOT NULL,[UniV] [int] NULL ,[College] [int] NULL ,CONSTRAINT [PK_Level] PRIMARY KEY CLUSTERED ([Code] ASC)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]) ON [PRIMARY]" +
// " " +
// " ", con);
//con.Open();
//cmd22.ExecuteNonQuery();
//lblfinish.Text += "
Table Added Level";
//con.Close();
//SqlCommand cmdi1 = new SqlCommand("CREATE TABLE [dbo].[tbl_WordTranslate]( [Code] [int] IDENTITY(1,1) NOT NULL, [Le_No] [int] NOT NULL, [Le_AutoDate] [datetime] NULL CONSTRAINT [DF_tbl_WordTranslate_Le_AutoDate] DEFAULT (getdate()), [Le_Month] [nvarchar](50) COLLATE Arabic_CI_AS NULL, [Le_Year] [nvarchar](50) COLLATE Arabic_CI_AS NULL, [Le_User] [int] NOT NULL, CONSTRAINT [PK_tbl_WordTranslate] PRIMARY KEY CLUSTERED ( [Code] ASC)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]) ON [PRIMARY]" +
// " " +
// " ", con);
//con.Open();
//cmdi1.ExecuteNonQuery();
//lblfinish.Text += "
Table Added tbl_WordTranslate";
//con.Close();
//SqlCommand cmdieeee = new SqlCommand("CREATE TABLE [dbo].[tbl_Youtube]( [Code] [int] IDENTITY(1,1) NOT NULL, [Le_No] [int] NOT NULL, [Le_AutoDate] [datetime] NULL CONSTRAINT [DF_tbl_Youtube_Le_AutoDate] DEFAULT (getdate()), [Le_Month] [nvarchar](50) COLLATE Arabic_CI_AS NULL, [Le_Year] [nvarchar](50) COLLATE Arabic_CI_AS NULL, [Le_User] [int] NOT NULL, CONSTRAINT [PK_tbl_Youtube] PRIMARY KEY CLUSTERED ( [Code] ASC)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]) ON [PRIMARY]" +
// " " +
// " ", con);
//con.Open();
//cmdieeee.ExecuteNonQuery();
//lblfinish.Text += "
Table Added tbl_Youtube";
//con.Close();
// SqlCommand cmd2 = new SqlCommand("CREATE TABLE [dbo].[tbl_Vistival]([Code] [int] IDENTITY(1,1) NOT NULL,[Le_WName] [nvarchar](250) COLLATE Arabic_CI_AS NULL,[Le_City] [int] NOT NULL,[Le_Address] [int] NULL,[Le_No] [int] NOT NULL,[Le_Where] [nvarchar](150) COLLATE Arabic_CI_AS NOT NULL,[Le_AutoDate] [datetime] NULL CONSTRAINT [DF_tbl_Vistival_Le_AutoDate] DEFAULT (getdate()),[Le_Day] [nvarchar](50) COLLATE Arabic_CI_AS NOT NULL, [Le_Month] [nvarchar](50) COLLATE Arabic_CI_AS NULL,[Le_Year] [nvarchar](50) COLLATE Arabic_CI_AS NULL, [Le_User] [int] NOT NULL,[Le_Country] [int] NULL, CONSTRAINT [PK_tbl_Vistival] PRIMARY KEY CLUSTERED ([Code] ASC)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]) ON [PRIMARY]" +
// " ", con);
// con.Open();
// cmd2.ExecuteNonQuery();
// con.Close();
// lblfinish.Text += "
Table Added tbl_Vistival";
// SqlCommand cmd22ghghg = new SqlCommand("CREATE TABLE [dbo].[tbl_DailyCall]([Code] [int] IDENTITY(1,1) NOT NULL,[Le_WName] [nvarchar](250) COLLATE Arabic_CI_AS NULL,[Le_No] [int] NOT NULL,[Le_AutoDate] [datetime] NULL CONSTRAINT [DF_tbl_DailyCall_Le_AutoDate] DEFAULT (getdate()),[Le_Day] [nvarchar](50) COLLATE Arabic_CI_AS NOT NULL,[Le_Month] [nvarchar](50) COLLATE Arabic_CI_AS NULL,[Le_Year] [nvarchar](50) COLLATE Arabic_CI_AS NULL,[Le_User] [int] NOT NULL,CONSTRAINT [PK_tbl_DailyCall] PRIMARY KEY CLUSTERED ([Code] ASC)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]) ON [PRIMARY] " +
// " " +
// " ", con);
// con.Open();
// cmd22ghghg.ExecuteNonQuery();
// con.Close();
// lblfinish.Text += "
Table Added tbl_DailyCall";
// SqlCommand cmd22x = new SqlCommand("CREATE TABLE [dbo].[tbl_Arabic]([Code] [int] IDENTITY(1,1) NOT NULL,[Le_No_Sec] [nvarchar](50) COLLATE Arabic_CI_AS NOT NULL,[Le_No_User] [int] NOT NULL,[Le_No] [int] NOT NULL,[Le_Names] [ntext] COLLATE Arabic_CI_AS NOT NULL,[Le_AutoDate] [datetime] NULL CONSTRAINT [DF_tbl_Arabic_Le_AutoDate] DEFAULT (getdate()),[Le_Day] [nvarchar](50) COLLATE Arabic_CI_AS NOT NULL,[Le_Month] [nvarchar](50) COLLATE Arabic_CI_AS NULL,[Le_Year] [nvarchar](50) COLLATE Arabic_CI_AS NULL,[Le_User] [int] NOT NULL,CONSTRAINT [PK_tbl_Arabic] PRIMARY KEY CLUSTERED ([Code] ASC)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]" +
// " " +
//" ", con);
// con.Open();
// cmd22x.ExecuteNonQuery();
// con.Close();
// lblfinish.Text += "
Table Added tbl_Arabic";
//SqlCommand cmd22xx = new SqlCommand("Alter Table [tbl_StuShow] Add [Stu_Wechat] [nvarchar](50) COLLATE Arabic_CI_AS NULL" +
// " " +
// " ", con);
//con.Open();
//cmd22xx.ExecuteNonQuery();
//con.Close();
//lblfinish.Text += "
Alter Table tbl_StuShow Add Column Stu_Wechat";
SqlCommand cmd22xxy = new SqlCommand("DELETE FROM tbl_StuShow WHERE (Code IN (21))" +
" " +
" ", con);
con.Open();
cmd22xxy.ExecuteNonQuery();
con.Close();
lblfinish.Text += "
DELETED";
//SqlCommand cmd22xxx = new SqlCommand("Alter Table tbl_NewView Add [Le_mi] [int] NULL CONSTRAINT [DF_tbl_NewView_Le_mi] DEFAULT ((0))" +
// " " +
// " ", con);
//con.Open();
//cmd22xxx.ExecuteNonQuery();
//con.Close();
//lblfinish.Text += "
Alter Table tbl_NewView Add Le_mi";
//SqlCommand cmd22xxtbl_lessonRoom = new SqlCommand("Alter Table tbl_NewView Add [Le_type] [Nvarchar](50) NULL" +
// " " +
// " ", con);
//con.Open();
//cmd22xxtbl_lessonRoom.ExecuteNonQuery();
//con.Close();
//lblfinish.Text += "
Alter Table tbl_NewView Add Column Le_type";
//SqlCommand cmd22xxtbl_lesson = new SqlCommand("Alter Table tbl_lesson Add [ta] [int] NULL CONSTRAINT [DF_tbl_lesson_ta] DEFAULT ((0))" +
// " " +
// " ", con);
//con.Open();
//cmd22xxtbl_lesson.ExecuteNonQuery();
//con.Close();
//lblfinish.Text += "
Alter Table tbl_lesson Add Column ta";
}
catch (Exception ex) { lblfinish.Text = ex.ToString(); }
}
}