protected void Page_Load(object sender, EventArgs e)
 {
     try
     {
         string username = (string)(Session["username"]);
         ProjectDatasetTableAdapters.user_banksTableAdapter ds = new ProjectDatasetTableAdapters.user_banksTableAdapter();
         ProjectDataset.user_banksDataTable dt = new ProjectDataset.user_banksDataTable();
         dt = ds.GetDataid(username);
         if (dt.Rows.Count > 0)
         {
             banksview.Visible    = true;
             lblmsg.Visible       = false;
             banksview.DataSource = dt;
             banksview.DataBind();
         }
         else
         {
             banksview.Visible = false;
             lblmsg.Visible    = true;
             lblmsg.Text       = "Sorry, You have not added any bank account yet!";
         }
     } catch (Exception ex)
     {
         lblmsg.Visible = true;
         lblmsg.Text    = ex.ToString();
     }
 }
 protected void btnsend_Click(object sender, EventArgs e)
 {
     try
     {
         string username  = (string)(Session["username"]);
         String bankname  = txtbankname.Text.ToString();
         String accountno = txtbankaccount.Text.ToString();
         if (bankname == "")
         {
             lblmsg.Visible           = true;
             lblmsg.Text              = "Bank Name Must not be empty.";
             mtop.Style["margin-top"] = "40px";
         }
         else if (accountno == "")
         {
             lblmsg.Visible           = true;
             lblmsg.Text              = "Account Number Must not be empty";
             mtop.Style["margin-top"] = "40px";
         }
         else
         {
             ProjectDatasetTableAdapters.usersTableAdapter ta = new ProjectDatasetTableAdapters.usersTableAdapter();
             ProjectDataset.usersDataTable td = new ProjectDataset.usersDataTable();
             td = ta.GetDataByusername(username);
             String uid = td.Rows[0]["user_id"].ToString();
             lblmsg.Visible             = true;
             lblmsg.Text                = "Bank Added Successfully!";
             lblmsg.Style["background"] = "#4CAF50!important";
             mtop.Style["margin-top"]   = "40px";
             ProjectDatasetTableAdapters.user_banksTableAdapter bds = new ProjectDatasetTableAdapters.user_banksTableAdapter();
             bds.Insert(Convert.ToInt32(uid), bankname, accountno);
         }
     }
     catch (Exception ex)
     {
         lblmsg.Visible           = true;
         lblmsg.Text              = ex.ToString();
         mtop.Style["margin-top"] = "40px";
     }
 }