You searched for the word(s): userid:701918

More Search Options

RSS Available

• Linq Select where id not in statement help...

  I have two tables. The Programs table has a record for every program we offer along with an id for that program. The second table needs to be updated periodically to make sure it has a record for every active program id. This is how I would write the SQL outside of LINQ. select id from programs where active = 'true' and id not in (select program_id from table2) Now, what would be the best way to write this in LINQ? Maybe using a join? Maybe its just too early, but my brain doesnt seem to

  Posted to Data Access and ObjectDataSource Control (Forum) by jmsewe0 on 12/1/2009

• Re: Linq Select where id not in statement help...

  Sorry for the trouble - but looks like i figured out how to do it. Here is an example: var query = from c in dc.Customers where !(from o in dc.Orders select o.CustomerID) .Contains(c.CustomerID) select c; Here is where I found the answer : link Thanks!

  Posted to Data Access and ObjectDataSource Control (Forum) by jmsewe0 on 12/1/2009

• Re: Create an XSD with some type of inheritance

  Martin - that is basically what I thought. I appreciate the help! Thanks! Josh

  Posted to XML and XmlDataSource Control (Forum) by jmsewe0 on 11/10/2009

• Create an XSD with some type of inheritance

  Ok, so I am not sure this is possible, and I have looked everywhere, but I have not seen an example that can help out. I dont even know if this is the best place to post this. My company sends XML to another company in the format that they request. They did not provide a schema, so I am trying to write on to validate the xml before we ship it over to them. Here is where it gets tricky. Below is and example of the xml we send: <resultset table="sport"> <sport> <field name

  Posted to XML and XmlDataSource Control (Forum) by jmsewe0 on 11/4/2009

• app.config in a windows service does not update the service

  Odds are this has been answered before, but it makes absolutely no sense...I created a test Windows Service that writes to the Event Log. It writes to the Event log an entry that takes a value form the app.config every 30 seconds. here is the source: private void timer1_Elapsed(object sender, System.Timers.ElapsedEventArgs e) { if (!EventLog.SourceExists("TestingSource")) { EventLog.CreateEventSource("TestingSource", "TestingLog"); } EventLog.Source = "TestingSource";

  Posted to Configuration and Deployment (Forum) by jmsewe0 on 9/14/2009

• Re: app.config in a windows service does not update the service

  Nevermind - i am quite the bonehead. I was updating the app.config in the project folder and not the one in the bin folder. I got it to worlk.

  Posted to Configuration and Deployment (Forum) by jmsewe0 on 9/14/2009

• Re: Hide the update panel when update progress is displayed

  I am having the same issue here - anyone? I have two panels - one for a login, and one once the login is complete. I want to make the app sleep for a few seconds while the user logs in and display the update progress control, but hide the other two panels. Any thoughts? josh

  Posted to ASP.NET AJAX UI (Forum) by jmsewe0 on 6/12/2009

• Linq to SQL deleting columns

  We are using LINQ to develop an in house application and I am having some issues with it. My first issue - I have a query that returns multiple possible rows. For example there is 4 columns with one being program_id. If I select all rows where program_id = 1, I receive 4 rows with all 4 columns. The problem is the fourth column has all the same values, so the users do not want to see that column. I tried to handle all this in the stored procedure, but LINQ see the multiple select statements within

  Posted to Data Access and ObjectDataSource Control (Forum) by jmsewe0 on 3/16/2009

• Re: Gridview Question with possible Cross Tab query

  Ok, so my pasting from Word didnt turn out so well. Anyway, the question is still there, and I think i will be in need of a PIVOT table and not cross tab query. Discuss :)

  Posted to Data Presentation Controls (Forum) by jmsewe0 on 2/13/2009

• Gridview Question with possible Cross Tab query

  Ok, here is the deal. I have a table with values that need to be rearranged to look good in a gridview. My Table looks like this: Normal 0 false false false MicrosoftInternetExplorer4 /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin:0in; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font

  Posted to Data Presentation Controls (Forum) by jmsewe0 on 2/13/2009