Submitted by: 
We can customise the way a GridView look by using Item Template, we can use in our own convenience Steps: 1). In our example we are using Northwind Database, table Employees 2). use the following SQLDataSource <asp:SQLDataSource ID="DS1" Runat="Server" SelectCommand = "Select FirstName, LastName, Title, BirthDate from Employees"
Submitted by: 
Just to let you know that the update of Hotel Reservation System (VB.NET) version is on the way. This update includes an important features and bug fixes. I focus more on the reports of this program so you will understand how crystal reports works on Visual Basic .NET. These reports includes but not limited to the following: Accounts Receivable Check In Guest Check Out Due Reservation Folio Guest...

How to Show IP Address On Your Local Computer

Language: 
.NET

This video tutorial will teach you on how to show IP Address on your local computer using Visual Basic 2008.

The video will walk you through on how to add a Label, TextBox, and Winsock control on windows forms. It then add a line of code in code editor window to display the result in a TextBox control.

Taxonomy upgrade extras: 

How to Create Installation File

I received a lot of question through email and comments system so I decided to include this in my FAQ section.

If you are familiar with the language you are using most probably you already know the built in packages. In Visual Basic 6.0 there is an add-in that you can use to create an installer. This can be found under the Add-ins menu >> Add-In Manager then loading the...

Language: 
Stored procedures are series of SQL statements grouped into a single unit, we can pass parameters to the stored procedures same like the passing parameters to the functions Simple stored procedure USE [databasename] GO /****** Object: StoredProcedure [dbo].[user_insert_mycomment] Script Date: 11/19/2008 22:45:11 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO
Submitted by: 
We can use the Datasource control with MySQL, for this we have to require two things. This can be done without writing any codes,simpy we have to assign the ConnectionsString in the SQLDataSource control. the string will be like that DS1.ConnectionString="Driver={MySQL ODBC 3.51 Driver};server=YourServerIP;database=" & _ "YourDB;user=YourUID;pwd=YourPWD;option=3;"
Submitted by: 
Another source code for enrollment system. Features included: Data entry New and old students Professor Subjects Laboratory type Creation of courses Prospectus. Transactions Assessment Adding/Dropping of subjects Grading System Encoding of Grades Evaluation Report Card Transcript of Records
Submitted by: 
Complete enrollment system with administrator, registrar, accounting and faculty account. Print report using Data Report built with visual basic 6.0. No need crystal reports.
Language: 
We have 4 types of Exceute methods, through which we can excecute the quries angainst Database. 1). ExecuteNonQuery(() 2). ExecuteReader() 3). ExecuteScalar() 4). ExceuteXmlReader() 1). ExecuteNonQuery(() Explanation: Executes a command but does not return any value or output usage conditions: UPDATE, INSERT, DELETE statements using System; using System.Data;
Submitted by: 
Always forgot to remember one query. So for them only Below query you can any table, stored procedure or views who ever have that expression as a column or object name. SELECT * FROM SYSOBJECTS WHERE ID IN (SELECT ID FROM SYSCOMMENTS WHERE TEXT LIKE ‘%PRODUC%’) The query produced all the object names. where ever it finds expression like ‘PRODUC‘

Pages