Click here to Skip to main content
15,886,069 members
Home / Discussions / C#
   

C#

 
GeneralRe: C# how I can sniff a process? Pin
Richard MacCutchan10-Jan-12 2:36
mveRichard MacCutchan10-Jan-12 2:36 
GeneralRe: C# how I can sniff a process? Pin
terrinfo10-Jan-12 3:06
terrinfo10-Jan-12 3:06 
GeneralRe: C# how I can sniff a process? Pin
Richard MacCutchan10-Jan-12 3:26
mveRichard MacCutchan10-Jan-12 3:26 
GeneralRe: C# how I can sniff a process? Pin
terrinfo10-Jan-12 3:32
terrinfo10-Jan-12 3:32 
GeneralRe: C# how I can sniff a process? Pin
Richard MacCutchan10-Jan-12 3:45
mveRichard MacCutchan10-Jan-12 3:45 
GeneralRe: C# how I can sniff a process? Pin
terrinfo10-Jan-12 3:48
terrinfo10-Jan-12 3:48 
GeneralRe: C# how I can sniff a process? Pin
Richard MacCutchan10-Jan-12 4:06
mveRichard MacCutchan10-Jan-12 4:06 
QuestionC# -Oracle- Access Pin
bigphish9-Jan-12 8:33
bigphish9-Jan-12 8:33 
hi..
I m new to Oracle and c#.still I am tryiyng to picking up stones here Smile | :)

currently I am working on Script Task tool in SSIS (Using c#) in which I need to store the resultset from my Oracle stored procedure in to a MS access table.Below is the code:
C#
public void Main()
       {
            OracleConnection conn = new OracleConnection();
           // TODO: Add your code here
            conn.ConnectionString= "UserId=XXXX;Password=XXXX;Data Source= "XXXXXXX;";

            conn.Open();

           //execute stored procedure here
           DataTable resultDT = new DataTable();

           OracleCommand Cmd = new OracleCommand();
           Cmd.Connection = conn;
           Cmd.CommandText = "My_StoreProc";
           Cmd.CommandType = CommandType.StoredProcedure;
           OracleParameter[] paramsArray = new OracleParameter[2];
           paramsArray[0] = new OracleParameter("fromDate", OracleDbType.Date, ParameterDirection.Input);
           paramsArray[1] = new OracleParameter("toDate", OracleDbType.Date, ParameterDirection.Input);


..and here after I am stucked how to proceed with ..Frown | :-(
how to use Oracle dataadapter,dataset and store this result set in an Access table?Any help will be appreciated!

Thanks in advance!

BigFish
AnswerRe: C# -Oracle- Access Pin
RexGrammer9-Jan-12 8:45
RexGrammer9-Jan-12 8:45 
GeneralRe: C# -Oracle- Access Pin
bigphish9-Jan-12 19:04
bigphish9-Jan-12 19:04 
GeneralRe: C# -Oracle- Access Pin
Mycroft Holmes9-Jan-12 20:25
professionalMycroft Holmes9-Jan-12 20:25 
AnswerRe: C# -Oracle- Access Pin
jschell11-Jan-12 9:36
jschell11-Jan-12 9:36 
QuestionWinforms Update form label from a class library Pin
Member 43365949-Jan-12 4:53
Member 43365949-Jan-12 4:53 
AnswerRe: Winforms Update form label from a class library Pin
BobJanova9-Jan-12 5:05
BobJanova9-Jan-12 5:05 
GeneralRe: Winforms Update form label from a class library Pin
Member 43365949-Jan-12 5:17
Member 43365949-Jan-12 5:17 
GeneralRe: Winforms Update form label from a class library Pin
BobJanova9-Jan-12 6:46
BobJanova9-Jan-12 6:46 
AnswerRe: Winforms Update form label from a class library Pin
RexGrammer9-Jan-12 8:11
RexGrammer9-Jan-12 8:11 
AnswerRe: Winforms Update form label from a class library Pin
Luc Pattyn9-Jan-12 8:15
sitebuilderLuc Pattyn9-Jan-12 8:15 
GeneralRe: Winforms Update form label from a class library Pin
DaveyM699-Jan-12 8:43
professionalDaveyM699-Jan-12 8:43 
AnswerRe: Winforms Update form label from a class library Pin
BillWoodruff10-Jan-12 6:17
professionalBillWoodruff10-Jan-12 6:17 
QuestionHow to access the control of a form from diffrent form? Pin
Paramu19739-Jan-12 4:08
Paramu19739-Jan-12 4:08 
AnswerRe: How to access the control of a form from diffrent form? Pin
Ravi Bhavnani9-Jan-12 4:15
professionalRavi Bhavnani9-Jan-12 4:15 
AnswerRe: How to access the control of a form from diffrent form? Pin
RexGrammer9-Jan-12 8:09
RexGrammer9-Jan-12 8:09 
AnswerRe: How to access the control of a form from diffrent form? Pin
DaveyM699-Jan-12 9:07
professionalDaveyM699-Jan-12 9:07 
AnswerRe: How to access the control of a form from diffrent form? Pin
BillWoodruff10-Jan-12 6:55
professionalBillWoodruff10-Jan-12 6:55 

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.