GridView With an ItemTemplate
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
Hotel Reservation System Report Update
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
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.
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 Package and Deployment Wizard.
Using Stored Procedures with ASP.NET
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
Datasource control with MySQL Datasource control with MySQL
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;"
SMCM Enrolment System
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
Enrollment System
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. Related source code: Enrollment System v1.0 using VB.NET
Execute Commands Methods: How to use it?
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;
Search an object in Dababase
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‘