string query = "SELECT Company.`$_DBName`, Company.`$_ThisYearBeg`, Company.`$_ThisYearEnd`, Company.`$_PrevYearBeg`, Company.`$_PrevYearEnd`, Company.`$_ThisQuarterBeg`, Company.`$_ThisQuarterEnd`, Company.`$_PrevQuarterBeg`, Company.`$_PrevQuarterEnd`, Company.`$_Name`, Company.`$_Address1`, Company.`$_Address2`, Company.`$_Address3`, Company.`$_Address4`, Company.`$_Address5` FROM Techweb.TallyUser.Company Company ORDER BY Company.`$_DBName`"; string source = "PORT=9000;DRIVER=Tally ODBC Driver;SERVER={(local)}"; OdbcConnection con = new OdbcConnection(source); OdbcCommand cmd = new OdbcCommand(query,con); con.Open(); OdbcDataAdapter da = new OdbcDataAdapter(query,con); DataSet ds = new DataSet(); da.Fill(ds); DataGrid1.DataSource = ds; DataGrid1.DataBind(); con.Close();
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)