Validation to Check Duplicate Records

Prevent from inserting duplicate records into the table You need to check if a duplicate entry exists in table before inserting the data. I suggest you could refer to the solution given below: Approach 1=> using (SqlConnection conn = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["DefaultCSRConnection"].ConnectionString)) { //Open your connection conn.Open(); //Your Select Query ...

Read More »

Converting String in to CSV files in C Sharp

Function For Creating CSV files in C# public static string FormatCSV(string input)     {         try         {             if (input == null)                 return string.Empty;             bool containsQuote = false;             bool containsComma = false;            ...

Read More »