getting database name

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Adi - 20 Jun 2007 21:19 GMT

hi everyone... i have a doubt.. is there any way i can get the
database name.. my page is accessing.. i would like to display the
database name, the current page is accessing. This has to be done
without refering to the connection string which is usually used to
create the connection with the database. i would appreciate for the
help..
thanks
ADITYA

Reply to this Message

Milosz Skalecki [MCAD] - 21 Jun 2007 00:05 GMT

Hi there Adi,

two ways:

1.
string database = ((IDbConnection)myConnection).Database;

2.
SqlCommand command = new SqlCommand("SELECT DB_NAME();", connection);
string database = (string) command.ExecuteScalar();

or use SqlDataSource with SelectCommand property set to "SELECT DB_NAME()"

hope this helps

Signature

Milosz

> hi everyone... i have a doubt.. is there any way i can get the
> database name.. my page is accessing.. i would like to display the
[quoted text clipped - 4 lines]
> thanks
> ADITYA

Reply to this Message

Adi - 21 Jun 2007 15:50 GMT

got it.. thanks milosz..

> Hi there Adi,
>
[quoted text clipped - 21 lines]
> > thanks
> > ADITYA

Reply to this Message

Rate this thread:

getting database name

Free Magazines