insert into mytable values('011,874000,275581',1)
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(); } } }
Ꞌ
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)