1) I have a Requirment where i have to get the Refno with Quantity from master table and which is not available in any of three table.. for Ex: TableA,TableB,TableC and then one more if Refno is available then.. have to sum from three table which it has the refno.... up to i need to show when MasterItem Refno with Quantity is not equal.. once it become equal from three table will not show the refno...
View 3 RepliesI have 3 tables. Blog and Tag have a many to many relationship. BlogTag is a junction table with a quantity column.
**Blog**
BlogID
Title
**Tag**
TagID
Name
**BlogTag**
BlogID
TagID
Quantity
I'm not sure how I handle the quantity column. I'd like it to store how many Blogs have a certain Tag NameHow do I deal with the quantity column when adding a new blog that has tags?
is it possible to select only the item that are displayed in the list box. That is i am having a list of item starting from 0 to 100 in the list box. But i have reduced the height of the list box so that it displayed the item one by one. I need the displayed item to automatically selected.
View 1 RepliesI have a shooping cart in version 9.0.1.3
I have several products with two variants for each.
I can add any quanity to the first variant and it is calculated into the cart correctly.
When I try to add a number besides one for the second variant it will only show one of the porduct in the cart.
I can change the quanity when it is in the cart. But I need it to work correctly.
I'd like show a products list in one ListView. Each item is a product in the List<Productos>.
If a product quantity is 3, the list have 3 repeated items with the same product.
How can i do for display in the item of ListView the product description + quantity of this product?
This is my code:
[Code]....
String conn = System.Configuration.ConfigurationManager.ConnectionStrings["conString"].ConnectionString;
SqlConnection con = new SqlConnection(); // for connection
SqlDataAdapter adp = new SqlDataAdapter(); // for fetch the records acc. to condition
DataTable dt = new DataTable(); // fill the fetched records
DataTable tb; // will store the session
[Code] .....
How will I get the total number of quantity....
I am trying to have a gridview row update a label in that gridview with the results of a calculation.
Eg. qty ordered * Price = lineTotal
I have:
[code]....
How do I get the Label extPrice to display the quantity entered * the price?
I list selections of available items in a gridview and have added a button column for adding items to a cart. Is there a way to add a column where the user can enter the quantity to add?
View 1 Repliessee my jpg picture to identify problem easly
[URL]
when i change quantity up it s increasing 1 but sum doesnt increasing if i click twice its increasing but wrong where i am doing wrong
my code is
[Code]....
In my webpage i am trying to create a order by gridview here item selected by user from dropdown and on selction of dropdown price display in next to item dropdown label price.now user insert quantity from next grid textbox and next is label amount shold disply calculate amount on price and quantity.i also want to use javascript for this prob.what i did that item and price displaying and user make input from textbox now want to calculation but how textbox recieve input and amount label dispaly calculate amount.
[Code]....
I posted a question earlier about updating the quantity column in my table, I use the code found below however I think because the Select and Update is inside of a foreach loop it is updating all of the products.
Furthermore, the products are also updated when the page is reloaded and the amount is increased based on how many times the user clicks on the add button. E.g. Click the add button twice the quantity increments by two each time.
I ideally need to be able to use the ItemID outside of the foreach loop, but can't.
Code:
foreach (UserItem ItemID in (List<UserItem>)Session["UserSession"])
{
ConclusionPage.InsertCommand = "IF EXISTS (SELECT ItemID FROM tblUserItems WHERE UserID='@CurrentUser' AND ItemID='@ItemID') UPDATE tblUserItems SET Quantity = Quantity+1 WHERE (UserID = '@CurrentUser') AND (ItemID = '@ItemID')";
ConclusionPage.Insert();
}
Perhaps someone has done something like this before. I am generating a quantity summary report. The quantities have to be summarized in two ways:A quantity for a specified date range, which can fall anywhere within the project duration defined by the user provided UserStartDate and UserEndDate A Quantity to date, defined by the ProjectStartDate till the user defined UserEndDate So if I put all these dates in sequence it would look something like this: ProjectStartDate, UserStartDate, UserEndDate, ProjectEndDate Right now in the code the User specified dates are vStartDate and vEndDate. The source data (list of bid items) is compiled in a UNION query (SqlServer View) and I am querying from this view using a stored procedure from which the data is captured using the code below.
Public Shared Function GETeFieldQuantityData( _
ByVal vProjectNo As String, _
ByVal vStartDate As DateTime, _
ByVal vEndDate As DateTime) _
As IEnumerable
' Dim SqlConnection, SqlCommand, and SqlDataReader
Dim vSqlConn As SqlConnection = New SqlConnection(GetConnString)
Dim vSqlCmd As SqlCommand = New SqlCommand("eFieldReturnQuantitySummary", vSqlConn)
'Dim vDataRdr As SqlDataReader
vSqlConn.Open()
'Construct parameters
vSqlCmd.Parameters.AddWithValue("@StartDate", vStartDate)
vSqlCmd.Parameters.AddWithValue("@EndDate", vEndDate)
vSqlCmd.Parameters.AddWithValue("@ProjectNum", vProjectNo)
vSqlCmd.CommandType = CommandType.StoredProcedure
'Return SqlDataReader Object
Return vSqlCmd.ExecuteReader(CommandBehavior.CloseConnection)
End Function
And the SELECT statement returning data to the form:
Code:
SELECT BidItemDesc As [Bid Item Description], Unit,
SUM(Qty) AS [Tot Qty], COUNT(*) AS Records
FROM dbo.qryQuantityWorkSheet
WHERE ((ProjectNum = @ProjectNum)
AND (ProjDate >= @StartDate)
AND (ProjDate <= @EndDate) )
GROUP BY ProjectNum, BidItemDesc, Unit
ORDER BY BidItemDesc
In crystal report, for data showing at below:
QUANTITY----PAID_DAY
12------------2/2/2010
35------------
63------------5/15/2010
13------------
How to add code to sum of Quantity if there is a day in [PAID_DAY]?
The result showing on the report should be 12+63=75.
my code is calculate to current rowafter update quantity but other rows don't affect and not calculate i need to calculate all rows i think i need to use for loops but i dont know how to do it
[code]....
[Code]....
We have a demand system where customer can demand the quantity they want for a particular deal.
For each demand they submit, a new record is added to the DealDemandRequest table with the CustomerID, DealID, Quantity
I want to be able to to calculate the total quantity demanded by a particular customer. Current I query the DealDemandRequest table for all the records by a particular customer and then do a sum of the Quanity column.
However, we are expecting this table to be over 1 million record and it is reallly really slow right now.. Any better ways?
I have an ASP.NET gridview that list all data rows for Book store with column name: Book (BoundField), quantity (TemplateField) , price (templateField) and amount (amount = quantity * price). I would like to change either quantity or price that will update the amount automatically after leaving cell in the gridview but not save new values into database until I made all changes and display message: "Are you sure to change them in database?".
View 1 Repliesmy main intention is that, the exsisting table of sql server database(.dbo) with 1000's of records, that should be import to a new access database table(.mdb).for example if we want to had a new table in db2, of exsisting table in db1 with some conditions by using "select * into New_Tabel from (select * from Exsisting_Table where <Condition>) as objectName". Here the new table is created and records inserted in one execution in db2. The same work should be done for access(sqlserver db --> Access db).Here the new access database table with given name (as string_sysdate) must be created dynamically by clicking a button (multiples time creating new table).Is there any query or c# code for sql server database to access database.
View 2 Replieshow can i use html to create table(<table></table>) in code behind c#?
View 18 RepliesI am fairly new to ASP.Net and web programming in general and I am having issues trying to add values from a dropdown list in my gridview to another table.
Here is my scenario. I have 2 tables in my SQL Express DB. When editing the values of table2 in a gridview, I would like to show some data from table1 in a dropdown so users can select a value from table 1 and enter that value in table 2.
I have the Gridview setup to show table2 data.
I created a field template and inserted my dropdown list and linked it to my table1 data source.
When I run my web form, I can click to edit one of the fields in the gridview, and my dropdown list correctly displays the data from table 1, but when I try to update the table2 with the dropdown value, it doesn't correctly update. The row in table2 never updates.
posting the dropdown value from table 1 into the appropriate field in table2..
Again, I am new to this and have been following the tutorials etc on this site, but can't find one pertaining to this topic.
I am working on a web app for an online photo album. It is the last project in Scott Mitchell's book: "ASP.Net 2.0 in 24 hours".
I am creating a page where users can enter new photo images. The functionality for uploading an image will come later. I am working on just inserting a new row into the Pictures table with an optional category, a required title and a required description.
I am getting an error when I try to insert a new row.
Here is a screenshot of the page with a shot of the dropdown list.
The Categories are user-specific. I am getting the correct values retrieved.
[URL]
There are two pretty simple database tables involved here.
NOTE: The CategoryID and PIctureID are both autoincrement integer columns.
[URL]
The page uses a DetailsView that uses a SqlDataSource that uses the Pictures table. (The DetailsView's Default Mode property is set to "Insert". The "Enable Inserting" checkbox is also checked.)
The dropdown list uses a dropdown control that uses a SqlDataSource that uses the Categories table.
When the "Insert" button is clicked the CategoryID value associated with selected (Category) Name on the dropdown list will be used along with the Title and Description values to insert a row in to the Pictures table. (If no Category value is selected, then a null value will be used for the CategoryID. This is OK because the CategoryID column in the Pictures table allows nulls.)
My problem is that I am getting this error:
Cannot insert explicit value for identity column in table 'Pictures' when IDENTITY_INSERT is set to OFF.
(FYI: I have the full version of both Visual Studio and SQL Server.)
Here is my source code for the page:
[Code]....
Im creating a table dynamically in my codebehind to display some statistics. The table is in a usercontrol. When the page first loads, its created and displayed correctly. If I do something that generates a postback, the table subsequently disappears, this is because its created inside a !IsPostback. How can i ensure that the table, once its been generated, stays visble on the page ? I dont want to generate it each time the page loads as it involves a lot of calculations on the database which will slow the pageload down.
View 4 Replies I am experiencing is that when I try to populate a table on a online environment with the below code, the table is populated twice. With the same code the table is populated correctly on an offline/production environment and cannot understand why :
This is what I have:
The table is called Trips
Code Behind:
[Code]....
This is what I use in my .aspx page:
(removed for brevity...)
<script type="text/javascript">
since I am trying to find one googling but there is nothing apparently.
I am trying to generate a dynamic table andd add rows to a ASP.Net table control on my UI. My problem is as I add a new row from MyTable, in to another table the table I am copying from, will loose one row. Here is the code:
Table
myTable = new
Table
();
[Code]....
am just reading one row in every loop and add that row in to another table object, why is 'myTable' loosing loosing one row in each loop?
I have two possible header rows for a DataTable that I build dynamically. Setting the value of a cell works fine. Adding the cell to a TableRow works fine. The problem comes in where I have to build a second possible header row that uses the same cell.
An example is below.
trHead1 = New TableRow
trHead2 = New TableRow
tcCalc = New TableCell
tcCalc.Text = "Rates"
trHead1.Cells.Add(tcCalc)
trHead2.Cells.Add(tcCalc)
As soon as I make the second row add the cell, the cell disappears from the first row. This really doesn't make sense to me but that seems to be the way it is. If there is a work around other than duplicating the lines;
tcCalc = New TableCell
tcCalc.Text = "Rates"
I 'm curious to know how I could hide rows in my <table> in logical cases where, for instance, I have a list of radio buttons and depending on whether the user selects "Yes", the row below it appears for them to fill in some information.
View 9 Replies