StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
18041496
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
1
CommunityOwnedDate
CreationDate
2013-08-04T09:25:09.720
FavoriteCount
0
LastActivityDate
2013-08-04T09:33:35.950
LastEditDate
2013-08-04T09:33:35.950
LastEditorUserId
447156
OwnerUserId
447156
ParentId
18041266
PostTypeId
2
Score
2
ViewCount
0
LastEditorDisplayName
text
Body
<blockquote> I converted the date to dd-MM-yyyy and saved these dates in the database having column of type varchar </blockquote> No offense but this is terribly wrong. There is no reason to use <code>varchar</code> as column type for your date values. Use <code>DATE</code> or <code>DATETIME</code> column types instead. That's what they for. <ul> <li><a href="http://www.tutorialspoint.com/mysql/mysql-data-types.htm" rel="nofollow">MySQL Data Types</a></li> </ul> In your case, I suggest you to use <code>DATE</code> column type because it supports <code>YYYY-MM-DD</code> format. And you should always use <a href="http://www.codinghorror.com/blog/2005/04/give-me-parameterized-sql-or-give-me-death.html" rel="nofollow">parameterized queries</a>. This kind of string manipulations are open for <a href="http://en.wikipedia.org/wiki/SQL_injection" rel="nofollow">SQL Injection</a> attacks. <pre><code>string dateFrom = dtp_dfrom.Value.ToString("YYYY-MM-DD"); string dateTo = dtp_dto.Value.ToString("YYYY-MM-DD"); using(MySqlConnection conn = new MySqlConnection(myconstring)) { DataTable dt = new DataTable(); using(MySqlCommand cmd = new MySqlCommand("SELECT trans_date, product_type AS Item, product_quantity, amount, SUM( product_quantity ) AS Qty, SUM( amount ) AS 'Total Price' FROM main_table WHERE trans_date BETWEEN @dateFrom AND @dateTo GROUP BY product_type")) { cmd.Parameters.AddWithValue("@dateFrom", dateFrom); cmd.Parameters.AddWithValue("@dateTo", dateTo); MySqlDataAdapter sda = new MySqlDataAdapter(cmd, conn); sda.Fill(dt); } } </code></pre>
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POGetting Data Between Two Dates From MySql in C#
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USSoner Gönül
UserOwnerUserId
1. USSoner Gönül
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. POGetting Data Between Two Dates From MySql in C#
 singulars
 PostTypePostTypeId
 PTQuestion
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
2. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTAcceptedByOriginator
CommentsPostId
1. COI have changed the column type to DATE as suggested and now i have the following exception : Unable to convert MySQL date/time value to System.DateTime.
 singulars
 PostPostId
 PO
 UserUserId
 USROM

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.