public DsMaster.PROFILESDataTable LoadProfiles(int profileid = 0) { var ta = new DsMasterTableAdapters.PROFILESTableAdapter {Connection = {ConnectionString = _constr}}; var ds = new DsMaster.PROFILESDataTable(); if (profileid == 0) ta.Fill(ds); else { ta.FillByProfileId(ds, profileid); } return ds; }
public string DoSave() { string retval; try { var cn = new SqlConnection {ConnectionString = _constr}; cn.Open(); var dt = new DsMaster().PROFILES; bool isnew = false; var ta = new DsMasterTableAdapters.PROFILESTableAdapter {Connection = cn}; ta.Fill(dt); var dr = dt.FindByPROFILEID(ProfilenamesRow.PROFILEID); if (dr != null) { dr.BeginEdit(); dr.EUSERID = Utils.Userid; dr.EDATE = DateTime.Now.Date; } else { dr = (DsMaster.PROFILESRow) dt.NewRow(); isnew = true; dr.PROFILEID = ProfilenamesRow.PROFILEID; dr.CUSERID = Utils.Userid; dr.CDATE = DateTime.Now.Date; } dr.DETAILS = ProfilenamesRow.DETAILS; 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; }