Visual Basic

xml file is here for the above question

28-May-07 12:59

You forgot to say VB6 this time. VB6 is a dead language, people will assume .NET unless you say otherwise.

Which bit can't you do ? Do you have the data from the table ? Do you know how to create a file ? If you broke this into it's three obvious parts and googled, I'm sure you'd find the help you need.

Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

reading xmlvalue

balakpn28-May-07 2:03

balakpn

28-May-07 2:03

hi i am trying to read the following xml file
<sessionrequest schemalocation="\WEB-INF\xml\schema\Application.xsd" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<requesttype>APPLICATION
<token>
<requestarguments>
<application>
<companyid>TT0010001
<requesttype>APPLICATION
<application>FUNDS.TRANSFER
<version>,BM
<function>I
<operation>PROCESS
<transactionid>NEW<compscreen>MAIN
<message>
<field>
<fieldname>TRANSACTION.TYPE
<value>AC

<field>
<fieldname>DEBIT.ACCT.NO
<value>0110000020000005

<field>
<fieldname>DEBIT.CURRENCY
<value>USD

<field>
<fieldname>DEBIT.AMOUNT
<value>78

using the following code

Dim readx As XmlReader = XmlReader.Create("C:\Documents and Settings\gurubala\Desktop\1-1.t24txn.xml")
While readx.Read
If readx.NodeType = XmlNodeType.Element Then
MsgBox(readx.Name.ToString & " : " & readx.ReadString)
End If
End While

the problem here is it reads the nodes and values but starts to skip firstnode <message><field> ... it leaves <fieldname> element and reads <value>
why this happens how to avoid this

thanks

with regards
Balagurunathan.B

balakpn28-May-07 2:10

balakpn

28-May-07 2:10

