Re: Problemer med å eksekvere en sqlkommando [
Besvar ]
Av: Stian SandbergBare for å gjøre koden din litt ryddiger/bedre:
SqlCommand cmd = new SqlCommand("INSERT INTO EleverFag (elevID, fagID) VALUES (@elevID,@fagID)", myConnection);;
foreach (ListItem chklstItem in chkelever.Items)
{
cmd.Parameters.Clear();
cmd.Parameters.Add("@elevID", chklstItem.Value);
cmd.Parameters.Add("@fagID", lstFellesfag.SelectedItem.Value);
cmd.ExecuteNonQuery();
}
cmd.Dispose();
Grunnen til at du får den feilen du beskriver kan være en av følgende:
- the user you are connecting as does not have SELECT, UPDATE, INSERT, DELETE, EXEC permissions on the object;
- you aren't logging in / connecting as the user you expect;
- you are referencing the object without an owner name prefix (or with the wrong owner name);
- you are connected to the wrong database;
- you are, in fact, spelling the object's name incorrectly.
Stian
<a href="http://serverside.no/">http://serverside.no/</a>
