Step 1: Create (tblCategory) table in your Database

CREATE TABLE [dbo].[tblCategory](
[CategoryID] [int] IDENTITY(1,1) NOT NULL,
[CategoryName] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
CONSTRAINT [PK_tblCategory] PRIMARY KEY CLUSTERED
(
[CategoryID] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]

step 2: insert into tblCategory(CategoryName) values(’Movies’);

insert into tblCategory(CategoryName) values(’Electronics’);

Step3: Drag Dropdownlist in Default.aspx then write below code in Page_load event

using System.Data;
using System.Configuration;
using System.Data.SqlClient;

protected void Page_Load(object sender, EventArgs e)
{

//Data Source = Your server name or local  sqlserver name

//Data Source=./SQLEXPRESS (for local Sqlserver)

//Data Source = santhu or 192.168.1.34 (for remote servers)

string ConnectionString = “Data Source=santhu;Initial Catalog=DatabaseName;User Id=sa;Password=abc123″;
SqlConnection objConn = new SqlConnection(ConnectionString);

string query = “select CategoryID,CategoryName from tblCategory”;
SqlCommand objCmd = new SqlCommand(query,objConn);
objCmd.CommandType = CommandType.Text;

DataSet objDs = new DataSet();
SqlDataAdapter objDa = new SqlDataAdapter(objCmd);

objConn.Open();
objDa.Fill(objDs);
objCmd.ExecuteNonQuery();

DropDownList1.DataTextField = “CategoryName”;
DropDownList1.DataValueField = “CategoryID”;

DropDownList1.DataSource = objDs;
DropDownList1.DataBind();

objConn.Close();

}

Step4: Now Run Your Application

Happy coding..