Search:

Hi,

I have changed a data type of a field (fieldsize) from int to Bigint.

Now, the problem is it generated the following error:

Microsoft VBScript runtime error '800a000d'

Type mismatch

Hi,

I want to update my statement to read 2 values from what is available -

1) user_full_name (concatenation of firstname and lastname) eg., firstname = John lastname= Smith user_full_name =...

Hi,

I have the following code;


Private Function findauthoremail(ByVal name As String) As String

Dim ConString As String =...

Hi,

Why when I click the checkbox and submit it stills submit a False value?

Thank you



Try
query = "UPDATE TblChangeControlDet SET PeerRvwApp=@PeerRvwApp WHERE...

Hi,

I am having the follwing code;



Try

Dim PeerValue As New System.Data.SqlClient.SqlCommand(("Select PeerRvw From dbo.TblChangeControlDet WHERE ChangeID=@ChangeID"), conn)...

please tell how to do it in one SQL update statement..


Many thanks

Ok Changed it to;



nextconn.Open()

Dim query As String

Dim cmdB As New System.Data.SqlClient.SqlCommand(("Select RefNo From dbo.QryRefNo WHERE ChangeRaisedDate =...

Hi,

I have the following code;


Dim query As String
Dim RefID As New System.Data.SqlClient.SqlCommand(("Select RefNo From dbo.QryRefNo WHERE ChangeRaisedDate = @ChangeRaisedDate"),...

Tried;



Protected Sub btnsubmit_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnsubmit.Click

Dim strConn As String

strConn =...

Tried that it gave same error message.

Even tried to create another string;

Dim nextconn As New SqlConnection(strConn)

Then I opened and closed same location as you did in bold.

Same...

How can you do the first one please

Hi,

I have the following code;



Protected Sub btnsubmit_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnsubmit.Click

Dim strConn As String

Hi,

I have a datagridview (DgvProductDet) it has 5 columns (data bounded)

TruckModel
ProductName
Quantity
Priceperitem
Buy Now (Button Click)

Hi,

At button click on my form I have the code;


Private Sub BtnChk_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles BtnChk.Click


...

It didnt work!!

I even tried


If CmbTruckTyp.SelectedIndex > -1 Then

It never gives any error, however, both comboxes are visible regardless of "Daf" or "MEercedes-Benz" being selected.....

Hi,

The following code gives an error - at run time

InvalidCastException was unhandled
Operator '=' is not defined for type 'DatarowView' and 'Nothing'


If Not...

Hi,

I have a button on click event I have the following code;



Private Sub BtnChk_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles BtnChk.Click

If...

Hi,

I receive the error -

Incorrect syntax
Unclosed syntax near 's'
Unclosed quotation mark after character string ".


query = "UPDATE dbo.TblPracExclude SET " & _

Hi,

I have a datagridview (DgvPracExcl), on it I have a bounded field with a design name 'Notes' and columntype: DatagridviewTextBoxColumn.

At runtime a user can type in text on this textbox...

Hi,

I have a datagridview (DgvPracExcl) which at runtime allows a user to update the records to a table in the database.

Now, I want to save a history prior to the update. Therefore, create a...

Hi,

I have a form with a datagridview - on form load I have;


Dim irown As Integer
For irown = 0 To DgvPracExcl.Rows.Count - 1
DgvPracExcl.Rows(irown).Cells(0).ReadOnly...

any advice?

Ok - Changed it to


Dim conn As SqlConnection = GetDbConnection()

Dim sql As String = "INSERT INTO dbo.TblPracExclude (prac_no, Goldpracid, prac_name, prac_status, prac_enabled,...

If I exclude the '' I receive the error message - Incorrect syntax near ','.

Thanks

Hi,

I have the follwoing code;


query = "INSERT INTO dbo.TblPracExclude (prac_no, Goldpracid) VALUES (" & _
chk_prac_no & ", '" & _
...