在 Visual Studio 上,我可以通过以下方式创建我的 SQLite 数据库的 DataSet:
1) 连接sqlite数据库文件并创建表
2) 将新数据集添加到我的解决方案 (DataSet2.xsd)
3) 将表格拖到设计器中
现在如何使用 Visual Studio 为我创建的对象?
例如,我正在尝试做类似的事情:
DataSet2.TableTestDataTable t = new DataSet2.TableTestDataTable();var objects = t.GetObjectData(..//不知道怎么用
或
DataSet2TableAdapters.TableTestTableAdapter t = new DataSet2TableAdapters.TableTestTableAdapter();var 数据 = t.GetData();var q = 来自数据中的 a选择一个;foreach(q 中的 DataSet2.TableTestRow 行){行.整数 = 12345;//改变列整数的值}t.submitchanges();//方法确实注意存在
解决方案 DataSet2TableAdapters.TableTestTableAdapter t = new DataSet2TableAdapters.TableTestTableAdapter();DataSet2 ds = new DataSet2();t.Fill(ds.TableTest);foreach(ds.TableTest.Rows 中的 DataSet2.TableTestRow 行){行.整数 = 12345;//改变列整数的值}t.更新(ds2);
类似的东西......
On visual studio I can create a DataSet of my SQLite database by doing:
1) Connect to sqlite database file and create a table
2) Add new DataSet to my solution (DataSet2.xsd)
3) Drag tables to the designer
Now how can I make use of the objects that visual studio created for me?
for example I am trying to do something like:
DataSet2.TableTestDataTable t = new DataSet2.TableTestDataTable();
var objects = t.GetObjectData(..// do not know how to use it
OR
DataSet2TableAdapters.TableTestTableAdapter t = new DataSet2TableAdapters.TableTestTableAdapter();
var data = t.GetData();
var q = from a in data
select a;
foreach (DataSet2.TableTestRow row in q)
{
row.integer = 12345; // change value of column integer
}
t.submitchanges(); // method does note exists
解决方案
DataSet2TableAdapters.TableTestTableAdapter t = new DataSet2TableAdapters.TableTestTableAdapter();
DataSet2 ds = new DataSet2();
t.Fill(ds.TableTest);
foreach (DataSet2.TableTestRow row in ds.TableTest.Rows)
{
row.integer = 12345; // change value of column integer
}
t.Update(ds2);
Something like that ....