Search results for query: *

  1. P

    EF5 Legacy Detecting a new relationship

    Hi guys, As title says im using EF5 legacy Im just wondering if it is possable and not overly complicated to 'catch' when an object is being added to another object. So i have a Car table/object and an Order table/object, im looking for something like the onpropertychanged when i add an order...
  2. P

    Passing objects through forms

    ...= "System.Data.SqlClient" EntityBuilder.ProviderConnectionString = My.Settings.SQLServer_Address EntityBuilder.Metadata = "res://*/Model1.csdl|res://*/Model1.ssdl|res://*/Model1.msl" Dim EntityConnection As New EntityConnection(EntityBuilder.ToString)...
  3. P

    Passing objects through forms

    ...= "System.Data.SqlClient" EntityBuilder.ProviderConnectionString = My.Settings.SQLServer_Address EntityBuilder.Metadata = "res://*/Model1.csdl|res://*/Model1.ssdl|res://*/Model1.msl" Dim EntityConnection As New EntityConnection(EntityBuilder.ToString)...
  4. P

    Nested Rows in DataGridView

    Hi Yeah i came to this conclusion as well after many hours of looking into it i dont think the result is worth the effort. So i decided just to mouse over the cell and it will show the details you might want to know :D Thanks for your input
  5. P

    Nested Rows in DataGridView

    Hi everyone, im annoyed with myself as im sure i had some help getting this done before and im an awfull one for starting projects again and again as i find/learn better ways of doing things, but i cant find the project that i used the nested rows before and im not to great with Datagridviews...
  6. P

    Reading HTML and performing Regex

    ...page of HTML how can i get the regex to match the full block above, when i said i cant run another regex i meant i cant just search for the <dt>.*</dt>. as you can probably tell from my code i have been searching for this line 'Obtained <a href="/wow/en/item/113961" class="color-q4"...
  7. P

    Reading HTML and performing Regex

    ...Dim Sourecode As String = sr.ReadToEnd Dim Item_ As New System.Text.RegularExpressions.Regex( _ "Obtained <a href=""/wow/en/item/.*"" class=""color-q4"".*") Dim matche_name As MatchCollection = Item_.Matches(sourecode) For Each Match As Match In matche_name...
  8. P

    EF6 Connection Strings Dynamic

    I'm just carring on with making this thing leaving it as it is for now. I have actually commented out the login call so it doesn't annoy me when debugging :D. but I was thinking on the subject, I'm not great with networking, I understand the basic principles of it, but already attempted to set...
  9. P

    EF6 Connection Strings Dynamic

    I had a look at the thread and at SQL integrated security, I think im going about this the wrong way. my only reason to use users are: 1 Username, our invoices ordernumbers ect use our initals, invoice number VB13082014P1 VB13082014W1 it has happened a number of times we have sent invoices...
  10. P

    EF6 Connection Strings Dynamic

    Herman, I could jump out of the screen and kiss you!!!!! changed to EF5 few minor changes and its working as I had hoped. Rep for you mate. Could I ask you to have a quick look at the way im doing the login, is their anything their thats a big No No or if it works go with it?
  11. P

    EF6 Connection Strings Dynamic

    owww, EF6 is not microsoft made, yea il go for EF5. I have to look into how to setup to use that instead of EF5, tried using the .ToList in my app and it didn't make anything better, so back to the drawing board it seems :( Thanks for your time Herman
  12. P

    EF6 Connection Strings Dynamic

    Hi Herman, thank you for pointing that out, your spot on, im going to try that to see if I am getting a connection or not. TBH no i dont need the new features, the thing that started me upgrading was the Enum support in EF5, Im far more comfortable with VS2010 but it doesn't support Enum in...
  13. P

    EF6 Connection Strings Dynamic

    ...EntityBuilder.Provider = "System.Data.SqlClient" EntityBuilder.ProviderConnectionString = My.Settings.SQLServer_Address EntityBuilder.Metadata = "res://*/Model1.csdl|res://*/Model1.ssdl|res://*/Model1.msl" Return New ImageEntities(EntityBuilder.ToString) End Function
  14. P

    List advice

    I was struggling as their wasn't a Colours property in ModelsColours, but now their isn't a ModelsColours table show it just shows the Many To Many relastionships and Models now has a Colours property. With cb_Colour .DataSource = CType(cb_Model.SelectedItem, Model).Colours...
  15. P

    List advice

    Hi JMC, I got it working, I spent a bit of time googling and how to use Many To Many relastionships with EF, I noticed that EF manages the navigation properties for Many To Many so figured the culprit had to be my DB. I was using a seperate PK for the ModelsColours table but also noticed I had 2...
  16. P

    List advice

    Hi jmc, Thanks for your reply I had started doing this, thought the DB tables would be the better long term solution, also the fact I would need to transfer files around the clients if doing the list. I did have to make a few changes to what I had done after followng your instructions. I am...
  17. P

    List advice

    Hi guys, I'm looking a bit of advice of the best way I should construct the list/lists/Dbtable/DBTables :S I'l try my best to stay on topic and keep it simple. I need to fill 3 properties Car.Make Car.Model Car.Colour, each property cancels out options for the next, eg VW would leave only Vw...
  18. P

    Question Filtered Select statement on Entity Framework

    Hi guys, just to make it noted for anyone else that has this problem and comes across the thread, this is what i did.. 'Gets List Of ALL Cars From Dealer With An OrderNumber From That Department Dim listofcars = (From car As Car In db.Cars, Ord As Order In car.Orders Where...
  19. P

    Question Filtered Select statement on Entity Framework

    hi Herman, yea sorry your right, not much information at all, posted this Very late at night, i shall update first post
  20. P

    Question Filtered Select statement on Entity Framework

    Hi guys, got my lambda expression fixed as in i didn't need them, never realized i could use two arguments for comparison. I have a CheckedListBox, that holds a Collection of Cars, And a DataGridView That Displays The Cars.Orders The Problem i am getting, is the a common problem, that...
Back
Top