public DsMaster.PROFILENAMEMASTDataTable LoadProfileNames() { var ta = new DsMasterTableAdapters.PROFILENAMEMASTTableAdapter {Connection = {ConnectionString = _constr}}; var ds = new DsMaster.PROFILENAMEMASTDataTable(); ta.Fill(ds); return ds; }
public string DoSave(string pname) { string retval; try { var cn = new SqlConnection {ConnectionString = _constr}; cn.Open(); var dt = new DsMaster().PROFILENAMEMAST; bool isnew = false; var ta = new DsMasterTableAdapters.PROFILENAMEMASTTableAdapter {Connection = cn}; ta.Fill(dt); var dr = dt.FindByPROFILENAME(pname); if (dr != null) { dr.BeginEdit(); } else { dr = (DsMaster.PROFILENAMEMASTRow) dt.NewRow(); isnew = true; } dr.PROFILENAME = 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; }