All radiobuttonlists and checkboxlist popluate from the database.comapring product productgroup and productvalue.after customer seleted items from these radiobutton list and checkboxlists iwant to create it as record to sttore in diffrent table with the all selected item + total price.so that in future we just serch record and we get it with and induval price and total price and seleted item.also its show image on selted items too.I dont know how to do it , I have MS ACESS database.I am using C# asp.net.I am working on it since last week.I dont know how i start it. I want to show image when it retrive the record which is customer seleted.
I want to create a temp table to store data in a stored procedure and then then retrive it from the code. I need to save the data in the begining before it is deleted.And then after the inserts are done I want to update the tblcontactlist by referring to the temp table.
I have a bunch of radiobuttonlists and one checkboxlist that when selected they are supposed to get added to a price total. All of the radiobuttonlists work correctly in adding to the price but the checkboxlist doesn't get added when one is selected. Here is the code I am using:
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load NewPrice.Text = Format(473, "currency") Dim Proc, Ram, Hd, Cd, Window, Mon As Integer Dim li As ListItem Dim sumList As Integer = 0 If processor.SelectedItem Is Nothing Then NewPrice.Text = Format(473 + Proc + Ram + Hd + Cd + Window + Mon + sumList, "currency") If processor.SelectedItem Is Nothing Then Exit Sub Proc = processor.SelectedItem.Value If Memory.SelectedItem Is Nothing Then NewPrice.Text = Format(473 + Proc + Ram + Hd + Cd + Window + Mon + sumList, "currency") If Memory.SelectedItem Is Nothing Then Exit Sub Ram = Memory.SelectedItem.Value If HardDrive.SelectedItem Is Nothing Then NewPrice.Text = Format(473 + Proc + Ram + Hd + Cd + Window + Mon + sumList, "currency") If HardDrive.SelectedItem Is Nothing Then Exit Sub Hd = HardDrive.SelectedItem.Value If CdDrive.SelectedItem Is Nothing Then NewPrice.Text = Format(473 + Proc + Ram + Hd + Cd + Window + Mon + sumList, "currency") If CdDrive.SelectedItem Is Nothing Then Exit Sub Cd = CdDrive.SelectedItem.Value If os.SelectedItem Is Nothing Then NewPrice.Text = Format(473 + Proc + Ram + Hd + Cd + Window + Mon + sumList, "currency") If os.SelectedItem Is Nothing Then Exit Sub Window = os.SelectedItem.Value If Monitor.SelectedItem Is Nothing Then NewPrice.Text = Format(473 + Proc + Ram + Hd + Cd + Window + Mon + sumList, "currency") If Monitor.SelectedItem Is Nothing Then Exit Sub Mon = Monitor.SelectedItem.Value If Storage.SelectedIndex <> -1 Then For Each li In Storage.Items If li.Selected Then sumList += li.Value End If Next End If NewPrice.Text = Format(473 + Proc + Ram + Hd + Cd + Window + Mon + sumList, "currency") End Sub
I have a gridView that shows the transaction_line table including "tL_id, t_id, date, pro_id, quantity, price, total price = quantity*price. How can I get a total transaction_line price for this gridView for each transaction_line id ??
I'm building an application, my client wants me to create new control using AJAX. This control should look like thisThis control includes price(dolars and cents) and when user clicks on specific price(suppose 95 dolars and 33 cents) this price should jump inside to textboxs(one for dolars and one for cents)Does anybody have a clue how to implement this control creation??
<asp:SqlDataSource ID="totalcount" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>" SelectCommand="SELECT COUNT ([CID]) FROM [WWAMembers] WHERE([CID] IS NOT NULL)"></asp:SqlDataSource>
how do I get the totals displayed with label or other control?
I tried with no succcess doing a search here on the forum for some answers or pointers. So here goes.
I would like to Calculate total time from a records in a table.
the Table we'll call it "Time Table" may have four rows IE.
Field1 Field2 IN 08:00:00 OUT 12:30:00 IN 13:00:00 OUT 17:00:00
I am trying to display these records in a Child gridview with a total. Is there any SQL that can total time like this? or any other way I can total this?
I have data grid with page size 15. I need to find total number of record(s) in a grid. How to do it?There is two ways to do:
1) Here I have used LINQ. So calling stored procedure again and we can done using .Count () property. But here I don't want make call to data base again.2) Creating our own logic like here I have done like:
var debtProtectionId = 0 // get the selected id of debt protection dropdown if (mainPanel.generalPanel.calculationsFieldSet.debtProtection.getValue() != '') { debtProtectionId = mainPanel.generalPanel.calculationsFieldSet.debtProtection.getValue(); } // get the store record with this id var storeRecord = planCombinationsStore.getAt(debtProtectionId)
When I run the code it says 'storeRecord is undefined'.
I have one SqlDataSource control as DataSet with enable caching in one page aspx. Filtering is applied to this SqlDataSource control, so that the page always returns one record data.
My question: How to get the record data value from SqlDataSource control (one record data value) and store it as String variable?
In my online web-application User is inserting new records and when user enters record system gets current datetime (using below query) and insert into table.
My insert is adding a record to the database in the call to the stored procedure in SQL Server, but a -1 is returned - Shouldn't it return 0 if the insert/update was successful?
