How to select a table from many table while inserting

ranjunath govind 2665 21 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?

ranjunath govind

Other

1 Answers

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");
        }

forum

How to select a table from many table while inserting

Can you answer this question?

1 Answers