Click here to Skip to main content
15,888,013 members
Home / Discussions / C#
   

C#

 
GeneralRe: Find and count duplicates in a list Pin
OriginalGriff24-Aug-20 5:39
mveOriginalGriff24-Aug-20 5:39 
GeneralRe: Find and count duplicates in a list Pin
Acuena25-Aug-20 4:13
Acuena25-Aug-20 4:13 
GeneralRe: Find and count duplicates in a list Pin
OriginalGriff25-Aug-20 4:43
mveOriginalGriff25-Aug-20 4:43 
AnswerRe: Find and count duplicates in a list Pin
Afzaal Ahmad Zeeshan20-Aug-20 4:37
professionalAfzaal Ahmad Zeeshan20-Aug-20 4:37 
AnswerRe: Find and count duplicates in a list Pin
BillWoodruff22-Aug-20 21:58
professionalBillWoodruff22-Aug-20 21:58 
QuestionPowerApps and C# Pin
Member 1127440117-Aug-20 6:08
Member 1127440117-Aug-20 6:08 
AnswerRe: PowerApps and C# Pin
Dave Kreskowiak17-Aug-20 7:42
mveDave Kreskowiak17-Aug-20 7:42 
QuestionBinding picture box with column with oracle Pin
mohammed alherwi14-Aug-20 23:26
mohammed alherwi14-Aug-20 23: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 10:11
professionalEddy Vluggen22-Aug-20 10:11 
QuestionHow to Read and Write to RFID(v9t557) as Human Interface Device C# Pin
Member 1177073713-Aug-20 14:10
Member 1177073713-Aug-20 14:10 
AnswerRe: How to Read and Write to RFID(v9t557) as Human Interface Device C# Pin
Dave Kreskowiak13-Aug-20 16:28
mveDave Kreskowiak13-Aug-20 16:28 
GeneralRe: How to Read and Write to RFID(v9t557) as Human Interface Device C# Pin
Member 1177073714-Aug-20 12:40
Member 1177073714-Aug-20 12:40 
GeneralRe: How to Read and Write to RFID(v9t557) as Human Interface Device C# Pin
Dave Kreskowiak14-Aug-20 13:16
mveDave Kreskowiak14-Aug-20 13:16 
GeneralRe: How to Read and Write to RFID(v9t557) as Human Interface Device C# Pin
Member 1177073714-Aug-20 13:28
Member 1177073714-Aug-20 13:28 
GeneralRe: How to Read and Write to RFID(v9t557) as Human Interface Device C# Pin
Dave Kreskowiak14-Aug-20 17:26
mveDave Kreskowiak14-Aug-20 17:26 
GeneralRe: How to Read and Write to RFID(v9t557) as Human Interface Device C# Pin
Member 1177073714-Aug-20 20:18
Member 1177073714-Aug-20 20:18 
GeneralRe: How to Read and Write to RFID(v9t557) as Human Interface Device C# Pin
Dave Kreskowiak15-Aug-20 4:03
mveDave Kreskowiak15-Aug-20 4:03 
GeneralRe: How to Read and Write to RFID(v9t557) as Human Interface Device C# Pin
OriginalGriff15-Aug-20 2:31
mveOriginalGriff15-Aug-20 2:31 
QuestionHow to generate random decimal numbers in C# Pin
Sajo Nezic12-Aug-20 6:02
Sajo Nezic12-Aug-20 6:02 
AnswerRe: How to generate random decimal numbers in C# Pin
OriginalGriff12-Aug-20 6:09
mveOriginalGriff12-Aug-20 6:09 
AnswerRe: How to generate random decimal numbers in C# Pin
Luc Pattyn12-Aug-20 10:15
sitebuilderLuc Pattyn12-Aug-20 10:15 
AnswerRe: How to generate random decimal numbers in C# Pin
Eddy Vluggen13-Aug-20 12:07
professionalEddy Vluggen13-Aug-20 12:07 
AnswerRe: How to generate random decimal numbers in C# Pin
Patrice T14-Aug-20 22:33
mvePatrice T14-Aug-20 22:33 
AnswerRe: How to generate random decimal numbers in C# Pin
BillWoodruff19-Aug-20 1:31
professionalBillWoodruff19-Aug-20 1:31 
GeneralRe: How to generate random decimal numbers in C# Pin
jsc4219-Aug-20 6:41
professionaljsc4219-Aug-20 6: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.