ASP.Net - The Scripts Library Community

Create Hit Counter using C#

2009-06-19T21:44:19Z

A simple Hit Counter function that will count how many visitors your website has reached. This function uses the StreamReader to read from a text file located in the root folder of your application, adn the StreamWriter to write into this file.

First, create a text file, name it as txtcounter.txt, and place it in the root folder or your application.
The GetStat() function will return the latest updated from the text file, and write new stat to it:

Upload Microsoft Word file using ASP.NET

2009-06-15T00:23:42Z

Normal 0

This function allows you to upload a Microsoft Word file and put it on the server using ASP.NET.

Normal 0 Add the following controls to the aspx file, inside a form tag:

Read Write With Cookies Using C#

2008-09-13T21:26:41Z

Cookies are widely used in majority of web applications. They are used in login forms, shopping cart, or simply to track users. This example demonstrates how to write, read values using a cookie using C#.

{CODE brush: cpp;}
//To Write to a cookie

HttpCookie userCookie;
UserName="admin";
userCookie = new HttpCookie("UserName") ;
cookie.Values.Add(UserName, UserName) ;
Response.Cookies.Add(userCookie);

// To read from a cookie

HttpCookie userCookie;
userCookie = Request.Cookies["UserName"];
String UserName = userCookie.Value;
{/CODE}

That's it!

Using parameters with MS Access

2008-09-06T22:05:23Z

This example illustrates the usage of parameters in asp.net with MS Access. It’s a simple sub that takes one parameter, first name, and print the Last name on the page.

{CODE brush: vb;}
<%@ Import Namespace="System.Data" %>

<%@ Import Namespace="System.Data.OleDb" %>

Sub Print_Last_Name (First_Name as string)

Dim conn As OleDbConnection

Dim strLastName As String

Dim cmd As OleDbCommand

conn = New OleDbConnection( "PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA Source=c:\users.mdb" )

strLastName = "Select LastName From users Where FirstName=? "

cmd = New OleDbCommand( strLastName, conn )

cmd.Parameters.Add( "@firstname", First_Name )

conn.Open ()

Response.write ("Home Phone Is " & cmd. ExecuteScalar ()

conn.Close ()

End Sub
{/CODE}

Connect ASP.Net to MySQL database

2008-09-06T18:57:26Z

MySql is a free open-source database server. Thus, many people would like to use it with in
ASP.Net pages to cut the cost of their projects.

It’s pretty easy to connect ASP.Net pages to MySQL database. First you have to have MySQL
database and the MySQL ODBC Driver.