Database

Question

create table Credentials(FirstName varchar(20),Lastname varchar(20),UserId varchar(40),Password varchar(50),Retypepassword varchar(40)) insert into credentials('Pavan','Bujji','Pavan@gmail.com','$pavan','$pavan') This is mY table.when i enterd password and retype pswrd ..it shows error like   Incorrect syntax near ')'...y doed it come ..plz help me..how do i write query for that table..   Thank You, Pavan.

Ravi Patel · Answer

Hi ,   try this   insert into credentials(FirstName ,Lastname, UserId,Password,Retypepassword) values ('Pavan','Bujji','Pavan@gmail.com','$pavan','$pavan');

Sourabh Somani · Answer

.Aspx Code -------------------- ________________________________________________ ASPX.CS Code on Page Load -------------------------------------------------------  private void page_load(object sender system.eventargs e) { if(Request.Form["username"]!=null) { var username = Request.Form["username"]; var password = Request.Form["password"]; //Provide SQL Queries Here } }

Pavan Bujji · Answer

pavangaddirala@gmail.com     if u dont mind,can u send me to this ?.. how to write the code to login by usinh HTML controls..?..    thankq boss..

Sourabh Somani · Answer

Give me your mail ID I Will send you

Pavan Bujji · Answer

can u give the code to that ..plz..

Sourabh Somani · Answer

use server side or asp control textbox or label or button
if you want to do this work by using html control you can but you have to use ajax and jquery
thanks
and plzzz accept my answer if it helps you
:)

Pavan Bujji · Answer

Hello boss..do u know how to convert html to asp controls..i know if add a attribute runat="server"..?..in that form we have login..how to write the code for login by using html controls..if i click on the login it is not redirecting to C# file..it is redirecting to aspx code..how to be..

Pavan Bujji · Answer

Thank you boss ..it was silly mistake by me

Sourabh Somani · Answer

Please see your insert query  your query is insert into credentials('Pavan','Bujji','Pavan@gmail.com','$pavan','$pavan');   you have missing values there insert into credentials values ('Pavan','Bujji','Pavan@gmail.com','$pavan','$pavan');    Thanks in advance