Bind DropdownList with Data From SQL

Try these Examples to Bind DropdownList with Data from SQL Server with Two ways

First Example :

Step1 : Create new ASPX page and Drag DropdownList Control
Step2 : In Code behind of your Page create new method to Bind your Dropdownlist control and then in Page_Loag call your method

this is my method to Bind Dropdownlist control

public void Bind()
{
// Open the Connection
SQLConnection Con = new SqlConnection(ConfigurationManager.ConnectionStrings["Bag_ConnStr"].ConnectionString);
Con.Open();
// SQL Statement
string strSQL = null;
strSQL = "SELECT State_Name, State_Code FROM TableState ORDER BY State_Name";
// Command, Data Reader
SQLCommand Com = new SQLCommand(strSQL, Con);
SQLDataReader rdr = Com.ExecuteReader();
// Populate the Control
while (rdr.Read()) {
ListItem newListItem = new ListItem();
newListItem.Text = rdr.GetString(0);
newListItem.Value = rdr.GetString(1);
DropDownList1.Items.Add(newListItem);
}
}

protected void Page_Load(object sender, EventArgs e)
{
if(! IsPostBack)
{
Bind();
}
}

and in web.config file

<connectionStrings>
<remove name="Bag_ConnStr"/>
<add name="Bag_ConnStr" connectionString="Data Source=.;Initial Catalog=DataBase;Integrated Security=True" providerName="System.Data.SqlClient"/>
</connectionStrings>

Second Example:

Step1 : Create new ASPX page and Drag DropdownList Control
Step2 : In Code behind of your Page create new method to Bind your Dropdownlist control and then in Page_Loag call your method

this is my method to Bind Dropdownlist control

public void Bind()
{
SqlDataReader ddDR = null;
SqlConnection ddSqlConnection = new SqlConnection(ConfigurationManager.ConnectionStrings["Bag_ConnStr"].ConnectionString);
SqlCommand ddSqlCommand = new SqlCommand("SELECT Id,Name FROM Education_Level ", ddSqlConnection);
ddSqlCommand.CommandType = CommandType.Text;
ddSqlConnection.Open();
ddDR = ddSqlCommand.ExecuteReader(CommandBehavior.CloseConnection);
ddl_Education_Level.DataSource = ddDR;
ddl_Education_Level.DataTextField = "Name";
ddl_Education_Level.DataValueField = "Id";
ddl_Education_Level.DataBind();
}

protected void Page_Load(object sender, EventArgs e)
{
if(! IsPostBack)
{
Bind();
}
}

and in web.config file

<connectionStrings>
<remove name="Bag_ConnStr"/>
<add name="Bag_ConnStr" connectionString="Data Source=.;Initial Catalog=DataBase;Integrated Security=True" providerName="System.Data.SqlClient"/>
</connectionStrings>

Note : Don't forget to Import System.Data.SqlClient

Exception in .Net Framework

Exception Types

There are a number of exception classes provided by C#, all of which inherit
from the System.Exception class. Following are some common exception classes.

SystemException

A failed run-time check;used as a base class for other.

AccessException

Failure to access a type member, such as a method or field.

ArgumentException

An argument to a method was invalid.

ArgumentNullException

A null argument was passed to a method that doesn't accept it.

ArgumentOutOfRangeException

Argument value is out of range.

ArithmeticException

Arithmetic over - or underflow has occurred.

ArrayTypeMismatchException

Attempt to store the wrong type of object in an array.

BadImageFormatException

Image is in the wrong format.

CoreException

Base class for exceptions thrown by the runtime.

DivideByZeroException

An attempt was made to divide by zero.

FormatException

The format of an argument is wrong.

IndexOutOfRangeException

An array index is out of bounds.

InvalidCastExpression

An attempt was made to cast to an invalid class.

InvalidOperationException

A method was called at an invalid time.

MissingMemberException

An invalid version of a DLL was accessed.

NotFiniteNumberException

A number is not valid.

NotSupportedException

Indicates that a method is not implemented by a class.

NullReferenceException

Attempt to use an unassigned reference.

OutOfMemoryException

Not enough memory to continue execution.

StackOverflowException

A stack has overflown.

The finally block is used to do all the clean up code. It does not support
the error message, but all the code contained in the finally block is executed
after the exception is raised. We can use this block along with try-catch and
only with catch too.

