OleDbConnectionStringBuilder ac = new OleDbConnectionStringBuilder();
ac.DataSource = @"E:\code\t同學錄\My_class.mdb";
ac.Provider = "Microsoft.Jet.OLEDB.4.0";
//怎样使用使用相对路径使程序再别的机子上不用调试也能运行?
//还有怎样修改代码使程序简洁,而不是每次连接数据库都写同样的代码?
解决方案 »
- c#文件上传 如何调试AjaxuploadHandler.ashx
- winform 默认配置文件的问题
- C#编写的程序中,源代码指哪些内容?
- c# 将获取了句柄的窗体移动到某一位置 问题2
- 怎么实现鼠标点到图片就自动弹出一个层????
- abnormal program termination,高手请帮忙啊
- winform 自定义报表
- System.UnauthorizedAccessException: 对路径“c:\inetpub\wwwroot\TragramMini\WebTragMini\tan\Up?
- 怎样通过一个button的单击事件执行其它应用程序。如setup.exe!!!!!!!!!!!再线等待!!!!!!!!!!!!!!!!!!!!!!!马上给
- 怎样判断一个字串是不是数字字串?
- 窗體切換時....在綫等.....
- 开头这几句是什么意思?
<?xml version="1.0" encoding="utf-8"?>
<configuration>
<appSettings>
</appSettings>
<connectionStrings>
<add name="ConnectionString" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|\My_class.mdb;Persist Security Info=True" providerName="System.Data.OleDb" />
</connectionStrings>
</configuration>
然后:
string ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
<add name="accessConnStr" connectionString="Provider=Microsoft.Jet.OLEDB.4.0; Data Source= |DataDirectory|a.mdb" providerName="System.Data.OleDb"/> <appSettings>
<add key="ConnString" value="provider=microsoft.jet.oledb.4.0;data source="/>
<add key="dbPath" value="~/App_Data/a.mdb"/>
</appSettings>
string connectionString = "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source=~/database/a.mdb";
{
OleDbConnectionStringBuilder ac = new OleDbConnectionStringBuilder();
ac.DataSource = Application.StartupPath + "\\My_class.mdb"; //这样改不行
ac.Provider = "Microsoft.Jet.OLEDB.4.0";
if (fin_nam.Text != "") //按姓名查找
{
using (OleDbConnection oc = new OleDbConnection(ac.ConnectionString))
{
DataSet ds = new DataSet(); try
{
oc.Open();
string str = "select nam,sex,qq,tel,eml,add,ima from cla_tab where nam='" + this.fin_nam.Text.Trim() + "'"; //匹配姓名
OleDbDataAdapter adt = new OleDbDataAdapter(str, oc);
adt.Fill(ds, "cla_tab");
…… }
catch (Exception)
{ MessageBox.Show("查詢失敗!");
}
finally
{ oc.Close(); }
}
}
else
MessageBox.Show("請輸入查詢條件!");
}
//搞定了,把access数据库放到debug目录下就行了,谢谢搂下各位大侠!
ac.DataSource =@ Application.StartupPath + "\\My_class.mdb";
OleDbConnectionStringBuilder ac = new OleDbConnectionStringBuilder();
ac.DataSource = @Application.StartupPath + "\\My_class.mdb";
ac.Provider = "Microsoft.Jet.OLEDB.4.0";
using (OleDbConnection oc=new OleDbConnection(ac.ConnectionString))
{
DataSet ds = new DataSet();
try
{
oc.Open();
string str = "delete from cla_tab where nam='"+this.show_nam.Text.Trim()+"'"; //这一句可以直接执行
OleDbDataAdapter adt = new OleDbDataAdapter(str, oc);
adt.Fill(ds, "cla_tab");
File.Copy(filename, Application.StartupPath + "\\ima_dat\\" + name, true); //oc1.Open();
string str1 = "Insert Into cla_tab values('" + show_nam.Text.Trim() +
"','" + show_sex.Text.Trim() +
"','" + sho_q.Text.Trim() +
"','" + sho_tel.Text.Trim() +
"','" + sho_ema.Text.Trim() +
"','" + sho_add.Text.Trim() +
"','" + name.Trim() + "')"; //为什么这一句就跳过了?
OleDbCommand os = new OleDbCommand(str1, oc);
os.ExecuteNonQuery();
string constr = System.Configuration.ConfigurationManager.AppSettings["ConnectionString"];
OleDbConnection con = new OleDbConnection(constr);
string constr = System.Configuration.ConfigurationManager.AppSettings["ConnectionString"];
OleDbConnection con = new OleDbConnection(constr);