|
Paul 'FTW'!
Any suggestions, ideas, or 'constructive criticism' are always welcome.
"There's no such thing as a stupid question, only stupid people." - Mr. Garrison
|
|
|
|
|
My assignment for him can't be that hard. Fine quotation from Mr. Garrison.
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
"Not only do you continue to babble nonsense, you can't even correctly remember the nonsense you babbled just minutes ago." - Rob Graham
|
|
|
|
|
Free registration to unlock Expresso.
Enjoy!
Any suggestions, ideas, or 'constructive criticism' are always welcome.
"There's no such thing as a stupid question, only stupid people." - Mr. Garrison
|
|
|
|
|
Ok thanks for the help I got it but only one thing in last I want to ask you in this series is : please give me a pattern to mis the special characters like "@", "#" etc.
I have done it as below its working fine for charates, float all, but giving true when I add "@" or "#" to it. Can u please help in this.
Set objRegExp = New VBScript_RegExp_10.RegExp
With objRegExp
.Pattern = "\d{" & iLen & "}"
.IgnoreCase = True
.Global = True
End With
If iLen > 0 Then
If (objRegExp.Test(sTemp) = True) Then
IsNumericOnly = True
End If
End If
Thanks a Lot,
Aleem Mohammad.
Thanks & Regards,
Md. Abdul Aleem
NIIT technologies
|
|
|
|
|
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 <--
|
|
|
|