62,074
社区成员
发帖
与我相关
我的任务
分享
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Data.SqlClient;
using System.Data;
/// <summary>
///DAL 的摘要说明
/// </summary>
public class DAL
{
public DAL()
{
//
//TODO: 在此处添加构造函数逻辑
//
}
private static string connStr = "Server=172.19.59.11\\SQLEXPRESS;DataBase=orderList;Uid=sa;Pwd=123456";
//private static string connStr = "Data Source=.;Initial Catalog=Goods;Integrated Security=True";
private static SqlConnection conn = null;
public static SqlConnection Conn
{
get
{
if (conn ==null || conn.State == ConnectionState.Closed)
{
conn = new SqlConnection(connStr);
}
return DAL.conn;
}
}
public static int ExecuteNonQuery(string sql)
{
//插入、更新、删除之后
SqlConnection myConn = Conn;
SqlCommand cmd = new SqlCommand(sql, myConn);
if (myConn.State == ConnectionState.Closed)
{
myConn.Open();
}
int res = cmd.ExecuteNonQuery();
myConn.Close();
return res;
}
public static DataTable SqlDataAdapterDt(string sql)
{
//查询一个表之后
SqlConnection myConn = Conn;
SqlCommand cmd = new SqlCommand(sql, myConn);
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
adapter.Fill(dt);
return dt;
}
public static int ExecuteScalar(string sql)
{
//查总数之用
SqlConnection myConn = Conn;
SqlCommand cmd = new SqlCommand(sql, myConn);
if (myConn == null || myConn.State == ConnectionState.Closed)
{
myConn.Open();
}
int res = Convert.ToInt32(cmd.ExecuteScalar());
myConn.Close();
return res;
}
}
[/quote]他没有命名空间的话 你直接DAL.方法就行了静态的你直接调用就行了,如在cs页面DAL.ExecuteNonQuery(sql);
using + 别人类的命名空间; 就行了
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Data.SqlClient;
using System.Data;
/// <summary>
///DAL 的摘要说明
/// </summary>
public class DAL
{
public DAL()
{
//
//TODO: 在此处添加构造函数逻辑
//
}
private static string connStr = "Server=172.19.59.11\\SQLEXPRESS;DataBase=orderList;Uid=sa;Pwd=123456";
//private static string connStr = "Data Source=.;Initial Catalog=Goods;Integrated Security=True";
private static SqlConnection conn = null;
public static SqlConnection Conn
{
get
{
if (conn ==null || conn.State == ConnectionState.Closed)
{
conn = new SqlConnection(connStr);
}
return DAL.conn;
}
}
public static int ExecuteNonQuery(string sql)
{
//插入、更新、删除之后
SqlConnection myConn = Conn;
SqlCommand cmd = new SqlCommand(sql, myConn);
if (myConn.State == ConnectionState.Closed)
{
myConn.Open();
}
int res = cmd.ExecuteNonQuery();
myConn.Close();
return res;
}
public static DataTable SqlDataAdapterDt(string sql)
{
//查询一个表之后
SqlConnection myConn = Conn;
SqlCommand cmd = new SqlCommand(sql, myConn);
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
adapter.Fill(dt);
return dt;
}
public static int ExecuteScalar(string sql)
{
//查总数之用
SqlConnection myConn = Conn;
SqlCommand cmd = new SqlCommand(sql, myConn);
if (myConn == null || myConn.State == ConnectionState.Closed)
{
myConn.Open();
}
int res = Convert.ToInt32(cmd.ExecuteScalar());
myConn.Close();
return res;
}
}
App_Code文件夹下类的调用问题