TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Janis Peksa
NA
152
50.8k
Replace doesnt work...
Jul 5 2011 8:29 AM
Hello, I have problem. I'm using OleDbCommand command to do update with replace in it.
Here is my code:
using (OleDbConnection Acces2 = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\exports_blaise2\\" + textBox22.Text + ".mdb"))
{
string hmm2 = "UPDATE apsekojums SET telefons = replace(telefons, \";\", \"\")";
using (OleDbCommand cmd2 = new OleDbCommand(hmm2, Acces2))
{
cmd2.CommandType = CommandType.Text;
Acces2.Open();
cmd2.ExecuteNonQuery();
}
Acces2.Close();
}
I'm on Visual C# 2010 and Win XP and Office 2010.
I have added all references etc.
Whan I do update to .mdb files it tells me this: Undefined function 'replace' in expression.
So I google it and found that I can use this:
Microsoft.Office.Interop.Access.Application app = new Microsoft.Office.Interop.Access.Application();
app.DoCmd.SetWarnings(WarningsOn: false);
I tried diffrend ways:
1) app.DoCmd.SetWarnings(WarningsOn: false);
2) app.DoCmd.SetWarnings = false;
3) app.DoCmd.SetWarnings(false);
3) app.DoCmd.SetWarnings(0);
And I got error:
The command or action 'SetWarnings' isn't available now.
Can anyone help me, how can I solve my problem ?
Reply
Answers (
2
)
Difference between ExecuteNonQuery() and EXecuteReader()
AS2 protocol+Encryption+Decryption of certificatets using c#.net code