Select query that should return multiple rows: It does not

[weird0]

The given should return A,B that is two rows because both
accountnames A and B have the same user_Id=1 but it is only returning
A when I performed the op. MessageBox.Show ("AccountNames: " +
Object.ToString () );

[WebMethod]
public Object GetAccountNames (string User_Id)
{
//string AccountNames;
Object AccountNames;

// create a Command,Connect ion and Reader object

System.Data.Sql Client.SqlConne ction sqlConnection1 =
new System.Data.Sql Client.SqlConne ction(connectio nString);
System.Data.Sql Client.SqlComma nd cmd = new
System.Data.Sql Client.SqlComma nd();
//Object returnValue;

// Search for the pincode

cmd.CommandText = "SELECT acc_name FROM Account_Informa tion
where user_id='" + User_Id + "'";
cmd.CommandType = CommandType.Tex t;
cmd.Connection = sqlConnection1;

sqlConnection1. Open();
AccountNames = cmd.ExecuteScal ar();
//AccountNames = returnValue.ToS tring();
sqlConnection1. Close();

return AccountNames;

}

[sloan]

ExecuteScalar is the wrong choice here.

You want

..ExecuteReader

or

LoadDataSet
ExecuteScalar is for 1 single value.

like

Select count(*) as MyCount from dbo.Emp

would be a single value. ExecuteScalar is for that kind of purpose.

"weird0" <am********@gma il.comwrote in message
news:11******** **************@ o5g2000hsb.goog legroups.com...

The given should return A,B that is two rows because both
accountnames A and B have the same user_Id=1 but it is only returning
A when I performed the op. MessageBox.Show ("AccountNames: " +
Object.ToString () );

[WebMethod]
public Object GetAccountNames (string User_Id)
{
//string AccountNames;
Object AccountNames;

// create a Command,Connect ion and Reader object

System.Data.Sql Client.SqlConne ction sqlConnection1 =
new System.Data.Sql Client.SqlConne ction(connectio nString);
System.Data.Sql Client.SqlComma nd cmd = new
System.Data.Sql Client.SqlComma nd();
//Object returnValue;

// Search for the pincode

cmd.CommandText = "SELECT acc_name FROM Account_Informa tion
where user_id='" + User_Id + "'";
cmd.CommandType = CommandType.Tex t;
cmd.Connection = sqlConnection1;

sqlConnection1. Open();
AccountNames = cmd.ExecuteScal ar();
//AccountNames = returnValue.ToS tring();
sqlConnection1. Close();

return AccountNames;

}

[sloan]

I might have misread.

Are you expecting one and only one value?

See here:

http://msdn2.microsoft.com/en-us/library/ms978510.aspx
and scroll down to the appendix
Appendix
How to Enable Object Construction for a .NET Class
keep scrolling down a little, basically "every scenario" is listed there.

1 row, multiple columns
1 row, 1 value (what you want)
multi rows, multi columns

"sloan" <sl***@ipass.ne twrote in message
news:eA******** ******@TK2MSFTN GP02.phx.gbl...

ExecuteScalar is the wrong choice here.

You want

.ExecuteReader

or

LoadDataSet
ExecuteScalar is for 1 single value.

like

Select count(*) as MyCount from dbo.Emp

would be a single value. ExecuteScalar is for that kind of purpose.

"weird0" <am********@gma il.comwrote in message
news:11******** **************@ o5g2000hsb.goog legroups.com...

The given should return A,B that is two rows because both
accountnames A and B have the same user_Id=1 but it is only returning
A when I performed the op. MessageBox.Show ("AccountNames: " +
Object.ToString () );

[WebMethod]
public Object GetAccountNames (string User_Id)
{
//string AccountNames;
Object AccountNames;

// create a Command,Connect ion and Reader object

System.Data.Sql Client.SqlConne ction sqlConnection1 =
new System.Data.Sql Client.SqlConne ction(connectio nString);
System.Data.Sql Client.SqlComma nd cmd = new
System.Data.Sql Client.SqlComma nd();
//Object returnValue;

// Search for the pincode

cmd.CommandText = "SELECT acc_name FROM Account_Informa tion
where user_id='" + User_Id + "'";
cmd.CommandType = CommandType.Tex t;
cmd.Connection = sqlConnection1;

sqlConnection1. Open();
AccountNames = cmd.ExecuteScal ar();
//AccountNames = returnValue.ToS tring();
sqlConnection1. Close();

return AccountNames;

}

[=?Utf-8?B?UGV0ZXIgQnJvbWJlcmcgW0MjIE1WUF0=?=]

In addition to what Sloan pointed out, you really want to get into the habit
of using parmeterized queries or even better, stored procedures.
Peter

--
Site: http://www.eggheadcafe.com
UnBlog: http://petesbloggerama.blogspot.com
Short urls & more: http://ittyurl.net


"weird0" wrote:

The given should return A,B that is two rows because both
accountnames A and B have the same user_Id=1 but it is only returning
A when I performed the op. MessageBox.Show ("AccountNames: " +
Object.ToString () );

[WebMethod]
public Object GetAccountNames (string User_Id)
{
//string AccountNames;
Object AccountNames;

// create a Command,Connect ion and Reader object

System.Data.Sql Client.SqlConne ction sqlConnection1 =
new System.Data.Sql Client.SqlConne ction(connectio nString);
System.Data.Sql Client.SqlComma nd cmd = new
System.Data.Sql Client.SqlComma nd();
//Object returnValue;

// Search for the pincode

cmd.CommandText = "SELECT acc_name FROM Account_Informa tion
where user_id='" + User_Id + "'";
cmd.CommandType = CommandType.Tex t;
cmd.Connection = sqlConnection1;

sqlConnection1. Open();
AccountNames = cmd.ExecuteScal ar();
//AccountNames = returnValue.ToS tring();
sqlConnection1. Close();

return AccountNames;

}