Create, Retrieve, Update, Delete - CRUD function using adapter and dataset in C#

Here's a clever way to create CRUD function using adapter and dataset.

public DataSet yourFuntion(string firstparam, string secondparam)
{

SqlConnection sqlconn = new SqlConnection(connectionString);
try {
if (sqlconn.State == ConnectionState.Closed) {
sqlconn.Open();
}
SqlDataAdapter adapterz = new SqlDataAdapter();
SqlCommand selectCMD = new SqlCommand("yourstoredprocedure", sqlconn);
selectCMD.CommandType = CommandType.StoredProcedure;
adapterz.SelectCommand = selectCMD;
selectCMD.Parameters.Add("@firstparam", SqlDbType.Int).Value = firstparam;
selectCMD.Parameters.Add("@secondparam", SqlDbType.VarChar, 3).Value = secondparam;

DataSet compDS = new DataSet();

adapterz.Fill(compDS);
compDS = compDS;
adapterz.Dispose();
sqlconn.Close();


return compDS;

} catch (Exception ex) {
//handle error here
} finally {
sqlconn.Close();
}


}

Thats it, This really works. Happy Coding.