Search:
Type: Posts; User: dr225
Search:
Search took 0.06 seconds.
-
dday9 - thanks for the simple and straightforward answer. Grateful! Stay blessed...
-
Thank you all - Much obliged
-
:)...
the form looks neat, do you have any other ideas?
-
Sorry for the confusion. It is a combo box with a dropdownlist, not a textbox.
Thanks
-
Hi,
I have the following code that pulls the data from the table, however, I want the first record to be set as --Select-- by default...
Any help please...
Try
Using con As...
-
Highlighted in RED - I want instead to add to the database a NULL value...
Thanks dday9
-
If (Me.DgUnitsUp.Rows(i).Cells(8).Value IsNot Nothing AndAlso Not DBNull.Value.Equals(Me.DgUnitsUp.Rows(i).Cells(8).Value) AndAlso Integer.TryParse(Me.DgUnitsUp.Rows(i).Cells(8).Value.ToString(),...
-
I have tried changing to this:
If (Not Nothing.Value.Equals(Me.DgUnitsUp.Rows(i).Cells(8).Value) AndAlso Integer.TryParse(Me.DgUnitsUp.Rows(i).Cells(8).Value.ToString(), tenantregID)) Then
...
-
Thanks dday9...
When I select NULL and click update the following line executes an error at run time
If (Not DBNull.Value.Equals(Me.DgUnitsUp.Rows(i).Cells(8).Value) AndAlso...
-
Thanks si_the_geek..
As a follow up:
I have this code which works fine but when the selected value is NULL then I receive the error message:
System.NullReferenceException: 'Object...
-
Thanks dday9
If Me.DgUnitsUp.Rows(i).Cells(8).Value.ToString() = DBNull.Value.Equals(value) Then
Me.DgUnitsUp.Rows(i).Cells(3).Value = True
...
-
Thanks dday9..
So I changed and called the UNION in the SQL - it brings the results as required. Now when I select an empty cell and click update I get an error stating
...
-
Hi,
I have the following code below that pulls the list of 'tenantfullname' from the table to the datagridview. However, I would like the top value on the dropdownlist to be empty. Because there...
-
That is all garbage. Be Kind my friend...
-
I do know where the problem resides, but don't know how to solve it:
For i As Integer = 0 To DgUnitsUp.Rows.Count - 1
DgUnitsUp.Rows(i).Cells(8).Value =...
-
query = "UPDATE dbo.tblunits SET flattype=@flattype, units=@units, rentamt=@rentamt, vacant=@vacant, tenantregID=@tenantregID WHERE propertyID=@propertyID and unitID=@unitID"
cmd =...
-
cmd.Parameters.AddWithValue("@vacant", DgUnitsUp.Rows(i).Cells(3).Value.ToString())
cmd.Parameters.AddWithValue("@tenantregID", TenantName.SelectedValue)
...
-
Hi,
I have the follow code that works fine.. It pulls all the registered tenants from the tbltenants to the tenantname column - combobox dropdownlist to select from.
Try
Using...
-
-
Hi,
In the Update Statement code - I receive the error message:
Incorrect Syntax near 'flattype'
For i As Integer = 0 To DgUnitsUp.Rows.Count - 1 Step +1
-
-
Sorted---
"Select tenantfullname AS TenantName from tbltenants order by firstname", con
My missing...
-
Hi,
I receive the error message in the below code:
System.IndexOutOfRangeException: TenantName
vb:line 709
Try
-
Thanks dday5, perfect!
Using con As New SqlConnection("Data Source=DESKTOP-O6TSDMJ;Initial Catalog=RCMS;Integrated Security=True")
DsUnitdetails.EnforceConstraints = False
...
-
Thanks jmcilhinney - Always very helpful and to the point! :)
-
Hi,
I receive the following error message at run time:
There is already an open DataReader associated with this Command which must be closed first.
Dim con As New...
-
-
Tried
Dim cmd As New SqlCommand("Select flattype from vwunitdetails where propertyid = '" & DgUnitsUp.Rows(i).Cells(0).Value & "' And Units '" = DgUnitsUp.Rows(i).Cells(1).Value & "'", con)...
-
Hi,
I have an issue at run time:
Error message:
'Units' is not declared. It may be inaccessible due to its protection level. RCMS
'Units' is a header on the datagridview (DsUnitsUp),...
-
Hi,
I have the error:
Must declare the scalar variable "@propertyID".
Please help!
Private Sub UpdatedPropertyDetails()
-
Thanks - jmcilhinney. Always very helpful indeed! Much appreciated...
-
Hi,
I have the following Save function, that works but the logic is not correct:
Private Sub Save()
Dim conn As SqlConnection = GetDbConnection()
Dim query As String
-
Hi,
I have a datagridview and trying to save all the records from the datagridview to a SQL table on 'Save'.
However, it doesn't work please could you check for me what is wrong...
Data is...
-
Hi,
I have the following code which works fine. I call the SUB when the update button is clicked.
Now, even if no changes has been done it still updates the record and creates a record in the...
-
-
I am so sorry - jmcilhinney & thanks for always helping...
I have rectified the issue and sorted the code:
If selectedRow.Cells(9).Value IsNot DBNull.Value Then
Dim img As...
-
Sorry guys!
Tried this:
Dim img As Byte()
img = DgvLandlordDetails.Item(9, e.RowIndex).Value
Dim ms As New MemoryStream(img)
TxtLandlordRegID.Text =...
-
Ok - Changed to this:
If selectedRow.Cells(9).Value IsNot DBNull.Value Then
Dim bytes = DirectCast(selectedRow.Cells(9).Value, Byte())
Dim img As Byte()
...
-
Tried this:
Dim img As Byte()
img = DgvLandlordDetails.Item(9, e.RowIndex).Value
If Not IsDBNull(img) Then
Dim ms As New MemoryStream(img)
...
-
Dim img As Byte()
img = DgvLandlordDetails.Item(9, e.RowIndex).Value
If img IsNot DBNull Then
Dim ms As New MemoryStream(img)
End If
...
|
Click Here to Expand Forum to Full Width
|