C# Equivalent functiion

Question

0.00/5 (No votes)

See more:

Hey Guys I wanted to as if there is a C# alterative or equivalent to Java's

Resultset Object and the getStatemnt function in the Resultset Object.

Java

	/**
	 * Function to close the statement object of the result set passed
	 * @param ResultSet Result Set Object
	 */
protected void closeStatement(ResultSet lObjResultSet) 
{
  try
  {
     if(lObjResultSet != null)
      {
	Statement objStatement = lObjResultSet.getStatement();
	if(objStatement != null)
        objStatement.close();
      }
  } catch(Exception e) 
    {
       System.out.println("Exception in closeStatement 2 of TransactionObject " +e.getMessage());
		}
} //end of function closeStatement

I am trying to convert this piece of code from java to c#

Thnks for your help.

Posted 24-Oct-13 8:00am

rudolph098

Updated 24-Oct-13 8:17am

v2

Add a Solution

Comments

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 24-Oct-13 14:04pm

Please explain the scenario and what you want to achieve.

rudolph098 24-Oct-13 14:18pm

I have updated the question. Thank you

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Abhinav S · Answer 1 · 2013-10-24T08:33:00

Solution 2

There is another version of the ResultSet I guess - the DataSet. These two are not identical though.
Some comparison here[^].

Forward Readonly restrictions do not exist in a DataSet.

Posted 24-Oct-13 8:33am

Abhinav S

Updated 24-Oct-13 8:34am

v2

Ranjan.D · Answer 2 · 2013-10-24T08:12:00

Solution 1

SqlDataReader is the equivalent of ResultSet

More Info -http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqldatareader.aspx[^]

Just close the database connection instance after execution of sql command. There is no such equivalent for getStatement

Posted 24-Oct-13 8:12am

Ranjan.D

Updated 24-Oct-13 8:21am

v3

Comments

rudolph098 24-Oct-13 14:48pm

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

Ranjan.D 24-Oct-13 14:52pm

I suggestion not to duplicate , but understand the logic and do the same in C#.. Have a look into http://msdn.microsoft.com/en-us/library/haa3afyz.aspx in order to Retrieve Data Using a DataReader.

rudolph098 24-Oct-13 15:12pm

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

Ranjan.D 24-Oct-13 15:16pm

That's the reason I said though Java, C# look alike there are lots of differences. All you need to do in C# is create a connection object, command object and set the sql query to execute then execute the command so you will get a datareader , finally process the reader. It can be done with in 8 lines of code.

rudolph098 24-Oct-13 15:33pm

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?

Ranjan.D 24-Oct-13 15:56pm

Yes the Datareader is some what equivalent to Resultset . SqlCommand is used to execute the sql query and it will return the DataReader.

The Java Doc says what the ResultSet is - A table of data representing a database result set, which is usually generated by executing a statement that queries the database.

In C# the statement can be considered as SqlCommand. Hope this helps you.

rudolph098 24-Oct-13 16:06pm

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?.

Ranjan.D 24-Oct-13 16:17pm

No the Resultset will not be passed and like Java the SqlCommand will be executed and it will return the SqlDataReader, You just need to do the following, I don;t understand why are you comparing Java and C# and getting confused..

SqlCommand command = new SqlCommand(
"SELECT CategoryID, CategoryName FROM dbo.Categories;" +
"SELECT EmployeeID, LastName FROM dbo.Employees",
connection);

// Open a database connection
connection.Open();

// Execute command to return the reader
SqlDataReader reader = command.ExecuteReader();

// Loop through the reader
while (reader.HasRows)
{
Console.WriteLine("\t{0}\t{1}", reader.GetName(0),
reader.GetName(1));

while (reader.Read())
{
Console.WriteLine("\t{0}\t{1}", reader.GetInt32(0),
reader.GetString(1));
}
reader.NextResult();
}

rudolph098 24-Oct-13 16:24pm

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

Ranjan.D 24-Oct-13 16:35pm

Yes I had shared with you the link - http://msdn.microsoft.com/en-us/library/haa3afyz.aspx , check previous post :)