Software Applications Programming Errors and solutions.

Get data from Table using dataTable using c#.net static public DataTable getData(string selectstr) { string connectionString = ""; OleDbConnection connection = null; OleDbDataAdapter adp = null; OleDbCommandBuilder oleDbCommandBuilder = null; DataTable dataTable = null; connectionString = ConfigurationSettings.AppSettings["ConnectionString"]; connection = new OleDbConnection(connectionString); connection.Open(); adp = new OleDbDataAdapter(selectstr, connection); oleDbCommandBuilder = new OleDbCommandBuilder(adp); dataTable = new DataTable(); adp.Fill(dataTable); connection.Close(); return dataTable; }

Companies City Region Country Jordan Data Communications Company Llc Amman Amman Governorate Jordan Godrej Infotech Limited Mumbai Maharashtra India Bharti Broadband Delhi Delhi India Tata Teleservices Ltd - Tata Indicom - Cdma Divisi Mumbai Maharashtra India Excell Media Pvt Ltd Hyderabad Andhra Pradesh India Reliance Communications Pune Maharashtra India Bharti Broadband Bangalore Karnataka India Acd Elektronik Gmbh Almersbach Rheinland-pfalz Germany Mts Allstream Toronto Ontario Canada Tata Communications Gurgaon Haryana India Telekom Malaysia Berhad Petaling Jaya Kuala Lumpur Malaysia Delhi-vsb- Leased Line Tata Teleservices Ltd Chandigarh Chandigarh India Microsoft Corp Asia/pacific Region Tata Teleservices Isp New Delhi Delhi India Telenet N.v. Brussels Brussels Hoofdstedelijk Gewest Belgium Porini Spa Como Lombardia Italy Net4india Ltd. Delhi Delhi India 3bb Broadband Bangkok Krung Thep Thailand Ptv Swiss Ag Bern Bern Switzerland Tata Communications Ahmad...

Symbols in ER Diagrams Rectangle : Entity set Ellipse  : Attribute Diamond : Relation Lines  : links attribute to entity or relation and entities to relations Double ellipse : multivalued attribute Dashed ellipse : derived attribute Double line : total participation of entity in relationship set Inverted triangle : Links sub-type entities with super-type entity