<div>
Hi, 
 
In which line it is throwing error?
</div>

<div>
Hi, 
 
I think you are trying to add data to the table column 30 which is not there. 
 
Table is not having the 30 columns.
</div>

<div>
Hi Guys , 
 
Line No 139 Throwing Error as &nbsp; tblcsv.Rows[tblcsv.Rows.Count - 1][count] = FileRec; 
 
and below is c# code 
 

<pre><code class="code-100 nolinks" id="code-20-41450646-1">using System;
using System.IO;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;


public partial class Import : System.Web.UI.Page
{
 SqlConnection con;

 string sqlconn;
 protected void Page_Load(object sender, EventArgs e)
 {

 }

 protected void Button1_Click(object sender, EventArgs e)
 {

 }

 protected void Button2_Click(object sender, EventArgs e)
 {

 }
 

 private void connection()
 {
 sqlconn = ConfigurationManager.ConnectionStrings[&quot;con&quot;].ConnectionString;
 con = new SqlConnection(sqlconn);

 }
 //Function to Insert Records 
 private void InsertCSVRecords(DataTable csvdt)
 {

 connection();
 //creating object of SqlBulkCopy 
 SqlBulkCopy objbulk = new SqlBulkCopy(con);
 //assigning Destination table name 
 objbulk.DestinationTableName = &quot;Company&quot;;


 //Mapping Table column 
 objbulk.ColumnMappings.Add(&quot;CompanyId&quot;, &quot;CompanyId&quot;);
 objbulk.ColumnMappings.Add(&quot;agent_id&quot;, &quot;agent_id&quot;);
 objbulk.ColumnMappings.Add(&quot;CompanyOwner&quot;,&quot;CompanyOwner&quot;);
 objbulk.ColumnMappings.Add(&quot;CompanyOwnerId&quot;, &quot;CompanyOwnerId&quot;);
 objbulk.ColumnMappings.Add(&quot;CompanyName&quot;, &quot;CompanyName&quot;);
 objbulk.ColumnMappings.Add(&quot;CreatedBy&quot;, &quot;CreatedBy&quot;);
 objbulk.ColumnMappings.Add(&quot;CreatedById&quot;, &quot;CreatedById&quot;);
 objbulk.ColumnMappings.Add(&quot;ModifiedBy&quot;, &quot;ModifiedBy&quot;);
 objbulk.ColumnMappings.Add(&quot;ModifiedById&quot;, &quot;ModifiedById&quot;);
 objbulk.ColumnMappings.Add(&quot;CreatedTime&quot;, &quot;CreatedTime&quot;);
 objbulk.ColumnMappings.Add(&quot;ModifiedTime&quot;, &quot;ModifiedTime&quot;);
 objbulk.ColumnMappings.Add(&quot;LastActivityTime&quot;, &quot;ModifiedTime&quot;);
 objbulk.ColumnMappings.Add(&quot;Territories&quot;, &quot;ModifiedTime&quot;);
 objbulk.ColumnMappings.Add(&quot;ACNNumber&quot;, &quot;ACNNumber&quot;);
 objbulk.ColumnMappings.Add(&quot;ABNNumber&quot;, &quot;ABNNumber&quot;);
 objbulk.ColumnMappings.Add(&quot;TrusteeInformation&quot;, &quot;TrusteeInformation&quot;);
 objbulk.ColumnMappings.Add(&quot;RegistrationDate&quot;, &quot;RegistrationDate&quot;);
 objbulk.ColumnMappings.Add(&quot;ASIC&quot;, &quot;ASIC&quot;);
 objbulk.ColumnMappings.Add(&quot;Status&quot;, &quot;Status&quot;);
 objbulk.ColumnMappings.Add(&quot;ClientType&quot;, &quot;ClientType&quot;);
 objbulk.ColumnMappings.Add(&quot;LastContacted&quot;, &quot;LastContacted&quot;);
 objbulk.ColumnMappings.Add(&quot;OrganizationType&quot;, &quot;OrganizationType&quot;);
 objbulk.ColumnMappings.Add(&quot;Agent&quot;, &quot;Agent&quot;);
 objbulk.ColumnMappings.Add(&quot;Address&quot;, &quot;Address&quot;);
 objbulk.ColumnMappings.Add(&quot;City&quot;, &quot;City&quot;);
 objbulk.ColumnMappings.Add(&quot;Province&quot;, &quot;Province&quot;);
 objbulk.ColumnMappings.Add(&quot;PostalCode&quot;, &quot;PostalCode&quot;);
 objbulk.ColumnMappings.Add(&quot;Note&quot;, &quot;Note&quot;);
 objbulk.ColumnMappings.Add(&quot;TenancyAddress&quot;, &quot;TenancyAddress&quot;);
 objbulk.ColumnMappings.Add(&quot;SQLID&quot;, &quot;SQLID&quot;);
 //inserting Datatable Records to DataBase 
 con.Open();
 objbulk.WriteToServer(csvdt);
 con.Close();


 }

