Binding NHibernate Proxy Objects To A DataGridView?
Jan 22, 2012
I am attempting to bind objects pulled from an NHibernate session to a DataGridView and am having problems.I have a single session in which I fetch all of my "look-up" items that are bound to a combobox column, and then I query for the objects themselves. omehow, this still results in proxy child objects on the main objects. I have even changed the mapping of the look-up items to eager fetch, but I still get proxies somehow.Here is how I am fetching the objects:
Dim _makes As IList(Of Make) = session.QueryOver(Of Make).List
Dim _models As IList(Of Model) = session.QueryOver(Of Model).List
Dim _cars as IList(of Car) = session.QueryOver(of Car).List
I have a GUI which allows the user to select a report to view/edit. When the user selects a report, it shows the Items in the report. The Item has many properties - most of which are binding properly. One of the properties is Owner, and this is bound to a ComboBoxColumn.
Report
Items
Owner
I have done something very similar to this a few times and had no problems when I set the DataPropertyName, DataSource, ValueMember, and DisplayMember. The only difference is that this time instead of the Item type having an OwnderID it actually has an instance of the Owner object.giving the items bound in the list a self-referencing property that allows them to return themselves for the purposes of setting the ValueMember.However, When I bind it this way:
I get a lot of errors like: Unable to cast object of type 'System.String' to type 'Owner'.
and:
The following exception occurred in the DataGridView:
System.ArgumentException: DataGridViewComboBoxCell value is not valid.To replace this default dialog please handle the DataError event.I was able to get around some of these errors by binding it like this:
and also by making the ToString function on the Owner display the OwnerName property. This seems pretty hacky though - and I think I'm misunderstanding something fundamental as it still does not function properly.
Basically, I wish to fetch a filtered set of objects from the database (Oracle 9.2) based on the id property of the object PsalertsEvent. The code being executed is:
Public Overloads Function GetAll(ByVal laterThan As Long, ByVal filteredPsalertsEvents As IList) As IList Implements IPsalertsEventRepo.GetAll 'Get all psalerts events with an ID greater then the specified laterThan parameter filteredPsalertsEvents = MyBase.NHibernateSession.CreateQuery("from PsalertsEvent p where p.id > " & laterThan).List
I just read this article about the Entity Framework 4 (actually version 2).Entity Framework seems to offer a huge improvement over its first release. Thus, I have never ever used EF in any project, since I think EF is not mature enough in comparison to NHibernate.NHibernate and its current contributions of FluentNHibernate and Linq for NHibernate by Ayende RahienMy feeling is that Microsoft is solely trying to gain terrain it has lost in favor of NHibernate when the 2nd version of NHibernate came out.Nevertheless, my concerns are the followings (not in particular order):Will EF4 tend to be less XML-verbose?Will EF4 be compatible with other underlying datastore than just SQL Server?What are the greatest benefits of going with EF4 instead of FluentNHibernate or NHibernate itself.
NHibernate is a great tool, I guess everyone agrees. Due to its predecessor Hibernate, we may easily find documentions and tutorials and sample applications to get acquainted with it. This is not the case for FluentNHibernate. Particularly as per the project I'm working on right now which demands that I investigate further about NHibernate and its options (FluentNHibernate for instance) in order to document the rules of usage and the best practices of NHibernat and FluentNHibernate technology. Thus, being handcuffed with VB.NET, being a C-Style developer, I can't find some syntax equivalencies in VB.NET for the examples provided, though I made I way so far
I would like to ask if you can use VB.NET for NHibernate and Fluent Nhibernate?I have searched the web, but I can't seem to get a detailed or explicit statement that tells that one can use VB.NET for NHibernate and with Fluent.
Many of the samples in the NHibernate site are made in C#. That's why I was wondering if I can't use VB.NET when using NHibernate.
I'm currently working on binding an objects properties to fields on a Form. Whilst I have managed to get it so that I can get standard objects to bind, I am having a problem figuring out how I would go about binding an inherited object.
For example, if I had a Client class (the parent class) and then two sub-classes called CompanyClient and IndividualClient. The CompanyClient would have an extra field company name for example.The problem I'm having is that I'm not certain how to set up the binding, as if I set up the binding against the Client class then I would be missing the Company Name property for the CompanyClient, if I set up against the CompanyClient, then it wouldn't work with the IndividualClient as it doesn't have all the fields.
I know I could get around this by having different forms for each of the different Client types, but as almost all of the properties are the same I would like to avoid this if I can.I was wondering whether anyone knows how I might be able to go about doing this
VS2008 targeting .Net 3.5x. I have a combobox with a datasource and display member set, and when I run the project, I see the items. I am also binding the selected item to another object which contains the item upon which I want to select. I have verified that both the bound object and its underlying data contain the value I expect. The problem is that I cannot get it to select the correct item - it only ever selects the first item in the list.
I have a class from where I need to set objects in another form?
Form1: vb.net Function SetMyObject(ByVal frmTarget As Object) frmTarget.PictureBox1 = Form1.PictureBox1 End Function
(Not tested code, just wrote to show what I mean)So that's the late binding one.I should also say that the frmTarget variable isn't static so thats why I can't make something like Form2.PictureBox1 = Form1.PictureBox1
I'm making a application to use in college to retrieve my calendar and other things in VB.NET. But my college uses a proxy so when I connect my laptop I need to change the internet settings in my web browser to view web pages. how I would send requests via a proxy server in VB.NET? Or is there a piece of software that I can download which tunnels all connections or is there a setting in win7 does this?
I'd like to set the proxy for a web request. However, when I say, for example, request.proxy = "x.x.x.x:xxxxx", it gives me the error "String cannot be converted to webproxy". How can I get around this and actually set the proxy?
I want to bind it to the DataGridView and show it in a tree-like structure with the authors and editors shown seperately in expandable (+) symbols. I dont want to use DataSet. How do I do it using the XSD and the class file generated from it?
i have an empty datagridview on FormA and calling a function in FormB to run a query and bind the results to FormA's datagridview. i receive no errors, but nothing shows up in the datagridview.here's my code (note: sql statement does return results within sql management studio)
vb.net
Public Sub GetRecorders(ByVal _sqlString As String) Try[code].....
I've bound a collection with public properties that are of type double to a datagridview control. If, in the datagrid, the user enters a value that is a string I get an error thrown, and I can't seem to find the method to handle it.
The only way I've been able to fix this is to make all public items in my bound collection of type string, and in the get/set make the private variables double.
This is a huge pain; is there any way to do this in a more elegant fashion?
2nd question is there a way to make the default header text something other than the public property name? (I know I can manually change this in the code later, I was wondering if there was a way to automatically have it something else)
(below is example code; I've changed the P property to reflect that change I had to make)
Public Class clsPIDElement Private _P As Double Private _I As Double
I have a grid populated from a list. Now there are particular properties in this list that I don't want displayed on the grid. It displays all of the columns perfectly, then adds 2 others I didn't originally have on the grid when I constructed it in designer mode. I have removed them after the binding with DataGridView.Columns.Remove("ColumName"). However, is there a way to prevent it from adding these beforehand, or is this the only way?
I have a datagridview with a column made of comboboxes. Is it possible to bind them to the result of a query? I've been able to do that, but I need to bind each combobox to a different query, or better to the same query which is called with a different parameter.
So, I have column1 which is made of combos. The user selects an item, and in column2, which is made of combos as well, I get some items which are taken from a query where the parameter is the value the user selected in column1. After that, I have column3, made of combos, in which each combo is populated with values resulting from a query with 2 parameters: one is the value selected in column1 and the second from column2. And this should be for each row.
I've been able only to bind the combos of column1, which are all populated using the same query. I thought I could use an array of tables where the i-th element of the array has the table (populated by my query using the table adapter) which contains the element of the combo in row i. Is it possible to bind the combo in column_j and row_i to that table?
I have a bit of code which loads data from a stored procedure in MS SQL Server and then loads the data to a datagridview, which works fine. What i want is for the code that connects / loads the data to sit in my Database Class and then everything associated with the datagridview to be stored in my Form but i am having problems passing the contents of the bindingsource over to the Form from the Database Class.
I developed a windows forms app, using VisualBasic in VS 2010. In my form, first I declared a variable as DataTable (Dim VarTable as New DataTable). Second, changed the DataSource property of my DataGridView (DataGridView1.Datasource=VarTable) Third, I filled the VarTable in this way: using a resulset from SqlDataReader, i added row by row.
Dim Result As SqlDataReader=CommandSQL.ExecuteReader Do While Result.Read() Dim RowToAdd As DataRow RowToAdd=VarTable.NewRow() RowToAdd("Code")=Result("Code") RowToAdd("Name")=Result("Name") VarTable.Rows.Add(RowToAdd) Loop
Fourth, after the user changed data in datagridview, I saved the data back to SQL, cleared VarTable (VarTable.Rows.Clear()), and back to top of form to accept a new code. But here, problems begin. When I execute again the whole code described, the datagridview dont show the entire rows, and sometimes crashed with different errors. Solution? Dont fill VarTable row by row. Use VarTable.Load(Result) to populate the VarTable. I don't know why now works, But just I wanted to share this information.
I have DataGridView which is 'binded' to dataset table. When I add new field to the table from access ,that field not appears in the datagrid. I am looking a way to refresh datagrid columns.I was try to delete datagridvew and add new datagridview with the same properties,but still last field(column) is missing. I was try to add new column manually, and I was set property name corresponding to the new field name. but data is not shown.
I created two tables(FIRSTtable and SECONDtable) in the mysql database and two tables that are related.[code]...
Relations between the two tables using the product_id column with UpdateCascade and DeleteCascade. Both relationships are functioning normally when I try with the sql script. Suppose I delete all product_id in the FIRST table, all existing data in the SECOND table will be deleted.
Both of these tables displayed in datagridview. When I delete all the data in the FIRST table, the all rows in datagridview FIRST table will be deleted, also the data in mysql the FIRST table will be deleted.
I try to open the mysql database, the data are in SECOND Table also deleted, the problem why the view that in the second datagridview, can not be deleted, still keep the previous data? How to refresh datagridview binding in vb.net or C#? [code]...
Public Structure RetailRpt Public FromDate As Date Public ToDate As Date
[Code]....
I've added the DSRPT structure from the datasource of the datagridview. but unfortunately I can't manage to show the nested structure data with [+] in the datagridview row.
I have set up at DataGridView "cdgvExp" for data entry. cdgvExp.Datasource = ExpTab. The datagridview can accept new rows according to how many entries there are. I will then use the data in ExpTab. The Fourth colum is called "Lot" and is a combobox in the datagridview. The goal is to have the Combobox in the fourth column have the datasource be LotTab which is populated according to other choices in the form. I am hunting for something that would work like an independant combobox like cbLots.datasource = LotsTab
How do I dynamically set the Datasource and Datamember of a combobox that is already set up in a datagridview?
datagrid.datasource = dataset.tables(0) datagrid.datamember = "Column1" 'Where this is the name of the column
This would show me just that column in the grid regardless of the number of columns in the dataset.
In VB.NET 2008 I do: datagridview1.datasource = dataset.tables(0)
I see all the columns.I then add:
datagridview1.datamember = "Column1" 'Where Column1 is the column name
I then have an empty grid.How does one get only a single column to show in the grid from a multi-column data source? I am using internal code to populate the datasets and tables.
like this i have n number of questions in my word document. so my need is i need to read the questions and fill it up in the datagridview with yes or know chek box. my datagridview appearance would be as follows. so the peson who is viewing the questions and can make yes or know option using the check box.if the person chooses no option he has to enter the reason the reason column. so i have to do this dynamically. means that binding datagridview with checkbox ,textbox, data dynamically. how to do this please because after the datas entered in the datagridview i have to loop through rows and i have populate into another word document. so please if there is any sample
I can't get my binding source to update from a DataGridView
This is how I'm loading the dataset into the dgv:
vb.net Dim sFileName = filelocation & "Checks.xls" Dim connectionStringTemplate As String = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0};Extended Properties=""Excel 12.0;HDR=Yes;IMEX=1""" Dim connectionString As String = String.Format(connectionStringTemplate, sFileName) Dim sqlSelect As String = "SELECT * FROM [Sheet1$];" Dim workbook As DataSet = New DataSet()
I have one DataGridView named dgv.dgv is pretty much a plain gridview. No bounded data. No columns added. It's basically empty.I also have one DataTable named dt.I add rows and columns manually into dt.
dt.Columns.Add(New DataColumn("TexBox", GetType(String))) dr = dt.NewRow() dr("TextBox") = String.Empty dt.Rows.Add(dr)
I then simply set dgv datasource into dt.
dgv.DataSource = dt dgv.Refresh()
I then set the value for this particular cell.
dgv.Item(0,0).Value = "xxx"
Now when I run and execute all those commands. I happen to retrieve the gridview with that value indeed. The "xxx" cell appeared and currently it's uneditable.What I want to achieve is:Allow this "xxx" cell to be editable. Preferrably if it can be inserted into a TextBox control inside the cell.
