首頁猿問 WM DBHelp類

WM DBHelp類

.NET

炎炎設計 2018-12-07 11:04:25

通過VS2008新建的智能設備項目，操作SQL2000/2005的數(shù)據(jù)庫，如果全部用SQL 語句是可以的，但是我有很多的復雜關系需要通過存儲過程來實現(xiàn)，可是我發(fā)現(xiàn)Windows Mobile里面連Parameters.AddRange這個方法都沒有，哪位朋友有這方面的操作類請發(fā)一個給我，類似下面的這一段代碼，下面的代碼是CS和BS里面用到的，感謝！ using System.Net.Mime;using DBUtility;using System.Windows.Forms;using System.Data.SqlClient;using System.Data;using System; namespace DAL{??? public class DALHelper??? {??????? ??????? private SqlConnection connection;??????? public SqlConnection Connection??????? {??????????? get??????????? {??????????????? string connectionString = @"server=.;database=DemoDB;uid=sa;pwd=123456";??????????????? ??????????????? if (connection == null)??????????????? {??????????????????? connection = new SqlConnection(connectionString);??????????????????? connection.Open();??????????????? }??????????????? else if (connection.State == System.Data.ConnectionState.Closed)??????????????? {??????????????????? connection.Open();??????????????? }??????????????? else if (connection.State == System.Data.ConnectionState.Broken)??????????????? {??????????????????? connection.Close();??????????????????? connection.Open();??????????????? }??????????????? return connection;??????????? }??????? } ??????? public int ExecuteCommand(string safeSql)??????? {??????????? SqlCommand cmd = new SqlCommand(safeSql, Connection);??????????? int result = cmd.ExecuteNonQuery();??????????? return result;??????? } ??????? public int ExecuteCommand(string sql, params SqlParameter[] values)??????? {??????????? SqlCommand cmd = new SqlCommand(sql, Connection);??????????? cmd.CommandType = CommandType.StoredProcedure;??????????? cmd.Parameters.AddRange(values);??????????? return cmd.ExecuteNonQuery();??????? } ????? ??????? public string GetScalar(string safeSql)??????? {??????????? SqlCommand cmd = new SqlCommand(safeSql, Connection);??????????? string result = cmd.ExecuteScalar().ToString();??????????? return result;??????? } ??????? public string GetScalar(string sql, params SqlParameter[] values)??????? {??????????? SqlCommand cmd = new SqlCommand(sql, Connection);??????????? cmd.CommandType = CommandType.StoredProcedure;??????????? cmd.Parameters.AddRange(values);??????????? string result = cmd.ExecuteScalar().ToString();??????????? return result;??????? } ??????? public SqlDataReader GetReader(string safeSql)??????? {??????????? SqlCommand cmd = new SqlCommand(safeSql, Connection);??????????? SqlDataReader reader = cmd.ExecuteReader();??????????? return reader;??????? } ??????? public SqlDataReader GetReader(string sql, params SqlParameter[] values)??????? {??????????? SqlCommand cmd = new SqlCommand(sql, Connection);??????????? cmd.CommandType = CommandType.StoredProcedure;??????????? cmd.Parameters.AddRange(values);??????????? SqlDataReader reader = cmd.ExecuteReader();??????????? return reader;??????? } ??????? public DataTable GetDataSet(string safeSql)??????? {??????????? DataSet ds = new DataSet();??????????? SqlCommand cmd = new SqlCommand(safeSql, Connection);??????????? SqlDataAdapter da = new SqlDataAdapter(cmd);??????????? da.Fill(ds);??????????? return ds.Tables[0];??????? } ??????? public DataTable GetDataSet(string sql, params SqlParameter[] values)??????? {??????????? DataSet ds = new DataSet();??????????? SqlCommand cmd = new SqlCommand(sql, Connection);??????????? cmd.CommandType = CommandType.StoredProcedure;??????????? cmd.Parameters.AddRange(values);??????????? SqlDataAdapter da = new SqlDataAdapter(cmd);??????????? da.Fill(ds);??????????? return ds.Tables[0];??????? } ??????? /// <summary>??????? /// 返回一個數(shù)據(jù)集，從里面取出不同的表 ??????? /// </summary>??????? /// <param name="sql"></param>??????? /// <param name="values"></param>??????? /// <returns></returns>??????? public DataSet GetDataSet3(string sql, params SqlParameter[] values)??????? {??????????? DataSet ds = new DataSet();??????????? SqlCommand cmd = new SqlCommand(sql, Connection);??????????? cmd.CommandType = CommandType.StoredProcedure;??????????? cmd.Parameters.AddRange(values);??????????? SqlDataAdapter da = new SqlDataAdapter(cmd);??????????? da.Fill(ds);??????????? return ds;??????? }??? ??? }}

查看完整描述

1 回答

桃花長相依

TA貢獻1860條經驗獲得超8個贊

你看下這個對不

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;

namespace SQL.MySchoolDAL
{
?? public static class DBHelper
??? {
??????? private static string connectionString =
??????????? ConfigurationManager.ConnectionStrings["conString"].ToString();

??????? private static SqlConnection connection;
??????? public static SqlConnection Connection
??????? {
??????????? get
??????????? {
??????????????? if (connection == null || connection.ConnectionString=="")
??????????????? {
??????????????????? connection = new SqlConnection(connectionString);
??????????????????? connection.Open();
??????????????? }
??????????????? else if (connection.State == ConnectionState.Closed)
??????????????? {
??????????????????? connection.Open();
??????????????? }
??????????????? else if (connection.State == ConnectionState.Broken)
??????????????? {
??????????????????? connection.Close();
??????????????????? connection.Open();
??????????????? }
??????????????? return connection;
??????????? }
??????? }

??????? public static int ExecuteCommand(string sql, CommandType commandType, params SqlParameter[] values)
??????? {
??????????? SqlCommand cmd = new SqlCommand(sql, Connection);
??????????? cmd.Parameters.AddRange(values);
??????????? cmd.CommandType = commandType;
??????????? int result = cmd.ExecuteNonQuery();
??????????? return result;
??????? }

??????? public static int GetScalar(string sql, CommandType commandType, params SqlParameter[] values)
??????? {
??????????? SqlCommand cmd = new SqlCommand(sql, Connection);
??????????? cmd.Parameters.AddRange(values);
??????????? cmd.CommandType = commandType;
??????????? int result = Convert.ToInt32(cmd.ExecuteScalar());
??????????? return result;
??????? }

??????? public static SqlDataReader GetReader(string sql, CommandType commandType, params SqlParameter[] values)
??????? {
??????????? SqlCommand cmd = new SqlCommand(sql, Connection);
??????????? cmd.Parameters.AddRange(values);
??????????? cmd.CommandType = commandType;
??????????? SqlDataReader reader = cmd.ExecuteReader(CommandBehavior.CloseConnection);
??????????? return reader;
??????? }

?????? public static DataSet GetDataSet(string sql, CommandType commandType, params SqlParameter[] values)
??????? {
??????????? DataSet ds = new DataSet();
??????????? SqlDataAdapter da = new SqlDataAdapter(sql, Connection);
??????????? da.SelectCommand.Parameters.AddRange(values);
??????????? da.SelectCommand.CommandType = commandType;
??????????? da.Fill(ds);
??????????? return ds;
??????? }
??? }
}