Click here to Skip to main content
15,887,083 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
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();
Posted
Updated 2-Jul-17 13:39pm
Comments
Kornfeld Eliyahu Peter 2-Jul-17 16:24pm    
Check the actual SQL, including the replacements...

You have 2 comma issues, one mentioned by @KornfeldEliyahuPeter
SQL
Sum(MediumVal) As [Dine In], From

Here is the other.
SQL
As [MediumVal], FROM
 
Share this answer
 
It seems the extra comma here messes the syntax...
SQL
Sum(MediumVal) As [Dine In], From
(the comma before FROM)
 
Share this answer
 
Comments
Member 9983063 2-Jul-17 16:27pm    
i have used your code but still i am getting that error

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900