another help here
-
Hello There again i guess, can you help me w/ this.i look for some example of validating a username and password in a database on the internet..well looking for some tutorial instead,i found one and copy it, i follow the instruction, but i dont get it..maybe im a slowlearner,there are instrcution that i dont get it.. here are the instructions Pre-Code Setup: 1. Create a New ASP.NET Web Application. I called mine NorthLogin2 2. Rename the default aspx Webform to Login or Index or something more descriptive. I called mine Login2.aspx 3. Assuming you are in Visual Studio.Net right click on this form in the Solution Explorer and Select Set as Start Page. 4. Find your Northwind.mdb file (The classic Northwind Database in Access) Under Tools, Options, Tables/Queries Tab select Run Permissions as Owner's 5. Create a new table for login requirements. I called mine tblUser Columns U_id (autonumber), U_Name (text), and U_Password (text with Input Mask of Password) 6. Create Query (i.e. Stored Procedure) to validate login(s). I called mine sp_ValidateUser In the SQL Designview the code for that query is SELECT COUNT(*) AS Num_of_User FROM tblUser WHERE (((tblUser.U_Name)=[@UserName]) AND ((tblUser.U_Password)=[@Password])); This query counts the number of users that it retrieves which matches the where clause. The @UserName and @Password are the values passed in to the query from the Webform. 7. Close database, because you can not access it while it is open. -----------END --->in the ff. instruction i already done the instruction # 1-5..im confused about #6..would you help me with that..coz there are no instruction, i dont know how to put COUNT* on the query at MS ACcess,i tried to create in a "Create Query in Design View" but where should i found COUNT(*)??im not that expert in MS Access and SQL.. -->what does API mean?. -->well theres another one...along with the tutorial is said that "This is sample code for a ASP.Net Login page (using Visual Basic.Net code behind) with OleDB connection to an Access Database using ADO.Net."..it means whenevr you bulid or creating asp.net with database access does it means that im also creating a Access database at ADO.net?? -->ok here is another one(sorry if im going to ask all the confusing question inside my head)..im also want to create a "Forum" web application that i will include in our website project...our team leader(only at our project)also my classm8 said that i have to used a "
-
Hello There again i guess, can you help me w/ this.i look for some example of validating a username and password in a database on the internet..well looking for some tutorial instead,i found one and copy it, i follow the instruction, but i dont get it..maybe im a slowlearner,there are instrcution that i dont get it.. here are the instructions Pre-Code Setup: 1. Create a New ASP.NET Web Application. I called mine NorthLogin2 2. Rename the default aspx Webform to Login or Index or something more descriptive. I called mine Login2.aspx 3. Assuming you are in Visual Studio.Net right click on this form in the Solution Explorer and Select Set as Start Page. 4. Find your Northwind.mdb file (The classic Northwind Database in Access) Under Tools, Options, Tables/Queries Tab select Run Permissions as Owner's 5. Create a new table for login requirements. I called mine tblUser Columns U_id (autonumber), U_Name (text), and U_Password (text with Input Mask of Password) 6. Create Query (i.e. Stored Procedure) to validate login(s). I called mine sp_ValidateUser In the SQL Designview the code for that query is SELECT COUNT(*) AS Num_of_User FROM tblUser WHERE (((tblUser.U_Name)=[@UserName]) AND ((tblUser.U_Password)=[@Password])); This query counts the number of users that it retrieves which matches the where clause. The @UserName and @Password are the values passed in to the query from the Webform. 7. Close database, because you can not access it while it is open. -----------END --->in the ff. instruction i already done the instruction # 1-5..im confused about #6..would you help me with that..coz there are no instruction, i dont know how to put COUNT* on the query at MS ACcess,i tried to create in a "Create Query in Design View" but where should i found COUNT(*)??im not that expert in MS Access and SQL.. -->what does API mean?. -->well theres another one...along with the tutorial is said that "This is sample code for a ASP.Net Login page (using Visual Basic.Net code behind) with OleDB connection to an Access Database using ADO.Net."..it means whenevr you bulid or creating asp.net with database access does it means that im also creating a Access database at ADO.net?? -->ok here is another one(sorry if im going to ask all the confusing question inside my head)..im also want to create a "Forum" web application that i will include in our website project...our team leader(only at our project)also my classm8 said that i have to used a "
-
Hello There again i guess, can you help me w/ this.i look for some example of validating a username and password in a database on the internet..well looking for some tutorial instead,i found one and copy it, i follow the instruction, but i dont get it..maybe im a slowlearner,there are instrcution that i dont get it.. here are the instructions Pre-Code Setup: 1. Create a New ASP.NET Web Application. I called mine NorthLogin2 2. Rename the default aspx Webform to Login or Index or something more descriptive. I called mine Login2.aspx 3. Assuming you are in Visual Studio.Net right click on this form in the Solution Explorer and Select Set as Start Page. 4. Find your Northwind.mdb file (The classic Northwind Database in Access) Under Tools, Options, Tables/Queries Tab select Run Permissions as Owner's 5. Create a new table for login requirements. I called mine tblUser Columns U_id (autonumber), U_Name (text), and U_Password (text with Input Mask of Password) 6. Create Query (i.e. Stored Procedure) to validate login(s). I called mine sp_ValidateUser In the SQL Designview the code for that query is SELECT COUNT(*) AS Num_of_User FROM tblUser WHERE (((tblUser.U_Name)=[@UserName]) AND ((tblUser.U_Password)=[@Password])); This query counts the number of users that it retrieves which matches the where clause. The @UserName and @Password are the values passed in to the query from the Webform. 7. Close database, because you can not access it while it is open. -----------END --->in the ff. instruction i already done the instruction # 1-5..im confused about #6..would you help me with that..coz there are no instruction, i dont know how to put COUNT* on the query at MS ACcess,i tried to create in a "Create Query in Design View" but where should i found COUNT(*)??im not that expert in MS Access and SQL.. -->what does API mean?. -->well theres another one...along with the tutorial is said that "This is sample code for a ASP.Net Login page (using Visual Basic.Net code behind) with OleDB connection to an Access Database using ADO.Net."..it means whenevr you bulid or creating asp.net with database access does it means that im also creating a Access database at ADO.net?? -->ok here is another one(sorry if im going to ask all the confusing question inside my head)..im also want to create a "Forum" web application that i will include in our website project...our team leader(only at our project)also my classm8 said that i have to used a "
Dear blitz2bleach, 1. Regarding your Count(*) problem : Just check your MS access editor or what you say MS access Quesry designer you can get the Count function somewhere in Function(s) 2. API is nothing but Application Programming Interface. Just method and properties of class that you can use while developing an appliation.
Thanks, Arindam D Tewary