|
hi all
i have a set of data in hyperterminal of my system which is automatically coming to the hyper terminal when i connect my pc to a epbax system.
now the problem is i want to insert those data to access database automatically when any new data comes to the hyperterminal using vb.net
can anybody help me in this regard with suitable code snippets..
thanks in advance
i m pradip kishore from india,working in vb.net & asp.net
|
|
|
|
|
You can't extract data from HyperTerminal. It doesn't expose any method of communicating with another application. The best way to do what you want would be to write your own serial comm app. That will get you the greatest flexibility and easy access to the data comming through the serial ports.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
thanks for ur response
my objective is.. when ever an EPBX will be connected to my pc,then the call details(like calling no,call duration etc..)will come to the hyper terminal of my pc automatically.bt i want a way by which i can insert those data to any of my access or sql server database for further manipulation through program(vb.net) based on the received raw data..
can u give me some sample code snippets or some links regarding this..
thanks in advance
i m pradip kishore from india,working in vb.net & asp.net
|
|
|
|
|
One more time... You can not use HyperTerminal in your program in any way shape or form!
You have to write your own code to handle the serial port and get the data from it.
VB.NET 2005 makes this pretty easy with the System.Io.Ports namespace. VB.NET 2002 and 2003 will need to use a 3rd party, or home grown, class that exposes the serial port to your code. A quick Google for "vb.net serial port"[^] comes up with lots of examples.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
hi
thanks for your help
i m pradip kishore from india,working in vb.net & asp.net
|
|
|
|
|
i have a problem like i would not like my user to type in the same thing over and over again. What i would like to do is tt if the user type something in the textbox, my textbox is able to save the statement. So in future the user who wants to use the program again can just click on the dropdown arrow and select the text and not keying in everything again. Any solution to tis??
|
|
|
|
|
You need to write the code to store it somewhere. A textbox isn't going to do that, and it's the wrong place to write the code to store your information. Where do you want to store it ?
Christian Graus - C++ MVP
|
|
|
|
|
Also, it appears you want a combo box, not a text box. Probably you want to store past choices as Xml, I would suspect.
Christian Graus - C++ MVP
|
|
|
|
|
Currently in my application i am using textbox. wat i mean is if the user type in for example 'myproject.com.sg' and tis phrase wil be save and the next time the user will not have to type in anymore but can select from a dropdown arrow. i am doing sumthing like combo but as i know the variable we have to preset ourselves and it is not fexible. What i need to save is wat the user type in and i cant hardcode wat they ared going to type.
|
|
|
|
|
OK, so do what I said. Use a combobox and store the text that is entered to an XML file.
Christian Graus - C++ MVP
|
|
|
|
|
how to?? i do not know how to use XML. Do u have any example of wat should i do?
|
|
|
|
|
I am going out. A DataSet can save/load XML, or you can use an XmlDocument.
Christian Graus - C++ MVP
|
|
|
|
|
still dun understand.. Any site whereby i can refer to?
|
|
|
|
|
mystring = text1.text //store what they've entered in a string
combo1.additem mystring //store what's in the textbox in a combo
next time user uses the system they drop down the combo to find their item and don't enter text in the text box
|
|
|
|
|
Subjugate wrote: Any site whereby i can refer to?
This one. There are plenty examples of how to use XML if you search the articles.
|
|
|
|
|
You can also use SQL or Access to store the input data. Although I suspets it would be slower than going the XML route. But if you have no experience with XML this may be the way to go.
It should be fairly easy. Just create a SPROC that updates the table after each entry and on page load fills a dataset that populates the comboBox.
I know I was really broad but you can find hundreds of sites on how to accomplish this. Good Luck.
GT
|
|
|
|
|
Hi,
I have created a report using TTX file. If i preview the report the sample data in TTX file is not displayed. Instead it shows '1' as default value for the number fields and 'string sample value' for string fields. Please help to solve this.
Thanks,
Ramesh.
|
|
|
|
|
What is a TTX file ?
Christian Graus - C++ MVP
|
|
|
|
|
Tab separated Text file. It is a data definition file used to pass ADO recordset to cryatal report 6.
|
|
|
|
|
Hi
I want to use INPUT, GET etc functions of BASIC to be implemented in VB6 to get the input and PRINT the output but all without using any interfaces like form,inputbox,msgbox ....... i.e. im tryiong tom write a console application in VB6
Is there any way to do that
bye
pitchu
|
|
|
|
|
VB6 doesn't have any built in methods to make a console application. You have to call into the Win32 API to create and manage a console window, along with outputting any text to it and getting input from it.
A simple Google for "vb6 console application" reveals these[^]...
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
i have a serious problem with my loop. My loop can only read the 1st data in my database even though there is 2 data inside. I think the problem should lays on my loop. Can u guys take a look at my loop and try to help me troubleshoot. Thanks a lot cos tis is urgent i got to pass up my proj soon.
While TReader.Read And TReader2.Read And TReader3.Read And TReader4.Read
strActionName = dTable.Rows(0)("ActionName")
strStatus = dTable2.Rows(0)("Status")
strFrequency = dTable3.Rows(0)("Frequency")
strActionDone = dTable4.Rows(0)("ActionDone")
strOneLine = ("ActionName = " + strActionName + "," + " Task = " + strActionDone + "," + " Frequency = " + strFrequency + "," + " Current Status = " + strStatus + "")
MessageBox.Show(strOneLine)
End While
|
|
|
|
|
This is a disaster - why do you have four readers ?
Christian Graus - C++ MVP
|
|
|
|
|
i use 4 reader because i need to read 4 rows from the same table and i dun know any other shorter way out. Any suggestion in how i should do it?
|
|
|
|
|
Wow.
Take a step back and do some reading. If they are all in the same table, then you only need one reader, each row will contain all the values you need, assuming you select them.
Christian Graus - C++ MVP
|
|
|
|