I have an IEnumerable(Of System.Data.DataRowView) and would like to set it to be the datasource of a datagridview - however when I try I get no results my IEnumerable variable in the eg below is called xIEnum
DataGridView1.DataSource = xIEnum
However when I go
DataGridView1.DataSource = xIEnum.ToList
it works.... However I want the data to automatically update when I change the underlying datasource that the IEnum is mapped to?
I have an object called Result<T> that has a constructor which accepts an argument of IEnumerable<T>. I'd like to be able to pass in a datatable if possible.
I tried datatable.AsEnumerable(), but where I bind to the data it was complaining that 'MyProperty' is not a field or property on type 'DataRow' - which makes sense since 'MyProperty' isn't a property on 'DataRow', but it was a column in my datatable.Is there a way to convert a datatable to something that I can pass into the Result object and still have it bind to, say, a gridview?
I tried using the linq Zip method on IEnumerable but it does not work for more than 2 arrays.Here is an example in Python of what I am trying to do(I got p - nested IEnumerable - and need q - another nested IEnumerable):
>>> l=['a','b','c']
>>> m=[1,2,3]
>>> n=['x','y','z'][code].......
I am stuck trying to convert code that works in C to VB. The C code is:internal IEnumerable<GraphicsBase> Selection
[Code]...
I have read the stuff about how this has to be done in VB using GetEnumerator method, but I just can't seem to get it to work.
I use vb.net and windows form and sqlserver
I added Data Source(Microsoft SQL Server (SqlClient)) to my project. and now I need to change it to ODBC Data Source .
I have been successful in using the datasource binding in VB 2008 (drag and drop from datasource to form)My question is that I have date and time fields in an access database. In the database they are fine. I have the date as a long date and the time field as medium time.When these dates are viewed in my vb form, they show as:example (for date of 5/15 and time of 9:00)
Date field: 5/15/2009 12:00:00 AM
Time field: 12/30/1899 9:00:00 AM
I tried to format these field in VB to long date and medium time but it doesn't change. Any suggestions on how to do this?
i import into a list box data from a db. when i try to save listbox it save this text
System.Data.DataRowView
instead text of single item...
how i can get the real text of each item?
I am connecting my VB application to Oracle Database. I need to configure the Data Source in the app.config.ng know which section do I define my UID, PWD and DSN and what functions do I use to read this information. Can I also write back this information through the application.
View 1 RepliesI'm learning some more VB in my spare time, and I'm making a simple customer database that uses SQLCE. I've got the datasource set up and all that, but for some reason when I hit accept on the form, nothing happens?
[Code]...
I gather MATTER NUMBER and PATENT NUMBERS in a listbox on a dialog form - that I pass to the main form after the dialog closes.I then ask for CASES on subsequent dialog forms and want to have drop downs for MATTER NUMBER and PATENT NUMBERS that "have the suggestions" of what was entered in those list boxes earlier.So - I've been using DATASOURCE for binding to datatables and thought to myself - heh - I can probably set the DATASOURCE of the DROPDOWNS - and it works!
Public AddMatterNumber As ListBox
Public AddPatentApp As ListBox
MatterNumber.DataS
[code].....
I have a vb.net project. I have used the GUI and wizard to create a DataSource pointing to a SQL Server Stored Procedure. It works great! However, a new column has been added to the stored procedure.In the GUI if I right click the data source name and refresh, nothing happens.If I right click the stored procedure name and refresh, nothing happens.If I preview data I can see the new column returned.If I choose edit with wizard there is a red exclamation point next to the name of the stored procedure and red X be each column name.
When I hover over the field name it says "Column ABC in the DataSet references a column missing from the Database".When I hover over the stored procedure it says "STORED_PROCEDURE is mapped to STORED_PROCEDURE in the DataSet. Element STORED_PROCEDURE in the DataSet contains columns that do not exist in the Database".I can't figure out how to get the new columnd in the dataset.
[code]My question is how can I remove xStopBits(0) before setting the DataSource?To get around this I currently have a check in the ComboBox1_SelectedIndexChanged event.
View 14 RepliesI am trying to link a date produced from a month calendar to a three column data source . Col 1 is date and cols 2 and 3 hold password records for use on the selected date. I am able to have the selection from the month calendar produce a result into the label text but cannot see how to relate the date in col 1 back to the label. I am beginning in this world,
View 1 Repliesi need to query the datatable & set the outcome as datagridview controls datasource
vb.net
Private Sub Txt_Search_TextChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Txt_Search.TextChanged
'routine objective:- Filter datatable & set the datagridview datasource
[code]....
During Loading a form, I bind a datasource property of the DGV to the bindingsource, and then set the fillweight property of the DGV columns. But, after form being shown, earlier set properties are being reseted to default = 100.
The procedure is like:
1. TestForm.Show()
2. TestForm_Load(...) Hnadles MyBase.Load
DGV.DataSource = bindingsource
DGV.columns(0).fillweight = 80
DGV.columns(1).fillweight = 120
3. Me.close() (Closing the form which called TestForm.Show()
And now I have visible a TestForm with well binded datasouce seeing all the columns, but their fillweith property was beeing reseted...
I made an application that was used by one person only, but now my boss told me that this application it'll be used by all company.I made the application with a dataset that have the datasource in a access database that's installed with the application. The user can add, delete and change values in the database, so i had to put the database in a sql server to everyone see the changes.There's someway to change the dataset datasource/connection string?
View 9 RepliesI have created an application which uses an sql server connection as its datasource. The problem I'm having is that the application needs to work on computer that has no network connection. How Can i change the datasource so that on runtime it can work off a machine that is not connected to a network? The datasource from the sql connection only contains one table with no data. It only needs to be updated with a target folder that can be changed to any location on any computer already written in the code.
The connection string suddenly stands as: Dim MyConnectionString As String = "Data Source=MY-PC;Initial Catalog=ImageLocs;User Id=test;Password=test;Pooling=False"
My form closes whenever I insert an object that has a data bound in it. The object I'm trying to insert is a textbox from the data source window (drag n drop). I've checked on the database and that the table has records in it.
View 1 RepliesI have two tables "Person" and "Alias" in a one to many relationship. I have a DGV for "Person" and want to use a combobox for the Aliases. I also have a textbox and a button for the user to type the alias name and click the button to add the alias name to the combobox and update the dataset. I keep getting the "Items collection cannot be modified when the DataSource property is set." Error. But if i use a DGV instead of a combobox for aliases, I have no errors and everything works fine. If I remove the datasource property for the combobox it will not get populated with the data already entered, so how, or can I, set it up where the combobox gets populated when the form loads and able to add items to the combobox????
View 1 RepliesI was wondering how i can loop through a combo boxes items display item field - and return the value for each - i want this to be generic regardless of the combo boxes data source - or if the combo box has been populated with a string list / class etc
View 3 RepliesI see a couple of previously answered questions about adding an item to an IEnumerable in C#, but I'm stuck when trying to implement the proposed solution in VB.NET.
Option Strict On
Dim customers as IEnumerable(Of Customer)
' Return customers from a LINQ query (not shown)
customers = customers.Concat(New Customer with {.Name = "John Smith"})
The above code gives the error:
Option Strict On disallows implicit conversions from Customer to IEnumerable(Of Customer)
is there a way to retrieve type T from IEnumerable<T> through reflection?
e.g.
i have a variable IEnumerable<Child> info; i want to retrieve Child's type through reflection
IEnumerable interface provides a instance method GetEnumerator that returns IEnumerator type opject .That's okey .But its very hezy to me that how IEnumerable objects are able to work with For Each loop ?When using For Each GetEnumerator method is not called directly from my code .Then from where and how GetEnumerator is called ?Basically my question is that when a class implements IEnumerabel interface then how a distinct behaviour is attached to that class?How it is used with For Each without calling GetEnumerator ?Here is the sample code that i am using :
Public Class Person
Public firstName As String
Public lastName As String
Public Sub New(ByVal firstName As String, ByVal lastName As String)
[code]....
I need to create a user control which can be used in my all projects. I have created a user control with a TextBox Control and a ListBox Control. My goal is that as soon as any character is pressed in the textbox, Listbox's item which starts from that character should be selected. I have done all the coding needed for the functionality but my problem is that when I add this usercontrol to my form, I should be able to change the DataSource, displaymember and valuemember properties at designtime. But I cannot see these properties when I add the control on the form.
View 1 RepliesHow can I create the property... type the combobox? for now I found alone this that it goes in mistake
[Code]....
i'm using Enumerable.Except to check if a DataTable in memory is in sync with the table in database.
The background is: this DataTable and other frequently used tables are stored in the Cache of a WebApplication. But meanwhile i'm convinced that this is not a good approach because it's a source for nasty errors that are difficult to reproduce/debug.
Therefore i've created a function that checks if database and memory are in sync, otherwise an error-log will be created. This works perfectly. If there is a row in memory that is not in database, this row will be shown below "Difference in database", the same applies in reverse. But if rows exist in both datasources(the PK idRMA) and some values differ, the log will contain this row in two versions(below "Difference in database" and "Difference in database"). It is not easy to see the differences on the first sight.
Q: Is it possible to select only the properties that caused Except to think that first sequence is not in second?
This is the the complete function(the first lines are relevant):
Public Shared Sub CheckRmaMemoryInSyncWithDB()
Dim inSyncText As String
Dim color As Drawing.Color
[Code]......
I'm trying to use the page control's collection with LINQ. Whereas this works:
dim l = Me.Controls.OfType(Of TextBox).AsQueryable()
the following return an ArgumentExceptionError:
dim l = Me.Controls.AsQueryable()
I used this but did not work :
Dim IENUM As IEnumerable = dat.getDanhSachDongSP
Dim bid as New BindingSource
bid.DataSource = IENUM
Dim dt2 As DataTable
dt2 = bid.DataSource
It show error "cant convert from IEnumberable to datatable"
when you use the object browser to see the features of a sortedlist elementat is not shown , but because a sorted list inherets features of ienumerable it works, cant that be corrected
View 1 RepliesWhile learning to use LINQ in VB.NET, I came across the following:Dim x As IEnumerable = (some LINQ query)
If you can't instantiate an interface, but only a concrete implementation of it, why is this allowed? Is there some difference between doing Dim x as (Type) and Dim x as New (Type)?