you have 3 parameters in your stored procedure, need to set all the parameter values.
when artist login to system you can get the artistId from the database and keep that value.
cmd.Parameters.AddWithValue("@name",txtname.Text);
cmd.Parameters.AddWithValue("@category",ddlcategory.SelectedValue);
cmd.Parameters.AddWithValue("@artistId",artistId);