|
Yep. This is a simple dictionary app, so in fact I am using it more like a lookuplistbox/lookupcombobox (dropdown style = simple) whereby a user instead of picking the desired value from the dropdown list finds whatever he types into the combo. A while ago I tried that in Delphi - worked OK, loaded in less than a sec.
|
|
|
|
|
You might want to look into the AutoCompleteMode[^] property then.
"WPF has many lovers. It's a veritable porn star!" - Josh Smith As Braveheart once said, "You can take our freedom but you'll never take our Hobnobs!" - Martin Hughes.
My blog | My articles | MoXAML PowerToys | Onyx
|
|
|
|
|
This may be a dumb question, so feel free to ignore this, but are you sure a combo box is what you really want here? How on earth are the users expected to use a combo box with 100,000 entries in it? Trying to find the entry you are look for in a drop-down with 100,000 entries is going to be really hard to use in the real world.
Could you possibly implement some sort of filter where the users could type in part of the data they are looking for, then use that to query the table and load up the matching results based on the search criteria entered. So, for example if it was a list of names and they typed "Smith" then it would only load names like Smith* into the list. If you search for "combo box autocomplete" or similar then you might find something that would help.
|
|
|
|
|
After importing the xml file to dataset , it contains 3 tables .its linked
How I can join these tables into one table.
|
|
|
|
|
why do you want to do that?
|
|
|
|
|
I have one xml file like the following.Inorder to save the student details to sql server database, first i imported to dataset then the dataset contain 3 tables HEADER,STUDENT,RESULT.I want save the details as student name,id,subject,mark .
please help
<MAIN
<Header>
<ID>94</ID>
<TransactionDate>20/03/2010 16:10</TransactionDate>
</Header>
<STUDENT>
<ID>1076523</ID>
<NAME/>
<PLACE>101</PLACE>
<RESULT>
<SUBJECT>MATHS</SUBJECT>
<MARK>465.9</MARK>
</RESULT>
<RESULT>
<SUBJECT>Secondary</SUBJECT>
<MARK>272.4</MARK>
</RESULT>
</STUDENT>
<STUDENT>
<ID>AP1076524</ID>
<NAME/>
<PLACE>117-09-D000004-00</PLACE>
<RESULT>
<SUBJECT>Principal</SUBJECT>
<MARK>592.0</MARK>
</RESULT>
</STUDENT>
</MAIN>
|
|
|
|
|
I repeat:
WHY do you want to do that?
Yes. I get it that you have three tables and you want to save it into sql table. But why not have three tables in sql as well? why do you want to combine tables to enter into sql?
Som
|
|
|
|
|
hI,really sorry, am new to xml programming .
Pls check my xml file format.if i want to save the data as
studentid,studentname,subject,mark
1 John Maths 92
1 John ENGLISH 42
2 MATH 90
2 ENGLISH 89
can you please explain how to read the xml and save the details in the table.
( i dont know how to access data from sub tables in the dataset)
<MAIN
<Header>
<ID>SAS</ID>
<TransactionDate>20/03/2010 16:10</TransactionDate>
</Header>
<STUDENT>
<ID>1</ID>
<NAME>jONH</<NAME>
<PLACE>KK</PLACE>
<RESULT>
<SUBJECT>MATHS</SUBJECT>
<MARK>92</MARK>
</RESULT>
<RESULT>
<SUBJECT>ENGLISH</SUBJECT>
<MARK>42</MARK>
</RESULT>
</STUDENT>
<STUDENT>
<ID>2</ID>
<NAME/>
<PLACE>J</PLACE>
<RESULT>
<SUBJECT>MATHS</SUBJECT>
<MARK>90</MARK>
<SUBJECT>ENGLISH</SUBJECT>
<MARK>85</MARK>
</RESULT>
</STUDENT>
</MAIN>
|
|
|
|
|
may be reading a book may help. its gonna be a long chapter to write here.
|
|
|
|
|
ok,can u please tell me how to loop trough the child tables in a dtaset.
dim r as datarow
for each r in ds.parent table..
like this how to read sub table of parent table in the dataset
|
|
|
|
|
foreach(DataTable table in ds.Tables)
foreach(DataRow row in table.Rows)
{
foreach(DataColumn column in table.Columns)
{
}
}
|
|
|
|
|
In the future please format any code snippets or xml like this, using the pre tags. What you have unreadable and will mostly get you ignored by those that can help the most.
I know the language. I've read a book. - _Madmatt
|
|
|
|
|
If the two datatables are in the same dataset, you can create datarelations
between them, and use the GetChildRows, GetParentRow methods to do something similar to joins.
I hope this helps.
Best,
Sanket Sirotiya
http://www.urchha.com/
|
|
|
|
|
Can u describe your question in more detail.
Like by giving example what exactly u want to do??
So, that we can help in better way.
Jinal Desai
|
|
|
|
|
Hi, thanks for ur support.The following is my xml.
I have two tables .videos and actors . I need the code to read and save the xml data as follows.
Videos table
titleID title director format
100 Gentleman Jonathan Lynn DVD
101 Her Alibi Bruce Beresford DVD
Actorstable
titleID Actor ActorID
100 Eddie Murphy M123
100 John J23
101 Eddie S623
xml file
<?xml version="1.0" encoding="utf-8"?>
<Videos>
<Video>
<ID>100</ID>
<Title>Gentleman</Title>
<Director>Jonathan Lynn</Director>
<Actors>
<Actor>Eddie Murphy</Actor>
<ActorID>M123</ActorID>
<Actor>John</Actor>
<ActorID>J23</ActorID>
</Actors>
<Format>DVD</Format>
</Video>
<Video>
<ID>101</ID>
<Title>Her Alibi</Title>
<Director>Bruce Beresford</Director>
<Actors>
<Actor>Eddie</Actor>
<ActorID>S623</ActorID>
</Actors>
<Format>DVD</Format>
</Video>
</Videos>
|
|
|
|
|
You can use datarelation in dataset,
relate your two tables that will reside in one
dataset.
And in that way you can manually access individual element from
datarelation and generate xml or you can use LINQ.
Hope this will help!
Jinal Desai - LIVE
|
|
|
|
|
Hi,
I have an xml file like the following. want to save the xml file either in one table or two tables. but i dont know how to link these two tables in the dataset.
Inorder to save the xml file into my database first import to dataset (dsSource.ReadXml(xmlfilename))and it comes in two tables in the dataset. how i can save this xml file into sql table.
xml file contains a main node student under that sub nodes are there
student -main node
name
id
place
Result-sub node
subject
mark
subject
mark
.....
result-sub node ending
student node end
Thanks in advance
|
|
|
|
|
Sorry - not quite sure whether you want to save the xml file itself into the table or parse it and then save the data into a table.
You can try out these links - here and here.
|
|
|
|
|
sorry, I want to save the data into my table. The dataset contains multiple tables I dont know how to link these tables.
|
|
|
|
|
My table structure is headerid,date,studid,studname,studsubject,studmark
i am working in vb.net.can you please help to save this to my table
<MAIN
<Header>
<ID>94</ID>
<TransactionDate>20/03/2010 16:10</TransactionDate>
</Header>
<STUDENT>
<ID>1076523</ID>
<NAME/>
<PLACE>101</PLACE>
<RESULT>
<SUBJECT>MATHS</SUBJECT>
<MARK>465.9</MARK>
</RESULT>
<RESULT>
<SUBJECT>Secondary</SUBJECT>
<MARK>272.4</MARK>
</RESULT>
</STUDENT>
<STUDENT>
<ID>AP1076524</ID>
<NAME/>
<PLACE>117-09-D000004-00</PLACE>
<RESULT>
<SUBJECT>Principal</SUBJECT>
<MARK>592.0</MARK>
</RESULT>
</STUDENT>
</MAIN>
|
|
|
|
|
I am a .net developer, and have worked on .net 2.0 or .net 3.5 for several years. I need to obtain the MCAD or MCPD for a new project. I will greatly appreciate if fellow members recommend some good books or practice-test materials so I can speed up the process.
Cheers,
-James
|
|
|
|
|
You "need" to obtain certification for the project?
MeasureUp are good practice exams. The Microsoft Press exam prep books are mostly worthless as far as I'm concerned.
I know the language. I've read a book. - _Madmatt
|
|
|
|
|
I am writing a dll class to take in health patient information. On the developer side, how do i initialize my structure variables?
'code in the dll
Public Class MyClass
Private someData as ArrayList = New ArrayList
Private Structure PatientData
Public myDate as Date
Public myDouble1 as Double
Public myDouble2 as Double
Public myDouble3 as Double
End Structure
Private Function AddData(ByVal visitdate As Date, ByVal bmi As Double, ByVal height As Double, ByVal weight As Double) As Integer
Dim visit As PatientData
visit.myDate = visitdate
visit.myDouble1 = bmi
visit.myDouble2 = height
visit.myDouble3 = weight
visitData.Add(visit)
End Function
end Class
'How do I populate these variables as the developer?
|
|
|
|
|
It seems like you're already doing it? What is the issue?
Also, please remember to format code you post using the pre tags, ie. code block
I know the language. I've read a book. - _Madmatt
|
|
|
|
|
As it's a structure, they will automatically be initialized to their default values.
DaveIf this helped, please vote & accept answer!
Binging is like googling, it just feels dirtier. (Pete O'Hanlon)
BTW, in software, hope and pray is not a viable strategy. (Luc Pattyn)
|
|
|
|