保留字或参数 [英] Reserved words or an arguments

问题描述

大家好，我在表格报告中遇到一个小问题，当我选择数据时，我收到保留字的错误我已多次检查没有保留字请大家帮帮我



我尝试过：

 con_string.ConnectionString = @Provider = Microsoft .ACE.OLEDB.12.0;数据源= | DataDirectory | \Restaurant.accdb; Persist Security Info = False; 
 con_string.Open（）; 
 DataSet dsa = new DataSet（）; 
 DataTable dt1 = new DataTable（）; 
 dsa.Tables.Add（dt1）; 
 OleDbDataAdapter da = new OleDbDataAdapter（）; 
 da = new OleDbDataAdapter（string.Format（SELECT column2，Sum（MediumVal）As [Dine In]，From（SELECT column2 As [column2]，Switch（column3 like'Dinein％'，1，True，0 ）作为[MediumVal]，FROM Total [日期] [＃0}＃和＃{1}＃和[column2] IN（'CHEESY STICK'，'CHICKEN WINGS 6PCS'，'CHICKEN NUGGETS 6PCS'，'CHICKEN NUGGETS） 12PCS'，'面包有奶酪面包4PCS'，'大蒜面包4PCS'，'新鲜沙拉棒（REG）'，'新鲜沙拉棒（小）'，'CHILLI NEST。'，'MAXI NEST ......'，' VEGGI NEST ..'，'BEEF SANDWICH'，'SMOKED VEAL'，'CHICKEN FAJITA SANDWICH'，'BEEF LASAGNE'，'LICKEN LASAGNE'，'VEGETABLE LASAGNE'，'CHICKEN PASTA'，'SPAGHETTI ......'，'小比利时。'，'普通比萨饼'，'大比萨。'，'小额外的顶级'，'常规额外顶级'，'大型额外顶级'，'冰淇淋舀'，'矿泉水'，'矿泉水大' '，'SOFTDRINK 1.5 LTR'，'SOFTDRINK 300 ML'，'PITCHER .....'，'JUICE S MALL'，'JUICE LARGE。'，'DEAL 1 ......'，'DEAL 2 ......'，'DEAL 3 ......'，'DEAL 4 ..... 。'，'交易5 ......'，'DABANG DEAL。'，'交易A ......'，'交易B ......'，'MIDNIGHT DEAL REGULAR'，'MIDNIGHT DEAL LARGE'，'PIZZA BURGER（BBQ）'，'SUPREME DOUBLE CHEESE'））Group by column2，dateTimePicker1.Text，dateTimePicker2.Text），con_string）; 
 da.Fill（dt1）; 
 dataGridView1.DataSource = dt1; 
 con_string.Close（）; 

解决方案

你有2个逗号问题，其中一个是@KornfeldEliyahuPeter提到的

 Sum（MediumVal） As  [Dine  In ]，< span class =code-keyword> From  

这是另一个。

 作为 [MediumVal]， FROM  

< blockquote>似乎这里额外的逗号混淆了语法...

 Sum（MediumVal） As  [ Dine 在] ， 从 

（逗号）在FROM之前）

Hello guys, i am facing a little issue in form report when i select data so am getting an error of reserved word i have checked multiple times there is no reserved words please guys help me

What I have tried:

con_string.ConnectionString = @"Provider = Microsoft.ACE.OLEDB.12.0;Data Source =|DataDirectory|\Restaurant.accdb;Persist Security Info=False";
            con_string.Open();
            DataSet dsa = new DataSet();
            DataTable dt1 = new DataTable();
            dsa.Tables.Add(dt1);
            OleDbDataAdapter da = new OleDbDataAdapter();
            da = new OleDbDataAdapter(string.Format("SELECT column2,Sum(MediumVal) As [Dine In], From ( SELECT column2 As [column2], Switch(column3 like 'Dinein%', 1,True,0) As [MediumVal], FROM Total  Where [Date] between #{0}# AND #{1}# AND [column2] IN('CHEESY STICK','CHICKEN WINGS 6PCS','CHICKEN NUGGETS 6PCS','CHICKEN NUGGETS 12PCS','BREAD WITH CHEESE NEST 4PCS','GARLIC BREAD 4PCS','FRESH SALAD BAR(REG)','FRESH SALAD BAR(SMALL)','CHILLI NEST.','MAXI NEST...','VEGGI NEST..','BEEF SANDWICH','SMOKED VEAL ','CHICKEN FAJITA SANDWICH','BEEF  LASAGNE','CHICKEN LASAGNE','VEGETABLE LASAGNE','CHICKEN  PASTA','SPAGHETTI...','SMALL PIZZA.','REGULAR PIZZA','LARGE PIZZA.','SMALL EXTRA TOPPING','REGULAR EXTRA TOPPING','LARGE EXTRA TOPPING','ICE CREAM  SCOOP','MINERAL WATER SMALL','MINERAL  WATER LARGE','SOFTDRINK 1.5 LTR','SOFTDRINK 300 ML','PITCHER.....','JUICE SMALL  ','JUICE LARGE.','DEAL 1......','DEAL 2......','DEAL 3......','DEAL 4......','DEAL 5......','DABANG DEAL.','DEAL A......','DEAL B......','MIDNIGHT DEAL REGULAR','MIDNIGHT DEAL LARGE','PIZZA BURGER(BBQ)','SUPREME DOUBLE CHEESE') ) Group By column2", dateTimePicker1.Text, dateTimePicker2.Text), con_string);
            da.Fill(dt1);
            dataGridView1.DataSource = dt1;
            con_string.Close();

解决方案

You have 2 comma issues, one mentioned by @KornfeldEliyahuPeter

Sum(MediumVal) As [Dine In], From

Here is the other.

As [MediumVal], FROM

It seems the extra comma here messes the syntax...

Sum(MediumVal) As [Dine In], From

(the comma before FROM)

这篇关于保留字或参数的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！