ASP.NET VB Tutorials

New Website -Shefeek Jinnah

2009-01-26T01:50:00.001-08:00

My name is Shefeek Jinnah.I am a Software Engineer by profession.I completed my graduation from Mar Athanasious College Of Engineering,Kothamangalam,Kerala in the year 2008.Coding is my passion and technical expedition is my pursuit.

I have been writing technical blogs for the last few years.But i find myself difficult in managing all the blogs and communities.So i decided to combine all my blogs and keep it under a single roof and here it is.The intention of this website is to share information so that it will be useful for me as well as for the visitors.I will post everything technicaly that goes through my head daily and which i am involved in.

I offer free technical assistance though the discussion forum of this website.You can ask me for any technical assistance.I will provide you with enough information if it is within my range or i can get you the details soon after consulting with my senior’s

http://www.shefeekj.com/

Data Insertion

2007-06-16T23:46:00.000-07:00

In this chapter let us examine how to insert data into a table from a webform

Suppose we have a text box named 'sname' and a button named 'insert' .Our aim is to
insert  the value in the text box to the table named 'reg' when the button is clicked

steps

1.Establish the connection
2.Double click on the button

                 Since the event is to happen when the button is clicked,the code for insertion should be written below buttons click event heading.When you double click on the button,you will be guided to this location

Code
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click                              (No need to write the above line.It will be there)

con.open()
  //open the connection
cmd.CommandType = CommandType.Text
cmd.CommandText = "insert into reg values('" & Me.sname.Text & "')"

                                                                   //code to insert
cmd.ExecuteNonQuery()
con.Close()

Basics of coding

2007-06-15T10:54:00.000-07:00

Basics of coding

Code to establish Sql Connection

imports system.data.sqlclient // importing class library

dim con as new sqlconnection("server=.;uid=sql userid;pwd=sqlpassword;database=databasename")

'con' means connection name(You can give any name)

Code to declare an sql command

dim cmd as new sqlcommand("",con)

Code to declare sqldata adapter

dim ada as new sqldataadapter(cmd)

Code to declare datatable & dataset

dim dt as new datareader
dim ds as new dataset

Code to declare datareader

Dim dr As SqlDataReader

***We are not creating a new datareader..so there is no 'new' command in the above code

Where to write this code

Creating database using Sql server 2000

2007-06-15T09:44:00.001-07:00

Creating database in sql 2000 is a very simple process.You can do this in two ways

By using Query analyzer

1.Take start>All programs>Microsoft sql server>query analyzer

2.Give userid and password of sql server that you set during installation
   Tick the box "Start sql server if stopped"

3.Now you can write the queries to create tables and database in the white part.

4.To execute the query..select the query and press f5.

Using Enterprise manager

1.Take start>all programs>Microsoft sql server>Enterprise manager
2.On the left panel select   Microsoft sql server>sql server group>(local)(windows NT)
3.To create new database ,right click on the database and there is an option to create new    database there.
4.To create a new table ,select the databae name>Right click on tables >New table

5.A new pop up window will open.On that window give the necessary column names and datatypes

Creating auto incrementing columns

Autoincrementing columns are columns whose value is incremented each time a new row is entered into a table .

This is useful for generating a unique id automatically for each entry.

Steps

1.ON the page design pop up window in enterprise manager.Create a new column

2.Make its datatype as int

3.On the bottom maket identity 'Yes'

4.Set identity seed and identity increment to your desired values .

Installing Sql Server 2000

2007-06-15T09:36:00.001-07:00

To Install SQL Server 2000 Basic Local Installation.

1.Insert the Microsoft SQL Server 2000 cd in your CD-ROM drive (if the compact disc does not run automatically, double-click Autorun.exe in the root directory of the compact disc), select SQL Server 2000 Components, and then select Install Database Server. Setup prepares the SQL Server Installation Wizard. At the Welcome page, click Next.

2.In the Computer Name dialog box, Local Computer is the default option, and the local computer name appears in the text box. Click Next.

3.In the Installation Selection dialog box, click Create a new instance of SQL Server, or install Client Tools, and then click Next. Follow directions on the User Information, Software License Agreement and related pages. In the Installation Definition dialog box, click Server and Client Tools, and then click Next.

4. In the Instance Name dialog box, if the Default check box is available, you can install either the default or a named instance(the default user name is 'sa'). If the Default check box is not available, a default instance has already been installed, and you can install only a named instance. • To install the default instance, click to select the Default check box, and then click Next.

5 To install a named instance, click to clear the Default check box, type a new named instance in the Instance Name box(dont forget this username and password.This will be ther user id and password used to establish connection to the sql server from asp.net page), and then click Next.

6. In the Setup Type dialog box, click Typical or Minimum, and then click Next.

7. In the Service Accounts dialog box, Select Local machine and click next(If you are using sql server to create databases directly on your web domain,then give your user id and password in this step)

8. In the Choose Licensing Mode dialog box, make selections according to your license agreement, and then click Continue to begin the installation. In the Setup Complete dialog box, click Yes, I want to restart my computer now, and then click Finish.

IIS Errors-Unable to debug

2007-06-15T04:17:00.000-07:00

If you installed IIS after installing dot net framework,then you wont be able to debug the project in visual studio...

Reason
The IIS is not configured with asp.net .Simply IIS dont know what is asp.net..SO we will have to link IIS with our dotnet framework.

Solutions

First Solution

1.Take start >Run
2.Copy the code below and press Ok

"H:\WINDOWS\Microsoft.NET\Framework\v1.1.4322\aspnet_regiis.exe" -i

Replace 'H' with the drive in which your windows is installed.
Replace v1.1.4322 with the version of your dotnet framework

Trouble shooting --->If this is not working the take search and search for the file aspnet_regiis.exe ....If found copy its address,compare it with the code above and rewrite the code...DOnt forget to write '-i' at the end

Second Solution

If you dont understand the first solution then simply reinstall dotnet frame work

It will be in the Visual Studio Prerequisite CD....No need to reinstall entire Visual Studio

If you have any doubt mail me at shefeekj@gmail.com

Visual Studio 2003 & 05

2007-06-15T03:57:00.002-07:00

The first head ache i found is installing visual studio as it is a bit lengthy process...Visual studio needs some prerequisites..So we can install Visual Studio only after installing the prerequisites....The prerequisites includes

Internet information service(IIS) with front page extension

1.Go to control panel.Switch to classic view if you are not in classic view
2.Take add or remove programs.
3.Take add/remove windows components from the left panel.
4.Tick Internet Information Service from the list.
5.Highlight IIS and click Details link in the bottom
6.In details page tick all the options and click OK.
7.Click Next...and the components will start installations.Insert WIndows XP Cd when its asked for..

Other Prerequisites(Dot net framework)

1.Put Visual studio cd no :1
2.It will check for the prerequisites .
3.Insert the prerequistes cd when asked for.
4.Follow the instructions .(Simple steps)

Introduction

2007-06-15T03:49:00.000-07:00

                                    Hi Friends......I would like to give a small introduction for this blog here....I am now coding in asp.net using vb as scripting languange..I found this stream very interesting and powerful....So i thought of sharing my experience and the solutions for situation where i found myself stuck while coding in asp.net.Hope this will be useful for others...........

                    This blog is not perfect..This is upto my knowledge and experience.If you find any error please let me know..I dont know much about the scientific way of programing and all.And i dont know much about the theory like 'why it is like this'  .But i can assure that the codes  will work....

If you find this blog helpful please let me know.Waiting for your criticism and suggestions

                                                                         Yours Faithfully

                                                                          Shefeek Jinnah                                                                           shefeekj@gmail.com