what is wrong in this statement i want the time to show after e selected time
i want the time to be shown after 22:00
for each r as datarow in mydataset.tables("Bookingen").rows
if r.item("td") >="22:00" then
messagebox.show(r.item("td"))
I have a DataGridView bound to a DataSet. I only want a selection of columns displayed on the DataGridView rather than all. I then have a text box which I want to display a value (Version_no column) from the column not showing in the DataGridView. Is this possible?
Would it be better to have a hidden column on the DataGridView and use this value for the text box?
Dim UpdateThreadStart As New ThreadStart(AddressOf QueryDataBase)
Dim CallDataBindToDataGrid As New MethodInvoker(AddressOf Me.DataBindToDataGrid)
Dim MyDataSet As New DataSet
[Code].....
I created a new query in the dataset designer. There are now 2 queries there. The original one and the new one.I also added named parameters in the Where clause of the 2nd query.This is the query in the new one:
SELECT ID, FatherName, MotherName, EmergencyContactName,
EmergencyContactRelationship, Address1, Address2, City, State, Zip,
PrimaryPhone, SecondaryPhone, Emaile.
[code].....
I am using a Strongly Typed Dataset as DAL. I want to return a single column from my table for that i wrote the code as
SELECT DISTINCT Floor
FROM Room
WHERE (Building = @Building)
But when i previewed the data, it shows me all the columns of the table with Null Value and the column with primary key has -1 value. This condition raise an Exception when i link this query to a ComboBox ..
cmbFloor.DataSource = da.GetFloorByBuilding(cmbBuilding.Text)
cmbFloor.DisplayMember = "Floor"
Error: Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.
When the user clicks an "Edit" button on my form, I want a box to come up which allows the user to edit a DataTable in a strongly-typed DataSet. What's the best way to do this?
View 2 RepliesI have code running in the Datatable.ColumnChanging event in my dataset. This dataset underlies a form and conventional drag/drop controls are in place for data entry.when the event triggers and runs, I am running code in the form that checks the dataset.HasChanges property. It is showing False. But this is immediately after the ColumnChanging event has been triggered.Okay, I see by others posts and MSDN that .HasChanges will only be true after moving off the row with the changed column. I have also noted lots of discussion about the advanced binding property of DataSourceUpdate Mode, but that does not address this issue.I guess I can do this by checking the state of the row for the binding source. Just seems odd that the event behind the dataset can be triggered and that does not change the dataset.HasChanges property.
View 3 RepliesI have tried everything I can to get beyond this error which shows below as <<<<< error here. It is trying to fill a dataset from a data adapter. If I change the SELECT statement to just SELECT * FROM xTable I get the correct number of records in each table. But anytime I try with a more complex statement I get the error message shown below which indicates System.Data.Common.DbDataAdapter.Fill(DataSet dataSet. I've completely erased all data and entered a new set of test data so I know there is no problem with relationships. Each table has primary key which is foreign key in other table. IS there something wrong with the Imports section: Imports System
[Code]...
i am trying to copy data from a standard Dataset to a Type Dataset (XSD) of same table structure. i want to use Automapper to do that one. So how can i do that using automapper?
View 1 RepliesI need to pick all data in my application from my database and use it in my form
my question : how to pick all data in my application then i use it
I have two Datagrids, One grid has all the customers garments on it with style number and contact length. The other grid has the users who have garment issued to them. the style number is in both grids. I need to loop through the users grid and say if the contract number is 1 from the first grid then the contract date on the second grid will be todays date + 365 days (year contract) I have looked at using a stored procedure and also a for each command but I am just getting stuck with it all. [Code]
View 1 RepliesI have a problem saving a dataset which contains rows that i have imported from another dataset. i can successfully view the imported rows in a gridview but i cannot commit the rows back to the database.
View 2 RepliesI have multiple datasets that I would like to combine into one. There is a common ID field that can be associated to each row. Calling Merge on the dataset will add additional rows to the dataset, but I would like to combine the additional columns. There are too many fields to do this in one query and therefore would make it unmanageable. Each individual query would be able to handle ordering to ensure the data is placed in the correct row.
For Example lets say I have two queries resulting in two datasets:
SELECT ID, colA, colB
SELECT colC, colD
The resulting dataset would look like
ID colA colB colC colD
1 a b c d
2 e f g h
ok, I've finally got my test database issues sorted out, however now I need to actually modify my existing report to add the two new fields from my test database. I have made a copy of the report so that I am not modifying the original. I have deleted the two old fields and now want to add my two new fields in there. In the Field explorer window, I see an object called "dataset1" and when I expand it, it is using a view that includes fields from the table that I added my two new fields to.
The problem I see here is that I have gone in and modified the view to include these two new fields in my test database - but again, they are not showing up as selectable fields here. I am just assuming that "dataset1" is somehow pointing to the live database again and that I need to change the datasource location.In my solution explorer, I see an object called "dataset1.xsd" but the properties of that do not tell me much about where it is actually pointing to...
[Code]...
I want to access data using both the datasets.
Private Sub Button3_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button3.Click
Try
[Code]....
In my code i have dataset name ds and table named Info1,when i write ds after that how tablename is coming,its not possible? How to do that ?
i am looking to map a dataset of addresses on a map. basically, i want the users to type a street name in my town and be able to see the houses that have signed up already on that street. so a pinpoint should show up on the houses that came up on the dataset.
[Code]...
I have some concern about designing Datasets. I was told that it would be good to have a dataset for each table for maintenance purpose. Because frequent change in database tables is expected, having one dataset including every tables would be pain to make the corresponding change in the application.
Q. is it good approach to have a dataset for each table ( I would end up having 30~40 datasets for each db table using Stored procedure) ?
I have a separate project for commonly used datasets. each project include "dataset project" as a reference, and use it by including needed dataset into Forms, classes, etc.
Q. Does this approach makes the whole system to be slower? If I have a set of datasets as a separate project, it would be beneficial, since It will be easier to make a change (I only need to make modification in one place)
it returns date, and value by date.
for ex:
01.01.2009 454
02.01.2009 785
[code].....
I am having difficulties with Filling a dataset. It seems to be automatically assigning a datatype to the column based off of the first field of data it finds in that column. The column sometimes contains an integer, but it may also contain letters and numbers. If the first field is an integer, it says the fields in the column that contain a letter are DBNull. I'd like for the entire dataset to be formatted as a string/text type since I do not know what the values will be that I'm importing 100% of the time. How do I tell the dataset to expect a certain datatype for all columns and rows i'm going to import?
View 19 RepliesWhat is the impact of creating variables using:
Dim ds as New DataSet
ds = GetActualData()
where GetActualData() also creates a New DataSet and returns it? Does the original empty DataSet that was 'New'ed just get left in the Heap?
What if this kind of code was in many places? Would that affect the ASP.NET process and cause it to recycle sooner?
I have a datagrid which is already bound to a dataset, I need to get this dataset,make changes on some data, then rebind the datagrid with the modified dataset.
here's my code
[Code]...
I have a form that has 1 text box and has 2 queries that locate the data. One is by customer ID and the other is by customer last name. They both work but when the code works and the user enters a customer ID and the query locates it then enters a customer last name it also locates it. If the user enters the same customer id again the query seems to fail. This is why I'm sure I need to add some kind of code to reset the Dataset.
Here's the code in the load sub procedure:
EditBoxSearch.Focus()
' Start out clean.
[code].....
I have a dataset (WW1Dataset) with one data table(WW1).(database used in an access database) I'm trying to filter the dataset e.g a user wants to filter by a chosen surname (SurnameTextBox.text) so the datset is filtered to display only those records wherethe surname column in the dataset matches SurnameTextBox.text.
View 1 RepliesI created a SQL database using the migration tool.I am converting my access forms to VB.net (VS2008).I am wondering if I create a single dataset in studio to the database or do I create a dataset for each form (query)? I am trying to determine what the best solution is. Many of my forms have drop downs that are populated using queries from tables.
View 3 RepliesI use a dbDataAdapter to populate a DataTable from an unlinked oracle database.I have a dbDataAdapter that I want to insert rows into an SQL Server table using SQLCommandBuilder.I have been trying all day to update the DataTable that references the SQL Server table with the data from the Oracle DataTable so that I can insert the rows.
View 2 RepliesI am trying to get back a single from from a EF database model using the below line of code..
Dim _classRoom As classrm = db.classrms.Select(Function(b) b.Course_ID = _CurrCourse.course_ref)
Where classrm is the name of the entity and db is declared as a new entity. What I am trying to do is select a row from the entity based on matching Course_ID which in this model is a string. So that I can later use the variable _classRoom to get other items out of the same row.. However I am getting the following error:
Unable to cast object of type 'System.Data.Objects.ObjectQuery`1[System.Boolean]' to type 'Trial_Online.classrm'.
I have to preform similar tasks with several different Entities but if I get pointed in the right direction I can manage from there...
Using a checkboxlist not a simple checkbox I need to select 1 checkbox otherwise display a error message in an label once I submit the form. My checkboxlist does generate correctly now I just need to validate it
'check checkboxlist
For Each ckbox In checkBoxCropsFertilzed.Items
If ckbox.Selected > 1 Then
lblErrorMessage.Text = "too many selected"
End If
Next
I have the following document[code]...
Now, how can I get the ID of the Div, by selecting text in his Field?
For example, if the user selects the text "Div1 - Text" (or part of him), the result should be "ID1".
if the user selects the text "Div2 - Text" (or part of him), the result should be "ID2", and so on.
ive got several combo boxs on a search form and its all working great if you select the items from the list, but have a problem if you type the value, the selectedvalue isnt being returned what do i need to do, this is what im using to get the value when selecting via clicking
Private Sub BTYPE_ComboBox_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles BTYPE_ComboBox.SelectedIndexChanged
If Len(Trim(BTYPE_ComboBox.Text)) > 0 Then BTYPE_FILTER.Text = BTYPE_ComboBox.SelectedValue.ToString Else BTYPE_FILTER.Text = 0
End Sub
Can anyone reccommend a good database that I can use on a local machine to storenames/addresses etc. and that integrates easily into .Net 2.0.I have used MySQL a fair bit, so something along that route would be great but without the need to install additional software on the computer or connect externally to a server
View 1 RepliesI wrote some software that use the AVICAP32.dll to do a spot of video capture.All was going well till they went and bought a laptop with a built in webcam.Now my software picks one a random and uses that for the video (somewhat annoying to say the least) Can anyone tell me how to pick a camera to use,I suspect it is related to DVM_DIALOG but my experiments have not been too successful.
View 1 Replies