DataSource Controls :: Access The Point Data For Both The Merchant And Merchant Category
Apr 26, 2010
the best way of achieving the following using SQL Express 2008.I have a table with the following information in:
merchant id (an integer referencing the merchant i.e 1000)
merchant category id (an integer referencing a unique category for the merchant i.e 1015)
points (a long int)
I want to access the point data for both the merchant and merchant category.
?
i.e. merchant 1000 total points 100
merchant category 1015 total points 70
merchant category 1016 total point 30
I created a view with rollup which gives me the 2 levels i need, but i'm unsure as to whether this is the most efficient way of achieving my goal.Ideally I'd like a view to show the following:
i have a .net example from barclays epdq merchant inergration. which i get working fine, but i need to send the request via a onclick event, currently the example uses a html form, what would be the best way to do this?instead of usng the form below i want to hold hidden asp feilds and dynamically populate them
Recently we've developed an E-Commerce web application for a client. We are at the stage before launch and the client is not happy to disclosing live merchant account details to us because they don't want us to potentially being able to see their clients' data.
Since we are going to maintain their website (running off their servers but we will still have access to the site files) I cannot see an easy solution to this other than trust.
How to implement and maintain E-commerce application when business don't want to disclose merchant details to developers?
I am working in a project that is a musical website. I want to display the web page with all categories I have. In my database , named Category_Master, I have two fields like Category_Id (which is a primary key ) and Category_Name. I have generated category_Id with NEWID() function. The category_Id is not supposed to display on the web page. But, i have to select Category_Name and according to that , I have to get the category_Id. If I am using Static connection with SqlDataSource, i am able to make visible=false property so that the category_id won't be visible. But , at that time, I can't write code to Select the category_id of the selected index.
If i am using disconnected approach, I filled the dataset with the Category_Master, and binded it to GridView. But, at that time, I can't hide the category_id from the user. I want to select category_id by clicking on the category_name with out displaying category_id ..?
Here is what I am basically trying to accomplish I want to upload images to the server separated into categories and save the file path into the database. I have found plenty of documentation on saving to a file and the file path to a database. But, I haven't found anything that will allow me to seperate the images into categoies.
I have made three tables in the database
[code]....
What I am trying to do is create a gallery for our clients to browse and download different vesions of posters and ad cards.
I would like to make script that show category and all its forum that 's why I have created table 'cat' ( id , CAT_TITLE )( table for category) and an other table for forum name ' s 'forum' ( id , name,CAT_ID)
my question how I can show category and the forum by using repeater or another control like http://forums.asp.net/
i create example using Northwind database so i create a new website and add new ADO.Net Entity Data Model (.edmx) called Northwind.edmx and i add Categories and Products table inside this (.edmx) file
and add new ADO.Net Data Servuce called "ADODataService" and add it as WebReferences called NorthwindService
so i add new web page and drag DropdownList and Gridview as i want to bind Dropdownlist to all categories and when i select category from Dropdownlist bind Gridview to all Products related to this category
so my code
[Code]....
and my code [Code]....
so when i select category from Dropdownlist nothing happen :(
also you will find commented code in method BindCategory whuch is not work also.
I'll try to explain as simple as I can in text what my problem is. I don't see any other way to make my issue clear.
I have a GridView that uses an ObjectDataSource.
The ObjectDataSource has an DataObjectTypeName defined, so I pass/get complete objects or list of objects to/from the data access methods.
The objects I'm working with, let's say we work with Book objects, contain a Title and a Category, BUT the Category is an object itself. When the Select method is called, we get a List of Book objects, which is perfectly displayed, overridden ToString method in the Category objects within the Book objects.
The problem I face is that I can't find a way to update the category in my GridView. What I did already accomplish is:I used a template field in the GridView for the Category so I could use a DropDownList for that field in Edit mode.
I bound the DropDownList to another ObjectDataSource that gives me a list of CategoryObjects.
So when I enter Edit mode... the row shows a nice ddl with the available categories. It even selects the right original category.
So far so good... but when I want to save my new selection, I get an error that a string (the selected category in the ddl) cannot be converted to a Category object (that's what the Book object, that is going to be used for the update, expects).
I'm trying to access a user's userId in the login forms user logged in event, but I keep getting an error. If I attach the code to a button which is clicked when a user is already logged in, I get no problems, it's only when I try to execute it within the user logged in event that I get the problem.
Below is my code with the part that causes the error commented out:
[Code]....
I'm guessing that I'm trying to access the userid before it is available, i.e. before they're logged in, but the event as I understand it is fired immediately AFTER they've logged in.
In which case, when is the earliest point that I can access a logged in user's userId (I'd like to tie this in to the point at which they login)
I've many wifi access point that are giving me connection inside an intranet, every access point is located in a wanted position of course, and my big problem is to know to which access point i'm connected trough a web page!Let me say access point named "A", and access point named "B", i must retrieve, with a web page, to which access point the client is connected because in that way i'll get the right position of my mobile
I'm working on a dynamic table of contents (toc). The toc is generated from data in a sql database. There are 5 sections in the toc and within each of the five sections, there are a varied number of rows. (Section 1 may have 5 rows, while Section 2 has 12 rows). To help differentiate between the sections, I'd like the ability to add some type of grouping in my gridview. So, it would look like below. Do I just add a different gridview for each section, or is there a way to "categorize" the gridview to break up the data with a Section 1 Category
I have two tables... Laptop category and Laptop details ... Laptop of each category is displayed using Imagebuttons in my website... eg: Dell.HP,Compaq and each category is associated with unique ID like 1 ,2, 3, etc.
Based on this category ID when i click on particular image button it should redirect to another web page ( I ve specified the page in each ImageButton's PostBackUrl property as LaptopDetails.aspx ? catId=1 ....). And in Details page I would like to display the sub models of particular Laptop Category...
for eg Dell has three sub models INSPIRON 1464, INSPIRON 15 and INSPIRON 15R
sub models has to be displayed with image and all the details from the database...
I have a datalist that retreives category names for a knowledge base system I'm working on. When you click to view all the category titles, I want to hide those category titles that don't have any articles associated with that category. So, for example, you click to see all the category titles, but because there isn't any KB articles for "Mice", the "Mice" category isn't visible.
im creating advance search for my project and end up with the problem of select statement format for 2category.
here is example:
i have advancesearch that has checkbox wherein you can select multiple checkbox. example is selecting category, for example ihave 5 category as shown below.
Category
News Sports Opinion Editorial Literary i did tried someformats for my select statements to make it work for 2 or more category, but i just cant get the right format of the select statement.
example if i select the following.
if selected is category 'Sports'
it wil work with this: " 'Select * MyTable1 where [Category Title]='Sports' "
if selected are category 'Sports' and 'News'. what must be the format for my selectstatement for 2 or more category in the same fieldname? should it work with this?
" 'Select * MyTable1 where [Category Title]='Sports','News'" no, how could i make it work. what must be the right format?
I'm developing a webshop and need to list products. Each product is displayed in a UserWebControl. I have a method that return the products to be shown. The UserWebCotrol has a product property.What should I use to create the controls on my category page? I need to dynamically create the instances of the UserWbControl and set the product property.
1. I have gridview which is bind with sql data source column name industry 2. I have checkbox list which has all industry name, 3. I want to pass checkboxlist selected value to sql data souce to filter data in gridview.
I could use some guidance on a better way get get my data than I am using. This way is taking nearly 45 seconds to get the data and bind it to a gridview here are my methods used to get the data
I'm now reading this article:[URL]But I don't understnad why this is better than just writing code, methods that connects to DB and get from stored procedore what I need. Why is it better to use so much DataSets for all the tables and more.
What would be the best way to handle the following scenario? I have an application where depending on what type of proceeding is selected, only certain input fields should be visible.
There are 33 proceeding types and 14 input fields in total
First case, make one big form with all of the fields and have a dropdown with proceeding type which depending on what is selected, makes certain fields visible?
