请问 在C#中 可以直接用 insert into table (column1,cloumn2,....) values (values1,values2,....)插入ORACLE 数据库吗``` update 同样可以吗??
没办法``以前没用过`没接触过`没学过``现在是事急马行田,临时抱佛脚啦``各位高手知道的说下
没办法``以前没用过`没接触过`没学过``现在是事急马行田,临时抱佛脚啦``各位高手知道的说下
但你要说清楚地问题,
你这个问得很模糊!
操作数据跟连接SQL SERVER是一样的。
sql = "INSERT INTO ticket(ticketnum,ticketnumext,subject,comments,datetime,domain,site,sector,channel,creatorteam,destinationteam,language,"
+"creator,skill,treatingagent,status,type,customer,dossiernum,callednum) VALUES (ticket_uid.nextval, '" +
ticNumExtBox.Text + "','" +
subjectBox.Text + "','" +
commentBox.Text + "','"+
dateTimePicker1.Value + "','" +
domainBox.Text + "','" +
siteBox.Text + "','" +
sectorBox.Text + "','" +
channelCom.Text + "','" +
cTBox.Text + "','" +
desTBox.Text + "','" +
LangCom.Text + "','" +
creatorBox.Text + "','" +
skillBox.Text + "','" +
treAgentBox.Text + "','" +
staCom.Text + "','" +
typeCom.Text + "','" +
custBox.Text + "','" +
dosNumBox.Text + "','" +
calledBox.Text + "')"; cmd = new OracleCommand(sql, conn);
MessageBox.Show(cmd.CommandText);
//cmd = conn.CreateCommand();
//////---------------------
//cmd.CommandText = sql;
//tran.Commit();
cmd.ExecuteNonQuery();
我用的得是 System.Data.OracleClient;