0
 'public void OnPost()
        {
            DateTime dt = DateTime.Parse("2022-10-22");
            execProc(newDate.Name, newDate.Age, dt);
            
        }
    
    
    
        public void execProc(string name,int age,DateTime birthDate)
        {
            SqlConnection connsql = new SqlConnection("Data Source= conn");
            SqlCommand cmd = new SqlCommand($"exec insertInfo {name},{age},{birthDate}",connsql);
            connsql.Open();
            cmd.ExecuteNonQuery();
            connsql.Close();
        }'

Error when pass data to procedure : Microsoft.Data.SqlClient.SqlException: 'Incorrect syntax near ','.'

0 Answers0