hi all.. i am using script task in SSIS.i am new to it. I have a oracle connection string in the code say:

//OraConn.ConnectionString = "User Id=XXXX;Password=xxxx;Data Source= (xxxxxxx));";

now i want to access this conection via variable: OraConn. how to do it? is it like below?

OraConn.ConnectionString = Dts.Variables["OraConn"].Value.ToString();

but its not working :( can anybdy suggest? FBG

yes .Thanks alot for the help :)

Okie.. sorry if my code was unclear..:( I am converting some code from vb to c#, wch will take some values from Oracle database and will insert in to a MS access database..so I cant view the oracle database wch is in some other server.legseq field in oracle database is taking data dynamically , which can be empty also some times. so while inserting in to Access database I need to check if the value of legseq is empty.if it is empty i need to make it Zero before inserting. hope its clear now..

Thnks for the reply Luc. will the below code can give the same result?

int? legseq = 0;
if (legseq == null)
{
legseq = 0;
}

hi.. am new to c#.. am getting an error below code..wch is wrking fine with Vb..

int legseq = 0;
if (legseq == " ")
{
legseq = 0;
}

Error: Operator '==' cannot be applied to operands of type 'string' and 'int'

I dont want to use 'null'instaed off " ". and dont want to make int as nullable. can anybdy help? Regrds, Reta

Hi there. I am using .NET Oracle.DataAccess.dll.. I m pretty sure that it can be done.Can anyone lead me till the dataset fill? Regards, BF

hi.. I m new to Oracle and c#.still I am tryiyng to picking up stones here :) 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:

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 ..:-( how to use Oracle dataadapter,dataset and store this result set in an Access table?Any help will be appreciated! Thanks in advance! BigFish

I have two grids.say Parent_Grid and Child_Grid. When ever I am inserting a record in the Parent_Grid one empty row with all value '0' should add in Child_Grid..how to achieve this?

I am trying to insert dataset as xml datatype,although the query is working fine, I am getting error in the application.

error:Cannot drop the table '#temp2', because it does not exist or you do not have permission.

I have tried alot to fix this..every thing in my query seems fine.adding the Query below:

create table #temp2 (JobID int,winnerId int,Title Nvarchar(50),FirstName nvarchar(50),LastName nvarchar(50),
Destination nvarchar(50),DateBooked datetime,DateDeparture datetime,Operators nvarchar(50),PhoneHome nchar(25),
PhoneWork nchar(25),Address nvarchar(200),TCAT nvarchar(50),Notes nvarchar(50),LastModifiedBy nvarchar(50),LastModifiedDate datetime)

insert into #temp2


SELECT  
	Data.Col.value('JobID\[1\]','int')as JobID,
	Data.Col.value('WinnerID\[1\]','int')as WinnerID,
	Data.Col.value('Title\[1\]','nvarchar(50)')as Title,
	Data.Col.value('FirstName\[1\]','nvarchar(50)')as FirstName,
	Data.Col.value('LastName\[1\]','nvarchar(50)')as LastName,
	Data.Col.value('Destination\[1\]','nvarchar(50)')as Destination,
	convert(datetime, left(Data.Col.value('DateBooked\[1\]','varchar(50)'),10)) as DateBooked,
	convert(datetime, left(Data.Col.value('DateDeparture\[1\]','varchar(50)'),10)) as DateDeparture,
	Data.Col.value('Operators\[1\]','nvarchar(50)')as Operators,
	Data.Col.value('PhoneHome\[1\]','nchar(25)')as PhoneHome,
	Data.Col.value('PhoneWork\[1\]','nchar(25)')as PhoneWork,
	Data.Col.value('Address\[1\]','nvarchar(200)')as Address,
	Data.Col.value('TCAT\[1\]','nvarchar(50)')as TCAT,
	Data.Col.value('Notes\[1\]','nvarchar(50)')as Notes,
	Data.Col.value('LastModifiedBy\[1\]','nvarchar(50)')as LastModifiedBy,
	convert(datetime, left(Data.Col.value('LastModifiedDate\[1\]','varchar(50)'),10)) as LastModifiedDate



FROM @Winnerpersonal.nodes('/NewDataSet/WPersonal') AS Data(Col)


insert into tbl\_WinnerPersonal(JobID,Title,FirstName,LastName,Destination,DateBooked,DateDeparture,Operators,PhoneHome,PhoneWork,Address,TCAT,Notes,LastModifiedBy,LastModifiedDate)
select @JobID,Title,FirstName,LastName,Destination,DateBooked,DateDeparture,Operators,PhoneHome,PhoneWork,
Address,TCAT,Notes,LastModifiedBy,LastModifiedDate from #temp2	where WinnerID < 0

drop table #temp2

CAn any one know wherer I went wrong??

Sorry..I forget to mention, there are two type of users ..Admin_user and user.. some conditions has to be satisfied: 1.adminUser can only delete other users. 2.Atleast one adminuser should be there in the table always. is there any way in sql ?

Hi.. I have an issue with the User table..How can I prevent a user deleting himself? I am giving the procedure below:

ALTER PROCEDURE [dbo].[Usp_User_Delete]
@LoginID AS int,
@DeletingPersonLoginId AS int,
@ErrorMessage as varchar(100) OUTPUT
AS
BEGIN
SET @ErrorMessage = 'SUCCESS'

BEGIN TRY
	DELETE FROM \[tbl\_User\]
	WHERE
		
	ID = @LoginID and ID<>@DeletingPersonLoginId
END TRY
BEGIN CATCH
	SELECT @ErrorMessage = ERROR\_MESSAGE()
END CATCH

What I have to check in C# code before delete command firing???

ANY UPDATE ON THIS? nothing is working for me.. :-(

hi.., if,

dt_GetCurrentPeriod.Rows[0]["IsCurrentPeriod"]

is 'false' also its giving error..It is working fine only if "IsCurrentPeriod" is true.. If the field is null its taking as false and giving error.I made this as nullable column.

Hi.. I am getting below error while executing this code:last line of code is throwing the error.-"Format exception unhandled by code.String was not recognized as a valid Boolean."

WinnersBLL objperiods = new WinnersBLL();

        DataTable dt\_GetCurrentPeriod = new DataTable();
         dt\_GetCurrentPeriod = (DataTable)Session\["WinBudget"\];
         GridEditableItem insertedItem = e.Item as GridEditableItem;
        

 if(Convert.ToBoolean(dt\_GetCurrentPeriod.Rows\[0\]\["IsCurrentPeriod"\].ToString()) == true)

{
some task.
}

If "Iscurrentperiod" column in the datatable is null ,its giving the error. how to check for null or false ?

I have a problem with telerik rad controls.I have a grid called MASTER_GRID and while selecting a row from that grid the corresponding SUB_GRID will load.same MASTER_GRID i am using in RadAjaxmanger as one of the control.when i am using the MASTER_GRID with RadAjaxcontrol, the "ROWCLICK" event which is in the MASTER_GRID is not firing..shall i add anything in the RadAjax manager to anable row click for the master grid??

In this example it shows gris in a row..but in my scenario, two different grids are there.I dont know how to bind data in to the 2nd grid according to the row selection of the first grid.. I am using telerik rad grid.

I am new to .net developement..stuck with an issue.. I have 2 grids in a page...Maingrid( key:- EmpID) and a Childgrid (key:- EmpID,PeriodID) For Each Maingrid details there will be one or more corresponding Childgrid details. When user selects a Maingrid detail record (ie, when selecting a row), corresponding Childgrid detail will be loaded in the Childgrid …(same as dependent grid.) How to load the 2nd grid according to the 1st grid row selection?

protected void rdg_Maingrid_ItemCommand1(object source, GridCommandEventArgs e)

{
    if (e.CommandName.ToString().ToUpper() == "RowClick")
    {

        //code for retrieving corresponding data in the budget grid..

    }
}

and I have delete ,edit options in both the grids. Anyhelp will be appreciated.

I am having 3 text boxes and a total label.total is calculating from the values of the textboxes.i am validating textboxes for only entering decimal values.but when i am entering values starting with decimal (".") the total is changing to NaN error (javascript - Not a Number error)..how to fix it?? other decimal values are working fine..only decimal starting with "." is giving error..any solution? Thanks in advance. "try try and try!!"

yes..just check this..u will get an idea.. www.vaxvoip.com

then on which section should i post this...??? i have posted it in Graphics section also..but no replies..so thought to put here..no intension to cross verify u all..just wanted to get any clue..thats y..