Recent content by Lemon

  1. L

    Grouping data already in the dataset

    Strange aint it, when you find out what your problem is and its the simplest thing, well for future refernce, if anyone else finds the same problem, all it takes is adding the 'DISTINCT' keyword to your SQL statement...e.g. SELECT DISTINCT * FROM....
  2. L

    How do I find out how many items have been populated into a datagrid?

    I need help! I just need to find out (if its possible) to retrieve or count the amount of records that have been populated to the datagrid from a query... Basically test if the amount of records is > 1... If you have any Ideas, please help!!!
  3. L

    Resetting a dropdownlist after a postback

    Dont that just beat all, I found it!! Thanx anyway!! "MyDropDownList.SelectedIndex = 0"
  4. L

    Resetting a dropdownlist after a postback

    I'd guess its a pretty easy but I just havent learned to do it.... Incase your wondering and it would help all I want is on a postback to set the selectedindex of the list to '0' (the first entry) Just need and example of the code!! Please help!
  5. L

    Grouping data already in the dataset

    Well ,my database is laid out so that each manufacturer's products are all held within one table, no relationships... The fields, are the PrinterModel(used to query on),CartridgeDescription,CartridgeCode(also for querying),Capacity,PageYield and Type (for querying). So fact of the matter is...
  6. L

    Grouping data already in the dataset

    I have it like that... One SQL query returns the printer models(the problem one), and the 'SelectedIndexChanged' event in that ddl, triggers the query to populate the next ddl with the available cartridges.... The problem query works great, but I just cant get those duplicate printer models...
  7. L

    Grouping data already in the dataset

    Hey, I'm stuck with a problem I have to get sorted out!! I'm need to group data thats already been loaded into a dataset. The data is loaded populated to a dropdownlist. Sql server database in case you're wondering... The user must select the desired printer model, and the next query fires...
  8. L

    Inserting data from textboxes to a database?

    THANX!! Its working properly now!! I'll prolly be back soon enough with more problems later on! But thank you for now anyway!
  9. L

    Inserting data from textboxes to a database?

    Thanx alot, got that cleared up!! ;) Prefer the second method!! Ummm, now more troubles!! How do I call the funtion I have the insert query in?? I currently have it set to the datasource of a datagrid....NOT working.... e.g. Grid1.DataSource = InsertData() Grid1.DataBind()...
  10. L

    Inserting data from textboxes to a database?

    Hey, got a little problem....again....hoping for some help!! OK, I need to insert data into a SQL server database from textboxes, each textbox the entry for a different field, of course! Its simple enough writing the queries, but how do you have query take the information in the textboxes as...
  11. L

    adding data to a dropdownlist already containing items

    Thanx alot Craig, that definitely helped! Its just that little thinking out of the box that gets me sometimes... But, yeah its working great! :D
  12. L

    adding data to a dropdownlist already containing items

    Well, I'm hoping someone can help me.... I've got a web application that queries data from a database based on selections made in previous dropdownlists. The problem is that some of the final queries return only one data item. I'm using the onSelectedIndexChanged with autopostback enabled as...
Top Bottom