command.ExecuteReader();

when i use this code in my project in vs 2012 and my Database is Access it display an error in this line " OleDbDataReader reader = command.ExecuteReader();"

The error is : " The SELECT statement includes a reserved word or an argument name that is misspelled or missing, or the punctuation is incorrect."

what should i do for solving this error ?

Thanks for any help

Davood

------------------------------

This is my code :

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Data.OleDb;

using System.Configuration;

public partial class _Default : System.Web.UI.Page

{

protected void Page_Load(object sender, EventArgs e)

{

}

protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)

{

string connectionString, queryString;

connectionString = ConfigurationManager.ConnectionStrings["ostanConnectionString"].ToString();

queryString = "SELECT FROM situation where state ='" + DropDownList1.SelectedValue + "'";

using (OleDbConnection connection = new OleDbConnection(connectionString))

{

OleDbCommand command = new OleDbCommand(queryString, connection);

connection.Open();

OleDbDataReader reader = command.ExecuteReader();

DropDownList2.Items.Clear();

while (reader.Read())

DropDownList2.Items.Add(reader["city"].ToString());

reader.Close();

connection.Close();

}

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Abhay Shanker12y ago
Accepted answer
Hi,

Check below incorrect line
queryString = "SELECT missing FROM situation where state ='" + DropDownList1.SelectedValue + "'";

here you are missing * or field name
Davood Riazi12y ago
Hi , Thanks for your help. it works , but in DropDownList2 it dosen't show anything . why ? in DropDownlist1.SelectedValue it shows province name .but i want whenever i click on DropDownlist1 it shows me the name of province's city in DropDownlist2 .