making relationships
string insCmd = "insert into Registeration(UserName, Password, EmailAddress, Gender) values('" + TextBox_UN.Text + "','" + TextBox_P.Text + "','" + TextBoxEA.Text + "','" + DropDownList_G.Text + "','" + "')"; and my bd has the same number of columns but shows error There are fewer columns in the INSERT statement than values specified in the VALUES clause. The number of values in the VALUES clause must match the number of columns specified in the INSERT statemen
Riddhi ValechaPosted May 16, 2013, 3:20 AM
I have made changes in Registration.aspx page.
On Button1_click event, I have fired an insert query.
I have made a new database(in App_Data folder), given a new connection string in connection.cs class.
The values are being inserted perfectly. Check this code.
Riddhi ValechaPosted Jun 6, 2013, 3:47 AM
Do explain the flow in detail.
I am not getting what exactly you are expecting.
If you want attendence, then in simple and layman's language, your system flow should be-
1)User Enters UserName and Password.
2)User clicks on LOGIN Button.
3)System checks whether Username and password are correct or not. If correct, then system enters current date and time. If incorrect, then system will show the user error message.
-----------
If it is this, then the project should work for you dear.
ram zyPosted May 25, 2013, 6:27 PM
Riddhi ValechaPosted May 20, 2013, 1:13 AM
Take this code...It will help you.... Do mark as accepted answer if this helps...
Riddhi ValechaPosted May 20, 2013, 1:05 AM
I have taken 2 tables...
1)TBL_USERS where Username is PK - not null and unique.
2)TBL_ATTENDENCE- where intime and outtime are inserted.
---------------
I have made a login page... where Username and password are verified...
If the login is successful, then in the TBL_ATTENDENCE Table, the intime and outtime are entered.
-----------
If this helps you, mark the answer as accepted...
ram zyPosted May 18, 2013, 4:30 AM
Riddhi ValechaPosted May 16, 2013, 6:09 AM
If you have any other issues in understanding the code, do let me know...
ram zyPosted May 8, 2013, 4:03 PM
ram zyPosted May 8, 2013, 4:03 PM
Jay SPosted May 8, 2013, 3:10 PM
Riddhi ValechaPosted May 7, 2013, 7:32 AM
You can do it using MSAccess or Visual Studio