Error while inserting data in DataBase ?

my requirment is insert TableName and JourneyDate and FlightNumber alongwith otherdata at RunTime but i get error, I tried it several times.

Table Structure is:

Create Table HA142(JourneyDateDateTime primary key,FlightNochar(5)not nullFOREIGN kEY REFERENCES FLIGHTS(FlightNo),FirstClassSeatAvalableint,BusinessClassSeatAvalableint,EconomyClassSeatAvalableint,FsWaitingAvalableint,BsWaitingAvalableint,EcWaitingAvalableint)

string flightno = drpFlightNo.SelectedItem.Text;string JourneyDate = Session["JourneyDate"].ToString();string newStrign =",18,42,280,3,7,35)";SqlConnection myConn =new SqlConnection("workstation id=JASIM;packet size=4096;user id=ASPNET;data source=JASIM;persist security info=False;initial catalog=Test");SqlCommand populateFlightTable =new SqlCommand("INSERT INTO "+flightno+" VALUES("+JourneyDate+","+flightno+newStrign,myConn);myConn.Open();populateFlightTable.ExecuteNonQuery();myConn.Close();

whenever compiler reached topopulateFlightTable.ExecuteNonQuery();I received error. i tried it to rectify several times but no result.

plz hemp me...

Your insert statement is incorrect.

Read this article to know how that works

http://www.w3schools.com/sql/sql_insert.asp

HTH
Regards

|||

I am passing Table name at runtime becouse user does't not know in which table he is inserting date, it is based on his input record. that's why i am trying to accept table name and first two field of that table from user at run time.

So if I made any mistake in my code, plz tell me what is wrong and how to solve it. By using stored prosedure it is not possible to accept table along name with their Fields at runtime.

|||Thank you it was Syntax Error.