SQL string format utility? 1

[jkelly295]

Does anyone know of a utility that you can paste a sql statement from say Query Analyzer and it will create a formatted string for use in an ASP.NET page. Most of the time I use sprocs but sometimes when building dynamic sql statements it would be nice to have this utility.

 

[ca8msm]

What do you mean by a formatted string? You mean to replace all the spaces, tabs and carriage returns so that you could assign it to a string?


____________________________________________________________

Need help finding an answer?

Try the Search Facility or read FAQ222-2244 on how to get better results.

 

[jkelly295]

Select *
FROM Table
Where Field='TheOne'


equals

tSQL = "Select * "
tSQL += "FROM Table "
tSQL += "Where Field='TheOne' "

 

[ca8msm]

You'd presumably have to write an add in for VS or you could create your own simple program to do it. It would be fairly straight forward...


____________________________________________________________

Need help finding an answer?

Try the Search Facility or read FAQ222-2244 on how to get better results.

 

[jkelly295]

Just didn't want to re-invent the wheel if it already existed.

 

[ca8msm]

Fair enough. Something like this may be useful for you then:

http://www.adonetexpress.com/

although I don't think there's a 2005 version of it out yet.


____________________________________________________________

Need help finding an answer?

Try the Search Facility or read FAQ222-2244 on how to get better results.

 

[jkelly295]

That is even more than what I was looking for!
I Had found a few stand alone vb examples but this is the best by far.

Thanks!

 

[BoulderBum]

Both VS.NET and VS 2005 have similar functionality built-in.

VS 2005:

http://www.c-sharpcorner.com/Code/2004/Oct/DataSourceControls.asp

VS.NET:

http://www.developer.com/db/article.php/3092741

Also, in VS.NET, try dragging a table/stored procedure from the Server Explorer->Data Connections->[your database] onto your web form and check out the magic!

...okay, perhaps that's a bit melodramatic, but it will generate the connection, and commands for you so you don't have to write the SQL.