Problem with DDL and Gridview

[Stelly]

Hey All,

I have a problem... I have a DDL which I want to populate a GridView
dependant on what is chosen in the DDL... so far I have done below... but when I try to go to edit it postbacks the page and the information vanishes... any ideas what I should do??

protected void ddlSelect_SelectedIndexChanged(object sender, EventArgs e)
{
if (ddlSelect.SelectedItem.Value == "1")
{
string[] datakey = { "PC_ID" };
gdvSelect.DataKeyNames = datakey;
gdvSelect.DataSourceID = "SqlSource";
gdvSelect.AutoGenerateEditButton = true;
gdvSelect.AutoGenerateColumns = true;
gdvSelect.DataBind();

SqlSource.ConnectionString = ConfigurationSettings.AppSettings["ConnectionString"];
SqlSource.SelectCommand = "SELECT * FROM Computer";
SqlSource.DeleteCommand = "DELETE FROM Computer WHERE PC_ID = @PC_ID";
SqlSource.DeleteParameters.Add(new Parameter("PC_ID", TypeCode.Int32));

SqlSource.InsertCommand = "INSERT INTO Computer (PC_ID, PcModel, CCCSR, EPSR, PoNo, ShipDate, OnSite, UserID, OS, UserShared, Available) VALUES (@PC_ID, @PcModel, @CCCSR, @EPSR, @PoNo, @ShipDate, @OnSite, @UserID, @OS, @UserShared, @available)";
SqlSource.InsertParameters.Add(new Parameter("PC_ID", TypeCode.Int32));
SqlSource.InsertParameters.Add(new Parameter("PcModel", TypeCode.String));
SqlSource.InsertParameters.Add(new Parameter("CCCSR", TypeCode.String));
SqlSource.InsertParameters.Add(new Parameter("EPSR", TypeCode.String));
SqlSource.InsertParameters.Add(new Parameter("PoNo", TypeCode.String));
SqlSource.InsertParameters.Add(new Parameter("UserID", TypeCode.String));
SqlSource.InsertParameters.Add(new Parameter("OS", TypeCode.String));
SqlSource.InsertParameters.Add(new Parameter("UserShared", TypeCode.Int32));
SqlSource.InsertParameters.Add(new Parameter("Available", TypeCode.Int32));

SqlSource.UpdateParameters.Add(new Parameter("PC_ID", TypeCode.Int32));
SqlSource.UpdateParameters.Add(new Parameter("PcModel", TypeCode.String));
SqlSource.UpdateParameters.Add(new Parameter("CCCSR", TypeCode.String));
SqlSource.UpdateParameters.Add(new Parameter("EPSR", TypeCode.String));
SqlSource.UpdateParameters.Add(new Parameter("PoNo", TypeCode.String));
SqlSource.UpdateParameters.Add(new Parameter("UserID", TypeCode.String));
SqlSource.UpdateParameters.Add(new Parameter("OS", TypeCode.String));
SqlSource.UpdateParameters.Add(new Parameter("UserShared", TypeCode.Int32));
SqlSource.UpdateParameters.Add(new Parameter("Available", TypeCode.Int32));
}

else if (ddlSelect.SelectedItem.Value == "2")
{
gdvSelect.DataSource = SQLQueries.UserListBindData();
gdvSelect.DataBind();
}
}

Cheers,

Stelly