Datatable : ReadErrorLog

[Sandeep Shankar]

I am newbie in C# world, developing SMO application.

I was looking ReadErrorLog method of JobServer class which returns
Datatable.
My Question is, How I would know what columns are returning from
ReadErrorLog .



Thanks

 

[Guest]

One easy way is to simply examine the Columns collection of the returned
DataTable. Each column has a name.

-- Peter
Site: http://www.eggheadcafe.com
UnBlog: http://petesbloggerama.blogspot.com
BlogMetaFinder(BETA): http://www.blogmetafinder.com

 

[Sandeep Shankar]

How would I know What column ReadErrorLog is returning? I am not able to
find anything in help.

 

[Guest]

foreach(DataColumn column in myReadErrorLogDataTable.Columns)
{
Console.WriteLine( column.ColumnName );
}

-- Cheers,
Peter
Site: http://www.eggheadcafe.com
UnBlog: http://petesbloggerama.blogspot.com
BlogMetaFinder(BETA): http://www.blogmetafinder.com

 

[Sandeep Shankar]

Thank you very much It worked just fine.

I am just learning C#, I am DBA and writing some tool to administrate DB.

Once again Thanks