public DataTable ExcuteNonQuery(string query)
{
Array parameterList = MParameterList.ToArray();
MParameterList.Clear();
using (SqlConnection con = new SqlConnection(CONNECTION_STRING))
{
try
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
SqlDataAdapter sqlAdptr = new SqlDataAdapter(query, con);
if (parameterList.Length > 0)
{
sqlAdptr.SelectCommand.Parameters.AddRange(parameterList);
}
DataTable dataTable = new DataTable();
sqlAdptr.Fill(dataTable);
return(dataTable);
}
catch (Exception ex)
{
// ex.ToWriteLog(Environment.StackTrace);
msg = ex.Message;
return(null);
}
}
}
public object ExcuteScalar(string query)
{
Array parameterList = MParameterList.ToArray();
MParameterList.Clear();
using (SqlConnection con = new SqlConnection(CONNECTION_STRING))
{
try
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
SqlCommand cmd = new SqlCommand(query, con);
if (parameterList.Length > 0)
{
cmd.Parameters.AddRange(parameterList);
}
object obj = cmd.ExecuteScalar();
return(obj);
}
catch (Exception ex)
{
//ex.ToWriteLog(Environment.StackTrace);
msg = ex.Message;
return(null);
}
}
}
/// <summary>
/// Add sql paramiter by call this method
/// </summary>
/// <param name="parameterName"></param>
/// <param name="ParameterValue"></param>
public static void SetParamiterWithValue(string parameterName, string ParameterValue)
{
MParameterList.Add(new SqlParameter("@" + parameterName + "", ParameterValue));
}
