I'm creating a website with ASP.net and I have a sign up page. The user has to enter a name and password in textboxex, and choose a location and reason for joining from dropdown lists. (There is a built in wizard for new user sign-up but I chose not to use it).I would like to save the information entered in a table in a database in the App_Data folder. How do I do this?
View 3 RepliesI am trying to make a routine system(school, college) where i will use three text field as input1> Class start time(input: 8:00 AM) // when school/college will start.2> Class ending time(input: 1:00 PM) // when all of my class will finish3> Duration of class(input: 1.5(hour))// class hourdesired output: A class routine where time(hour) will be shown in row and Day(e.g, sunday,monday) will be shown in column.questions:
1> how i'll take the input as time:hour from text field?2> how i can save the calculated time in database for use in other page?
Our application lets the administrator create new users. Since the administrator is logged in, I have set Logincreateduser = false so that the administrator is not logged out even after creating the new user.
The problem is :I need the userid of the newly created user to store additional details of the user in another database table. I see that i can get the username using Createuserwizard1.username; but how do I get the userID?
I'm developing an ASP.NET application with Visual Studio 2008 SP1 and C#. I'm also using Sql Server 2008 SP1.I'm trying to add the tables created with the command aspnet_regsql -S (local) -E -A m to my own database.
If I run that command it will create a database (Aspnetdb database) with four tables. I want to know if there is a command that creates those tables in my own database (called myDatabase, for example).And, when the tables are created. How can I connect authentication to myDatabase?
i have this form, that the data is stored in a SQL db using Linq.
my question is, how can i add a column, that will have all the information about the sender, meaning IP address, browser, referrer etc.
the thing is is i want to store it in one field. i come from a php knowledge that has been long forgotten by me, but i still remember there was some serialize command, that you could run on an array and store it in a db, then when you want it back to an array you would just run deserialize command and it would go back to an array.
I would like a situation where there are three textbox available and this would give the user an opportunity to input a value in the textboxes. The value in the textboxes would then be stored in a database table(the table is already created in sql). Furthermore, the value would be able to be reterieved later on when the user presses another button. A sample code will help.
View 1 RepliesOn my aspx page I am trying to capture user input and then tried to save them in database and also trying to post them onto another page. Now I am using the following code on the button click event:ASPX CODE:
<asp:Button runat="server" ID="cmdPress" Text="Save"
ValidationGroup="ValidateId" Height="26px" onclick="cmdSave_Click"/>
CODE BEHIND:
SaveCustomer();
SaveRequest();
cmdPress.Attributes.Add("onClick", "update(" + ID.Text + ");");
Now when I click save button then it the page waits and then I have to click again to close the page automaticallly and move to the next page. Can anyone tell me why I will have to click Save button twice to activate the button.
VS2008 c#, asp.net 3.5, ms sql 2008How do I validate user input in TextBox inside a FormView [Insert Mode] with MS SQL 2008 Database?* FormView #fvInsertProjectInfo* TextBox #txtProjectNameCurrently, user could insert a new project using the FormView, but will only be found out that the project is already existed when pressing the INSERT button. To make it more user friendly, I would like to check that the database does not contain a record of the project the user trying to insert (by comparing value in txtProjectName with the Projects table in the database)
View 2 RepliesI'm new for asp.net and web development at all.
I want to filter user input before putting to database.
Are there common technics for this?
I have five textboxes(tb1, tb2, ... tb5) on the page, each textbox represent a column in the database table.
I need to search the database table based on the text in the textboxes. User can either enter text in all five textboxes or none.
What's the best way to do a search?
I am thinking for one textbox(tb1), depends on if tb1.text is empty or not, I need to do 2 searches
[Code]....
for two textboxes(tb1 & tb2), depends on if tb1.text and/or tb2.text are empty or not, there are 4 combinations, so I need to do 4 searches
[Code]....
for three textboxes, there are 8 combinations,
Does that mean for five textboxes, I need to do 2 to the power of 5, 32 combinations, 32 if statements?
I want to store the user name and email details in to the database after they paid the money through paypal .
View 2 RepliesWhen a user logins, I want to be able to store all his profile information so I can display, for example, his email on different pages of my website, but I don't want to have to keep querying the database for every time I want to display his email. How would I go about doing this?
View 2 RepliesIn this forums given one example,Based on this That information stored in database using asp.net,
And also After login need Logout also...
I am retrieving list of projects and project IDs using autocompleteextender. Is it possible to restrict the user to type further if the input doesn't retrieve any value from database. Though, I have found a solution by calling function through OnClientPopulated. But this function calls back the webservice "GetCompletionList" method. I don't want to recall one method two times. is there any other way?
View 1 RepliesI want to kill the session on the browser closing or tab closing and store the Logout time in database using Asp.Net.
I have coded that code in Global.asax page which works only when we Click on Logout Button .but it's not worked on the tab closing /Browser closing.
void Session_End(object sender, EventArgs e) {
SqlTransaction transaction = null;
using (SqlConnection con = new SqlConnection(conn)) {
con.Open();
SqlCommand cmd = con.CreateCommand();
transaction = con.BeginTransaction("Transactions");
[Code] ....
how can i generate rtf file based on input field(textbox input by user) c#
View 3 RepliesI would like to program an Input Box that comes up when a user clicks 'Find' button. It asks 'Please enter an employee number'. Then it takes the employee number typed into a text box and searches a dataset for that specific employee record.
I know that it should be server side because the client may not have the proper javascript installed or diabled. Therefore, can someone give me some code to put in code behind that can pop up an input box and use the input after, if this can be done?
i've got some problem reading excel files to store into sqlserver database. currently my code has a fileupload control and a button for me to save the excel file into a folder and read the data inside the excel file and write it into the sql database. The code works only if the excel sheet name is Sheet1.xlsx, however i tried upload a diff file named ImportUserFile.xlsx and it gave me the exception below. 'ImportUserFile$' is not a valid name. Make sure that it does not include invalid characters or punctuation and that it is not too long. i have also tried other file names and it seemed only Sheet1.xlsx works.
[Code]....
Using SQL and C#. I have a gridview with a template field. I need to modify the some items in the gridview when the user selects a given record and store the values back in the database. ProjectID is the unique key in the database.Gridview is done as a table. How can I do it? Here is my grid view implementation.
[Code]....
Its related to datatable in gridview store in session and then session retrive and store to database. basically i am using gridview here creating new row for button click and these row adding untill user's last entry then submit all these entry to database. so i want to use session variable to store this data temporarily and after final entry user click on submit button and all data shold be save in db.
View 9 RepliesIs it better to store images directly in a database or to just store the name of the file in the db and display that file? I would think that just storing the filename of the image would keep the db size low...
View 1 RepliesWeb service error response (code/message etc) would you store it in a database? or would you keep the error response in a method.By the time I'm done with this, there will be hundreds of error response, maybe in the future, thousands? (I dont know yet, depends how large this web service grows).EDIT: error response is the response returned back to the application via the web service, (not to be confused with error logging).
View 1 RepliesCreate a class Employee which will implement the below interface: IEmployee. The application should accept the function to invoke and its parameters from the console in the Format:
[MethodName]:[Parameter1]:[Parameter2]
Ex: SetProperty:Age:44
The implemetation shold have the necessary checks on whether the input is in correct format by handling like FormatException.And the program should be able to continuously accept the input and print corresponding output until the input given as "Exit".
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
namespace ConsoleApplication1
[CODE]..
Issue: I am unable take the user input in the corresponding format.in the above code everytime I have to give the user input in the format "Set:Age:33" but this is not I m looking for .Actually firstly the expected input and output should be given in the format as per the screenshot I have attached.
I have a user control (ascx file) that contains an interface for users to change the data retrieved from the db. So, I am displaying data and most of this data can be edited by the user. When the user enters text into a textbox, and clicks "Save Changes", the value they typed in is lost and not persisted to the database. I realize now this is because the SaveChanges button does a postback, and the user control gets reloaded with its original valuesbefore the code within my SaveChanges button gets executed. I'm not sure if there are properties I need to set to save the input data, or if I need to write my own code to do it. What is the generally accepted method to do this? (Also, all of the controls in the ascx file are wrapped in an Update Panel.)
View 8 RepliesBelow is the code I use to store file into database but there are a few problems.
1. couldn't store file larger than 4mb
2. couldn't store doc,docx,xlsx but only .txt
my table column are:
[code]....