C#

dataReader1.GetFieldType(0)

Unsy wrote:

a little jobby

Luc Pattyn wrote:

The ListBox will not keep track of your selection order; all it keeps track of is the selected state for each of the items; as a result SelectedItems will enumerate the selected items in their order of appearance.

You need to implement your stuff yourself; just keep your own chronological list of selected items, wire up the SelectionChanged event, and adapt your list accordingly every time the selection changes; remember an item can be removed from the selection too!

WebClient webClient = new WebClient();
webClientData = webClient.DownloadData(uri);

byte[] buffer;
HttpWebRequest req = (HttpWebRequest)WebRequest.Create(url);
HttpWebResponse resp = (HttpWebResponse)req.GetResponse();
System.IO.Stream s = resp.GetResponseStream();

string query2 = "select sum(amount) Total from pur_inv_dtl where inv_id = '" + IdTxt.Text + "'";



SqlCommand cmd2 = new SqlCommand(query2, conn);
try
   {
   conn.Open();
   SqlDataReader sdr = cmd2.ExecuteReader();
   while (sdr.Read())
      {
      Gtotal.Text = sdr["Total"].ToString();
      }
   }
finally
   {
   conn.Close();
   }