|
I would like to display the CategoryName from Categories table in ComboBox.
Based on the selection from the ComboBox display corresponding SubCategory from the SubCategories table
(here Category id can be duplicate) in the Listbox.
Thanks
Sathi
|
|
|
|
|
Ok, but can you stop telling me what you want to do and explain why you can't do it? In other words, what is the problem that you need help with? Which is what I have asked you like 3 times now.
|
|
|
|
|
Sorry for the trouble.
Please help me with the code to get the job done as written in prevous message.
I would like to get the categoryId of the selected categoryName of combobox from the Categories table so as to compare and display the subcategory in the listbox
Thanks
Sathi
|
|
|
|
|
Oh, you don't want to program yourself, you just want someone to create code for you?
Do you also need someone to polish your shoes?
|
|
|
|
|
Wow.....what a nice answer......
just because i am not smarter than you....
Thanks
Sathi
|
|
|
|
|
AKSSMV wrote: just because i am not smarter than you....
Smarter? Really? That's your excuse? WOW
AKSSMV wrote: what a nice answer
In four attempts you still have not provided even the smallest amount of information about the programming problem you are having. How long did you think it would be until you irritated someone?
|
|
|
|
|
Thanks a lot
Sorry for all the trouble...............
Thanks
Sathi
|
|
|
|
|
Hi,
Your problem is that on the subcategory you need one more field
you need
Categories
ID
Category
SubCategories
ID
Category
SubCategory
You should use the ER Model always that it is possible and that requires a unique identifier per table... for me this is the easiest way to do it!!!
Your queries should be some like
For the Categories
SELECT * FROM Categories
For the subcategories
SELECT * FROM SubCategories WHERE Category = 'YOUR CATEGORY ID'
This way you retrive all the sub categories for that specific Category...
with no offense but Sometimes i dont understand what kind of work is this people doing to so this basic questions! i believe that you should buy a book and understant the whole concept about databases before trying to do this kind of job
|
|
|
|
|
hi,
How to automatically click Ok button in MessageBox?
After the message show.
Without click OK button by user. Will OK button fire automatically?
Ex:
MessageBox.Show( "Welcome", MessageBoxButtons.OK );
Thanks,
Raja
|
|
|
|
|
Hi,
MessageBox does not have a time-out. You can solve this in many ways:
1.
launch a timer, when it expires, find the window handle, then either send a close message, or locate the OK button and send a click message.
2.
much easier: create your own messagebox class, and provide a built-in time-out with a timer that simply closes this form.
modified on Thursday, May 7, 2009 10:32 AM
|
|
|
|
|
I second number 2, this is your best option.
|
|
|
|
|
hi iam using vs 2005 c# window application
iam using a viewlist to show data about some product for a project iam doing
however only part of the data needs to be shown e.g(name,id) hidden(gender,weight)
originally i was using a static array to store the hidden data.
now iam wondering if it is possible to let the view list store the hidden infomation and such
is this possible? or even recommanded? any recommandation?
please advice.
|
|
|
|
|
neodeaths wrote: is this possible?
Yes
neodeaths wrote: or even recommanded?
Depends, but under normal circumstances, no.
neodeaths wrote: any recommandation?
There are things called Principles and Best Practices in the field of software design that have been established through years of experience. Here are two that address your question.
Separation of Concerns[^]
Model-View-Controller Design Pattern[^]
|
|
|
|
|
I am assuming you are slightly dislectic (or English is not your first langauge) and you actually mean a ListView.
When loading the LV put the datarow/array item into the tag property, set the subitem column width to 0 to hide it and when you select the item you have the supporting data object available in the tag property. Caveat - this gets VERY slow when loading a large amount of data.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
hi all,
can anybody knows help me.while installation of any msi windows installer creates copy of that msi with newly generated msi file name in temporary location("%WINDOWS%\Installer\").so i want to know how windows installer will generate that new msi file name.
|
|
|
|
|
The generation of that filename is random and cannot be predicted. Why would you want to know?
|
|
|
|
|
Thank u for responding my question. i feel happy to share my doubt with u.actually i am working on msi. i am trying to deploy an application without the need of installing the application by windows installer in the target pc. so mostly i am trying to simulate windows installer services and functions for security purpose.Actually client dont have required permissions to install an application, that's why windows installer creates copy of msi package in the temporary location ( RootDrive:\Windows\Installer\") from where installer performs installation with full accessible services required for installation of application and also it uses that copied msi for installation, Repair and uninstallation. so i need to do research on copied msi with generated msi file name.
|
|
|
|
|
SoumyaSri wrote: i am trying to deploy an application without the need of installing the application by windows installer in the target pc. so mostly i am trying to simulate windows installer services and functions for security purpose.Actually client dont have required permissions to install an application
If the client doesn't have permissions to install the application, it's for a reason. You're also not going to get around this limitation by "simulating" your own installer. If you have to register COM-based components, the client is STILL not going to be able to install your app because the Registry keys you need to change will STILL be off-limits to the user installing the app. The same is true for files that you have to put in System32, and maybe even Program Files, depending on the users situation.
SoumyaSri wrote: that's why windows installer creates copy of msi package in the temporary location ( RootDrive:\Windows\Installer\") from where installer performs installation with full accessible services required for installation of application and also it uses that copied msi for installation, Repair and uninstallation. so i need to do research on copied msi with generated msi file name.
Wrong. It's not because of the clients permissions. The installer is cached (no matter who installs the app) so that Windows Installer caches the .MSI in a well-known location so that if a repair is needed the .MSI is available to do the repair without needing the original installation media.
You are NOT going to be able to circument security by "faking" a repair of an app by tricking Installer into thinking the app was already installed.
Besides, the Installer service that actually does the install, runs as LocalSystem, not the user...
|
|
|
|
|
That message was so good, it almost made my heart tickle. 
|
|
|
|
|
Hi Gents,
Is it possible to embed a datagridview control in windows forms to Webform. If it is yes then please give me an idea
Regards
Azeem
Ahamed Azeem
software Programmer
|
|
|
|
|
Ahamed Azeem wrote: Is it possible to embed a datagridview control in windows forms to Webform
No.
|
|
|
|
|
Hello all,
I whant to change the possition at which the child window of a Rebar Window, in this case a toolbar window, is placed once the control is created. (padd it to the right)
None of the members of REBARBANDINFO lets you specify an offset for it's child window.
I could trap WM_SIZE messages and then re-position it's child everytime the window is moved, but I dont like this method.
Is there any way to set the offset of a child window inside a reband control ? (whithout forcing size by means of constantly sending WM_SIZE messages)
Thanks in advance. 
|
|
|
|
|
Well, we're doing a Winform Word reporting project for a Career evaluation comany to automate their candidate reports. We need generate some chart, images base on the candidate's result.
We have following questions:
1.Regarding how to get those chart into word, we think of two options for now, first option is to draw those chart, images in Winform and then try to insert them as pictures into Word. Second option is to use Word's own charting,
that is use MS Graph library, and insert chart straightway into word and customize the chart into our desired shape.
However, either option seems not easy, for the first option, how do we get an image or chart file from Winform and then insert the file? For the second option, the chart is NO-Standard word chart or word shape, I don't think we can draw a chart or shape out of what WORD has offered.
So if anyone have any hints how we can work around these issues, please offer some advice.
2.Another hard part is how do we dynamically draw the chart base on candidate's evaluaiton result? Say a candidate get 8 out of 10 or 70 out of 100, those points need to be reflected on the charting. But in WORD how can we draw so accurately?
3.Even we find some ways to get the chart, image into word, the next question comes to how do we precisely, exactly insert the chart/image into the right position we want in the Word file? I have been thinking of bookmarks, but it seems there's no
way to dynamically generate bookmark.
We appreicate your time and your advice in advance!
|
|
|
|
|
Why do you want the info in word - the business requirement should be VERY strong, not just "I think I want it in Word". Office is a lousy reporting tool, you are subject to it being on the client machine and versioning on the client machine can be a nightmare in anything but a small shop.
I would recommend using SQL Server Reporting Services (SSRS) to do your reporting, there is an export to word/excel option from SSRS. It's not perfect but office is not perfect. If your client is at all picky they are probably not going to be happy with the solution.
Trying to use word/excel as a reporting platform is a disaster that has found a home.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Hi,thanks for the reply, but as I said, the client want the report in Word format and it's only a small Winform application with Access database. So using a SQL server reportin service is out of topic anyway. I have also realized that it's all about Office/Word automation in this case.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
