windows form Data Repeater

private void DataRepeaterForm_Load(object sender, EventArgs e)

        {

            SqlConnection con = new SqlConnection("Data Source=ADRIAN-PC; Initial Catalog=AdventureWorks2008R2; Integrated Security=true;User id=;password=");



            SqlCommand cmd = new SqlCommand("Select * from Person.Person", con);

            SqlDataAdapter adapt = new SqlDataAdapter(cmd);



            DataTable items = new DataTable();

            adapt.Fill(items);



            textBox1.DataBindings.Add("Text", items, "FirstName");

            label1.DataBindings.Add("Text", items, "LastName");



            TextBox myUcTextBox1 = (TextBox)myUC1.Controls.Find("textBox1", true).First();



            if( myUcTextBox1 != null)

                myUcTextBox1.DataBindings.Add("Text", items, "LastName");



            dataRepeater1.DataSource = items;

        }

k@rth!k
karthikreddy08a50@gmail.com

BindingSource bindingSource1 = new BindingSource();

bindingSource1.DataSource = items;

textBox1.DataBindings.Add("Text", bindingSource1, "FirstName");

label1.DataBindings.Add("Text", bindingSource1, "LastName");

dataRepeater1.DataSource = bindingSource1;

k@rth!k
karthikreddy08a50@gmail.com

private void Form1_Load(object sender, EventArgs e) 

    { 

        bindingsource = new BindingSource(); 

        ds = new DataSet("Preferences");



        DataTable table = new DataTable("Preference");



        table.Columns.Add("Value");



        table.Columns.Add("OverflowBehaviour");



        for (int i = 1; i <= 8; i++) 

        { 

            if (i < 5) 

                table.Rows.Add(i, ValueTypeAutoIncrementOverflowBehaviour.Exception); 

            else 

                table.Rows.Add(i, ValueTypeAutoIncrementOverflowBehaviour.Wrap); 

        }



        ds.Tables.Add(table);



        bindingsource.DataSource = ds; 

        bindingsource.DataMember = "Preference";          



        textBox1.DataBindings.Add(new Binding("Text", bindingsource, "Value", true, DataSourceUpdateMode.OnValidation)); 



        comboBox1.DataBindings.Add("SelectedItem", bindingsource, "OverflowBehaviour", false, DataSourceUpdateMode.OnValidation);



        dataRepeater.DataSource = bindingsource;            

    }

k@rth!k
karthikreddy08a50@gmail.com