Click here to Skip to main content
15,394,479 members
Home / Discussions / C#
   

C#

 
GeneralRe: Active Directory Questions Pin
Mycroft Holmes16-Nov-17 11:36
professionalMycroft Holmes16-Nov-17 11:36 
AnswerRe: Active Directory Questions Pin
BillWoodruff16-Nov-17 20:44
mveBillWoodruff16-Nov-17 20:44 
GeneralRe: Active Directory Questions Pin
Richard MacCutchan16-Nov-17 22:54
mveRichard MacCutchan16-Nov-17 22:54 
GeneralRe: Active Directory Questions Pin
Kevin Marois17-Nov-17 4:39
professionalKevin Marois17-Nov-17 4:39 
AnswerRe: Active Directory Questions Pin
Nathan Minier17-Nov-17 1:36
professionalNathan Minier17-Nov-17 1:36 
Generalsession Pin
Ishi Kaushik16-Nov-17 7:04
MemberIshi Kaushik16-Nov-17 7:04 
AnswerRe: Hello , I am working on three tier architecture based project, i am stuck in writting session code. so please tell me how and where i can write the session code Pin
OriginalGriff16-Nov-17 8:03
mveOriginalGriff16-Nov-17 8:03 
QuestionData type mismatch in criteria expression." in c# Pin
sai.201216-Nov-17 5:54
Membersai.201216-Nov-17 5:54 
Hi all,

I have a question.

I have to insert oracle table values in Access database.

I am storing oracle table values in datatable(dt).

In oracle and Access database "Net" field is a "Number"

Trying to insert "Net" field in access datatype i am getting following exception.
"Data type mismatch in criteria expression."

I have found out the reason is "Net" field value in oracle table is EMPTY ("").

What i did is trying to check the field IsNullOrEmpty, if it is Empty then i want to store null value into "Net" field(In Access database).

I have made some code change after that also receiving the same error message .

""Data type mismatch in criteria expression."

Please help me how to fix this.

What I have tried:

strNet = !string.IsNullOrEmpty(dr["NET"].ToString()) ? dr["NET"].ToString() : null;
if (dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
sInsertValues= "'" + strNet + "'";

insertAEdetails.ParmValue = sInsertValues;

insertAEdetails.InsertIntoAccess();
iNbrInserts++;
}
}
AnswerRe: Data type mismatch in criteria expression." in c# Pin
Gerry Schmitz16-Nov-17 6:35
mveGerry Schmitz16-Nov-17 6:35 
AnswerRe: Data type mismatch in criteria expression." in c# Pin
Eddy Vluggen16-Nov-17 7:07
professionalEddy Vluggen16-Nov-17 7:07 
PraiseRe: Data type mismatch in criteria expression." in c# Pin
sai.201216-Nov-17 9:56
Membersai.201216-Nov-17 9:56 
GeneralRe: Data type mismatch in criteria expression." in c# Pin
Eddy Vluggen16-Nov-17 10:33
professionalEddy Vluggen16-Nov-17 10:33 
QuestionLicensing a .NET DLL Pin
P.Gnanaraj16-Nov-17 2:17
MemberP.Gnanaraj16-Nov-17 2:17 
AnswerRe: Licensing a .NET DLL Pin
Richard MacCutchan16-Nov-17 3:20
mveRichard MacCutchan16-Nov-17 3:20 
QuestionAsync method/task issue Pin
primem0ver15-Nov-17 7:21
Memberprimem0ver15-Nov-17 7:21 
AnswerRe: Async method/task issue Pin
Sascha Lefèvre15-Nov-17 8:33
professionalSascha Lefèvre15-Nov-17 8:33 
GeneralRe: Async method/task issue Pin
primem0ver15-Nov-17 9:52
Memberprimem0ver15-Nov-17 9:52 
GeneralRe: Async method/task issue Pin
Sascha Lefèvre15-Nov-17 10:19
professionalSascha Lefèvre15-Nov-17 10:19 
AnswerRe: Async method/task issue Pin
Gerry Schmitz16-Nov-17 4:24
mveGerry Schmitz16-Nov-17 4:24 
GeneralRe: Async method/task issue Pin
primem0ver16-Nov-17 10:57
Memberprimem0ver16-Nov-17 10:57 
GeneralRe: Async method/task issue Pin
Gerry Schmitz16-Nov-17 11:13
mveGerry Schmitz16-Nov-17 11:13 
GeneralRe: Async method/task issue Pin
primem0ver28-Nov-17 13:41
Memberprimem0ver28-Nov-17 13:41 
GeneralRe: Async method/task issue Pin
Gerry Schmitz29-Nov-17 4:29
mveGerry Schmitz29-Nov-17 4:29 
GeneralRe: Async method/task issue Pin
primem0ver2-Dec-17 13:30
Memberprimem0ver2-Dec-17 13:30 
GeneralRe: Async method/task issue Pin
Gerry Schmitz2-Dec-17 13:46
mveGerry Schmitz2-Dec-17 13:46 

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.