ASP.Net - The Scripts Library Community

Create Hit Counter using C#

payment@lebmailer.com (Feras) — Fri, 19 Jun 2009 21:44:19 +0000

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

ferasc@hotmail.com (Feras) — Mon, 15 Jun 2009 00:23:42 +0000

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#

info@scriptslibrary.net (Administrator) — Sat, 13 Sep 2008 21:26:41 +0000

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

info@scriptslibrary.net (Administrator) — Sat, 06 Sep 2008 22:05:23 +0000

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

ferasc@hotmail.com (Feras) — Sat, 06 Sep 2008 18:57:26 +0000

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.