query for monthly report
-
hi, i need to get data from database on monthly basis.i need to select month from UI, based on that , i want the records in database. am using Mysql database in c#, any suggestions
-
hi, i need to get data from database on monthly basis.i need to select month from UI, based on that , i want the records in database. am using Mysql database in c#, any suggestions
Member 10263519 wrote:
any suggestions
Sure, craft a select query either as a stored procedure or a string query (remember to use parameters), make a connection to the database, and either execute your query string orthe stored procedure. Bind the results to your display control. Just what are you expecting as an answer to a request for suggestions?
Never underestimate the power of human stupidity RAH
-
Member 10263519 wrote:
any suggestions
Sure, craft a select query either as a stored procedure or a string query (remember to use parameters), make a connection to the database, and either execute your query string orthe stored procedure. Bind the results to your display control. Just what are you expecting as an answer to a request for suggestions?
Never underestimate the power of human stupidity RAH
thanks