Error 1 The type or namespace name 'ConfigurationManager' does not exist

The most likely this issue is a missing a reference to the System.Configuration.dll. I had the issue about this when i was working on my Data Access Layer in my project. Eventhough i have declared the "using System.Configuration" namespace. it still didnt work. So i decided to do an Add reference to the System.Configuration.dll at my Class Library Data Access Layer project, then it worked. Hope this helps

SQL Data Statements

Select Statements

Select fieldname , fieldname From table name

example: Select DistributorID , DistributorName From DistributorTable


Update Statements

UPDATE table name
Set fieldname = value

example:

Update Customers
Set Name = 'Jerry'


Delete Statements

Delete From tablename

example:

Delete From Customers

Connection Strings

SQL Connection String
Data Source=ServerName;Initial Catalog=DatabaseName;Persist Security Info=True;User ID=username;Password=password;

OLEDB Connection String
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\mydatabase.mdb;User Id=username;Password=password;


Oracle Connection String
Provider=msdaora;Data Source=MyOracleDataBase;User Id=myUsername;Password=myPassword;