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

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

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

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

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

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

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

A simple question. In asp.net I want to navigate to a page with a button (OnClick) the same way I would navigate to a page with a hyperlink. How do I do this? Marika

I am displaying a datagrid, whereby rows added by the user are displayed. The problem is I am starting from an empty datagrid, and to start off with only want to display the header and the footer. It seems like asp.net does not display the datagrid, if it has no items. Any way around this...

I am using a datagrid where the first column consists of check boxes and the second column is bound to a database table. <asp:datagrid> <Columns> <asp:TemplateColumn> <ItemTemplate> <asp:CheckBox id="chkSelect" runat="server" ></asp:CheckBox> </ItemTemplate>...

Can someone tell me how to compare two datarows, without having to go through each field in the row? I want to see if they are different, and if yes do some other stuff. I also need to use Trim() and ToLower() Marika

I am selecting data rows from a datatable. I want to print each attributes of the row, with the code below. It works fine. for(int i=0; i < selected_row.ItemArray.Length; i++) { if(selected_row[i].ToString().Trim() == "") { } else { str = str +...

Can someone please tell me how to bind the listBox to a textbox? In my code below, I have a listBox1, which is bound to a data table and displays a list of last names. I bound the selected value to email address, just because this is the primary key in the table. Below the listbox, I have a...

I have a dataset/datatable and trying to get it to get the rows of the table to display in a ListBox. My code so far String disp = dt_shared.Columns["FirstName"].ToString() + " " + dt_shared.Columns["LastName"].ToString(); listBox1.DataSource = dt_shared; listBox1.DisplayMember = disp...

I need to create something like a listbox, to list rows of a datatable. (in C# VS) It needs to list contacts and attributes of that contract that are to be updated. Like this: Joe Smith – jsmith@coco.com AddressStreet: Cranfield Gdns. Website: www.sthing.com Etc. Barbara...

I have two DataTables I have matched up the corresponding rows based on a primary key The next step is that I need to compare each of the two matched rows to see if there is any difference in any of the fields Is the only way to do this is to compare every single field? Thank you

I need to convert from DataSet to XML and back. I use the WriteXML() in C#. When a field(s) in a dataset is empty, there will be no equivalent xml tag in the xml file. I am not sure what happens when it is converted back? For example I might get: <books> <book> <title>J2ME</title>...