TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Rahul Lakshakar
NA
199
41.7k
Create table in database on button click
Oct 22 2016 12:52 AM
I am creating an system using Asp.Net c#. I want create a table in the database on submit the details. I am taking the name of the table from dropdown selected item. I am using the following code but it is not working please help me.....
string constr = ConfigurationManager.ConnectionStrings["conn"].ConnectionString;
SqlConnection con = new SqlConnection(constr);
con.Open();
string insertData = "insert into ExamDetail (ExamName, SubjectName, Duration, StartTime, EndTime, NegativeMark, QusNo, QusMarks) values (@EName, @SubName, @DUR, @ST, @ET, @NM, @QN,@QM)";
SqlCommand com = new SqlCommand(insertData, con);
com.Parameters.AddWithValue("@EName", DropExamName.SelectedItem.Text);
com.Parameters.AddWithValue("@SubName", DropSubName.SelectedItem.Text);
com.Parameters.AddWithValue("@DUR", DropDuration.SelectedItem.Text);
com.Parameters.AddWithValue("@ST", Text_Stime.Text);
com.Parameters.AddWithValue("@ET", Text_Etime.Text);
com.Parameters.AddWithValue("@NM", RadioNegativeMarks.SelectedItem.Text);
com.Parameters.AddWithValue("@QN", Text_question_no.Text);
com.Parameters.AddWithValue("@QM", text_question_marks.Text);
string createExamTable = "BEGIN";
createExamTable += "CREATE TABLE [dbo]. ['"+ DropExamName.SelectedItem.Text +"'](";
createExamTable += "[ExamId] INT IDENTITY(1,1) NOT NULL,";
createExamTable += "[QusNo] INT NOT NULL,";
createExamTable += "[QusDetail] VARCHAR(MAX) NOT NULL";
createExamTable += "[Optn1] VARCHAR(MAX) NOT NULL";
createExamTable += "[Optn2] VARCHAR(MAX) NOT NULL";
createExamTable += "[Optn3] VARCHAR(MAX) NOT NULL";
createExamTable += "[Optn4] VARCHAR(MAX) NOT NULL";
createExamTable += "[CorrectOptn] INT NOT NULL";
createExamTable += ")";
createExamTable += " END";
SqlCommand ComCreateTable = new SqlCommand(createExamTable, con);
com.ExecuteNonQuery();
ComCreateTable.ExecuteNonQuery();
Response.Write("DONE");
Reply
Answers (
4
)
sys._application' cannot be converted to type 'sys._applicat
how to insert one record of multiple time in asp.net