Hi

Try the query like this

SELECT count(*)
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = 'mytable'

Hi

did you tried doing this.. ?

protected void Page_Load(object sender, EventArgs e)
{
if(!IsPostback)
{
// your complete Country code here
}

Hi..

Put all the code in Page load event in !IspostBack like below..

protected void Page_Load(object sender, EventArgs e)
{
if(!IsPostback)
{
// your...

Try doing this.. it should work

Replace this code :
ddlItems.DataSource = dsCategory;
ddlItems.DataMember = "Categories";
ddlItems.DataTextField = "Description";

With ...