C# WF窗体的DBhelp类怎么写.谢谢了，大神帮忙啊

using Systemusing System.Collections.Genericusing System.Linqusing System.Textusing System.Datausing System.Data.SQLitenamespace DAL { static class SqlHelper { private static bool Conn = falseprivate static string ConnStr = @"Data Source=FileNamePooling=trueFailIfMissing=false"static SqlHelper() { Conn = TestConn()} public static bool Update(string SQL, params SqlParameter[] SqlParameters) { bool Result = falseif (Conn) using (SQLiteConnection SqlConn = new SQLiteConnection(ConnStr)) { SqlConn.Open()using (SQLiteCommand SqlCmd = new SQLiteCommand(SQL, SqlConn)) { if (SQLiteParameters != null) SqlCmd.Parameters.AddRange(SqlParameters)Result = SQLiteCmd.ExecuteNonQuery() >0} } return Result} public static T Scalar<T>(string SQL, params SQLiteParameter[] SqlParameters) { object Result = nullif (Conn) using (SQLiteConnection SqlConn = new SQLiteConnection(ConnStr)) { SqlConn.Open()using (SQLiteCommand SqlCmd = new SQLiteCommand(SQL, SqlConn)) { if (SQLiteParameters != null) SqlCmd.Parameters.AddRange(SqlParameters)Result = SqlCmd.ExecuteScalar()} } return (Result != null) ? (T)Result : default(T)} public static DataTable Query(string SQL, params SQLiteParameter[] SqlParameters) { DataTable Result = nullif (Conn) using (SQLiteConnection SqlConn = new SQLiteConnection(ConnStr)) { SqlConn.Open()using (SQLiteCommand SqlCmd = new SQLiteCommand(SQL, SqlConn)) { if (SqlParameters != null) SqlCmd.Parameters.AddRange(SqlParameters)using (SQLiteDataAdapter SqlAdap = new SQLiteDataAdapter(SqlCmd)) using (DataSet ds = new DataSet()) { SqlAdap.Fill(ds)Result = ds.Tables[0]} } } return Result} private static bool TestConn() { bool TestResult = falsetry { using (SQLiteConnection SqlConn = new SQLiteConnection(ConnStr)) SqlConn.Open()TestResult = true} catch { TestResult = false} return TestResult} } }

首先你得有DBHelpler这个类，然后你看这个类中你要进行调用的方法是不是静态的如果是静态的直接用类名.方法名即可，前提是引用这个类的命名空间，如果不是静态的话，那么就new一下这个类，然后用这个new的DBHelper的变量点出你要用的方法即可，如果你没有DBHelper的话，你可以去下载一个，或者找一个，或者自己写一个。

---