DataSource Controls :: Get Datas From Customer Database?

Jan 8, 2010

developing a product (like shopping cart) in ASP.NET/C# 3.5. It is common for all the shopping sites. The following is my task,I need to get the datas from customer database (It may be SQLServer, MySQL or Oracle and the database structure also different). For example i need the following items for my product from the customer database,Category ID (Category or Product) Category Name Parent Category Description Cost Quantity Thumbnail image url Original image url Related products So how to get above values from the customer database and what should be the best concept to do this because i don't know anything about customer database (I don't know whether it is SQLServer or MYSQL and also i don't know the database name, table name or column name).

View 4 Replies

Similar Messages:

Forms Data Controls :: Dynamically Insert Datas From Database Into Table?

Aug 20, 2010

how can i dynamically insert datas from database into Table and display the table

View 1 Replies

DataSource Controls :: How To Calculate The Total Quantity Demanded By A Particular Customer

Mar 22, 2010

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?

View 3 Replies

Forms Data Controls :: Can Write Selected Product Ids From Grid View To Database With Customer Id

Jan 26, 2010

how should i write selected product ids from grid view to database with customer id. how to associate customer id with job ids selected from grid should i store which customer selected which product after login

View 1 Replies

Web Forms :: Storing All The Datas Of Xl Sheet Into Sqlserver Database Table?

May 28, 2010

i want store all the datas of xl sheet into sqlserver database table. i am using 2.0 and sqlserver 2005. pls provide the coding.

View 2 Replies

Web Forms :: Specific Customer Info Be Showing On His Page For Each Customer?

Jan 13, 2010

Now i have a database table holds all info of my (customers) such as first last names and address phone number etc ... and i able to edit delete update their info from my side using the admin page that contians gridview i created. If several customers logged into their account pages, and each one wants to update his information,

How can i let the specific customer info be showin on his page for each customer? (I have one databse table and it contains a primery key column called "MemberID") how can i make the new subscribed user get his info that he did input or i would like to add to it, showin on his account page?

View 8 Replies

C# - How To Move Customer Information From Database To Your Database

Oct 6, 2010

I'm using CreateUserWizard for creating an user but automatically add user to ASP.NET database
I want to add user in my database and in my customer table. I have tried these code as peer below but nothing happened


View 2 Replies

Web Forms :: Link The Customer Info From Database With The Login Part?

Jan 4, 2011

i had done the register page, now want to create the login page, but how to link these 2 things to make it able login from the customer database ? I m newbie of web application developer, i am using the visual studio 2008, C# to create the web site

View 6 Replies

Web Forms :: Collect Customer Complaints And Stores Into Database - How To Entry Form Works

Dec 16, 2010

I am writing an application that collects Customer Complaints and stores them into a database. I want to keep it simple so that the Managers without much web knowledge can use it. This is how my Entry Form works. The Manager selects the name and id of the staff by choosing a location. This loads ids and names of the Staff in that location from the database. Then the Manager rates the complaint based on the severity and enters the comments. I was able to use Session objects to get all these values from the Entry page to the Confirmation page so the Managers can check again. This is where it gets tricky. If there is a correction they have to make by trying to go back to the Entry page, the values are lost (esp. Drop-down ones).

View 6 Replies

Customer Domain "appear Everything From Subdirectory" To A Multi Customer Application

Mar 9, 2011

I'm not really sure where to start with this and therefore can't pick a more specific area to post. At first I though this might be something I would do in IIS7 but on reflection i think it needs to be at the application level. I am developing an application which will as part of it's function provide a unique website (custom CMS) to my customers. Each person who registers will have their own site accessible via a url such as [URL]. I need someway to take this and work out which customer it is and then load the rest of the pages with their content. So the site may have a home, about us and news pages for example and be themed to the customers requirements. Each of the pages will be the same aspx file and application for all customers but the content and style will be loaded from the database at runtime. I'd like for the duration of the visit for everything to appear as if from this subdirectory without actually creating them for each customer. so thy could visit [URL] but it actually loads [URL] and loads the content based on the customer site the visit is viewing.

