i have publish data on data grid(in vb express 2010) and want to check for the data in each an every row. there are few columns and i want to check the string "OK" under "Status" column. if there is any "Not ok" found then need to prompt a message describing the details of whole row under.
View 4 Replies<asp:GridView ID="Gridview1" runat="server" />
<Columns>
<asp:BoundField DataField="Years" HeaderText="Year" />
[code]....
I have above Gridview in my aspx page. but I need to format my Hours column from hour to (Day, hour) format for e.g. for 72 hours it should display as 9 d 0 hr.For that I have one function in my .vb page as follow,
Public Function ConvertHoursToDays(ByVal totalHours As Integer) As Object
Dim num As Integer = CInt(Math.Round(Conversion.Int(CDbl((CDbl(totalHours) / 8)))))
If (num < 0) Then
[code]....
Can I use the function to display gird data in (0 d 0 hr) format?
I have a program for school project that has input fields for Name, Address, City, State and Zip. I need to error check so that the fields are not empty.I have used If statements that check to see if the fields are empty and shows a message box if they are but if I leave the whole form empty and click the button that activates it, all the if statements go- one by one instead of pausing for the user to input the required data.How do I check for data and make the program stay there until the data is input? I have tried TRY/CATCH but it won't catch this type of error.
this is the
'This program computes customer's bills at the pizza shop for all combinations of
'crusts, toppings, sizes and discounts
Option Strict On
Public Class PizzaForm
[code].....
I tried this code to check if the data in textbox1 not equal to any data in column name, so insert the data that in the textboxes to the table1. Esle.. do another thing. But it didn't success with me.
Code:
Dim conn As New OleDbConnection()
conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" _
& "Data Source =" & Application.StartupPath & "DataBaseName.mdb "
[Code].....
i have a string (the letters will never be in the same order):
TFTADFDAAFDADADDAFFDTFFTDFTFTDTTAFDAFADTAAATFDTADAFFTFTDDFDAFFTAT
1) i know it is always going to 65 characters (no numbers)
2) it will only have the letters ADFT
i want to loop through each row of data and check if the data contains this.
System.Text.RegularExpressions.Regex.IsMatch()
My application is like this : i have to search my data from database with some check box and text box when user select check box specific function go on and then when user enters some range of value in textbox then the result will shown in data grid view after that i can print it by selecting data
my vb.net code is as follow:
Imports System.Data
Imports System.Data.SqlClient
Public Class XtraForm1
[CODE]............
I m also pasting the demo picture.
I have a problem reading data from an RFID-reader. I connect to the reader by tcp and wait for DataAvailable to be true, then reading the data until I got a end of data character. Then I just go back and waiting for a new DataAvailable. This is done in a own thread for the function.
There seems to be some kind of timeout, If I don't got any data in a couple of minutes, then it just sits there in the do/loop waiting for DataAvailable. I hold the card to the RFID reader, it beeps, but there is no data available. I don't get any exeptions, and the information says that the clientsocket is still connected. Are there anything more I can check?
If I put the card to the reader in a minute-interval it seems as this will never occur. So 2-3 minutes idle:ing seems to do this.
Here are my code to read data from the socket, I have taken away some irrelevant code:
Sub test(ByVal ip As String, ByVal port As Integer)
' this sub is meant to run forever
[CODE]......................
how to check data if it is already in the database?
View 8 RepliesOn my form with my detailed layout of my database in textboxes i can change my data or add new record.
how can i verify if there was any changes to a record when the form is being closed or when my cancel button is pressed.
i want to create a message box that warns tha there hav been changes made should it be saved yes or no
i want to check the first record in the database and do updation. similarly i would like to check all the records one by one and do updation. iam using the sql database. In my vb.net applcn i have two tables "FATRAN " and "GLDetails".
[Code]...
Again I have problem with checking whether DataReader object has data or not?
Dim cmd as SqlCommand
Dim drd as SqlDataReader
cmd = New SqlCommand ("SELECT * FROM Stock", conx)
drd = cmd.ExecuteReader()
[Code]...
This code works. i insert 3 string and then check if the database already save this code.if the first string does not exist it works well.but when 1 string "already exist" or found in the DB, all of the next string say its already in db even though it haven't. what should i do?
For count = 0 To strArr.Length - 1
If strArr(count).Contains("=") Then
str1 = strArr(count)
coun = str1.IndexOf("=")
str1 = str1.Substring(0, coun)
[Code]...
I have 2 checl boxes bol1 and bol2 and i stored a record after ticking one of them and now i want to make a function to retrive what i stored in the access data base in check boxs as well according to the ID. the table name is check_table and the columns names are "bol1 , bol2" the type is (yes,no).
View 3 RepliesIm working on a HSD 32 bit data bus to serial converter via a microcontroller. Now first I want to make a sort of data sniffer to read the data bus (32Bit) .All on the controller side is working and the stream of bytes are coming in via RS232 as 4 bytes in HEX like FD,A5,45,8B . I already converted the bytes in Dec and ASCII to determine what is passed true the bus and how fast and stuff.. Now that is all correct and working very well if the LSB (least significant bit) of the 32 data bus is Data line 0 and the MSB (most significant bit) is Data line 31 but if that is not the case I need to invert the 32Bits (like as I would invert the connector on the bus) . How do I best do this using the 4 bytes I send from the micro controller.
Example:
(MSB) 01001000 01100101 01101100 01110000 (LSB)
HEX= 48 65 6C 70
DEC= 72,101,108,112
ASCII= H E L P
I need to invert it with a button to:
(MSB) 00001110 00110110 10100110 00010010 (LSB)
HEX= 0E 36 A6 12
DEC= 14,54,166,18
ASCII= (SO) 6 : (DC2)
I have an array of boolean data that I'm trying to display on the screen using 144 check boxes. Is there an easy way of updating all 144 check boxes with the data from an array and an easy way to update the array when changes are made to the check boxes?
View 3 RepliesHere is another problem i have a check box in datagrid i am using this check box to update user status i.e is he disable or enabled my problem is this
1. When i check the check box is saves True value in User_st column where as i want when i check the check box it should save False in user_st column.
2. When the datagrid form loads it fetches the records from my users table here i can enable or disable users but thoses users who are already disalbed, for then the checkbox should be chedked and for enabled users checkbox should be unchked how to achieve this????
Here is the code i am using om my update button
[Code]...
How to check the data inside this value anyone ?
View 10 Replies<VB.NET 2005+SQL server 2005>
Error has to be raised for input text by user. User will input data on datagridview. Below are examples of use input.
1. "2009/01/23 08:00:10" --> How do I know that right datatime format or not
2. "2009/15/23 08:00:10" --> How do I check the month is wrong
I created a form with a checkbox and my purpose is if data have already existed, the checkbox will show a check when it launch however i am very new to VB( First time actualy). i google to find the answer but the best solution just tell me to use RegQueryValueEx, unfortunately,i don't know axactly how.
View 12 RepliesHow can i check if some value exists in the data reader
View 7 RepliesI have a asp.net page that has several SqlDataSources defined that feed data into some graphs. The problem is that the graph product does not handle "no data" very well, and throws an error. I'd like this to handle the situation more gracefully-- so I need to check whether the SqlDataSource returned data or now before rendering the graph (and if not, just post a message saying "No Data" or something).
Is there an easy way to check if the data source returned data, and do this if/then without a bunch of code behind?
how to check the data is already exist in database using vb 6.0Naren
View 1 RepliesI need to control a device with a GPIB port. I have the commands that I need to use to do this; but I don't know which is the sintaxis in Visual Basic.
For example if I need to send a instruction like "START:0.01" to the external device which are the libraries that I have to include?, how should I write the programming line to do this?
The main tasks that I need to program are sending data, receiving data, and saving data
I have looked through the entire internet (well that's what it feels like) to find this out.Tables - Authors and Titles add new title must be linked to an author, so I need to check that the author exists, if so, update the titles table with the user data from the textboxes. If the author does not exist, I need to insert the author first & last name into the author table, then the title info into the title table.this is in VB, using ASP.NET, and my database is a file, I'm not using SQL server, just Visual Studio 2008.
Dim insertParameters As New ListDictionary()
insertParameters.Add("ISBN", ISBNTextBox.Text)
insertParameters.Add("Title", titleTextBox.Text)
[code].....
I'm using VS2010 and SQLServer 2008. I'm trying to test for DBNull in datafields, but every formulation of a test I have imagined (or found) throws an error. Specifically,"The value for column 'ColumnName' in table 'TableName' is DBNull." (system.data.strongTypingException).Well, not too helpful. I know it's DBNull, and I want VB to recognize this.Here is what I've tried so far (all with the same result).
[code]...
How to deal with a "date bug" that I have encountered in my program. Here is a scenario.
1. My system has a locale of en_US and therefore displays the date as MM/DD/YYYY
2. My program tries to import from a csv file in which it carries out tests on a field to check for a valid date before loading the rest of the data.
3. If the date in the file is in the format DD/MM/YYYY the test fails and therefore the data is not loaded. This is the bug.
I would like code to test for the date string in the csv file that will recognize any date format (locale).
check if the entered data is in the same row inside the table using .net?
View 1 RepliesI usually have a check to see if a certain database column is DBNull and if it is convert it. Current with a datatype of money in SQL 2008 with the row column containing
Null, i declare the equivalent value as Decimal (in .Net) then get the error "'DBNull' to type 'Decimal' is not valid".... How could i check this column for null and convert it?
Im using VB.NET 2008
I know I can exit a program by using the End statement.
But i was wanting to know how to check to see if the data has been changed since it was loaded and bring up a diaglog box up saying the data has been changed or not saved, would you like to save the data before exiting?
I will have a form that will have a yes, no, and cancel buttons.
Im using VB.NET 2008 I know I can exit a program by using the End statement.But i was wanting to know how to check to see if the data has been changed since it was loaded and bring up a diaglog box up saying the data has been changed or not saved, would you like to save the data before exiting?
I will have a form that will have a yes, no, and cancel buttons.