Search results for query: *

  • Users: LeonR
  • Content: Threads
  • Order by date
  1. L

    Unicode / RTF / Datagridview / SQL

    Ok, I have a bit of an awkward problem...Basically to cut it short, data that I need to store in a couple of columns within SQL need to contain some superscript, it will be alphanumeric, it's not just the usual mathematic related symbols. The Greek symbols work fine (alpha, beta using nvarchar...
  2. L

    Relational DB vs JOIN

    This may be a really strange question, but why would you use relational tables within a DB when you can query them using INNER JOIN etc? (Assuming common ID's exist obviously)?
  3. L

    Immutable Datatypes

    I was after some opinions and views in regards to immutable and mutable data types. For example, I understand that if you were to define a string, that is creating and storing a string of char's in memory and then pointing a reference to that location? (indirect addressing?) That makes sense...
  4. L

    DISTINCT and INNER JOIN

    I have a SQL problem that has been bugging me, it should be simple but I can't 'quite' get the results im after. I have 2 tables, Table 1 and Table 2. Table 1 contains lots of orders, each line is an order (order number, customer number etc) , using DISTINCT, I can return just 1 of each order...
  5. L

    full SQL Server with full VS ?

    Quick question... If I buy VB professional, can I connect to SQL express/SQL server using normal TCP/IP connections with the entity model? At the moment it's awkward as it copys the DB to the VB directory, which means its not updating the live SQL database I assume? (at least if I change the...
  6. L

    Data Sources Wizzard missing SQL Server

    Does anybody know why my vb.net express is missing the SQL server express from the list?? (just compact and SQL file). This is rather annoying! Obviously I can connect manually, but I wanted to experiment with the data entity models etc! Thanks, Leon
  7. L

    Best practices for SQL query

    Out of interest, how are people managing their query strings from within a vb.net? I am currently using a function (method) in a class object, and simply parseing the string to the function, either add or get data. Obviously doing this means you end up with alot of hardcoded stuff in the...
  8. L

    Datatable object within class function + garbage collection?

    Sorry for the vauge title, it's a bit tricky to summarize in a line! Basically I have written a class which will be responsible for my SQL transactions. Within the class there is a function which you parse a query string to, the function will connect to the DB, execute the query and return the...
  9. L

    Option Strict and Data Type Conversion

    Just wondering what the preferred/practised data type conversion technique is? For example I recently enabled option strict, which in turn found quite a few errors in relation to data types, vb.net prompted me to use CType, which is fine. However, I have seen other functions for data type...
  10. L

    DrawString, 96dpi.....bad quality?

    I am writing some software which overlays text on to an image. The code is quite straight forward, I am basically creating a new bitmap obect, then loading a jpg (or bmp) into it , then assigning it to a graphics object (if thats teh correct term), using the drawstring function and outputing it...
  11. L

    Threading, class and GUI

    Hi guys, I know this is probably a common one, its also quite tricky to know how to get around it (I find anyway). I have a seperate thread, within that thread I have defined an object (of my own class). Obj.UpdateMyForm is called, but how do I get the code from my class to update the form...
  12. L

    Using images from resources

    This is probably quite simple, but it keeps tripping me up. I have added a .png to my project (in solution explorer). Now all I need to do is simply point a picturebox at this resource and display it. I'm obviously missing something quite primitive! I assume that would be classed as a...
  13. L

    Switching Monitor Off and On?

    Hi, I've had a quick search and not got very far. Using google I managed to find some good examples but they just don't do anything. CodeProject: Turn On and Off Monitors from .NET Console Application. Free source code and programming help I've tried the above link and a few others with no...
  14. L

    Left click for notifyicon menu?

    Ive done some searches on the web and not found much. Basically, I have a NotifyIcon contextmenu setup, which works fine for right click. I simply want the same menu to pop up when I left click, ive got as far as this :- NotifyIcon1.ContextMenu.Show(x, Control.MousePosition) what do i use...
  15. L

    Express Edition - Restrictions?

    Hi, Just curious on a few things related to vb.net 2005 express edition. Is it legal to use it for purposes other than education/home use? Can you sell software created with it? And use it for commerical purposes? Cheers people! Cool community here also :)
Back
Top