Search results for query: *

I can’t figure out. Any ideas someone. First I need to get the total supply, total returns, total missed sales for every value (GROUP BY O_Dim_Val) in a specific dimension (O_Dim_Id = ‘D03’) for a specific time period. So it would be like O_Dim_Id O_Dim_Val TotalSales TotalReturns...

Thanks, I run your code and its almost what I need. I realised that to compare I cannot display the Sale_Dt, rather I need to display Day(Sale_Dt) Now all I need to do is to display FebSale for day 1 and MarSale for day 1 next to each other FebSale for day2 and MArSale for day 2 next to each...

I don't know how to approach this problem. I have a query SELECT SUM(Sold_Sum) Sold, Sale_Dt FROM Sales WHERE Dimen = 'D1' AND SaleMonth = 2 GROUP BY Sale_Dt This query is fine, gives me the Total sales for February Now I need to get another column, to show the Total sales for March (I...

I have 3 tables Table 1: CurrentInstrumentset with columns ID, Status, Type Table 2: InstrumentsetType with columns ID, Type, AutoID Table 3: Auto with columns AutoID, AutoName I want to get all the CurrentInstrumentsets, but want to display the AutoName for each Like: SELECT CI.ID...

Thank you, both

Can someone please help me with this query. zoneID, flyingObjectID and DateAndTime make up a composite key for my table FlyingObjects I need to get the rows: for each zone all the flying objects associated with it (once), where the DateAndTime is MAX(DateAndTime) so far I got: SELECT zoneID...

I have a datagrid that is linked to an ArrayList custAddress. A typical column looks like this. I also have an add button in the FooterTemplate, and on OnItemCommand = "doInsert" a new item is added to the ArrayList custAddress, which is also reflected in the datagrid. <asp:TemplateColumn>...

The thing is what happens is when I press the submit button the asp.net page sends a message. this message is then read by another application and this is what updates the database. My datagrid is bound to the database table. However the update takes several steps, which is executed within...

Thanks, I am not sure why I want to display it in a separate window. When the form is submitted, the values update the database table. However there are some business rules which are also executed (not on the client side or serverside), which based on the values also update the same database...

In my application I submit some values through a form, which inserts these values into my database. I want to see the updated database 'almost' as soon as I have clicked submit, without the user having to click on anything. I might be wrong here, but I thought if I have a narrow window on the...

I am trying to create a parent/child relationship within two related tables customer and cust_addresses. The tables are linked via customer.o_id = cust_addresses.instance_id Here is the code to create the relationship between the tables within the dataset //Fill the dataset's first table with...

Thanks, I have since figured it out. I wanted to know how to get to the values of the ArrayList. The difficulty was that the elements of the ArrayList were Objects (Addresses) So I realised I need to cast the ArrayList Like ArrayList b; ((Address)b[1]).City; ((Address)b[1]).Postcode; and if it...

I wonder if anyone can help, although this is not specifically an ASP.NET question, but I am programming ASP.NET (c#) and had so many great answers on this forum. I have an ArrayList which has elements of type Address eg. ArrayList address; address.Add(new Address("Boston","N453"))...

I will try, but still missing the last two values, although if it is always :00 then it is no problem.

Almost, it now displays 2004-2004-01-20 01:00:00Z How can I get rid of Z and display 01:00:00:00 instead?

Can anyone tell me how to convert DateTime.Now to display in a format 2004-01-20 01:00:00:00 Marika

If you do have time later and could try it be great. Thanks for the help either way, Marika

I tried what you said, and it seem to except it, but I know get the error message: System.NullReferenceException: Object reference not set to an instance of an object. Would you know why this is? My table does exist and is not empty.

I have a datagrid. The datagrid has a footer, and one of the columns in this footer is a dropdown list. <asp:TemplateColumn> ... <FooterTemplate> <asp:DropDownList ID="add_attribute"Runat="Server"> </asp:DropDownList> </FooterTemplate> </asp:TemplateColumn> I am trying to bind...

Thank you