using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;
namespace DAL
{
public class SqlHelper
{
public static string str = ConfigurationManager.ConnectionStrings["ProDBConnectionString"].ConnectionString;
public static DataTable Query(string sql)
{
DataTable dataTable=new DataTable();
SqlDataAdapter sda=new SqlDataAdapter(sql,str);
sda.Fill(dataTable);
return dataTable;
}
public static int NonQuery(string sql)
{
int num = 0;
SqlConnection sqlConn=new SqlConnection(str);
sqlConn.Open();
try
{
SqlCommand sqlCmd = new SqlCommand(sql, sqlConn);
num = sqlCmd.ExecuteNonQuery();
}
finally
{
sqlConn.Close();
}
return num;
}
}
}
sqlHelper代码块
最新推荐文章于 2024-09-30 14:15:34 发布