Parameter problem with arrays

I'm using arrays in a web application i'm building and it's been a whole day that i can't work this out. Specifically, i am trying to call a method that i created " public static int ExecuteNonQuery (string proc, SqlParameter [] param) " So in the page that i'm calling it, i'm also declaring the array of SqlParameter like this: SqlParameter[] param = new SqlParameter[4]; --> param[0] = {"@sname", SqlDbType.NVarChar, 30}; param[0].Value = this.TextBox3.Text; --> param[1] = {"@saddr", SqlDbType.NVarChar, 60}; param[1].Value = this.TextBox4.Text; --> param[2] = {"@sparentphone", SqlDbType.NVarChar, 24}; param[2].Value = this.TextBox5.Text; --> param[3] = {"@sparentemail", SqlDbType.NVarChar, 40}; param[3].Value = this.TextBox6.Text; --> param[4] = {"@sdob", SqlDbType.NVarChar, 10}; param[4].Value = this.TextBox7.Text; But when i run it i get errors on the lines above pointed by the errors. Errors like " ; expected" and others syntactical ones. What is wrong with my syntax? Have you got any suggestions?

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

sailorfoley22y ago
hey, where you getting the errors you need to one of following examples: param[0] = new SqlParameter("@sname",SqlDbType.NVarChar,30) or param[0].SqlDbType = SqlDbType.NVarchar etc. for every property you wish to set. Your array is initialised to already have 4 SqlParameter objects so i would suggest to use the second method here. Hope this helps, sailorfoley