abolfazlahmadi
دوشنبه 08 آذر 1395, 16:18 عصر
سلام من ازکد زیر برای ساخت جدول در asp.net استفاده میکنم الان فقط یه جدول هست اگه بخوام تعداد زیادی جدول درست کنم کد نویسی زیاد و اصلا منظقی نیست که از کدهای زیر استفاده کنم راه و پیشنهاد شما جیه؟
SqlConnection connect = new SqlConnection(Connection);
string access_page = " CREATE TABLE [dbo].[access_page]([ID_access_page] [int] IDENTITY(1,1) NOT NULL,[name_pages] [nvarchar](50) NULL,[username] [nvarchar](50) NULL,CONSTRAINT [PK_access_page_page] PRIMARY KEY CLUSTERED ([ID_access_page] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY] ";
SqlCommand command = new SqlCommand(access_page , connect);
connect.Open();
command.ExecuteNonQuery();
connect.Close();
SqlConnection connect = new SqlConnection(Connection);
string access_page = " CREATE TABLE [dbo].[access_page]([ID_access_page] [int] IDENTITY(1,1) NOT NULL,[name_pages] [nvarchar](50) NULL,[username] [nvarchar](50) NULL,CONSTRAINT [PK_access_page_page] PRIMARY KEY CLUSTERED ([ID_access_page] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY] ";
SqlCommand command = new SqlCommand(access_page , connect);
connect.Open();
command.ExecuteNonQuery();
connect.Close();