OlderDog's Q&A profile

• SQL Server Between + '%'

  helloo I have this table Id Code -- -------- 1 10101001 2 10101002 3 10102001 4 10102002 5 60101001 6 60101002 7 60102001 8 60102002 9 60201001 10 60201002 11 70101001 12 70101002 I need to query this table by the following (select id, code from table1 where code between '1' + '%' and '7' +'%') to get all values of codes between (code starting with 1) and (code starting with 7) or for example: (select id, code from table1 where code between '602' + '%' and '7' +'%') ------------------------------------------------------------------------- Im not getting correct answers or let be specific in the second query im not getting codes starting with 7, im only getting codes >= 602 but less that 7, so 7 is not incl ...Show All

• Windows Forms Adding Row header a text in datagridview

  hi all, Can anyone tell how to add the rowheader a text in datagridview using visual c# Thanks. http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=298522&SiteID=1 please look at that thread ,i hope it will help ...Show All

• Visual Basic Command Line Switches

  Okay, A really easy one here. I want to pass a single command line switch to my application, where if there is a specific switch it will show one form, if there is no switch or an unrecognised switch, it will show another form. Just need to know how I would go about finding out what switch was supplied - see, easy!! Thanks in advance OK, I've just found another way of doing this. There is a system array, my.application.commandlineargs, which contains the switches. I plan to put in my Saver_load event and if my switch is there I do me.close() then show my new form ...Show All

• Windows Forms GridView with Radio Button

  Hi, i am using Visual Studio 2005, (Framework 2.0) How to Display Radio Buttons in GridView. Thanks Please refer to http://msdn.microsoft.com/library/default.asp url=/library/en-us/dnvs05/html/winf_radiobutton.asp Hope it is helpful ...Show All

• Visual C# Beginning C# / .NET Questions ( Timers, Strings, and HTTP servers)

  I've been a Delphi developer for several years but am trying to learn .NET and C# but I have a few questions... 1) Does C# / .NET have timers I'd like to setup a timer so that a function is called every XX minutes. 2) How can I split a string containing linebreaks into an array (or any other object) For example let's say I have "Hello<CR>To the world!<CR>" then I'd like a[0] = "Hello" and a[1] = "To the world!" 3) Does C# / .NET have any simple built-in HTTP servers I'd like my application to have a built-in webserver for remote configuration (sort of like a router configuration web server) Thanks for any help! sofakng wrote: 1) Does C# / ...Show All

• Visual Basic TabPage Header Question

  Is it possible to change the color of just the header of a tabpage If so, can someone please assist me with this Any ideas Thanks all... jb Absolutely...set the drawmode to owner draw and then draw the tabs in the drawitem event: Private Sub Form1_Load ( ByVal sender As Object , ByVal e As System . EventArgs ) Handles Me . Load With Me . TabControl1 . DrawMode = TabDrawMode . OwnerDrawFixed End With End Sub Private Sub TabControl1_DrawItem ( ByVal sender As Object , ByVal e As System . Windows . Forms . DrawItemEventArgs ) Handles TabControl1 . DrawItem Dim g As Graphics = e . Graphics Dim p As ...Show All

• Windows Forms Tabcontrol - bug(?) when pasting components on it

  Hello all First: Visual Studio 7.1.3088 .NET Framework 1.1 SP1 Here's the problem. I've got 3 forms with each one one tabcontrol on it, each tabcontrol having several pages (3 or 4). When I cut a component (GroupBox, TextBox, Label) from it and try to paste it on another TabPage, it only works with 1 component. After that, CTR-V or CTR-C don't perform any actions and "Cut, Copy, Paste, Delete and Select All" are grayed out in the Edit-menu. "Bring To Front, Bring To Back, Align To Grid, Lock Controls, Cut, Copy, Paste, Delete and Properties" are grayed out in the contextmenu. This means that I can cut one control -or select multiple controls- and paste it on a different page. Then the menu's get grayed out. The ...Show All

• Visual Studio Express Editions need features in Advanced

  I need some of the features of the advanced install. Ploblem is I already installed the regular version. How do I get those advanced features now I already have db's on it and running Dave I believe you can find all the advanced features on the SQL download page http://msdn.microsoft.com/vstudio/express/sql/download/ You can install the Management Studio and the Reporting services toolkit separately. ...Show All

• Visual Basic Saving into Excel

  I know i can save text files into text documents, but can i save them into excel spreadsheets IceAngel89: Try the following code can hope that helps: Dim oExcel As Object Dim oBook As Object Dim oSheet As Object 'Start a new workbook in Excel Set oExcel = CreateObject( "Excel.Application" ) Set oBook = oExcel.Workbooks.Add 'Add data to cells of the first worksheet in the new workbook Set oSheet = oBook.Worksheets(1) oSheet.Range( "A1" ).Value = "Last Name" oSheet.Range( "B1" ).Value = "First Name" oSheet.Range( "A1:B1" ).Font.Bold = True oShe ...Show All

• Visual C# Setting Font Size on Thumbnail Image

  Hi, Can anyone tell me why when I use the code below, the font size comes out a different size on each thumbnail image System.Drawing.Image theThumbnail= bmp.GetThumbnailImage(width, height, myCallBack, IntPtr.Zero); Graphics g= Graphics.FromImage(theThumbnail); g.DrawString("SOLD",new Font("Verdana",6, FontStyle.Bold), new SolidBrush(Color.FromArgb(100,255,255,255)),0,0); I got it set to the perfect size for my test image, then tried another image and it was too small. It's like it's relative to the original image size and not the thumbnail image size The font em-size is usually expressed in points, which is an absolute measurement unit (one point should be 1/72"). ...Show All

• Visual Basic To attach to a Com+ Application

  How can I make my application attach to multiple com application I would like to provide a list of com applications installed on the user's pc. For this reason I can't create a reference to the com object during runtime. It should be dynamic as per user selection. It could be an Excel, Word or other com application. Summary 1) To get a list of all com applications available on the user's pc 2) To create a reference dynamical to what the user chose. Thanks Further to my enquiry, I was guided to use wmi however it seems that there is a little bit of difficulty of how and what to use to read the GUID of a com application and then to add a reference dynamically to that object. I ...Show All

• Windows Forms Problem with printing to printer ...............

  I have some code I made. I am useing WinXP Pro. In My Code I Print about 500 Pages with table that is the same for every page , but the difrent for every page is the data. my problem is, when I am starting the print I am running the same code of the table into System.Drawing.Printing. PrintPageEventArgs and in the info of the spooler of the printer I can see that the file to print is very big about 30 MB . but when the file Is come's to 10MB it go's very slowly. I use lyser printer with 64 MB very fast. what can I do Can I save the table in System.Drawing.Printing. PrintPageEventArgs In memory and add to him for every page the data Start your serach for problem from ...Show All

• Visual Studio Express Editions copy and paste listbox items

  i am creating a program that runs a game and then lists the 'results' in a listbox. i want the end user to be able to copy and paste the items in the listbox to another program, say, word. i have changed the select to multi, so i can select all the rows, but can't do anything with them. can anyone help me out. thanks in advance. btw, i'm using vb 2005 express edition. i dont think so. after the program is ran, i want to be able to highlight the listbox items, right click, copy, and then paste to another program, like a word. sorry if i'm being confusing...im very new to programming ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Free press for XNA

  Someone's obviously read the FAQ Nonetheless, it's free press: http://arstechnica.com/articles/xna.ars monkeynova ...Show All

• Windows Forms Font style not found issue/exception -- how can apps work with this problem?

  I have the following code (generated by the designer): this .panelTabs.Font = new System.Drawing. Font ( "Verdana" , 11.25F, System.Drawing. FontStyle .Regular, System.Drawing. GraphicsUnit .Point, (( byte )(0))); A user running our app gets the exception: ArgumentException: Font 'Verdana' does not support style 'Regular'. because the user's computer has all verdana font files but the "Regular" one. So he has bold, italics, etc files but does NOT have the "regular" font style. If all the verdana fonts are missing, Windows smartly does a font substitution. However, when certain style is missing, it does not seem to do it. How can I avoid this exceptioon without having to go through hundred ...Show All