The code below is for a button which needs to send data to a sql DB
I have two questions:
1 Does anyone have a sample code snippet that i can look at to see how to do this
2 would it be better to pass the variables to a stored procedure
and have the DB do the insert
or
should i just code it in as an insert into
My initial instinct is to use a stored procedure as that would make it easier
to upgrade/change in the future if needed.
Code:
private void Submit_btn_Click_1(object sender, EventArgs e)
{
//submit data to the desc_table
/*connecting to database to perform task
* connection variable. open();
* function
* .close(); */
myconnection.Open();
//do stuff
myconnection.Close();
}
Thanks all in advance