public string[] 1

[jamert]

Hi i'm wondering 2 things
[1]
can one loop thru a public string array (aller)

if (aller[0].ToString() != Request.Form["aller0"].ToString()) { cmd.Parameters.Add("@aller0", SqlDbType.NVarChar).Value = Request.Form["aller0"].ToString(); }

if (aller[1].ToString() != Request.Form["aller1"].ToString()) { cmd.Parameters.Add("@aller1", SqlDbType.NVarChar).Value = Request.Form["aller1"].ToString(); }

if (aller[2].ToString() != Request.Form["aller2"].ToString()) {
....


something like ?:

for (int i = 0; i <= 26; i++)
{

if (aller.ToString() != Request.Form["aller"].ToString()) { cmd.Parameters.Add("@aller", SqlDbType.NVarChar).Value = Request.Form["aller"].ToString()); }

}

[2]
ALSO can using the SqlDataReader rdr be used with the public array something like,

aller = (string)rdr1["aller"];

Thanks again

 

[misterstick]

for (int i = 0; i <= 26; i++)
{
 string column = string.Format("aller{0}", i);
 if (aller[i].ToString() != Request.Form[[b]column[/b]].ToString()) 
 { 
  cmd.Parameters.Add("@" + [b]column[/b], SqlDbType.NVarChar).Value = Request.Form[[b]column[/b]].ToString()); 
 }
}

untested, ymmv.


mr s. <

 

[jamert]

Thanks misterstick will try it.

Any thoughts on reusing the SqlDataReader "rdr" in a loop something like:

for (int i = 0; i <= 26; i++)
{
string column = string.Format(rdr1["aller{0}"], i);

if (column.Length>0)
{
aller = column;
}

}

Thanks

 

[misterstick]

that assigns the name of a column as its value.

or

aller[1] = "aller1";

is that what you want?

mr s. <