forum

Home / DeveloperSection / Forums / How to select a table from many table while inserting

Ask Question

How to select a table from many table while inserting

ranjunath govind220921-Jul-2014
I have 4 tables
 
StdntBtech,StdntPg,StdntUg,StdntDip
 
I have to insert values into StdntBtech if the course name is BE or Btech
similarly 
 
I have to insert values into StdntPG if the course name is MCA or MSc
similarly
I have to insert values into StdntUg if the course name is BSc
 
similarly 
I have to insert values into StdntDip if the course name is Diploma

which statement I have to use(IF or Case)
if so how the syntax will be?
how can I use a string instead of table name in insert statement?



mssql servermssql server 
Updated on 23-Jul-2014
ranjunath govind

ranjunath govind

Follow

Can you answer this question?

Answer

1 Answers

Anonymous User

Anonymous User

23-Jul-2014
Here is my code for insert record in a table according to course name from many table while inserting...

string tblname = "";
        if (txtcourse.Text == "BE" || txtcourse.Text == "Btech")
        {
            tblname = "StdntBtech";
        }
        else if (txtcourse.Text == "MCA" || txtcourse.Text == "MSc")
        {
            tblname = "StdntPg";
        }
        else if (txtcourse.Text == "BSc" || txtcourse.Text == "BA")
        {
            tblname = "StdntUg";
        }
        else if (txtcourse.Text == "Diploma")
        {
            tblname = "StdntDip";
        }
        else
        {
            Response.Write("Please Insert Correct Course Name!!");
        }
        string st = "insert into " + tblname + " values('" + txtName.Text + "','" + txtCity.Text + "','" + txtcourse.Text + "')";
        if (tblname != "")
        {
            cn.Open();
            cmd = new SqlCommand(st, cn);
            int executerow = cmd.ExecuteNonQuery();
            if (executerow > 0)
            {
                Response.Write(executerow + " Row's affected");
            }
            cn.Close();
        }
        else
        {
            Response.Write("Please Insert Correct Record");
        }

Liked By