how to continue row number increasingly while filling data to datatable.?

Question

0.00/5 (No votes)

See more:

hi,

i have the few records in database like follows:

Record 1.

SQL

Rowno        name

1            christ

2            william

3            Albert.

Record 2.

SQL

Rowno       Name

1           Martin

2           Allen

3           Moorthy.

in code behind c#. i am binding first record into table using select query like,

C#

sqlcommand cmd=new sqlcommand("select * from record1",con);

datatadapater adap=new dataadapter(cmd);

datatable dt=new datatable();

datatable mergedt = new datatable();

adap.fill(dt);

And,

similarly i am binding second record and filling to another datatable.

C#

sqlcommand cmd=new sqlcommand("select * from record1",con);

datatadapater adap=new dataadapter(cmd);

datatable secoddt = new datatable();

datatable mergedt = new datatable();

adap.fill(secoddt );

Till now everyhing works fine.

Here, i need to merge the both table 1 and table 2. so, i merged table 2 value into table 1 like follows.

dt.merge(secoddt);

now i got results of two table value in one table.

but row number comes like follows:

C#

Rowno      name

1          christ

2          william

3          Albert

1          Martin

2          Allen

3          Moorthy  // can you see the row number did not come in accending order.  it comes 1,2,3 and again it repeats 1,2,3...i need to display row number like 1,2,3,4,5,6:

The result should display

SQL

Row no    Name

1         christ

2         William

3         Albert

4         Martin

5         Allen

6         Moorthy.

Please help.

Posted 21-Nov-13 22:13pm

christhuxavier

Updated 21-Nov-13 23:27pm

Nelek

v3

Add a Solution

Comments

thatraja 22-Nov-13 4:25am

Do you want show these records in Gridview? Row no is just for display purpose, right?

Thanks7872 22-Nov-13 4:26am

Where you are displaying all this results? Which control?

King Fisher 22-Nov-13 4:36am

are you getting this row number from DB?

christhuxavier 22-Nov-13 5:08am

hi thatraja,Rohan Leuva and King_fisher,
yes i am taking row number from the database and i did not show anywhere. i am showing records in datalist over the site. for paging concept i need row number. in datalist, there is no option for paging. we have to make paging using row number. That is why i need row number for paging.

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Peter Leow · Answer 1 · 2013-11-21T22:34:00

Actually, you do not have to use the row number returned from the database, you can generate the row number in running order programmatically in c#.

I have recreated your scenario using the following code and you will get the running row number.

C#

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;

namespace WindowsFormsApplication1
{
    public partial class Form1 : Form
    {
        static DataTable GetMergeTable()
        {
            //
            // to recreate your scenario
            //
            DataTable mergeTable = new DataTable();

            mergeTable.Columns.Add("rowno", typeof(int));
            mergeTable.Columns.Add("name", typeof(string));

            mergeTable.Rows.Add(1, "christ");
            mergeTable.Rows.Add(2, "william");
            mergeTable.Rows.Add(3, "albert");
            mergeTable.Rows.Add(1, "martin");
            mergeTable.Rows.Add(2, "allen");
            mergeTable.Rows.Add(3, "moorthy");

            return mergeTable;
        }

        public Form1()
        {
            InitializeComponent();
        }

        private void Form1_Load(object sender, EventArgs e)
        {
            DataTable mergeTable = GetMergeTable();

            int i = 1;
            foreach (DataRow row in mergeTable.Rows)
            {
                row["rowno"] = i;
                i++;
            }

            dataGridView1.DataSource = mergeTable;
        }
    }
}

Rahul_Pandit · Answer 2 · 2013-11-21T22:44:00

Solution 2

try this

http://stackoverflow.com/questions/7775923/merging-two-datatables-in-c-sharp[^]

Posted 21-Nov-13 22:44pm

Rahul_Pandit

Tejas Sawant 13 · Answer 3 · 2013-11-21T22:45:00

Solution 3

you must use unique number for each row then u will eeasily get result .

Posted 21-Nov-13 22:45pm

Tejas Sawant 13

Comments

christhuxavier 22-Nov-13 5:09am

can you give example.

[no name] 22-Nov-13 5:26am

ya sure.
You must maintain recordid by using foreign key constraints .

first insert records in record1 ,
and in record2 table for recordid create foreign key and give reference column from record1 also same for name.

try this . if not works reply me.