至少一个参数没有被指定值

[zjc363349388]

public class DataAccess
{
static OleDbConnection conn = new OleDbConnection(@"Provider=Microsoft.Jet.Oledb.4.0;Data Source=" + System.Web.HttpContext.Current.Server.MapPath(@"~/App_Data/B2C.mdb"));

public static DataSet getOleServerData(string sqlstring)
{
OleDbDataAdapter adapter = null;
DataSet ds = new DataSet();
try
{
conn.Open();
adapter = new OleDbDataAdapter();
adapter.SelectCommand = new OleDbCommand(sqlstring, conn);
adapter.Fill(ds);
}
finally
{
conn.Close();
}
return ds;
}
}

protected void btLogon1_Click(object sender, EventArgs e)
{
DataSet ds = DataAccess.getOleServerData(@"SELECT C-Password, C-Name FROM CUSTOMER WHERE C-Email LIKE '" + TextBox2.Text + "'");
GridView1.DataSource = ds.Tables[0];
GridView1.DataBind();
}
运行后出错：至少一个参数没有被指定值。是怎么回事？

[qiangsigm]

你SQL语句写了没哦 sqlstring

[INTTNY]

说的是你的SQL语句出错呢，你那个数据列的名称有问题，改为下划线吧

[dreamsnake]

不一定是SQL语句的问题。看看拼出来的连接字符串对不对

[Hamsic]

DataSet ds = DataAccess.getOleServerData(@"SELECT C-Password, C-Name FROM CUSTOMER WHERE C-Email LIKE '" + TextBox2.Text + "'");

红色部分去掉

[houyizhinv]

[Quote=引用 5 楼 tchjl2007 的回复:]
DataSet ds = DataAccess.getOleServerData(@"SELECT C-Password, C-Name FROM CUSTOMER WHERE C-Email LIKE '" + TextBox2.Text + "'");

红色部分去掉

[/Quote]
红色部分没问题的吧

[woshifou]

调试一下，看在那里除了问题。

[波导终结者]

C-Password等用方括号括起来，[C-Password]，字段名最好不要有减号，换成下划线