我做了一个。net小程序。用的是sql数据库。但是有些数据只能在另一个服务器上的Sybase数据库上取。所以我写了一段连接Sybase的代码。但是报错。求各位大神赐教
AseConnection con = new AseConnection();
con = new AseConnection("Data Source=115.238.39.90;Port=5000;database=drms;User id=sa;Password=123321;");
con.Open();
AseCommand da = new AseCommand("select * from pos.p_inv where piv_br_id = 0001 and piv_date = 2013-05-23", con);
AseDataReader dr = da.ExecuteReader();
FileStream fs = new FileStream("D:\\2.txt", FileMode.Open);
StreamWriter sw = new StreamWriter(fs, Encoding.Default);
while (dr.Read())
{
string a1 = dr.GetString(dr.GetOrdinal("piv_bill_no"));
string a2 = dr.GetString(dr.GetOrdinal("piv_br_id"));
DateTime a3 = dr.GetDateTime(dr.GetOrdinal("piv_date"));
string a4 = dr.GetString(dr.GetOrdinal("piv_time"));
string a5 = dr.GetString(dr.GetOrdinal("piv_emp"));
decimal a6 = dr.GetDecimal(dr.GetOrdinal("piv_zk_amt"));
}
string str = a1.ToString() + "," + a2.ToString() + "," + a3.ToString() + "," + a4.ToString() + "," + a5.ToString() + "," + a6.ToString();
dr.Close();
con.Close();
这段代码编译是成功的。但是运行就报错。。.NETSybase服务器数据库String
AseConnection con = new AseConnection();
con = new AseConnection("Data Source=115.238.39.90;Port=5000;database=drms;User id=sa;Password=123321;");
con.Open();
AseCommand da = new AseCommand("select * from pos.p_inv where piv_br_id = 0001 and piv_date = 2013-05-23", con);
AseDataReader dr = da.ExecuteReader();
FileStream fs = new FileStream("D:\\2.txt", FileMode.Open);
StreamWriter sw = new StreamWriter(fs, Encoding.Default);
while (dr.Read())
{
string a1 = dr.GetString(dr.GetOrdinal("piv_bill_no"));
string a2 = dr.GetString(dr.GetOrdinal("piv_br_id"));
DateTime a3 = dr.GetDateTime(dr.GetOrdinal("piv_date"));
string a4 = dr.GetString(dr.GetOrdinal("piv_time"));
string a5 = dr.GetString(dr.GetOrdinal("piv_emp"));
decimal a6 = dr.GetDecimal(dr.GetOrdinal("piv_zk_amt"));
}
string str = a1.ToString() + "," + a2.ToString() + "," + a3.ToString() + "," + a4.ToString() + "," + a5.ToString() + "," + a6.ToString();
dr.Close();
con.Close();
这段代码编译是成功的。但是运行就报错。。.NETSybase服务器数据库String
解决方案 »
- 如何找出服务器上包含指定字符的文件!求
- 我的连接字符串怎么写都不行!
- asp.net编程经验浅谈@@
- 水晶报表提示:出现通信错误。将停止打印
- 2个div完美实现GridView表头固定
- 图片调整问题
- 哪位遇见过,response.redirect 不可用的情况?我有的页面里头可以redirect,有的就不行,头疼死了!
- 最后25分提一个问题!关于Apache + mod_asp.net + mono + mysql 的在windows和liunx平台下服务器配置的相关知识,请高人指点!
- 请问:Windows 窗体 DataGrid 控件 上显示 datetime 字段的值,为什么只显示日期 不显示时间?
- 哪里可以得到免费的SSL证书?
- 求Gridview 一个单元格中显示多张缩微图的方法
- Asp.net+JQuery导入Linkedin Profile信息
代码 OdbcConnection con = new OdbcConnection(); //连接Sybase数据库
con = new OdbcConnection("Dsn=server;database=drms;server=server;port=5000;uid=sa;pwd=123321");
con.Open();
OdbcCommand da = new OdbcCommand("select * from pos.p_inv where piv_br_id = 0001 and piv_date = 2013-05-23", con);