C#

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;

JollyMansArt wrote:

1)How to create a XML file that stores the connection string
2)How to refer to that XML file to use the connection string in the application.