Tutorials

This tutorial is part of Database Programming Made Easy Series.

If you're using CheckBox before in Visual Basic 6.0, you will find in this tutorial on how easy it is to bind a CheckBox control in VB .NET.

I am using Datasets and Data Adapters to connect to our database.

Some times we need some random unique number for solving some problem.For this purpose we can generate unique number by using GUID The following codes will generate a unique number Dim UniqueNumber As Guid UniqueNumber = Guid.NewGuid Response.Write("
" & UniqueNumber.ToString) About the author:

[inline:DataGridView Control.jpg=How to Bind Data to the Windows Forms Datagridview Control] The DataGridView control provides a customizable table for displaying data. The DataGridView class allows customization of cells, rows, columns, and borders through the use of properties such as DefaultCellStyle, ColumnHeadersDefaultCellStyle, CellBorderStyle, and GridColor. (Source: MSDN)

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

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;"

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‘

Recently we were working on Barcode application and want details of the Barcode mechanism like how the barcode works, what are the different types of barcode, which one is better for which condition and other important questions by googling we got the following website which are providing efficient information to deal with these type of issues

Trick #1 Delete a selected row from a DataGrid using c# Double click the dataGrid and write the code private void DataGridvie_selected(Object sender,EventArgs e) { DataSet da=new DataSet(); int i=datagrid1.selectedIndex; int empidval=ds.Tables["emp"].Rows[i][0].ToString(); SqlConnection conn=new Sqlconnection("conn string"); conn.Open();

In windows desktop application it is easy to print a form data for report or other purpose but in asp.net web form it is not easy to print a page. The printing on client side needs solutions for different conditions using JavaScript The simplest way to print a web form is to use client side JavaScript. To print a web page, you can use code like this:

This tutorial is part of Database Programming Made Easy Series.

With few modification from the previous tutorial you will learn how to fill combo box with data.

I am using Datasets and Data Adapters to connect to our database.