I'm using CreateUserWizard for creating an user but asp.net 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
[Code]....
[Code]....
i want to get data from database of field Name and Gender, and then display it in Label name and gender. when i click save it move to next record and display name and gender that next record.
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 Repliesi 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 asp.net web application developer, i am using the visual studio 2008, C# to create the web site
View 6 RepliesI 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 Replieshow 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 control.how should i store which customer selected which product after login
View 1 RepliesThis form has some information for making a reservation for a customer at a dining venue. If the customer is a "known" / "returning" customer id like to fill the form based on the customer ID. Some of the things on the form are ...
textbox=CustomerID
Input Button
textbox=FirstName
textbox=Lastnemt
Using MVC, What would be the best way to go about going back to the server to find the customers first / last name and posting it back to the values in the textboxes ? Ive been trying to work with AJAX & JQuery but i cant seem to update the values in the textbox using AJAX.
We have two database, one is normalised A other one is not normalised B. Bu SSIS mirroring we have moved all latest data B to A. But now that is one time opersation. But B is our live database, now everyday I want that any operation occur in B should move to A.
Is there any automatic way is available if not then can I acheive this my manually?
i'm tring to connect a ql database to my website but the data r not getting added in the table..
ut when i use the query builder there the data is been added successfully when done for testing the connection.i'm using sqlserver2005 in vs-2008.
I have SQL Management studio in one system. It has lot of tables, stored procedurs. I want to move that database data into another system. like taking Office database to my home. How can I do that ?
View 1 RepliesI am displaying one question & their 4 options per page. For that i have one label for question & radiobuttonlist for their answers.There is next button. after clicking next button i want to display another record. I have tried this with dataset with random function, but its not proper. values gets repeated. so i want first record to be display in pageload & after clicking next button next record should move till record exists. I want to move one record to another after clicking next button.
View 1 RepliesI've 2 listboxes i want to transfer items from listbox1 to listbox2 and then save the items on listbox2 (transfered items) on database.
View 1 RepliesProblem: I need to move a local development database to the production server without any of the test data.
I am running SQL Server Express 2008 and SQL Server Management Studio 2008.
To create my ASP.NET Membership 2.0 system I created the DB initialy and ran aspnet_regsql.exe
I then added my own tables manually to store additional information.
I adjusted the web.config file with an application name.
When I ran a sript the application ID name was created and populated in the aspnet_Applications table. My script created a new member created and added to the admin role. Ok so everything go so far.
Now I want to move the local DB to the server. I know the connection string and can change this in the web.config.
My hosting company doesn't provide restore, so I don't think I can backup and restore
Q 1. What would be the best way to move the database across. Bearing in mind I need to clean the database out of test data.
Would it be just generate an SQL Script for the database and run it as a query on the server? And if this is the best way then do I need to set the permissions for the ASPNET user?
Q 2. What is the best way to clear out the data in the local database.?
I just started with ASP.net in Visual Studio and I have a problem which I can't find any solution for. I made a master page with a few subpages and one is a very simple shoutbox page. I added a gridview and added some information manually into the database so I could see if it displayed well on the website and it did. So I have a GridView with Name and Message. Beneath that I have a textfield and a button and I'd like to submit the information in the textfield to the database however I don't know how to do it.
This is the code I have on the shoutbox page:
[code]....
I recently designed a website for a school, I have their result in my database, I am using Northwind. What I want to do is, since all the result are in the data, I want to input a students name, exam number and some numbers in a card(exam scratch card, which they will purchase) they will purchase. When they input these details, the students results will be pulled out from the database.
Just like exam result portal, where you will look up your result with, your name, school number and numbers from the scratch card.
I have a table where I have a column for different states (NY, NJ, etc). People can join the group (in my page) for each state (the state where they live). So I have to display the newest members for each state.
So the way it should work is, every time the page is refreshed/reloaded it should show the state name as a header text and the first 5 newest members for that state. This should be random, for example initially when the page is loaded say it will show state: New York and the 5 recent members like Stacy, Laura, Mike, Sam, Mathew.
Then when the page is refreshed it will show another state like State: california and the recent 5 members
I want the user to click the link then the window pops up, but I want the data inside the window to be pulled from a database, and I need to repeat this process for 5 links that are also pulled out of a database. Say the most popular items for the month. My question is how would this be best accomplished? Jquery, or AJAX. I am just trying to see which would be the easier way to go about coding this with .net and C#.
View 1 Replieshow to use web service to upload information to the database using vb.net 1.1
View 2 RepliesI am trying to create Modal Web Form to get information and save in the database. when I submit the Modal form, it give me "
The name 'sNewNotes ' does not exist in the current context" message. I am not able to save data. How do I accomplish this?
Following is the Modal Dialogue Html and codebehind code
I have an aspx form that is meant to add a new prescription for a doctor system. I've created the database and dataset needed, but the problem is that the doctorID and patientID has to be able to select from the database, not entered in as a plain text. The form look something like this (I did this in DetailsView in MS Visual Studio 2010):
DoctorID: [textbox]
PatientID: [textbox]
prescription details: [textbox]
Insert Cancel
as you can see, only the prescription details needed to be entered in and the doctorID and patientID needed to be selected from the database (in a dropdown list maybe) and it shouldnt allow any text to be entered in. I did the above tables using a DetailsView in Microsoft Visual Studio 2010. However I can't seem to make the doctor and patient ID field be dropdown box which allow me to choose the current doctor and patient in the Doctor and Patient table in the databse. Can anyone tell me how to do it with Design View in Visual Studio?
I have a stored procedure which is working fine and also code in my vb class, which when I click on save, looks as though it has executed but no information is saved into the database....
My code used to save the data into the database is below.
[Code]....
I would like to check my database for to see if a user name is available but my script isn't working.
I am taking input from a text box call unametextbox and i'm trying to extract any matching username from the database, this is my code.
[Code]....
It's probably something small but I can't seem to find what went wrong. I am trying to insert information into my database. It goes through the code just find but it doesn't insert into my database. Here's my code:
[Code]....
Here's my webconfig connection string:
[Code]....
I have created a login form through VS 2008 using C#. There are 5 different aspx pages in my application.
1)Default.aspx: It contains only a hyperlink to direct the user to login.aspx page.
2)Login.aspx: This page has texbox for Username and Password, sign in button, textbox for displaying error and hyperlink (Create an Account) if the user does not created an account yet.
Here is Login.aspx code:
[Code]....
Now, I want to do following with my application.
If the user already has an account, he can put his username and password and click on the sign in button. If the username is existed in databse, application should compare the user input with database and if both are matched then the application should redirect the user to "welcome.aspx". If username does not exist it should show that Username does not exist.
my access database consists of 2 tables. i name it table A and table B.
my idea is, i would like to search the data inside these table A and table B by using a text box and a button.
and 2 radio button are used to control whether data inside table A or data inside table B to be search.
