Remove HTML Tages from Datatable In C# First Create This Function. Public string RemoveHTMLTags( string source) { return Regex .Replace(source, "<.*?>", string .Empty); } And Then use like this ---------------------------- // Data Stored in DataTable if (dt.Rows.Count > 0) { string strterm = Convert .ToString(dt.Rows[0]["term"].ToString()); strterm = RemoveHTMLTags(strterm); } else { }
Popular posts from this blog
Change database schema name using mssql
Question : ============================================ I have this schema : [hhh].[spemployee] and what to change schema like this : [eee].[ spemployee ] ============================================ Answer : ============================================= First Create below IF (NOT EXISTS (SELECT * FROM sys.schemas WHERE name = 'eee')) BEGIN EXEC ('CREATE SCHEMA [eee] AUTHORIZATION [dbo]') END Then user ALTER to change schema name ALTER SCHEMA [ eee ] TRANSFER [hhh].[ spemployee ] ============================================= ===================================================== and Result as below : [eee].[ spemployee ] =====================================================
Calculate Mortgage in c# using console application
Formula : M = P [ i(1 + i)^n ] / [ (1 + i)^n – 1] M = monthly mortgage payment P = the principal, or the initial amount you borrowed. i = your monthly interest rate. Your lender likely lists interest rates as an annual figure, so you’ll need to divide by 12, for each month of the year. So, if your rate is 5%, then the monthly rate will look like this: 0.05/12 = 0.004167. n = the number of payments, or the payment period in months. If you take out a 30-year fixed rate mortgage, this means: n = 30 years x 12 months per year, or 360 payments. ___________________________________ Start Code _________________________________ using System; using System.Collections.Generic; using System.Linq; using System.Text; namespace Oops_Concepts { class Program { static void Main(string[] args) { Program objProgram = new Program(); ...
Comments
Post a Comment