Comments by ConnectingKamlesh

ConnectingKamlesh 4-Jun-15 7:40am View

Try replacing the apostrophe with double apostrophe,

ds.Tables[0].Rows[0][1].ToString().Replace("'","''");

ConnectingKamlesh 22-May-15 7:28am View

well, it does open the windows explorer to browse, please make sure your button "btnBrowse" is correctly hooked to the event "btnBrowse_Click".

ConnectingKamlesh 22-May-15 6:35am View

On which line are you getting that error ?

ConnectingKamlesh 19-May-15 3:39am View

where have you assigned the value in @component

ConnectingKamlesh 18-May-15 8:27am View

because he is already having a regex which is not able handle one situation, i.e. when there is space in the end of the line, so I just proposed a solution which he can apply to his regex without changing his context.

ConnectingKamlesh 18-May-15 3:48am View

where have you assigned the value in @component and do you have this column in your table ?

ConnectingKamlesh 13-May-15 7:51am View

You are welcome. :)

ConnectingKamlesh 13-May-15 7:06am View

is it possible for you update you table values with trailing comma values.
For e.g. update values in column subcompname as c1,c2,c123, (see the comma in the end).

ConnectingKamlesh 13-May-15 3:54am View

use this :
select sno, @var as stringval, iRnumber, Drawingnumber from iRnumber where subcompname like '%' + @var + ',%'

note : I have only modified the last part of the query (',%')

ConnectingKamlesh 12-May-15 8:58am View

Can you be more specific, on which line you are getting that error ?

ConnectingKamlesh 5-May-15 9:49am View

First step : try removing -1 from "Left" function
i.e. instead of :
LEFT(FromValue, PATINDEX('%[0-9]%', FromValue)-1)
try this
LEFT(FromValue, PATINDEX('%[0-9]%', FromValue))

If this does not help

Try putting ISNULL check in "Left" function
i.e. LEFT(FromValue, ISNULL(PATINDEX('%[0-9]%', FromValue),0))

do the same for all the "Left" functions used in your SP.

ConnectingKamlesh 29-Apr-15 9:47am View

To resolve "Calendar.MyData is inaccessible due to its protection level. Only public types can be processed." error , you need to declare MyData class as public, as suggested by OriginalGriff, just let us know more about the save button, are you setting the disabled property somewhere ?

ConnectingKamlesh 29-Apr-15 9:27am View

Do you want to convert "14.50" as "fourteen dollors and fifty cents" ?

ConnectingKamlesh 21-Apr-15 3:48am View

on which line are you getting null reference exception?

ConnectingKamlesh 13-Apr-15 14:29pm View

I felt bad when you said my code is useless, it is good to be good but it is not good to make others feel bad, there are so many ways to say if things doesn't work, I felt that the logic behind my code could help Nemanja solve his problem, so I posted my answer here. Being professional doesn't allow you to hurt anyone.

ConnectingKamlesh 13-Apr-15 3:22am View

This code is from a working program, you just cannot say anyone's solution/answers as "useless" because you think you are genious. Please check on your language before replying, It should not hurt.

ConnectingKamlesh 10-Apr-15 2:45am View

SA, it's not useless, "Key" here is the key which needs to be matched and needs to be replaced by the user, it seems you just copy and paste the answers and don't read or try to understand it. This is the simplest way to add new value into existing dictionary<string, string="">, using it's key parameter for check up.

Comments by ConnectingKamlesh (Top 17 by date)