Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public formAccounts()
- {
- InitializeComponent();
- BindGrid();
- }
- private void BindGrid()
- {
- OleDbConnection conn = new OleDbConnection();
- conn.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source= G:SanjeevTESTDBDB.mdb;Jet OLEDB:Database Password=Test123; Jet OLEDB:Engine Type=5";
- conn.Open();
- string constring = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=G:SanjeevTESTDBDB.mdb;Jet OLEDB:Database Password=Test123; Jet OLEDB:Engine Type=5";
- using (OleDbConnection con = new OleDbConnection(constring))
- {
- using (OleDbCommand cmd = new OleDbCommand("SELECT * FROM tblAccounts", con))
- {
- cmd.CommandType = CommandType.Text;
- using (OleDbDataAdapter sda = new OleDbDataAdapter(cmd))
- {
- using (DataTable dt = new DataTable())
- {
- sda.Fill(dt);
- //Set AutoGenerateColumns False
- dtGrdAccounts.AutoGenerateColumns = false;
- //Set Columns Count
- ***dtGrdAccounts.ColumnCount = 3;***
- //Add Columns
- dtGrdAccounts.Columns[0].Name = "AccountID";
- dtGrdAccounts.Columns[0].HeaderText = "Id";
- dtGrdAccounts.Columns[0].DataPropertyName = "AccID";
- dtGrdAccounts.Columns[1].HeaderText = "Account name";
- dtGrdAccounts.Columns[1].Name = "Account name";
- dtGrdAccounts.Columns[1].DataPropertyName = "AccName";
- dtGrdAccounts.Columns[2].Name = "AccountNumber";
- dtGrdAccounts.Columns[2].HeaderText = "Account number";
- dtGrdAccounts.Columns[2].DataPropertyName = "AccNumber";
- dtGrdAccounts.DataSource = dt;
- }
- }
- }
- }
- }
- string cmdText = "prAddAccounts";
- OleDbCommand cmd = new OleDbCommand(cmdText, conn);
- cmd.CommandType = CommandType.StoredProcedure;
- cmd.Parameters.AddWithValue("AccName", txtAccName.Text.ToString());
- //..... other parameters to insert record .....
- OleDbCommand cmd = new OleDbCommand(cmdText, conn);
- cmd.CommandType = CommandType.StoredProcedure;
- OleDbDataReader reader = cmd.ExecuteReader();
- BindGrid();
- string cmdText = "prAddAccounts";
- OleDbCommand cmd = new OleDbCommand(cmdText, conn);
- cmd.CommandType = CommandType.StoredProcedure;
- cmd.Parameters.AddWithValue("AccName", txtAccName.Text.ToString());
- //..... other parameters to insert record .....
- //Clear the binding.
- dtGrdAccounts.DataSource = null;
- //Bind the new data.
- BindGrid();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement