C# (CSharp) library_management searching.search Examples

Example #1

File: LibrarianProfile.aspx.cs Project: brutFox/Library-Management

        public void databinding(string key)
        {
            searching s = new searching();
            SqlDataAdapter adapter = s.search(key);
            SqlCommandBuilder builder = new SqlCommandBuilder(adapter);

            DataSet ds = new DataSet();
            adapter.Fill(ds, "Books");
            ds.Tables["Books"].PrimaryKey = new DataColumn[] { ds.Tables["Books"].Columns["BID"] };
            result_grid.DataSource = ds.Tables["Books"];
            result_grid.DataBind(); 
        }

Example #2

File: LibrarianProfile.aspx.cs Project: brutFox/Library-Management

        public void databinding(string key)
        {
            searching         s       = new searching();
            SqlDataAdapter    adapter = s.search(key);
            SqlCommandBuilder builder = new SqlCommandBuilder(adapter);

            DataSet ds = new DataSet();

            adapter.Fill(ds, "Books");
            ds.Tables["Books"].PrimaryKey = new DataColumn[] { ds.Tables["Books"].Columns["BID"] };
            result_grid.DataSource        = ds.Tables["Books"];
            result_grid.DataBind();
        }

Example #3

File: HomePage.aspx.cs Project: brutFox/Library-Management

        protected void Search_btn_Click(object sender, EventArgs e)
        {
            string key = this.search_box.Text.ToString();
            searching s = new searching();
            SqlDataAdapter adapter = s.search(key);
            SqlCommandBuilder builder = new SqlCommandBuilder(adapter);

            
            
            DataSet ds = new DataSet();
            //adapter.Fill(ds, "Books");
            adapter.Fill(ds, "Books");
            ds.Tables["Books"].PrimaryKey = new DataColumn[] { ds.Tables["Books"].Columns["BID"] };
            result_grid.DataSource = ds.Tables["Books"];
            result_grid.DataBind();
        }

Example #4

        protected void Search_btn_Click(object sender, EventArgs e)
        {
            string            key     = this.search_box.Text.ToString();
            searching         s       = new searching();
            SqlDataAdapter    adapter = s.search(key);
            SqlCommandBuilder builder = new SqlCommandBuilder(adapter);



            DataSet ds = new DataSet();

            //adapter.Fill(ds, "Books");
            adapter.Fill(ds, "Books");
            ds.Tables["Books"].PrimaryKey = new DataColumn[] { ds.Tables["Books"].Columns["BID"] };
            result_grid.DataSource        = ds.Tables["Books"];
            result_grid.DataBind();
        }