Beispiel #1
0
 public string DoSave(string pname,int bankid=0)
 {
     string retval;
     try
     {
         var cn = new SqlConnection { ConnectionString = _constr };
         cn.Open();
         var dt = new DsMaster().BANKS;
         bool isnew = false;
         var ta = new DsMasterTableAdapters.BANKSTableAdapter() { Connection = cn };
         ta.Fill(dt);
         var dr = dt.FindByBANKID(bankid);
         if (dr != null)
         {
             dr.BeginEdit();
         }
         else
         {
             dr = (DsMaster.BANKSRow)dt.NewRow();
             isnew = true;
         }
         dr.BANKNAME = pname;
         if (isnew)
         {
             dt.Rows.Add(dr);
             ta.Update(dt);
         }
         else
         {
             dr.EndEdit();
             ta.Update(dt);
         }
         retval = "1";
     }
     catch (Exception ex)
     {
         retval = ex.ToString();
     }
     return retval;
 }