ASP.NET

Tina P wrote:

I guess I can see that you are using i+=5 instead of i++ because I told you that there might be 5 column headers and then the data would be repeated after every 5 values? Is that why you have increments of 5?

Tina P wrote:

well even if we use i based syntax instead of actual numbers...we are still doing it manually...in other words I'd still have to provide values (@Col,@Col2,@Col3,@Col4,@Col5)"; myself, which incase of tens of thousands of line, may not be practical!

SqlConnection conn = new SqlConnection("blah blah");

                        string query = "insert into ClientTable ([" + col[5] + "],[" + col[6] + "],[" + col[7] + "],[" + col[8] + "],[" + col[9] + "]) values (@Name,@Address,@Phone,@SecurityLevel,@Coverage)";
                        SqlCommand cmd = new SqlCommand(query, conn);

                        SqlParameter param = new SqlParameter();
                        param.ParameterName = "@Name";
                        param.ParameterName = "@Address";
                        param.ParameterName = "@Phone";
                        param.ParameterName = "@SecurityLevel";
                        param.ParameterName = "@Coverage";



                       for (int i = 10; i < col.Length; i += 5) 
                       {
                           param.Value = col[i];
                           param.Value = col[i+1];
                           param.Value = col[i+2];
                           param.Value = col[i+3];
                           param.Value = col[i+4];

                           cmd.Parameters.Add(param);

                           cmd.ExecuteReader();

                       }      

SqlConnection conn = new SqlConnection("blah blah");

string query = "insert into ClientTable ([" + col[5] + "],[" + col[6] + "],[" + col[7] + "],[" + col[8] + "],[" + col[9] + "]) values (@Name,@Address,@Phone,@SecurityLevel,@Coverage)";
SqlCommand cmd = new SqlCommand(query, conn);

SqlParameter parameterName = new SqlParameter("@Name", SqlDbType.VarChar, 100);
SqlParameter parameterAddress = new SqlParameter("@Address", SqlDbType.VarChar, 100);
SqlParameter parameterPhone = new SqlParameter("@Phone", SqlDbType.VarChar, 50);
SqlParameter parameterSecurity = new SqlParameter("@SecurityLevel", SqlDbType.VarChar, 50);
SqlParameter parameterCoverage = new SqlParameter("@Coverage", SqlDbType.VarChar, 50);
cmd.Parameters.Add(parameterName);
cmd.Parameters.Add(parameterAddress);
cmd.Parameters.Add(parameterPhone);
cmd.Parameters.Add(parameterSecurity);
cmd.Parameters.Add(parameterCoverage);

cmd.Prepare();

for (int i = 10; i < col.Length; i += 5) {
   parameterName.Value = col[i];
   parameterAddress.Value = col[i+1];
   parameterPhone.Value = col[i+2];
   parameterSecurity.Value = col[i+3];
   parameterCoverage.Value = col[i+4];
   cmd.ExecuteNonQuery();
}

cmd.Parameters.Add("@DATE", SqlDbType.DateTime);

for (int i = 0; i < col.Length; i += 11)
{
     cmd.Parameters["@DOW"].Value = col[i+1];
     etc.
     cmd.ExecuteNonQuery();

}

cmd.Parameters.Add("@[SERVICE CENTER]", SqlDbType.NVarChar, 50);

cmd.Parameters["@[Description]"].Value = col[i+2];

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);