|
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
|
|
|
|
|
Hi CKnig,
Can you advice me how should i write the code if i want to save the data from datagrid to database?
eg: Let's say i had 'Add' 10 rows. I want to add these 10 rows into database. How should i do?
I have been searching for codes. But the result not what i want.
Can you pls help. Thanks in advanced.
Here is my codes that stuck half way:-
Dim strQuery1 As String
strQuery1 = "Insert into MMBarCode (HBarCode,EMIBarCode) values('" & DataTable.Rows(HBarCode) & "','" & DataTable.Rows(EMIBarCode) & "')"
myConnection.Open()
myCommand = New SqlCommand(strQuery1, myConnection)
Try
ra = myCommand.ExecuteNonQuery()
myConnection.Close()
Me.Close()
Catch ex As Exception
myConnection.Close()
MessageBox.Show(ex.Message)
End Try
Thanks, eunice
|
|
|
|
|
This is a SQL statement that is witten in Access for parameter search with wildcard
...
WHERE (((SLUŽBA.Priimek) Like "*" & [Search text] & "*"));
why doesn't it work in a Visual Basic Querry? I write the same expression in Function field and it doesn't work. Any suggestions?
Thanks.
|
|
|
|
|
In SQL - sytax this becomse something like
WHERE (SLUŽBA.Priimek LIKE %[Search text]%)
(% <=> * and no &)
|
|
|
|
|
Well, hard to understand what you mean by a 'Visual Basic Querry', but if you're building a string, you need to deal with how to represnt quotes for a start.
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
hi guys
i am running dotnet 2 exe file from network but it doest not run on my system , it says something
security like exception, but if i make my intrantet setting from dotnet framework2 configuration to gullytrusted it runs fine, but in this way i will have to make this setting on individual system, how to i do avoid from this issue,is there any that dotnet bypass the security or we can run our exe on tuntime in the fully trusted zone, thanks in advance
hello
|
|
|
|
|
First: there is no workaround IN code (that's what CAS is for)
As you said yourself: you either have to put the folder in the trusted zone / put the assembly in there or get some company policies for this task. However you will need to set these settings on ever client.
Of course if you copy the exe to local disks - say with a batch file before starting ...
|
|
|
|
|
Hi, I just want to know if it would be advised to put the following at the end of this code:
Set objFSO = CreateObject("Scripting.FileSystemObject")<br />
Set objOutFile = objFSO.OpenTextFile("\\jhbtest01\e$\SARS\Script\FileWithFilePath\FileNameFormA.txt", 2, True)<br />
strLine = FileName<br />
objOutFile.WriteLine strLine
Should i add this at the end:
objOutFile.Close AND is this the right way of doing the close section??? (it is working without it but i get error... so it works the first time round but fails second time round... without me seeing the error.)...
Oh yeah... this bit of code is in a javascript file that i call through VB.Net using the Shell()
"Many of life's failures are people who did not realize how close they were to success when they gave up." Thomas A. Edison
|
|
|
|