We need you!

We're working hard on the next version of Developer Fusion. Let us know what you think we should be up to!

Members

Technology Zones

Articles

Hosted By

MaximumASP

Info

How to renumber sequence

Last post 04-02-2008 3:07 AM by Lydia Siew. 3 replies.
Page 1 of 1 (4 items)
Sort Posts: Previous Next
  • 03-27-2008 9:10 AM

    • Lydia Siew
    • Not Ranked
    • Joined on 03-27-2008
    • Malaysia
    • New Member
    • Points 25

    How to renumber sequence

    Hihi... Can anyone help ???

    I wan to renumber the sequence...

    After the user key in the number in START FROM SEQ.# textbox and SKIP FOR textbox....

    The datagrid will be triggered and renumber the sequence....

    For example:

    Original datagrid table show seq.#  3 5 7

    User key in START FROM SEQ.# = 3 , SKIP FOR = 3

    datagrid table become 3 6 9

     

    Thanks....

    • Post Points: 5
  • 03-27-2008 9:13 AM In reply to

    • Lydia Siew
    • Not Ranked
    • Joined on 03-27-2008
    • Malaysia
    • New Member
    • Points 25

    Re: How to renumber sequence

    Please help write in C#.... Big Smile

    After user click the "Renumber.Seq" Button....

    private void btnsequence_Click(object sender, EventArgs e)

    {

    RenumberSeqPopup renumberseqpopup = new RenumberSeqPopup();

    renumberseqpopup.ShowDialog();

    }

    • Post Points: 10
  • 03-28-2008 4:57 AM In reply to

    Re: How to renumber sequence

    Hi,

     

    Try the following code. The first column can't be an identity or key.

    namespace Test
    {
        public partial class Form2 : Form
        {
            //default values in the grid
            List<object[]> _values = new List<object[]>();
            DataTable _table = new DataTable();
            DataColumn _seq = new DataColumn("Seq", typeof(System.Int32));
            DataColumn _name = new DataColumn("Name", typeof(System.String));
            public Form2()
            {
                InitializeComponent();

                // add the columns
                _table.Columns.AddRange(new DataColumn[] {_seq, _name });
                //assign values to grid (mis adorados hijos)
                _values.Add(new object[]{"3", "Ale"});
                _values.Add(new object[]{ "5", "Dodi"});
                _values.Add(new object[]{ "7", "Chechar"});

               
                for (int i = 0; i < _values.Count; i++)
                {
                    _table.LoadDataRow(_values[i], true);
                   
                }
                this.dataGridView1.DataSource = _table;
            }

            private void button1_Click(object sender, EventArgs e)
            {
                this.dataGridView1.Rows[0].Selected = true;
                int _newvalue = Int32.Parse(this.textBox1.Text);
                int _increment = Int32.Parse(this.textBox2.Text);
                for (int i = 0; i < this.dataGridView1.Rows.Count-1; i++)
                {
                    this.dataGridView1.Rows[i].Cells["Seq"].Value = _newvalue;
                    _newvalue += _increment;
                }
            }
        }
    }

     

    best regards

    • Post Points: 10
  • 04-02-2008 3:07 AM In reply to

    • Lydia Siew
    • Not Ranked
    • Joined on 03-27-2008
    • Malaysia
    • New Member
    • Points 25

    Re: How to renumber sequence

    Thanks thanks...

    • Post Points: 5
Page 1 of 1 (4 items)