CodeVerge.Net Beta


   Explore    Item Entry   Register  Login  
Microsoft News
Asp.Net Forums
IBM Software
Borland Forums
Adobe Forums
Novell Forums

MS SQL 2008 on ASP.NET Hosting



Zone: > NEWSGROUP > Asp.Net Forum > starter_kits_and_source_projects.commerce_starter_kit Tags:
Item Type: NewsGroup Date Entered: 3/4/2004 3:46:34 AM Date Modified: Subscribers: 0 Subscribe Alert
Rate It:
(NR, 0)
XPoints: N/A Replies: 0 Views: 69 Favorited: 0 Favorite
Can Reply:  No Members Can Edit: No Online: Yes
1 Items, 1 Pages 1 |< << Go >> >|
sideveloper
Asp.Net User
Pre Populate Form Fields3/4/2004 3:46:34 AM

0/0

I'm sorry for cross posting, but I should have put this in here in the first place and I haven't gotten an answer yet and I'm completely stuck. Hopefully someone here can help me.

I'm adding some new features to the E-commerce starter kit and need a little help on something. I have made it so a person has to register before they enter the site. Once they add products to their cart and check out I want to pre populate the billing info fields with the info they entered when they registered.

In my customersDB.cs file I created a method:


public SqlDataReader GetBillingInfo(String customerID)

{



// Create Instance of Connection and Command Object

SqlConnection myConnection = new SqlConnection(ConfigurationSettings.AppSettings["ConnectionString"]);

SqlCommand myCommand = new SqlCommand("CMRC_BillingInfo", myConnection);



// Mark the Command as a SPROC

myCommand.CommandType = CommandType.StoredProcedure;



// Add Parameters to SPROC

SqlParameter parameterCustomerID = new SqlParameter("@CustomerID", SqlDbType.Int, 4);

parameterCustomerID.Value = Int32.Parse(customerID);

myCommand.Parameters.Add(parameterCustomerID);





myConnection.Open();

SqlDataReader result = myCommand.ExecuteReader(CommandBehavior.CloseConnection);





return result;

}






My stored procedure then calls all the billing info data in the database based on the customerID that is passed in.

Then in my register.aspx page I have in my Page_Load():



if (Session["obj_CustomerId"] != "") {

string customerID = Session["obj_CustomerId"].ToString();



Gracelakes_Production.CustomersDB BillingInfo = new Gracelakes_Production.CustomersDB();

BillingInfo.GetBillingInfo(customerID);



B_FirstName.Text=BillingInfo.B_FirstName;



}




This is where I'm stuck. I can't seem to grab B_FirstName out of the database. I keep getting an error that Gracelakes_Production.CustomersDB' does not contain a definition for 'B_FirstName which is the name of the field in the database.

Can someone tell me what I'm missing?

Thanks
1 Items, 1 Pages 1 |< << Go >> >|


Free Download:

Books:
Pro Apache Struts with Ajax Authors: John Carnell, Rob Harrop, Kunal Mittal, Pages: 502, Published: 2006
Programming ColdFusion MX: Creating Dynamic Web Applications Authors: Rob Brooks-Bilson, Pages: 1115, Published: 2003
Adobe Acrobat 8 PDF Bible Authors: Ted Padova, Pages: 1085, Published: 2007
Essential SharePoint 2007: A Practical Guide for Users, Administrators and Developers Authors: Jeff Webb, Pages: 428, Published: 2007
AdvancED DOM Scripting: Dynamic Web Design Techniques Authors: Jeffrey Sambells, Aaron Gustafson, Pages: 570, Published: 2007
CSS, DHTML, & Ajax: Visual QuickStart Guide Authors: Jason Cranford Teague, Pages: 562, Published: 2007
Macromedia ColdFusion MX 7 Web Application Construction Kit: web application construction kit Authors: Ben Forta, Raymond Camden, Leon Chalnick, Angela C. Buraglia, Pages: 1440, Published: 2005
Macromedia ColdFusion MX Development Authors: Eric Ladd, Pages: 594, Published: 2002
Struts: The Complete Reference Authors: James Holmes, Pages: 800, Published: 2006

