Visual Basic

FirstPrevNext

Stop Windows going to sleep while app is running The8at23-Jan-07 1:54 The8at 23-Jan-07 1:54  I need to be able to prevent Windows from powering-down while my VB6 application is running. Re: Stop Windows going to sleep while app is running Dave Kreskowiak23-Jan-07 5:26 Dave Kreskowiak 23-Jan-07 5:26  You can find an example here[^]. Dave Kreskowiak Microsoft MVP - Visual Basic Customize Setup for Vb.net Project Amit Gorawadia23-Jan-07 1:31 Amit Gorawadia 23-Jan-07 1:31  Hello Gurus I got an application developed in vb.net, for the deployment of it I need to cutomize that. I need to provide four option (checkbox) to user during the installation & based on the selection the installer should write the values in registry, I know how to provide the four options(checkbox) as well as how to write values in registry, The only bit I don't is how to check those option provided or choosen by the user(s). Please reply ASAP: Scheduling an Event on Developer Express Bright267723-Jan-07 1:24 Bright2677 23-Jan-07 1:24  Hi All, Can anybody let me know how to schedule an event through coding in Developer Express in Vb.Net Thanks & Best Regards, Noor. Noor Re: Scheduling an Event on Developer Express Dave Kreskowiak23-Jan-07 5:12 Dave Kreskowiak 23-Jan-07 5:12  Schedule an event?? What event? What is this app supposed to be doing? And what's "Developer Express"?? Are you talking about Visual Basic .NET Express Edition? Dave Kreskowiak Microsoft MVP - Visual Basic Re: Scheduling an Event on Developer Express Bright267723-Jan-07 16:53 Bright2677 23-Jan-07 16:53  Sorry, I will clear the question. I want to fix an appointment on some day (For eg 14-02-2007). I want to display it in Developer Express(Thirt Party Tools) Scheduler like we used to display in Microsoft Outlook Calendar. Hope This Question is clear to answer. Thanks & Best Regards, Noor. Noor Re: Scheduling an Event on Developer Express Dave Kreskowiak24-Jan-07 2:29 Dave Kreskowiak 24-Jan-07 2:29  Never used Developer Express stuff. Your best source of support is their own site and forums, here[^]. Dave Kreskowiak Microsoft MVP - Visual Basic Capture Data From a TCP/IP Address-Port Ian Woods22-Jan-07 23:57 Ian Woods 22-Jan-07 23:57  Hi All, I have to write some VB 2005 code that will capture barcode data sent via TCP/IP. I will then put the captured data to a SQL 2000 database table. I have no problems with the database stuff, where I really need HELP is how to capture the data beginning sent via TCP/IP port. I have the scanning hardware setup on my desk and working. Using the scanners setup software I can see that it is sending data out from its IP address on port 1024. The output string has a starting Header of “STX” and an ending footer of “ETX”. Example (STX**************ETX) * = Barcodes Data I would appreciate any help. Have not done any coding with TCP/IP before. Regards Woodsy Re: Capture Data From a TCP/IP Address-Port Dave Kreskowiak23-Jan-07 5:11 Dave Kreskowiak 23-Jan-07 5:11  Normally, I'd say you'd write a TCP/IP client to capture this data. You'd connect to the IP and port of the device and setup a NetworkStream object to read the data comming from the scanner. Exactly how you implement this, though, should be documented by the manufacturer of the scanner. Dave Kreskowiak Microsoft MVP - Visual Basic winproc in vb ng4kau122-Jan-07 23:53 ng4kau1 22-Jan-07 23:53  can any body help me?? LRESULT CALLBACK WndProc(HWND hwnd, UINT Message, WPARAM wParam, LPARAM lParam) i'm trying to convert this c++ code into vb 6.0 can i?, any recommendation for the message sending function i should use in vb? thx Re: winproc in vb Dave Kreskowiak23-Jan-07 5:06 Dave Kreskowiak 23-Jan-07 5:06  If I understand your question correctly, this can't be done in VB6. This is the Window Procedure function declaration that already exists in all VB6 Forms and controls. If you want to subclass the form, you'll have to supply your own, alternate, WndProc. You can find an example of installing your own message handler here[^]. Dave Kreskowiak Microsoft MVP - Visual Basic requirements obarahmeh22-Jan-07 23:35 obarahmeh 22-Jan-07 23:35  Hi Gyes, I have an application built on vb.net and this application connect to Oracle server database and retrieves data from it. What are the requirements needed when I wanna install this application into a new PC. I mean is there a need to have Oracle installed in the PC or not. Re: requirements Guffa23-Jan-07 0:03 Guffa 23-Jan-07 0:03  No, you don't need to install Oracle on the client. --- Year happy = new Year(2007); Re: requirements obarahmeh23-Jan-07 0:21 obarahmeh 23-Jan-07 0:21  But the .Net uses some files exist in the Oracle home like OCI.DLL which enables the .Net to connect to Oracle DB and retrieves data from it. So how do you say that we don't need to install Oracle on the PC???? Re: requirements Guffa23-Jan-07 0:47 Guffa 23-Jan-07 0:47  If you are using any libraries in your application, of course you have to include them when deploying the application. That has nothing to do with the fact that the libraries comes from Oracle. You don't need to install Oracle to connect to an Oracle database. --- Year happy = new Year(2007); Re: requirements obarahmeh23-Jan-07 1:00 obarahmeh 23-Jan-07 1:00  As I told you, we need a library called OCI.dll which comes from the Oracle home (bin folder inside Oracle home) and also other DLLs to enable the application to connect to Oracle, so how do we not need to install Oracle on the PC if we need these DLLs which are coming from Oracle and not embedded in the .Net framework??? Re: requirements mr_lasseter23-Jan-07 3:46 mr_lasseter 23-Jan-07 3:46  You need to install the Oracle client on the users machine. You will also have to configure the tnsnames.ora file to be able to connect to the database. Mike Lasseter Re: requirements Colin Angus Mackay23-Jan-07 3:47 Colin Angus Mackay 23-Jan-07 3:47  What Guffa means is that you do not need to install the Oracle database server on the PC. You may need to install some small redistributable parts of Oracle to allow the client to connect to the server. This should be documented in the .NET data provider you are using. Upcoming events: * Glasgow Geek Dinner (5th March) * Glasgow: Tell us what you want to see in 2007 My: Website | Blog | Photos Re: requirements Dave Kreskowiak23-Jan-07 3:52 Dave Kreskowiak 23-Jan-07 3:52  The system requirements for the .NET Framework Data Provider for Oracle state that the machine must have the Oracle Client, 8i Release 3 or greater or 9i or greater if your accessing a UTF16 database, installed in order to work. System Requirements[^] Dave Kreskowiak Microsoft MVP - Visual Basic Re: requirements obarahmeh23-Jan-07 20:24 obarahmeh 23-Jan-07 20:24  So gyes, if we wanna finish this conversation about my question, we can say as a result that we should install the Oracle client on the PC and also change the TNS names...realy I did that before but it is realy not good thing in the .Net framework that it needs some files from Oracle client to connect to Oracle DB. I think the .Net framework team developers must include those files inside the .Net framework to be more flexible and to less the need to install Oracle client each time you install your application into some machine in your company. Finally thank you very much gyes. Kind Regards OBarahmeh Palestinian Central Bureau of Statistics (PCBS) Ramallah-Palestinian Territory Re: requirements Dave Kreskowiak24-Jan-07 2:32 Dave Kreskowiak 24-Jan-07 2:32  obarahmeh wrote: but it is realy not good thing in the .Net framework that it needs some files from Oracle client to connect to Oracle DB. Why not? Besides, there are licensing issues here. Microsoft can't package parts of the Oracle client in the .NET Framework because Oracle won't let them. There's also an issue of functionality with different versions of Oracle. Like was stated, if you have a UTF16 database, you neeed to change out the underlying Oracle Client. This saves you from having to recompile your code and release a different version just to support the different encoding! How is this a bad thing???? Dave Kreskowiak Microsoft MVP - Visual Basic coding for retriving and save data in vb6 Sissy1222-Jan-07 22:59 Sissy12 22-Jan-07 22:59  hai... recently, just this afternoon i being asked by my superior to do vb function for retriving data(collect data and save in database)using vb6,in order for me to be transfered from acc to it department(web developer assistant)...it just a simple one but means a lot for me..imagined that i haven't touched vb since 2 years after my graduation in 2004...the rest software maybe..but not vb... any guys know...a simple coding for this..thks..i have to submit this thursday morning......even i asked help from my friends... i need to study and review all the thing again...oh gosh..i trying to sort out this mess... , sissy12 Re: coding for retriving and save data in vb6 Parwej Ahamad23-Jan-07 0:38 Parwej Ahamad 23-Jan-07 0:38  Dim DbaseConn As ADODB.Connection Dim RecSet As ADODB.RecordSet Set DbaseConn = New Connection Set RecSet = New Recordset DbaseConn.open(dsn="dsnname") 'For reading the records........... RecSet.open ("Select * from tablename") do while not RecSet.EOF msgbox(RecSet!column1) msgbox(RecSet!column2) ........................... RecSet.movenext loop 'For Add new record.................. RecSet.open ("Select * from tablename") RecSet.addnew RecSet!column1="value1" RecSet!column2="value2" RecSet.update 'finally close the connection RecSet.close() DbaseConn.close() ''''''''It's helpful for u Keep Smiling !!! Parwej Ahamad g_parwez@rediffmail.com Adding a new record to a DataTable with Identity column MatthysDT22-Jan-07 20:58 MatthysDT 22-Jan-07 20:58  In my application I have a typical setup: * Dataset with numerous DataTables, each with a TableAdapter * Various BindingSources I want to add a new record to a table of which I only fill one record at a time into my DataTable, meaning the DataTable in the DataSet will always only have 1 record. The table in my database (SQL2000) has an Identity(1,1) column as the Primary Key. When I add a new record to my DataTable, the first problem I get is that the Primary Key for the new record is wrong, probably because it doesn't know what the last identity insert value in the SQL table is. But even when I specify a value an Exception occurs at my BindingSource.EndEdit() section of the code. This exception reports that I cannot insert a NULL value into Column "ID"(or whatever my PK column is named) Where can I find an example of adding a user entered record to a datatable with an Identity column. This must be done using the controls on the form that are bound to the datasource. (WinForms VB.Net, Visual Studio 2005) you can't forget something you never knew... "Watching Migthy Joe Young made me hate my life..................................I want a gorilla!" A. Havemann Re: Adding a new record to a DataTable with Identity column shreekar22-Jan-07 21:59 shreekar 22-Jan-07 21:59  Google is the short answer. Long answer follows: Ideally, you should populate the data table, post the data back to the DB and get the newly added ID back (using stored procs?) Shreekar

Last Visit: 31-Dec-99 18:00     Last Update: 16-May-24 7:11 Refresh ᐊ Prev1...2851285228532854285528562857285828592860 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.