ASP.NET

rameez Raja wrote:

is there any availble class in .net for generating random password?

Id, Info, Date<br />
1, Some text, 2008-12-14<br />
2, "Some text,<br />
containing commas,<br />
and line breaks.", 2008-12-15<br />
3, "More text, mind you.", 2008-12-16

for (int i = 10; i < col.Length; i += 5) {
   ' here col[i], col[i+1] ... col[i+4] contains the five values.
}

Guffa wrote:

here col[i], col[i+1] ... col[i+4] contains the five values

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