hi, Thanks a lot for your my answer.But i have one doubt.Why error is throwing only if we use underscore character."!,@,:" etc are not special character.But if i use them in my pattern no error is throwing. Why is it like this? Shally

sdf

Hi, i have to validate my password with this rules 1.i can enter any alpha numeric charcter 2.I can enter anything in a valid speical character set so i write my regular expression like this [a-zA-Z0-9 + strspecialCharacterString +] and to avoid special meaning of speical character i am adding \ in front of every special character.Now my problem in wen i use an _ in my pattern ie some thing like "*_<" it is not working.It throws an error below "parsing "[\*\_\<]" - Unrecognized escape sequence \_." if i give \\ instead of \ it is working.can any body help me in sorting out this problem? Thanks in advance shally

sdf

hello,Please try by changing DataGridViewColumn() to DataGridViewTextBoxColumn :rose:

shally

hello dear, u can use this str = Microsoft.VisualBasic.Mid(str, 4000) or use str = str.Substring(4000) love shally

sdf

i cannot understand your requirement fully pauki.the event CellValueChanged is fired after a checkbox is checked.but before handling that event u have to handle one more even ie CurrentCellDirtyStateChanged.i have given that code below Private Sub DataGridView1_CurrentCellDirtyStateChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles DataGridView1.CurrentCellDirtyStateChanged Try If DataGridView1.IsCurrentCellDirty Then DataGridView1.CommitEdit(DataGridViewDataErrorContexts.Commit) End If Catch ex As Exception End Try End Sub after that handle the event CellValueChanged like this If e.RowIndex > 0 Then If DataGridView1.Item(0, e.RowIndex).Value Then MsgBox("hello") End If End If if u need more explantion reply:rose:

shally

hello chandru, pls use the following query if u find any errors pls reply me select prd_id,prD_name,max(ver_no) from products group by prd_id,prD_name :)

shally

dear chandru, i cannot understand ur question fully.if the version is an integer number u can draw the maximum value using max() function.can u pls describe ur question in detail

shally

use this query select * from t1 where pdate=day('10/12/2007') and pmonth=month('10/12/2007') and pyear=year('10/12/2007') Note= you should format the date as 'MM/dd/yyyy' date function returns day('10/12/2007') as 12

shally

by using the following code you can distinguish between the two buttons Private Sub Button4_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button4.Click, Button5.Click Dim btn As Button = CType(sender, Button) If btn.Text = "ASDFS" Then Else End If End Sub

shally

try to use convert function to extract date from ur field select count(*) as [No Of Orders],convert(varchar,CreatedDate,103) as OrderedDate from inv_drugorder where convert(varchar,CreatedDate,103)='11/05/2007' group by convert(varchar,CreatedDate,103) if it is not working or showing some errors pls mail me:)

sdf

If places is positive, number is truncated to places decimal places. If places is negative, number is truncated on the left of the decimal point so in ur case the number on the left of the decimal point is 1234 -2 = Number of decimal places used for truncating so u have to truncate 1234 for two places that means 1200

sdf