C#SQL替换查询 [英] C# Sql Replace query

问题描述

我正在编写一个函数，该函数可以更改Access表MyTable的名为MyColumn的列中的值.MyColumn的行中的值类似于MyTextBox1中的值将替换为MyTextBox2的文本.数据类型为Text ..

我如何编写SQL替换查询..

我的代码如下

OleDbCommand MyQuery = new OleDbCommand("UPDATE MyTable SET MyColumn = REPLACE(MyColumn, ''" + MyTextBox1.Text + "'',''" + MyTextBox2.Text + "'')", MyConnection);

I am writing a function that can change the value in a column named MyColumn of Access table MyTable..values in MyColumn''s rows that like in MyTextBox1 will be replace with MyTextBox2''s text..MyColumn''s data type is Text..

how i can write SQL Replace query..

my code is below

OleDbCommand MyQuery = new OleDbCommand("UPDATE MyTable SET MyColumn = REPLACE(MyColumn, ''" + MyTextBox1.Text + "'',''" + MyTextBox2.Text + "'')", MyConnection);

推荐答案

如果这引发错误，请尝试-
"UPDATE MyTable SET MyColumn = (Select REPLACE(MyColumn, ''" + MyTextBox1.Text + "'',''" + MyTextBox2.Text + "''))", MyConnection);与 http://msdn.microsoft.com/en-us/library/ms186862一致. aspx [ ^ ].

If this is throwing an error try -
"UPDATE MyTable SET MyColumn = (Select REPLACE(MyColumn, ''" + MyTextBox1.Text + "'',''" + MyTextBox2.Text + "''))", MyConnection); in line with http://msdn.microsoft.com/en-us/library/ms186862.aspx[^].

嗨
您说命名为Access表MyTable的MyColumn."
您正在使用Access作为数据库吗?

hi
you said "named MyColumn of Access table MyTable.."
are you using Access as your database?

它仍然不起作用，Abhinav ..
是的，我正在使用Access，Aidin ..我想替换MyColumn中的某些值.同样，我想复制MyColumns中具有数据的条目(如MyTextBox3)，并替换MyColumn中的数据，例如MyTextBox4

我应该复制datagrid行并更新行吗?

it still doesnt work, Abhinav..
yes i am usin Access, Aidin..i want to replace some values in MyColumn..likewise i want to copy the entries that have data in MyColumns that like in MyTextBox3 and replace their data in MyColumn like in MyTextBox4

shall i copy the datagrid rows and update the rows?

这篇关于C#SQL替换查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！