OleDbConnectionStringBuilder ac = new OleDbConnectionStringBuilder();
ac.DataSource = @"E:\code\t同學錄\My_class.mdb";
ac.Provider = "Microsoft.Jet.OLEDB.4.0";
//怎样使用使用相对路径使程序再别的机子上不用调试也能运行?
//还有怎样修改代码使程序简洁,而不是每次连接数据库都写同样的代码?
解决方案 »
- C# serialport 的write
- dataGridView数据绑定出现这个怎么解决
- 请教:窗体间的操作问题
- remoting问题,提示异常:remoting 未处理serializationException,Invalid type code in stream 'Invalid'..[在线急等]
- 怎么在datagridview中显示图片 如果用string sql = "select ydy.照片 as 照片 from ydy where 专项='划船'";
- dataGrid的问题,帮我看看吧
- ComboBox的DataBindings属性和DataSource属性,能同时使用吗?二者存在冲突吗??解决就给分!
- winform中DataGrid有多大用处????
- 怎么通过窗体的Hwnd取得窗体的Document对象
- Request.UserHostName到底在什么情况下才能获得浏览器段的计算机名?
- 窗體切換時....在綫等.....
- 开头这几句是什么意思?
<?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);