SqlHelper Help Class

Using System;
Using System.Collections.Generic;
Using System.Linq;
Using System.Text;
Using System.Threading.Tasks;
Using System.Configuration;
Using System.Data;
Using System.Data.SqlClient;

Namespace CZBK. Itcastproject.dal
{
public class SqlHelper
{
private static readonly string connstr = configurationmanager.connectionstrings["ConnStr"]. ConnectionString;
public static DataTable getdatatable (String sql, CommandType type, params sqlparameter[] pars)
{
using (SqlConnection conn = new SqlConnection (CONNSTR))
{
using (SqlDataAdapter apter = new SqlDataAdapter (SQL, conn))
{
if (pars! = null)
{
Apter. SelectCommand.Parameters.AddRange (pars);
}
Apter.SelectCommand.CommandType = type;
DataTable da = new DataTable ();
Apter. Fill (DA);
Return da;
}

}
}
public static int ExecuteNonQuery (string sql,commandtype type,params sqlparameter[] pars)
{
using (SqlConnection conn=new SqlConnection (CONNSTR))
{
using (SqlCommand cmd=new SqlCommand (sql,conn))
{
if (pars!=null)
{
Cmd. Parameters.addrange (pars);
}
Cmd.commandtype = type;
Conn. Open ();
return CMD. ExecuteNonQuery ();
}
}
}
public static Object ExecuteScalar (String sql, CommandType type, params sqlparameter[] pars)
{
using (SqlConnection conn = new SqlConnection (CONNSTR))
{
using (SqlCommand cmd = new SqlCommand (SQL, conn))
{
if (pars! = null)
{
Cmd. Parameters.addrange (pars);
}
Cmd.commandtype = type;
Conn. Open ();
return CMD. ExecuteScalar ();
}
}
}
}
}

SqlHelper Help Class