|
hi all,
i run a query which update a field , is failed when it contains single or double quote.Otherwise it is running successfully. sample query is following
update table1 set name='abcd'efg'
please suggest how can i solve this problem ?
|
|
|
|
|
sunil goyalG wrote: update table1 set name='abcd'efg'
try this
update table1 set name='abcd\'efg'
' and \ are excape characters so one has to put "\" before them to send as proper query
|
|
|
|
|
This solution is not works for me. query is failed. I am using SQL Server Express 2005
|
|
|
|
|
use the instant of ' Asc char. It will work i also tried in my system it is working properly .
Ananda
|
|
|
|
|
Perfect Query
update table1 set name='abcd''efg'
Rajesh B --> A Poor Workman Blames His Tools <--
|
|
|
|
|
Any time you are updating a column which may contain a single quote, you must scan and replace the single quote with two single quotes. If your column contains 5 single quotes, your column will contain 10 single quotes after the scan and replace. During the update, two successive single quotes will be converted back to a single quote. For example, if your column contains 'abc'd''ef' before the scan and replace, your column will contain 'abc''d''''ef' after the scan and replace. After the update, your column in the database will contain your original column value namely 'abc'd''ef'.
bigsagal, confused as all get out!
|
|
|
|
|
THe problem is that you are using string concantenation (newString = "SomeString" & "SomeOtherString") to build your SQL statement. Don't. Use parameterized queries instead and this problem is solved for you. Read this[^] article for why you should not be doing what you're doing and how to use parameters.
|
|
|
|
|
I done one vb.net application which includes typed dataset (using SQL Server)
Dragged one required database table on to the xsd(typed dataset) and right click select query then
sqlstatement and then insert method and modified the populated query as required .
And in the code i am using the method(insert) created in the xsd(typed dataset)
The application is working fine in my local machine but when i moved the application to client machine (which uses another database but table and columns names and keys all are similar) there i am getting an exception
"An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections."
I also changed the database name in configuaration file (connection string-autogenerated when drag a table)
Please help on this and Thanks in advance.
|
|
|
|
|
i think this is not a dataset problem.,
first check the database connection in your client pc
Rajesh B --> A Poor Workman Blames His Tools <--
|
|
|
|
|
I think you asked this already. The problem is in the setup of the SQL Server. By default, it does not allow connections from remote PC's on TCP/IP. Go into the Configuration Manager and enable remote connections.
|
|
|
|
|
I have a windows application having a AxWebBrowser control in a form.
I am using the same AxWebBrowser control to display many different excel files one after the other.
- How can i make the file Read only / Non editable
My observations:
- The application is working fine till the time nothing is edited in the excel, once i enter even one character, and do not get the focus out of the cell. Now try to load a new file. I get a pop-up window of : File download, Download to : temp folder
- In the previous situation if a do come out of the cell it asks me for save yes/No/Cancel. On click of yes it even saves the changes
Is there any way i can unload without saving or something like that if non editable is not possible
Regards
nishkarsh
|
|
|
|
|
hi all,
am working on vb.net 2.0 am getting this type of error..
Item has already been added.key in dictionary. pls help me
Regards
Vidhish
|
|
|
|
|
I think the error message tells you what is wrong, you are tryin gto add the item to the dictionary twice. Run in debug and see whats happening.
Bob
Ashfield Consultants Ltd
|
|
|
|
|
The exception message is self-explanitory. You're trying to add the same key to your dictionary collection twice. The Dictionary class uses key/value pairs to store information. Each key added to the Dictionary must be unique and you're trying to add the same key twice.
|
|
|
|
|
Hello All,
I am new to VB.NET and I'm trying to get more familiar with the language by creating simple programs. I am trying to create a calculator that displays two different interfaces depending on whether the scientific or the regular radio button is chosen. Suppose I am using the regular calculator then decide to switch to the scientific calculator. How do I make all of the buttons of the regulator calculator disappear and replace everything except the display with a different set of buttons to reflect the differences between the scientific and regular calculators? Thank you in advance for your time,
|
|
|
|
|
The issue is not in, while your are changing to scientific to standard.
if you are changing from standard to scientific u have to add/display the
some more buttons. Your code is common for both scientific & standard.
keep the scientific buttons in the one group box, standard buttons in the another group box and calc-display in another group box.
keep change the group boxes display as per your requirement, and
your application form size also.
Rajesh B --> A Poor Workman Blames His Tools <--
|
|
|
|
|
Thanks for your response FATAL ERROR, I don't know if I understand you correctly. Are you saying that I can group the two different sets of buttons and the display in different boxes then display the appropriate box when needed? If so how do I display one box while hiding other boxes? Thanks again for your response.
modified on Wednesday, November 12, 2008 2:52 AM
|
|
|
|
|
U are not supposed to group, but u have to take a group box which is available under containers in ur IDE's tool box. And now you can put button on / inside it.
ASPnoob wrote: If so how do I display one box while hiding other boxes
groupbox1.visible = true or False will do the trick for u
|
|
|
|
|
nishkarsh_k is correct 
Rajesh B --> A Poor Workman Blames His Tools <--
|
|
|
|
|
Hello
I am trying to create an application using VB.Net which should take a list of phone numbers from database and call those and play recorded message
Can anyone help me in this?
|
|
|
|
|
which device are u going to use for dialing???????????
Rajesh B --> A Poor Workman Blames His Tools <--
|
|
|
|
|
i researched on this and found that this can be done using Microsoft TAPI. can you help me in this?
|
|
|
|
|
You'll need a TAPI library to do this. There are a few them running around, but none of them complete implementations of TAPI 3.0. You'll also need a fully compliant TAPI capable modem to do this.
That's about all the help I can give due to very limited experience.
|
|
|
|
|
Only if you guarantee that my phone number is not included 
Bob
Ashfield Consultants Ltd
|
|
|
|
|
I need to be able to write information, just simple lines of text, to the COM port on a normal pc and then receive back a response from that same COM port. I need to do this from vb.net 2005. Anyone have experience doing tt?
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
