SQLHelper for C#.net

public class Sqlitehelper
{
Get connection string
private static readonly string str = configurationmanager.connectionstrings["Constr"]. ConnectionString;
<summary>
Adding and deleting functions
</summary>
&LT;SP name= "SQL" >sql statements </sp>
&LT;SP name= "SP" >sql parameters </sp>
<returns> number of rows affected </returns>
public static int ExecuteNonQuery (String sql, params sqliteparameter[] sp)
{
using (sqliteconnection con=new sqliteconnection (str))
{
using (Sqlitecommand cmd=new Sqlitecommand (Sql,con))
{
Con. Open ();
if (param!=null)
{
Cmd. Parameters.addrange (SP);
}
return CMD. ExecuteNonQuery ();
}
}
}
<summary>
Inquire
</summary>
&LT;SP name= "SQL" >sql statements </sp>
&LT;SP name= "param" > Parameters </sp>
<returns> return to first column </returns>
public static Object ExecuteScalar (String sql, params sqliteparameter[] sp)
{
using (sqliteconnection con=new sqliteconnection (str))
{
using (Sqlitecommand cmd=new Sqlitecommand (Sql,con))
{
Con. Open ();
if (param!=null)
{
Cmd. Parameters.addrange (SP);
}
return CMD. ExecuteScalar ();
}
}
}
<summary>
Query table
</summary>
&LT;SP name= "SQL" >sql statements </sp>
&LT;SP name= "param" > Parameters </sp>
<returns> Back to Table</returns>
public static DataTable executetable (String sql, params sqliteparameter[] sp)
{
DataTable dt = new DataTable ();
using (Sqlitedataadapter sda=new sqlitedataadapter (SQL,STR))
{
if (param!=null)
{
Sda. SelectCommand.Parameters.AddRange (SP);
}
Sda. Fill (DT);
}
return DT;
}
<summary>
Inquire
</summary>
&LT;SP name= "SQL" >sql statements </sp>
&LT;SP name= "param" > Parameters </sp>
<returns> Data </returns>
public static Sqlitedatareader ExecuteReader (String sql, params sqliteparameter[] sp)
{
Sqliteconnection con = new sqliteconnection (str);
using (Sqlitecommand cmd=new Sqlitecommand (Sql,con))
{
if (param!=null)
{
Cmd. Parameters.addrange (SP);
}
Try
{
Con. Open ();
return CMD. ExecuteReader (commandbehavior.closeconnection);
}
catch (Exception ex)
{
Con. Close ();
Con. Dispose ();
Throw ex;
}
}
}

}