private void SKlV_SelectedIndexChanged(object sender, EventArgs e) { ListView lv = (ListView)sender; int cnt = lv.SelectedItems.Count; if (cnt >= 1) { ListViewItem item = lv.SelectedItems[0]; Access SKDB = new Access(); DataSet TableDS = new DataSet(); string SQLStr = string.Format(lawyersql, item.SubItems[0].Text); SKDB.AddTableInDataSet(TableDS, "LawyersInfo", SQLStr); //this.Photo. = TableDS.Tables[0].Rows["photourl"].ToString(); ShowPhoto(this.Photo, TableDS.Tables[0].Rows[0]["photourl"].ToString()); this.LawyerCredit.Text = TableDS.Tables[0].Rows[0]["lawcreditno"].ToString(); this.LawyerName.Text = TableDS.Tables[0].Rows[0]["xm"].ToString(); this.SWSName.Text = TableDS.Tables[0].Rows[0]["swsname"].ToString(); this.huiyuanbh.Text = TableDS.Tables[0].Rows[0]["mobile"].ToString(); //int subcnt = item.SubItems.Count; //StringBuilder sb = new StringBuilder(); //for (int i = 0; i < subcnt; i++) //{ // System.Windows.Forms.ListViewItem.ListViewSubItem subitem=item.SubItems[i]; // sb.Append(subitem.Name + "=" + subitem.Text); // sb.Append("|||"); //} //MessageBox.Show(sb.ToString()); } //string text = lv.SelectedItems[0].Text; //this.LawyerCredit.Text = text; }
private void SchBtn_Click(object sender, EventArgs e) { Access SKDB = new Access(); DataSet TableDS = new DataSet(); string SQLStr = string.Format("select SWSName,XM,LawCreditNO,KH,bh,mobile from Lawyers where SWSName like '%{0}%'and XM like '%{1}%' and mobile like '%{2}%'order by SWSName,XM", SWSNameTB.Text.Trim(), XMTB.Text.Trim(), lsbh.Text.Trim()); SKDB.AddTableInDataSet(TableDS, "LawyersInfo", SQLStr); DGLawInfo.SetDataBinding(TableDS, "LawyersInfo"); DGLawInfo.TableStyles.Clear(); DGLawInfo.TableStyles.Add(LawInfoTableStyle); }