private List <Testdir> gridf8view()
{
var conn = Database.ConnectDB();
conn.Open();
string query = "select * from tb_testdir;";
SqlCommand cmd = new SqlCommand(query, conn);
SqlDataReader reader = cmd.ExecuteReader();
List <Testdir> list = new List <Testdir>();
while (reader.Read())
{
Testdir tdir1 = new Testdir();
tdir1.ID = reader.GetInt32(reader.GetOrdinal("Testdir_id"));
tdir1.testname = reader.GetString(reader.GetOrdinal("test_name"));
tdir1.price = reader.GetInt32(reader.GetOrdinal("Price"));
tdir1.testcode = reader.GetString(reader.GetOrdinal("test_code"));
list.Add(tdir1);
}
conn.Close();
return(list);
}
public void loadcombotest()
{
var conn = Database.ConnectDB();
conn.Open();
string query = "select test_name, price from tb_testdir;";
SqlCommand cmd = new SqlCommand(query, conn);
SqlDataReader reader = cmd.ExecuteReader();
List <Testdir> list = new List <Testdir>();
while (reader.Read())
{
Testdir tdir = new Testdir();
tdir.testname = reader.GetString(reader.GetOrdinal("test_name"));
tdir.price = reader.GetInt32(reader.GetOrdinal("price"));
int count = 1;
tdir.ID = count;
count++;
list.Add(tdir);
}
combof7_test.DataSource = list;
combof7_test.ValueMember = "ID";
combof7_test.DisplayMember = "testname";
conn.Close();
}