Bind Database table column to TextBox : Data Bind TextBox « Database ADO.net « C# / C Sharp






Bind Database table column to TextBox

using System;
using System.Drawing;
using System.Collections;
using System.ComponentModel;
using System.Windows.Forms;
using System.Data;
using System.Data.SqlClient;

    public class Form1 : System.Windows.Forms.Form {
        private System.Windows.Forms.TextBox textBox1;
        private System.Windows.Forms.TextBox textBox2;
        private System.ComponentModel.Container components = null;

        public Form1() {
            InitializeComponent();
        }

        private void InitializeComponent(){
         this.textBox1 = new System.Windows.Forms.TextBox();
         this.textBox2 = new System.Windows.Forms.TextBox();
         this.SuspendLayout();

         this.textBox1.Location = new System.Drawing.Point(8, 8);
         this.textBox1.Name = "textBox1";
         this.textBox1.Size = new System.Drawing.Size(192, 20);
         this.textBox1.TabIndex = 0;
         this.textBox1.Text = "textBox1";

         this.textBox2.Location = new System.Drawing.Point(8, 40);
         this.textBox2.Name = "textBox2";
         this.textBox2.Size = new System.Drawing.Size(184, 20);
         this.textBox2.TabIndex = 1;
         this.textBox2.Text = "textBox2";

         this.AutoScaleBaseSize = new System.Drawing.Size(5, 13);
         this.ClientSize = new System.Drawing.Size(208, 76);
         this.Controls.Add(this.textBox2);
         this.Controls.Add(this.textBox1);
         this.Name = "Form1";
         this.Text = "Form1";
         this.Load += new System.EventHandler(this.Form1_Load);
         this.ResumeLayout(false);

      }

      static void Main() {
            Application.Run(new Form1());
      }

      private void Form1_Load(object sender, System.EventArgs e) {
         string connString = "server=(local)\\SQLEXPRESS;database=MyDatabase;Integrated Security=SSPI";

         string sql = @"select * from employee ";

         SqlConnection conn = new SqlConnection(connString);
         SqlDataAdapter da = new SqlDataAdapter(sql, conn);
         DataSet ds = new DataSet();
         da.Fill(ds, "employee");

         // Bind to FirstName column of the Employees table 
         textBox1.DataBindings.Add("text", ds, "employee.firstname");
         // Bind to LastName column of the Employees table
         textBox2.DataBindings.Add("text", ds, "employee.lastname");
      }
    }



           
       








Related examples in the same category

1.Bind DataSet to TextBox
2.Simple DataBinding to TextBox
3.Bind String array to a TextBox
4.DataView Binding to TextBox