private void Button_Click_2(object sender, RoutedEventArgs e)
 {
     if (tbx1.Text == "")
     {
         var var_name = new MessageDialog("Please add a question.");
         var_name.Commands.Add(new UICommand("OK"));
         var_name.ShowAsync();
     }
     else
     {
         var db = new SQLite.SQLiteConnection(App.DBPath);
         qna q  = new qna();
         q.question = tbx1.Text;
         db.Insert(q);
         var var_name = new MessageDialog("Question added successfully");
         var_name.Commands.Add(new UICommand("OK"));
         var_name.ShowAsync();
         tbx1.Text = "";
     }
 }
        private void Button_Click_1(object sender, RoutedEventArgs e)
        {
            try
            {
                var db = new SQLite.SQLiteConnection(App.DBPath);
                qna qa = new qna();

                int a      = Convert.ToInt32(textbox1.Text);
                var emptab = (db.Table <qna>().Where(em => em.qno == a)).Single();

                if (emptab.ans1 == null)
                {
                    qa.ans1 = textbox3.Text;
                    goto l3;
                }
                else if (emptab.ans2 == null)
                {
                    qa.ans2 = textbox3.Text;
                    goto l3;
                }
                else if (emptab.ans3 == null)
                {
                    qa.ans3 = textbox3.Text;
                    goto l3;
                }
                else if (emptab.ans4 == null)
                {
                    qa.ans4 = textbox3.Text;
                    goto l3;
                }
                else if (emptab.ans5 == null)
                {
                    qa.ans5 = textbox3.Text;
                    goto l3;
                }
                else if (emptab.ans6 == null)
                {
                    qa.ans6 = textbox3.Text;
                    goto l3;
                }
                else if (emptab.ans7 == null)
                {
                    qa.ans7 = textbox3.Text;
                    goto l3;
                }
                else if (emptab.ans8 == null)
                {
                    qa.ans8 = textbox3.Text;
                    goto l3;
                }
                else if (emptab.ans9 == null)
                {
                    qa.ans9 = textbox3.Text;
                    goto l3;
                }
                else if (emptab.ans10 == null)
                {
                    qa.ans10 = textbox3.Text;
                    goto l3;
                }
                else
                {
                    var var_name = new MessageDialog("Answer is not sent !! try again");
                    var_name.Commands.Add(new UICommand("OK"));
                    var_name.ShowAsync();
                }

                l3 :   db.Insert(qa);
                var d = new MessageDialog("Your answer is send.Thank you");
                d.Commands.Add(new UICommand("OK"));
                d.ShowAsync();
            }
            catch (Exception ex)
            {
                textbox3.Text = ex.Message;
            }
        }