The finally block is executed even if the error is raised. Control is always
passed to the finally block regardless of how the try blocks exits.

This is shown in the following example:

int a, b = 0 ;
Console.WriteLine( "My program starts" ) ;
try
{
a = 10 / b;
}
catch ( InvalidOperationException e )
{
Console.WriteLine ( e ) ;
}
catch ( DivideByZeroException e)
{
Console.WriteLine ( e ) ;
}
finally
{
Console.WriteLine ( "finally" ) ;
}
Console.WriteLine ( "Remaining program" ) ;

The output here is:

My program starts

System.DivideByZeroException: Attempted to divide by zero.

at ConsoleApplication4.Class1.Main(String[] args) in d:\programs\consoleapplication4\class1.cs:line
51

finally

Remaining program

But then what's the difference? We could have written

Console.WriteLine ("finally");

after the catch block, and not write the finally block at all. Writing finally
did not make much of a difference. Anyway the code written after catch gets executed.
The answer to this is not clear in this program. It will be clear when we see
the try-finally and the throw statement.

Windows XP Run Commands and Shortcuts

Windows XP Home / Pro Run Commands and Short Cuts
How To - Click Start, Click Run and enter the command Click OK

Run commands

Calc - Calculator

Cfgwiz32 - ISDN Configuration Wizard

Charmap - Character Map

Chkdisk - Repair damaged files

Cleanmgr - Cleans up hard drives

Clipbrd - Windows Clipboard viewer

Cmd - Opens a new Command Window (cmd.exe)

Control - Displays Control Panel

Dcomcnfg - DCOM user security

Debug - Assembly language programming tool

Defrag - Defragmentation tool

Drwatson - Records programs crash & snapshots

Dxdiag - DirectX Diagnostic Utility

Explorer - Windows Explorer

Fontview - Graphical font viewer

Ftp - ftp.exe program

Hostname - Returns Computer's name

Ipconfig - Displays IP configuration for all network adapters

Jview - Microsoft Command-line Loader for Java classes

MMC - Microsoft Management Console

Msconfig - Configuration to edit startup files

Msinfo32 - Microsoft System Information Utility

Nbtstat - Displays stats and current connections using NetBios over TCP/IP

Netstat - Displays all active network connections

Nslookup- Returns your local DNS server

Ping - Sends data to a specified host/IP

Regedit - registry Editor

Regsvr32 - register/de-register DLL/OCX/ActiveX

Regwiz - Reistration wizard

Sfc /scannow - Sytem File Checker

Sndrec32 - Sound Recorder

Sndvol32 - Volume control for soundcard

Sysedit - Edit system startup files (config.sys, autoexec.bat, win.ini, etc.)

Taskmgr - Task manager

Telnet - Telnet program

Tracert - Traces and displays all paths required to reach an internet host

Winipcfg - Displays IP configuration

Management Consoles

certmgr.msc - Certificate Manager

ciadv.msc - Indexing Service

compmgmt.msc - Computer management

devmgmt.msc - Device Manager

dfrg.msc - Defragment

diskmgmt.msc - Disk Management

fsmgmt.msc - Folder Sharing Management

eventvwr.msc - Event Viewer

gpedit.msc - Group Policy -XP Pro only

iis.msc - Internet Information Services

lusrmgr.msc - Local Users and Groups

mscorcfg.msc - Net configurations

ntmsmgr.msc - Removable Storage

perfmon.msc - Performance Manager

secpol.msc - Local Security Policy

services.msc - System Services

wmimgmt.msc - Windows Management

Shortcuts

access.cpl - Accessibility Options

hdwwiz.cpl - Add New Hardware Wizard

appwiz.cpl - dd/Remove Programs

timedate.cpl - Date and Time Properties

desk.cpl - Display Properties

inetcpl.cpl - Internet Properties

joy.cpl - Joystick Properties

main.cpl keboard - Keyboard Properties

main.cpl - Mouse Properties

ncpa.cpl - Network Connections

ncpl.cpl - Network Properties

telephon.cpl - Phone and Modem options

powercfg.cpl - Power Management

intl.cpl - Regional settings

mmsys.cpl sounds - Sound Properties

mmsys.cpl - Sounds and Audio Device Properties

sysdm.cpl - System Properties

nusrmgr.cpl - User settings

