Click here to Skip to main content
15,792,435 members
Home / Discussions / C#
   

C#

 
GeneralRe: Find and count duplicates in a list Pin
OriginalGriff24-Aug-20 6:39
mvaOriginalGriff24-Aug-20 6:39 
GeneralRe: Find and count duplicates in a list Pin
Acuena25-Aug-20 5:13
Acuena25-Aug-20 5:13 
GeneralRe: Find and count duplicates in a list Pin
OriginalGriff25-Aug-20 5:43
mvaOriginalGriff25-Aug-20 5:43 
AnswerRe: Find and count duplicates in a list Pin
Afzaal Ahmad Zeeshan20-Aug-20 5:37
professionalAfzaal Ahmad Zeeshan20-Aug-20 5:37 
AnswerRe: Find and count duplicates in a list Pin
BillWoodruff22-Aug-20 22:58
professionalBillWoodruff22-Aug-20 22:58 
QuestionPowerApps and C# Pin
Member 1127440117-Aug-20 7:08
Member 1127440117-Aug-20 7:08 
AnswerRe: PowerApps and C# Pin
Dave Kreskowiak17-Aug-20 8:42
mveDave Kreskowiak17-Aug-20 8:42 
QuestionBinding picture box with column with oracle Pin
mohammed alherwi15-Aug-20 0:26
mohammed alherwi15-Aug-20 0:26 
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"]];
}
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

Table emp 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.
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
AnswerRe: Binding picture box with column with oracle Pin
Eddy Vluggen22-Aug-20 11:11
professionalEddy Vluggen22-Aug-20 11:11 
QuestionHow to Read and Write to RFID(v9t557) as Human Interface Device C# Pin
Member 1177073713-Aug-20 15:10
Member 1177073713-Aug-20 15:10 
AnswerRe: How to Read and Write to RFID(v9t557) as Human Interface Device C# Pin
Dave Kreskowiak13-Aug-20 17:28
mveDave Kreskowiak13-Aug-20 17:28 
GeneralRe: How to Read and Write to RFID(v9t557) as Human Interface Device C# Pin
Member 1177073714-Aug-20 13:40
Member 1177073714-Aug-20 13:40 
GeneralRe: How to Read and Write to RFID(v9t557) as Human Interface Device C# Pin
Dave Kreskowiak14-Aug-20 14:16
mveDave Kreskowiak14-Aug-20 14:16 
GeneralRe: How to Read and Write to RFID(v9t557) as Human Interface Device C# Pin
Member 1177073714-Aug-20 14:28
Member 1177073714-Aug-20 14:28 
GeneralRe: How to Read and Write to RFID(v9t557) as Human Interface Device C# Pin
Dave Kreskowiak14-Aug-20 18:26
mveDave Kreskowiak14-Aug-20 18:26 
GeneralRe: How to Read and Write to RFID(v9t557) as Human Interface Device C# Pin
Member 1177073714-Aug-20 21:18
Member 1177073714-Aug-20 21:18 
GeneralRe: How to Read and Write to RFID(v9t557) as Human Interface Device C# Pin
Dave Kreskowiak15-Aug-20 5:03
mveDave Kreskowiak15-Aug-20 5:03 
GeneralRe: How to Read and Write to RFID(v9t557) as Human Interface Device C# Pin
OriginalGriff15-Aug-20 3:31
mvaOriginalGriff15-Aug-20 3:31 
QuestionHow to generate random decimal numbers in C# Pin
Sajo Nezic12-Aug-20 7:02
Sajo Nezic12-Aug-20 7:02 
AnswerRe: How to generate random decimal numbers in C# Pin
OriginalGriff12-Aug-20 7:09
mvaOriginalGriff12-Aug-20 7:09 
AnswerRe: How to generate random decimal numbers in C# Pin
Luc Pattyn12-Aug-20 11:15
sitebuilderLuc Pattyn12-Aug-20 11:15 
AnswerRe: How to generate random decimal numbers in C# Pin
Eddy Vluggen13-Aug-20 13:07
professionalEddy Vluggen13-Aug-20 13:07 
AnswerRe: How to generate random decimal numbers in C# Pin
Patrice T14-Aug-20 23:33
mvePatrice T14-Aug-20 23:33 
AnswerRe: How to generate random decimal numbers in C# Pin
BillWoodruff19-Aug-20 2:31
professionalBillWoodruff19-Aug-20 2:31 
GeneralRe: How to generate random decimal numbers in C# Pin
jsc4219-Aug-20 7:41
professionaljsc4219-Aug-20 7:41 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.