How to use select into and insert into queries in codebehind

Mohan Srinivas

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

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Prateek Singla9y ago
Accepted 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 MUKHTAR9y ago
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 P9y ago
you can do it in stored procedure and use that in web application