Jump to content
Xtreme .Net Talk

Robby

Moderators
  • Posts

    3848
  • Joined

  • Last visited

Everything posted by Robby

  1. You shouldn't be using Response.Write(), use RenderControls instead.
  2. http://www.aspnetmenu.com has a great package for $119, I'm sure there are free one out there as well.
  3. Congrats, is it contageous (getting twins)?
  4. Robby

    break points

    Did you enable debuging and make sure you are not in Release mode.
  5. When you set the DataSource you also need to set the ... .DisplayMember = "SomeTextToShow" .ValueMember = "SomeID" The above 'SomeXXX' are field names from your table.
  6. Try this... 'the displayed text MessageBox.Show(cboCustomers.SelectedValue.ToString) or for its' index position in the the control MessageBox.Show(cboCustomers.SelectedIndex.ToString) 'or even MessageBox.Show(cboCustomers.Text)
  7. With SQL Server the number is created only when the row is saved/inserted. So yes, you cannot know what that number is until the new row is inserted. What is the PK used for elsewhere on the screen, is it part of another field, perhaps you can circumvent this approach.
  8. Where is the connection string pointing? To a local or remote database?
  9. The other PC may have a firewall blocking access to the remote SQL Server.
  10. Robby

    Increment?

    I don't see it as a good idea. why not do this... x +=1
  11. Short answer: Don't. Instead store the path of the image. This will save a considerable amount of database size. Retrieving/displaying the images thereafter is quite simple.
  12. Why not use Identy (autoIncrement) on the ID column?
  13. No way Volte, that was next on my plate. Anyway, by the time I get to it you'll probably be finished yours.
  14. What I'm thinking is; When you search a product by ID it will return (let's say) red, white, black, and Small, Med, Large, XLarge. Does this mean that each color has a matching size?
  15. when you say 'i have hidden some Fields' , do you mean you made a column not visible? you can use e.Item.Cells(0).tostring in the selectedindexchange event sorry if the syntax is off, I don't have .NET handy.
  16. I just thought of something, what if the user selects a color and size that do not exist? Isn't it better to display each color and size per product as the user selects a product?
  17. Sharp Invader, cool name. :) Waiting for a .NET contract to pan-out. In the meantime, I'm working a few small things, mostly asp.net.
  18. Since you're binding two controls you should seperate the SQL into two statements. Excluding Productsxsizes from Colours will give you the Distinct you need. (and vice versa)
  19. You can parse the file and load an array or a dataview, and perhaps for each item in the TH tags create the header for each datagrid column. Once the content resides in an array you can Bind it to the datagrid.
  20. An important note, SP3 is needed on the Client (dev machine) as well as the Server. See if this is helpfull ... http://www.sqldev.net/download/dts/DotNETCookBook.pdf
  21. I ran my package and got the same error on a simular line. I don't know how to fix this, sorry. I'll do a bit of research as my curiousity is peeked.
  22. Does the above data exist in a file or database or an array?
  23. I just tried it out and you need to make a few changes... I have not run the following, but it should work. oConnection = goPackage.Connections.New("DTSFlatFile") 'change this.... oConnection.ConnectionProperties("Data Source") = "C:\test.txt" 'to this.... oConnection.ConnectionProperties.Item("Data Source").Value = "C:\test.txt"
  24. I haven't tried this, but you should be able to Reference the "MS DTSPackage Object Library".
  25. What object/method are you using?
×
×
  • Create New...