Send a suggestion!

We're building a brand new version of the site, and we'd love to hear your ideas

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)