public static void TableValuedToDB(DataTable dt, string storedProcName, string TypeName)

        {

            using (SqlConnection connection = DBConnectionFactory.newConnection(connectionString))

            {

                if (connection.State != ConnectionState.Open)

                {

                    connection.Open();

                }

                try

                {

                    if (dt != null && dt.Rows.Count != )

                    {

                        SqlCommand cmd = new SqlCommand(storedProcName, connection);

                        cmd.CommandType = CommandType.StoredProcedure;

                        SqlParameter tvpParam = cmd.Parameters.AddWithValue(TypeName, dt);

                        tvpParam.SqlDbType = SqlDbType.Structured;

                        // Execute the command.

                        cmd.ExecuteNonQuery();

                    }

                }

                catch (Exception ex)

                {

                    throw ex;

                }

                finally

                {

                    DisposeConnection(connection);

                }

            }

        }