111,082
社区成员




using System;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;
public class AdminServices
{
private static string connString = DBHelp.Conn.ConnectionString;
static void Main()
{
string query = "select count(*) from Customers";
int totalRecordsAffected = (int)DBHelp.ExecuteScalar(query);
Console.WriteLine("输出受影响的行数{0}",totalRecordsAffected);
Console.ReadLine();
}
}
public class DBHelp
{
private static SqlConnection conn = null;
public static SqlConnection Conn
{
if(conn == null)
{
conn = new SqlConnection(ConfigurationManager.ConnectionStrings["configName"].ConnectionString);
}
return conn;
}
public static object ExecuteScalar(string safeStr)
{
object o;
using(SqlConnection conn = Conn)
{
conn.Open();
using(SqlCommand cmd = new (safeStr , conn))
{
o = cmd.ExecuteScalar();
}
conn.Close();
}
return o;
}
}
return DBHelp.GetScalar(strSql);
public static string GetScalar(string safeSql)
{
string connectionString = ConfigurationManager.ConnectionStrings["人员管理.Properties.Settings.OperationManagerConnectionString"].ConnectionString;
SqlConnection connection = new SqlConnection(connectionString );
connection.Open();
SqlCommand cmd = new SqlCommand(safeSql,connection);
string result = (cmd.ExecuteScalar()).ToString();
connection.Close();
return result;
}