What version of ASP.NET? 1.0, 1.1, 2.0, or 3.0... each has different security levels/requirements/restrictions unique to its code level.

For 2.0 :...

You could also place this "connection" in a Web.config file, for security purposes...

And to be sure... what version of ASP.NET are you speaking of? .Net 1.0, 1.1, 2.0, 3.0 ?

2.0 Tutorial:...

The Answer to your very question about .. "How do I prevent direct access to the Default.aspx via URL entry..." is found in this very thread...



Found here: ...

This is done in your code prior this statement. This is "validation" is done when you pass the username/password into the DBConnection Function:


...
If DBConnection(txtUserName.Text.Trim(),...

Hey Benbujwah,

If you did do the CUT and PASTE with Visual Web Developer Express, then that is the cause of the error. This code is for .NET 1.0 or 1.1 ONLY and not .NET 2.0 (which is what Web...

No worries Rich,

Good question. See page 2 of this tutorial on how to do just what you asked.

http://www.daniweb.com/techtalkforums/thread19303-2.html

The error states Object not declared.... On Line 41 and Char 3. Where is that in your code?

Provide the text from the error message you took a screen shot of, this will help us narrow things...

Remember that this code is running on the web server in a process that is not running as the currently logged on (to the server) user. Therefore the process will be running under its own Window...

Good points nikkiH!

One thing that can be done as well is to retrieve the date/time from the database as stored and use the parse/format methods in ASP.NET to produce the desired output.

...

Not a dabbler in mySQL setups...but thought this may be helpful

http://www.interworx.com/support/docs/iworx-cp/sysadmin/system-services/mysql/howto-mysql-options

Could you not test in a logic statement if the row count is not > 0 than ignore?

How have you setup SQL? It sounds like you have it setup as Windows Authentication and NOT mixed mode.

You will have to add your ASP.NET user to the sql authenticated users.

Couple of questions:

What framework are you running for IIS?
Is the directory of the application a Virtual Directory?
Do other ASP.NET application have the same problem? (i.e. a simple Hello...

Also try looking at some of the tutorials and posts about Login pages, etc on Dani Web as they contain good examples of searches from values entered into a textbox.

<appSettings/>
<connectionStrings>
<add name="pubsConnectionString1" connectionString="Data Source=P4C800E\SQLEXPRESS;Initial Catalog=pubs;Integrated Security=True"
...

A search is bascially a query in the most basic sense. i.e. SELECT title FROM books WHERE author = "King, Stephen"

So the questions become;

What are you wanting to do for the search?
...

Appears to be up and running again

Hi Mike,

Visual Web Develper or Visual Studio 2005 is in ASP.Net 2.0 and not 1.1. So some modification of this code would need to be done, as there are some differences which makes this code...

Hi Mike,

I would review the tutorial section at the top of this thread for the step by step procedure, but bascially the imports are placed at the top of the code behind page or top of the script...

Here is a link.. (http://sqlserver2000.databases.aspfaq.com/what-are-reserved-access-odbc-and-sql-server-keywords.html)

NOTE: Access is not inclusive of the JET engine. So for a full...

This is correct. But as an aside, it is not good practice to use the LIKE clause for something like a staffID, which should be unique or a primary key.

But that depends on the application and...

pseudo_code:

Dim strSQL as String

strSQL = "SELECT Field1, Field2 FROM tbltemp WHERE Field1 = '" & TextBox1.Text & "'"



Hope this helps.

Hi there,
I have given you the tools to do this. Give it a try and if you have specific problems I will help you with it. The code to do this is right there in the links I provided.

Another...

Hi there glad I could help.

At the start of this thread, page 1, there is the steps to using a store procedure (preferred methodology) for this.


CREATE PROCEDURE sp_ValidateUser /*...

Understood, but without the Number column it is a very complex means of determining the row number of a record in a table. Why? Several reasons. First of all, remember, a SELECT statemet or...

Patience!

Also, we are not here to do your work for you, the general edicate here is to state the question / problem and provide the work you have tried to to solve it but have been unsuccessful....

Well, as I originally stated you are seeming to already be grabbing the row number in your select statement!

Note the changes in red to your code to get the "number" from the select statement.
...

What do you have for Imports in this Class?

Are you wanted the Number from your select statement criteria?

Because if the is the case then simply put:


label1.text = kisiler.GetValue(0)
' Where 0 represents the first colum or
' ...

This may sound strange, but have you reinstalled Web Matrix and what version of .Net framework are you running? Have you reinstalled the .Net framework?

As you wanting to store this in the Database?

You could us an old CGI standard? Or you could do something like this website shows (writing to a text file).
...

Here is a link to doing in Visual Basic.NET, so you will have to make some modifications to this inorder to make it work.

http://msdn2.microsoft.com/en-us/library/ms162203.aspx

Hi there

You dont need this: RETURN @Num_of_User a select statement by default returns a value already.


And you don't require this:
objReturnParam =...

What you are doing is still not correct. You are passing a Select Command Object a Create Table Statement and then trying to fill a dataset (a SELECT query result set, which you are not doing) with...

Sure, use the SQL statements in the Store Procedures in the code_behind, just like you would any other SQL statement.

Dim sqlstring as String = "SELECT Count(*) FROM tblUsers WHERE...."

Hope...

In the ASP.NET page do something like this

(Assuming your data entry for date is a calendar).. it is the principle / logic here that matters.. not the methods

Session("Date") =...

The theme denotes Windows XP campkev.

An issue like this, doesn't always require Install and reinstall of IIS, but rather a reinstall of .NET framework.

But glad you figured it out.

Agreed.

What is the issue exactly? Have you verified the security access on the IIS of your client machine? Security, and permissions are usually the first thing to consider.

Please provide more details. Innately you can edit an SQL statement inside the IDE. But are you meaning when the SQL statment is in the code / code behind?

What needs to be added:

' |||||||||||||||||||||||||||||
' ||||| PALADINE"S CODE |||||
' |||||||||||||||||||||||||||||
Dim...