namespace databanktest
{
public partial class Form1 : Form
{
OleDbConnection objconnection = new OleDbConnection("Provider = Microsoft.Jet.OLEDB.4.0; Data Source = DBES.mdb");
OleDbDataAdapter objDataAdaptor = new OleDbDataAdapter();
DataSet objDataSet = new DataSet();
public Form1()
{
InitializeComponent();
}
private void Form1_Load(object sender, EventArgs e)
{
objDataAdaptor.SelectCommand = new OleDbCommand();
objDataAdaptor.SelectCommand.Connection = objconnection;
objDataAdaptor.SelectCommand.CommandText = "select code, name, tell from anbarha";
objDataAdaptor.SelectCommand.CommandType = CommandType.Text;
objconnection.Open();
objDataAdaptor.Fill(objDataSet, "ali");
objconnection.Close();
grdForm1.AutoGenerateColumns = true;
grdForm1.DataSource = objDataSet;
grdForm1.DataMember = "ali";
objDataAdaptor = null;
objconnection = null;
}
private void btnExit_Click(object sender, EventArgs e)
{
this.Close();
}
}
}