using System;
using System.Collections.Generic;
using System.Text;
using System.Data.SqlClient;
using System.Data;
//using System.Configuration;
partial class sqlHelper
{
public static string GetSqlConnectionString()
{
// 192.168.102.117
return "Server=192.168.6.230;User Id=sa;Password=1qaz@WSX;DataBase=YCS_SMARTCABI;";
//return ConfigurationManager.ConnectionStrings["SqlConn"].ConnectionString;
}
// winCE中使用的框架为 .NET Compact Framework ,该旧框架很多方法不支持,可以写代码实现配置文件;
//适合增删改操作,返回影响条数
public static int ExecuteNonQuery(string sql, params SqlParameter[] parameters)
{
using (SqlConnection conn = new SqlConnection(GetSqlConnectionString()))
{
using (SqlCommand comm = conn.CreateCommand())
{
conn.Open();
comm.CommandText = sql;
//comm.Parameters.AddRange(parameters);
//旧的框架不支持AddRange方法;
foreach (SqlParameter sp in parameters)
{
comm.Parameters.AddWithValue(sp.ParameterName, sp.Value);
}
return comm.ExecuteNonQuery();
}
}
}
//查询操作,返回查询结果中的第一行第一列的值
public static object ExecuteScalar(string sql, params SqlParameter[] parameters)
{
using (SqlConnection conn = new SqlConnection(GetSqlConnectionString()))
{
using (SqlCommand comm = conn.CreateCommand())
{
conn.Open();
comm.CommandText = sql;
//comm.Parameters.AddRange(parameters);
foreach (SqlParameter sp in parameters)
{
comm.Parameters.AddWithValue(sp.ParameterName, sp.Value);
}
return comm.ExecuteScalar();
}
}
}
//Adapter调整,查询操作,返回DataTable
public static DataTable ExecuteDataTable(string sql, params SqlParameter[] parameters)
{
using (SqlDataAdapter adapter = new SqlDataAdapter(sql, GetSqlConnectionString()))
{
DataTable dt = new DataTable();
//adapter.SelectCommand.Parameters.AddRange(parameters);
foreach (SqlParameter sp in parameters)
{
adapter.SelectCommand.Parameters.Add(sp.ParameterName, sp.Value);
}
adapter.Fill(dt);
return dt;
}
}
public static SqlDataReader ExecuteReader(string sqlText, params SqlParameter[] parameters)
{
//SqlDataReader要求,它读取数据的时候有,它独占它的SqlConnection对象,而且SqlConnection必须是Open状态
SqlConnection conn = new SqlConnection(GetSqlConnectionString());//不要释放连接,因为后面还需要连接打开状态
SqlCommand cmd = conn.CreateCommand();
conn.Open();
cmd.CommandText = sqlText;
//cmd.Parameters.AddRange(parameters);
foreach (SqlParameter sp in parameters)
{
cmd.Parameters.AddWithValue(sp.ParameterName, sp.Value);
}
//CommandBehavior.CloseConnection当SqlDataReader释放的时候,顺便把SqlConnection对象也释放掉
return cmd.ExecuteReader(CommandBehavior.CloseConnection);
}
}
Ado sqlHelper
最新推荐文章于 2022-04-21 12:35:51 发布