C#

SqlCommand cmd = new SqlCommand("INSERT INTO EACS_User_1 " +
                                "(firstName, lastName) " +
                                "VALUES " +
                                "(" + uf_FirstName + "," + uf_LastName + ")");

SqlCommand cmd = new SqlCommand("INSERT INTO EACS_User_1 " +
                                "(firstName, lastName) " +
                                "VALUES " +
                                "(@FN, @LN)");
cmd.Parameters.AddWithValue("@FN", uf_FirstName);
cmd.Parameters.AddWithValue("@LN", uf_LastName);

<<thashif>> wrote:

Actually i only find cmd.parameters.add i mean i dont get addwithvalue... should i include anything??? is it because i am using VS2003

cmd.Parameters.Add("@FN", System.Data.SqlDbType.VarChar).Value = uf_LastName;

for (int i = 0; i < dataGridView1.Rows.Count; i++)
              {
                  dataGridView1.BackgroundColor = Color.Red;
                  if (i % 2 == 0)
                  {
                      dataGridView1.BackgroundColor = Color.Blue;
                  }
              }

private void dataGridView1_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
     {
         for (int i = 0; i < dataGridView1.Columns.Count; i++)
         {
             e.CellStyle.BackColor = Color.Red;
             if (i % 2 == 0)
             {
                 e.CellStyle.BackColor = Color.Blue;
             }
         }
     }