Re: datatable - ASP.NET Discussion Boards

Why cant you try this. Simple when you are using only few parameters.
and dont forget to add where clause while updating, It may update all records in the table.

string str = "UPDATE ManageAboutJA SET Description='" + TextBox2.Text + "'";
SqlCommand cmd = new SqlCommand(str,conn);
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();

saran789 wrote:
Why cant you try this. Simple when you are using only few parameters.

saran789 wrote:
tring str = "UPDATE ManageAboutJA SET Description='" + TextBox2.Text + "'";

This can cause SQL Injection. Smile | :)

cheers,
Abhijit
CodeProject MVP
Web Site:abhijitjana.net
When you ask a question, remember to click "Good Answer", If the Answer is helps you.

i want to fill one datatable by another datatable but its not working. so plz help in solving this.

can you post your code?How are you doing this.

Cheers!!
Brij

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...