ASP.NET

Tina P wrote:

the question is having said that do i need
these square brackets around the Values in the query and also the place where i"m setting the value of the parameter

for (int i = 0; i < 11; i ++)
                        {
                            while ((line = sr.ReadLine()) != null)
                            {
                                string[] col = line.Split(',');

                                cmd.Parameters["@Name"].Value = col[i];
                                cmd.Parameters["@location"].Value = col[i + 1];
                                cmd.Parameters["@pincode"].Value = DateTime.Now.Date;
                                cmd.Parameters["@Date"].Value = col[i + 3];
.
.
.
.
                                cmd.Parameters["@eta"].Value = col[i + 10];


                                cmd.ExecuteNonQuery();
                            }
                        }

icecandy wrote:

question, I wasnt sure if I should post in here or in the visual basic forum so I apologize if this is the wrong place for this question.

<br />
   sGlitter = Request.Form("text")<br />
   imageString = ""<br />
<br />
   For Each Letter ltr in sGlitter<br />
      imageString = imageString & "<img src=http://www.icecandyeffects.com/glitter2/pink1/" & ltr & ".gif>"<br />
   End For<br />

GridView gv1 = new GridView();
        gv1.Width = 600;                
        gv1.DataSource = Table1;        
        gv1.DataBind();
             
        gv1.HeaderRow.Height = 50;
        gv1.HeaderRow.BackColor = System.Drawing.Color.Black;
        gv1.HeaderRow.ForeColor = System.Drawing.Color.White;
        gv1.RowStyle.Height = 100;

        GridView gv2 = new GridView();
        gv2.Width = 780;        
        gv2.DataSource = Table2;
        gv2.DataBind();
                
        switch (DateTime.Today.DayOfWeek.ToString())
        {
            case "Monday":
                gv2.Rows[0].Cells[0].BackColor = System.Drawing.Color.Aqua;
                break;
            case "Tuesday":
                gv2.Rows[0].Cells[1].BackColor = System.Drawing.Color.Aqua;
                break;
            case "Wednesday":
                gv2.Rows[0].Cells[2].BackColor = System.Drawing.Color.Aqua;
                break;
            case "Thursday":
                gv2.Rows[0].Cells[3].BackColor = System.Drawing.Color.Aqua;
                break;
            case "Friday":
                gv2.Rows[0].Cells[4].BackColor = System.Drawing.Color.Aqua;
                break;
        }
        
        gv2.HeaderRow.Height = 50;
        gv2.HeaderRow.BackColor = System.Drawing.Color.Black;
        gv2.HeaderRow.ForeColor = System.Drawing.Color.White;
        gv2.RowStyle.Height = 175;       

        GridView gv3 = new GridView();
        gv3.Width = 600;
        gv3.DataSource = Table3;
        gv3.DataBind();
        
        gv3.HeaderRow.Height = 50;
        gv3.HeaderRow.BackColor = System.Drawing.Color.Black;
        gv3.HeaderRow.ForeColor = System.Drawing.Color.White;
        gv3.RowStyle.Height = 100;        

        Panel1.Controls.Add(gv1);        
        Panel1.Controls.Add(gv2);
        Panel1.Controls.Add(gv3);