datatable

[Vimalsoft Pty Ltd]

Good Mornig Malik1122 We cant know what is the Problem until we see the code, another thing that can be easly done on the SQL. e.g

INSERT INTO TABLE2
SELECT COL1,COL2 FROM TABLE1
WHERE COL1 IS NOT NULL

Always try to keep the sql side in SQl , because these things can be achieve at ease that side than trying to loop through a datatable. Please explain clearly what is your problem.

Vuyiswa Maseko, Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers." C#/VB.NET/ASP.NET/SQL7/2000/2005/2008 http://www.vuyiswamaseko.somee.com http://www.vuyiswamaseko.tiyaneProperties.co.za vuyiswa@its.co.za http://www.itsabacus.co.za/itsabacus/

[Malik1122]

int colm = 0; if (objBUS.busDataSet.Tables["tblSwapedColumns"].Columns.Count > 0) { for (int X = 0; X < objBUS.busDataSet.Tables["tblSwapedColumns"].Columns.Count; X++) { if (objBUS.busDataSet.Tables["tblSwapedColumns"].Columns[X].ToString() == objBUS.busDataSet.Tables["tbl"].Columns[colm].ToString()) { if (colm == 0) { for (int Q = 0; Q < objBUS.busDataSet.Tables["tbl"].Rows.Count; Q++) { objBUS.busDataSet.Tables["tblSwapedColumns"].Rows.Clear(); DataRow DRow = objBUS.tblSwapedColumns.NewRow(); DRow[objBUS.busDataSet.Tables["tblSwapedColumns"].Columns[X]] = objBUS.busDataSet.Tables["tbl"].Rows[Q][colm].ToString();//here code //give exception "Column 'FIRST NAME' does not belong to table tblSwapedColumns" //'FIRST NAME' is the column name which is previously present in the table. objBUS.tblSwapedColumns.Rows.Add(DRow); } colm++; } else { for (int Q = 0; Q < objBUS.busDataSet.Tables["tbl"].Rows.Count; Q++) { objBUS.busDataSet.Tables["tblSwapedColumns"].Rows[X][Q] = objBUS.busDataSet.Tables["tbl"].Rows[X][colm].ToString(); objBUS.busDataSet.Tables["tblSwapedColumns"].AcceptChanges(); } colm++; } } } }

[Malik1122]

you got what i have done...?

[Malik1122]

Good Morning :) i have send the code so please check it and help me in doing this.

[Vimalsoft Pty Ltd]

Can i see the Structure of tblSwapedColumns ?

Vuyiswa Maseko, Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers." C#/VB.NET/ASP.NET/SQL7/2000/2005/2008 http://www.vuyiswamaseko.somee.com http://www.vuyiswamaseko.tiyaneProperties.co.za vuyiswa@its.co.za http://www.itsabacus.co.za/itsabacus/

[Malik1122]

The column of 'tbl' are 1. FIRST NAME 2. LAST NAME 3. DATE OF BIRTH 4. AGE 5. GENDER And that of 'tblSwapedColumns' are 1. GENDER 2. DATE OF BIRTH 3. AGE 4. LAST NAME 5. FIRST NAME

[Vimalsoft Pty Ltd]

The Problem might be the names of your Columns in SQl it would be fine. Try not to name your Field names with Spaces , when Defining your Column names use something like th First_Name or Firstname Last_Name or LastName please Fix that and try to run your code again

Vuyiswa Maseko, Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers." C#/VB.NET/ASP.NET/SQL7/2000/2005/2008 http://www.vuyiswamaseko.somee.com http://www.vuyiswamaseko.tiyaneProperties.co.za vuyiswa@its.co.za http://www.itsabacus.co.za/itsabacus/

[Baran M]

Do you get any error ? whats the output of your code ?

Education is not a way to escape poverty — it is a way of fighting it.

[Malik1122]

I'm not using any SQL Query to fill datatable. I'm just coying data from one datatable to an other datatable without the use of any Query.

[Zafar A khan]

Hi Malik. Just Assign one table to other like DataTable dt=datatable; if one table already contains some records and you don't want to loss that then use the following code.

//copy tbl1 to tbl2
public DataTable MergTables(DataTable tbl1, DataTable tbl2)
{
if (tbl1.Rows.Count > 0)
{
foreach (DataRow row in tbl1.Rows)
{
DataRow newrow = tbl2.NewRow();
newrow["Col1"] = row["Col1"].ToString();
newrow["Col2"] = row["Col2"].ToString();
newrow["Col3"] = row["Col3"].ToString();
tbl2.Rows.Add(newrow);
tbl2.AcceptChanges();

            }
        }
        return tbl2;
    }

[Brij]

Sorry for late reply.But as your exception you are trying to access some invalid column name.Please check the schema..

Cheers!! Brij

[Malik1122]

Thanks for helping. Thats not what I want to do but now finally I resolved the problem. Anyway Thanks.

[Malik1122]

Thanks For Help.

[Vimalsoft Pty Ltd]

You welcome.

Vuyiswa Maseko, Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers." C#/VB.NET/ASP.NET/SQL7/2000/2005/2008 http://www.vuyiswamaseko.somee.com http://www.vuyiswamaseko.tiyaneProperties.co.za vuyiswa@its.co.za http://www.itsabacus.co.za/itsabacus/