User Profile

Collapse

Profile Sidebar

Collapse
AlmightyJu
AlmightyJu
Last Activity: Sep 15 '13, 07:04 PM
Joined: Sep 30 '08
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • AlmightyJu
    replied to SELECT In order by specific Ids
    in SQL Server
    The list of Ids is dynamic, its for a vb net app, the Ids can be selected by the user in an order or it might be from a different select statment, this particular case is ordered by a date but the ids are passed from a different function.

    I think i'll just generate the code you posted for the ids as the ids are in a collection so its simple enough to do. Will it be a problem with performance if i use that for about 20+ ids?
    ...
    See more | Go to post

      Leave a comment:

    • AlmightyJu
      started a topic SELECT In order by specific Ids
      in SQL Server

      SELECT In order by specific Ids

      I've got a bit of a strange question, a short version of the sql I'm using is

      SELECT * FROM table WHERE id IN (5,10,1,9)

      Is there a way to get the results in the same order as the IN clause? so the results should be ordered by the id and be returned as 5,10,1,9

      Maybe im not thinking about it the right way but its ran from within a vb.net app and the IN(x) is generated from somewhere else.

      ...
      See more | Go to post
      • AlmightyJu
        replied to How to Change Column Name in DataGridView in Runtime
        in .NET
        If you mean in VB.NET then its

        DataGrid.Column s(0).HeaderText = MyTextBox.Text

        and use that wherever you need to.

        hope it helps
        See more | Go to post

          Leave a comment:

        • AlmightyJu
          replied to Get the Excel sheet name
          in .NET
          The code i used is:

          Code:
          Dim ExcelApp As New Microsoft.Office.Interop.Excel.Application
Dim Workbook As New Microsoft.Office.Interop.Excel.Workbook

Workbook.Sheets(1).Name = "Your Sheet Name"
          If you want to have the properties and methods appear after the typing Workbook.Sheets (1).

          use the code

          Ctype(Workbook. Sheets(1), Microsoft.Offic e.Interop.Excel .Worksheet)...
          See more | Go to post

            Leave a comment:

          • AlmightyJu
            replied to Object reference not set to an instance of an object
            in .NET
            Any idea which line is causing it to say that?
            See more | Go to post

              Leave a comment:

            • AlmightyJu
              replied to VB.NET Select Text in Label
              in .NET
              Its a desktop app, I thought about having a right click and copy or a button, was just wondering if its possible to have it selectable as sometimes they want to copy the entire address and others just the postcode.

              Nothing to port really, just added the context strip in the designer and just added

              Clipboard.SetDa taObject(Addres sLbl.Text, False)

              to the handler, I'll just ignore the postcode for now since...
              See more | Go to post

                Leave a comment:

              • AlmightyJu
                started a topic VB.NET Select Text in Label
                in .NET

                VB.NET Select Text in Label

                Hi all,

                I just joined because I've found loads of help on this site but I cant find an answer to this.

                I have a form that i loads data in from a database and stores them in various controls and the address is in a label, is it possible that you can select text in the label just like in a text box and copy the text? I cant find anything that helps :(

                I don't want to change it from a label to a text box...
                See more | Go to post
                No activity results to display
                Show More
                Working...