I am trying to insert datas from Excel into table, here i am checking for valiation which doesnot support will not be inserted but will return the error at last saying these rows is not inserted.
try
{
Param[0] = new SqlParameter("@ISBN", row[0].ToString().Trim().Replace("-", ""));
Param[1] = new SqlParameter("@Description", row[1].ToString().Trim());
Da.ExecuteNonQuery_SP("RAN2802201102_Catalog1_Insert", Param);
}
catch (Exception Ex)
{
ErrorISBN += row[0].ToString().Trim() + " ";
}
here waht are the isbn are not inserting in stores into ErrorISbn has an array and diaplays at last. some time this can got to hundreds so it is occupying the page ...... so now i need to display only the Total Count which was not inserted.........
...
Go to the complete details ...