<SessionRequest schemaLocation="\WEB-INF\xml\schema\Application.xsd" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<requestType>APPLICATION</requestType>
<token></token>
<requestArguments>
<Application>
<companyId>TT0010001</companyId>
<requestType>APPLICATION</requestType>
<application>FUNDS.TRANSFER</application>
<version>,BM</version>
<Function>I</Function>
<Operation>PROCESS</Operation>
<transactionId>NEW</transactionId>
<compScreen>MAIN</compScreen>
<message>
<field>
<fieldName>TRANSACTION.TYPE</fieldName>
<value>AC</value>
</field>
<field>
<fieldName>DEBIT.ACCT.NO</fieldName>
<value>0110000020000005</value>
</field>
<field>
<fieldName>DEBIT.CURRENCY</fieldName>
<value>USD</value>
</field>
<field>
<fieldName>DEBIT.AMOUNT</fieldName>
<value>78</value>
</field>
<field>
<fieldName>DEBIT.VALUE.DATE</fieldName>
<value>20061005</value>
</field>
<field>
<fieldName>CREDIT.CURRENCY</fieldName>
<value>USD</value>
</field>
<field>
<fieldName>CREDIT.VALUE.DATE</fieldName>
<value>20061005</value>
</field>
<field>
<fieldName>CREDIT.ACCT.NO</fieldName>
<value>0110000020000017</value>
</field>
<field>
<fieldName>CHARGES.ACCT.NO</fieldName>
<value>0110000020000005</value>
</field>
</message>
</Application>
</requestArguments>
</SessionRequest>
the problem here is it reads the nodes and values but starts to skip <message>---> <field>`s firstnode ... it leaves <fieldname> element and only reads <value>
why this happens how to avoid this

with regards
Balagurunathan.B

Image to and from database

Dileep_Vickey28-May-07 1:15

Dileep_Vickey

28-May-07 1:15

Hi friends,
I am using VB6 at front end and SQL/SERVER 2005 on back end. Now i need to save pictures (in jpeg or bmp) in SQL database. And i have to display it on front end when it needs. I saved one image into database into a table field of type 'image'. It was saved. Is this the correct way to save picture in database?. Then how can I display this file in VB6.
by Dileeeeeeeeeeeeeeep.
D'Oh! | :doh:

Datagrid problem

Yogesh Kumar Chauhan28-May-07 1:00

Yogesh Kumar Chauhan

28-May-07 1:00

How I can Add Templates Column at Run Time in the .aspx Page in VB.NET

yogesh

Re: Datagrid problem

Christian Graus28-May-07 1:04

28-May-07 1:04

You can't, the aspx is processed before the code behind. Your best bet is probably a repeater, which means you have full control over what is rendered, and can better change it at runtime.

Random display of items

samerh28-May-07 0:36

samerh

28-May-07 0:36

Hi all
I have a game where i input winning items each with a number and picture. I enter only winning numbers in xml file so when any one plays the game, he/she only wins if winning number is entered. I dont have a ratio for winning items. What i want is to apply a random ratio for winning items.
Forexample out of 100% wins i want the wins to be as follows:
20% item1
30% item2
25% item3
25% item4

please note that in the game i can add as many items as i want.
Any ideas and thanks

Christian Graus28-May-07 0:45

28-May-07 0:45

Set up your percentage, then use a random number generator. In the example above, get a number between 1 and 100. 1-20 is item1, 21-50 is item2, 51-75 is item3, 76-100 is item4.

samerh28-May-07 1:44

samerh

28-May-07 1:44

Christian Iam still confused about setting up items. The case is that i dont have a fixed number of items to set up percentages, the items may vary from one time to another. If this is the case how it is this doable?

Lets suppose i fixed my winning item number to 4 items with percentages (40,30,20,10)and i used the random function
Dim RandomNumber1 As Integer
RandomNumber1 = RandomClass.Next(0, 40)
Dim RandomNumber2 As Integer
RandomNumber2 = RandomClass.Next(41, 70)
Dim RandomNumber3 As Integer
RandomNumber3 = RandomClass.Next(71, 90)
Dim RandomNumber4 As Integer
RandomNumber4 = RandomClass.Next(91, 100)

Then what?
Then only if i chosed a number between 91 & 100 i win an item4 and so on, which is not my case. I want a ratio of (40,30,20,10) of the four existing items and a ratio of (35,25,15,15,10) of my five items and so on.
Any ideas and thanks

Christian Graus28-May-07 11:07

28-May-07 11:07

If the list is random, how is the spread going to be set ? If it's not also random, then you can store a list of values to compare against, to get the same end result.

samerh wrote:
RandomNumber4 = RandomClass.Next(91, 100)

This is not what I said. Take ONE random number between 1 and 100, then work out which interval it fits into. That's how you get your percentage spread. This make not give you any hits at all.

CPallini28-May-07 1:47

CPallini

28-May-07 1:47

if you want to assign to each item a random percentage, dynamically, use the following:

(1) Assign to each item ratio a random number
(2) rescale the assigned ratios to sum up to 100 (i.e. normalize).

Smile | :)

If the Lord God Almighty had consulted me before embarking upon the Creation, I would have recommended something simpler.
-- Alfonso the Wise, 13th Century King of Castile.

Christian Graus28-May-07 11:07

28-May-07 11:07

Yeah, that's what I said.

progress bar

charchabil0328-May-07 0:05

28-May-07 0:05

Hello
Can you provide me a simple function of how to use Progress bar while pulling an unknown number of data from a database
thx

Regards
Ramy

Christian Graus28-May-07 0:10

28-May-07 0:10

Quite plainly, if you don't know how much data you are getting, there's no way you can show a real progress bar. You should also try to make your database call all in one go, not breaking it up into many calls if you can help it.

Your best bet is to set a progress bar to just show indeterminate progress ( the bar moves over and over ) and leave that showing while a thread does your DB call.

Xandip28-May-07 0:23

Xandip

28-May-07 0:23

ya tats right.. i had posted the same question days ago, and got the same answer from the members of this group. Any ways, try to loop the value of the progressbar with the number of recordsets you want to load. Place the function in a timer with an interval of say 1000 ms.

hope this works..

The name is Sandeep

charchabil0328-May-07 0:59

28-May-07 0:59

Kindly,Provide me a simple code for that Smile | :)

thank you

Regards
Ramy

Christian Graus28-May-07 1:03

28-May-07 1:03

What he has suggested is plain not going to work. Set your progress bar Style property to Marquee and do what I said, there is just no way you can show a progress bar for an unknown number of items.

charchabil0328-May-07 1:11

28-May-07 1:11

Thx for ur help
I really appreciate it. ( and i m not complaining)
all what i ask is a simple code please
thx

Regards
Ramy

Christian Graus28-May-07 1:24

28-May-07 1:24

If you set the progress bar style to marquee, it will display itself automatically. Just put one on your form, and then do your database call in a thread. When the thread ends, get rid of the progress bar. I'm sorry, but I don't write VB, and really, there's no code that I can show you, you need no code for the progress bar, and I don't know how your database call is written.

charchabil0328-May-07 1:35

28-May-07 1:35

thx for ur help Smile | :)

Regards
Ramy

Xandip28-May-07 2:45

Xandip

28-May-07 2:45

Christian Graus wrote:
I'm sorry, but I don't write VB

then start writing and THEN give your suggestions...

So whats the idea?? Changing the style of the progress bar? wats the matter if u get the count of the records that has to be processed..(as i said earlier)

Christian Graus wrote:
there's no code that I can show you

but i can show you..

With flxTest
.Clear
.Rows = 1
.Cols = 5

Call GetConnection 'Function
Set Gadors = New ADODB.Recordset
GNewQuery = "SELECT * FROM test"
Gadors.Open GNewQuery, Gadocn
Gadors.MoveFirst
Dim i As Long
pg.Min = 0 'setting values of progressbar
pg.Max = Gadors.RecordCount
MousePointer = vbHourglass
While Gadors.EOF = False
i = .Rows
.Rows = .Rows + 1
.TextMatrix(i, 0) = Gadors.Fields(0)
.TextMatrix(i, 1) = Gadors.Fields(1)
.TextMatrix(i, 2) = Gadors.Fields(2)
.TextMatrix(i, 3) = Gadors.Fields(3)
.TextMatrix(i, 4) = Gadors.Fields(4)
If pg.Value <> Gadors.RecordCount Then pg.Value = pg.Value + 1
Gadors.MoveNext
flxTest.Refresh
Wend
MousePointer = vbDefault
End With

try this one....

The name is Sandeep

Dave Kreskowiak28-May-07 6:16

Dave Kreskowiak

28-May-07 6:16

Your updating the progress bar AFTER the records have been returned, not during. Your only updaating the progress bar during the processing of each record.

For a long running stored procedure that returns a set of records, or for an unknown size of the set, this won't work at all.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007

Christian Graus28-May-07 11:00

28-May-07 11:00

Xandip wrote:
then start writing and THEN give your suggestions...

Most of the questions here are framework questions, which is why I can answer them. I *can* write VB, but I'd prefer not to.

Xandip wrote:
but i can show you..

Like Dave said, this won't work. What I explained, will.