Return a table or data set from mysql stored procedure and access in asp.net c# -

i want create sql stored procedure start , end dates parameters.based on start , end dates,procedure should query each day in between start , end dates.and return result table or dataset.how dataset or table result set in asp.net c#? please me in sorting out issue.

use mysqldataadapter

represents set of data commands , database connection used fill dataset , update mysql database

example article:

public dataset selectrows(dataset dataset,string connection,string query)  {     mysqlconnection conn = new mysqlconnection(connection);     mysqldataadapter adapter = new mysqldataadapter();     adapter.selectcommand = new mysqlcommand(query, conn);     adapter.fill(dataset);     return dataset; } 

where selectcommand select query or stored procedure

parameters: mysqlcommand sql select statement or stored procedure , set selectcommand property of mysqldataadapter.