sql insert statement in c#

If the statement is inside a stored procedure and you're creating the global temporary table first, it should be ok. If you're trying to run the statement from client side, the insert is valid only within a single batch and you must create the table in the same batch.

Also you're using global temporary table which is visible to all sessions. Is this what you really want to do? Using table typed variables is a preferred way over temporary tables.

I dont think you can make a temp table in SQL the way you are thinking, since it only exists within the scope of the query/stored procedure that creates it.

Itz recommended to create a Table in SQL to put this into.

insert_query = "insert into ##Mytemp(Col1,Col2,Col3) values('" + char_temp + "','" +int_temp + "','" + tinyint_temp + "')";

hope this is helps you



Regards
R.dhanabal

remove "values" keyword from your query

please use below

insert_query = "insert into ##Mytemp(Col1,Col2,Col3) values('" + char_temp + "','" +int_temp + "','" + tinyint_temp + "');";

try this or follow this ....

string str="insert into tablename (column1,column2,column3,column4,column5,column6,column7)values('"+txt1+"','"+txt2.text+"','"+txt3.text+"','"+txt.text+"','"+txt.text+"','"+txt.text+"'"

sqlcommmnad cmd=new sql command(str,con);

cmd.exicutenonquery();

con. close();