using listboxes in C#

[ShuckyD]

I have an application that i have been working on which is done with C# as well as being a smart device so i am using the compact framework. Some things are done differently in there, i have found out the hard way, but this should be fine im just not sure how i would go about getting this to work.

In the application we have someone scan a barcode, that barcode generates a list of items to get. (Right now i have that all done in a textbox) The SQL statement that pulls the whole list looks like this

public string PullMyOrder(string Order)
		{
			try
			{
				Connect();
				System.Data.SqlClient.SqlDataReader reader;
				rs.CommandText="SELECT [Sales Order Pickticket].[Line Number], " +
					"[Sales Order Pickticket].[Item Number], [Sales Order Pickticket].[BO Qty]-CONVERT(MONEY,dbo.fnc_nz(CONVERT(nvarchar(50),[PickedQty]),0)), " +
					"LEFT([Description],12) FROM [Sales Order Lineitems] INNER JOIN [Sales Order Pickticket] ON " +
					"([Sales Order Lineitems].[Sales Order Number]=[Sales Order Pickticket].[Sales Order Number]) AND " +
					"([Sales Order Lineitems].[Line Number]=[Sales Order Pickticket].[Line Number]) " +
					"WHERE [Sales Order Pickticket].[Sales Order Number]='" + Order + 
					"' AND ([Sales Order Pickticket].[BO Qty]-CONVERT(MONEY,dbo.fnc_nz(CONVERT(nvarchar(50),[PickedQty]),0))) > 0 AND [Shipped]=0";

				reader=rs.ExecuteReader();
				Order="";
				while (reader.Read() == true)
				{
					if (Order != "")
					{
						Order = Order + "\r\n";
					}
					strOrder = strOrder + reader.GetInt32(0).ToString().PadRight(4) + 
						reader.GetString(1)+ "\t" + reader.GetSqlMoney(2).ToString().PadRight(6) 
						+ reader.GetString(3);
				}
				reader.Close();
			}
			catch (SqlException ex)
			{
				MessageBox.Show(ex.Message,"XYZ: " + ex.Number);
			}
			Disconnect();
			return Order;
		}

that pulls the whole order and plops it right into that textbox. I need more control over that so i have to change it to a list box so that we just display the item that is suspose to be picked and then the item after, or something similar. I cant really do that with a text box since its all one large thing with new lines at the end of the item.

I want to be able to make the application tell the person using it via SQL coding where the location is for the next item, i have those textboxes already added to the form now all i have to do is get this working so i have an area to read from and then find their location. Follow?

So what im pretty much asking is how do you use a list box to do what i am trying to do. Ive seen how to add items to the collection, but you have to do that manually, i want to add things via code, and then be able to target specific things lines in there

[Iturea]

Quote:

Originally Posted by ShuckyD

that pulls the whole order and plops it right into that textbox. I need more control over that so i have to change it to a list box so that we just display the item that is suspose to be picked and then the item after, or something similar. I cant really do that with a text box since its all one large thing with new lines at the end of the item.

I want to be able to make the application tell the person using it via SQL coding where the location is for the next item, i have those textboxes already added to the form now all i have to do is get this working so i have an area to read from and then find their location. Follow?

So what im pretty much asking is how do you use a list box to do what i am trying to do. Ive seen how to add items to the collection, but you have to do that manually, i want to add things via code, and then be able to target specific things lines in there

Well I don't understand fully what you are looking for but I am going to take a stab in the dark and say create an ArrayList? -- So you can access the items you want such as the next item in the list...

// Somewhere in your function or class create object
ArrayList lstItems = new ArrayList();

while (reader.Read())
{
  if (Order != "")
  {
    Order = Order + "\r\n";
  }
  
  //WHERE lstItems IS YOUR NEW ARRAYLIST
  lstItems.Add(reader["listitemsfield"].ToString());

  
  strOrder = strOrder + reader.GetInt32(0).ToString().PadRight(4) + 
  reader.GetString(1)+ "\t" + reader.GetSqlMoney(2).ToString().PadRight(6) 
  + reader.GetString(3);
}

Then just pull the items you want out of the lstItems Array programmatically...

I know that's not your SQL example, but couldn't that work?

[ShuckyD]

i think it can, let mne giveit a try