C#Express - get datset into a datasource to be used in datagrid

Question

C# express does not have the nice IDE features that lets me bind to an SQL Server like it would and Access database so....

I created a class that retrieves the data I want and puts it in a DataSet.

How do I get this DataSet as a DataSource that the IDE can use for setting up tableAdapters, dataBinders and gridViews?

I really need help on this....4 hours and no progress...please


stuntman

Answer 1

Its not the sql query im confused about its more about how the easiest way is to work with a datetime in C# and in sql. I need to have the dates displayed on my webpage but I also need to use the dates for sorting in my sql queries. I coul dsave the datetime as a string in db so it would be easy to retreive it and display it but im just not sure if I would be able to sort with it since its a string in my db. Then I need to save it as a timestamp in the db but I just want to make sure that sql timestamp is easy to work with and easy to convert into string when i want it in my c# code.

Answer 2

try this code retreive rows sorted by datetime

SELECT orderID, DATEPART(MM,OrderDate) AS OrderMonth FROM Orders

more info

http://www.sqlmag.com/article/articleid/43488/43488.html

Answer 3

hi friend,

Simply using DateTime data type in sqlserver can solve your problem.


Please mark the anser if it helps.