Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. ludmann

    calculations on a group by

    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...
  2. ludmann

    different columns

    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...
  3. ludmann

    different columns

    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...
  4. ludmann

    Select into?

    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...
  5. ludmann

    query help (MAX)

    Thank you, both
  6. ludmann

    query help (MAX)

    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...
  7. ludmann

    editable datagrid

    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>...
  8. ludmann

    popup window

    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...
  9. ludmann

    popup window

    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...
  10. ludmann

    popup window

    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...
  11. ludmann

    relationship between dataset tables

    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...
  12. ludmann

    ArrayList in C#, ASP.NET

    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...
  13. ludmann

    ArrayList in C#, ASP.NET

    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"))...
  14. ludmann

    DateTime asp.net

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

    DateTime asp.net

    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?
  16. ludmann

    DateTime asp.net

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

    binding dropdown within datagrid

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

    binding dropdown within datagrid

    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.
  19. ludmann

    binding dropdown within datagrid

    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...
  20. ludmann

    navigate with button

    Thank you

Part and Inventory Search

Back
Top