private void Button1_Click (object sender, EventArgs e) {try {//odbcconnect Ion conn = new OdbcConnection (); Conn. ConnectionString =//"ODBC;" +//"Driver={sybase SQL Anywhere 5.0};" +//"defaultdir=c:\myfolder\;" +//"DBF=C:\MYPATH\DBNAME.DB;" + "Uid=username;" +//"Pwd=secret;" +//"DSN ="""";"; Must be included! Conn. Open (); Geovindu connectionString = "DSN=GEOVINDU; UID=DBA; Pwd=sql; "; Data Source=sademo using (odbcconnection connection = new OdbcConnection (connectionString)) {connection. Open (); DataTable dt = new DataTable ();//connection. GetSchema (); DataSet ds = new DataSet (); OdbcdAtaadapter da = new OdbcDataAdapter ("SELECT * FROM Employee", connection); Da. Fill (DS); DT = ds. Tables[0]; Do work here. This.dataGridView1.DataSource = DT; }} catch (OdbcException ex) {MessageBox.Show (ex). Message.tostring ()); } }
Read the numbers as follows:
Csharp:read Sybase SQL anywhere5.5 using C #