Comments by Munavar Ankathil (Top 1 by date)

Thanks santhosh
Tally connectin is ready But when I Try to fill the dataset i getting another error "The connection has been disabled."
My code is below

OdbcCommand TallyCommand = new OdbcCommand("SELECT StockItem.$Name, StockItem.$Parent FROM TESTER.TallyUser.StockItem ORDER BY StockItem.$Name", TallyConnection);
OdbcDataAdapter TallyDataAdapter = new OdbcDataAdapter(TallyCommand);
DataSet TallyDataSet = new DataSet();
TallyDataAdapter.Fill(TallyDataSet);
TallyCollectionConnection.Close();
return TallyDataSet;