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

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.

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);

}

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Suthish Nair15y ago
check my reply to your other thread
LOGANATHAN V15y ago
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 Chand15y ago
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!