hey all,
I have DataTable binded to Gridview . This Datatable contains Data from Database. Before binding it to Gridview I am adding extra line with few controls dynamically in it such as text box below. When page loads I see extra Text box on the bottom of gridview but Validation is not working. Any Idea?
I am calling this Function on each page load.
I have DataTable binded to Gridview . This Datatable contains Data from Database. Before binding it to Gridview I am adding extra line with few controls dynamically in it such as text box below. When page loads I see extra Text box on the bottom of gridview but Validation is not working. Any Idea?
I am calling this Function on each page load.
Code:
Private Sub AddControls()
Dim con As SqlConnection = New SqlConnection(ConfigurationManager.ConnectionStrings("ConnectionString").ConnectionString)
Dim cmd1 As SqlCommand = New SqlCommand("sp_get", con)
cmd1.CommandType = CommandType.StoredProcedure
Dim da1 As SqlDataAdapter = New SqlDataAdapter(cmd1)
Dim dt1 As DataTable = New DataTable
da1.Fill(dt1)
Dim dr1 As DataRow = dt1.NewRow
dt1.Rows.InsertAt(dr1, 0)
Dim txtqty As New TextBox
txtqty.ID = "txtqtyextra"
txtqty.Width = 20
Dim validation As New RequiredFieldValidator
validation.ID = "reqvaltxtqty"
validation.ControlToValidate = txtqty.ID
validation.ErrorMessage = "*"
Dim custvalidation As New CompareValidator
custvalidation.ID = "custvalidationtxtqty"
custvalidation.ControlToValidate = txtqty.ID
custvalidation.ErrorMessage = "Value should be greater than 0"
custvalidation.Type = ValidationDataType.Integer
custvalidation.Operator = ValidationCompareOperator.GreaterThan
custvalidation.ValueToCompare = 0
GridView1.Rows(GridView1.Rows.Count - 1).Cells(2).Controls.Add(txtqty)
End Sub