
连接代码如下:
private void Frm_Main_Load(object sender, EventArgs e)
{
try
{
string odbcConStr = "server=129.0.0.252;UID=name;PWD=password;database=RGKF";
// string odbcConStr1 = "Data Source=ZHCHL-PC\\SQLEXPRESS;Integrated Security=True";
OdbcConnection odbcCon = new OdbcConnection(odbcConStr);//创建数据库连接对象
OdbcDataAdapter da =//创建数据适配器对象
new OdbcDataAdapter("select * from CT_ZYGS", odbcCon);
DataTable dt = new DataTable();//创建数据表
da.Fill(dt);//填充数据表
this.dgv_Message.DataSource =//设置数据源
dt.DefaultView;
}
catch (Exception ey)//捕获异常
{
MessageBox.Show(ey.Message);//弹出消息对话框
}
}
private void Frm_Main_Load(object sender, EventArgs e)
{
try
{
string odbcConStr = "server=129.0.0.252;UID=name;PWD=password;database=RGKF";
// string odbcConStr1 = "Data Source=ZHCHL-PC\\SQLEXPRESS;Integrated Security=True";
OdbcConnection odbcCon = new OdbcConnection(odbcConStr);//创建数据库连接对象
OdbcDataAdapter da =//创建数据适配器对象
new OdbcDataAdapter("select * from CT_ZYGS", odbcCon);
DataTable dt = new DataTable();//创建数据表
da.Fill(dt);//填充数据表
this.dgv_Message.DataSource =//设置数据源
dt.DefaultView;
}
catch (Exception ey)//捕获异常
{
MessageBox.Show(ey.Message);//弹出消息对话框
}
}

