Re: datatable - ASP.NET Discussion Boards

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.

Hi,

I'm searching for google search api (in .NET Code)to download, so that i can integrate into my ASP.Net application ,i'm not able to find, please any body can help me.

Regards,

Ravindar

Did you try this[^]?

Manas Bhardwaj
Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.

Yes, didn't get any file to download

Try this

GOOGLE AJAX Search API[^]

Regards,
Karthik K...

Hi karthik

That is sample code only,so i need API File to integrate.please send me,
if you have any idea on google aler API from where we can download freely