如何将DataTable插入数据库？ [英] How do you insert a DataTable into a Database?
问题描述
好吧，我是这个整个.net场景的新手，所以我一直在努力寻找如何将新创建的表添加到数据库（连接）中的示例？
这里''我到目前为止！
//创建表
DataTable table = new DataTable（" MyTable"）;
table.Columns.Add（new DataColumn（" Name"，Type.GetType（" System.String"）））;
table.Columns.Add（new DataColumn（ " Age"，Type.GetType（" System.Byte"）））;
//添加一行数据
DataRow dataRow = table .NewRow（）;
dataRow [" Name"] =" John";
dataRow [" Age"] = 30;
table.Rows.Add（dataRow）;
// ????????????????????????
。
。
（这里是我被困的地方）
如何添加我上面的表到下面的数据库连接？
。
。
// ????????????? ???????????
//创建数据库连接
OleDbConnection dbConn = new OleDbConnection（" Provider = Microsoft.Jet.OLEDB.4.0;数据来源= + DBFULLNAME）;
---------------------------------- --------------------
对不起，我知道他们必须在某个地方做个例子，但一直在寻找几个小时没有运气！
感谢您的帮助。
ok i''m new to this whole .net scene so i have been battling trying to find examples on how to add a newly created table into the database (connection)?
Here''s what i have so far!
//create table
DataTable table = new DataTable("MyTable");
table.Columns.Add(new DataColumn("Name", Type.GetType("System.String")));
table.Columns.Add(new DataColumn("Age", Type.GetType("System.Byte")));
//add a row of data
DataRow dataRow = table.NewRow();
dataRow["Name"] = "John";
dataRow["Age"] = 30;
table.Rows.Add(dataRow);
//?????????????????????????
.
.
(Here''s where i''m stuck)
How do I add my table above to the db connection below?
.
.
//?????????????????????????
//create database connection
OleDbConnection dbConn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" + DBFULLNAME);
------------------------------------------------------
sorry i know their must be an example somewhere but have been searching for hours with no luck at all!
thanks for any help.
推荐答案
如果您问如何获取数据在DataTable中保存的SQL Server的答案是将适配器或命令与DataTable和Update相关联。
如果您问如何将物理表添加到SQL Server数据库中会使用SMO \SQLDMO或直接TSQL，而不是ADO。您也可以使用OleDb连接来定义新表，但它不会包含任何数据。
If you are asking how to get data into SQL Server that is held in a DataTable the answer would be associate an Adapter or Command to DataTable and Update.
If you are asking how to add a physical Table to a SQL Server Database you would use SMO\SQLDMO or straight TSQL, not ADO. You could also use an OleDb connection to define a new table but it would not have any data in it.
如果您问如何要将数据导入DataTable中保存的SQL Server，答案就是将适配器或命令与DataTable和Update相关联。
如果您询问如何将物理表添加到SQL Server数据库您将使用SMO \SQLDMO或直接TSQL，而不是ADO。您还可以使用OleDb连接来定义新表，但它不会包含任何数据。
If you are asking how to get data into SQL Server that is held in a DataTable the answer would be associate an Adapter or Command to DataTable and Update.
If you are asking how to add a physical Table to a SQL Server Database you would use SMO\SQLDMO or straight TSQL, not ADO. You could also use an OleDb connection to define a new table but it would not have any data in it.
如果我上面的例子没有告诉你我被困在哪里，那么我不知所措？
我之后的所有内容都是我的DataSet和DBConnection之间缺少的链接！我已经创建了数据库，我只需要将该死的表插入其中。
我查看了DataAdapter，这将允许我提供DataTable我的数据集m使用contains，但是仍然没有让我更接近插入表格吗？
任何帮助都将不胜感激。
Well if my above example didn''t show you where i''m stuck, then i''m at a loss?
All i''m after is the missing link between my DataSet and DBConnection! I''ve already created the database i just need to insert the damn table into it.
I looked into the DataAdapter which will allow me to supply a DataSet that the DataTable i''m using contains, but that still doesn''t bring me any closer to inserting the table?
any help would be appreciated.
ok看来没有人理解我的问题？我将尝试进一步解释。
1）我在项目文件夹中创建了一个新的空数据库，使用SQLConfigDataSource（win32 api）
2）现在我想在我的第一篇文章中使用上面的例子插入一个新表，该帖子使用DataSet，DataTable，DataColumn和DataColumn。和DataRow
我可以使用以下代码实现这一点:(但我更愿意学习如何使用上面的代码）
---------------------
OleDbConnection dbConn = new OleDbConnection（" Provider = Microsoft.Jet .OLEDB.4.0;数据源= c：\mydb.mdb"）;
dbConn.Open（）;
OleDbCommand cmd = new OleDbCommand（ ）;
cmd.Connection = dbConn;
//创建表
cmd.CommandText =" CREATE TABLE mytable（名称VARCHAR（25），Age INTEGER）" ;;
cmd.ExecuteNonQuery（）;
//添加一行数据
cmd.CommandText =" INSERT INTO mytable VALUES（''John''，30）" ;;
cmd.ExecuteNonQuery（）;
dbConn.Close（）;
---------------------
但是什么如果我不能插入最终的表格，那就是使用所有以前的课程进入数据库????
我确定有一种方式，它可能只是几行代码但我只是没有找到合适的班级来做这件事，而且我厌倦了谷歌！如果有人可以提供帮助我真的会对它有所帮助。
ok it appears no one understands my problem? i''ll try to explain further.
1) i created a new empty database in my project folder, using SQLConfigDataSource (win32 api)
2) now i''d like to insert a new table using my example above in my first post, which uses "DataSet", "DataTable", "DataColumn" and "DataRow"
I can achieve that using the following code: (but i''d much rather learn how to use the above code)
---------------------
OleDbConnection dbConn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=c:\mydb.mdb");
dbConn.Open();
OleDbCommand cmd = new OleDbCommand();
cmd.Connection = dbConn;
// create table
cmd.CommandText = "CREATE TABLE mytable (Name VARCHAR(25), Age INTEGER)";
cmd.ExecuteNonQuery();
//add a row of data
cmd.CommandText = "INSERT INTO mytable VALUES (''John'', 30)";
cmd.ExecuteNonQuery();
dbConn.Close();
---------------------
but what''s the use of having all those previous classes if i can''t insert the final table into the database????
i''m sure there''s a way and it''s probably just a couple of lines of code but i just haven''t found the right class to do it, and i''m sick of google!, if anyone could help i would really apreciate it.
这篇关于如何将DataTable插入数据库？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
