you can either use datareader or dataset to sovle your issue. some thing like below
string query="select s_name,s_sirname from record_table";
oleDbCommand cmd = new OleDbCommand(query, cn);
oleDbAdepter Da = new oleDbAdepter(cmd);
dataset ds = new dataset();
cn.open();
da.fill(ds);
cn.close();
if(ds!=null && ds.tables[0].rows.count>0)
{
name = ds.tables[0].rows[0]["name"].tostring();
sirname =ds.tables[0].rows[0]["sirname "].tostring();
}