如何查找数据列并从所选列中获取数据 [英] How Do I Find Data Column And Get Data From That Selected Column
本文介绍了如何查找数据列并从所选列中获取数据的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
任何人请帮助
尝试
' Dim Cmd As OleDb.OleDbCommand
Dim Con As OleDb.OleDbConnection
Dim Sql 作为 字符串 = 没什么
' Dim Reader As OleDb.OleDbDataReader
Dim ds As 新 DataSet()
Dim adapter As 新 OleDbDataAdapter()
Con = 新 OleDb.OleDbConnection(DBpath)
Sql = 从用户中选择用户。*来自LoginID =& '& TextBox1.Text& '
' Cmd =新OleDb.OleDbCommand(Sql,Con)
adapter.SelectCommand = 新 OleDbCommand(Sql,Con)
Con.Open()
adapter.Fill(ds, Users)
Dim item As DataTable = ds.Tables( 0 )
DataGridView1.DataSource = ds.Tables( 用户)
Console.WriteLine( 表名:{0},item.TableName)
Console.WriteLine( 它的列是:)
对于 每个 col As DataColumn 在 item.Columns
如果 col.ColumnName.Substring(col.ColumnName。长度 - 3 )= Upd 然后
-----这里我GOT TO 找到我想要的领域< span class =code-keyword> TO 选择 那个字段______
' 如果row(col.ColumnName).Item.ToString =yes那么
Console.WriteLine( {0}& vbTab& {1},col.ColumnName,col.DataType)结束 如果
结束 如果
下一步
Con.Close()
Catch ex As 异常
MsgBox(ex.Message)
结束 尝试
结束 Sub
当它到达具有UPD名称的字段时,我无法检索该字段的值吗? div class =h2_lin>解决方案
列名是否以Upd开头?或以Upd结尾?您目前正在查看结尾。
一个字符串,相当于在此实例中以startIndex开头的子字符串
< br $> b $ b
效率相当低,但col.ColumnName.StartsWith(Upd)$ c怎么样$ c>或
col.ColumnName.EndsWith(Upd)
?
any one please help
Try
'Dim Cmd As OleDb.OleDbCommand
Dim Con As OleDb.OleDbConnection
Dim Sql As String = Nothing
'Dim Reader As OleDb.OleDbDataReader
Dim ds As New DataSet()
Dim adapter As New OleDbDataAdapter()
Con = New OleDb.OleDbConnection(DBpath)
Sql = "SELECT Users.* from Users where LoginID=" & "'" & TextBox1.Text & "'"
'Cmd = New OleDb.OleDbCommand(Sql, Con)
adapter.SelectCommand = New OleDbCommand(Sql, Con)
Con.Open()
adapter.Fill(ds, "Users")
Dim item As DataTable = ds.Tables(0)
DataGridView1.DataSource = ds.Tables("Users")
Console.WriteLine("Table name: {0}", item.TableName)
Console.WriteLine("Its columns are:")
For Each col As DataColumn In item.Columns
If col.ColumnName.Substring(col.ColumnName.Length - 3) = "Upd" Then
-----HERE I GOT TO FIND THE FIELDS I WANT BUT NEED TO PICK the value of that field_______
'If row(col.ColumnName).Item.ToString = "yes" Then
Console.WriteLine("{0}" & vbTab & "{1}", col.ColumnName, col.DataType) End If
End If
Next
Con.Close()
Catch ex As Exception
MsgBox(ex.Message)
End Try
End Sub
I cant retrieve value of that field when it gets to field that has UPD as name?
解决方案
Do the column names begin with "Upd"? Or end with "Upd"? You are currently looking at the end.
"A string that is equivalent to the substring that begins at startIndex in this instance"
That's rather inefficient, but how aboutcol.ColumnName.StartsWith( "Upd" )
orcol.ColumnName.EndsWith( "Upd" )
?
这篇关于如何查找数据列并从所选列中获取数据的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文