How to validate the excel sheet using ASP.NET C#?

Question

i upload one excel document with more than one sheet and stored in dataset as data table.now i want to validate the dataset.<br /> if 'item no' is mandatory.the item number must be mandatory all sheets in excel sheet.<br /> if item number in 7 th row in all sheets but column value is different. how to validate,<br /> *All mandatory fields rows are same in all sheets but column is difference how to validate it.<br />

Answer 1

Hi,

 

Please check the attached file. 

Answer 2

Try like below : 

<ItemTemplate>
    <%# Container.DataItem("columnName") == "N" ? "<a href="" />" : "<asp:ImageButton ID='ImageButton1' ImageUrl='<%#Eval("Item")%>' OnClick='ImageButton1_Click' runat='server' />"  %>
</ItemTemplate>

 

Answer 3

Manas Mohapatra

Thank you!

Answer 4

Midhun T P

Thank you so much it's working fine

Answer 5

Hi

 

Midhun T P

In data table one column have value like 

N

R

N

N

R

 

how to change the button to image button inside the repeater(button is inside the repeater) .

Is this in table we hide and show but it is in repeater

if N comes button show if R comes button to image button how to do it.

 

Answer 6

Hi,

 

You can use both and hide one of them according to the value in itemdatabound