|
Hello every one
I am working on a application which was originally done in VB6 and then migrated to vb.net 2005 express…
A lot of changes had already undergone in the application and it is working fine, now we are undergoing lot of new additions..
We are using ADODB to connect to the database with a connection object and have a recordset to access data.
- Now the issue is that if the N/w connection breaks to the DB server the I wanted the application to retry (as in case of wireless, signals do drop and come back at times) after few moments.. But even when the network is back again the application still dose not connects to the DB server…
- I checked the connection object’s status and recordset also.. Both seem to be fine…
Can any one plz help me on this..
Regards
Nishkarsh
|
|
|
|
|
I am sorry I do not have a ready solution for you, but we experience the same problem with PDA's on our WLAN. We have found out that for us the problem is caused because the device does not receive a new IP address from the server, after the connection was dropped.
If your problem is related, you could try to make your device renew its IP configuration before you try to reconnect to the db.
Hope this is of help to you,
Johan
My advice is free, and you may get what you paid for.
|
|
|
|
|
Thanks for the input...
I am using static IP address on the client machines..So there is no issue to acquire new IP address..
Is there any way to refresh the connection and recordset objects??
modified on Thursday, December 20, 2007 12:29:26 AM
|
|
|
|
|
Hi!
i have many textboxes on a form in a vb .net 2005 application
these textboxes are databound.
Is there any way i can set the MaxLength property of these textboxes (which are bound to varchar fields in the database) to the size of the field in the database.
Or how do i access the field (i.e. DataColumn of the table) to which a textbox is bound.
Thank You
|
|
|
|
|
may be you should try textbox1.mexlength = 20 'Length
Good Luck
|
|
|
|
|
but, the problem remains. what length should i set as i don't know the lenght of the field in the database?
|
|
|
|
|
You can query the database for the length, assuming you are using SQL server. Not sure about other DBs.
|
|
|
|
|
for that issue u have to keep track of which field u are accessing
There is another way to do it but this will introduce a real big overload on the system and application will become slow...
What you can do is just before you set the size of textbox do a query and to get the field size(I am not sure how to do it... but for sure there will be a query for sure)... and then assign the max size of textbox
Good Luck
|
|
|
|
|
why do i need to query the database for the length of the field since my textboxes are databound (using drag & drop from the data sources window) and the properties of the the datatables show the mapped fields (i.e. varchar(6) to system.string with length 6). Is there any way I can access these properties of the datatables.
|
|
|
|
|
My existing VB6 programs make extensive use of random files read and written to using complex structures. For example...
Private Type RightsElement
ItemName As String * 10
ItemFolder As String * 32
End Type
Private Type OneUser
UserName As String * 20
Password As String * 20
AllRights (0 to 64) As RightsElement
End Type
I could then declare a variable such as
Dim ThisUsersRights As OneUser
and subsequently read or write to a random file using this variable.
I have tried in vain to make this work in VB.Net 2008. I NEED to be able to read my existing files. Can anyone offer any suggestions? Or perhaps point me in the right direction for getting an answer?
Many thanks.
Steve
|
|
|
|
|
Is there a specific problem you are having?
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
|
|
|
|
|
Hi, I am doing a project for my school and I have a scenario like this:
Say I am making a event planner website. This site itself do not sell anything but has to provide props, goodies for the event therefore it needs to link to a supplier website (which is created by myself too) and I am using their product data to put on my website.
I wish to do it using XML such as they can send me an agreed upon XML format.And my Event planner website will automatically accept the xml and use the data inside to be put on my website in my format.
Do you think it is feasible?
Then here is the problem which i hope somebody can answer me.
1.How do they send me an xml file which will be automatically processed by my system(no human intervention).How do my system know that someone is sending and prepare to accept it? Could you point to me whether is there any class to use?
2.If say the first time this supplier send me the xml file and my system happily accept it and show my website, then a few weeks later this supplier change the price of only one product. what are the ways to program the system to be able to make the system intelligent enough to just update the one products change. Is there any class again in the VB to create xml file?
Thanks a million
|
|
|
|
|
xavier1988 wrote: Do you think it is feasible?
Yes, we have a system that does this, but it has been written in PHP.
xavier1988 wrote: How do they send me an xml file
With ftp. You would need to look into automating ftp transfers. Usually this is done separately from the website program.
xavier1988 wrote: what are the ways to program the system to be able to make the system intelligent enough to just update the one products change.
This and more can best be accomplished by using a database (for example MySQL). It will allow you to design a system that will only update the necessary data. It is also the easiest way to transform the data from the xml file to content on a website.
My advice is free, and you may get what you paid for.
|
|
|
|
|
xavier1988 wrote: How do they send me an xml file which will be automatically processed by my system
There are several different ways to do this:- FTP the files and write a Windows Service that watches that directory. Each time a new file is added the service processes the file.
- Use a web-based file upload component and process the file as part of the upload handler.
- Use a web-based file upload component and save the file to a directory. Using the same type of service described in the FTP option, process the files offline.
There isn't anything already written to do this type of work since it is specific to each project. You will need to write it yourself.
xavier1988 wrote: what are the ways to program the system to be able to make the system intelligent enough to just update the one products change.
The best approach would be to use a database to store the information. When you process the XML file, store each product record in a database table; if the record already exists (same product id/code) then just update the field(s) that changed.
xavier1988 wrote: Is there any class again in the VB to create xml file?
Yes, XmlDocument will allow you to create an XML file.
|
|
|
|
|
I would very much appreciate it if anyone could help me in creating a parameterized query in Visual Basic .Net 2005. In VB.Net 2003 it can be created with the "?" wildcard but when I tried the same method in VB.Net 2005 it's not working.
|
|
|
|
|
can u plz post the exact syntax u are using now with calling statement...
|
|
|
|
|
I need to add a menu item in the MDI form which will display the list of all the open child forms. In VB 6.0 when we create menu, there was a option of setting this option whether this menu is a Window list or not. Could anybody tell how can I set a Menu item to Window list so that in runtime it automatically populates itself with the list of open child windows. I am new in VB.Net 2005. Please Help.
Thanks in Advance.
|
|
|
|
|
in the property's from the meunstrip there is a property:'MdiWindowListItem' choose the toolstripmenuitem where you want to display open forms (usauly called 'Windows' or something) and you'r done
If my help was helpfull let me know, if not let me know why.
The only way we learn is by making mistakes.
|
|
|
|
|
Thanks Dragon, It worked.
Thanks agian.
Sekhar 
|
|
|
|
|
Please send me vb.net code to check and uncheck nodes in treeview with multiple root nodes, subnodes
|
|
|
|
|
don't just ask for code
the right course of action is:
1 try to write it yourself
2 if 1 fails do a google search
3 if 2 fails ask here with you'r code from point 1 and specification where things go wrong
to help you on you'r way
loop thru the nodes in treeview
check the node
inside loop1 loop thru the nodes of that node
check the subnode
repeat loop2 for the subnodes
you will need to do this in a recursive methode
maybe this article could help (haven't looked at it for more than 1 min so can't be shure)
http://www.codeproject.com/KB/list/treelistview.aspx[^]
If my help was helpfull let me know, if not let me know why.
The only way we learn is by making mistakes.
|
|
|
|
|
It is rude to demand people just send you code for solving a problem. Try solving it yourself, then when stumped, ask for help.
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
|
|
|
|
|
deepakkp wrote: Please send me vb.net code to check and uncheck nodes in treeview with multiple root nodes, subnodes
Sure thing. Please tell me how much you can pay into my Paypal account. 
|
|
|
|
|
I want to put a Label or a Picture Box on a MDI Form, which can display some information or display a picture on the MDI form. If I put a label or picture box on the MDI form then, it gets displayed on the top of all child forms. How to display it on the background like the BackgroundImage property of the MDI form. Please Help...
Thanks in Advance.
Sekhar
|
|
|
|
|
You can't - that's what a MDI-form is for. In this case you can get around the issue by painting your own background image (with the image from the PictureBox / text from the Label) and displaying this.
Normaly if you want some information shown on the MDI - form you add a StatusBar or ToolBar
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
