Search results for query: *

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 been using the following code with my .NET application which reads information from Access Dim MSAccess_Connection As OleDb.OleDbConnection Dim strMSAccess_Connection_SQL As String = "" Dim strDatabaseTable_SQL As String = "" Dim MSAccess_DatabaseTable As New DataTable...

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...

In MS Access, it's possible to have a pull-down menu for the user to select certain items for entry into a field... Can I do that with a DataGridView?

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 I've successfully used the following code to populate a datatable from my MS Access database strMSAccess_Connection_SQL = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & strDatabaseFilePath & ";Persist Security Info=True" MSAccess_Connection = New...

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" _...