How to use select into and insert into queries in codebehind

Question

can anybody give an code behind example for select into and insert into queries..I know how to use in SQLserver but don't know how to use in a web application code behind file

Prateek Singla · Answer

Just Make a strored procedure of your query and call it in your code. Check these links http://www.c-sharpcorner.com/article/using-stored-procedures-with-Asp-Net/ http://www.aspsnippets.com/Articles/Select-SQL-Server-Stored-Procedures-using-ASPNet-Example.aspx

SARDAR MUKHTAR · Answer

for this, you can use StoredProcedure. And you can use the following in code behind. Execution: //Select Into ExecuteQuery("INSERT INTO Table1 (Col1, Col2, Col3) SELECT Col1, Col2, Col3 FROM Table2 WHERE Col1= 'value'"); //Insert Into ExecuteQuery("INSERT INTO Table1 (Col1, Col2, Col3) Values('Val1', 'Val2', 'Val3')"); //Create a method like this and use in your applicaiton public int ExecuteQuery(string query) { try { using (SqlConnection con = new SqlConnection(_conString)) { SqlCommand cmd = new SqlCommand(query, con); int x = 0; if (con.State == ConnectionState.Closed) { con.Open(); } x = cmd.ExecuteNonQuery(); if (con.State == ConnectionState.Open) { con.Close(); } return x; } } catch (Exception ee) { return 0; } }

Rafnas T P · Answer

you can do it in stored procedure and use that in web application