combo boxes and datasources???

[crostar]

I am using VB.NET and SQL Server. I have created a store procedure (getcompany) in SQL Server that gets one column of information from a table. i was to link this store procedure outcome to a combo box in a form. This is the code to get the store procedure:

Dim strcon As String = "data
source=BFS1;database=BS2;uid=sa;pwd=vonag340;"

Dim myadapter As New SqlClient.SqlDataAdapter("getcompany", strcon)

Dim ds As New DataSet

myadapter.SelectCommand.CommandType = CommandType.StoredProcedure

myadapter.Fill(ds, "output")

how do i link this to combobox1???

Thanks

[hellswraith]

NEVER EVER EVER post your connection string with a username and password in it.

[crostar]

I changed the info before i pasted it. Thanks for the advise, but i already figured that one out. Does anyone know how i can attach my store procedure as a datasource for a combobox???

[Memnoch1207]

This is C#, but it should give you an idea how to do it.

private void Form1_Load(object sender, System.EventArgs e)
{
   string ConnectionString = "server=localhost;user id=username;password=password;database=dbname";

   SqlConnection Conn = new SqlConnection(ConnectionString);
   SqlCommand Comm = new SqlCommand(getCompany, Conn);
   SqlDataReader reader;

   try
   {
      Conn.Open();
      reader = Comm.ExecuteReader();
      while(reader.Read())
      {
           ComboBox1.Items.Add(reader["CompanyName"]);
      }

      reader.Close();
      Conn.Close();
   }
		
   catch(Exception ex)
   {
      MessageBox.Show("Error: " + ex.ToString());
   }
}