ORACEL中数据一对多的关系 本来就应该是4个字段多条记录啊?楼主是什么意思? 插入就是insert语句啊 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 你还没理解我的意思,insert into(a,b,c,d)values(a,b,c,d),这是一个部门插入的时候,那要是同时有2个或两个以上部门的数据要插入呢?是一次性的插入数据库,不是分开的插入啊 那就类似这样insert into aselect'50000','5'from dualunion allselect '60000','6'from dualunion allselect '70000','7'from dual; string cid = Page.Request.QueryString["id"]; string sql = "select * from network_checkin a,network_department b where ID='" + cid + "' and a. enforcementdepartments=b.deptid"; C_DataCommon dc = new C_DataCommon(); var myds = dc.ExecuteDataSet(sql); DataRowView mydrv = myds.Tables[0].DefaultView[0]; txtid.Text = Convert.ToString(mydrv.Row["ID"]); faqiren.Text = Convert.ToString(mydrv.Row["creatcard"]); title.Text = Convert.ToString(mydrv.Row["TITLE"]); // dept.Text= Convert.ToString(mydrv.Row["name"]); dept.SelectedValue = Convert.ToString(mydrv.Row["enforcementdepartments"]); type.Text = Convert.ToString(mydrv.Row["TYPE"]); contact.Text = Convert.ToString(mydrv.Row["CONTACT"]); telphone.Text = Convert.ToString(mydrv.Row["TELEPHONE"]); extensionnumber.Text = Convert.ToString(mydrv.Row["EXTENSIONNUM"]); txtStartTime.Text = Convert.ToString(mydrv.Row["STARTTIME"]); txtEndTime.Text = Convert.ToString(mydrv.Row["ENDTIME"]); txtactualtime.Text = Convert.ToString(mydrv.Row["actualtime"]); accord.Text = Convert.ToString(mydrv.Row["ACCORD"]); description.Text = Convert.ToString(mydrv.Row["DESCRIPTION"]); content.Text = Convert.ToString(mydrv.Row["CONTENT"]); range.Text = Convert.ToString(mydrv.Row["RANGE"]); code.Text = Convert.ToString(mydrv.Row["CODE"]); usernum.Text = Convert.ToString(mydrv.Row["USERNUM"]); zhimu.SelectedValue = Convert.ToString(mydrv.Row["SUBTITLES"]); //zhimu.Text = Convert.ToString(mydrv.Row["SUBTITLES"]); baozi.SelectedValue = Convert.ToString(mydrv.Row["BULLETIN"]); IVR.SelectedValue = Convert.ToString(mydrv.Row["IVR"]); notes.Text = Convert.ToString(mydrv.Row["NOTES"]); //lblstate.Text = Convert.ToString(mydrv.Row["STATE"]); lblstate.Text = mydrv.Row["STATE"].ToString(); Session["STATE"] = lblstate.Text; tbopinion.Text = mydrv.Row["adjustopinion"].ToString(); ccunit.Text = mydrv.Row["ccunit"].ToString();我是这样在后台一个一个字段分别读出来的,然后把他们显示在各个服务器控件里面,所以这里我有些困惑了,多条记录,字段都一样,咋分别读出来显示在各个框中啊 关于数据集拼凑组合的思路 ORACLE 2表根据相同的字段 以时间组合成一张表 这样的SQL应该怎么写? 请问如何在sqlplus中查看oracle错误码的命令 toad to oracle里的function oracle数据库和oracle Developer的问题,急! ORACLE批量修改語句問題 请教各位一句SQL语句 为什么 OracleService* 服务不能启动? 求解,如何實現該功能 ORACLE 并非所有变量都已绑定 oracle的with语句问题
select
'50000','5'
from dual
union all
select '60000','6'
from dual
union all
select '70000','7'
from dual;
string sql = "select * from network_checkin a,network_department b where ID='" + cid + "' and a. enforcementdepartments=b.deptid";
C_DataCommon dc = new C_DataCommon();
var myds = dc.ExecuteDataSet(sql);
DataRowView mydrv = myds.Tables[0].DefaultView[0];
txtid.Text = Convert.ToString(mydrv.Row["ID"]);
faqiren.Text = Convert.ToString(mydrv.Row["creatcard"]);
title.Text = Convert.ToString(mydrv.Row["TITLE"]);
// dept.Text= Convert.ToString(mydrv.Row["name"]);
dept.SelectedValue = Convert.ToString(mydrv.Row["enforcementdepartments"]);
type.Text = Convert.ToString(mydrv.Row["TYPE"]);
contact.Text = Convert.ToString(mydrv.Row["CONTACT"]);
telphone.Text = Convert.ToString(mydrv.Row["TELEPHONE"]);
extensionnumber.Text = Convert.ToString(mydrv.Row["EXTENSIONNUM"]);
txtStartTime.Text = Convert.ToString(mydrv.Row["STARTTIME"]);
txtEndTime.Text = Convert.ToString(mydrv.Row["ENDTIME"]);
txtactualtime.Text = Convert.ToString(mydrv.Row["actualtime"]);
accord.Text = Convert.ToString(mydrv.Row["ACCORD"]);
description.Text = Convert.ToString(mydrv.Row["DESCRIPTION"]);
content.Text = Convert.ToString(mydrv.Row["CONTENT"]);
range.Text = Convert.ToString(mydrv.Row["RANGE"]);
code.Text = Convert.ToString(mydrv.Row["CODE"]);
usernum.Text = Convert.ToString(mydrv.Row["USERNUM"]);
zhimu.SelectedValue = Convert.ToString(mydrv.Row["SUBTITLES"]);
//zhimu.Text = Convert.ToString(mydrv.Row["SUBTITLES"]);
baozi.SelectedValue = Convert.ToString(mydrv.Row["BULLETIN"]);
IVR.SelectedValue = Convert.ToString(mydrv.Row["IVR"]);
notes.Text = Convert.ToString(mydrv.Row["NOTES"]);
//lblstate.Text = Convert.ToString(mydrv.Row["STATE"]);
lblstate.Text = mydrv.Row["STATE"].ToString();
Session["STATE"] = lblstate.Text;
tbopinion.Text = mydrv.Row["adjustopinion"].ToString();
ccunit.Text = mydrv.Row["ccunit"].ToString();我是这样在后台一个一个字段分别读出来的,然后把他们显示在各个服务器控件里面,所以这里我有些困惑了,多条记录,字段都一样,咋分别读出来显示在各个框中啊