返回首页

您好,
我已经加入到与我SQLDatabase连接一个DataSet。测试查询显示正确的价值观,但是当我编程的尝试,以显示某一个领域的价值,使用下面的代码

昏暗的vrName = dsTest.Tables(tblTest)。行(0)(0)

,它syas表不是一个dsTest
成员
请告知我如何使用数据集阅读,写作,编辑和删除数据,因为我们在WinForms中使用。

非常感谢。

回答

评论会员:游客 时间:2012/02/04
,在C#codeprelang="c#"SqlDataAdapterdAdt=spanclass="code-keyword"new/spanSqlDataAdapter(spanclass="code-string""/spanspanclass="code-string"SELECT*FROMtblTest"/span,spanclass="code-string""/spanspanclass="code-string"ConnectionString"/span);DataSetdSet=spanclass="code-keyword"new/spanDataSet();DataTabledTab=spanclass="code-keyword"new/spanDataTable();DataRow[]dRow;dAdt.Fill(dSet,spanclass="code-string""/spanspanclass="code-string"tblTest"/span);dRow=dSet.Tables[spanclass="code-digit"0/span].Rows[spanclass="code-digit"0/span]spanclass="code-keyword"string/spanmyVar=dSet.Tables[spanclass="code-digit"0/span].Rows[spanclass="code-digit"0/span].ItemArray[spanclass="code-digit"0/span].ToString();/pre/code在VB.Netcodeprelang="vb"spanclass="code-keyword"Dim/spandAdtspanclass="code-keyword"As/spanspanclass="code-keyword"New/spanSqlDataAdapter(spanclass="code-string""/spanspanclass="code-string"SELECT*FROMtblTest"/span,spanclass="code-string""/spanspanclass="code-string"ConnectionString"/span)spanclass="code-keyword"Dim/spandSetspanclass="code-keyword"As/spanspanclass="code-keyword"New/spanDataSet()spanclass="code-keyword"Dim/spandTabspanclass="code-keyword"As/spanspanclass="code-keyword"New/spanDataTable()spanclass="code-keyword"Dim/spandRowspanclass="code-keyword"As/spanDataRow()dAdt.Fill(dSet,spanclass="code-string""/spanspanclass="code-string"tblTest"/span)dRow=dSet.Tables(spanclass="code-digit"0/span).Rows(spanclass="code-digit"0/span)spanclass="code-keyword"Dim/spanmyVarspanclass="code-keyword"As/spanspanclass="code-keyword"String/span=dSet.Tables(spanclass="code-digit"0/span).Rows(spanclass="code-digit"0/span).ItemArray(spanclass="code-digit"0/span).ToString()/pre/code
米卡Wendelius:编码与数据集,是两全其美的相同(ASP.NET /的WinForms)。基于错误消息的听起来dsTest是不是一个数据集,但别的东西。如果你悬停在dsTest的Visual Studio应该告诉你什么是你使用的类
评论会员:游客 时间:2012/02/04
srinivasvadepally:嗨kfsehgal,只是看到下面的链接,它可以清除您的问题。imgsrc=任何问题,请给我一个查询。有一个好时机!|