using System.Data.SqlClient;
using System.Data.SqlTypes;
using System.Configuration;//取得案卷编号******************************************
string strsql = "select mlabg.ajly,mlabg.ajbh,mlabg.dsr,mlabg.dsrlxdz,ajky ,cbr,mzfjbqk.fddbr,mzfjbqk.fddbrdh from mlabg ,mzfjbqk where mlabg.xh = '"+ str_xh +"' and mlabg.xh = mzfjbqk.xh";
SqlDataAdapter MyCommand = new SqlDataAdapter(strsql,conn);
DataSet ds = new DataSet();
MyCommand.Fill(ds);
DataTable MyTable = new DataTable();
MyTable = ds.Tables[0];
if(MyTable.Rows.Count ==1)
{
this.ajbh.Text = MyTable.Rows[0]["ajbh"].ToString().Trim();
this.ajly.Text = MyTable.Rows[0]["ajly"].ToString().Trim();
this.dwmc.Text = MyTable.Rows[0]["dsr"].ToString().Trim();
this.dwdz.Text = MyTable.Rows[0]["dsrlxdz"].ToString().Trim();
this.dcjg.Text = MyTable.Rows[0]["ajky"].ToString().Trim();
this.cbr.Text = MyTable.Rows[0]["cbr"].ToString().Trim();
this.fddbr.Text= MyTable.Rows[0]["fddbr"].ToString().Trim();
this.lxdh.Text = MyTable.Rows[0]["fddbrdh"].ToString().Trim(); }
using System.Data.SqlTypes;
using System.Configuration;//取得案卷编号******************************************
string strsql = "select mlabg.ajly,mlabg.ajbh,mlabg.dsr,mlabg.dsrlxdz,ajky ,cbr,mzfjbqk.fddbr,mzfjbqk.fddbrdh from mlabg ,mzfjbqk where mlabg.xh = '"+ str_xh +"' and mlabg.xh = mzfjbqk.xh";
SqlDataAdapter MyCommand = new SqlDataAdapter(strsql,conn);
DataSet ds = new DataSet();
MyCommand.Fill(ds);
DataTable MyTable = new DataTable();
MyTable = ds.Tables[0];
if(MyTable.Rows.Count ==1)
{
this.ajbh.Text = MyTable.Rows[0]["ajbh"].ToString().Trim();
this.ajly.Text = MyTable.Rows[0]["ajly"].ToString().Trim();
this.dwmc.Text = MyTable.Rows[0]["dsr"].ToString().Trim();
this.dwdz.Text = MyTable.Rows[0]["dsrlxdz"].ToString().Trim();
this.dcjg.Text = MyTable.Rows[0]["ajky"].ToString().Trim();
this.cbr.Text = MyTable.Rows[0]["cbr"].ToString().Trim();
this.fddbr.Text= MyTable.Rows[0]["fddbr"].ToString().Trim();
this.lxdh.Text = MyTable.Rows[0]["fddbrdh"].ToString().Trim(); }
nowDSN = ConfigurationSettings.AppSettings["pdwh"];
conn = new SqlConnection(nowDSN);
{
public static System.Data.SqlClient.SqlConnection sqlcon; }
放在类中,以静态方式,很多全局要用的东西都可以这样放
{
public static string strCon="....";
}
//引用
.....
string myStrConn=ConClass.strConn;
.....
Good Luck
接分
public class DBase
{
...........
private static System.Data.SqlClient.SqlConnection _Cn
=new System.Data.SqlClient.SqlConnection("你的连接字符串");
public static System.Data.SqlClient.SqlConnection Cn
{
get
{
if(_Cn.State!=ConnectionState.Open)
{
_Cn.Open();
}
return _Cn;
}
}
}
访问DBase.Cn
配置文件就是test.exe.config,他是一个xml文件
然后在test.exe.config中编辑:
<?xml version="1.0" encoding="utf-8"?>
<configuration>
<appSettings>
<add key="connstring" value="server=yourservername;user id=user;
password=pwd;database=db"/>
</appSettings>
</configuration>然后在你需要连接数据库的窗体中读取这个配置文件即可比如:
using System.Data.SqlClient;
using System.Xml;
using System.Configuration;
....
string str_conn=ConfigurationSettings.AppSettings["connstring"]; //读取连接信息
SqlConnection conn=new SqlConnection(str_conn);
...注意:配置文件必须和程序集位于相同的文件夹. wish u good luck
Greatsft