Click here to Skip to main content
15,908,776 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hi All,
Here i m trying with listobject control in excel 2007..here i took one list control and made database fields to populate in list.

What i need is i want to update the database directly when we update the cells in list control in excel..

for that i need to capture the cell which is modified...
for that firstly i'm capturing rownumber and then through that rownumber i want to find the value which is modified and i need to update the datbase directly...

hope everyone understand this..
Here is my code:
C#
int i= list1.SelectedIndex;
string x = "A" + i.ToString();
string y = "B" + i.ToString();
var cell = list1.Range["Type.Missing", y];
string p = Convert.ToString(cell);


I know that P value shows error...
but i want to know the cells value here by any means.
Posted
Updated 8-Nov-11 19:54pm
v2
Comments
Pandya Anil 9-Nov-11 8:34am    
I have a suggestion.. first check is the 'cell' null ?
then find out what is the data type of cell.. may be you will get some tails from there...
[no name] 9-Nov-11 8:41am    
ya..the thing is..the thing is i want the cell value to be converted to string so that i can refer cell value database and then update the fields..

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900