how to access sql database in asp.net

You can refer the following 2 links to get your job done:

1. http://msdn.microsoft.com/en-us/library/ff648340.aspx[^]
this will help in connection, its easy and clear.

2. http://msdn.microsoft.com/en-us/library/6759sth4%28v=vs.71%29.aspx[^]

this one is for displaying or accessing records

try on this one
step by step tutorial

http://www.w3schools.com/aspnet/aspnet_intro.asp[^]


http://www.w3schools.com/sql/sql_intro.asp[^]

If you want to display records from database means you have to use some grids and want to open connection

sqlconnection con=new sqlconnection("Data Source=aa;UID=dd;password=ee;database=xx");
con.open();

con.close();

<connectionStrings>

<add name="Personal" connectionString=" Server=whsql-v04.prod.mesa1.secureserver.net; Database=DB_675; User ID=user_id; Password=password; Trusted_Connection=False" providerName="System.Data.SqlClient" /> <remove name="LocalSqlServer"/> <add name="LocalSqlServer" connectionString=" Server=whsql-v04.prod.mesa1.secureserver.net; Database=DB_675; User ID=user_id; Password=password; Trusted_Connection=False" providerName="System.Data.SqlClient" />

</connectionStrings>

To connect to SQL Server from C#.NET, you need to create a connection string such as below:

private SqlConnection connection;
private string connectionString =
@"Server=(local);Database=Embedding_SQL_Test;User ID=sa;Password=123";
connection = new SqlConnection( connectionString );

Next, you use the SqlConnection object created above to create a 'SqlCommand', as shown below:
SqlCommand cmd = new SqlCommand( "select * from Customer where CustomerID = @Cid", connection);

The SQL query shown here can be replaced by a SELECT, INSERT, UPDATE queries etc.

Next to execute the SQL queries in the database, you use the following methods:
ExecuteReader - to execute SELECT queries
ExecuteNonQuery - to execute INSERT, DELETE, UPDATE, and SET statements.

This is a very short description of how to connect to SQL Server database from C# and execute SQL queries in the database.
For details about the connection string, the methods and their parameters check the following link: ( http://www.shahriarnk.com/Shahriar-N-K-Research-Embedding-SQL-in-C-Sharp-Java.html )
Here you will also find details about how to pass parameters to the SQL queries as well as calling stored procedures and much more.

By searching google or any search engine site.