ASP.NET

Data Source=.\SQLEXPRESS;AttachDbFileName=e:\data\Customers.mdf;Integrated Security=True;User Instance=True

SET @table_1 = (SELECT table1.ID FROM table1

SET @table_1 = SCOPE_IDENTITY()

Dim upBmp As Bitmap = Bitmap.FromStream(FileUpload1.PostedFile.InputStream)
Dim upWidth As Integer = upBmp.Width
Dim upHeight As Integer = upBmp.Height

public partial class assets_WebControls_ftExclusions : System.Web.UI.UserControl
{
    private int id; // the id passed from parent page
    private ftExclusionsList myftExclusions;   // the list to return to master page

    public  int ID
    {
        get{return ID;}
        set{ID=value;}
    }

    public ftExclusionsList selectedExclusions
    {
        get { return myftExclusions; }
        set { myftExclusions = value; }
    }
   
    protected void Page_Load(object sender, EventArgs e)
    {
// Just binding the checkbox list with selected items/total items
        if (!Page.IsPostBack)
        {
            cblExclusions.DataBind();
            ftExclusionsList myExcluList = ftExclusionsManager.ftExclusionsById(ID);
            if (myExcluList != null)
            {
                if (myExcluList.Count > 0 && myExcluList != null)
                {
                    foreach (ftExclusions ex in myExcluList)
                    {
                        cblExclusions.Items.FindByValue(ex.excluId.ToString()).Selected = true;
                    }
                }
            }
        }
        
    }
    protected void btnUpdate_Click(object sender, EventArgs e)
    {// returning result set here how to bind it with gridview on parent page ? :( 
        ftExclusionsList myFTExclusionList = new ftExclusionsList();
        foreach (ListItem li in cblExclusions.Items)
        {
            if (li.Selected == true)
            {
                ftExclusions myftExclusion = new ftExclusions();
                myftExclusion.ftExcluId = Convert.ToInt32(li.Value);
                myftExclusion.excludesc = li.Text.ToString();
                myFTExclusionList.Add(myftExclusion);
            }
            
        }
        selectedExclusions = myFTExclusionList;
    }
}