在C#中sql插入数据

 

//数据库连接字符串        
        //private static string source = @"Data Source = PCseverName;DataBase=sqlName;User ID=severName;Pwd=123456;";   //用server用户名登录
        private static string source = "server = PCName;" + "integrated security=SSPI;" + "database =sqlName ";  //用windows用户名登录
        //private static string source = "server = (loacl);" + "integrated security=SSPI;" + "database =sqlName ";  //用windows用户名登录

        //数据库连接对象
        public static SqlConnection connection = new SqlConnection(source);

 public void SqlIPInsert()
        {         
            string insertCommand = "insert into IP(ID,IP,Rack,Solt)  values(1,'192.168.1.78', 2, 3)";//sql插入数据       
            string sql = "select ID,IP,Rack,Solt  from IP ";
            using (SqlCom