QuickSql Updated Updadted Stored procdure ıcın degıskenlı versıyon eklendın sp_af!!!

private string conn = “data source=.;database=bar2kod;trusted_connection=true”;

public void q(string SQL)
{
try
{
using (SqlConnection cnn = new SqlConnection(conn))
{

SqlCommand cmd = new SqlCommand();
cmd.CommandText = SQL;
cmd.Connection = cnn;
cnn.Open();
cmd.ExecuteNonQuery();
cnn.Close();
}
}
catch(Exception ex)
{

System.Windows.Forms.MessageBox.Show(”q-> Sql Error : “+ ex);

}

}
public void sp_q(string spName , string spVariable)
{
try
{
using (SqlConnection cnn = new SqlConnection(conn))
{
SqlCommand cmd = new SqlCommand(spName, cnn);
cmd.CommandType = CommandType.StoredProcedure;
cnn.Open();
cmd.ExecuteNonQuery();
cnn.Close();

}
}
catch (Exception ex)
{

System.Windows.Forms.MessageBox.Show(”sp_q-> Sql Error : ” + ex);

}
}
public string sp_af(string spName, string spVariable)
{
string rst;
try
{
using (SqlConnection cnn = new SqlConnection(conn))
{

SqlCommand cmd = new SqlCommand(spName, cnn);
cmd.CommandType = CommandType.StoredProcedure;

string[] spt = spVariable.Split(’,');
for (int i = 0; i < spt.Length; i++)
{
string[] SPvar = spt[i].ToString().Split(’=');
cmd.Parameters.AddWithValue(SPvar[0].ToString(), SPvar[1].ToString());

}

cnn.Open();
rst = cmd.ExecuteScalar().ToString();
cnn.Close();

}
}
catch (Exception ex)
{

System.Windows.Forms.MessageBox.Show(”sp_af-> Sql Error : ” + ex);
rst = “null”;

}
return rst;
}
public DataTable afq(string SQL)
{
try
{

using (SqlConnection cnn = new SqlConnection(conn))
{

SqlDataAdapter adp = new SqlDataAdapter(SQL, cnn);

DataSet ds = new DataSet();

adp.Fill(ds, “records”);

return ds.Tables[0];

}
}
catch (Exception ex)
{

System.Windows.Forms.MessageBox.Show(”afq-> Sql Error : ” + ex);
return null;

}
}

}