Logo 
Search:

Asp.net Forum

Ask Question   UnAnswered
Home » Forum » Asp.net       RSS Feeds

Type conversion error

  Asked By: Dukker    Date: Jan 04    Category: Asp.net    Views: 5512
  

I'm having big problems with trying to update a record in a table based on a guid that I have in a hidden text field on my page. I keep getting a type conversion error, "Can Convert from string to uniqueidentifier. this is what my code looks like:


Sub UpdatePatient()
Dim BillingQDS As DataSet = New DataSet
Dim BillingQCB As SqlCommandBuilder
Dim ConnectString1 As String
Dim Connect1 As SqlConnection = New SqlConnection
Dim Adapter1 As SqlDataAdapter = New SqlDataAdapter
Dim Row1 as DataRow
ConnectString1 = ConfigurationSettings.AppSettings("ConnectStr")
Connect1.ConnectionString = ConnectString1
'Adapter1.SelectCommand = New SqlCommand("Select * from tBillingQ where BillingQID = '" & Lbl_BillingQID.text &"'" , Connect1)
Adapter1.Fill(BillingQDS,"BillingQ")
Row1 = BillingQDS.Tables("BillingQ").Rows(0)
Row1.Item("Status") = 1
Adapter1.Update(BillingQDS,"BillingQ")
End Sub

This is inside my form

<asp:label ID="Lbl_BillingQID" Visible="True" runat="server"/>

Share: 

 

1 Answer Found

 
Answer #1    Answered By: Heidi Larson     Answered On: Jan 04

On which line does the error  occur??????????????

 
Didn't find what you were looking for? Find more on Type conversion error Or get search suggestion and latest updates.




Tagged: