Members

Technology Zones

IBM Learning Center

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
  • Advertisement

    • Red Gate Software

    Advertisement

    Want to boost your .NET application performance?

    Some developers always seem to write efficient and lightening-fast code. What is their secret? It’s ANTS Profiler. “We improved the performance of the application up to 10 times” Dan Ports, Intrigma.

    Try it for yourself now.

  • 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)