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();