Search results

  1. J

    Resolved Deleting a DataTable Record w/ LINQ

    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 _...
  2. J

    Writing DataTable (100+ Columns) Back To MS Access

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

    Updating A LINQ Query

    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"), _...
  4. J

    LINQ Select Distinct From Datatable

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

    Group Query Question

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

    StreamReader On CSV => List (Of String) - Leading Spaces

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

    Populating DataGridView from BackgroundWorker - Invoking

    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)...
  8. J

    Question Retrieving Table List - One DB Errors, One DB Does Not...

    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()...
  9. J

    Question Can Visual Studio Express Open Visual Studio Projects?

    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!
  10. J

    Question Connection String for Both MS Access 2003 & 2007?

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

    SQL Connection To Access - 2007 vs 2003?

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

    Can I Have A DataGridView 'Combo-box'?

    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?
  13. J

    MessageViewer - Industry "Trend" Question

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

    Determine Duplicates via LINQ

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

    StackTrace Question

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

    Using My.Settings to Load Different Configurations

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

    Adapter.Update

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

    Using LINQ to write?

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

    Dialog Form Suddenly Closes?

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

    Testing Exception Type .Message

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