Question

winform操作excel的问题。。高手帮帮我！非常感谢！ 代码如下。。有什么错误？

OleDbConnection conn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\Documents and Settings\\Administrator\\桌面\\复件 quality\\quality\\quality.xls;Extended Properties=\"Excel 8.0;HDR=Yes;IMEX=1\"");
public Userinfo Login(Userinfo user)
{
string sql = string.Format("select * from [Sheet1$] where uname='{0}' and upwd='{1}'", user.Uname, user.Upwd);

try
{
conn.Open();
OleDbCommand cmd = new OleDbCommand(sql, conn);
OleDbDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
user.Uid = dr["uid"].ToString();
user.Uname = dr["uname"].ToString();
user.Upwd = dr["upwd"].ToString();
user.Urole = (int)dr["urole"];
}
return user;
}
catch (Exception)
{

throw;
}
finally
{
conn.Close();
}

Answer 1

//你要确保你通过 Login(Userinfo user)传递过滤的参数不能为空哦！，其它的错误，你把系统报的错贴出来看看吧!
user.Uid = dr["uid"].ToString();
user.Uname = dr["uname"].ToString();
user.Upwd = dr["upwd"].ToString();
user.Urole = (int)dr["urole"];