<div>
Your post helped me to do the task much faster.Anyway i did this in c#, not VB.
</div>


Your post helped me to do the task much faster.Anyway i did this in c#, not VB.

<div>
<div class="content wysiwyg-content">
hi,<br />
<br />
&nbsp; &nbsp; I have a datagrid with about 10 columns in it.Now i want to import the values in excel file to datagrid.<br />
<br />
scenario :<br />
<br />
1-----There are only 5 columns in excel.So i want to match the column names for excel and datagrid for populating the same column values in datagrid.<br />
2-----I have a session value session[&quot;RiskID&quot;]. I want to check this value against all the values in first column&quot;RiskId&quot; in excel. If any one value in the column dosen't match, then it shud not import to datagrid.Instead it shud prompt a message to user.<br />
3-----I have a column called &quot;SI&quot; in excel. I want to check all the values in this column. If any one value in the column has &quot;0&quot;, then it shud not import to datagrid.Instead it shud prompt a message to user.<br />
4-----If any values in excel has values like &quot;&nbsp;Microsoft's &quot;&nbsp;with an apostaphe, it shud not be a problem in importing the values to datagrid.<br />
<br />
Please help me on this. Thanks. Its very Urgent
</div>
</div>


hi,

    I have a datagrid with about 10 columns in it.Now i want to import the values in excel file to datagrid.

scenario :

1-----There are only 5 columns in excel.So i want to match the column names for excel and datagrid for populating the same column values in datagrid.
2-----I have a session value session["RiskID"]. I want to check this value against all the values in first column"RiskId" in excel. If any one value in the column dosen't match, then it shud not import to datagrid.Instead it shud prompt a message to user.
3-----I have a column called "SI" in excel. I want to check all the values in this column. If any one value in the column has "0", then it shud not import to datagrid.Instead it shud prompt a message to user.
4-----If any values in excel has values like " Microsoft's " with an apostaphe, it shud not be a problem in importing the values to datagrid.

Please help me on this. Thanks. Its very Urgent

Import from Excel to datagrid using c#.-- URGENT.

C# is an object-oriented programming language created in conjunction with Microsoft’s .NET framework. Compilation is usually done into the Microsoft Intermediate Language (MSIL), which is then JIT-compiled to native code (and cached) during execution in the Common Language Runtime (CLR).

The successor to Active Server Pages, ASP.NET websites utilize the .NET framework to produce dynamic, data and content-driven web applications and services. ASP.NET code can be written using any .NET supported language. As of 2009, ASP.NET can also apply the Model-View-Controller (MVC) pattern to web applications