 protected void UploadButton_Click(object sender, EventArgs e)
 {
 //Creating object of datatable 
 DataTable tblcsv = new DataTable();
 //creating columns 
 tblcsv.Columns.Add(&quot;CompanyId&quot;);
 tblcsv.Columns.Add(&quot;agent_id&quot;);
 tblcsv.Columns.Add(&quot;CompanyOwner&quot;);
 tblcsv.Columns.Add(&quot;CompanyOwnerId&quot;);
 tblcsv.Columns.Add(&quot;CompanyName&quot;);
 tblcsv.Columns.Add(&quot;CreatedBy&quot;);
 tblcsv.Columns.Add(&quot;CreatedById&quot;);
 tblcsv.Columns.Add(&quot;ModifiedBy&quot;);
 tblcsv.Columns.Add(&quot;ModifiedById&quot;);
 tblcsv.Columns.Add(&quot;CreatedTime&quot;);
 tblcsv.Columns.Add(&quot;ModifiedTime&quot;);
 tblcsv.Columns.Add(&quot;LastActivityTime&quot;);
 tblcsv.Columns.Add(&quot;Territories&quot;);
 tblcsv.Columns.Add(&quot;ACNNumber&quot;);
 tblcsv.Columns.Add(&quot;ABNNumber&quot;);
 tblcsv.Columns.Add(&quot;TrusteeInformation&quot;);
 tblcsv.Columns.Add(&quot;RegistrationDate&quot;);
 tblcsv.Columns.Add(&quot;ASIC&quot;);
 tblcsv.Columns.Add(&quot;Status&quot;);
 tblcsv.Columns.Add(&quot;ClientType&quot;);
 tblcsv.Columns.Add(&quot;LastContacted&quot;);
 tblcsv.Columns.Add(&quot;OrganizationType&quot;);
 tblcsv.Columns.Add(&quot;Agent&quot;);
 tblcsv.Columns.Add(&quot;Address&quot;);
 tblcsv.Columns.Add(&quot;City&quot;);
 tblcsv.Columns.Add(&quot;Province&quot;);
 tblcsv.Columns.Add(&quot;PostalCode&quot;);
 tblcsv.Columns.Add(&quot;Note&quot;);
 tblcsv.Columns.Add(&quot;TenancyAddress&quot;);
 tblcsv.Columns.Add(&quot;SQLID&quot;);

 //getting full file path of Uploaded file 
 System.IO.StreamReader stream = new System.IO.StreamReader(FileUploadControl.PostedFile.InputStream);

 //string CSVFilePath = Path.GetFullPath(FileUploadControl.PostedFile.FileName);

 //Reading All text 
 string ReadCSV = stream.ReadToEnd();
 //string ReadCSV = File.ReadAllText(CSVFilePath);
 //spliting row after new line 
 foreach (string csvRow in ReadCSV.Split('\n'))
 {
 if (!string.IsNullOrEmpty(csvRow))
 {
 //Adding each row into datatable 
 tblcsv.Rows.Add();
 int count = 0;
 foreach (string FileRec in csvRow.Split(','))
 {
 tblcsv.Rows[tblcsv.Rows.Count - 1][count] = FileRec;
 count++;
 }
 }


 }
 //Calling insert Functions 
 InsertCSVRecords(tblcsv);

 }
}
</code></pre>
</div>

<div>
Hi, 
 
In datatable you have 30 columns and which is 0 based index. 
 
I think from the CSV split string contains more than 30 values with comma separated. 
 
So you are getting the error. 
 
Check the count here before loop. 
 
int valuesCount = csvRow.Split(',').Count(); // it will be more than the columns in datatable
</div>

<div>
Hi Lokesh , 
 
your are correct lokesh i have 30 columns in my database . is my csv file is wrong
</div>

<div>
Thanks prabhu rajendran &nbsp;ill &nbsp; check it now
</div>

<div>
am using a new csv file its still remains same error 
<a href="https://filedb.experts-exchange.com/incoming/2016/02_w06/1079750/a---Copy.csv" target="_blank" class="file-inline" title="a---Copy.csv (304 KB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>a---Copy.csv</a>
</div>

a---Copy.csv

<div>
Hi Lokesh 
 
Now its reporting as 
<blockquote>
System.InvalidOperationException: The given ColumnMapping does not match up with any column in the source or destination.
</blockquote>
</div>

<div>
Though it's of course best practice to check for column counts as suggested above, the actual problem is much simpler, and pretty common. 
 
You have an extra line break in your file. 
The last &quot;row&quot; in the file is blank, so will have length = 0 when you try to split on it. 
Remove that extra line break and it will work properly.
</div>

<div>
Hi, 
 
Debug and let me know where you are getting this.
</div>

<div>
Hey Friends I think i missed out a mapping in a column .When i corrected its works Great . Thanks Experts for tremendous Effort
</div>

<div>
<div class="content wysiwyg-content">
Hi , 
 
Am Trying to Upload CSV to my server but it keep on showing Error as 
<blockquote>
System.IndexOutOfRangeException: Cannot find column 30.
</blockquote>
 but my csv has 31 comma seperated values in it . Any Suggestions Experts 
<a href="https://filedb.experts-exchange.com/incoming/2016/02_w06/1079736/a---Copy.csv" target="_blank" class="file-inline" title="a---Copy.csv (1 KB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>a---Copy.csv</a>
</div>
</div>

Hi ,

Am Trying to Upload CSV to my server but it keep on showing Error as System.IndexOutOfRangeException: Cannot find column 30. but my csv has 31 comma seperated values in it . Any Suggestions Experts

ASP.Net Error-System.IndexOutOfRangeException: Cannot find column 30.

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

ASP.NET

The .NET Framework is not specific to any one programming language; rather, it includes a library of functions that allows developers to rapidly build applications. Several supported languages include C#, VB.NET, C++ or ASP.NET.

.NET Programming

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).

Web development includes all aspects of presenting content on intranets and the Internet, including delivery development, protocols, languages and standards, server software, browser clients, databases and multimedia generation.