database problem in vb.net

[amaneet]

Sir/Madam, Can I programically find out whether the particular table exist in the database or not. Thanks abd Regards

[Walter_H]

you can do this by querying the DataSet's table-Collection with the method Contains. e.g: Dim ds As New DataSet ... If ds.Tables.Contains("YourTableName") Then ... End If - walter

[Colin Angus Mackay]

amaneet wrote:

Can I programically find out whether the particular table exist in the database or not.

Yes, however the exact query depends on the database. For example, in SQL Server 2000 the query

SELECT * FROM INFORMATION_SCHEMA.TABLES

gives you your starter for 10.

---

Upcoming Scottish Developers events: * Glasgow: Tell us what you want to see in 2007 My: Website | Blog | Photos

[Colin Angus Mackay]

He said database, not DataSet.

---

Upcoming Scottish Developers events: * Glasgow: Tell us what you want to see in 2007 My: Website | Blog | Photos

[Walter_H]

your're right! sorry - walter