|
Hi friends,
I have a homework, i worked for hours but I got stuck in a point. I can't go out of this point.
I am very glad if you can help me.
I make effort to get a query from from northwind database sample. I want max sales of employees according to product.
There are 9 employees(sales persons). There are 77 products type. Salespersons sell this products. I want ,which product was sold maximumly according to sales turnover. The result must be like below
salesperson product sales amount
salesperson1 product a x
salesperson2 product b y
. .
. . .
.
salesperson9 product h w.
I tryed below script, I can find max sales of each salespersons but I can't add productname column to this query.
select t.firstname,t.lastname,max(t.sales) as sales
from (select employees.Firstname,employees.lastname,products.productname,
sum("order details".unitprice*quantity*(1-discount)) as Sales from ((Employees inner join orders on employees.employeeID=orders.employeeID) inner join "order details" on orders.orderID="order details".orderID) inner join products on products.productID="order details".productID
group by employees.lastname,employees.firstname,products.productname
) as t
group by t.firstname,t.lastname
order by t.firstname
Good DAys
Regards
|
|
|
|
|
Are you still having trouble?
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
|
|
|
|
|
Yes, I still can't find solution.
|
|
|
|
|
Don't you need a products.productname in the group by?
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
|
|
|
|
|
I need product name of max sold products in result table.
|
|
|
|
|
I want to build a very dynamic program but the thing is i need your help. I am reading the entire xml file on application startup. I want to display my custom Label when user click on the Next button, if user click again i want to display the the custom circle and so on.
Firstly, I don't want to load all the controls when application startsup. I want to separate controls from their data that way i wouldn't be loading those controls which aren't being displayed currently.
Secondly, offcourse any change in the data value should reflect the controls means if X value changes on the dataside so the controls X position value on the screen should changes as well.
Lastly, a very intersting thing i want to implement is that lets say a custom lable control is displayed and changes its position onMouseMove on the stage it should update it's class raw data.
Thanks for ur help
xml
Label
Text Hello World Text
width 10 width
height 15 height
Label
Circle
width 12 width
height 13 cheight
circle
Triangle
width 15 cwidth
height 20 width
Triangle
xml
|
|
|
|
|
hi,
for(i=0;i<4;i++)<br />
{<br />
if(i==0){button.Color=Color.Red;}<br />
else if(i==1){button.Color=Color.Blue;}<br />
else if(i==2){button.Color=Color.Black;}}<br />
else if(i==3){button.Color=Color.Yellow;}}<br />
}
why button color is not change?i want change the button color according to the if-else conditions.
I AM WORKING ON "PLOTTER ROBOT"(FYP).
|
|
|
|
|
Each color change causes a message that will be send to the button so that it will change it's color. The messages are queued and are all executed when you return the control to the message pump (when you exit the method).
You can use the DoEvents method to make the message pump handle the messages, and a delay so that you have time to actually see the change:
foreach (Color c in new Color[] { Color.Red, Color.Blue, Color.Black, Color.Yellow}) {
button.Color = c;
DoEvents();
Thread.Sleep(500);
}
However, if you really want to do something like this, you should use a timer instead.
Experience is the sum of all the mistakes you have done.
|
|
|
|
|
That'll just make your button yellow every time. Get rid of the for statement.
|
|
|
|
|
I have a file of 400 products. I can't import a file into the destination database but instead I have to go through a web page and manually input all the products one at a time. I was hoping to speed this up by writing a program that would work similar to Google's browser auto-fill plugin so I could read from an exported file from our current database. Does anyone know how I can get a handle on the current browser window so that I can use the DOM and populate specific fields? Thanks.
|
|
|
|
|
You would need to use P/Invoke interop calls to some of the Win32 API calls. I'm not sure which ones off-hand.
There is a potentially easier way, which would be to make use of the HttWebRequest object and the HTML parser[^] found in this article.
You would need code similar to this:
HttpWebRequest webRequest = WebRequest.Create("http://www.codeproject.com") as HttpWebRequest;
string html = "";
if (webRequest != null)
{
HttpWebResponse response = webRequest.GetResponse() as HttpWebResponse;
if (response != null)
{
using (StreamReader reader = new StreamReader(response.GetResponseStream()))
{
html = reader.ReadToEnd();
}
}
}
if (html.Length > 0)
{
HtmlParser parser = new HtmlParser();
HtmlNodeCollection nodes = parser.Parse(html);
HtmlNodeCollection tables = nodes.FindByName("table");
HtmlNode table = tables[6];
} As you can see, you can access the HTML in a similar method as you would XML, or you can load it directly into an XmlDocument (once you have selected a single HtmlNode element by using the following:
XmlDocument xml = new XmlDocument();
xml.LoadXml(table.XHTML);
XmlNodeList tableRows = xml.SelectNodes("//tr");
Scott.
—In just two days, tomorrow will be yesterday.
—Hey, hey, hey. Don't be mean. We don't have to be mean because, remember, no matter where you go, there you are. - Buckaroo Banzai
[ Forum Guidelines] [ Articles] [ Blog]
|
|
|
|
|
Hi
Here is the scenario of exception handling for my applications:
I have a translator that translate exceptions to a meaningful message for user.
When an unhandled exception occurs there is an Application ThreadException handler that is supposed to catch and handle the exception(To translate it using the translator and show a message box to user)
When I compile my solution and run the exe file everything goes fine but when I'm in debug mode it doesn't work and if there's an unhandled exception the debugger stops and shows me the exception.
What should I do to use my Exception handling scenario even while I'm debugging?
Thanx
|
|
|
|
|
Hi,
I susggest you have a look at the menu Debug/Exceptions...
|
|
|
|
|
Hi guys. i have two Questions to make sure the serialization of objects does not alter the following concepts:
i may use windows application with either mdb or MS SQL database.
Is it possible to those database files such as micrsoft access or microsoft SQL to convert binary format, like BIN files extension?
OR with those database files above can be converted in to dll files?
thanks so much for helping..
so much of happy ending...
|
|
|
|
|
zafax4 wrote: i may use windows application with either mdb or MS SQL database.
Yes.
zafax4 wrote: Is it possible to [missing verb] those database files such as micrsoft access or microsoft SQL to convert binary format, like BIN files extension?
I don't understand the question.
zafax4 wrote: OR with those database files above can be converted in to dll files?
I don't see how converting a database to a DLL would be helpful in anyway. A DLL file is fairly static. It generally does not change. In fact, while the program is running it cannot change as the operating system locks the file. By contrast, database files tend to change all the time.
|
|
|
|
|
I don't think any of your questions actually impact object serialization in any way.
You can use a Windows application with any database technology you want. Typically the actual database files are in a proprietary format specific to the database engine (technology) and aren't human-readable. If you want to prevent someone from opening the database outside of your application (through a database management tool) then you need to use the database security mechanisms to password protect your database.
DLLs are not used for data like this. If you want to "embed" the database in to your application, you should look at Microsoft SQL Server Compact Edition[^]
—In just two days, tomorrow will be yesterday.
—Hey, hey, hey. Don't be mean. We don't have to be mean because, remember, no matter where you go, there you are. - Buckaroo Banzai
[ Forum Guidelines] [ Articles] [ Blog]
|
|
|
|
|
Thanks you so much scott its really helpful and im happy that u helped me.
i need to database to be embeded in the application as you said, but i dont want to do security externally by using password.
thanks lot!
so much of happy ending...
|
|
|
|
|
You're welcome. The best option would probably be SQL Server CE (Compact Edition). It has a very small runtime footprint (2 DLLs) and stores the entire databse in a single file. It is very compatible with the full-blown SQL Server and pretty easy to work with.
Scott.
—In just two days, tomorrow will be yesterday.
—Hey, hey, hey. Don't be mean. We don't have to be mean because, remember, no matter where you go, there you are. - Buckaroo Banzai
[ Forum Guidelines] [ Articles] [ Blog]
|
|
|
|
|
Thanks Scott lot!
Just now im in the website u given , i'll go through this more and found some helpful samples too!.
scott i really appreciate you being so helpful. thanks .
so much of happy ending...
|
|
|
|
|
I'm very new to C sharp, having come from a c++ and vb background.
Within VS2005, I have a script (MainForm.Designer.cs) that defines all the components in my project (mostly toolstripmenus, buttons, labels, comboboxes etc.), the events attached to them etc
However, every time I try to group the code into logical blocks (including using regions) and save it, when I re-open VS mixes it all up again. I've gone through the help and even tried MSDN, but haven't found a way around this.
Anyone got any ideas?
Thanks in Advance,
John.
|
|
|
|
|
Hi,
all .Designer.cs files are generated automatically by Visual Designer;
you are not supposed to modify them in any way other than through the Designer.
So you should put your own code in one or more separate files.
|
|
|
|
|
Thanks Luc,
Just so I understand correctly, are you suggesting that I put the code from the designer script into my own script and simply call the functions from the designer script?
Best,
John.
|
|
|
|
|
why would you do any of that?
Leave the Designer code as is, where it is; the .Designer.cs files are part of your
project, they will be included in all your builds.
And there is nothing to call except for InitializeComponent(), which should be called
as the first statement in your form's constructor (the wizzard will have put it there
for you too).
|
|
|
|
|
You'll notice that your MainForm.cs and MainForm.Designer.cs both have:
public partial class MainForm
within the same namespace.
The designer file is handled by the IDE and automatically updated everytime design changes are made (this can include project opening etc).
You shouldn't normally make any changes to the designer file yourself. Your own 'functions' and calls to them should be added in the MainForm.cs file, or alternatively create your own MainForm.Functions.cs and/or MainForm.FunctionCalls.cs file and start these files with the namespace required and the public partial class MainForm { .... }
|
|
|
|
|
jgrogan wrote: are you suggesting that I put the code from the designer script into my own script and simply call the functions from the designer script?
No, leave them as they are.
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
