I see so there is no other way to connect it is by ASP/ASP.NET/ADO/AJAX?am I right?so if I used some of this language my file extension should be .asp..instead of .html or .js?if I used ADO?

I am currently doing some project and I think Im going crazy. I am developing an online video rental using JavaScript, and actually has a database on it..Can I ask aside from ASP..what should I used to make a connection string,I am using a MS Access 2007 as database?where should I put it on my HTML/JavaScript file if you can give me a hint about making a connection string? it is possible to use database with pure HTML/Javascript file aside from asp?pls help me :( thanks!

Well, thanks. But if it is possible to include it inside "response.write" object?..How? Thanks..

Can anyone tell me if it is possible to have a drop down menu that contains the selection of time.for example from 12:01 AM to 11:59 PM? thanks for your answer..

what i mean is that it is important to have this in a form?? what if i have a log in controls?do i have to used postback?? in my question is redirect forms alsways denotes ?(question mark symbol)..and this symbol is always seen whenever i browse on the net.. what would be the most commonly used form attribute,, thanks

there are Microsoft Access jet provider and SQLOLEDB(?) provider when there have connection string..and each of these two have a different have a different header file and and command and keyword how about SQLEXPRESS??what will be the appropriate header file and keywords?would it be the same as SQLOLEDB provider??

my question is what is commonly used the redirect form or postback form?? what is the used of two in asp.net...do i have to include it anytime?in my web form?

If my Data Source is Microsoft Access Database File (OLE DB) iLL USE ALL oleDB cOMMAND AND IF sql SERVER,sqL COMMAND LIKE sQLcONNETION IS ONE OF THE KEYWORD USED TO CONNECT TO DATABASE iM USING SQL SERVER 2005 EXPRESS,THE COMMAND WOULD HAVE BEEN THE SAME TO SQL COMMAND LIKE sql

DataSource=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database.mdf;Integrated Security=True;User Instance=True

IN THIS CONNECTION STRING CAM I ACCESS IT,IN SQK COMMAND LIKE "SQLcoNNECTION" FOR AN ASP.NET DEVELOPER,WHAT WILL BE THE EASIEST DATA SOURCE CONTROL? -IN ASP.NET ADMINISTRATION TOOL,ASPNETDB.MDF DATABASE CREATED INSTANTLY IN A DATABASE EXPLORER...IF IM GOING TO ACCESS MY OWN DATABASE AND NOT THE ASPNETDB.MDF,CAN I SET UP A MEMBERSHIP,ROLES AND PROFILE? CAN YOU GIVE THE HINT..CAN I ACCESS ASP.NET ADMINISTRATION TOOL AND SET UP A MY ASP.NET WEBSITE TO CREATE PROFILE,ALLOW ADMNISTRATOR AND USER, DENY ANONYMOUS USER?THAT MY WEBSITE CAN BE SECURED EVEN WITHOUT THE USING THE ASPNETDB.MDF ONCE AGAIN THANKS FOR THE ANSWER.

-->We been doing our first website,"Security Web Control" like "Log In" "login view" are the most commonly used in asp.net. if our security web control composed only on a html control,what will be the difference?we were not able to set up a Membership role and profile in ASP.NET Website Administration Tool ?becuase we manually make our original "Security web control".. -->and why always aspnetdb.ndf is always a default database? what if we make our database using MS Access?can we access it or make it a default website in a ASP.NET Website Administration Tool?now can it b done? what are the alternatives way to used if im not going to used a ASP.NET Website Administration Tool? to set up membership?... -->When im modifying a connectiom of the database(in a database explorer In Visual Web Develper)?im only used the Microsoft Access Database File (OLE DB) native Jet Provider and Microsoft SQL Server Database File (SqlClient)-(a mircosoft Server Instance including MS SQL express)..but in other provider,the "servername" always ask, and when i type the server name,im only got error like when i modified connection MS SQL Server(Connect to Microsoft SQL Server 2000 and 2005)... Im always modified the server name in the SEt Up Wizard using aspne_regsql but i always got err0r.. Hope all my question can clearly answred Thanks for always helping....

like any other tutorial, i been set up for a see how to add the membership-related schemas to an existing database using the ASP.NET SQL Server Registration Tool (aspnet_regsql.exe). ive run the command aspnet_regsql.exe..asking for my server name and there are drop down list for the database,but when i click the drop dowm list,it will take a while when an error msg has appeared,on my second attempt. i didmt click the database drop down list instead the button "Next" the one i clicked, now "Setting SUmmary" has appeared and when i click "Next" button it will take a while and the error msg has been appeared sayinf this:

Setup failed.

Exception:
Unable to connect to SQL Server database.

Details of failure

System.Web.HttpException: Unable to connect to SQL Server database. ---> System.Data.SqlClient.SqlException: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Connect(Boolean& useFailoverPartner, Boolean& failoverDemandDone, String host, String failoverPartner, String protocol, SqlInternalConnectionTds connHandler, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject, Boolean aliasLookup)
at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
at System.Data.

I been thorugh many website to search "Forum Web Application"(that has thread for new msg.),but i didnt find about it.. my question is what is the best to use data control or web control When Im using Visual Web developer2005 to develop a "Forum" application.... thanks for your answer....

Hello there,i just want to know that it is possible in the website that a asp.net pages and Master pages could be together in a website??for example,the default page would have been the aspnet.aspx..and one of the links/navigation in my aspnet.aspx is the master page i created.. Ive done it lately but it couldnt work,that my deefault page has a link to the master page..could anyone tell me how to make a masterpage become a link in default website page? thanks 4 helping...:)