I'm not really sure how to approach this. Maybe using a session value to store the customerid for the site the person is viewing which could be calculated from the URL on the first visit. I presume other people have done something simialr in the past. Where it gets more complex is if I then want to offer customers to have there own domain name pointed to the site. In that scenario they would have say [URL] which points to my server and bound to my application [URL]. All pages would have look as though they were on the customer website such as [URL] but still point to [URL] in the background and also somehow link to the customerid in the database to load the correct content.

View 1 Replies

Forms Data Controls :: GridView With Datas From VB.NET Script?

Apr 30, 2010

I'm wondering if it's a GridView is able to display data from my VB.NET Script.

My GridView is connected to a SQL server wich display datas from an user which can have a few accounts.

My script write one password per line.

How can I display passwords in the same lines from the GridView ?

View 2 Replies

Forms Data Controls :: How To Read Datas From Table Control

Aug 20, 2010

how can i read datas from table control

View 4 Replies

Forms Data Controls :: Editing Datas In Gridview Using A Dropdownlist?

Dec 20, 2010

i am making an application using a datagridview... And I am very new to it. And I need to edit my datas in gridview using a dropdown list.

So this is the flow of the program. As the page load, my gridview will appear, with the datas from the database binded to it, so far I have done that already. Every row in the gridview has an edit hyperlink, so when I click that, I can change the values in that row using a dropdownlist, wherein, the item in my dropdown are aswell from my database.

View 2 Replies

Forms Data Controls :: Select The Required Datas From Datalist?

May 21, 2010

I make one datalist and put data in it and add one button for selection. When you click the button and you can select the necessary data.

The following is my code:

Protected Sub ImageButton20_Click(ByVal sender As Object, ByVal e As System.Web.UI.ImageClickEventArgs) Handles ImageButton20.Click
Dim myConnection As SqlConnection
Dim myCommand As SqlDataAdapter ' Create a connection to the "pubs" SQL database located on the
' local computer.
myConnection = New SqlConnection("server=localhost;" _
& "database=pubs;Trusted_Connection=Yes")
' Connect to the SQL database using a SQL SELECT query to get all
' the data from the "Titles" table.
myCommand = New SqlDataAdapter("SELECT * FROM Product Photos WHERE Product Name= FOOD ", myConnection)
' Create and fill a DataSet.
Dim ds As DataSet = New DataSet()
' Bind MyDataList to the DataSet. MyDataList is the ID for
' the DataList control in the HTML section of the page.
DataList1.DataSource = ds
End Sub

However it is still not workable. Who can fix it?

View 3 Replies

Forms Data Controls :: Filter GridView From SQL Datas With Windows Username

Apr 15, 2010

I have a list with computers, username and other values in a SQL server.

I can diplay this on a gridview with a SQL script.

However i wan't to filter the list by the windows's username.

When a user logon from this windows account and goes to the ASP.NET web page he could shows only the list that contains his username...

I'm able to ask to the SQL server the SQL login, computer name wich we are logged on but no the windows login.

If someone known how make a kind of filter, i can display the windows username with a VB.NET script

View 9 Replies

DataSource Controls :: Transferring Data From Central Database To Local Database?

Mar 2, 2010

I'm trying to figure out if it's possible to transfer records from SQL central database (who has a public IP address) into SQL local database (who doesn't have a public IP)?

or if it's not possible can I use a centralized website instead to pass some data into the local website? (but i'm not sure if it will have some security concerns)..

View 3 Replies

DataSource Controls :: Tried To Update My Current Database With The Triggers To Input The Schema Into The Already Existing Database Can't Get That To Work?

Jan 22, 2010

Creating a system with web front end and SQL backend (microsoft obviously). I have tried using the asp.netsqlprovider but i can;t as i am only allowed one database on the server, so i then tried to update my current database with the triggers to input the schema into the already existing database.Next step i create my own table with two simple fields of username and password and try and authenticate that way, i can't get that to work either.

