زر Radiobutton وربطه بقاعدة البيانات أكسس

code]

public class Client

{

private void ConnectBtn_Click(object sender, System.EventArgs e)

{

GenericAdoNetComp genDP = new GenericAdoNetComp();

sql = "SELECT * FROM Employees";

if (radioButton1.Checked)

{

connString =

"Provider=Microsoft.Jet.OLEDB.4.0; Data

Source=c:\\Northwind.mdb";

conn = genDP.GetConnection(1, connString);

adapter = genDP.GetDataAdapter(1, connString, sql);

}

else if (radioButton2.Checked)

{

connString =

"Data Source=MCB;Initial Catalog=Northwind;user

id=sa;password=;";

conn = genDP.GetConnection(2, connString);

adapter = genDP.GetDataAdapter(2, connString, sql);

}

else if (radioButton3.Checked)

{

// Construct your connection string here

conn = genDP.GetConnection(3, connString);

adapter = genDP.GetDataAdapter(3, connString, sql);

}

try

{

conn.Open();

// Fill a DataSet

DataSet ds = new DataSet();

adapter.Fill(ds);

dataGrid1.DataSource = ds.Tables[0].DefaultView;

}

catch (Exception exp)

{

MessageBox.Show(exp.Message);

}

finally

{

conn.Close();

}

}

}

/code]