-----------------------------------------------------------
New Message on BDOTNET
-----------------------------------------------------------
From: maheshwarisonia
Message 2 in Discussion
Hello Shital,
You can use the sp_helpdb stored procedure for getting the information of
table.I am sending you the code.This will return the information about the
specific database.If you want to get the all database information change
SQLStmt="sp_helpdb"
Dim SQLStmt as String = "sp_helpdb [" & DatabaseName & "]"
Dim Con as SQLConnection = New SQLConnection(conString)
Con.Open()
Dim cmd as SQLCommand = New SQLCommand(SQLStmt, Con)
Dim DR as SQLDataReader
DR = cmd.ExecuteReader()
If DR.Read()
_Owner = dr("Owner")
_DateCreated = dr("Created")
_DatabaseSize = dr("db_size")
dr.NextResult()
dr.read()
_MaximumSize = dr("MaxSize")
_FileSize = dr("size")
End If
DR.Close
Con.Close
DR = Nothing
Con = Nothing
cmd = Nothing
I think it will help you.If you find any problem then feel free to ask.
Regards,
Soniya
>From: "shitalpdesai" <[EMAIL PROTECTED]>
>Reply-To: "BDOTNET" <[email protected]>
>To: "BDOTNET" <[email protected]>
>Subject: How Retrieve SQL Database Information using VB.Net?
>Date: Tue, 7 Jun 2005 23:52:37 -0700
>
_________________________________________________________________
Can�t have enough of SRK? http://server1.msn.co.in/sp05/iifa/ Help him bag
the award.
-----------------------------------------------------------
To stop getting this e-mail, or change how often it arrives, go to your E-mail
Settings.
http://groups.msn.com/bdotnet/_emailsettings.msnw
Need help? If you've forgotten your password, please go to Passport Member
Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help
For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact
If you do not want to receive future e-mail from this MSN group, or if you
received this message by mistake, please click the "Remove" link below. On the
pre-addressed e-mail message that opens, simply click "Send". Your e-mail
address will be deleted from this group's mailing list.
mailto:[EMAIL PROTECTED]
