public partial class Form1 : Form { DataGridView dataGrid; DataSet dataSet; OleDbDataAdapter da; private OleDbConnection conn = new OleDbConnection(); private string conStr = "Provider=SQLOLEDB;Data Source=SERVICE\\SQLEXPRESS;Initial Catalog=Test;Integrated Security=SSPI"; public Form1() { InitializeComponent(); conn = new OleDbConnection(conStr); conn.Open(); InitializeComponent(); //CreateGridAndButton(); } private void Form1_Load(object sender, EventArgs e) { string str = "SP_TestForAccess"; OleDbCommand cmd = new OleDbCommand(); cmd = new OleDbCommand(str, conn); dataGrid=new DataGridView(); da = new OleDbDataAdapter(); DataTable dt = new DataTable(); dataSet = new DataSet(); da.SelectCommand = cmd; //dt.Load(dr); //dataSet.Tables.Add(dt); da.Fill(dataSet, "tbl_main"); dataGrid.DataSource = dataSet.Tables[0].DefaultView; } }
dataGrid.DataSource = dataSet.Tables[0];
this.Controls.Add(dataGrid);
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)