- con = new OleDbConnection("provider=oraoledb.oracle.1;user id=scott;password=tiger");
- daEmp = new OleDbDataAdapter("select * from emp", con);
- daDept = new OleDbDataAdapter("select * from dept", con);
- //----------------------------
- ds = new DataSet();
- //---------------------------------------
- daEmp.Fill(ds, "emp");
- dataGridView1.DataSource = ds.Tables["emp"];
- //-------------------------------------------
- daDept.Fill(ds, "dept");
- cmbDname.DataSource = ds.Tables["dept"];
- cmbDname.DisplayMember = "dname";
- cmbDname.ValueMember = "deptno";
- //-------------------------------------------------
- pictureBox1.DataBindings.Add("Image", ds.Tables["emp"], "photo2", true, DataSourceUpdateMode.OnPropertyChanged);
- txtEmpno.DataBindings.Add("text", ds.Tables["emp"], "empno");
- txtEname.DataBindings.Add("text", ds.Tables["emp"], "ename");
- txtSal.DataBindings.Add("text", ds.Tables["emp"], "sal");
- cmbDname.DataBindings.Add("selectedvalue", ds.Tables["emp"], "deptno");
- dtpHireDate.DataBindings.Add("text", ds.Tables["emp"], "hiredate");
- txtJob.DataBindings.Add("text", ds.Tables["emp"], "job");
- OleDbCommandBuilder cmb = new OleDbCommandBuilder(daEmp);
- bmb = this.BindingContext[ds.Tables["emp"]];
- }
Binding picture box with column with oracle
Im using the above code to insert picture of employee but when i Try to save it using
- bmb.EndCurrentEdit();
- daEmp.Update(ds.Tables["emp"]);
Im getting an error Dynamic SQL generation for the UpdateCommand is not supported against a SelectCommand that does not return any key column information.
I have tried to change the data type in Oracle from blob to long raw but Im getting the same issue.
Could u plz let me know what is the error
mohammed alherwiPosted Aug 15, 2020, 4:19 AM
In Sql server I have tried same table and same column it is working.
In sql server I declare the column of employee photo as image data type.
But in oracle I have tried Long raw and blob data type it is not working
mohammed alherwiPosted Aug 15, 2020, 4:17 AM
It is already having primary key.
The problem occur only when the line binding of picturebox is ther.
If i committed the line of picturebox no error the record will be saved.
Navaneeth KrishnanPosted Aug 14, 2020, 11:42 PM