首先需要在数据库中新建一张表把QQID、密保问题、密保答案都写进去
然后在进行一下代码编写:
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Data.SqlClient;//SQL server、SQL语句所需命名空间。
namespace MyQQ
{
public partial class SearchFrm : Form
{
public SearchFrm()
{
InitializeComponent();
}
//窗体加载时的
private void SearchFrm_Load(object sender, EventArgs e)
{
//隐藏数据、按钮、容器控件
this.dgvBase.Visible = false;
this.dgvAdvance.Visible = false;
this.btnAddFriends.Visible = false; ;
this.btnUp.Visible = false;
this.groupAdvance.Visible = false;
//赋值与下拉框并且使下拉框只能选不能填
this.cmbSex.Items.Add("--请选择--");
this.cmbSex.Text = "--请选择--";
this.cmbSex.Items.Add("男");
this.cmbSex.Items.Add("女");
this.cmbSex.DropDownStyle = ComboBoxStyle.DropDownList;
this.cmbAge.Items.Add("--请选择--");
this.cmbAge.Text = "--请选择--";
this.cmbAge.Items.Add("18岁以下");
this.cmbAge.Items.Add("18岁~25岁");
this.cmbAge.Items.Add("25岁~35岁");
this.cmbAge.Items.Add("35岁~45岁");
this.cmbAge.Items.Add("46岁以上");
this.cmbAge.DropDownStyle = ComboBoxStyle.DropDownList;
}
//点击此按钮显示容器控件并且txtNum得到焦点
private void rdoAdvance_Click(object sender, EventArgs e)
{
this.groupAdvance.Visible = true;
this.txtNum.Focus();
}
//点击此按钮隐藏容器并且文本框里面的值清空
private void rdoAll_Click(object sender, EventArgs e)
{
this.txtNum.Text = "";
this.txtNickName.Text = "";
this.groupAdvance.Visible = false;
}
//基本查找的方法及情况
public void BaseSearch()
{
string sql = "";
if(this.rdoAll.Checked == true)
{//查找所有人
sql = "select Id,NickName,Age,Sex from users";
}else if(this.rdoAdvance.Checked == true)
{
if (this.txtNum.Text == "" && this.txtNickName.Text == "")
{
MessageBox.Show("请输入QQ号码或者昵称");
return;
}
if (this.txtNum.Text != "" && this.txtNickName.Text == "")
{//1、有QQ号,无昵称
sql = string.Format("select id,nickname,age,sex from users where id={0}",this.txtNum.Text);
}
else if (this.txtNum.Text == "" && this.txtNickName.Text != "")
{//2、无QQ号,有昵称
sql = string.Format("select id, nickname,age,sex from users where nickname='{0}'",this.txtNickName.Text);
}
else if (