firewall.cpl - Firewall Settings (sp2)

wscui.cpl - Security Center (sp2)

Windows Environment Commands

%ALLUSERSPROFILE% - Open the All User's Profile

%HomeDrive% - Opens your home drive e.g. C:\

%UserProfile% - Opens you User's Profile

%temp% Opens - temporary file Folder

%systemroot% - Opens Windows folder

Wupdmgr - Takes you to Microsoft Windows Update

General keyboard shortcuts

CTRL+C(Copy)

CTRL+X (Cut)

CTRL+Z (Undo)

DELETE (Delete)

SHIFT+DELETE (Delete the selected item permanently without placing the item in the Recycle Bin)

CTRL while dragging an item (Copy the selected item)

CTRL+SHIFT while dragging an item (Create a shortcut to the selected item)

F2 key (Rename the selected item)

CTRL+RIGHT ARROW (Move the insertion point to the beginning of the next word)

CTRL+LEFT ARROW (Move the insertion point to the beginning of the previous word)

CTRL+DOWN ARROW (Move the insertion point to the beginning of the next paragraph)

CTRL+SHIFT with any of the arrow keys (Highlight a block of text)

CTRL+UP ARROW (Move the insertion point to the beginning of the previous paragraph)

SHIFT with any of the arrow keys (Select more than one item in a window or on the desktop, or select text in a document)

CTRL+A (Select all)

F3 key (Search for a file or a folder)

ALT+ENTER (View the properties for the selected item)

ALT+F4 (Close the active item, or quit the active program)

ALT+ENTER (Display the properties of the selected object)

ALT+SPACEBAR (Open the shortcut menu for the active window)

CTRL+F4 (Close the active document in programs that enable you to have multiple documents open simultaneously)

ALT+TAB (Switch between the open items)

ALT+ESC (Cycle through items in the order that they had been opened)

F6 key (Cycle through the screen elements in a window or on the desktop)

F4 key (Display the Address bar list in My Computer or Windows Explorer)

SHIFT+F10 (Display the shortcut menu for the selected item)

ALT+SPACEBAR (Display the System menu for the active window)

CTRL+ESC (Display the Start menu)

ALT+Underlined letter in a menu name (Display the corresponding menu)

Underlined letter in a command name on an open menu (Perform the corresponding command)

F10 key (Activate the menu bar in the active program)

RIGHT ARROW (Open the next menu to the right, or open a submenu)

LEFT ARROW (Open the next menu to the left, or close a submenu)

F5 key (Update the active window)

BACKSPACE (View the folder one level up in My Computer or Windows Explorer)

ESC (Cancel the current task)

SHIFT when you insert a CD-ROM into the CD-ROM drive (Prevent the CD-ROM from automatically playing)

CTRL+SHIFT+ESC (Open Task Manager) Dialog box keyboard shortcuts



If you press SHIFT+F8 in extended selection list boxes, you enable extended selection mode. In this mode, you can use an arrow key to move a cursor without changing the selection. You can press CTRL+SPACEBAR or SHIFT+SPACEBAR to adjust the selection. To cancel extended selection mode, press SHIFT+F8 again. Extended selection mode cancels itself when you move the focus to another control.



CTRL+TAB (Move forward through the tabs)

CTRL+SHIFT+TAB (Move backward through the tabs)

TAB (Move forward through the options)

SHIFT+TAB (Move backward through the options)

ALT+Underlined letter (Perform the corresponding command or select the corresponding option)

ENTER (Perform the command for the active option or button)

SPACEBAR (Select or clear the check box if the active option is a check box)

Arrow keys (Select a button if the active option is a group of option buttons)

F1 key (Display Help)

F4 key (Display the items in the active list)

BACKSPACE (Open a folder one level up if a folder is selected in the Save As or Open dialog box)

Microsoft natural keyboard shortcuts

Windows Logo+BREAK (Display the System Properties dialog box)

Windows Logo+D (Display the desktop)

Windows Logo+M (Minimize all of the windows)

Windows Logo+SHIFT+M (Restore the minimized windows)

Windows Logo+E (Open My Computer)

Windows Logo+F (Search for a file or a folder)

CTRL+Windows Logo+F (Search for computers)

Windows Logo+F1 (Display Windows Help)

Windows Logo+ L (Lock the keyboard)

