select语句在C# [英] select statement in C#
本文介绍了select语句在C#的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我的代码中的问题在哪里?
Where's the problem in my code ?
string constr = "Provider=Microsoft.Jet.OLEDB.4.0;"
+ "Data Source=C:\\Users\\Simon\\Desktop\\test5\\test5\\test5\\save.mdb";
OleDbConnection conn = new OleDbConnection(constr);
string sql = "SELECT users.user_name,naziv,obroki_save.datum"
+ "FROM zivila JOIN obroki_save ON zivila.ID=obroki_save.ID_zivila"
+ "JOIN users ON obroki_save.ID_uporabnika=users.ID";
OleDbCommand cmd = new OleDbCommand(sql, conn);
conn.Open();
OleDbDataReader reader;
reader = cmd.ExecuteReader();
while (reader.Read())
{
Console.Write(reader.GetString(0).ToString() + " ,");
Console.Write(reader.GetString(1).ToString() + " ,");
Console.WriteLine("");
}
reader.Close();
conn.Close();
推荐答案
如果你在调试器中运行它,问题:
If you run it in the debugger you can see the problem:
SELECT users.user_name, naziv,obroki_save.datumFROM zivila JOIN obroki_save ...
^^^^
您的SQL中缺少空格。应该是这样:
You're missing spaces in your SQL. It should be this:
string sql = "SELECT users.user_name,naziv,obroki_save.datum " // << here
+ "FROM zivila JOIN obroki_save ON zivila.ID=obroki_save.ID_zivila " // << here
+ "JOIN users ON obroki_save.ID_uporabnika=users.ID";
这篇关于select语句在C#的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文