User Profile

Collapse

Profile Sidebar

Collapse
MIkeC
MIkeC
Last Activity: Oct 6 '08, 09:04 AM
Joined: Jan 15 '08
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • MIkeC
    started a topic Loop through CheckedListbox
    in .NET

    Loop through CheckedListbox

    In VB net 2005, I have loaded a Checkedlistbox with values, I now want to loop through these values and test against another table, if there is a matching string then set the checkbox

    Thanks in advance
    See more | Go to post
    • MIkeC
      started a topic Efficient way of opening Excel and displaying result set from a SQL Server table in v
      in .NET

      Efficient way of opening Excel and displaying result set from a SQL Server table in v

      I am new to quite new vb net 2005 and want to read a sql server table and load the result set directly into excel. I want the worksheet to be opened and display the column headers and data from the query.
      In VB6 it was possible to declare a Querytable and I am wondering if there is an equivalent in .Net
      See more | Go to post
      • MIkeC
        replied to Populate Form from SQL Server
        in .NET
        Thanks for the Rapid reply.

        I have a couple of problems. It seems that Autopostback is an ASP feature I am coding in VB. sorry If this is wrong

        The form will only display 1 row which is controlled by the Where clause. Ideally I will have a button on the form that will perform the Update code and close the form. I was looking for an update command that will commit all changes back to database

        Thanks in...
        See more | Go to post

          Leave a comment:

        • MIkeC
          started a topic Populate Form from SQL Server
          in .NET

          Populate Form from SQL Server

          Apologies if this has already been posted.

          I am coding in VB

          I am trying to find the best way to populate a form from a sql Database in .net 2005

          I have a company table that has > 20 columns, I will be selecting a specific row. I have populated the form with textboxes that are named so that they reflect the column names of the company table.

          I want to select the row, populate the form...
          See more | Go to post
          • MIkeC
            replied to Problem opening Excel from VB
            in Visual Basic
            I agree that it should make any difference as to how things run.

            I use the same account login etc....
            See more | Go to post

              Leave a comment:

            • MIkeC
              replied to Problem opening Excel from VB
              in Visual Basic
              I can certainly run the application when I run it locally and not through Citrix?...
              See more | Go to post

                Leave a comment:

              • MIkeC
                replied to Problem opening Excel from VB
                in Visual Basic
                I removed the on error resume code but still did not receive a message
                See more | Go to post

                  Leave a comment:

                • MIkeC
                  started a topic Problem opening Excel from VB
                  in Visual Basic

                  Problem opening Excel from VB

                  I am trying to open a specific Excel speadsheet so that I can load to a table.

                  I am using VB6 in Citrix.

                  The code works OK when run locally but simply closes down the application without a runtime error when executing the exe in Citrix

                  The Code is:

                  [CODE=vb]Private Sub ImportID_Click( )
                  Dim S As String, RecsIn As Long, T As String, I As Long, F As Long, f1 As Long
                  Dim iExcel...
                  See more | Go to post
                  Last edited by Killer42; Jan 18 '08, 12:00 AM.
                  No activity results to display
                  Show More
                  Working...