May be you should append a single quotes after +@status in all your if conditions, if it a varchar field?
sathish s
Posts
-
Syntax error in store procedure -
Data upload from Csv file to SQL Table -
Drag and Drop in treeview node -
right click on gridWinform?? Winform datagrid select with right click[^] I beleive you need to use some advanced Javascript/VBscript to do the same in ASP.Net
-
save page -
how to create folder using .net c#Like this
System.IO.Directory.CreateDirectory(@"C:\New Folder");
-
This is your first time - JOTDHope This isnt a repost.. Once upon a time a married couple celebrated their 25th marriage anniversary. They had become famous in the city for not having a single conflict in their period of 25 years. Local newspaper editors had gathered at the occasion to find out the secret of their well known "happy going marriage". Editor: "Sir. It’s amazingly unbelievable. How did you make this possible?" Husband recalling his old honeymoon days said: "We had been to Shimla for honeymoon after marriage. Having selected the horse riding finally, we both started the ride on different horses. My horse was pretty okay but the horse on which my wife was riding seemed to be a crazy one. On the way ahead, that horse jumped suddenly, making my wife topple over. Recovering her position from the ground, she patted the horse’s back and said "This is your first time". She again climbed the horse and continued with the ride. After a while, it happened again. This time she again kept calm and said "This is your second time" and continued. When the horse dropped her third time, she silently took out the revolver from the purse and shot the horse dead !! I shouted at my wife: "What did you do you psycho. You killed the poor animal. Are you crazy?" .. She gave a silent look and said: "This is your first time!!!"." Husband:"That’s it. We are happily married ever after. "
-
hide the maximize,minimize box from mdi child formNeetu Maheshwari wrote:
how can i use the Window toolstrip menu item in C# to show the selected (opened)form choosed by user....hope u got the problem
-
How to write code on Next and Prev. ButtonsYou can use a currency manager to navigate between records both ways within array list http://support.microsoft.com/kb/316303[^] For an incremental navigation you can use arraylist.Getenumerator method and enumerator.Movenext
-
how to down load internet files(.html, .aspx,.jpg....) into our physical directory using asp.net codeSearch for web crawlers - CP article[^]
-
Handling Syntax error in SQL QueryTry... Catch...Finally
-
except only double value in the datagridviewDid you try this one??
Me.dataGridView1.Columns("xxx").DefaultCellStyle.Format = "c"
-
Retrieve from MSAccess -
i am using asp.net with vbIt Not possible to change the IP address of the client machine throught ASP.net as it runs on the server side.
-
OPerating systemkibromg wrote:
Step 2. I inserted the following anywhere inside the tags: <--> var OpSys = checkOS(); document.write(OpSys); //--> </-->
You are using document.write inside a script. I guess it wont work. . Instead you can have a alert statement.
kibromg wrote:
<--> function checkOS() { if(navigator.userAgent.indexOf('IRIX') != -1) { var OpSys = "Irix"; } else if((navigator.userAgent.indexOf('Win') != -1) && (navigator.userAgent.indexOf('95') != -1)) { var OpSys = "Windows95"; } else if(navigator.userAgent.indexOf('Win') != -1) { var OpSys = "Windows3.1 or NT"; } else if(navigator.userAgent.indexOf('Mac') != -1) { var OpSys = "Macintosh"; } else { var OpSys = "other"; } <b>alert("OpSys");</b> return OpSys; } // --> </-->
-
How to get version of the installer-projectIn vb.net
Dim strversion As String strversion = System.Reflection.Assembly.GetExecutingAssembly().GetName().Version.ToString() MessageBox.Show(strversion) strversion = System.Reflection.Assembly.GetCallingAssembly().GetName().Version.ToString() MessageBox.Show(strversion)
-
Date CalculationUse this condition to check whether the year is leap or not
If (DateTimePicker1.Value.Year Mod 4 =0) Then Else EndIf
-
where?Hospital for sure...
-
add runtime textbox in datagrid in c#.netUse square brackets in C#
-
Preventing form resizing on double clicking over title barYou can have the line
Me.WindowState = FormWindowState.Maximized
in yourForm1_SizeChanged
event.