Search results for query: *

On second thoughts I'm running it off directly from an IIS web server (instead of locally). So I guess there must be a bug in the event wiring mechanism?

Thanks again. I shall investigate when I get hold of VS later (I'm using Visual Web Developer at the moment). Now if I bind the ddl as suggested, how can I pass the changed value back to the GridView's underlying datasource for updates? Right now when I click "Update" in the GridView all the...

Thanks both. I changed to the .DataSource and DataBind() method and it's working fine now. But I also tried a debug/step-in as advised by Mark and did notice the event was indeed ran consecutively. So why is it that the second case work but not the first? NHW

Thanks a lot for the tip. It's capturing the event correctly now. But I've now run into another problem. When I run a loop to populate the dropdownlist, it seems to be repeating. Example Code: *** 'After verifying edit mode and retrieved the control ddlRank For i = 1 To 3...

Hi. I'm trying to create a dropdownlist show up when a row is being edited. And the number of items in the dropdownlist depends on the number of rows in the gridview. When i run the code, it's always complaining not being able to reference to the dropdownlist object. Here's the snippet...

Thanks for your advice. I shall play around with it more.

Thanks for the reply. The scenario is I need to create 20 online surveys, and they all share the same structure (except the number of questions) in terms of answer types, validation etc.. So instead of making 20 aspx files I thought it might be easier to create one page, then feed the contents...

I'm trying to create dynamic controls which type and ID depends on some row data retrieved from a database. For example if the data column "productType" is "1", then create a textbox with ID the same as the column "productID". I've tried using a Repeater. But the problem is there seems to be...

Hi. I'm using an application that allows users to save multiple files at the same time. Each filename is based on a property which may not be unique. In case there are duplicate filenames, the application will ask whether the user wants to overwrite. If so, it will do so. And if not, the save...

Thanks.. what if I want to assign a ranking to the results according to Year and Model? Eg. (I just made up the AvgPrice and sorted the table for convenience) Thanks! SNum Year Model AvgPrice Rank ---- ---- ----- -------- ---- 1 2003 A 20.4 1 2 2003 A...

Hi. I'm trying to average the data of a column according to the grouping of 2 other columns.. e.g. the raw data is SNum Year Model Price ---- ---- ----- ----- 1 2003 A 20 1 2003 B 10 2 2003 A 15 2 2003 B 10 2 2003 C 12 3 2003 B 20 1 2004 A...

Thanks. It works like a charm :)

Hi, I'm having troubles trying to aggregate some data. The source table is like this: Staff Shop Colour Value ----- ---- ------ ----- 1 1 R 50 2 1 R 35 3 1 R 44 1 2 R 70 2 2 R 34 1 1 B 90 2 1 B...

Thanks so much! The coalesce function works like a charm. But could someone please kindly explain why it works this way? I checked books online and it doesn't seem to say much.. Thanks again! NHW

Hi all. I'm having problems doing a simple join (I think).. hope can get help here. I have 2 tables (due to other reasons I can't put the data into one single table to begin with): Table A: ID Year ValueA -- ---- ------ 1 2004 A 2 2004 B 2 2005 C 3 2005 D Table B: ID Year...

SQLSister: I've currently come across a problem that you raised - what if I want to count the number of occurances of a value for different columns? Eg if my table is: Val1 Val2 ---- ---- True True False True True False False True True True And I want to return a recordset with...

I think I may not have made myself clear. "Name", "Phone", and "Gender" are column names. Since I'm not trying to sort the sequence of my output, the ORDER BY clause probably isn't suitable in this case?

Hi. Is it possible to invert the built-in datagrid? Eg in the database: Name | Phone | Gender Tom | 1234 | M On screen: Name | Tom Phone | 1234 Gender| M Thanks

Thanks John. But is it possible to log the non-existing ParentID into a text file as this information may need to be viewed by users who don't have access to the database.

Hi all. I'm new to writing triggers and simply couldn't think of getting something to work. I am using DTS to import a csv file into a table called "tblChild". There is only one column, "ParentID", to insert. Some ParentID may already exist in the current tblChild. So the trigger should only...