Last post May 21, 2011 03:30 AM by Decker Dong - MSFT
May 18, 2011 10:52 PM|dreamit|LINK
column names = uid (primary key ), holddata (10) rows (values) = 1,2,3,4,5,6,7,8,9,10 && 100,100,100,100,100,100,100,100,100,100 now on submitting of input (say - 1,3,6,7 ) from a Textarea box in which input are comma seperated uid rows (values) , the corresponding
holddata values must get modified as (1, 100, 1, 100, 100, 1, 1, 100, 100, 100) Eg:- posted data from a form using TextArea Field through comma seperated input the "uid" (column name) must get selected and modify the holddata ( column name ) values in a database
as shown above. please help us in our coding, in which we got stuck!
May 20, 2011 10:06 AM|mitja.GTI|LINK
please take a look at this methods...
Arrays and Lists in
Passing a list/array to
SQL Server stored procedure
May 21, 2011 03:30 AM|Decker Dong - MSFT|LINK
Your request is at a mess. So I (maybe) didn't catch you so accurately. Please correct me if I'm wrong
You want to get each values from the statement with the commas and modify them, do you?
if yes, let's say:
stringvalues = Your Value From TextArea.ToString().Split(',');
values[0-based index] = new value;
string newvalue = string.Join(",",values);
//Update with the newvalue..