？？有关connstring

alphard 2000-05-25 04:09:00
网站禁止使用server.mappath,如何设置连接串connstring???
...全文
78 1 打赏 收藏 转发到动态 举报
写回复
用AI写文章
1 条回复
切换为时间正序
请发表友善的回复…
发表回复
subzero 2000-05-26
  • 打赏
  • 举报
 回复
那只能用绝对路径了
或者用文件DSN
精彩编程与编程技巧-编写Connect Strings...
精彩编程与编程技巧-编写Connect Strings ...
C#访问数据库资源库（支持Access、MSSql、MySql、Oracle等）让数据库访问更便捷，更稳定
C#访问数据库资源库（支持Access、MSSql、MySql、Oracle等）让数据库访问更便捷，更稳定 如果需要源代码，可通过邮箱cj5260@163.com索取 访问Access数据库方法 UGM.Common.DAL.DB.DBAccessDAL.string getIdentity(OleDbConnection Conn, OleDbTransaction Tran) UGM.Common.DAL.DB.DBAccessDAL.Connect(string DBSource) UGM.Common.DAL.DB.DBAccessDAL.check(OleDbConnection Conn) UGM.Common.DAL.DB.DBAccessDAL.Excute(OleDbConnection Conn, string CommandText) UGM.Common.DAL.DB.DBAccessDAL.convetAccess(string str) UGM.Common.DAL.DB.DBAccessDAL.Analyse(string FieldType) UGM.Common.DAL.DB.DBAccessDAL.ExecuteSql(string SQLString) UGM.Common.DAL.DB.DBAccessDAL.ExecuteSql(string ConnString, string SQLString) UGM.Common.DAL.DB.DBAccessDAL.ExecuteSql(OleDbConnection Conn, string SQLString) UGM.Common.DAL.DB.DBAccessDAL.ExecuteSql(OleDbConnection Conn, OleDbTransaction Tran, string SQLString) UGM.Common.DAL.DB.DBAccessDAL.ExecuteSqlTran(ArrayList SQLStringList) UGM.Common.DAL.DB.DBAccessDAL.ExecuteSqlTran(string ConnString, ArrayList SQLStringList) UGM.Common.DAL.DB.DBAccessDAL.GetSingle(string SQLString) UGM.Common.DAL.DB.DBAccessDAL.GetSingle(string ConnString, string SQLString) UGM.Common.DAL.DB.DBAccessDAL.Query(string SQLString) UGM.Common.DAL.DB.DBAccessDAL.Query(string ConnString, string SQLString) UGM.Common.DAL.DB.DBAccessDAL.Query(string SQLString, int start, int max) UGM.Common.DAL.DB.DBAccessDAL.Query(string ConnString, string SQLString, int start, int max) UGM.Common.DAL.DB.DBAccessDAL.Query(OleDbConnection Conn, string SQLString) UGM.Common.DAL.DB.DBAccessDAL.Query(OleDbConnection Conn, OleDbTransaction Tran, string SQLString) UGM.Common.DAL.DB.DBAccessDAL.ExecuteSql(string SQLString, params OleDbParameter[] cmdParms) UGM.Common.DAL.DB.DBAccessDAL.ExecuteSql(string ConnString, string SQLString, params OleDbParameter[] cmdParms) UGM.Common.DAL.DB.DBAccessDAL.ExecuteSqlTran(Hashtable SQLStringList) UGM.Common.DAL.DB.DBAccessDAL.ExecuteSqlTran(string ConnString, Hashtable SQLStringList) UGM.Common.DAL.DB.DBAccessDAL.GetSingle(string SQLString
未在本地计算机上注册“Microsoft.ACE.OLEDB.16.0”提供程序异常解决办法
下载安装AccessDatabaseEngine_X64后，可以不用再安装office 实现读取Excel文件 代码连接如下：private static string connString = "provider=Microsoft.ACE.OLEDB.16.0;Data Source={0};Extended Properties=Excel 8.0";
C#Access代码下载
C#Access代码下载using System;using System.Data;using System.Data.OleDb;namespace AccessDb{    ///     /// AccessDb 的摘要说明，以下信息请完整保留    /// 请在数据传递完毕后调用Close()方法，关闭数据链接。    ///     public class AccessDbClass    {        #region 变量声明处        public OleDbConnection Conn;        public string ConnString;//连接字符串        #endregion        #region 构造函数与连接关闭数据库        ///         /// 构造函数        ///         /// ACCESS数据库路径        public AccessDbClass(string Dbpath)        {            ConnString = "Provider=Microsoft.Jet.OleDb.4.0;Data Source=";            ConnString += Dbpath;            Conn = new OleDbConnection(ConnString);            Conn.Open();
城市的连动效果
实现城市连动 using System; using System.Collections; using System.Configuration; using System.Data; using System.Linq; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.HtmlControls; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Xml.Linq; using System.Data.SqlClient; namespace _0327Province_City_代码实现_ { public partial class _Default : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { string connstring = @"Data Source=.\SQLExpress;Initial Catalog=IDInfoDB;Integrated Security=True";//@表示转义字符 .\sqlexpress表示数据源 SqlConnection sconn = new SqlConnection(connstring); string Tablename = "province"; string selectstring = "select * from " + Tablename; SqlDataAdapter sda = new SqlDataAdapter(selectstring, sconn); DataSet ds = new DataSet(); sconn.Open(); sda.Fill(ds, Tablename); sconn.Close(); this.ddl_Province .DataSource = ds.Tables[Tablename].DefaultView; this.ddl_Province .DataTextField = "province"; this.ddl_Province .DataValueField = "provinceID"; this.ddl_Province .DataBind(); } } protected void ddl_City_SelectedIndexChanged(object sender, EventArgs e) { if (this.ddl_City .SelectedIndex >= 0) { string connstring = @"Data Source=.\SQLExpress;Initial Catalog=IDInfoDB;Integrated Security=True";//@表示转义字符 .\sqlexpress表示数据源 SqlConnection sconn = new SqlConnection(connstring); string Tablename = "area"; string selectstring = "select * from " + Tablename + " where cityid='" + this.ddl_City .SelectedValue + "'"; SqlDataAdapter sda = new SqlDataAdapter(selectstring, sconn); DataSet ds = new DataSet(); sconn.Open(); sda.Fill(ds, Tablename); sconn.Close(); this.ddl_Area .DataSource = ds.Tables[Tablename].DefaultView; this.ddl_Area .DataTextField = "area"; this.ddl_Area .DataValueField = "areaID"; this.ddl_Area .DataBind(); } } protected void ddl_Province_SelectedIndexChanged(object sender, EventArgs e) { if (this.ddl_Province .SelectedIndex >= 0) { string connstring = @"Data Source=.\SQLExpress;Initial Catalog=IDInfoDB;Integrated Security=True";//@表示转义字符 .\sqlexpress表示数据源 SqlConnection sconn = new SqlConnection(connstring); string Tablename = "city"; string selectstring = "select * from " + Tablename + " where provinceid='" + this.ddl_Province .SelectedValue + "'"; SqlDataAdapter sda = new SqlDataAdapter(selectstring, sconn); DataSet ds = new DataSet(); sconn.Open(); sda.Fill(ds, Tablename); sconn.Close(); this.ddl_City .DataSource = ds.Tables[Tablename].DefaultView; this.ddl_City .DataTextField = "city"; this.ddl_City .DataValueField = "cityID"; this.ddl_City .DataBind(); } } } }
ASP

28,390

社区成员

357,068

社区内容

发帖
与我相关
我的任务
社区描述
ASP即Active Server Pages，是Microsoft公司开发的服务器端脚本环境。
社区管理员
  • ASP
  • 无·法
加入社区
  • 近7日
  • 近30日
  • 至今

加载中

查看更多榜单
社区公告
暂无公告

试试用AI创作助手写篇文章吧

+ 用AI写文章