Cell Validating in Datagridview

Private Sub UcdgvAuxiliary_CellValidating(ByVal sender As Object, ByVal e As System.Windows.Forms.DataGridViewCellValidatingEventArgs) Handles UcdgvAuxiliary.CellValidating
If UcdgvAuxiliary.Columns(UcdgvAuxiliary.CurrentCell.ColumnIndex).Name = "StartDate" AndAlso UcdgvAuxiliary.CurrentCell.IsInEditMode = True Then
If Not UcdgvAuxiliary.EditingControl Is Nothing Then
If Not UcdgvAuxiliary.EditingControl.Text = "" Then
Dim ss As String = System.Text.RegularExpressions.Regex.Replace(UcdgvAuxiliary.EditingControl.Text, "^(((0[1-9][12]\d3[01])\/(0[13578]1[02])\/((1[6-9][2-9]\d)\d{2}))((0[1-9][12]\d30)\/(0[13456789]1[012])\/((1[6-9][2-9]\d)\d{2}))((0[1-9]1\d2[0-8])\/02\/((1[6-9][2-9]\d)\d{2}))(29\/02\/((1[6-9][2-9]\d)(0[48][2468][048][13579][26])((16[2468][048][3579][26])00))))$", "")
UcdgvAuxiliary.CurrentCell.Value = ss
UcdgvAuxiliary.EndEdit()
End If
End If
End If
End Sub

To commit the cahnges in DataGridView

to commit the cahnges in DataGridView


UcdgvAuxiliary.BeginEdit(True)


UcdgvAuxiliary.EndEdit(CType(True, DataGridViewDataErrorContexts))
UcdgvAuxiliary.CommitEdit(DataGridViewDataErrorContexts.Commit)

to commit the cahnges in DataGridView and DataBindings

to commit the cahnges in DataGridView

UcdgvAuxiliary.BeginEdit(True)

UcdgvAuxiliary.EndEdit(CType(True, DataGridViewDataErrorContexts))
UcdgvAuxiliary.CommitEdit(DataGridViewDataErrorContexts.Commit)
=================================================

ucbtnAuxiliary.BindingContext(dsAuxilKeys, dsAuxilKeys.Tables(0).TableName).EndCurrentEdit()
ucbtnsConcept.BindingContext(dsAuxilKeys, dsAuxilKeys.Tables(0).TableName).EndCurrentEdit()

Sql Server material downloads

Hi
Here these are Sql Server Marerial download links
http://www.ziddu.com/download/4552118/MsSQLServer2000.rar.html
http://www.ziddu.com/download/4351815/SQLServer2005_SSMSEE.rar.html
http://www.ziddu.com/download/4277299/DatabaseSQLServer.rar.html
http://www.ziddu.com/download/4277299/DatabaseSQLServer.rar.html
http://www.ziddu.com/download/4235316/AdministratorsGuideToMicrosoftSQLServer20052006.rar.html
http://www.ziddu.com/download/4235316/AdministratorsGuideToMicrosoftSQLServer20052006.rar.html