Its better to make an global class which consisting code for opening Gloabal Connection as well as DML operation
public static SqlConnection GetConnection()
{
SqlConnection con = new SqlConnection("Your Connection String");
con.Open();
return con;
}
or create an global function for Save,Update and Delete
public static bool SaveRecord(string query)
{
int i = 0;
cmd = new SqlCommand(query, GetConnection());
try
{
i = cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
Console.WriteLine(ex.Message.ToString());
}
if (i == 1)
{
return true;
}
else
{
return false;
}
}
How to using SaveRecord(string query) Function
Just passed query to SaveFunction(string query) method as a parameter and hold value in a boolean.
Ex:-
bool res = SaveRecord("Your Command");
if(res)
{
}