C#连接Sybase数据库
C# ADO.NET访问sybase数据库
需要下载三个dll
下载地址 http://down1.infnitee.com/download/sybase_dll.rar
数据库连接:sybase默认端口是5000
Data Source=CY-20131231JCYW;Port=5000;Database=dbname;Uid=userA;Pwd=***;
请求数据库代码:
try { DataTable dt = new DataTable(); AseConnection con = new AseConnection(SYBaseConnectionStr); AseCommand cmd = con.CreateCommand(); cmd.CommandText = "select * from clinic_invoice_detail where expense_date between @date1 and @date2"; cmd.Parameters.Add(new AseParameter("@date1", AseDbType.DateTime) { Value = txt_dateStart.Value }); cmd.Parameters.Add(new AseParameter("@date2", AseDbType.DateTime) { Value = txt_dateEnd.Value }); AseDataAdapter da = new AseDataAdapter(cmd); da.Fill(dt); da.Dispose(); cmd.Dispose(); con.Dispose(); dataGridView1.DataSource = dt; dataGridView1.AutoResizeColumns(); } catch (Exception ex) { MessageBox.Show(ex.ToString()); }
GarsonZhang www.yesdotnet.com
版权声明:本文为YES开发框架网发布内容,转载请附上原文出处连接
post YES开发框架