Seach button with textbox (C# and Oracle database)

Question

Hi people i need help for codding a search button with textbox that searches anything in my oracle database using c# from my windows form,
iam sorry if iam not very clear because my english is not very good and iam pretty new to visual studio 2010 ultimate

eg: lets say i have this:

what i want is, when i press search, it searches the database or tables involved and returns me a datagrid with all records that contain Raul in it.
Iam using c# and the database is Oracle 11g.

once again if iam not been clear enough or there is something wrong with my question please tell me.

Thank you very much.

Sreejesh SP · Answer

Dear Porche Please Include the name space of Oracle.DataAccess.Client then 1 errorr removed IN suppose you don't get this namespace please add the referrencce Then please take the name space and add Gridview that is And your gridview name is Gridview1 so youe code is Gridview1.datasource=dt; Gridview1.databind(); Thanks Sreejesh

Porche Panamera · Answer

Hi Sreejesh after going through your code i got some clue but i got stock here could you give me a hand? this what i have: private void search_btn_MouseClick(object sender MouseEventArgs e) { string ConString = Data Source=faraidb;User Id=system;Password=****;; OracleConnection con = new OracleConnection(ConString); OracleCommand cmd=new OracleCommand(select * from hr.nao_publicados where nome LIKE+pesquisa_textBox.Text con); OracleDataAdapter oda = new OracleDataAdapter(cmd); nao_publicados dt=new nao_publicados(); if(pesquisa_textBox.Text!= string.Empty) { oda=new OracleDataAdapter(cmd); oda.fill(dt); GridView.datasource=dt; Gridview.databind(); } } } but now i got this errors: Error 2 The name 'GridView' does not exist in the current context C:\Prófitus-Clientes\Proposta\FAA\eProc\eProc\Menu_naveg_f2.cs 84 19 eProc Error 3 The name 'Gridview' does not exist in the current context C:\Prófitus-Clientes\Proposta\FAA\eProc\eProc\Menu_naveg_f2.cs 85 19 eProc Error 1 'Oracle.DataAccess.Client.OracleDataAdapter' does not contain a definition for 'fill' and no extension method 'fill' accepting a first argument of type 'Oracle.DataAccess.Client.OracleDataAdapter' could be found (are you missing a using directive or an assembly reference?) C:\Prófitus-Clientes\Proposta\FAA\eProc\eProc\Menu_naveg_f2.cs 83 23 eProc Thank you a forgive my ignorance.

Sreejesh SP · Answer

Dear rahul Please try below code protected void btnsearch(object senderEventargument args) { OleDbConnection con = new OleDbConnection(ConnectionString); OleDbCommand cmd=new OleDbCommand(); cmd.connection=con; OleDbDataAdapter oledbda; Datatable dt=new datatable(); if(textbox1.text!=string.Empty) { cmd.commandtext=select * from student where sname LIKE+textbox1.text; oledbda=new OleDbDataAdapter(cmd); oledbda.fill(dt); Gridview.datasource=dt; Gridview.databind(); } } Thanks Sreejesh

Satyapriya Nayak · Answer

string ConnectionString = System.Configuration.ConfigurationSettings.AppSettings[dsn]; OleDbConnection con = new OleDbConnection(ConnectionString); OleDbCommand com ; OleDbDataAdapter oledbda ; DataSet ds ; DataTable dt; string str; if (string.IsNullOrEmpty(textBox1.Text)) { errorProvider1.SetError(textBox1 please provide name); } else { try { con.Open(); str = select * from student where sname =' + textBox1.Text + '; com = new OleDbCommand(str con); oledbda = new OleDbDataAdapter(com); ds = new DataSet(); oledbda.Fill(ds student); con.Close(); DataGridView1.DataSource = ds; DataGridView1.DataMember = student; } catch (Exception ex) { MessageBox.Show(ex.Message); } } textBox1.Clear(); DataGridView1.Visible = true;

Porche Panamera · Answer

Thank you Satyapriya i realy apreciate but i want the code in C# because iam using C# for my windows forms.

Satyapriya Nayak · Answer

Private Sub Button1_Click(ByVal sender As System.Object ByVal e As System.EventArgs) Handles Button1.Click If TextBox1.Text =  Then ErrorProvider1.SetError(TextBox1 please provide name) Else Try con.Open() str = select * from student where sname =' & TextBox1.Text & ' com = New OleDbCommand(str con) oledbda = New OleDbDataAdapter(com) ds = New DataSet oledbda.Fill(ds student) con.Close() DataGridView1.DataSource = ds DataGridView1.DataMember = student Catch ex As Exception MsgBox(ex.Message) End Try End If TextBox1.Clear() DataGridView1.Visible = True End Sub