oracle & c# - How can I implement this kindly help me to do..

Question

How can I implement this kindly help me to complete.

Table1: empid (primary key), empdoj, empamt, empadd

Table2: emploanid(primary key), empph, empdob

Table3: empsal,emploan,empint

I have to use empdoj, empamt, emploanid in table3 and I have to search, update the details by using emploanid

Frond end : c#

Database : oracle

Thanks in advance.

Suthish Nair · Answer

check my reply to your other thread

LOGANATHAN V · Answer

my c# coding is try { //Search Employee Details Oracle.DataAccess.Client.OracleConnection cn = new Oracle.DataAccess.Client.OracleConnection(); cn.ConnectionString = user id=system; password=system;; Oracle.DataAccess.Client.OracleCommand cmd = new Oracle.DataAccess.Client.OracleCommand(); cmd.Connection = cn; //cn = new Oracle.DataAccess.Client.OracleConnection(); cmd.CommandText =  select deposit.loanid form1.empedoj form1.empshare sharecapital.shareint sharecapital.loandt sharecapital.loandeduc sharecapital.dividend sharecapital.sharetot from form1 deposit  sharecapital where deposit.loanid(+) = sharecapital.loanid = ' + txtlnid.Text.Trim() + '; // whether this query is right for to search the employee details( shows sql command not properly ended) Oracle.DataAccess.Client.OracleDataAdapter ada = new Oracle.DataAccess.Client.OracleDataAdapter(cmd); System.Data.DataTable dt = new DataTable(); dt.Clear(); ada.Fill(dt); //Display in Textbox if (dt.Rows.Count > 0) { txtlnid.Text = dt.Rows[0].ItemArray[0].ToString(); admdate.Text = dt.Rows[0].ItemArray[1].ToString(); txtadmamt.Text = dt.Rows[0].ItemArray[2].ToString(); txtadmint.Text = dt.Rows[0].ItemArray[3].ToString(); loandt.Text = dt.Rows[0].ItemArray[4].ToString(); txtlnamt.Text = dt.Rows[0].ItemArray[5].ToString(); txtlnint.Text = dt.Rows[0].ItemArray[6].ToString(); txtsctot.Text = dt.Rows[0].ItemArray[7].ToString(); } if (cn.State == ConnectionState.Closed) { cn.Open(); } string str; str = cmd.ExecuteScalar().ToString(); if (str != null) { MessageBox.Show(Record Found); } else { MessageBox.Show(ID not Match); } } catch (Exception ex) { MessageBox.Show(ex.Message); }

Mahesh Chand · Answer

Go to ADO.NET section of this website and look for Oracle articles. There are many. Also there are many listed in the right side bar. Here are the steps. 1. You need to create a Windows Forms application 2. You need to use Oracle database provider or ODBC data provider to connect to Oracle database Read some articles how it is done as I mentioned above. Cheers!