The SelectCommand property has not been initialized before calling 'Fill'.

See more:

C#

ASP.NET

Hi i am new in C# and this is my code. when i want to get report (in excel) from a date range it shown error. the error is "the selectcommand property has not been initialized before calling 'fill'."


Please help me...... my code is...........





protected void btshow_Click(object sender, EventArgs e)
{
DataSet dsExport = GetData();
System.IO.StringWriter tw = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter hw =
new System.Web.UI.HtmlTextWriter(tw);
DataGrid dgGrid = new DataGrid();
dgGrid.DataSource = dsExport;

//Report Header

// Get the HTML for the control.
dgGrid.HeaderStyle.Font.Bold = true;
dgGrid.DataBind();
dgGrid.RenderControl(hw);

// Write the HTML back to the browser.
Response.ContentType = "application/vnd.ms-excel";
this.EnableViewState = false;
Response.Write(tw.ToString());
Response.End();

}

public DataSet GetData()
{
DataSet dataSet = new DataSet();
SqlDataAdapter dataAdapter = new SqlDataAdapter();
SqlConnection cnn = new SqlConnection("user id=sa;" +
"password=prodip@km;server=PRODIP;" +
"Trusted_Connection=yes;" +
"database=Member;");
cnn.Open();
SqlCommand cmd = new SqlCommand("SELECT * FROM [Membermaster] where actuledate between '" + tbfromdate.Text.Trim() + "' and '" + tbtodate.Text.Trim() + "' ", cnn);
SqlDataReader dr = cmd.ExecuteReader();
dataAdapter.Fill(dataSet);
dataAdapter.Dispose();

return dataSet;
}





}




}