private DataSet Method_GetList()
{
try
{
DataSet ds = new DataSet();
SqlConnection cnn = new SqlConnection(m_DB_Cnn);
cnn.Open();
string strSQL = "EXEC SP_XXX";
SqlDataAdapter da = new SqlDataAdapter(strSQL, cnn);
da.Fill(ds);
cnn.Close();
cnn.Dispose();
return ds;
}
catch { return null; }
}
private string Method_Updatestring p_ID)
{
try
{
SqlConnection cnn = new SqlConnection(m_DB_Cnn);
cnn.Open();
string strSQL = "EXEC SP_XXX'" + p_ID + "'";
SqlCommand cmd = new SqlCommand(strSQL, cnn);
cmd.ExecuteNonQuery();
cmd.Dispose();
cnn.Dispose();
return "SUCCESS";
}
catch (Exception ex)
{ return "ERROR: --" + ex.Message; }
}