hello there,i know its not the righ place to ask some query,im cannot access my database in a query pane..i made a database where the username column has value and the password has none for e.g Username:93838383 and password:?..i just want to update the password column inputed by the user I make the query in the stored procedure but the error said: "Incomplete SET clause..unable to parse query text" i just want someone to check out the query and pls tell me what wrong or incomplete to my query UPDATE UserTable SET ((UserTable.[password] = [@password]) WHERE ((UserTable.username = [@username]) another thing is whenever the user visit the site,when the user type the password,it could not be updated anymore..unless i just want to use "select clause" because password column have now values... here is the query SELECT COUNT(*) AS Num_of_User FROM UserTable WHERE (((UserTable.username)=[@username]) AND ((UserTable.pasword)=[@password])); error:unable to parse query text it is correct query for accessing the values from the database? Im using a visual web developer IDE, i dont think if im using a sqlserver 2000 or 2005 thanx for helping

hello there,i know its not the righ place to ask some query,im cannot access my database in a query pane..i made a database where the username column has value and the password has none for e.g Username:93838383 and password:?..i just want to update the password column inputed by the user I make the query in th stord procedure but th error said: Incomplete SET clause..unable to parse query text i just want someone to check out the query and pls tell me what wrong or incomplete to my query UPDATE UserTable SET ((UserTable.[password] = [@password]) WHERE ((UserTable.username = [@username]) another thing is whenever the user visit the site,when the user type the password,it could not be updated anymore..unless i just want to use "select clause" because password column have now values... here is the query SELECT COUNT(*) AS Num_of_User FROM UserTable WHERE (((UserTable.username)=[@username]) AND ((UserTable.pasword)=[@password])); error:unable to parse query text it is correct query for accessing the values from the database? im using a visual web developer IDE thanx for helping

-i wonder how to be a "Root Admin" "Administrator" and etc...user,could it be in the Asp.net Website Administration tool?if it is.how can it be done?how can i deny simple user or anonymous user to access all the file in the database? -another is,could it be possible that i can create a database where the username column have now values and the user will decided for its own password for security?can be possible..for example my username stored in the database and i will sign up for its password,that will directly store in the database...and whenever i visited the site,i can now access the site... --Just like myspace and other website that the user has its own "my settings"where the own user has its own control to his page..where to make it?could i be used "master page"???How can it be done??im thinking of a 1 default page or default.aspx web form,that every user default page whenever the user visit the website? does anyone would tell me how can it be done?? --im using a visual web developer and asp.net 2.0 to build the website,what could be the most precised website for that rather than codeproject for more tutorial?? --thanks for the answer

-i wonder how to be a "Root Admin" "Administrator" and etc...user,could it be in the Asp.net Website Administration tool?if it is.how can it be done?how can i deny simple user or anonymous user to access all the file in the database? -another is,could it be possible that i can create a database where the username column have now values and the user will decided for its own password for security?can be possible..for example my username stored in the database and i will sign up for its password,that will directly store in the database...and whenever i visited the site,i can now access the site... --Just like myspace and other website that the user has its own "my settings"where the own user has its own control to his page..where to make it?could i be used "master page"???How can it be done??im thinking of a 1 default page or default.aspx web form,that every user default page whenever the user visit the website? does anyone would tell me how can it be done?? --im using a visual web developer and asp.net 2.0 to build the website,what could be the most precised website for that rather than codeproject for more tutorial?? --thanks for the answer:) -- modified at 2:18 Saturday 10th March, 2007

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 "

im doing a samle project that i want to include in my project.. here is the sample code... <%@ Page Language="VB" AutoEventWireup="false" CodeFile="Default.aspx.vb" Inherits="_Default" %> <%@ Import Namespace=System.Web.HttpException %> Northwind Database Login Sub doInsert(Source as Object, E as EventArgs) Dim strConn As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & _ Server.MapPath("C:\Documents and Settings\Joy.PHOENIX-1D0486C\Desktop\userId.mdb") & ";" Dim MySQL as string = "Insert into Members (uid, pwd, fullname, email) " & _ "Values (@uid, @pwd, @fullname, @email)" Dim MyConn As New Data.OleDb.OleDbConnection(strConn) Dim Cmd As New Data.OleDb.OleDbCommand(MySQL, MyConn) With Cmd.Parameters .Add(New Data.OleDb.OleDbParameter("@uid", frmuid.Text)) .Add(New Data.OleDb.OleDbParameter("@pwd", frmpwd.Text)) .Add(New Data.OleDb.OleDbParameter("@fullname", frmfullname.Text)) .Add(New Data.OleDb.OleDbParameter("@email", frmemail.Text)) End With MyConn.Open() cmd.ExecuteNonQuery() MyConn.Close 'Put a label on your page to contain the 'success' response: lblMessage.Text = "Thank you for signing up. An email will be sent to you shortly." & _ "Your response will be needed from that email to activate your account" End Sub

uid

pwd

fullname

email

hello there,again i need ur help..if i can access the data in mydatabase,lyk entering the correct password and username.how can i code opening new window when this data is correct?.i put a code in

and in the button tag asp:button PostBackUrl="index.aspx",the question is the following attributes in the tag given can affect direct opening new window when the corrct Username and Password is correct?...should i used method="get" in form tag/what is the difference between the "GET" and "POST"?what is commonly used form attribute?thankx 4 helping:) Im A nEWBIE programmer

well thank you..and the password i put is just a sample..im not that stupid..thanks again...:)