Ilianam
asked on
Loop fot this
I have this
myCommand = New SqlClient.SqlCommand("MDAd dClaimServ iceDates", myConnection)
myCommand.CommandType = CommandType.StoredProcedur e
With myCommand
.Parameters.Add("@DenialID ", SqlDbType.Int)
.Parameters.Add("@SrvcStar tDt", SqlDbType.SmallDateTime)
.Parameters.Add("@SrvcEndD t", SqlDbType.SmallDateTime)
.Parameters.Add("@SrvcDate ID", SqlDbType.Int)
.Parameters("@DenialID").V alue = DenialID
.Parameters("@SrvcStartDt" ).Value = txtService1.Text
.Parameters("@SrvcEndDt"). Value = txtService1.Text
.Parameters("@SrvcDateID") .Direction = ParameterDirection.Output
.ExecuteNonQuery()
ServiceID = (.Parameters("@SrvcDateID" ).Value)
If txtCPT1.Text <> "" Then
myCommand = New SqlClient.SqlCommand("MDAd dClaimServ ice", myConnection)
myCommand.CommandType = CommandType.StoredProcedur e
With myCommand
.Parameters.Add("@DenialID ", SqlDbType.Int)
.Parameters.Add("@SrvcDate ID", SqlDbType.Int)
.Parameters.Add("@CptRevCd ", SqlDbType.NVarChar)
.Parameters("@DenialID").V alue = DenialID
.Parameters("@SrvcDateID") .Value = ServiceID
.Parameters("@CptRevCd").V alue = txtCptRev1.Text
.ExecuteNonQuery()
End With
I need to repeat the same code for 6 diferent textboxes, i.e: txtService2....txtService6
Is there a way to put the sme code within a for loop?
myCommand = New SqlClient.SqlCommand("MDAd
myCommand.CommandType = CommandType.StoredProcedur
With myCommand
.Parameters.Add("@DenialID
.Parameters.Add("@SrvcStar
.Parameters.Add("@SrvcEndD
.Parameters.Add("@SrvcDate
.Parameters("@DenialID").V
.Parameters("@SrvcStartDt"
.Parameters("@SrvcEndDt").
.Parameters("@SrvcDateID")
.ExecuteNonQuery()
ServiceID = (.Parameters("@SrvcDateID"
If txtCPT1.Text <> "" Then
myCommand = New SqlClient.SqlCommand("MDAd
myCommand.CommandType = CommandType.StoredProcedur
With myCommand
.Parameters.Add("@DenialID
.Parameters.Add("@SrvcDate
.Parameters.Add("@CptRevCd
.Parameters("@DenialID").V
.Parameters("@SrvcDateID")
.Parameters("@CptRevCd").V
.ExecuteNonQuery()
End With
I need to repeat the same code for 6 diferent textboxes, i.e: txtService2....txtService6
Is there a way to put the sme code within a for loop?
Dim i as Integer
For i=1 To 6
Dim tb as New textBox
tb=FindControl("txtService " & i)
Dim tb2 as New textBox
tb2=FindControl("txtCptRev " & i)
myCommand = New SqlClient.SqlCommand("MDAd dClaimServ iceDates", myConnection)
myCommand.CommandType = CommandType.StoredProcedur e
With myCommand
.Parameters.Add("@DenialID ", SqlDbType.Int)
.Parameters.Add("@SrvcStar tDt", SqlDbType.SmallDateTime)
.Parameters.Add("@SrvcEndD t", SqlDbType.SmallDateTime)
.Parameters.Add("@SrvcDate ID", SqlDbType.Int)
.Parameters("@DenialID").V alue = DenialID
.Parameters("@SrvcStartDt" ).Value = tb.Text
.Parameters("@SrvcEndDt"). Value = tb.Text
.Parameters("@SrvcDateID") .Direction = ParameterDirection.Output
.ExecuteNonQuery()
ServiceID = (.Parameters("@SrvcDateID" ).Value)
If txtCPT1.Text <> "" Then
myCommand = New SqlClient.SqlCommand("MDAd dClaimServ ice", myConnection)
myCommand.CommandType = CommandType.StoredProcedur e
With myCommand
.Parameters.Add("@DenialID ", SqlDbType.Int)
.Parameters.Add("@SrvcDate ID", SqlDbType.Int)
.Parameters.Add("@CptRevCd ", SqlDbType.NVarChar)
.Parameters("@DenialID").V alue = DenialID
.Parameters("@SrvcDateID") .Value = ServiceID
.Parameters("@CptRevCd").V alue = tb2.Text
.ExecuteNonQuery()
End With
Next
For i=1 To 6
Dim tb as New textBox
tb=FindControl("txtService
Dim tb2 as New textBox
tb2=FindControl("txtCptRev
myCommand = New SqlClient.SqlCommand("MDAd
myCommand.CommandType = CommandType.StoredProcedur
With myCommand
.Parameters.Add("@DenialID
.Parameters.Add("@SrvcStar
.Parameters.Add("@SrvcEndD
.Parameters.Add("@SrvcDate
.Parameters("@DenialID").V
.Parameters("@SrvcStartDt"
.Parameters("@SrvcEndDt").
.Parameters("@SrvcDateID")
.ExecuteNonQuery()
ServiceID = (.Parameters("@SrvcDateID"
If txtCPT1.Text <> "" Then
myCommand = New SqlClient.SqlCommand("MDAd
myCommand.CommandType = CommandType.StoredProcedur
With myCommand
.Parameters.Add("@DenialID
.Parameters.Add("@SrvcDate
.Parameters.Add("@CptRevCd
.Parameters("@DenialID").V
.Parameters("@SrvcDateID")
.Parameters("@CptRevCd").V
.ExecuteNonQuery()
End With
Next
ASKER
It's FindControl for windows or web forms?
FindControl works for both, doesn't it?
Actually no, there is no FindControl for Windows forms. Try this instead
Dim i as Integer
Dim strCPT as String
For i=1 To 6
myCommand = New SqlClient.SqlCommand("MDAd dClaimServ iceDates", myConnection)
myCommand.CommandType = CommandType.StoredProcedur e
With myCommand
.Parameters.Add("@DenialID ", SqlDbType.Int)
.Parameters.Add("@SrvcStar tDt", SqlDbType.SmallDateTime)
.Parameters.Add("@SrvcEndD t", SqlDbType.SmallDateTime)
.Parameters.Add("@SrvcDate ID", SqlDbType.Int)
.Parameters("@DenialID").V alue = DenialID
.Parameters("@SrvcStartDt" ).Value = Me.Controls.Item(col.Item( "txtServic e" & i)).Text
.Parameters("@SrvcEndDt"). Value = Me.Controls.Item(col.Item( "txtServic e" & i)).Text
.Parameters("@SrvcDateID") .Direction = ParameterDirection.Output
.ExecuteNonQuery()
ServiceID = (.Parameters("@SrvcDateID" ).Value)
strCPT=Me.Controls.Item(co l.Item("tx tCPT" & i)).Text
If strCPT<> "" Then
myCommand = New SqlClient.SqlCommand("MDAd dClaimServ ice", myConnection)
myCommand.CommandType = CommandType.StoredProcedur e
With myCommand
.Parameters.Add("@DenialID ", SqlDbType.Int)
.Parameters.Add("@SrvcDate ID", SqlDbType.Int)
.Parameters.Add("@CptRevCd ", SqlDbType.NVarChar)
.Parameters("@DenialID").V alue = DenialID
.Parameters("@SrvcDateID") .Value = ServiceID
.Parameters("@CptRevCd").V alue = Me.Controls.Item(col.Item( "txtCptRev " & i)).Text
.ExecuteNonQuery()
End With
Next
Dim i as Integer
Dim strCPT as String
For i=1 To 6
myCommand = New SqlClient.SqlCommand("MDAd
myCommand.CommandType = CommandType.StoredProcedur
With myCommand
.Parameters.Add("@DenialID
.Parameters.Add("@SrvcStar
.Parameters.Add("@SrvcEndD
.Parameters.Add("@SrvcDate
.Parameters("@DenialID").V
.Parameters("@SrvcStartDt"
.Parameters("@SrvcEndDt").
.Parameters("@SrvcDateID")
.ExecuteNonQuery()
ServiceID = (.Parameters("@SrvcDateID"
strCPT=Me.Controls.Item(co
If strCPT<> "" Then
myCommand = New SqlClient.SqlCommand("MDAd
myCommand.CommandType = CommandType.StoredProcedur
With myCommand
.Parameters.Add("@DenialID
.Parameters.Add("@SrvcDate
.Parameters.Add("@CptRevCd
.Parameters("@DenialID").V
.Parameters("@SrvcDateID")
.Parameters("@CptRevCd").V
.ExecuteNonQuery()
End With
Next
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
it gives a lot of errors
what errors?
ASKER
all were related to the controls
Private Sub RoutineName(ByVal txtService1 as textbox)
myCommand = New SqlClient.SqlCommand("MDAd
myCommand.CommandType = CommandType.StoredProcedur
With myCommand
.Parameters.Add("@DenialID
.Parameters.Add("@SrvcStar
.Parameters.Add("@SrvcEndD
.Parameters.Add("@SrvcDate
.Parameters("@DenialID").V
.Parameters("@SrvcStartDt"
.Parameters("@SrvcEndDt").
.Parameters("@SrvcDateID")
.ExecuteNonQuery()
ServiceID = (.Parameters("@SrvcDateID"
If txtCPT1.Text <> "" Then
myCommand = New SqlClient.SqlCommand("MDAd
myCommand.CommandType = CommandType.StoredProcedur
With myCommand
.Parameters.Add("@DenialID
.Parameters.Add("@SrvcDate
.Parameters.Add("@CptRevCd
.Parameters("@DenialID").V
.Parameters("@SrvcDateID")
.Parameters("@CptRevCd").V
.ExecuteNonQuery()
End With
End Sub
And call the routine in the loop.