Web:
Pre-Populate Form Fields The capability of pre-specifying web survey form field values is provided through an advanced feature that uses a Web convention called a query string. ...
Acrobat User Community Forums / Using Combo Boxs to Prepopulate ... Re: Using Combo Boxs to Prepopulate Form Field. In the article I use hard coded field names for populating the result of the selection. ...
access/prepopulate form fields values in next page [Archive ... [Archive] access/prepopulate form fields values in next page JavaScript programming.
Inside Microsoft: ASP/ADO - Populating Form Fields From the ... In an ASP application, in order to edit an existing record pulled from a database, you must populate form fields with the results of a query. ...
Prepopulate | drupal.org Mar 22, 2006 ... You can prepopulate more than one field at a time as well. ... Pre-populate contact form · A simple job application function using CCK ...
Acrobat User Community Forums / Using Combo Boxs to Prepopulate ... Could you please look back at the sripting I used in the question I asked on " Using Combo Boxs to Prepopulate Form Field" on Thu, Jan 18, ...
Prepopulate Form with Logged in user info in LiveCycle ES | Roland ... To pre-populate the form we need to get the logged in user info and inject that into ... LiveCycle won’t be able to decipher the XPath to the form fields, ...
pre-populating form fields dynamically - WebDeveloper.com Reload this Page pre-populating form fields dynamically ... I am trying to pre- populate a form field dynamically, so that the date field and ...
Pre-populating Form Fields for a New Item - echef May 16, 2008 ... Pre-populating Form Fields for a New Item. So for surveys and such I thought it would be nice to pre-populate a SharePoint List "new" form ...
Adobe Forums - How Can I Programmatically populate Form Fields and ... Oct 1, 2008 ... I am still not catching how to actually pre-populate the form itself ... So - if I delete the connection after generating the form fields ...

Videos:
Lec 13 | MIT 3.091 Introduction to Solid State Chemistry Intrinsic and Extrinsic Semiconductors, Doping, Compound Semiconductors, Molten Semiconductors View the complete course at: http://ocw.mit.edu/3-091...
XML11: An Abstract Windowing Protocol Google TechTalks June 1, 2006 Arno Puder Arno Puder received his masters and Ph.D. in computer science and is currently working as an Assistant Prof...
Computers versus Common Sense Google TechTalks May 30, 2006 Douglas Lenat Dr. Douglas Lenat is the President and CEO of Cycorp. Since 1984, he and his team have been constructi...
OAP Online System PSR for OAP
Lec 14 | MIT 3.091 Introduction to Solid State Chemistry Introduction to the Solid State, the 7 Crystal Systems, the 14 Bravais Lattices View the complete course at: http://ocw.mit.edu/3-091F04 License: C...
Structuring Personal Information When Everything Can Be Saved and Searched... Google TechTalks May 17, 2006 William Jones William Jones is an Research Associate Professor in The Information School at the University of Washingt...
Developing and deploying an application on Google App Engine This video introduces developers to building apps on Google App Engine. For more in-depth information and deep-dive technical sessions, come to Googl...
Intel DG43NB Motherboard The Intel® Desktop Board DG43NB delivers new levels of performance and enhanced multimedia enjoyment in the ATX form factor supporting Intel® Core™2 ...
Opera "The Ring of the Nibelung" by Wagner, Karajan, Bayreuth in English «The Ring of the Nibelung» - the first contemporary myth, a phantasmagoria of superhuman novelty and coherence of word, image and music or just a lov...




Search This Site:










xml as data for small store

no price protection even at check out

commerce starter kit for a live environment

bug in the ms access ibuyspy application!!

"the name 'sizes' does not exist in the namespace 'asp.net.starterkit.commerce.shoppingcart'"

getting data from the database using a loop

shoppingcartdb

sub communities

login failed for user 'commerceuser'. reason: not associated with a trusted sql server connection.

problem with the installation

how to change the language of the strings

displaying shopping cart in html email

how to make a 2nd ecommerce site using starter kit?

commercalizing the commerce kit- interested in helping

ok i need help

catalog manager

help! help! searchresults

commerce starter kit - where is the database?

server error

sample web using fedex api

installed commerce kart, without a problem on framework 2

visualstudio

submenu

no db connection when installing starter kit

could not find stored procedure

can't find _menu.ascx.vb----vsnet....

photo gallery page security setting

cannot open database requested in login 'commerce'

installation on iis6.0??

storefront applications

  Privacy | Contact Us
All Times Are GMT