Posted by John Bell on 12/27/06 20:14
Hi
You don't give which version of SQL Server you are using, but you should
find most of what you want to do in parts of the Samples that come with the
product, for instance with SQL 2005 there is a dependency explorer and other
SMO examples which will do something similar to what you require. For SQL
2000 check out the DMO examples.
John
"frien" <001frien@gmail.com> wrote in message
news:1167166884.988685.252620@73g2000cwn.googlegroups.com...
>I am pretty new to the subject...i would really appreciate if you could
> help me with this doubt...
>
> I need to write a C# code which performs the following:
>
> a) connects to the sql server database( I dont know the procedure to
> connect to the data base)
>
> b) on a web page i need to display the list of table names and their
> associated indexes in a tree view ( i.e. parent node should be the name
> of the table and the child nodes should be the index names)
>
> Plz do help me
>
> Thanks a lot
>
[Back to original message]
|