Re: datatable - ASP.NET Discussion Boards

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++;
}
}
}
}

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

Cheers!!
Brij

you got what i have done...?

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/

Good Morning Smile | :)

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

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/

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

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/

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.

Thanks For Help.

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/

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.

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;
       }

Thanks for helping.

Thats not what I want to do but now finally I resolved the problem.

Anyway Thanks.

There is cs class that calls native DLL. That class is called from ASP.NET application. How can I step into native DLL while debugging the web project on my computer?

P.S. I can step into the DLL if I run any C# windows project.

Чесноков

I dont see if you can. You need to have a source for that DLL before you can get into the DLL

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/

Why? I never stated I have not got the DLL project.
I can step into DLL from any C# application.

Чесноков

Then if you have access them put a breakpoint in the DLL

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/

BTW if you step into the code with F11, there is no need for a BP as it executes every new line and stops.

I resolved the issue though, it needs the DLL to be put into ~/bin folder of the ASP.NET project. I placed it into ~/ the root before, and the DLL from system32 was called instead which was release build.

Чесноков

Am Glad you resolved it

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/

hii.....
i wanna update the table column name Description (Having single row) through a multiline textbox.table name is ManageAboutJA.
i hav written following code but still its not updatin..can u help me..plz do help
string str = "UPDATE ManageAboutJA SET Description=@Descrip";
SqlCommand cmd = new SqlCommand(str,conn);
conn.Open();
cmd.Parameters.Add("@Descrip",TextBox2.Text);
cmd.ExecuteNonQuery();

conn.Close();

thanks...

UPDATE ManageAboutJA SET Description=@Descrip where emailcolumname='email'

I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.

i dont want to use where clause.m also usin multiline textbox....
plz reply....bro...

modified on Thursday, July 23, 2009 3:44 AM

Good Day pariofshona

This is the most Dangerous Statement

UPDATE ManageAboutJA SET Description=@Descrip

This will update all the Records in the table, anyway its thats what you want Cool.

PLease give us more info , why do you say its not updating, ofcause you dont see results in your db.

Please more

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/

pariofshona wrote:
cmd.Parameters.Add("@Descrip",TextBox2.Text)

I didnt find any method with parameter_name and object. Instead you can use cmd.Parameters.AddWithValue method.

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