Click here to Skip to main content
15,911,360 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
how to connect the database in asp.net ?
Posted

 
Share this answer
 
Comments
Uday P.Singh 3-Dec-11 13:09pm    
5ed :)
Abhinav S 4-Dec-11 7:36am    
Good links. 5!
Try googling first before posting.

Here for your reference:
www.connectionstrings.com[^][^]

Regards,
Eduard
 
Share this answer
 
Comments
Abhinav S 4-Dec-11 7:36am    
Yeah that would have been my answer as well. 5.
thatraja 4-Dec-11 7:51am    
5!
Its a Quite Common question here and already answered many time.
Have a look there[^]
where I suggested to navigate http://www.sqlstrings.com/[^]
In addition you can find plenty of question with solutions while CP searching.
Have a look there-[Database Connection in asp.net][^]
 
Share this answer
 
Comments
Abhinav S 4-Dec-11 7:35am    
Good links. 5.
RaviRanjanKr 4-Dec-11 8:54am    
Thanks :)
thatraja 4-Dec-11 7:51am    
5!
RaviRanjanKr 4-Dec-11 8:54am    
Thanks :)
by using code u can connect-

<<br />
<%@ Import Namespace="System.Data.OleDb" %><br />
<script  runat="server"><br />
sub Page_Load<br />
dim dbconn,sql,dbcomm,dbread<br />
dbconn=New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;<br />
data source=" & server.mappath("northwind.mdb"))<br />
dbconn.Open()<br />
sql="SELECT * FROM customers"<br />
dbcomm=New OleDbCommand(sql,dbconn)<br />
dbread=dbcomm.ExecuteReader()<br />
end sub<br />
</script><br />
>
 
Share this answer
 
v2
You can begin with ADO.NET. :-)
 
Share this answer
 
web config file because use globally access a connection
<appsetting>
<add key="conn" value="dataprovider;databasename;username;password">
</add></appsetting>
dim con as sqlconnection
con= new sqlconnection (configurationmanager.appsetting("conn")).tostring
dim sql as string="select * from sample"
cmd=new sqlcommand
with cmd
.connection=conn
.command type=text
.coomandtext=sql
.selectcommand
end with
 
Share this answer
 
v2
Comments
RaviRanjanKr 4-Dec-11 8:57am    
Always wrap your code in pre tag.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900