Ad:

ASP.NET Discussion Thread
Unsolved
Views: 1002

Jun 19th, 2009

Search and Desplay on DataGrid

Expand Post »

Hi all

I have a datagrid filled with data from Oracle database, I have a textbox and a button search and on the textbox a person/user can enter the Title of the book he/she wana search the the results should be displayed in the datagrid

here is the code on btnSearch

ASP.NET Syntax (Toggle Plain Text)
 using (OracleConnection conn = new  OracleConnection(stringConn))
        {
            string sql = "select BookID, ISBN, Title, PublishedDate, Edition, Publisher, DepartmentName from Books where Title like '%Title%'";
            OracleDataAdapter adap = new OracleDataAdapter(sql, conn);
            adap.SelectCommand.Parameters.Add("Title", OracleType.VarChar).Equals(txtSearch.Text);
            adap.SelectCommand.Connection.Open();
            adap.Fill(dt);
        }
        DataGrid1.DataSource = dt;
        DataGrid1.DataMember = "Books";
        DataGrid1.DataBind();
    }
 using (OracleConnection conn = new  OracleConnection(stringConn))
        {
            string sql = "select BookID, ISBN, Title, PublishedDate, Edition, Publisher, DepartmentName from Books where Title like '%Title%'";
            OracleDataAdapter adap = new OracleDataAdapter(sql, conn);
            adap.SelectCommand.Parameters.Add("Title", OracleType.VarChar).Equals(txtSearch.Text);
            adap.SelectCommand.Connection.Open();
            adap.Fill(dt);
        }
        DataGrid1.DataSource = dt;
        DataGrid1.DataMember = "Books";
        DataGrid1.DataBind();
    }

but now when I click btnSearch the datagrid which is filled with all the data from the book table just got cleared, instead of desplaying all the books with the title entered in the textbox, please tell me what Im doing wrong

Thanks in advance

Similar Threads

connect datagrid to access db using ado code in vb6 in Visual Basic 4 / 5 / 6
how to use data grid in vb.net using odbc connection in VB.NET
Search in Datagrid... in VB.NET
To Search a record in datagridview in VB.NET
Data grid urgent help....very urgent in VB.NET

Traicey

Reputation Points: 26

Solved Threads: 19

Posting Whiz in Training

Offline

283 posts
since Mar 2008

Permalink

Jun 19th, 2009

Re: Search and Desplay on DataGrid

Some confusion:

1. Do now show the data when user leave textbox empty and click
on button.
For this case, do not execute you code - use if statement to
check the value of textbox.
2. Show a record for the book title entered into textbox.
Do not use like '..%' query. Use where columnname='somethig..'

Last edited by adatapost; Jun 19th, 2009 at 8:33 am. Reason: Spell mistake

adatapost

Moderator

Reputation Points: 2136

Solved Threads: 1228

Posting Genius

Offline

6,527 posts
since Oct 2008

Permalink

Jun 19th, 2009

Re: Search and Desplay on DataGrid

String sql = "Select * From Book Where Title = " + txtSearch.Text
I dont know why I didnt think about that, I guess it is true that inexperience programmers like complicating things

Thanks dude, hope Oracle is gonna love it coz if he does it will goodbye to this line
adap.SelectCommand.Parameters.Add("Title", OracleType.VarChar).Equals(txtSearch.Text);

Last edited by peter_budo; Jun 19th, 2009 at 12:47 pm. Reason: Keep It Organized - For easy readability, always wrap programming code within posts in [code] (code blocks) and [icode] (inline code) tags.

Traicey

Reputation Points: 26

Solved Threads: 19

Posting Whiz in Training

Offline

283 posts
since Mar 2008

Permalink

Jun 19th, 2009

Re: Search and Desplay on DataGrid

Here is code for your reference.

ASP.NET Syntax (Toggle Plain Text)
           string cnstr = "data source=abc;user id=hr;password=hr";
 
           // append pattern mach character
            textBox1.Text = textBox1.Text + "%";  
           // Use & - prefix with parametername
            string sql = "select * from employees where first_name like 
                                 &test";
           // No need to set reference of connecton object.
            OracleDataAdapter adp = new OracleDataAdapter(sql, 
                                          cnstr);
            adp.SelectCommand.Parameters.Add("&test", 
                                                               OracleType.VarChar );
            adp.SelectCommand.Parameters[0].Value = textBox1.Text;
 
            DataTable dt = new DataTable();
            // Fill method automatically opens & close the connection
            adp.Fill(dt);
            DataGrid1.DataSource = dt;    
            DataGrid1.DataBind();
           string cnstr = "data source=abc;user id=hr;password=hr";

           // append pattern mach character
            textBox1.Text = textBox1.Text + "%";  
           // Use & - prefix with parametername
            string sql = "select * from employees where first_name like 
                                 &test";
           // No need to set reference of connecton object.
            OracleDataAdapter adp = new OracleDataAdapter(sql, 
                                          cnstr);
            adp.SelectCommand.Parameters.Add("&test", 
                                                               OracleType.VarChar );
            adp.SelectCommand.Parameters[0].Value = textBox1.Text;

            DataTable dt = new DataTable();
            // Fill method automatically opens & close the connection
            adp.Fill(dt);
            DataGrid1.DataSource = dt;    
            DataGrid1.DataBind();

adatapost

Moderator

Reputation Points: 2136

Solved Threads: 1228

Posting Genius

Offline

6,527 posts
since Oct 2008

Permalink

Sep 23rd, 2009

Re: Search and Desplay on textbox or label

i have a problem on searching data from table and displaying it into the textbox or label...pls help me on this problem tnx..

obicerno

Reputation Points: 10

Solved Threads: 1

Newbie Poster

Offline

7 posts
since Sep 2009

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in ASP.NET Forum Timeline: What's N-Tier .. !! Need Tutorials

Next Thread in ASP.NET Forum Timeline: Interface Dynamism

DaniWeb Message

Cancel Changes

User Name
Password