Israel

Israel

  • 705
  • 1.3k
  • 216.4k

how to display my image on my picturebox with "search"

Oct 18 2014 8:40 AM
Hi!


I do search on the net how to display on the picturebox. I do find solution but it's wrote with others codes. What I need I want to follow the way I wrote my codes.
Please have a look and help me to correct these codee to display my picture from database please. Thanx:


string connectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\test1\test2\\app_data\office.mdb;Persist Security Info=False";
            OleDbConnection sqlCon = new OleDbConnection(connectionString);
            sqlCon.Open();
            string commandString = "select * from full_personal where nome ='" + txtName.Text + "'";
            OleDbCommand sqlCmd = new OleDbCommand(commandString, sqlCon);
            OleDbDataReader read = sqlCmd.ExecuteReader();

            if (read.HasRows)
            {
                while (read.Read())
                {
                    txtCod.Text = read["code"].ToString();
                    cbxNumberType.Text = read["number"].ToString();
                    picBxCadastFunc.Image = read["foto"].ToString();
           }
            read.Close();
            sqlCon.Close();
        }

Answers (12)