ASP.NET

ASP.NET RSS

how can connect the database

Please support our ASP.NET advertiser: Intel Parallel Studio Home

•

Join Date: Jan 2008

Posts: 1

Reputation: snifer is an unknown quantity at this point

Solved Threads: 0

snifer

Offline

Newbie Poster

how can connect the database

Jan 22nd, 2008

hi friends,
i had a problem when connecting the database to the asp.net. My database is SQL server 2005

•

Join Date: Apr 2005

Posts: 1

Reputation: Bombdrop is an unknown quantity at this point

Solved Threads: 0

Bombdrop

Offline

Newbie Poster

Re: how can connect the database

Jan 22nd, 2008

the following site shows connection string for all manor of DB's Connectionstrings.com/

•

Join Date: Nov 2007

Posts: 2,641

Reputation: Jx_Man is a glorious beacon of light

Solved Threads: 245

Jx_Man

Offline

Posting Maven

Re: how can connect the database

Jan 22nd, 2008

this following code to connect asp.net with sqlserver

 Help with Code Tags 
 ASP.NET Syntax (Toggle Plain Text) 
Imports System.Data
Imports System.Data.SqlClient
 
Module ConnectionDB
    Public conn As New SqlConnection("Server = j3rry;" & "initial Catalog = PP60;" & " Trusted_Connection=yes")
End Module
Imports System.Data
Imports System.Data.SqlClient

Module ConnectionDB
    Public conn As New SqlConnection("Server = j3rry;" & "initial Catalog = PP60;" & " Trusted_Connection=yes")
End Module

Never tried = Never Know
So, Please do something before post your thread.
* PM Asking will be ignored *

•

Join Date: Dec 2007

Posts: 291

Reputation: ericstenson is an unknown quantity at this point

Solved Threads: 29

ericstenson ericstenson is offline

Offline

Posting Whiz in Training

Re: how can connect the database

Jan 22nd, 2008

... try using the New SQL Datasource option to make sure your creds are good.

--
"Dummy."

•

Join Date: Feb 2003

Posts: 793

Reputation: Paladine has a spectacular aura about

Solved Threads: 26

Paladine

Offline

Master Poster

Re: how can connect the database

Jan 22nd, 2008

You could also place this "connection" in a Web.config file, for security purposes...

And to be sure... what version of ASP.NET are you speaking of? .Net 1.0, 1.1, 2.0, 3.0 ?

2.0 Tutorial: http://aspnet.4guysfromrolla.com/articles/110905-1.aspx

Last edited by Paladine; Jan 22nd, 2008 at 10:46 pm. Reason: Adding URL

Assistant Manager, Pharmacy Informatics
Wordpress Learning Blog
Updated : ASP.Net Login Code