Форум программистов [Powered by Invision Power Board]

Код

private void tabControl1_Selecting(object sender, TabControlCancelEventArgs e)
        {
            try
            {

                if (tabControl1.SelectedTab == tabPage3)
                {


                    conn1 = new OleDbConnection();
                    conn1.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\Data\\Client_DB.mdb";
                    //Initialize adapter.
                    command1 = new OleDbCommand();
                    command1.Connection = conn1;
                    adapter1 = new OleDbDataAdapter(command1);
                    adapter1 = new OleDbDataAdapter("Select Category,CompanyName,ClientName,Address,City,Telephone,PostalCode from TBL_Clients", conn1);

                    //Initialize Dataset.
                    ds1 = new DataSet();
                    dataTable1 = ds1.Tables.Add("Clients");

                    //Fill dataset with ImagesStore table.
                    adapter1.Fill(ds1, "Clients");

                    //Fill Grid with dataset.                    
                    dataGridView2.DataSource = ds1.Tables["Clients"];
                    //dataGridView2.Columns["StatusImage"].Width = 40;


                    this.txt_CategoryMail.DataBindings.Add("Text", dataTable1, "Category", true, DataSourceUpdateMode.OnPropertyChanged);
                    this.txt_CompNameMail.DataBindings.Add("Text", dataTable1, "CompanyName", true, DataSourceUpdateMode.OnPropertyChanged);
                    this.txt_ClientNameMail.DataBindings.Add("Text", dataTable1, "ClientName", true, DataSourceUpdateMode.OnPropertyChanged);
                    this.txt_AddressMail.DataBindings.Add("Text", dataTable1, "Address", true, DataSourceUpdateMode.OnPropertyChanged);
                    this.txt_CytiProvMail.DataBindings.Add("Text", dataTable1, "City", true, DataSourceUpdateMode.OnPropertyChanged);
                    this.txt_TelMail.DataBindings.Add("Text", dataTable1, "Telephone", true, DataSourceUpdateMode.OnPropertyChanged);
                    this.txt_PCMail.DataBindings.Add("Text", dataTable1, "PostalCode", true, DataSourceUpdateMode.OnPropertyChanged);
                   
                    //dataGridView1.AutoSizeRowsMode = DataGridViewAutoSizeRowsMode.AllCells;
                    dataGridView2.DefaultCellStyle.WrapMode = DataGridViewTriState.True;

                    foreach (DataGridViewColumn column1 in dataGridView2.Columns) column1.SortMode = DataGridViewColumnSortMode.NotSortable;

                }

            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.ToString());
            }
        }