甲骨文c#-如何实现这一点，请帮助我完成. [英] oracle & c# -How can I implement this kindly help me to complete.

问题描述

表1:Empid(主键)，empdoj，empamt，empadd

表2:Employanid(主键)，empph，empdob

表3:empsal，emploan，empint

我必须在表3中使用empdoj，empamt，emploanid，并且必须使用emploanid搜索，更新详细信息

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

MY WORKS IN DATABASE:
create table employee_detail (empcid varchar2(25) primary key, empdoj date, empamt varchar2(10),ampadd varchar2(10));

create table employee_deposit(loanid varchar(25) primary key, empph number(10), empdob date));

create table employee_sharecapital(loanid varchar2(25),empedoj date,empamt varchar2(10),empsal varchar2(10),emploan number(10));

i have to display & update in c# by using loan id in sharecapital table

前端:c#
数据库:oracle

在此先谢谢您.

Frond end : c#
Database : oracle

Thanks in advance.

推荐答案

很难弄清您要的内容:您的表似乎都不与其他表相关，因此table2甚至在哪里很难说.

将您的表重命名为明智的名称-"EmployerDetail"或类似的方法会很好-并向我们展示表之间的关系.

然后问一个与您要达到的目标有关的问题.

编辑您的问题以包含信息.

It is difficult to work out what you are asking for: none of your tables appear to be related to the others, so quite where table2 even comes into it is difficult to tell.

Rename your tables to something sensible - "EmployerDetail" or similar would be good - and try to show us the relations between the tables.

Then ask a question which refers to what you are trying to achieve.

Edit your question to include the information.

这篇关于甲骨文c#-如何实现这一点，请帮助我完成.的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！