北大青鸟Accp7.0MyKTV项目完整版
标签:
•
文件类型: .7z
•
文件大小: 30.38MB
•
下载次数: 1
•
北大青鸟Accp7.0MyKTV项目完整版 ,中关村校区完整版 带PPT
代码片段和文件信息
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Data.SqlClient;
using System.Data;
namespace KTV
{
class DBHelper
{
public static string connStr = @“Data Source=SISI;Initial Catalog=KTV;Integrated Security=True“;
static SqlCommand cmd = null;
//获取sqlconnection对象
static SqlConnection Connection{
get {
return new SqlConnection(connStr);
}
}
///
/// 执行增删改返回受影响行
///
///
public static int NoQuery(string sql) {
SqlConnection conn = Connection;
try
{
conn.Open();
cmd= new SqlCommand(sql conn);
return cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
System.Windows.Forms.MessageBox.Show(ex.Message);
return 0;
}
finally {
conn.Close();
}
}
///
/// 获取SqlDataReader对象
///
///
public static SqlDataReader Reader(string sql) {
SqlConnection conn = Connection;
try
{
conn.Open();
cmd= new SqlCommand(sql conn);
return cmd.ExecuteReader();
}
catch (Exception ex)
{
System.Windows.Forms.MessageBox.Show(ex.Message);
return null;
}
finally {
conn.Close();
}
}
///
/// 获取DataTable对象
///
///
///
public static DataTable Ada(string sql)
{
SqlConnection conn = Connection;
SqlDataAdapter ada = new SqlDataAdapter(sql conn);
DataTable table = new DataTable();
try
{
ada.Fill(table);
return table;
}
catch (Exception ex) {
System.Windows.Forms.MessageBox.Show(ex.Message);
return null;
}
}
///
/// 获取查询单行单列的结果
///
///
///
public static object Scalar(string sql) {
SqlConnection conn = Connection;
try
{
conn.Open();
cmd = new SqlCommand(sql conn);
return cmd.ExecuteScalar();
}
catch (Exception ex)
{
System.Windows.Forms.MessageBox.Show(ex.Message);
return null;
}
f
版权声明:本文内容由互联网用户自发贡献,该文观点仅代表作者本人。本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容, 请发送邮件举报,一经查实,本站将立刻删除。
评论列表(条)