Fordraiders
asked on
Updating Label showing Access Record
vb.net 2003
access 2003
I have a lable on my from that I would like to see what record I'am on in this loop
LabelRec
Can I have the Label Updated as I loop through this access table records ?
Dim dbConnection As Data.OleDb.OleDbConnection
Dim dbCommand As Data.OleDb.OleDbCommand
Dim dbDataAdapter As Data.OleDb.OleDbDataAdapte r
Dim dbCommandBuilder As Data.OleDb.OleDbCommandBui lder
Dim dbDataSet As Data.DataSet
dbConnection = New Data.OleDb.OleDbConnection ("Provider =Microsoft .Jet.OLEDB .4.0;Data Source=C:\DM2007\SkuCat.md b;User Id=admin;Password=;")
dbConnection.Open()
dbCommand = New Data.OleDb.OleDbCommand("S ELECT * FROM tblData", dbConnection)
dbDataAdapter = New Data.OleDb.OleDbDataAdapte r(dbComman d)
dbCommandBuilder = New Data.OleDb.OleDbCommandBui lder(dbDat aAdapter)
dbDataSet = New Data.DataSet
dbDataAdapter.Fill(dbDataS et, "tblData")
With dbDataSet.Tables("tblData" )
For Each dbRow As Data.DataRow In dbDataSet.Tables("tblData" ).Rows
' regular function
' regex dot if not surrounded by Numerics 01172007
dbRow.Item("fldDescription ") = Regex.Replace(dbRow.Item(" fldDescrip tion"), _
"(?<1>[a-zA-Z])(?<2>\.)(?< 3>\d)|(?<1 >\d)(?<2>\ .)(?<3>[a- zA-Z])", "$1 $3")
' regex Deleting Dot/periods if not surrounded by Numerics H.H Y.C
dbRow.Item("fldDescription ") = Regex.Replace(dbRow.Item(" fldDescrip tion"), _
"([a-zA-Z])(\.)([a-zA-Z])" , "$1 $3")
' regex slash if not surrounded by Numerics G/G Y/Y
dbRow.Item("fldDescription ") = Regex.Replace(dbRow.Item(" fldDescrip tion"), _
"([a-zA-Z])(\/)([a-zA-Z])" , "$1 $3")
Next
End With
dbDataAdapter.Update(dbDat aSet, "tblData")
dbConnection.Close()
Thanks fordraiders
access 2003
I have a lable on my from that I would like to see what record I'am on in this loop
LabelRec
Can I have the Label Updated as I loop through this access table records ?
Dim dbConnection As Data.OleDb.OleDbConnection
Dim dbCommand As Data.OleDb.OleDbCommand
Dim dbDataAdapter As Data.OleDb.OleDbDataAdapte
Dim dbCommandBuilder As Data.OleDb.OleDbCommandBui
Dim dbDataSet As Data.DataSet
dbConnection = New Data.OleDb.OleDbConnection
dbConnection.Open()
dbCommand = New Data.OleDb.OleDbCommand("S
dbDataAdapter = New Data.OleDb.OleDbDataAdapte
dbCommandBuilder = New Data.OleDb.OleDbCommandBui
dbDataSet = New Data.DataSet
dbDataAdapter.Fill(dbDataS
With dbDataSet.Tables("tblData"
For Each dbRow As Data.DataRow In dbDataSet.Tables("tblData"
' regular function
' regex dot if not surrounded by Numerics 01172007
dbRow.Item("fldDescription
"(?<1>[a-zA-Z])(?<2>\.)(?<
' regex Deleting Dot/periods if not surrounded by Numerics H.H Y.C
dbRow.Item("fldDescription
"([a-zA-Z])(\.)([a-zA-Z])"
' regex slash if not surrounded by Numerics G/G Y/Y
dbRow.Item("fldDescription
"([a-zA-Z])(\/)([a-zA-Z])"
Next
End With
dbDataAdapter.Update(dbDat
dbConnection.Close()
Thanks fordraiders
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER