Visual Basic

FirstPrevNext

Re: error in this code magedhv3-Jul-07 0:01 magedhv 3-Jul-07 0:01  syntex error do u have another solution i have already use this code in another form and it works well (in my first topic ) i don't know what's wrong Re: error in this code magedhv3-Jul-07 1:28 magedhv 3-Jul-07 1:28  he gives me error when i tried to enter 2 values this is the error syntax error (missing operator) in query expression '7/2/2007Vodafone'. Re: error in this code ChandraRam3-Jul-07 2:18 ChandraRam 3-Jul-07 2:18  magedhv wrote: syntax error (missing operator) in query expression '7/2/2007Vodafone' It looks like you dont have the two fields separated - shouldnt it be '7/2/2007','Vodafone'... Also, the first is a date field, IIRC date fields for Jet databases should be enclosed by # not quotes. Re: error in this code magedhv3-Jul-07 2:25 magedhv 3-Jul-07 2:25  plz write 4 me the code of the date to try thanks i appreciate your efforts Re: error in this code ChandraRam3-Jul-07 2:44 ChandraRam 3-Jul-07 2:44  Just remember this... for text (string) variables, enclose data in quotes - like 'Vodafone' for number variables, just the value will do for date variables, enclose data with # - like #7/2/2007# and between each field, you should have a comma. Hope this helps. Re: error in this code magedhv3-Jul-07 3:04 magedhv 3-Jul-07 3:04  do u mean like that dim x as string x = "'" # DateTimePicker1.Value # "'" if that's what u mean the visual basic underline the last line (x = "'" # DateTimePicker1.Value # "'" ) plz try to write the whole code and note that the same code i use it with the same string in other form and it worked well Re: error in this code ChandraRam3-Jul-07 3:09 ChandraRam 3-Jul-07 3:09  magedhv wrote: x = "'" # DateTimePicker1.Value # "'" Thats not what I mean... try this: x = "#" & DateTimePicker1.Value & "#" Re: error in this code Dave Kreskowiak3-Jul-07 5:04 Dave Kreskowiak 3-Jul-07 5:04  Ignore ALL the other replies you've gotten in this thread. They're all crap. Drop all this string concatenation garbage and do it the correct way with a parameterized query. See this article[^] by Colin Angus Mackay for more information as to what they are and why your shooting yourself in the foot doing it your way. You're actaully making is harder on yourself by building a string for your parameters. A guide to posting questions on CodeProject[^] Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic      2006, 2007 Re: error in this code magedhv4-Jul-07 0:34 magedhv 4-Jul-07 0:34  could u plz tell me what should i do because i read this topic but i didn't understand what to do so if u have any idea about what to do simply tell me and thanks i appreciate ur efforts Re: error in this code Dave Kreskowiak5-Jul-07 4:34 Dave Kreskowiak 5-Jul-07 4:34  I did "simply" tell you. You're building an SQL query by appending multiple strings together. This introduces the opportunity for a lot of bugs and security holes into your code. Read the article I gave you a link for and about half way down, it'll explain what a parameterized query is and how to put it together to solve most of your security and readability problems. A guide to posting questions on CodeProject[^] Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic      2006, 2007 Getting postition of the Mouse in a PictureBox Zaegra2-Jul-07 22:27 Zaegra 2-Jul-07 22:27  Hi, I'd like to know how i can get the mouse position in an image loaded into a picturebox. (The Image is stretched) If i use MousePosition i get the position of the mouse on the form, and i want to get the mouseposition on the image loaded into the picturebox. Again, the image is stretched so a x value of 1000 could be a x value of 1500 in real. Help, please? --Zaegra-- Re: Getting postition of the Mouse in a PictureBox Dave Kreskowiak3-Jul-07 5:00 Dave Kreskowiak 3-Jul-07 5:00  To do this, you cannot rely on the picturebox painting the picture for you. You have to supply the code to paint the picture yourself. This is because in order to map the mouse point coordinates in the picture box to the image its displaying, you MUST know the scaling values being used to scretch the image. Since the picturebox doesn't expose these to you when it draws the image, you have to calculate the scaling values yourself. A guide to posting questions on CodeProject[^] Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic      2006, 2007 Re: Getting postition of the Mouse in a PictureBox Zaegra5-Jul-07 1:15 Zaegra 5-Jul-07 1:15  Wew, seems pretty hard I have no idea on how to calculate those values, do you have any suggestions? --Zaegra-- setup with .net or sqlserver Doshi Divyesh2-Jul-07 22:15 Doshi Divyesh 2-Jul-07 22:15  how can i check whether .net or sqlserver was installed or not on a machine where i can run my msi?? so which dll(s) or file(s), i have to include in the setup project?? Beginner developer Re: setup with .net or sqlserver Dave Kreskowiak3-Jul-07 4:57 Dave Kreskowiak 3-Jul-07 4:57  You may want to look at Google for this[^] article for an example. You can check for the .NET Framework, but checking for SQL Server is pointless because the server may be running on an entirely different machine. A guide to posting questions on CodeProject[^] Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic      2006, 2007 WebService in vb6.0 ShuklaGirish2-Jul-07 22:13 ShuklaGirish 2-Jul-07 22:13  How to implement the webservice feature in vb 6.0 GIRISH Re: WebService in vb6.0 Dave Kreskowiak3-Jul-07 4:44 Dave Kreskowiak 3-Jul-07 4:44  You don't. VB6 doesn't support writing a web service. A guide to posting questions on CodeProject[^] Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic      2006, 2007 Bar code scanner USB Deemo2-Jul-07 20:08 Deemo 2-Jul-07 20:08  I have a cheap bar code scanner which I use a serial interface with and accessibility options (serialkeys). I have a USB cable for the scanner but I have absolutely no idea how to program this so that I can input data from the bar code scanner. Can anyone help? Thanks Wayne Re: Bar code scanner USB CPallini2-Jul-07 20:24 CPallini 2-Jul-07 20:24  Usually the device vendors provide RS232 emulation (or suitable library to communicate via USB), refer to you bar code scanner documentation. If the Lord God Almighty had consulted me before embarking upon the Creation, I would have recommended something simpler. -- Alfonso the Wise, 13th Century King of Castile. Re: Bar code scanner USB Navneet Hegde2-Jul-07 20:26 Navneet Hegde 2-Jul-07 20:26  Hi , simply open any Editor ex: Notepad scan the Light Of your Bar code scanner over any Barcode like Any book or Item, The SerialNo or the Code will be printed on notepad .MAtch this number with the one written under the barcode to verify Regards & wishes Navneet Hegde Nashik(City Of Pilgrimage) Develop2Program & Program2Develop Re: Bar code scanner USB Dave Kreskowiak3-Jul-07 4:44 Dave Kreskowiak 3-Jul-07 4:44  Usually, barcode scanners give you the data through the keyboard, just like the user typed it. You'll have to consult the documentation on the scanner to see if this is true. Once you determine that, you can plan your code. A guide to posting questions on CodeProject[^] Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic      2006, 2007 where do I find DefaultClientScript progperty VB 2005 GuildfordG2-Jul-07 19:53 GuildfordG 2-Jul-07 19:53  I’m USING VB 2005 to write web forms. In the tutorial it tells me to display the page in design view and then select DOCUMENT from the object list box at the top of the property window, then find the DefaultClientScript property and change it to VBScript. The problem being is that I can not find this property. Help please, as I'm new to the ASP.NET environment. Regards Graeme Guildford. I am always greteful for any help! Re: where do I find DefaultClientScript progperty VB 2005 Dave Kreskowiak3-Jul-07 4:29 Dave Kreskowiak 3-Jul-07 4:29  Try asking in the ASP.NET Forum[^]. The tutorial is either for an older verision of ASP.NET (.NET Framework 1.1 or lower), or is just plain wrong. There is no property called "DefaultClientScript" that I can find. Then again, I don't do any ASP.NET work, so I could easily be wrong. A guide to posting questions on CodeProject[^] Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic      2006, 2007 2-tier architecture and 3-tier architecture ShuklaGirish2-Jul-07 19:22 ShuklaGirish 2-Jul-07 19:22  Hi, I want to know the practicle diffrence between 2-tier architecture and 3-tier architecture.Also the advantages and disadvantages of both. Pls send me asap. Thanks and Regards. GIRISH Re: 2-tier architecture and 3-tier architecture originSH2-Jul-07 22:40 originSH 2-Jul-07 22:40  n-tier is the logical seperation of your code where n is the number of layers. By seperating your code into tiers/layers you are making it potentially more maintainable, more flexable and more scalable. That all depends on if you do a good job of it or not though :P Here's an ok, if a bit preachy, article: http://www.15seconds.com/issue/011023.htm[^]

Last Visit: 31-Dec-99 18:00     Last Update: 27-Sep-24 5:25 Refresh ᐊ Prev1...2379238023812382238323842385238623872388 Next ᐅ

General    News    Suggestion    Question    Bug    Answer    Joke    Praise    Rant    Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.