I've got a DataTable that I need to delete some rows from; I'm trying the following code but getting some unexpected results
Dim DatabaseAuxiliary_Table_Query = From ADG_Auxiliary_Record In DatabaseAuxiliary_Table.AsEnumerable() Select ADG_Auxiliary_Record _...
Hi
I've got this LINQ query
Dim WindowAlarmList_Table_Query = From Alarm_Record As DataRow In WindowAlarmList_Table.AsEnumerable _
Select Alarm = Alarm_Record.Field(Of String)("Alarm"), _...
I'm trying to run a DISTINCT query to return a unique listing from my datatable...
Dim Compound_Blocks_Table_Query = From Compound_Block_Record In Compound_Blocks_Table.AsEnumerable Select Compound_Block_Record
Order By...
Hi all
Hoping that someone can help me figure this out...
I believe that the following would be a LINQ "Select" Query?
Dim Query = From Record In Table.AsEnumerable() Select Record
Where Record.Field(Of String)("FieldName") = SomeString
With this, I'm able to refer to any field in the...
I've got a CSV that's just a single column of text like so
Param1
Param2
Param3
and so on...
I'm trying to use
Dim strIA_Block_Parameters As New List(Of String)
Dim IA_Block_Parameters_FileStream As FileStream = New FileStream(strIA_Block_Parameters_FilePath...
Hi all
I'm trying to do this in a multi-thread
DataGridView.Rows.Add({Column1, Column2})
I created a delegate and the AddressOf sub
Private Delegate Sub UpdateDataGridViewCallback(ByVal text As String())
Private Sub UpdateDataGridView(ByVal text As String())
DataGridView.Rows.Add(text)...
Hi all
I've got a program that interfaces with an MS Access database, using the following conne
strMSAccess_Connection_SQL = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & strDatabaseFilePath
MSAccess_Connection = New OleDbConnection(strMSAccess_Connection_SQL)
MSAccess_Connection.Open()...
A co-worker of mine has Visual Studio 2008 with Visual Basic 2008 9.0.21022.8 RTM...
I have Visual Studio Express 2008 installed...
When I tried opening the project he sent me, I got an error stating that the .vbproj isn't supported by my version...
Thanks!
Can someone tell me if it is possible to generically connect to MS Access?
Originally, when my users were on Access 2003, I used
strMSAccess_Connection_SQL = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & strDatabaseFilePath
MSAccess_Connection = New...
Hi
My application currently works with Access 2003 using the following approach...
strMSAccess_Connection_SQL = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & strDatabaseFilePath
MSAccess_Connection = New OleDbConnection(strMSAccess_Connection_SQL)
MSAccess_Connection.Open()
When I load...
Quick question - rather curious about this...
I was recently told by one of my company's development team that the industry "trend" or "standard" with regards to outputting to the MessageViewer is to go from bottom to top...
So, instead of it being like this
Message1
Message2
Message3
etc...
Hi everyone
I've got a simple two-column datatable that I want to check for duplicate entries in a given column... looking around on MSDN, I found a bit of stuff but I seem to be doing something a bit wrong...
Dim MatchMakerXML_Query = From Match In...
Hi all
I implemented a stacktrace analysis subroutine a while ago and for the most part, it works great... when I process an "unexpected error", I almost always generated something like this
5/13/2009 3:12:35 PM - UNEXPECTED ERROR - MS ACCESS DATABASE TABLE RETRIEVAL FAILED
Module ...
Hi all
I currently use a Configuration.xml file to store the various preferences and settings of my application... I'd like to continue using this but allow my different users to "load" individual XML files...
To do this, I imagine I can the My.Settings to identify the location of the...
Hi all
Up to this point, I've just been reading from my Access DB (importing info into AutoCAD) using the LINQ which I've found particularly easy to use in selecting a single specific record and then particular fields of that record...
Dim DatabaseDrawing_Table_Query = From Drawing_Record In...
Hi all
Hoping someone can offer some insight on what I've done here... I'm opening a form using the following syntax...
FormName.ShowDialog()
All of a sudden (clearly, I did something), when I exit out of a FolderBrowserDialog OR a OpenFileDialog, the dialog form closes... I know this...
Hi
I'm using Try/Catch statements like the below to make sure that my error is what I expect it to be...
Catch Exception_Type As XmlException
If (Exception_Type.Message = "Root element is missing.") Then
MsgBoxPrompt = "ADG MatchMaker.xml Structure INCORRECT" _...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.