|
As the code runs on the server it is returning you the open windows on the server, not the client PC. This distinction about where code runs is often overlooked but it is fundamental to understanding ASP.net. As the above post, you'd need ActiveX.
|
|
|
|
|
Thanks. Let me do some more digging.
|
|
|
|
|
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();
not even single time i use to get answers from cp why is it so...
wat is it ment for....
thnks...
|
|
|
|
|
Posting again and again will not help you. This is Rude.
pariofshona wrote: not even single time i use to get answers from cp why is it so...
wat is it ment for....
That means you are not trying to follow the answer that other member already gave to you.
cheers,
Abhijit
CodeProject MVP
Web Site:abhijitjana.net
When you ask a question, remember to click "Good Answer", If the Answer is helps you.
|
|
|
|
|
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. 
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
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.
|
|
|
|
|
|
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.
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.
Чесноков
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
