C#

<br />
private void AXSWMenu_FSCommand(object sender, AxShockwaveFlashObjects._IShockwaveFlashEvents_FSCommandEvent e)<br />
{<br />
CtlSimpleHtml find_suitableAction =new CtlSimpleHtml();<br />
find_suitableAction.load_html(e.args.ToString());<br />
<br />
}

<br />
public void load_html(string command_type)<br />
{<br />
if (command_type.Trim()=="Bio")<br />
{<br />
fill_author_name_forBio();<br />
pnl_viewer.Hide(); //a panel on user control<br />
pnl_Story.Hide(); //a panel on user control<br />
pnl_AuthorName.Show(); //a panel on user control<br />
pnl_AuthorName.Location=new Point(8,8); <br />
pnl_viewer.Location=new Point(8,672);<br />
pnl_AuthorName.Update();<br />
pnl_Story.Update();<br />
pnl_viewer.Update();	<br />
}<br />
}<br />

<br />
public void fill_author_name_forBio()<br />
 {<br />
Authors name =new Authors();<br />
DataTable Authors_name=name.find_AuthorsName_all(connection.make());<br />
//li_AuthorName is a listBox on the usercontrol<br />
li_AuthorName.DataSource=Authors_name;<br />
li_AuthorName.DisplayMember="Name";<br />
li_AuthorName.ValueMember="id";<br />
li_AuthorName.SelectedIndex=-1;<br />
 }<br />

<br />
public class Authors<br />
 {<br />
   OleDbConnection con;<br />
   OleDbCommand cmd;<br />
public DataTable find_AuthorsName_all(string cnstring)<br />
{<br />
con=new OleDbConnection(cnstring);<br />
 try<br />
  {<br />
   con.Open();<br />
   string cmdstr="select name,id from Authors ";<br />
   cmd=new OleDbCommand(cmdstr,con);<br />
   cmd.CommandType=CommandType.Text;<br />
   OleDbDataAdapter adp=new OleDbDataAdapter(cmd);<br />
   DataTable dt =new DataTable("Authors");<br />
   adp.Fill(dt);<br />
   con.Close();<br />
   return dt;<br />
   }<br />
   catch(Exception ex)<br />
   {<br />
     MessageBox.Show(ex.Message);<br />
     con.Close();<br />
     return null;<br />
    }<br />
   }<br />
}<br />