20041220 MYDB.CS

最新推荐文章于 2021-12-16 11:16:14 发布

xuandhu

最新推荐文章于 2021-12-16 11:16:14 发布

阅读量1k

点赞数

分类专栏： c# 文章标签： dataset string table delete object url

本文链接：https://blog.csdn.net/xuandhu/article/details/223272

版权

c# 专栏收录该内容

20 篇文章 0 订阅

订阅专栏

using System;
using System.Data ;
using System.Data.SqlClient;
using System.Timers;
using System.Collections;
using System.Collections.Specialized;

using System.IO;
using System.Web;
using System.Web.UI;
using System.Web.Caching;
using System.Configuration;
using System.Text;
using System.Text.RegularExpressions;
using System.Web.UI.WebControls;

//namespace zqfk.Controls
//{
public class mydb
{
/// <summary>
///数据连接
/// 在WEB.CONFIG文件中的内容如下
/// <appSettings>
///<add key="mydatabasepath" value="~/database/Database.mdb"></add>
///<add key="MYdatabaseconn" value="Provider=Microsoft.Jet.Sql.4.0;Data Source="></add>
///</appSettings>
/// </summary>
public static string ConnectionString
{
  get
  {  //return ConfigurationSettings.AppSettings ["ConnectionString"];
  // return System.Configuration.ConfigurationSettings.AppSettings["MYdatabaseconn"] + System.Web.HttpContext.Current.Server.MapPath(System.Configuration.ConfigurationSettings.AppSettings["mydatabasepath"]);
   return System.Configuration.ConfigurationSettings.AppSettings["myConnectionString"];
  }
}

//***********************************************************
/// <summary>得到一个表,已重载
/// </summary>
//***********************************************************
public static DataTable gettable(string sqlstring)
{
  SqlConnection db =new SqlConnection (ConnectionString);
  SqlDataAdapter dp =new SqlDataAdapter(sqlstring, db);
  DataSet ds=new DataSet();
  dp.Fill(ds, "table0");
  db.Close();
  //HttpContext.Current.Cache("mycache") = mydataset.Tables(0)
  //删除:Cache.Remove("mycache")
  return ds.Tables[0];
}
public static DataTable gettable(int boardid)
{
  SqlConnection db =new SqlConnection (ConnectionString);
  SqlDataAdapter dp =new SqlDataAdapter("select * from articles where art_col_sub="+boardid+"   order by id desc", db);
  DataSet ds=new DataSet();
  dp.Fill(ds, "table0");
  db.Close();
  return ds.Tables[0];
}

//***********************************************************
/// <summary>得到一个dataset,已重载
/// </summary>
//***********************************************************
  public static DataSet getdataset(string sqlstring)
{
  SqlConnection db =new SqlConnection (ConnectionString);
  SqlDataAdapter dp =new SqlDataAdapter(sqlstring, db);
  DataSet ds=new DataSet();
  dp.Fill(ds, "table0");
  db.Close();
  //HttpContext.Current.Cache("mycache") = mydataset.Tables(0)
  //删除:Cache.Remove("mycache")
  return ds;
}

//***********************************************************
/// <summary>查找数据
/// </summary>
//***********************************************************
public static bool findrecord(string sqlstring)
{
  if(gettable(sqlstring).Rows.Count>0)
   return true;
    else
   return false;
   }

public static string format_more(object obj)
{
  if (obj==null)
   return "";
  else
  {
   String text=obj.ToString();
   if (text.Length>10)
    return text.Substring(0,10)+"......";
   else
    return text;
  }
}
public static string format_more(object obj,int n)
{
  if (obj==null)
   return "";
  else
  {
   String text=obj.ToString();
   if (text.Length>n)
    return text.Substring(0,n)+"......";
   else
    return text;
  }
}

//***********************************************************
///    MY FORMAT URL
///    例: WWW.21CN.COM?AA=ABC&PAGE=1   返回值WWW.21CN.COM?AA=ABC&
///    作用:解决分页显示的问题
//***********************************************************
  public static string format_url()
{
  if (System.Web.HttpContext.Current.Request.ServerVariables["QUERY_STRING"]==null)
  {       return System.Web.HttpContext.Current.Request.ServerVariables["URL"] + "?";}
  else
  {
   String MYURL = (System.Web.HttpContext.Current.Request.ServerVariables["URL"] + "?" + System.Web.HttpContext.Current.Request.ServerVariables["QUERY_STRING"]).ToUpper();
   int l = MYURL.IndexOf("PAGE=".ToUpper());
   if( l > 0 )
    return (MYURL.Substring(0, l));
   else
    return MYURL + "&";

  }
}

//'***********************************************************
///'DELETE RECORD
//'***********************************************************
public static void record_del(string myid,string table_name)
{
  SqlConnection db =new SqlConnection (ConnectionString);
  SqlCommand mycommand = new SqlCommand("delete from "+table_name+" where id=" + myid, db);
  db.Open();
  mycommand.ExecuteNonQuery();
  db.Close();
}

//'***********************************************************
//'MY FORMAT memory field
//'例: a b   返回值a b
//'作用:解决备注字段的转换
//'***********************************************************
public static string format_memory(string memory_field )
{
  memory_field = memory_field.Replace("/n/n", "<p>");
  memory_field = memory_field.Replace("/n", "<BR>"); ///enter
  // memory_field = memory_field.Replace ( Convert.ToChar(32) , " "); ///'SPACEBAR
  // memory_field = memory_field.Replace("<", "<");
  // memory_field= memory_field.Replace(">", ">");
  //memory_field = memory_field.Replace("/"", """);
  return memory_field;
}
}
//}