Upoload CSV file in GridView

write dt.Acceptchanges();

after adding row in dt

Hello sir ,
i try it but in dt it shows only header row and data is come in to dt

debug your code and check whether dt has values or not

Hello sir,
I already try this but give error:

Input string was not in a correct format.

My DB Table structure is like

UserName varchar(50),
Email varchar(50),
Mobile int

Hello sir,
  In my CSV file contain 3 column UserName,Email,Mobile

    protected void btn_Add_Click(object sender, EventArgs e)
    {
        DataTable dt = new DataTable();
        dt.Columns.AddRange(new DataColumn[3]
        { new DataColumn("UserName", typeof(string)),
                        new DataColumn("Email", typeof(string)),
                        new DataColumn("Mobile",typeof(int))
                      
        });
        foreach (GridViewRow row in gridview1.Rows)
        {
           
                string UserName = row.Cells[1].Text;
                string Email = row.Cells[2].Text;
                int Mobile = int.Parse(row.Cells[3].Text);
                dt.Rows.Add(UserName, Email, Mobile);
           
        }
        if (dt.Rows.Count > 0)
        {
            string consString = ConfigurationManager.ConnectionStrings["connectionstring"].ConnectionString;

            using (SqlConnection con = new SqlConnection(consString))
            {
                using (SqlBulkCopy sqlBulkCopy = new SqlBulkCopy(con))
                {
                    //Set the database table name
                    sqlBulkCopy.DestinationTableName = "dbo.CSV";

                    //[OPTIONAL]: Map the DataTable columns with that of the database table
                    sqlBulkCopy.ColumnMappings.Add("UserName", "UserName");
                    sqlBulkCopy.ColumnMappings.Add("Email", "Email");
                    sqlBulkCopy.ColumnMappings.Add("Mobile", "Mobile");
                    con.Open();
                    sqlBulkCopy.WriteToServer(dt);
                    con.Close();
                }
            }
        }
    }

plz share your code.
you have to match the columns in csv and database

Hello sir,I try it but i got error:

Specified argument was out of the range of valid values.

I try to solve it but not get any solution..

If you have inserted csv data to gridview then use bulk insert to sql
or insert each row to sql db

http://www.aspsnippets.com/Articles/Using-SqlBulkCopy-to-insert-bulk-data-from-GridView-to-database-in-ASPNet.aspx

http://www.c-sharpcorner.com/UploadFile/0c1bb2/insert-bulk-records-into-database-using-Asp-Net-C-Sharp/

http://aspforums.net/Threads/155716/Bulk-Insert-Data-from-GridView-Rows-into-Database-in-ASPNet/