I ahve limited permissions on the network as i am a University Student. I really don't know what to do. Never had to create a log on system before and i thought it would be far simpler than this. I ahve used Microsoft's sqlprovider schema before and it worked fine. I have also authenticated via IIS and AD too before. I can't do any of those two in this instance it seems.I need an alternative for logging in users, if needs be in can be crude. I also still need to have some kind of two different views too for logged in users and not logged in users, but that can change if needs must.Don't let me down people, haha. Think this posts in the correct place, i could not find another one i thought could be more relevant.

View 4 Replies

DataSource Controls :: How To Transfer Database From Mysql To Sql Server Database

May 10, 2010

I have some data which is in mySQL, i am not familier with mySQL, i would like to transfer all the data from MySQL to SQL Server database,

View 11 Replies

DataSource Controls :: Import Data From Another Database To Database Everyday

May 30, 2010

i would like to ask about how to sync data from client sybase database import to our sql server database regularly(set time to sync everyday) by create a file in our sql server database

View 1 Replies

DataSource Controls :: Database Publishing Wizard With Existing Database?

May 10, 2010

I have a development database and one in production. There are two different sets of data in each database. On my dev system, I have mostly dummy data that I test with and in production is the real data for my web application. I recently added a new feature to the app that required a new table, and a new field for a foreign key in an existing table. I now need to upload that new structure to the production database without overwriting the live data with my test data.

If I run the Database Publishing Wizard, and choose "Schema Only" will it import the new structure and leave the existing data alone, or will it drop the records in my production database tables?

View 1 Replies

DataSource Controls :: Synchronize The Database To A Sql Server Database?

Jun 7, 2010

I have created a sdf database in a mobile application.Now I want to synchronize that database to a sql server database.

View 1 Replies

Forms Data Controls :: Access The Customer Name Outside The Form?

Jun 15, 2010

I have an ASP pg with a formview list control on it that hooks up to a sql database customer table

I want to access the customer name outside the form.

How do I:

A) access the bound text box in the form view template? Something like Text1.text=formview1.customername.text (that doesn't work but that's the kinda thing)

B) access the database field in the table that the sqlsource connects to to feed the formview

Really appreciate the help. I bet it's easy to do but I'm just not getting there.

View 4 Replies

Use The Database To Register New Customer With "ID" 302001..and I Want To Generate ID When Click "submit" Button?

Sep 7, 2010

I create a webform to register new customer..In my form i have "ID" for customer.And i have database with table "CustomerDetails" with existing data..Existing data "ID" start from 300000 and already have data till 302000..Now i want to use the database to register new customer with "ID" 302001..and i want to generate ID when click "submit" button...this is my problem..i wanna generate ID after click submit..

View 2 Replies

Databases :: Way To Access Datas Using SQL?

Jul 12, 2010

I read a lot of tutorials to learn what was the way to manage accessdata on a MySQL database from my ASP.NET, but there still something to whichremains unclear is the formatting of data and the ideal time to do so.For example, if I have a sentence like the following:"Je voudrais t'aider à résoudre ton problème"
When I pass the variable that contains this sentence, I wonder who the quotea problem because the SQL query in this setting look like this:"'I want to help you solve your problem'The quote of "t'aider" comes as the end of ther string in the query string. So I have to the format the string to double the quote to be able to pass it in the database..Maybe I missed the good tutorials, so if you have any links

View 10 Replies

How To Display Gridview Datas As Two Columns

Oct 29, 2010

I have a gridview in a webform. When the page is laoded the data from xml is binded to gridview. Say i have twenty product details in xml. Now i have written code to bind those details with gridview its working fine.

i want to display like this, for exmaple if there are twenty records i want to display ten datas on left and ten datas in right, find the sample below,

Records in dataset,

a 1
b 2
c 2
d 3

this is the way i want to display in gridview,

a 1 c 2
b 2 d 3

View 1 Replies

Copyrights 2005-15, All rights reserved