|
You're welcome 
|
|
|
|
|
|
i am designing a database for inventory the field requirements vary a lot depending on the product nature? The fields for Digital Cameras (number of pixels, maximum zoom, type of storage) would be very different from say, Hard Disks (capacity, interface type, speed, form-factor).
i hav a tables with the shema
product
proid int
prodname varchar
proattribute xml
catid int
category
catid int
catname vachar
prodincatattribut (xsd)
how can i be to able to store the attribute for a category of product as prodincatattribut (.xsd) as define by user . and ties the proattribute(xml) to it. so that users can only put the values of this attribute
or any other better design approach will be appriciate
|
|
|
|
|
Think templates.
Each product category should get it's own attribute template. By assigning a category to a certain product, the product will also get that category's attribute template.
My advice is free, and you may get what you paid for.
|
|
|
|
|
what do you mean by attribute template
|
|
|
|
|
Ebube wrote: The fields for Digital Cameras (number of pixels, maximum zoom, type of storage) would be very different from say, Hard Disks (capacity, interface type, speed, form-factor)
Like you said, each product type (= category) has it's own attributes. So you create one xml template (xsd) per category. Then you have a choice, you can save the templates with unique names in a folder, and save the names to the Categories table, or you can try and save the entire file as a blob, or bits to the database (I would go with the first option).
Then when a new product is entered into the system, you create a new xml file based on the correct attribute template, based on the category the user chooses for the product.
My advice is free, and you may get what you paid for.
|
|
|
|
|
Hi everyone, I am doing a small chat program using vb.net forms and database instead of LAN as my academic project. I have a timer on the form which constantly checks the new messagee arrival in the database. Once someone send a message (which goes to the database), I notify the recipient and open the conversation window. It works ok for 1 to 1 chat but multiple chat session get mingled up with each other beside I am not happy with the logic as well. Is there anyone can guide me how to write a chat program which could manager multiple users/sessions.
Thanks
Nas
|
|
|
|
|
First, you don't need the database at all. What you're doing puts an ever increasing load on the database with rising number of clients since you're polling the database for new messages.
Next, all you have to do is add a conversation layer above your clients. If its the first client to hit the server, the servers creates a new conversation. The next client that hits the server can get the list of conversions to join, or create a new one.
Your chat app should be sockets based (TCP/IP) so that if one client posts a message, the server can immediately send that message to all other clients in the same conversation without having the clients polling for new messages.
|
|
|
|
|
Many thanks for your quick reply. Can you please advice me where to look for socket programming resources on the web. Thanks
|
|
|
|
|
Try here[^]
Steve Jowett
-------------------------
Real programmers don't comment their code. If it was hard to write, it should be hard to read.
|
|
|
|
|
|
Hi all...
-> i am using VS 2008 on vista 64 bit system..
-> i want to access MS Access 2007 database using oledb; but i am getting the following error...
"Microsoft.ACE.OLEDB.12.0 Provider is not registered on the local machine."
-> so how will i cope with this problem..?
J A Nasir K
|
|
|
|
|
|
I would think that your app is compiled as 64-bit. Since there are no 64-bit drivers for Access databases, you'll get this error.
Force the target to x86 and you'll limit the code to 32-bit, thus using the 32-bit drivers for Access that are installed.
|
|
|
|
|
I know this is something simple but it has been a while since i have written in Vb6 and now with vb.net I
was not sure if the same code would be accepted.
I am allowing a user to enter in a textbox numeric values
after he tabs to the next textbox I would like to format the numbers he/she entered to currency but without the "$"
so for example:
the first textbox the user would enter 12345, then he would tab to the next textbox
and the data he just entered would then we formatted to display as such: 1,234.50
Thanks for your time and help.
Again sorry that this is something a beginner should know but I just forgot.
|
|
|
|
|
PAguilar09 wrote: gain sorry that this is something a beginner should know but I just forgot.
Not at all, it's an intelligent question. The Format method on the string class lets you format a string, like string.Format( "{0:C}", textbox1.Text) wil, from memory, format a string as currency. The string.Format method is what you want to look up in general for help on how to format strings.
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
ok so I am not sure if I am doing this in the right text box event.
I was trying this code in the lostfocus event but nothing worked.
Private Sub txtInitial_LostFocus(ByVal sender As Object, ByVal e As System.EventArgs) Handles txtInitial.LostFocus
txtInitial.Text = String.Format("{0:C}", txtInitial.Text)
End Sub
but when i enter in lets say: 123423
and then tab to the next text box nothing changes, or should i say the data that was entered does not change to 1234.23
what am i doing wrong?
|
|
|
|
|
As far as I can see from google, that is right. Have you set a breakpoint and perhaps set an intermediate string to the value, so you can check what is and what is not working ?
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
Is the lostfocus event the right one where i should be putting in the code?
when i run the program i enter in 12345 and then hit tab so the text box would lose the focus
but it still wont format
Private Sub txtInitial_LostFocus(ByVal sender As Object, ByVal e As System.EventArgs) Handles txtInitial.LostFocus
txtInitial.Text = String.Format("{0:C}", txtInitial.Text)
End Sub
|
|
|
|
|
There is a FormatCurrency method that can be called to do the work for you.
It takes a number of parameters, which allow you to include things like leadin 0's, ()'s for negative numbers etc.
|
|
|
|
|
As mentioned, there is a FormatCurrency function, but if you do not what the currency symbol, the the FormatNumber may be a better option.
Also, I think I would use the Leave event of the TextBox, rather than the LostFocus event.
Steve Jowett
-------------------------
Real programmers don't comment their code. If it was hard to write, it should be hard to read.
|
|
|
|
|
Mr Kreskowiak,
You stupid person.
I retired a few years ago. I bought a laptop for fun and enjoyment - learning visial basic has become a very satisfying hobby. I have no grandchildren and my wife recently died. Inane and ignorant remarks is obviously your low standard. I have not conned anybody.
I have posted genuine questions in these pages because I enjoy learning VB
Get your facts right before posting pathetic and remarks.
Stephen Comfort
Thanks for your help and advice!
Steve
|
|
|
|
|
Not even remotely the right forum for this, but to respond:
We are flooded here constantly with people asking questions like yours. Questions that either have no real world use and are someone's homework ( which is why you got lots of people trying to help you work towards the solution, the assumption being that giving you the solution would be doing you a disservice, because it would stop you from actually learning, or learning how to learn, if you were a student in a course ), or, worse. that are the paid work of some third world outsourcer who can barely type and who has in effect taken paid work from the very people who they then ask to do the work for them. People like yourself, who are just learning for fun, are such a minority, that they are hard to spot. I know that Dave, like myself, puts a lot of time into helping on these forums, BUT I also know we both try to lead the horse towards water, without actually pushing them into it, that is, to encourage people to use google, to buy and read books, to give them a nudge in the right direction, but not to write outright solutions to simple problems. Neither of us does this to tease or upset, we do it so that people who really want to learn, get help, and people looking to get free course credits, do not succeed. Again, that's the majority of what we see around here.
I am sorry for your loss, however, it's not really relevant, it shouldn't change how you're treated in a public programming forum. I'm sure that understanding where you're coming from in your approach to computing will color how anyone who reads this treats your questions in future, I can only state again, you've walked into a world where people who don't want to learn, try to get us to do paid work for them, and it's against that backdrop that it was assumed that you were trying to get us to do your paid work or homework for you.
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
OK, since the gloves are off...
BluesEnd wrote: Get your facts right before posting pathetic and remarks.
Facts?? The only facts I had were the ones you posted in your orignal post, which wasn't much and didn't include your life story.
You sounded like every other idiot who comes here looking for us to do their work for them because they went to RentACoder and got some schmuck to pay them to do a project they're nowhere near qualified to write. After seeing that 20 times a day around here, it gets a little old. I'm sorry you got splashed by the artillery shell I lob at every one them.
|
|
|
|
|
Having a burst-out on the internet will get you nowhere.
History says you are likely to be ridiculed.
Sometimes it is just best to swallow or ignore another person's opinions.
In fact, why should you even care about the opinion of some one you dont know?
And the last tip. Never expect to win an argument on the internet
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