Windows Logo+R (Open the Run dialog box)

Windows Logo+U (Open Utility Manager)

Accessibility keyboard shortcuts

Right SHIFT for eight seconds (Switch FilterKeys either on or off)

Left ALT+left SHIFT+PRINT SCREEN (Switch High Contrast either on or off)

Left ALT+left SHIFT+NUM LOCK (Switch the MouseKeys either on or off)

SHIFT five times (Switch the StickyKeys either on or off)

NUM LOCK for five seconds (Switch the ToggleKeys either on or off)

Windows Logo +U (Open Utility Manager)

Windows Explorer keyboard shortcuts

END (Display the bottom of the active window)

HOME (Display the top of the active window)

NUM LOCK+Asterisk sign (*) (Display all of the subfolders that are under the selected folder)

NUM LOCK+Plus sign (+) (Display the contents of the selected folder)

NUM LOCK+Minus sign (-) (Collapse the selected folder)

LEFT ARROW (Collapse the current selection if it is expanded, or select the parent folder)

RIGHT ARROW (Display the current selection if it is collapsed, or select the first subfolder)

Shortcut keys for Character Map

After you double-click a character on the grid of characters, you can move through the grid by using the keyboard shortcuts

RIGHT ARROW (Move to the right or to the beginning of the next line)

LEFT ARROW (Move to the left or to the end of the previous line)

UP ARROW (Move up one row)

DOWN ARROW (Move down one row)

PAGE UP (Move up one screen at a time)

PAGE DOWN (Move down one screen at a time)

HOME (Move to the beginning of the line)

END (Move to the end of the line)

CTRL+HOME (Move to the first character)

CTRL+END (Move to the last character)

SPACEBAR (Switch between Enlarged and Normal mode when a character is selected)

Microsoft Management Console (MMC) main window keyboard shortcuts

CTRL+O (Open a saved console)

CTRL+N (Open a new console)

CTRL+S (Save the open console)

CTRL+M (Add or remove a console item)

CTRL+W (Open a new window)

F5 key (Update the content of all console windows)

ALT+SPACEBAR (Display the MMC window menu)

ALT+F4 (Close the console) ALT+A (Display the Action menu)

ALT+V (Display the View menu)

ALT+F (Display the File menu)

ALT+O (Display the Favorites menu)

MMC console window keyboard shortcuts

CTRL+P (Print the current page or active pane)

ALT+Minus sign (-) (Display the window menu for the active console window)

SHIFT+F10 (Display the Action shortcut menu for the selected item)

F1 key (Open the Help topic, if any, for the selected item)

F5 key (Update the content of all console windows)

CTRL+F10 (Maximize the active console window)

CTRL+F5 (Restore the active console window)

ALT+ENTER (Display the Properties dialog box, if any, for the selected item)

F2 key (Rename the selected item)

CTRL+F4 (Close the active console window. When a console has only one console window, this shortcut closes the console)

Remote desktop connection navigation

CTRL+ALT+END (Open the Microsoft Windows NT Security dialog box)

ALT+PAGE UP (Switch between programs from left to right)

ALT+PAGE DOWN (Switch between programs from right to left)

ALT+INSERT (Cycle through the programs in most recently used order)

ALT+HOME (Display the Start menu)

CTRL+ALT+BREAK (Switch the client computer between a window and a full screen)

ALT+DELETE (Display the Windows menu)

CTRL+ALT+Minus sign (-) (Place a snapshot of the entire client window area on the Terminal server clipboard and provide the same functionality as pressing ALT+PRINT SCREEN on a local computer.)

CTRL+ALT+Plus sign (+) (Place a snapshot of the active window in the client on the Terminal server clipboard and provide the same functionality as pressing PRINT SCREEN on a local computer.)

Microsoft Internet Explorer navigation

CTRL+B (Open the Organize Favorites dialog box)

CTRL+E (Open the Search bar)

CTRL+F (Start the Find utility)

CTRL+H (Open the History bar)

CTRL+I (Open the Favorites bar)

CTRL+L (Open the Open dialog box)

CTRL+N (Start another instance of the browser with the same Web address)

CTRL+O (Open the Open dialog box, the same as CTRL+L)

CTRL+R (Update the current Web page)

CTRL+ CTRL+P (Open the Print dialog box)

W (Close the current window)