I have the following code that checks if the value in a cell contains a nummeric value.
Private Sub dgvOrderRegel_CellValidating(ByVal sender As Object, ByVal e As System.Windows.Forms.DataGridViewCellValidatingEventArgs) Handles dgvOrderRegel.CellValidating
Select Case e.ColumnIndex
Case 4 'Aantal
If Not IsNumeric(e.FormattedValue) Then
[Code]...
I am getting product id value some times null and empty from databasehere how i check if valule null and empty
productid = IIf(IsDBNull(TempDT.Rows(0).Item("productid")) =
True,
"", TempDT.Rows(0).Item("productid"))
[code].....
The code below works fine as long as there are values within an XML node (For example the <CPU>Intel</CPU> node below) but it throws an Exception error when the node value is blank/null whatever as in the example node <Monitor> </Monitor>.t's ok if the node value is blank, I just want to check for it and not throw an exception error.This question uses the following XML snippet below: Note: The tag <Monitor></Monitor> has no value in it.
<PCSettings>
<SystemSettings>
<CPU>Intel</CPU>
[code].....
I have some application settings that I want to put some error checking in and the below code does not work.
If My.Settings.SmtpServer = ("") Then
MsgBox("SMTP cannot be blank!", vbExclamation, "SMTP App")
End If
I'm using FileHelper to generate object's property. Here is an example of one property:
<FieldOptional(), _
FieldTrim(TrimMode.Both)> _
<FieldNullValue(GetType(String), " ")> _
Public StoreNo As String
As you can see the StoreNo will either have a value or " ", one of the business policy is to check if the StoreNo is empty or nothing if the object's StoreNo is empty or null then the record will not create.
I though about creating an HasValue Function in the class to check the StoreNo and other properties in the object but I feel like it is a hack.
Public Function HasValue() As Boolean
Dim _HasValue As Boolean = True
If StringHelper.IsNullOrBlank(Me.StoreNo) Then
[Code]....
I don't think this approach is an ideal solution. what if the StoreNo is remove or change to something else. What's the best approach to check object's property?
I want to display a message if the value of cell of my datagridview is Null.
View 1 RepliesWhat im trying to do is check a row for null values in my datagridview before saving the data back to my access database, in particular the first columns cell of the new row being added. This is the code I have so far'
Private Sub LatheprogramsBindingNavigatorSaveItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles LatheprogramsBindingNavigatorSaveItem.Click
Dim test As String = Me.LatheprogramsDataGridView.Columns(1).ToString()
[code]....
[Code]....
IF cursor leaves column 0 and row 0 then it displays msgbox but I want to check where column 0 and row 0 has value or empty In case of empty cell it must display msg as
msgbox("this is empty cell")
How to apply for loop on grid view and to check the empty cell value then show a message...
Dim cnt As New DataSet1.LibraryDataTable
For i As Integer = 0 To cnt.Rows.Count - 1
For j As Integer = 0 To 5
If GridView1.Rows(i).Cells(j).Text = Nothing Then
GoTo e
ElseIf GridView1.Rows(i).Cells(j).ID Then
GoTo a
End If
Next
Next
e:
lblmsg.Text = "he is not return a book"
a:
lblmsg.Text = "he is return all book"
The problem is that if you never enter anything into a cell for a new row then that cell is never validated. This is a problem because I have columns that should not be null. I am doing the check in the row level validation and storing the information about which cells are empty that should not be empty. The row level validation works fine and the row level validation error indicator goes on,(red exclamation mark at the beginning of the row) but I also need a visual indicator on the individual cells that are in error.
I am thinking that setting the HasError property for the cells that are in error should cause them to display n error style (the default red border). Is there a way to this this either from XAML (perferably) or from code?Alternatively I could cause those cells to re-validate when the row editing is finished. Does anyone know how to do this?
I have a datagrid that will be accepting data from an external measuring device via the serial port. The grid is also open to editing records as well. Part of the process of making this grid user friendly is to intercept the "enter" key and move to the next cell until there is a value in the cell. This is only for some cells, other cells can be blank. I have worked out how to intercept the "enter" key from another post on this forum. Here is the code:
[Code]...
If a column contains null dbnull value in sql server database then how can i replace it with "N/A" string when i view the database table in datagridview
View 2 RepliesI have a form with 2 datagridviews on it, each connected to to table in a database: dgv1 and dgv2.
- Dgv1 has a column called "Senders" and a column called "Recievers".
- Dgv2 has a column called "Recievers"(this is a master list of recievers) and a checkbox column in it.
Basically, when you click a checkbox in dgv2, it copies the name corresponding to it(from "Recievers"), to the "Recievers" column in dgv1.What i want to happen is, when the user selects a name from the "Senders" column in dgv1, it should automatically search the "Recievers" column (also in dgv1) for names(each name is on another line in the cell), based on the "Recievers" columnin dgv2, and if it's in the cell, it should check the checkboxs corresponding to the name in dgv2.
This must've have been asked before but I couldn't locate it. In a mixed code project (VB and C#) we were debugging some old Visual Basic code where a statement as follows could be found:
If Request.Params("xxx") <> "" Then
'do something
I considered this a bug as Request.Params could be null, in which case the statement would've become false which wasn't the idea. So I thought. I just found out, -- probably for the tenth time and I will keep forgetting -- that the following two statements are not equal, while Nothing in VB should be equal to null in C# (thought I):
if(String.Empty == null) // always false
If String.Empty = Nothing Then ' always true
Should I dismiss this as a typical Microsoft backward compatibility effort, or should I consider this a huge error in the VB.NET compiler? Does anybody know the Microsoftean opinion on this oddity?
How to check whether a column is null i use the following code but I got this error "Input string was not in a correct format."
[Code]....
i have a date control on form (vb.net) and by default its value is current date. i want to make its value to null or empty so that no date is shown and user choose from the drop down date calendar.
View 9 RepliesI am getting the attached error when any cell in a row is empty. How to avoid this error and to accept the null values?
View 4 RepliesI'm deserializing some XML from an old application into an object in my current application. The old XML often has empty elements (<SomeElement />) which are currently deserialized as empty strings (""). I agree that this is the most appropriate behaviour, but it is a minor irritant; I'd rather they were deserialized as Nothing or ideally ignored - the effect would be the same. Is there a means of ignoring these elements? Or can I have them deserialized as Nothing?
View 2 RepliesI am finding this weird issue. When I do this > activities.Where(Function(a) (Not a.IsDeleted And a.ParentId = 100) It returns an in-memory query & when I try opening it up, it throws a object not set exception. This only happens when there were no items which satisfied the condition. Shouldn't it be returning an empty set? When there are items satisfying the condition, then it returns a list & works all good.
View 1 RepliesI key-in data from textbox to datagridvie..........the date data the format datatable is:
[Code]...
I constantly find myself having to do code similar to the following.[code]Is there anyway to check for both on a single line? When i'm checking a condition for a great number of answers, I sometimes end up with conditionals 6-sets deep. If i check for null first, an error still pops up, even though VB shouldn't check since the first condition failed. i.e.[code]
View 8 RepliesHow can I change the following code to write to the database null instead of empty strings?
Public Sub SetChangeRequest(ByVal referenceLeaseID As Integer, _
ByVal referenceCustomerID As Integer, _
Optional ByVal custUnitNum As Object = Nothing, _
[CODE]...
I have a form and stored procedure that inserts the data from the form. It works fine except that if a field isn't filled in it doesn't insert a NULL into SQL it inserts "".
I've tried a few different ways but none seem to insert NULL, the one below still inserts "", can anyone point me in the right direction?
Here is the required part of the code, if you require more just let me know.
Dim rdr As SqlDataReader
Dim cmdInsert As SqlCommand = New SqlCommand()
cmdInsert.CommandText = "spPersonalDetailsInsert"
[Code].....
So if I enter nothing into address1 field it should write NULL to screen but it always writes NOT NULL. What does an empty form field equal? in classic ASP it was always "".
I have a couple of textfields in a Windows form. One of these textfields is allowed to be NULL. When I enter a value for every field, it is all inserted, no problem. When I leave the field (txtGewicht) blank, I can't seem to be able to insert NULL in Access Database.
If Double.TryParse(txtGewicht.Text, 0) Then
klant.Gewicht = Double.Parse(txtGewicht.Text)
Else
[Code]....
This is what I get:
"Cannot set column 'Gewicht' to NULL, please use DBNull instead"
So I changed 'Nothing' to DBNull.value, but it then tells me that System.DBNull cannot be converted to type Double.
I have a large one dimensional array that is called ArrayHold which is populated at runtime. I run a loop to scan through the array to find out which elements need to be removed based on a few parameters. This all works great, now I am left with two arrays. The original one and a new one which contains the locations of the elements to be removed.
Original Array: ("A")("B")("C")("D")("E")("F")("G")("H")
Second Array with index/count of elements that needs to be removed: ("0")("3")("5")("7")
End result should be preferably not in a new array but a "ReDim" of the original array:("B")("C")("E")("G")
What would be the simplest way to achieve this? I could run a loop to make all the elements that need to be removed "0" or ""? Would there be an easy way of resizing and array by dropping/removing all the white space or empty elements?
I need to sort a DataTable or DataGridView by a column that is a string value, but with null/empty values at the BOTTOM when sorting ASCENDING. The DataTable is NOT populated by a SQL statement, so no order by. If I do
[Code]...
I have a property called ReplacementTo and I set a value to it based on the selecteditem from the combobox, like this:
classEquipmentItem.ReplacementTo = cmbReplcmnt.SelectedItem.ToString
Now I can't use cmbReplcmnt.Text because what I actually need is the value of that SelectedItem
So problem is, if the user leaves the combobox as blank, it throws a null exception.I decided to use the IIf function then:classEquipmentItem.ReplacementTo = IIf(IsNothing(cmbReplcmnt.SelectedItem.ToString), classEquipmentItem.ReplacementTo = "", cmbReplcmnt.SelectedItem.ToString)
Unfortunately I still get the error I tried using a Try-Catch for it and it worked, but I don't want to rely on the Try-Catch, so I was wondering is there a another way to work this through?
I have a stored procedure (SQL Server Express) that returns a count of records:
SELECT COUNT(AdminUserID) AS CountEm
FROM Licenses
WHERE (AdminUserID = @AdminUserID);
Table "Licenses" has a field "CompanyID" which is a uniqueidentifier.
I need to add a clause to the WHERE to exclude records from the count where "CompanyID" is null/empty.
In VB code I'd do this with "If Not (TheCompanyID.Equals(Guid.Empty)) Then"
How would I do this in a stored procedure?
I need to sort a DataTable or DataGridView by a column that is a string value, but with null/empty values at the BOTTOM when sorting ASCENDING.The DataTable is NOT populated by a SQL statement, so no order by.If I doDataGridView1.Sort(New RowComparer(System.ComponentModel.ListSortDirection.Ascending))then it throws an exception, saying that the DataGridView is DataBound, which is correct, but doesn't help me, and I want to keep it databound.
View 2 RepliesI have several date fields in a datagridview, in sql these are saved as navchar fields. If the user needs to clear the date they can do so by highlighting the field and pressing the delete key. This clears the date no problem, unfortunately it sets the field to Nothing or "" (a blank). I need it to set it back to NULL for reporting purposes.
Here is the relevant part of the code:
Private Sub dgvWeldingLog_CellEndEdit(ByVal sender As Object, ByVal e As System.Windows.Forms.DataGridViewCellEventArgs) Handles dgvWeldingLog.CellEndEdit
Try
If dgvWeldingLog.Columns(e.ColumnIndex).Name = "dgvtxtDateWelded" Or _
dgvWeldingLog.Columns(e.ColumnIndex).Name = "dgvtxtFitCheck" Or _
[Code] .....
If there is an error in the data entry then the form cannot be saved. When I trap DBNull.Value is says it is equals to "Nothing" and not "NULL".