void getMember_Callback(SQLDataRequest sdr, DataTable dt) { if (this.InvokeRequired) { var m = new RequestCallbackHandler(getMember_Callback); this.Invoke(m, new object[2] { sdr, dt }); return; } if (dt.Rows.Count == 1) { var row = (DataRow)dt.Rows[0]; txtFirstName.Text = (string)row["FirstName"]; txtLastName.Text = (string)row["LastName"]; txtPhone.Text = (string)row["Phone"]; txtTotalPoints.Text = row["TotalPoints"] is DBNull ? "0" : (string)row["TotalPoints"]; recentTrans.Items.Clear(); row = null; //var mem = new Member((DataRow)dt.Rows[0]); } }
void getTag_Callback(SQLDataRequest sdr, DataTable dt) { if (this.InvokeRequired) { var m = new RequestCallbackHandler(getTag_Callback); this.Invoke(m, new object[2] { sdr, dt }); return; } if (dt.Rows.Count == 1) { var row = (DataRow)dt.Rows[0]; } }
void getMember_Callback(SQLDataRequest sdr, DataTable dt) { if (this.InvokeRequired) { //var m = new RequestCallbackHandler(getMember_Callback); //this.Invoke(m, new object[2] { sdr, dt }); //return; this.BeginInvoke(new MethodInvoker(() => getMember_Callback(sdr, dt))); return; } lstSearchResults.Items.Clear(); Member mem = null; foreach (DataRow row in dt.Rows) { mem = new Member(row); lstSearchResults.Items.Add(new ListViewItem(new string[] { mem.FirstName + " " + mem.LastName, mem.PhoneNum, mem.TotalPoints.ToString() }, 0)); } mem = null; }