When i have a relation between two entities in my model: [GroupMember] (*) ----- (1) [User] and tries to select items from this relation with LINQ: From entity in _user.GroupMember select entity I always get an empty result unless I load the relation first with following statement: _user.GroupMember.Load() Is there a way to avoid loading the relations like this?
View 2 Replies
I'm working on a new project and got some experience with Entity Framework 3.5. Now that I'm building the model and writing the first methods I notice that Entity Framework 4 seems to load every reference to which a navigation property exists. In 3.5 I had to manually .Include() each entity that was referenced if I wanted to access them. It even loads nested references. I've got 3 tables that look something like this:
[Code]...
I have created this table using sql but I need to create a relation with another table and I don't know how.
View 15 RepliesI have two list boxes named lb1 and lb2. Those list boxes have following items.
Lb1 Lb2
---- ----
2 4
3 5
[code]....
Lets assume that I have 2 tables:
First one is customer table and has primary key called cusid ( auto increment)
Second one is order table and has foreign key custid
How I can connect them, what I mean exactly when insert the record in the customer table I need the foreign key get the same value as primary key in customer table. I'm using sql server 2008 and vb.net 2008.
I haven't lost my mind? I have done relationships in the past but now they don't seem to work. Have I gone dumb? Creating a winform, using VS2008, sqlexpress & vb.net. My dataset looks like this:
[Code]...
i have 2 forms lets say form1 and form2, i already connected the ms access to my vb 2008 and im sure that i connect it right. The problems are for example i have this in my ms access table
[Code]...
How to bound this dataset to datagridview?
[Code]...
I'm trying to generate my own dataset and create parent/child relation on the fly so that the subsequent datagridviews (dgv) that will be displaying the information will filter each child dgv by the record chosen in the parent dgv (I hope this makes sense).
So far I am able to display info in each dgv, but every record from each corresponding table is displayed in each dgv- no filtering is occuring. I think the problem might be in how I'm creating the relation and/or how I'm linking it to the dgv. Here's the code I have on the UI:
[Code]...
OK, folks, help me figure out what I'm doing wrong. I have the following
Dim table1 As New DataTable("Table1")
table1.Columns.Add("column1", GetType(Integer))
table1.Columns.Add("column2", GetType(String))
table1.Columns.Add("column3", GetType(String))
table1.Columns.Add("column4", GetType(Integer))
[Code]...
table1.Columns.Add("column7", GetType(String), "parent(Relation1).column6")On the last line where I try to add column7 I get an error saying "unable to find parent relation 'Relation1'". I thought I just added that relation?
Have a good day lets assume that i have 2 tables First one is customer table and has primery key called cusid ( auto increment)second one is order table and has foregion key custid how i can connect them , what i mean exactly when insert the record in the customer table i need the foregion key get the same value as primery key in customer table
Note : I'm using sql server 2008 and vb.net 2008
I'm working on a program that allows me to edit XML data in a DataGridView. I have most everything working but I don't like my current TreeView Structure. I load the XML data into a DataSet and edit it there, so that is what I'd prefer to base my TreeView on. I've tried a few things such as..
[Code]...
I have a problem in this Routine(VB2008) :
Dim PubAry(2) As Object
Dim cc(2) As Double
cc(0) = 3.0 : cc(1) = 33.0 : cc(2) = 333.0
PubAry(0) = cc
[CODE]...
The result is:
- pubAry {Length=3} Object()
- (0) {System.Array} Object
- Double() {System.Array} Object
(0) 4.0 Double
(1) 44.0 Double
(2) 444.0 Double
- (1) {System.Array} Object
[CODE]...
Its like Excel Sheet Cells Relations !... Why?
I have a window application develpoed in vs 2008, framework 3.5, in which i have put a button.. Now where i click that button the other text boxes are filled up with the data from database thru web service.. what i want is while all text boxes are being filled i want to show an animated loading gif image till data loading is completed in all the text boxes.. i have tried to use image picture box but while data is loading gif image is displyes but in static mode.. cant see animation... i think this is because data loading and animation both are done thru one UI thread..
View 8 Repliesan application i developed using vb 2008 express, to fill a web form with data from an access database, one after another when a button is clicked hasn't given me what i expected. the loop was suposed to stop after filling web form with the first data on clicking a button and continue to fill the webform with the next(2nd) data from the database on clicking the button again. Below is the code i wrote
Private
Sub STARTButton_Click(ByVal
sender As System.Object,
ByVal e
[Code]....
I want my program to go to a site, fill in the data, click submit then once completed go to the next site.I know you can do this in webrequest but I can only get it to login but once Ive logged in I dont know how to make it click a button automatically, I only know how to do it semi-automatically by getting the ID.
View 11 RepliesI'm actually more comfortable in Java language for developing apps. But since my requirement now is getting tighter, I need to jump forward into VB.NET
well yeah... seems need to adapt some a bit. Anyway, I typed a lot for making this setter and getter properties inside visual studio;
[Code]...
Can someone direct me on how can i automatically update my value when a user changs the combobox item. At the moment i have a button click when the user changes the combobox item and press the button the values get updated, everytime the combobox item get changed i have to repeat it click the button to update the value. I want something where automitically as soon as the combobox item selected the total value in the text box to change without clicking the button:[code]
View 2 RepliesI am writing an encryption application that requires a 64 bit key. I am currently using the following code to automatically generate a key.
Function GenerateKey() As String
' Create an instance of a symmetric algorithm. The key and the IV are generated automatically.
Dim desCrypto As DESCryptoServiceProvider = DESCryptoServiceProvider.Create()
[code]....
I am wanting the user to create their own key. Can I convert a user defined password (a string) into a 64 bit key that can be used?
I have:1 Picturebox named: picturebox1 ,1 Timer named: timer1 and 3 images named: image1; image2 and image3.What code should I add so that in the timer's tick event it automatically changes the picture in picturebox1 to image1 then image2 then image3 and so on.
View 1 RepliesI am working on one report in vb.net.when i click on export button,an excel will be generated,allowing user to prompt for save or open.There is one more button provided for mailing a report.for that i need to attach these excel file.Is there any way to send excel automatically without saving and sending as attachment when clicking on mail button.
View 2 RepliesI am using code to send email through SMTP that is given manually. I wish that user does not have to give the SMTP. My application should get SMTP automatically and use that. Can I know what is the SMTP of the current ISP, with which my client is connected?
View 2 Repliesim doing a project like now a simple. how can i increment a value automatically im using an ms access.
my data type for that is a number i have a ID no. Field and when i add a record i want to automatically add a ID no. after i add a record the ID no. will become this 12-001 and add another one the id no. will automatically become 12-002 i have no textbox in the form.
Using the code below, I am determining if the computer has service pack 1 installed for office and windows. How do I then execute the SP1 .exe if it is not installed?
[Code]....
I have a TextBox, The situation is that when a user leaves it empty, OK button is disabled. If user types in a value of duration based on days, the button gets enabled. The problem is: let's say the user clicks on text box, types in : 100, and he realizes that he made a mistake, he erase that value and tries to start filling some other textboxes and come back again afterwards, at this level at the time user clicks on other part of form, the value becomes 0 automatically and Ok button is Enabled Now.
Private Sub txtMembershipDuration_TextChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles txtMembershipDuration.TextChanged
If txtMembershipDuration.Text = "" Then
btnOK.Enabled = False
End If End Sub
Also, how can I control that automatic 0?
I have an .net windows device application. I have a small form where i want to scan one item in a text box and then scan the other in the next text box and when that is done once it is done i want to save to dababase automatically. And get the focus to the first text box automatically.
[Code]...
How to make my forms resize automatically. here's the situation. I have my intro screen, which a user may want to maximise. Once this is maximised, the whole program should stay maximised. Again, if the user chooses to restore the window to its default size, the whole program should remain in that default size. However, once the user clicks the button "Press here to start" on the intro screen, the form automatically reverts to its original size if it was maximised. I also need to be able to stretch the contents in the correct ratios to fit the new screen size.
View 9 RepliesI want my app to take a picture, then save it automatically. Can I do that with the save file dialog or how would I do that?
[Code]...
I was wondering how can I fill a column automatically in the database with the GETDATE() ?
Like when I open the database the date of that column should be GETDATE() automatically
I have a "Print" button in my formthat works fine. All I want to know is: How do Iautomatically add a new page for printing when the text doesn't fit on a single one?Here's the code for the "Print" button:
Private Sub Button5_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button5.Click
'Opens a dialog in which you can choose a printer.
[code].....
