|
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
|
|
|
|
|
Thanks CKing, How can I put some information that frequently changes ?
Sekhar
|
|
|
|
|
Just use a StatusBar - most users are used  to this kind of visual information.
|
|
|
|
|
Hi everyone ,
I'm using vb.net 2003 (window application).
I have 2 textbox and want to add these 2 text into datagrid. But when i click "Add" Button for the 1st time, no problem. But after i click the 2 times, it replaced with the 1st row. But what i want is to add them into 2nd or subsequent rows depending on how many times i click 'Add' button.The 1st row remain.
Here i attach with my codes. I hope someone can hint me where is my mistake.
Thanks in advanced.
Private Sub btnAdd_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnAdd3.Click
Dim Table1 As DataTable
Table1 = New DataTable("LotNumber")
Dim Row As DataRow
Try
Dim HBarCode As DataColumn = New DataColumn("HBarCode")
HBarCode.DataType = System.Type.GetType("System.String")
Table1.Columns.Add(HBarCode)
Dim EMIBarCode As DataColumn = New DataColumn("EMIBarCode")
EMIBarCode.DataType = System.Type.GetType("System.String")
Table1.Columns.Add(EMIBarCode)
Row = Table1.NewRow()
Row.Item("HBarCode") = Me.txtHBarCode.Text
Row.Item("EMIBarCode") = Me.txtEMIBarCode.Text
Table1.Rows.Add(Row)
Catch ex As Exception
MessageBox.Show(ex.Message)
End Try
Dim ds As New DataSet
ds = New DataSet
ds.Tables.Add(Table1)
dgResult.SetDataBinding(ds, "LotNumber")
End Sub
thanks, eunice
|
|
|
|
|
Ok - the problem is that you allways create a new DataTable whenever you click add.
Put the section with the creation of the datatable / dataset to Form_Load or some other initialiser (you only want to call this once or when you need a clean DataTable) (Set the DataTable to be a private member of your class for access)
So you should get:
<br />
<br />
private myTable as DataTable = nothing<br />
<br />
public Sub InitGrid()<br />
<br />
myTable = New DataTable("LotNumber")<br />
Dim HBarCode As DataColumn = New DataColumn("HBarCode")<br />
HBarCode.DataType = System.Type.GetType("System.String")<br />
myTable .Columns.Add(HBarCode)<br />
<br />
Dim EMIBarCode As DataColumn = New DataColumn("EMIBarCode")<br />
EMIBarCode.DataType = System.Type.GetType("System.String")<br />
myTable .Columns.Add(EMIBarCode)<br />
<br />
Dim ds As New DataSet<br />
ds = New DataSet<br />
ds.Tables.Add(myTable)<br />
dgResult.SetDataBinding(ds, "LotNumber")<br />
<br />
end sub<br />
<br />
and
<br />
Private Sub btnAdd_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnAdd3.Click<br />
<br />
if myTable is nothing then InitGrid()<br />
<br />
Dim Row As DataRow<br />
<br />
Try<br />
<br />
Row = myTable.NewRow()<br />
Row.Item("HBarCode") = Me.txtHBarCode.Text<br />
Row.Item("EMIBarCode") = Me.txtEMIBarCode.Text<br />
myTable.Rows.Add(Row)<br />
<br />
Catch ex As Exception<br />
MessageBox.Show(ex.Message)<br />
End Try<br />
<br />
dgResult.Update()<br />
End Sub <br />
<br />
|
|
|
|
|
Hi CKnig,
Thanks a lot. It works now.
Appreciate that.
cheers,
eunice
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
