|
OK, now you've changed your post.
What part of my answer makes me so mean??
After-Darkness wrote: I SUCK OK iam SORRY IF U DONT LIKE .with my all respect Dave Kreskowiak YOU ARE SO MEAN
|
|
|
|
|
Probably because you didn't write all the code for him 
Bob
Ashfield Consultants Ltd
Proud to be a 2009 Code Project MVP
|
|
|
|
|
i have a table with th schema
productid int
productname varchar
productattribute xml
where the productattribute is supply by user through form say (<size>12<maker>seagate)
how can i deserialize this on the fly so i can say
product.productattribute.size =12
|
|
|
|
|
Ebube wrote: how can i deserialize this on the fly so i can say
product.productattribute.size =12
This doesn't make sense to me. Are you asking how you can set the value of a property that doesn't exist at design time?? You can't, since, obviously, the size property doesn't exist. It must be defined in the class before you can use it.
You can do something more like this:
product.productattribute("size") = 12
IF this is what you're really trying to do...
|
|
|
|
|
thanks Dave Kreskowiak
actually am looking for a way to break up this attribute so that i can have a report that look like
ram
size 256 maker seagate
price 50
note that this value exit in database but size and maker are nodes in the (xml productattribute column)
|
|
|
|
|
You're going to have to explain this from the start. What you're saying doesn't make any sense at all.
Report?? What report?? Where is the data stored and how? What's with the syntx you want?? how do the two relate to each other??
|
|
|
|
|
thanks a lot dave. i hv read it he say "Let's say our Products table might have ProductID, ProductName, ProductCategory and ProductAttributesXML.
We would then use ProductCategory to decide what type of class we store in ProductAttributesXML. So for ProductCategory='Digital Cameras" we could define a class DigitalCameraAttributes with fields such as Pixels, MaximumZoom, StorageType, and a special user control to show these details. Likewise, a class called HardDiskAttributes for the Hard Disks category."
now i want to allow user to specifies this fields from form cos i do not know at design time the product fields. so how can i define the class base on their input.
i hope it make sense.
|
|
|
|
|
Yikes. The only way this would be possible is if you generated code, compiled it and emitted an assembly for it at runtime. This is a VERY ADVANCED level topic and not something I've done, so I don't have any examples. For something like this, normally I'd use something like a "property bag" setup, where basic definitions for various fields common to all class types are defined in a custom collection. That collection would also use a seperately defined "property bag" kind of setup where you're storing key/value type/value information in a seperate collection. You'd also need custom serializer/deserializers to store/parse the data in/from XML files.
If you really want the custom generated class route, Google for ".net dynamic class creation".
|
|
|
|
|
thanks Dave am already storing key/value type/value information in the xml column in the database. i dont no much about custom serializer/deserializers. but the fact is that i only need to break this during report. i dont know if crytal report hav this ability to pull key/value type/value information from sql server
|
|
|
|
|
Your question still isn't very clear. Are you saying that productattribute is stored as XML, so for example:
<productattribute>
<maker>Seagate</maker>
<size>256</size>
<price>50</price>
</productattribute>
and you want to know how to break that XML up to get the sub-nodes for reporting.
Is that the question?
|
|
|
|
|
|
|
thanks a lot. i hv read it he say "Let's say our Products table might have ProductID, ProductName, ProductCategory and ProductAttributesXML.
We would then use ProductCategory to decide what type of class we store in ProductAttributesXML. So for ProductCategory='Digital Cameras" we could define a class DigitalCameraAttributes with fields such as Pixels, MaximumZoom, StorageType, and a special user control to show these details. Likewise, a class called HardDiskAttributes for the Hard Disks category."
now i want to allow user to specifies this fields from form. so how can i define the class base on their input
thanks
|
|
|
|
|
After I setup Component DevExpress for Visual Studio 2008, I can't run my project on other computer.Please help me to solve thisproblem!!!!!
Please guide me create setup file for my project that I can setup and run application on other computer that don't need to install DevExpress Component on that computer.Thanks alot!!!!
|
|
|
|
|
|
This clue is helpfull for me.Thank you very much!!!!!!
|
|
|
|
|
Hello,
I am programming in VB2005
I have a DataColumn with numbers and '<' sign as following:
-10
-5
<-90
<-50
+2
How can I sort this column?
Should I add another hided column and sort it?
Is there another way to do this?
Shay Noy
|
|
|
|
|
I suppose the column is of type string (nvarchar/nchar/varchar/etc).
How do you want this column to be sorted? In other words, what should the order be in the example you posted?
My advice is free, and you may get what you paid for.
|
|
|
|
|
Like this:
<-90 'Smaller than -90
<-50 'Smaller than -50 and that mean that it is bigger that <-90
-10
-5
+2
Shay Noy
|
|
|
|
|
You said that you are allowed to add a new column, so I assume that you are free to adapt the table structure.
If I were you, I would separate the < and > type characters from this column into its own column. Then transform the original column to type int, and simply adapt any queries or code to take both columns into account instead of only the one.
This means that you may have to adapt the query that got the data into this column to begin with, so that it separates the two value types (integers and < / >).
My advice is free, and you may get what you paid for.
|
|
|
|
|
|
Hi friends,
how to avoid flickering of tooltip? This application was done using vs-2003 and is working fine.But after converting it to vs-2008,flickering problem has arised .Please guide me in sorting out this issue.
Thanks,
Prasad
|
|
|
|
|
When you say flickering do you mean it is blinking? (toggling visibility at a fixed interval)...?
|
|
|
|
|
|
I installed a windows service in VB, and the service work fine.
But my service sometimes stop automatically when i don't use it for a long time (about 12hours).
Who can tell me reason?
Thanks.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
