using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Data.SqlClient;
using System.Data;
namespace ConsoleApplication1
{
class DBManager
{
public Object ExecuteScaler(string sql)
{
SqlConnection con = new SqlConnection();
con.ConnectionString = "Data source=(local);uid=sa;pwd=1;initial catalog=ypth";
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandText = sql;
con.Open();
Object obj= cmd.ExecuteScalar();//只会读取第一条数据
con.Close();
con.Dispose();
if(Object.Equals(obj,null) || Object.Equals(obj,DBNull.Value))
{
return null;
}
else
{
return obj;
}
}
}
}
ADO.NET里的ExecuteScaler方法简介
最新推荐文章于 2020-11-16 02:50:00 发布