如何在不打开Oracle的情况下从C#创建数据库 [英] How to create database from c# without opening oracle

问题描述

我想在不打开数据库的情况下从c#asp开发页面向数据库(oracle)插入一些值，例如名字"，父亲姓名"，"contactno"等.我已经创建了所有代码，connection.I已经使用oledbdataadapter.now，在执行此代码时我在逗号中犯了错误

插入到emp值(" .........................


请给我正确的代码

**************

(已删除电子邮件地址以免于自己保存OP).

i want to insert some values like "first name","fathers name","contactno" etc from c# asp development page to database(oracle),without opening the database.I have created all the code,connection.I have used oledbdataadapter.now i am making mistakes in comma while doing this code

"insert into emp values(".........................


pls send me the right code

**************

(removed email address to save OP from himself)

推荐答案

首先，除非您喜欢垃圾邮件，否则请不要在公共场所发布您的电子邮件地址.其次，您似乎在要求插入语句，当您不知道表的模式时，为什么不能自己编写该语句，以及如何编写该语句?您是什么意思，逗号错误"?你有尝试过吗?它以前如何 ?您遇到什么错误?


我注意到您的代码中有一个."仅举例吗?SQL中的字符串用单引号引起来.值".

First of all, don''t post your email address in public unless you like spam. Second, you seem to be asking for an insert statement, why can''t you write that yourself, and how could we write it, when you don''t know the schema of your table ? What do you mean, ''mistakes in comma'' ? Did you try something ? What was it ? What error did you get ?


I notice you have a " in your code. Is that just for example ? Strings in SQL are in single quotes. ''value''.

这篇关于如何在不打开Oracle的情况下从C#创建数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！