private void Form1_Load(object sender, EventArgs e)
{
cn = new OleDbConnection();
cn.ConnectionString = "Provider=Microsoft.jet.oledb.4.0;Data Source=\\\\Juriel\\Data$\\OKT08.mdb;jet oledb:database password=ocomokt2008";
try
{
cn.Open();
cmd = cn.CreateCommand();
cmd.Connection = cn;
cmd.CommandText = "select p_num,p_name from ren_per_info order by p_name";
cbNames.Items.Clear();
dr = cmd.ExecuteReader();
while (dr.Read())
{
co = new cbojbect();
co.Text = dr.GetString(dr.GetOrdinal("p_name"));
co.Value = Int32.Parse((string)dr.GetValue(dr.GetOrdinal("p_num")));
cbNames.Items.Add("");
cbNames.Items[cbNames.Items.Count - 1] = (iproject.cbojbect)co;
}
dr.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void cbNames_SelectedIndexChanged(object sender, EventArgs e)
{
co = (iproject.cbojbect)cbNames.SelectedItem;
uid = (int)co.Value;
filllist();
}