20db.txt

the original code of the book the principle and practice in sql server 2005

    public void bind()
    {
        string str = "select * from 华师陆河同乡";
        sqlconn = new SqlConnection(sqlstr);
        sqlconn.Open();
        SqlDataAdapter myda = new SqlDataAdapter(str, sqlconn);
        DataSet myds = new DataSet();
        myda.Fill(myds);
        GridView1.DataSource = myds;
        GridView1.DataKeyNames = new string[] { "姓名" };
        GridView1.DataBind();
        sqlconn.Close();
    }


string st;
    string str;
    protected void Button1_Click(object sender, EventArgs e)
    {


        if (TextBox1.Text != "")
        {

            st = DropDownList1.SelectedItem.Text;

            str = "select * from 华师陆河同乡 where " + st + " like '%" + TextBox1.Text.Trim() + "%'";

            sqlconn = new SqlConnection(sqlstr);
            sqlconn.Open();
            SqlCommand sqlcom = new SqlCommand(str, sqlconn);
           
            string rowCount = (string)sqlcom.ExecuteScalar();
            

            if (rowCount != null)
            {
                SqlDataAdapter myda = new SqlDataAdapter(str, sqlconn);
                DataSet myds = new DataSet();
                myda.Fill(myds);
                GridView1.DataSource = myds;
                GridView1.DataBind();
                //this.bind();
                sqlconn.Close();
            }
            else
                Response.Write("<script>alert('没有相关记录')</script>");

        }
        else
            this.bind();
    }


sqlconn = new SqlConnection(strCon);
        string sqlstr = "select * from 华师通讯录";
        sqlconn.Open();
        SqlDataAdapter myda = new SqlDataAdapter(sqlstr, sqlconn);
        DataSet myds = new DataSet();
        myda.Fill(myds);
        GridView1.DataSource = myds;
        //GridView1.DataKeyNames = new string[] { "学号" };
        GridView1.DataBind();
        sqlconn.Close();