How to check the reqired parameters and the add those parameter to sql command
i have sql command string
string sql_command = select * from table where name = @name and id = @id and value = @value
now i want to identify which parameter to add in sql command like
for (int i = 0; i < parameterNames.Length; i++)
{
cmd.Parameters.Add("@name");
}
parameterNames???