首页 诗词 字典 板报 句子 名言 友答 励志 学校 网站地图
当前位置: 首页 > 教程频道 > 网站开发 > asp.net >

怎么在.net中把连接到access数据库改变成连接到SQL数据库?

2012-09-09 
怎样在.net中把连接到access数据库改变成连接到SQL数据库??add nameSqlConnStr connectionStringdat

怎样在.net中把连接到access数据库改变成连接到SQL数据库??
<add name="SqlConnStr" connectionString="data source =localhost;uid =sq_abzwsj;pwd=sq_wsj369;database=wsj;pooling=true;"

public class ClsSqlconn
{
  private static string SqlConnStr = ConfigurationManager.ConnectionStrings["SqlConnStr"].ConnectionString;

  public ClsSqlconn()
  {
  }

  //打开数据库链接
  public static SqlConnection Open_SqlConn()
  {
  try
  {
  SqlConnection SqlConn = new SqlConnection(SqlConnStr);
  SqlConn.Open();
  return SqlConn;
  }
  catch (Exception Ex)
  {
  throw Ex;
  }
  }

  // 生成Command对象  
  public static SqlCommand Create_SqlCmd(string SqlStr, SqlConnection SqlConn)
  {
  SqlCommand SqlCmd = new SqlCommand(SqlStr, SqlConn);
  return SqlCmd;
  }

  //关闭数据库链接
  public static void Close_SqlConn(SqlConnection SqlConn)
  {
  if (SqlConn != null)
  {
  SqlConn.Close();
  SqlConn.Dispose();
  }
  GC.Collect();
  }

  //运行Sql语句
  public static void Run_SQL(string SQL)
  {
  SqlConnection SqlConn = Open_SqlConn();
  SqlCommand SqlCmd = Create_SqlCmd(SQL, SqlConn);
  try
  {
  //int result_count = 
  SqlCmd.ExecuteNonQuery();
  Close_SqlConn(SqlConn);
  //return result_count;
  }
  catch (Exception Ex)
  {
  throw Ex;
  }
  }


  //运行Sql语句,返回受影响的记录条数
  public static int Run_SQL_Row(string SQL)
  {
  SqlConnection SqlConn = Open_SqlConn();
  SqlCommand SqlCmd = Create_SqlCmd(SQL, SqlConn);
  try
  {
  int result_count = SqlCmd.ExecuteNonQuery();
  Close_SqlConn(SqlConn);
  return result_count;
  }
  catch (Exception Ex)
  {
  throw Ex;
  }
  }

  //返回Sql语句执行结果的第一行第一列
  public static string Get_Row1_Col1_Value(string Sql)
  {
  SqlConnection SqlConn = Open_SqlConn();
  string result;
  result = "";

  SqlDataReader Dr;
  try
  {
  Dr = Create_SqlCmd(Sql, SqlConn).ExecuteReader();
  if (Dr.Read())
  {
  result = Dr[0].ToString();
  }
  Dr.Close();
  }
  catch
  {
  throw new Exception(Sql);
  }
  Close_SqlConn(SqlConn);
  return result;
  }

  // 运行Sql语句返回 SqlDataReader对象
  public static SqlDataReader Get_Reader(string SQL)
  {
  SqlConnection SqlConn = Open_SqlConn();
  SqlCommand SqlCmd = Create_SqlCmd(SQL, SqlConn);
  SqlDataReader Dr;
  try
  {
  Dr = SqlCmd.ExecuteReader(CommandBehavior.Default);
  }
  catch
  {
  throw new Exception(SQL);
  }


  Close_SqlConn(SqlConn);
  return Dr;
  }

  // 运行Sql语句返回 SqlDataReader对象
  public static SqlDataReader Get_Reader(SqlCommand SqlCmd)
  {
  //SqlConnection SqlConn = Open_SqlConn();
  //SqlCommand SqlCmd = Create_SqlCmd(SQL, SqlConn);
  SqlDataReader Dr;
  Dr = SqlCmd.ExecuteReader(CommandBehavior.Default);
  return Dr;
  }

  // 运行Sql语句,返回DataSet对象,将数据进行了分页
  public static DataSet Get_DataSet(string SQL, DataSet Ds, int StartIndex, int PageSize, string tablename)
  {
  SqlConnection SqlConn = Open_SqlConn();
  SqlDataAdapter Da = new SqlDataAdapter(SQL, SqlConn);
  try
  {
  Da.Fill(Ds, StartIndex, PageSize, tablename);
  }
  catch (Exception Ex)
  {
  throw Ex;
  }
  Close_SqlConn(SqlConn);
  return Ds;
  }

  // 运行Sql语句,返回DataSet对象
  public static DataSet Get_DataSet(string SQL, DataSet Ds)
  {
  SqlConnection SqlConn = Open_SqlConn();
  SqlDataAdapter Da = new SqlDataAdapter(SQL, SqlConn);
  try
  {
  Da.Fill(Ds);
  }
  catch (Exception Ex)
  {
  throw Ex;
  }
  Close_SqlConn(SqlConn);
  return Ds;  
  }

  // 运行Sql语句返回 DataTable
  public static DataTable Get_DataTable(string SQL, string Tb)
  {
  SqlConnection SqlConn = Open_SqlConn();
  SqlDataAdapter Da = new SqlDataAdapter(SQL, SqlConn);
  DataTable dt = new DataTable(Tb);
  Da.Fill(dt);
  Close_SqlConn(SqlConn);
  return dt;
  }

  // 运行Sql语句返回 SqlDataAdapter对象  
  public static SqlDataAdapter Get_Adapter(string SQL)
  {
  SqlConnection SqlConn = Open_SqlConn();
  SqlDataAdapter Da = new SqlDataAdapter(SQL, SqlConn);
  return Da;
  }

  //显示提示信息
  public static void Showinfo(string s, Boolean gobk)
  {
  if (gobk)
  {
  HttpContext.Current.Response.Write("<script>alert('" + s + "');history.back();</script>");
  }
  else
  {
  HttpContext.Current.Response.Write("<script>alert('" + s + "');</script>");
  }
  }
}

[解决办法]
你写的不就可以嘛

热点排行