ADO.NET :: Combining Data On INSERT?
Nov 23, 2010
I have a page with a SqlDataSource and a GridView which displays products (Title, Description, Price) pulled from a SQL table (let's call it Table1). I have added a TemplateField with a DropDownList so the buyer can choose how many they'd like. I've also added a ButtonField so the user can click to add the items to his/her shopping cart. All this works really well. The inserting is done in the Code Behind into Table2 (the code for this is provided below)
I then have a second page (ViewOrder) with a SqlDataSource and a GridView which simply displays the contents of Table2.
Here's the problem. If I add three Product 1's, ViewOrder displays a row with 3 product 1's. That's fine. But, if I then add a further 2 Product 1's, ViewOrder now displays TWO rows, one with 3 and one with 2 OF THE SAME PRODUCT.
Now, as it's the same product, I'd like ViewOrder to display ONE row with FIVE Product 1's.
Here's the code which does the Inserting into Table2:
[Code]....
myVal is the SelectedValue of the DropDownList and MealValue is a calculated value of the unit cost * myVal.
View 11 Replies
Similar Messages:
Jun 10, 2010
[Code]....
I want to insert a record into a log table ONLY if one exact copy already doesn't exist within ten days, what is a good way to do in one stored procedure what I do above in two?
View 3 Replies
Jun 29, 2010
I'm trying to combine a date and time from separate variables in my asp.net insert sql. pointers? I'm getting the following error
Conversion failed when converting date and/or time from character string.
[Code]....
View 2 Replies
Jun 6, 2010
I'm trying to combine two charts ( Column & Spline ) using MS Charts 3.5. When i run the page the second series of the Spline chart is not visble/working.
Here is the code
string connectionString2 = "server='myserver'; user id='testuser'; password= est'; database='DBs'";
System.Data.SqlClient.SqlConnection sqlConnection2 = new System.Data.SqlClient.SqlConnection(connectionString2);
string queryString2 = "SELECT TOP 10 NAME, VOLUME, CLOSE FROM Com WHERE NAME IN ('LEAD')";
[Code].....
View 2 Replies
Sep 30, 2010
I have two tables (Person and Location) In the Dynamic Data Site, when adding Location info, I am need to choose a person from the dropdown box which is populated via a FK. That dropdown box defaults to the field in "Person" that is titled "fname" which is first name, so it looks like "Jim" or "Steve".
I'm trying to have that dropdown box display the full name of the person it references which would be combining the fields fname and lname.
Would I do this inside a Field Template? Metadata? I'm kind of stuck on this.
If I look at the FieldTemplate for ForeignKey_Edit I see this:
[code]...
and it seems like I should be able to make something similar to "PopulateListControl" and use that instead, but I have no idea where this method even resides.
View 1 Replies
Feb 6, 2010
I have a Customer Table that has many fields - two of which are FirstName and LastName.
I have a TyapedDataSet that is is linked to the CustomerTable
I have BusinessLogic layer that looks at the Typed DataSet
On my page I have an objectdatasource back to the BusinessLogicLayer and a dropdownlist
Currently, the dropdownlist displays the LastName and has a value set to CustomerID.
I want the display to be LastName+', '+FirstName instead of LastName
My question is where do I create the field called FullName - Do I open the MS SQL table and add a field called FullName -- but I think if I do this then when I add data I have to duplicate FirstName and LastName info. Do I add a field (column) to the dataset?
View 7 Replies
Aug 12, 2010
I combined MVC and DD by creating a new DD project and adding the MVC stuff (references, routing, usings, etc). The list of tables on default.aspx (from DD) will show all tables, including the ones with [ScaffoldTable(false)]. The URL's of the tables with Scaffold==true have the expected form (DD/TableName/List.aspx). However, the URL's of the tables that should not be shown are in the form /Home/List?Table=TableName. If you leave out the MVC routing (Routes.MapRoute) then the tables with Scaffold(false) are not shown. Or you can leave out only the Parameter defaults.
My guess is that Dynamic Data determines if a table is visible by checking to see if a route can be made to for the List page. The DynamicDataRoute will not match because that will not generate a route if Scaffold==false. BUT THEN the MVC Route WILL match because of the Parameter defaults at the end. Am I correct and is this a bug or am I completely missing something here? EDIT: I fixed it by adding filtering the VisibleTables on Scaffold like this, but that's a workaround...
System.Collections.IList visibleTables =
MvcApplication.DefaultModel.VisibleTables.Where(o=>o.Scaffold==true).ToList();
My RegisterRoutes in global.asax.cs:
public static void RegisterRoutes(RouteCollection routes)
{
DefaultModel.RegisterContext(typeof(studiebase2Entities), new ContextConfiguration() { ScaffoldAllTables = false });
routes.IgnoreRoute("{resource}.axd/{*pathInfo}");
routes.Add(new DynamicDataRoute("DD/{table}/{action}.aspx")
{
Constraints = new RouteValueDictionary(new { action = "List|Details|Edit|Insert" }),
Model = DefaultModel
});
routes.MapRoute(
"Default", // Route name
"{controller}/{action}/{id}", // URL with parameters
new { controller = "Home", action = "Index", id = UrlParameter.Optional } // Parameter defaults
);
}
View 1 Replies
Jul 1, 2010
I'm using a standard GridView control inside of a web form. The web form uses a master page. The application is running within sharepoint (wss 3.0) environment. When i attach both the OnRowCommand and OnRowDatabound events to the gridview as shown in the markup below, only the OnRowDataBound event fires. The OnRowCommand never gets hit. When i press a button on a row, it posts back but never hits the onRowCommand event and simply falls through and repaints the page . However if i remove the OnRowDataBound event, the OnRowCommand event starts to fires correctly. I've tried a number of things...1. Hooking up the events in code instead of markup. (inside of PageLoad or PageInit)2. Changing the order in which the events are attached.
View 4 Replies
May 7, 2010
I have a problem with DetailsView linked with Database, DetailsView is Insert/Edit enabled, and adding/ediditng data works, however........ when I add a new record (DetailsView in Insert mode) and press INSET instead going to record I have just created in Read-Only Mode it shows me blank form, it looks that the "linking" field is null.
View 3 Replies
Jan 21, 2011
I use GridView & FormView to update a record. but when I click the "save" button, throw an except : FormView must be in the insert mode to insert a record. The record has been updated success, and I didn't change the mode of the FormView, how this error comes?
View 3 Replies
Jan 27, 2010
In my detailsview, I have an emptydatatemplate set up to allow users to enter new records. The code works. However, once the record is inserted, the detailsview defaults to a standard insert screen. I know this will cause confusion for the users. I would prefer the detailsview to either show in edit mode or a read-only mode. I have used detailsview.changemode and detailsview.currentmode in the custom sub created for the add new button of the emptydatatemplate- neither of which do what I was hoping. It would be even better if when there was no data, it defaulted to the insert screen (which seems like that should be an easy, no-brainer way for .net to function) but it doesn't. Or, I don't know how to accomplish it.
I don't want to force the user to click cancel after inserting an item through the emptydatatemplate just to be able to use the detailsview for other records.
View 2 Replies
Oct 19, 2010
I have grid view in ASP.Net 3.5. I need to add multiple blank rows in a gridview and then have to save them in database. How can I do that in most simplest way?
View 7 Replies
May 22, 2010
I am using Visual studio 2010 express and I have a details view databinded to an sql database table. When I use the Insert option on the view it causes an error due to it trying to insert a null into the primary key field. If the Insert function does not create a new primary key entry how is it created?
View 9 Replies
Nov 21, 2010
How do I insert a snippet to change a hyper link ' insert' to a button image?
Here is the front page code:
[Code]....
View 4 Replies
May 20, 2010
I have a Winform that has fields need to be filled by a user. All the fields doesn't belong to one table, the data will go to Customer table and CustomerPhone table, so i decided to do multiple inserts. I will insert appropriate data to CustomerPhone first then Insert the rest data to Customer table.
View 3 Replies
Oct 26, 2010
I am trying to insert data into two table at the same time , but i'm successding in inserting data into only one table at a time on button click .
[Code]....
When i run the code, data gets inserted into table "implantDetails" only. Are multiple INSERT statments allowed?
View 1 Replies
Aug 4, 2010
i am new to asp.net programming i am trying to insert data into access db from asp.net web form but it is showing error as
Syntax error in INSERT INTO statement.
my code is :
Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
View 5 Replies
Jan 15, 2010
I am working on an asp.net page and I want to load the contents of another web page and place it in a panel. This is the kind of thing that you can do with curl, but I need a native c# solution.
View 2 Replies
Feb 26, 2010
some text I want to capture. <tag> junk I don't care about</tag> more stuff I want.
Is there a easy way to write a regex that captures the first and third sentences in one capture?
View 5 Replies
Nov 18, 2010
I have a dataset which I am binding to a listbox. However, I want to combine two of the fields to make up the DataTextField. Is this possible, or am I going to have to loop through the Data Rows?
lstAddressDropdown.DataSource = dsAddress;
lstAddressDropdown.DataTextField = "StreetAddress" + "Place";
lstAddressDropdown.DataBind();
lstAddressDropdown.Items.Insert(0, new ListItem("Please select"));
It's worth noting that the dataset comes back from a web service so I can't change any stored procedure to combine the columns there.
View 2 Replies
Jun 4, 2010
I have an ASP.NET 3.5 web application in which i am using the ToolkitScriptManager as below:
<ajaxToolkit:ToolkitScriptManager ID="ToolkitScriptManager1" EnablePageMethods="true" ScriptMode="Release"
LoadScriptsBeforeUI="false" runat="server" CombineScripts="false">
<CompositeScript>
<Scripts>
<asp:ScriptReference Path="~/JavaScript/jquery-1.4.1.min.js" />
<asp:ScriptReference Path="~/JavaScript/Validators.js" />
</Scripts>
</CompositeScript>
</ajaxToolkit:ToolkitScriptManager>
View 1 Replies
Jan 19, 2010
Combining all pages in One Page , its good? its fatser than put each page as independent page !
if some one visit modern website ( Such as windowslive website) you will find that there is one page and on the left hand of page u will find list(collection of Buttons) if u click inboxbuttin, the only portion of the page is refreshed and so on , and u will not navigate to another page (the URL remain Unchanged) and other website like (asp.net) u notice that , in evey page u will see full postback , althougth this page conain the same controls ( logo.. home... profile ....etc) why they didnt combine them in one page?
and finally what is the best thing to do that? Create UpdatePane and puting each Page Controls inside Panel and make them all hidden and adding them to ContentTemplate of UpdatePanel and Making some Panel Visible and Hide other Based on required scenario ? if yes , i have do it in one page , when it was as independent Page (StudentRegister.aspx) its run fast althougth this page contain big logo and many controls that take time to loaded but its run fast, but when i put StudentRegister.aspx controls inside my updatePanel which will act as container for all other Pages , the Page run slow , althougth the Logo and many Pics and controls not refreshed and only the Portion of page refreshed . there is any new technology used to do that?
View 7 Replies
Mar 24, 2010
My question:
Is it possible to design a page in Expressions Web and then use it in Visual Studio Presently, I am using an asp.net master page in Visual Studio with functionality from the VS tool box (navigation tree, login etc). These work fine but they are not very pretty. How can I keep all the functionality that Visual studio offers (I will be adding an SQL database) but have it looking better than the drag and drop tools in VS. Is it possible or not to connect an Expressions Web Master page easily, so it will drive the site already built in VS - but have a more attractive GUI?
Or, is there something that I am missing in Visual Studio - can I edit the drag and drop tools in there to build a GUI with a Microsoft feel and look?
View 6 Replies
Oct 19, 2010
[Code]....
which is giving me
And i tried
select * from @jax
group by rep
and it did not group them. How would i bring the sum ly up with the sum? so it shows 1-10 cust,sum,sumly
View 1 Replies
Dec 2, 2010
I'm developing a web app which allows users to upload images. Instead of forcing them to first download an image I also want to allow them to provide a URL of the image elsewhere on the web.
I've got the code to do this, my question is how can I combine these into one text box that will allow the user to enter either the location of the image on their hard drive or the location of the image on the web.
I'm aware of the ASP File Upload control - but how could I leverage it to do this?
View 1 Replies