Filling Dropdownlist through database values in ASP.NET 2005

[ITCraze]

Hello everyone,

I have three tables CompanyMst ,BranchMst and DeptMst.
CompanyMst contains:

CompanyId(Primary Key) ,CompanyName.

BranchMst contains:
CompanyId(Foreign key),BranchId(Primary Key),BranchName.

DeptMst contains:
UserId,BranchId(Foriegn key),DeptId(Primary Key),DeptName.


Now in the registration forms I am filling the DeptName and BranchName through dropdownlist using the DeptMst and BranchMst table.

Now as most of the application requires that the first item should be --Select--

But when I add DropdownList1.Items.Add("--Select--");
in page load it just overwrites the first value of the dropdownlist.

And when I tried to add the following after the databind() of dropdownlist:


objcomponent.Items.Insert(0, new ListItem("--Select", "0"));

It gives the erorr :Can't insert or update foreign key .

Please help as I know this is very small problem ,I have tried lot of things just looking for perfect solution.

Please help me to solve my problem.Please help,If anyone can explain me through coding then it will become easy for me.

Thanking you all.

[nateraaaa]

Try adding the new item to the dropdownlist before calling DataBind().

Nathan

[ITCraze]

Thank you for replying but you know I have tried adding the item before calling databind but nothing happening.Please suggest what can I do.

[nateraaaa]

Thank you for replying but you know I have tried adding the item before calling databind but nothing happening.Please suggest what can I do.

What code did you use to try and add the item to the dropdownlist before calling DataBind()?

Did you do it like this.

ddlMyList.Items.Insert(0, "--Select--");

Nathan

[ITCraze]

Yes I did exactly like this.But nothing is happening.Dropdownlist is not showing Select.But If I will add this after databind() then select is visible in the dropdownlist.But on submitting the form it is giving the error of :

Cannot add or Update foreign Key BranchId.

As I have mentioned previously that my form contains two dropdownlist:

BranchName and DeptName.

BranchId is primary Key of BranchMst and BranchId is foreign key of DeptMst.

Thats why after adding ddlList.Items.Insert(0,'--Select--') after databind it is giving this kind of error.

Please help me .Iam not getting any answer to this.