C#

SqlConnection con1 = new SqlConnection("DATA SOURCE = MAX_TOSHIBA ;Initial Catalog= nodule ; Integrated security = True");
            SqlDataAdapter adp1 = new SqlDataAdapter();
            SqlCommand com1 = new SqlCommand("SELECT the_pic FROM pic where  pic_id='" + chos_pic_id.ToString() + "' and pic_no='" + chos_pic_no.ToString() + "'",con1);
            adp1.SelectCommand = com1;
            DataTable t__1 = new DataTable();
            adp1.Fill(t__1);
            byte[] by_ = (byte[])t__1.Rows[0][0];
            FileStream FS1 = new FileStream("image.jpg", FileMode.Create);
            FS1.Write(by_, 0, by_.Length);
            
            FS1.Flush();            
            FS1.Close();
            
            pictureBox1.Image = Image.FromFile("image.jpg");

public static void DeletePerson ( string guid )
{
   SqlCommand SqlCmd.CommandText ="DELETE FROM persons WHERE guid = @guid";
SqlCmd.Parameters.AddWithValue ("@guid" , guid);
SqlCmd.ExecuteNonQuery();
SqlCmd.Parameters.Clear();
}

TxtPerson.Text = clsDataTable.Rows[CurrentRecored]["Name"].ToString();

TxtPerson.DataBindings.Add("Text" , bindingsource , "name" );

SELECT MAX(PersonID) FROM persons

public string[] SearchUserNames = { "Name"  , "Age" };  // Added to combobox
public string[] SearchDBNames =   { "pName" , "pAge"};


stQuery = "SELECT * FROM persons";
int isAnd = 0;

if (CheckName.Checked)
    {
        stQuery += " WHERE " + SearchDBNames[combobox.SelectedIndex].ToString();
        isAnd++;
    }
    if (CheckAge.Checked)
    {
        if (isAnd != 0)
        {
            stQuery += " AND ";
        }
         else
        {
            stQuery += " WHERE ";
        }
        stQuery += SearchDBNames[combobox.SelectedIndex].ToString();
        isAnd++;

    }