Search results for query: *

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....

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!!!

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

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!

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...

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...

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...

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

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()...

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...

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

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...