troubleshooting Question

ExecuteReader: CommandText property has not been initialized

Avatar of SirReadAlot
SirReadAlot asked on
C#
11 Comments1 Solution970 ViewsLast Modified:
hi experts,

how can i resolve this error.
    string connStr = ConfigurationManager.ConnectionStrings["TutTestConn"].ToString();
    SqlConnection dbconn = null;
    protected void Page_Load(object sender, EventArgs e)
    {
        // The currently selected year --code not need yet
        string selectedYear = yearSelect.SelectedItem.Value;

        // SQL statement to get the monthly revenues for the selected year.
        SqlCommand command = new SqlCommand("GetData", dbconn);
        dbconn = new SqlConnection(connStr);
        dbconn.Open();

        // Set up the SQL statement
        System.Data.IDbCommand sqlCmd = dbconn.CreateCommand();
        sqlCmd.CommandType = CommandType.StoredProcedure;

        // Read the data into the DBTable object
        DBTable table = new DBTable(sqlCmd.ExecuteReader());=========================ExecuteReader: CommandText property has not been initialized
        dbconn.Close();
       
        thanks
ASKER CERTIFIED SOLUTION
Éric Moreau
Senior .Net Consultant
Join our community to see this answer!
Unlock 1 Answer and 11 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 11 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros