示例#1
0
        private void A_FineReader_Load(object sender, EventArgs e)
        {
            SqlConnection conn = SQLbase.getConn();

            try
            {
                if (conn.State == ConnectionState.Open)
                {
                    conn.Close();
                }
                conn.Open();
                string        selectStr = "select * from readers where Rstate > 0";
                SqlCommand    SelectCmd = new SqlCommand(selectStr, conn);
                SqlDataReader datareader = SelectCmd.ExecuteReader();
                string        Rid, Rname, Rgender, Runit, Rtype, Rstate;
                int           rowindex = 0;
                this.datagridview.Rows.Clear();
                while (datareader.Read())
                {
                    Rid     = datareader["RID"].ToString();
                    Rname   = datareader["Rname"].ToString();
                    Rgender = datareader["Rgender"].ToString();
                    Runit   = datareader["Runit"].ToString();
                    Rtype   = datareader["Rtype"].ToString();
                    Rstate  = datareader["Rstate"].ToString();

                    rowindex = this.datagridview.Rows.Add();
                    //trim函数同于去除字符串两头的空格
                    this.datagridview.Rows[rowindex].Cells[0].Value = Rid.Trim();
                    this.datagridview.Rows[rowindex].Cells[1].Value = Rname.Trim();
                    this.datagridview.Rows[rowindex].Cells[2].Value = Rgender.Trim();
                    this.datagridview.Rows[rowindex].Cells[3].Value = Runit.Trim();
                    this.datagridview.Rows[rowindex].Cells[4].Value = Rtype.Trim();
                    this.datagridview.Rows[rowindex].Cells[5].Value = Rstate.Trim();
                }
            }
            catch
            {
                MessageBox.Show("操作错误!");
            }
        }
示例#2
0
        //读者查询
        private void button1_Click(object sender, EventArgs e)
        {
            SqlConnection conn = SQLbase.getConn();

            try
            {
                this.datagridview.Rows.Clear();
                if (conn.State == ConnectionState.Open)
                {
                    conn.Close();
                }
                conn.Open();
                string selectStr = "select * from readers";
                //按读者号查询
                if (comboBox_QueryStyle.SelectedIndex == 0)
                {
                    string id = txt_query.Text.ToString();
                    //建立查询命令
                    selectStr = "select * from readers where RID=" + id;
                }
                //按读者名查询
                else if (comboBox_QueryStyle.SelectedIndex == 1)
                {
                    string name = txt_query.Text.ToString();
                    //建立查询命令
                    selectStr = "select * from readers where Rname= '" + name + "'";
                }
                //按单位查询
                else if (comboBox_QueryStyle.SelectedIndex == 2)
                {
                    string unit = txt_query.Text.ToString();
                    //建立查询命令
                    selectStr = "select * from readers where Runit= '" + unit + "'";
                }
                //按类型查询
                else if (comboBox_QueryStyle.SelectedIndex == 3)
                {
                    string type = txt_query.Text.ToString();
                    //建立查询命令
                    selectStr = "select * from readers where Rtype= '" + type + "'";
                }
                //没有选择下拉框,则查询全部
                SqlCommand    SelectCmd = new SqlCommand(selectStr, conn);
                SqlDataReader datareader = SelectCmd.ExecuteReader();
                string        Rid, Rname, Rgender, Runit, Rtype, Rstate;
                int           rowindex = 0;
                this.datagridview.Rows.Clear();
                while (datareader.Read())
                {
                    Rid     = datareader["RID"].ToString();
                    Rname   = datareader["Rname"].ToString();
                    Rgender = datareader["Rgender"].ToString();
                    Runit   = datareader["Runit"].ToString();
                    Rtype   = datareader["Rtype"].ToString();
                    Rstate  = datareader["Rstate"].ToString();

                    rowindex = this.datagridview.Rows.Add();
                    //trim函数同于去除字符串两头的空格
                    this.datagridview.Rows[rowindex].Cells[0].Value = Rid.Trim();
                    this.datagridview.Rows[rowindex].Cells[1].Value = Rname.Trim();
                    this.datagridview.Rows[rowindex].Cells[2].Value = Rgender.Trim();
                    this.datagridview.Rows[rowindex].Cells[3].Value = Runit.Trim();
                    this.datagridview.Rows[rowindex].Cells[4].Value = Rtype.Trim();
                    this.datagridview.Rows[rowindex].Cells[5].Value = Rstate.Trim();
                }
            }
            catch
            {
                MessageBox.Show("查无此人!");
            }
            SQLbase.close(conn);
        }