Insert comma(,) in database through insert query in C#

Dear Supriya,

This link might help you out with your confusion and treat the comma value as string in order to insert it into the SQL Data field.

http://forums.asp.net/t/960972.aspx/1[^]

I hope this will help you out.

Thanks

Try this

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using System.Data.SqlTypes;
using System.Data.Sql;


namespace ConsoleApplication1
{
    class Program
    {
        static void Main(string[] args)
        {

            SqlConnection con = new SqlConnection("user id=sa;" +
                                       "password=sa@123;server=10.2.30.20;" +
                                       "Trusted_Connection=yes;" +
                                       "database=DBName; " +
                                       "connection timeout=30");

            string CSVString = "English,Marathi,Hindi";

            string query = "INSERT INTO LangKnown SELECT 1 ,'" + CSVString + "'";
            SqlCommand cmd = new SqlCommand(query, con);
            con.Open();
            cmd.ExecuteNonQuery();
            con.Close();
            
        }
    }
}

in windows character map
font Consolas
use char U+201A and its look like comma . and inserted in sql database by query

Ꞌ