Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Web Sevice Documentation Expand / Collapse
Author
Message
Posted Monday, March 7, 2011 10:16 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, April 24, 2014 12:52 PM
Points: 6, Visits: 47
I need to provide some documentation for a .net web service I'm providing. These are largely made up of stored procedures pulling data from a sql views. I have alll of the Red Gate tools which are great, but the Sql doc tool does not seem to provide the underlying datatype for the fields. Can anyone provide an easy way to provide the field list with data types?

Post #1074297
Posted Monday, March 7, 2011 12:34 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: 2 days ago @ 9:10 AM
Points: 13,230, Visits: 12,709
What about your wsdl file? That has everything in there.

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Moden's splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs
Understanding and Using APPLY (Part 1)
Understanding and Using APPLY (Part 2)
Post #1074404
Posted Monday, March 7, 2011 12:42 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, April 24, 2014 12:52 PM
Points: 6, Visits: 47
I thought it might, but no. Not the fields in the dataset which come from the view inbeaded in a stored procedure.
Post #1074413
Posted Monday, March 7, 2011 12:50 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: 2 days ago @ 9:10 AM
Points: 13,230, Visits: 12,709
Since this is .net and you sending this data from views I will assume your are using a DataTable to hold the data? You could debug the code and look at the DataTable.

something like
string output = string.Empty;
foreach (DataColumn col in myDataTable.Columns)
{
output += col.ColumnName + "\t" + col.DataType.ToString() + "\r";
}



_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Moden's splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs
Understanding and Using APPLY (Part 1)
Understanding and Using APPLY (Part 2)
Post #1074417
Posted Monday, March 7, 2011 12:55 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, April 24, 2014 12:52 PM
Points: 6, Visits: 47
Not a bad way to get it done. Thank You.
Post #1074421
Posted Monday, March 7, 2011 12:58 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: 2 days ago @ 9:10 AM
Points: 13,230, Visits: 12,709
Thanks. Admittedly not the way i would write it if it wasn't a one time thing. Appending strings and such. UGH!!! Hope this helps.

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Moden's splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs
Understanding and Using APPLY (Part 1)
Understanding and Using APPLY (Part 2)
Post #1074425
Posted Tuesday, March 8, 2011 10:25 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, April 24, 2014 12:52 PM
Points: 6, Visits: 47
The col.datatype gets me a string but no max length. Is it possible to get max length?
Post #1074959
Posted Tuesday, March 8, 2011 10:35 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: 2 days ago @ 9:10 AM
Points: 13,230, Visits: 12,709
Of course there really isn't a max length on System.String in .net. Well there is but it is totally huge. You are now trying to get the field size of underlying tables from a view.

You could use
select sc.* from sysobjects so
join syscolumns sc on sc.id = so.id
where so.name = 'your view name here'

You will have to look at the xtype column to determine the datatype and the length column. Remember that if the column is nchar, nvarchar that the max length is half of the length because it takes 2 bytes to store each character. I found a decent listing of xtypes as related to columns here. Maybe this will get you in the right direction?




_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Moden's splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs
Understanding and Using APPLY (Part 1)
Understanding and Using APPLY (Part 2)
Post #1074961
Posted Tuesday, March 8, 2011 10:38 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: 2 days ago @ 9:10 AM
Points: 13,230, Visits: 12,709
This is better. It will directly get you the datatype name.

select t.name, sc.* from sysobjects so
join syscolumns sc on sc.id = so.id
join systypes t on t.xtype = sc.xtype
where so.name = 'your view here'



_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Moden's splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs
Understanding and Using APPLY (Part 1)
Understanding and Using APPLY (Part 2)
Post #1074965
Posted Tuesday, March 8, 2011 10:42 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, April 24, 2014 12:52 PM
Points: 6, Visits: 47
That's what I was starting do. Sql is the best place for this, then I will get the field lenght from the database. I'm a sql guy trying to do everything in .net. There are too many ways to skin a cat. If I'm correct, I can just create a stored procedure to dump all of the specifics of the view out to a gridview for the customer.

Thanks again for your help.
Tom Brown
Post #1074967
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse