Comments by rudolph098 (Top 60 by date)

Bless you, i will try this out , and it is the latter.

Thank you for you help, one small problem. each of these classes CashReceipt, MiscReceipts etc have a function called "exportStoredProc". Implementing your logic, how do i access this function. Thank you

how do I pass one,two,three,four from the hashtable to the string array HTlist.

Sorry for any misunderstanding, I perform the first part of the code in C#. Its performing the second part of the code in C# that has me hooked. And also I am using (using System.Data.SqlClient;) which is .Net built in sqlconnection framework.

thanks for the help, but I fixed it, I forgot to add (DRTM_AssetTracker_Person.Guid, DRTM_AssetTracker_Person.FirstName, DRTM_AssetTracker_Person.LastName) in the FROM clause.

The purpose of the GUI is to aid the user select the given file they want and the file read-in is surprisingly very fast.
The file I am using has been edited thoroughly and only has a small data set. Also, I don't want to add code for error handling until I fix this problem.

thanks you, it was driving me nuts.

Bless you.

Sorry for wasting your precious time, but i found out why it was not working. It did not work because try catch doesn't work for compile errors.

I want to my custom message to catch when a bad date is entered (1900-1-0). Now MSQL management studio already does this by outputting : Msg 8114 , Error converting data type nvarchar to datetime. But I want my custom error to also output the bad data that caused it. Because my boss is going to dump a lot of queries for execution and some will have this bad data.

No, I said @ErrorMsg works fine, its @ErrorMsg1 that doesn't

The first link has all that i needed

IF EXISTS( SELECT ID FROM ITTESI_AssetTracker_Person WHERE Guid = @Guid)
BEGIN
-- Assign existing PersonID to output parameter @intPersonID
SET @intPersonID = ID
END
ELSE

like this?

Bless you.

Also i wanted to ask if there is a way to auto generate the date and insert it into the table instead of passing it like i did with firstname,lastname and guid.

Ok

also thanks a lot, i really appreciate your help

i gives this new error

Msg 102, Level 15, State 1, Procedure Check_IF_Person_Exist, Line 10
Incorrect syntax near 'OUTPUT'.
Msg 137, Level 15, State 1, Procedure Check_IF_Person_Exist, Line 17
Must declare the scalar variable "@intPersonID".
Msg 137, Level 15, State 1, Procedure Check_IF_Person_Exist, Line 24
Must declare the scalar variable "@intPersonID".

I did that and i get this error.

Msg 156, Level 15, State 1, Procedure Check_IF_Person_Exist, Line 2
Incorrect syntax near the keyword 'DECLARE'.
Msg 102, Level 15, State 1, Procedure Check_IF_Person_Exist, Line 4
Incorrect syntax near '@intPersonID'.
Msg 137, Level 15, State 1, Procedure Check_IF_Person_Exist, Line 12
Must declare the scalar variable "@intPersonID".
Msg 137, Level 15, State 1, Procedure Check_IF_Person_Exist, Line 19
Must declare the scalar variable "@intPersonID".

Thank you very much, I wasn't looking for code, I just need help getting past a misunderstanding.

is it not usually a query passed to statement for execution, why are they passing a Resultset? if a Db has been queried and a Resultset is obtained, is the Resultset not meant to be returned?.

ok so you said that a DataReader is Equivalent to a result set. So from the code, if a statement executes a Resultst, does an Sqlcommand execute a DataReader?

my problem is that they Resltset passes the data to be executed to statement, but Datareader get the data from an exectuted SqlCommand. but there's is a reverse

thank you, but something confuses me, in the code I placed above, they are passing a result set to an instance of a Statement object to be executed. So I am not sure how I will be able to mirror this with an SqlReader. Because an SqlReader get the data from an executed sqlcommand. I am confused , I would b very greatful if you shed more light on it. Thanks

I have updated the question. Thank you

Reply thank you, it worked

i am a confused, i have never used this to create a stored procedure, so this is new to me. Can you pls offer some assistance.

Thank you this was very insightful.

Thanks for the attempt, but this is why I don't use converter because they don't know if the language that they are converting to has the methods or not.

Thank you.

Ok thank you.

That's why I am stuck at the Enumeration objEnum, not the Hashtable.

I am not sure it helps me, I added code to the original question for a bit of context. thank you.

Thank you.And also i read the documentation,but i am not sure. So i you can help me clarify, does the xmlDocument.load() call the XmlTextreader by default or am i gonna have to do that myself
[load Method^]

Its complaining about 2 methods in the code. One being the hasMoreElements() and the nextElement().

thank you

Thank you.

very insightful. thanks

also how do I check if the hashtable is empty?

it did. thanks

Please can you give me a more concrete example, the documentation didn't.

thank you!! it was actually what I was looking for, I didn't look at the function properly. It was SelectNodes not SelectNode.

Thank for the help, actually I have been to this site already. The major thing that throws me off in the java code is that an instance of node (objRecord) is being passed as a parameter in selectSingleNode funcion, while the c# version of this function, implements it in a very different way. In C#, they performs a query on a xml document, but this java version performs a query on an object

Thank you

Thank you

thank you man, really greatful

Is there a way I can mimic this functionality in c#?.

thank you, but the documentation does little to nothing to answer my question.

its a variable of type ResultSet

thanks

thanks

thank you.

Thanks that solved on problem, but there is a new one.

Since its an oracleDb, i decided to change all the classes since there was the Oracle version for all the Sql.

To clarify: Dataset data1 = new Dataset(), so the oracle version of this is OracleDataset data1 = new Dataset(). So for all the other like SqlDataReader, SqlDataAdapter etc. all i did was to add Oracle in front of it for the purpose of uniformity and so the V.S stops complaining about conversion between the classes.

but the real question is that i am getting a new error message, after i made this change

OracleConnection Astra_db_Conn = new OracleConnection(Astra_conn);
string myquery = sql.ToString();
OracleCommand cmd = new OracleCommand(myquery);

Astra_db_Conn.Open();
try
{
OracleDataAdapter adpt = new OracleDataAdapter();
rs=cmd.ExecuteReader(); // this is where i get the error
adpt.Fill(rs);

} catch(Exception e)
{
log.Error("*** ERROR *** IRISExportQueries.loadStudentInfoLearningSites():" + e);

}

// but then i get the error: "cannot implicitly convert type 'Data.Oracle.OracleDataReader' to 'Data.Oracle.OracleDataSet'"

// thanks for the help