from子句中的语法错误。 [英] Syntax error in from clause.

问题描述

Hello Guys，我正面临一个问题，那就是当我从db中选择我的项目时，我得到一个像这样的错误

 FROM子句中的语法错误。 
 

我的尝试：

 con_string.Open（）; 
 DataSet dsa2 = new DataSet（）; 
 DataTable dt2 = new DataTable（）; 
 dsa2.Tables.Add（dt2）; 
 OleDbDataAdapter da2 = new OleDbDataAdapter（）; 
 da2 = new OleDbDataAdapter（string.Format（SELECT column2，Sum（MediumVal）As [Dine In]，Sum（LargeVal）As [Deliery]，Sum（RoyalVal）As [Take Away] From（SELECT column2 As [column2]，Switch（第3列像'DineIn％'，1，True，0）作为[MediumVal]，Switch（第3列像'Delivery％'，1，True，0）作为[LargeVal]，Switch（第3列像'TakeAway ％'，1，True，0）As [RoyalVal] FROM Total其中[Date]之间的[Date]＃AND＃{1}＃AND [column2] ='+ dt1.ToString（）+'Group By column2 ，dateTimePicker1.Text，dateTimePicker2.Text），con_string）; 
 da2.Fill（dt2）; 
 dataGridView1.DataSource = dt2; 
 con_string.Close（）; 
 dataGridView1 .Columns [0] .Width = 286; 
 dataGridView1.Columns [1] .Width = 180; 
 dataGridView1.Columns [2] .Width = 180; 
 dataGridView1.Columns [3] .Width = 180; 

解决方案

缺少结束括号：

  SELECT  column2，...  From （ SELECT  column2 作为 [column2]，...  FROM 总计其中 ... 组 按 column2 

Hello Guys, i am facing an issue that is when i select my items from db so i get an error like this

Syntax error in FROM clause.

What I have tried:

con_string.Open();
            DataSet dsa2 = new DataSet();
            DataTable dt2 = new DataTable();
            dsa2.Tables.Add(dt2);
            OleDbDataAdapter da2 = new OleDbDataAdapter();
            da2 = new OleDbDataAdapter(string.Format("SELECT column2,Sum(MediumVal) As [Dine In], Sum(LargeVal) As [Deliery], Sum(RoyalVal) As [Take Away] From ( SELECT column2 As [column2], Switch(column3 like 'DineIn%', 1,True,0) As [MediumVal], Switch(column3 like 'Delivery%',1,True,0) As [LargeVal], Switch(column3 like 'TakeAway%', 1,True,0) As [RoyalVal] FROM Total  Where [Date] between #{0}# AND #{1}# AND [column2] = '"+dt1.ToString()+"' Group By column2", dateTimePicker1.Text, dateTimePicker2.Text), con_string);
            da2.Fill(dt2);
            dataGridView1.DataSource = dt2;
            con_string.Close();
            dataGridView1.Columns[0].Width = 286;
            dataGridView1.Columns[1].Width = 180;
            dataGridView1.Columns[2].Width = 180;
            dataGridView1.Columns[3].Width = 180;

解决方案

The closing bracket is missing:

SELECT column2, ... From ( SELECT column2 As [column2], ... FROM Total  Where ... Group By column2

这篇关于from子句中的语法错误。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！