i want to check if time's column is sorted and after that save the table, for this i use this code but it seems does not work, evry time apears this MsgBox("Error")
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim sel_er As Integer
[code]....
What i am trying to do is get the data type of the sorted column that the user selects in order to properly convert a variable. the variable will be used to locate similar values in the dataset that populates the datagrid view.
View 10 RepliesI have a DataTable in a DataGridView, one of the columns has data that I want sorted. I can click on the column header to sort it and it's fine. The problem is that I don't want that column sorted automatically when some of the data changes in it. I want it sorted only when I click on the header.
View 3 RepliesI've got a calendar app where we're loading up a DataTable from one method, then merging the results with another method - both methods return the same type of data and the same columns. One of the columns in the results is "start_time", which has a date and time. What I want to do is sort the entire, merged, DataTable by the time in the "start_time" column, disregarding the date completely. I've gotten this far, but can't see how to get it done:
Public Function GetDates(ByVal dStart As DateTime, ByVal dEnd As DateTime, ByVal nPageId As Integer) As DataTable
Dim dt As DataTable
[Code]....
I think I need to create a new column and grab the time from the start_time column and then re-sort the table
I am trying to placed several check boxes (15) in a group box or on a form. I receive the following error message in Visual Studio:
Cannot set column, "The value violates the MaxLength limit of this column".
How to check a check box based on a condition at run time?
View 3 RepliesHow can I set a Column of a Data Type (time) to start from 8:00 A.M?. Since the default data type starts from midnight.Is there a way to create a constraint to set the time to start from 8:00 AM and check whether the inserted time is 8:00 A.M or not ?
View 2 Repliesspell check class? How to use it to spell check textboxes in real time?
View 9 RepliesHow does one check to see if the system time is equal or not equal to a specific time? So, say I want to perform an action if your system time is between 6pm and 6am. Or something similar?
View 1 RepliesBut I'm having a problem with showing the right info in a gridview.
Basically I've got a maintenance tool for an application. And I want to make it multi language.
This is a check for the language:
'setting the column name where to get the text resource from
Dim comment As String = "comment"
If (licentie.getlanguage() = "NL") Then
[Code]....
So far this works. But in my template I've got the following code in the gridview:
<asp:Label ID="LabelType" runat="server" Text='<%# Bind("Comment") %>' />
How do I set the column 'comment_NL' when the language is set 'NL' in the bind?
I have simple app code:
Dim sw As New StreamWriter(FileName, False, System.Text.Encoding.GetEncoding(Encoding))
Dim adapterPositions As New MyDatabase1DataSetTableAdapters.PositionsTableAdapter
[Code]....
How I can check column is DBNull or not?
i'm working with a database application and i want to check if there is a null value in a specific column but it works only when its not null but if its null it throws an exception automatically
i tried to change the nullvalue property of this column but i'm not able it shows a message that its not a valid property
i tried to change the source code in the code editer but it changes back automatically
i am checking for if the column code is Null or not in that same i wnat to check whether the column has any of the duplicate values then i should mark as isGoodRecord = 2,
If (IsDBNull(Row.Code) Or Row.Code = String.Empty) Then
Row.IsGoodRecord = 2
ErrorDesc += "Code is blank;"
end if
I have a windows service which fetches data from various datasources and build a XML file and send it to a webservice. For example first I will get customer details from Oracle Database and build the XML file and then the SQL Server database and build the customer details XML. I am planning to use the same function below to build the customer object irrespective of what the datasource is. But dr("age") column is not available in SQLserver datbase How can I check if a column exists or not.[code]
View 3 RepliesIf sqlquery = "Select admin FROM userlist = True" Then
Form2.Show()
Else
Form1.Show()
End If
My login script works its checking if admin from userlist = true is what i can't seem to get working.
I use ADO.Net to call a stored procedure that retrieves data from our database.I put that data into a data table using this code below:' set Ready ResultIDs in databaseDim dt As New DataTabledt.Load(cmd.ExecuteReader)
View 3 Repliesi want to check the table column null or empty......in vb.net iam using ms access in backend.....
View 2 RepliesI want to insert a value from loop in datarow so before entering value in datarow, i want to check that a perticular column NAME exist in table or not...please tell me how can i check it. (vb.net preferred).
View 2 RepliesI have a datagridview that is bound to a binding source.I used the following code to add a checkbox column to the datagridview:
Imports System.Windows.Forms
...
Dim newcolumn as DataGridViewCheckBoxColumn
Datagridview1.Columns.Add(newcolumn)
The checkbox column shows up successfully, but when I try to click any of the checkboxes,nothing happens.The cell remains unchecked.It blinks, so I know that it is acknowledging the click, but the checkbox state does not change.
I have a DataGridViewCheckBoxColumn and I am trying not to allow more than one checked boxes in the column. So after one is checked, when user tries to check another one, i want to prevent that and not have more than one checked box in entire column. I used whole bunch of events but nothing is helping me... Some time it seems working but if i double click the checkbox, it puts the checkbox... sometime it puts the check mark on my third click (not on first, not on second but on third...) What i want is only one checked box and if use tries to click another one don't let it happen.
View 5 RepliesI have this issue right now. I have a listview with checkbox. Now what I want to achieve is get all the id (hidden column) of all check items and pass it to arraylist so that I can pass it to SQL like this:
dim intProductID as new arraylist
For i = 0 To lv_list_products.Items.Count - 1
If lv_list_products.Items(i).Checked = True Then
[Code].....
"DELETE * from t_products WHERE f_product_id in(" & intProductID & ")" The reason I do this is to have only one time open of database connection, One of the member suggested it is not good to open and close database specially if it is within the loop. One more issue is the command within the array I need to separate all id with commas so I will not have error on SQL.
What is the best datagridview event to use these codes I want to check column 0 is empty or has some value
If e.ColumnIndex = 0 Then
If DataGridView1.CurrentCell.Value = "" Then
MsgBox("Empty Value")
[code]....
Hi, Is there any way to check which row of the value(any of the Column) is empty and get the row number??
View 4 RepliesFor each loop through a DataSet, I need to store the values of 2 columns (we'll call them ColumnA and ColumnB) so that I can use them to search the same DataSet again later.The DataSet stores the results of a search and places the value of ColumnA into a ListBox as a new item.When the user clicks on this ListBox item, the application will loop through the DataSet again using the value of ColumnA and the value of ColumnB as criteria to identify the correct row in the DataSet to return.This would be a lot simpler if the value for ColumnA was unique every time, but a value will inevitably be repeated on occasion. That's where ColumnB comes in. This column's value is likely to be unique 90% of the time, and, given the nature of the information in the DataSet, if either column duplicates, the other won't.So I've thought of adding the values for ColumnA and ColumnB into a 2 dimensional dynamic array, but I'm doing something wrong apparently.[code]
View 3 RepliesI am writing a backup process.
Step1: User selects 3 times (Tuesday 1am,3am,10am or Everyday 1am,3am,10am)
Step 2: The application should check the time settings and start the backup process automatically.
Is it possible to start the backup process if the application is not running?
How do i check for time difference for eg: i have code like this
If GetServerDateTime() < Format(Now, "MM/dd/yyyy hh:mm:ss tt") Then
msgbox ("Invalid datetime")
endif
i want to make it like if the time difference is within 2 min from the current time.... the application still can allowed to next form. Is there a specific code to do this....just to check the minute difference
What I want to do is whenever I want to add subjects to my listview it will check first if either the schedule is conflict or not. i have a starting time end time, and days but i dont know whats the proper condition to use in order to check if its conflict or not. anyone can help me on this matter this ive been struggling about this for several days.[code]
View 3 RepliesI implmented a function to check time range in vb.net. But it is giving me wrong output. My starttime is everyday at 11.00 Pm and end Time is 5.00 AM. My function if i pass 1.10 AM does not return me true output as this falls under that time range.
Private Function CheckTimeRange() As Boolean
Dim retValue As Boolean = True
Try
[Code]....
I am developing an application whereyby I want to run a check at 5pm each day. It will check if the next day is the due start of a project and if so send a notification email to the assigned developer, does anyone know the easiest way of doing this.
View 8 RepliesVS 2010 Check For Time And Day?
View 3 Replies