Exemple #1
0
    public void fillDLL_QualificationV1()
    {
        string         str = "select qualificationId,qualificationName from UserQualification";
        DataSet        ds  = new DataSet();
        SqlDataAdapter da  = new SqlDataAdapter(str, con);

        da.Fill(ds);
        DDDLQualificationV1.DataSource     = ds;
        DDDLQualificationV1.DataTextField  = "qualificationName";
        DDDLQualificationV1.DataValueField = "qualificationId";
        DDDLQualificationV1.DataBind();
        DDDLQualificationV1.Items.Add("Custom");
        DDDLQualificationV1.Items.Insert(0, new ListItem("--Select--", "0"));
    }
Exemple #2
0
    public void txtChangeV1(DropDownList ddl, TextBox tx)
    {
        string str1 = "insert into UserQualification(qualificationName)values('" + DDDLQualification.SelectedValue + "')";
        int    row1 = cc.ExecuteNonQuery(str1);

        string str2 = "select qualificationId,qualificationName from UserQualification ";

        ds = cc.ExecuteDataset(str2);


        DDDLQualificationV1.DataSource     = ds;
        DDDLQualificationV1.DataTextField  = "qualificationName";
        DDDLQualificationV1.DataValueField = "qualificationId";
        DDDLQualificationV1.DataBind();
        DDDLQualificationV1.Items.Add("Custom");
        DDDLQualificationV1.Items.Insert(0, new ListItem("--Select--", "0"));
    }