Jump to content
Xtreme .Net Talk

Robby

Moderators
  • Posts

    3848
  • Joined

  • Last visited

Everything posted by Robby

  1. We already discussed them a couple of months ago.
  2. I would change the email part as well... "SELECT Name, Company, Address, Email " & _ "FROM CRM_contacts " & _ "WHERE Email Is not null AND Postcode = '" & txtPost & "' " & _ "ORDER BY Company"
  3. I would consider changing the stucture of the xml to use elements, anyway, whatever suites you. this should get you started XmlTextReader tr; string path = "c:\test.xml"; tr = new XmlTextReader(path); FileStream fs = new FileStream(path,FileMode.Open); tr = new XmlTextReader (fs); string temp=""; while (!tr.EOF) { //read here }
  4. in your Catch you can Throw an exception to the calling function.. Catch e as Exception Throw new Exception (e.message) Then in the calling function you can display the error in a label or on the page.
  5. You can use GetPixel and GetDC.... Private Declare Function GetPixel Lib "gdi32" (ByVal hdc As Integer, ByVal X As Integer, ByVal Y As Integer) As Integer Private Declare Function GetDC Lib "user32" (ByVal hwnd As Integer) As Integer
  6. Does your current Loop cause a timeout?
  7. Divil, they're in Phoenix, Arizona
  8. I just changed over to http://www.crystaltech.com/plan2.htm I then realized that there servers are GMT - 8, D'OH!. There service and control panel are one of the best I've seen, I submitted 6 tickets and they were each replied to within a few minutes.
  9. Method 2 comes in handy if you're not using response.redirect(), especially if you want to pass objects from page to page and not just strings.
  10. In case you perfer to let the thread run on its own, you can get rid of the following... Dim ii As Integer Do While bThread.ThreadState = System.Threading.ThreadState.Running ii += 1 Loop
  11. Wyrd, I think you missunderstood, his DB design is fine (I think), it is the way that he wants to display the resultset to the user that needs to be in that fashion (or so). Is this correct bizzydint?
  12. I think I know what you want to display.... Author1 Book1 Book2 Author2 Book3 Book4 Author3 Book5 Book6 Book7 Book8 Instead of this method.... Author1... Book1 Author1...Book2 Author2...Book3 Author2...Book4 Author3...Book5 Author3...Book6 Author3...Book7 Author3...Book8
  13. Something more generic that should be more portable... ...server=127.0.0.1...
  14. The threading is done using ASP.... [mshelp]ms-help://MS.VSCC/MS.MSDNVS/cpref/html/frlrfSystemThreadingThreadClassStartTopic.htm[/mshelp]
  15. You should run the Package as stateless/asynchronous. Look up Threading, it's quite simple.
  16. Hmm, that has never happened to me. Sorry I have no answer.
  17. Hmm, I've forgotten the title, now I'm confused as well.
  18. cutiti, what does your code look like?
  19. There are a few interesting links here ... http://www.google.ca/search?hl=en&ie=UTF-8&oe=UTF-8&newwindow=1&q=microsoft+office+interop+c%23&btnG=Google+Search
  20. Have you tried the same actions while commenting the above code?
  21. Did you Run the code in Release Mode on the machine with VS?
  22. Why can't you use an Inner Join like the following? "SELECT Parent.ID,Parent.Author, Child.Book, Child.description " & _ "FROM ParentAuthors INNER JOIN " & _ " ChildBooks ON ParentAuthor.id = ChildBooks.id"
  23. Do they all have the same version of the Framework?
  24. Are you adding/formatting the dg at runtime or design-time?
  25. Is it really a many-to-many? Can one book have multiple authors? Are you using a Select statement, or a DataSet/DataTable to display them seperatly?
×
×
  • Create New...