Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Sign In with Facebook Sign In with Google Sign In with OpenID

Categories

We have migrated to a new platform! Please note that you will need to reset your password to log in (your credentials are still in-tact though). Please contact lee@programmersheaven.com if you have questions.
Welcome to the new platform of Programmer's Heaven! We apologize for the inconvenience caused, if you visited us from a broken link of the previous version. The main reason to move to a new platform is to provide more effective and collaborative experience to you all. Please feel free to experience the new platform and use its exciting features. Contact us for any issue that you need to get clarified. We are more than happy to help you.

Simple Data Binding

wvbothawvbotha Posts: 23Member
i need to list users ids on a combo box from users table. i'm using dataset from component.but it retrives only 1st record. i used C# to component and vb.net in desktop application.please, some one help
me. i need to retrive all user ids to combo box.


component :


public SqlConnection Con;
public SqlCommand Com;
public SqlDataReader DR;
public SqlDataAdapter AD;
public DataSet DS;
public DataTable DT;
int result;
public string SCon;
SqlCon .SqlCon ConObj=new SqlCon.SqlCon();

public Class1()
{ }

public DataSet RetriveEMP()

{
SCon=ConObj.SetConnection();
Con=new SqlConnection(SCon);
Con.Open();
AD= new SqlDataAdapter("select * from users", Con);
DS=new DataSet();
AD.Fill(DS,"users");
return DS;
}//End Of DataSet RetriveEMP()


Desktop Application:


Public Function am()
Try
Dim a As New ClassLibrary1.Class1
Dim dsa As New DataSet
dsa = a.RetriveEMP()
Dim dt As DataTable
dt = dsa.Tables(0)
ComboBox1.DataBindings.Add("Text", dt, "cEmpID")

Catch Ex As Exception
MsgBox(Ex.Message)
End Try

End Function



Comments

  • PavlinIIPavlinII Posts: 404Member
    : i need to list users ids on a combo box from users table. i'm using dataset from component.but it retrives only 1st record. i used C# to component and vb.net in desktop application.please, some one help
    : me. i need to retrive all user ids to combo box.
    :
    :
    : component :
    :
    :
    : public SqlConnection Con;
    : public SqlCommand Com;
    : public SqlDataReader DR;
    : public SqlDataAdapter AD;
    : public DataSet DS;
    : public DataTable DT;
    : int result;
    : public string SCon;
    : SqlCon .SqlCon ConObj=new SqlCon.SqlCon();
    :
    : public Class1()
    : { }
    :
    : public DataSet RetriveEMP()
    :
    : {
    : SCon=ConObj.SetConnection();
    : Con=new SqlConnection(SCon);
    : Con.Open();
    : AD= new SqlDataAdapter("select * from users", Con);
    : DS=new DataSet();
    : AD.Fill(DS,"users");
    : return DS;
    : }//End Of DataSet RetriveEMP()
    :
    :
    : Desktop Application:
    :
    :
    : Public Function am()
    : Try
    : Dim a As New ClassLibrary1.Class1
    : Dim dsa As New DataSet
    : dsa = a.RetriveEMP()
    : Dim dt As DataTable
    : dt = dsa.Tables(0)
    : ComboBox1.DataBindings.Add("Text", dt, "cEmpID")
    :
    : Catch Ex As Exception
    : MsgBox(Ex.Message)
    : End Try
    :
    : End Function
    :
    :
    :
    :
    Try this instead of DataBindings.
    [code] ComboBox1.ValueMember = "cEmpID"
    ComboBox1.DataSource = dt[/code]

    [blue][b][italic][size=4]P[/size]avlin [size=4]II[/italic][/size][/b][/blue]

    [purple]Don't take life too seriously anyway you won't escape alive from it![/purple]


Sign In or Register to comment.