C#

use databse<br />
select * from INFORMATION_SCHEMA.TABLES 

private void Form2_Load(object sender, System.EventArgs e)<br />
{<br />
Authors authors = new Authors();<br />
DataTable Name;<br />
Name=authors.find_AuthorsName_all(connection.make());<br />
<br />
//cmb_AuthorName is my combobox<br />
<br />
cmb_AuthorName.DataSource=Name;<br />
cmb_AuthorName.DisplayMember="name";<br />
cmb_AuthorName.ValueMember="id";<br />
}

<br />
public class Authors<br />
{<br />
OleDbConnection con;<br />
OleDbCommand cmd;<br />
<br />
public DataTable find_AuthorsName_all(string cnstring)<br />
{<br />
con=new OleDbConnection(cnstring);<br />
			<br />
			<br />
try<br />
{<br />
				<br />
con.Open();<br />
string cmdstr="select id,name 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 />
}<br />
}<br />

r_e_h_a_n wrote:

string idata = "insert into db1 values('"+txtID.Text+"','"+rbmale.Text+"','"+rbfemale.Text+"')";