DataGridView da Seçili Satır Bilgilerini TextBox ta Göstermek

Merhaba arkadaşlar. Bu makalemizde Customers tablosundaki bilgileri, DataGridView da göstereceğiz. DataGridView da seçili satır bilgilerini Textbox ta göstereceğiz.

dataGridView1.DataSource = ds;

dataGridView1.DataMember = "Customers";

textbox DataBindings metodu ile sütundaki satır bilgilerini textbox ta gösteriyoruz.

this.textBox1.DataBindings.Add("Text", ds, "Customers.ID");

Screenshot

 

Şekil 1

Form1.cs

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Data.OleDb;

using System.Drawing;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

using System.Windows.Forms;

namespace WindowsFormsApplication1

{

    public partial class Form1 : Form

    {

        public Form1()

        {

            InitializeComponent();

        }

        private void Form1_Load(object sender, EventArgs e)

        {

            OleDbConnection baglan = new OleDbConnection("Provider=Microsoft.Ace.Oledb.12.0;Data Source= northwind.accdb");

            OleDbDataAdapter da = new OleDbDataAdapter();

            OleDbCommand cmd = new OleDbCommand();

            DataSet ds = new DataSet();

            baglan.Open();

            cmd.CommandText = "Select ID, FirstName,LastName,JobTitle,City From Customers ";

            da.SelectCommand = cmd;

            cmd.Connection = baglan;

            da.Fill(ds, "Customers");

            dataGridView1.DataSource = ds;

            dataGridView1.DataMember = "Customers";

            this.textBox1.DataBindings.Add("Text", ds, "Customers.ID");

            this.textBox2.DataBindings.Add("Text", ds, "Customers.FirstName");

            this.textBox3.DataBindings.Add("Text", ds, "Customers.LastName");

            this.textBox4.DataBindings.Add("Text", ds, "Customers.JobTitle");

            this.textBox5.DataBindings.Add("Text", ds, "Customers.City");

          

            baglan.Close();

        }

    }

}

Bir makalenin daha sonuna geldik. Bir sonraki makalede görüşmek üzere. Bahadır ŞAHİN

Share This:

Facebook Twitter Pinterest Linkedin Whatsapp Whatsapp

About Bahadır Şahin

This is a short description in the author block about the author. You edit it by entering text in the "Biographical Info" field in the user admin panel.