C#

obrix_activex wrote:

it passes the process..but did not passed thru error handler(catch)..it just loop and loop in the function

public void OnStart()
{
    timer1.Start() ;
}
 
public void OnStop()
{
    timer1.Stop() ;
}

this.sqlConnection1.Open();
               if (sqlCommand1.Parameters.Count == 0)
               {
                   this.sqlCommand1.CommandText = "INSERT INTO tblImgData(ID," +
                                  " Name,Picture) values(@ID,@Name,@Picture)";
                   this.sqlCommand1.Parameters.Add("@ID",
                                    System.Data.SqlDbType.Int, 4);
                   this.sqlCommand1.Parameters.Add("@Name",
                                    System.Data.SqlDbType.VarChar, 50);
                   this.sqlCommand1.Parameters.Add("@Picture",
                                    System.Data.SqlDbType.Image);
               }

               this.sqlCommand1.Parameters["@ID"].Value = this.editID.Text;
               this.sqlCommand1.Parameters["@Name"].Value = this.editName.Text;
               this.sqlCommand1.Parameters["@Picture"].Value = this.m_barrImg;

               int iresult = this.sqlCommand1.ExecuteNonQuery();
               MessageBox.Show(Convert.ToString(iresult));

this.sqlCommand1.Connection = this.sqlConnection1;