Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: shaunieb
  • Content: Threads
  • Order by date
  1. shaunieb

    Selecting information from 3 or more tables with a common id.

    Hi I have 3 or more tables i need to get info from. They are all related by unit_id, but im not sure how to do it. Can anyone give me some ideas? The tables are displayed below. Thank you in advance. BOND unit_id bank accountno banktel contactname contacttel...
  2. shaunieb

    Removing duplicates from an arraylist

    I'm pulling my hair out here :) , i know im dong something really small wrong. What is the recommended way to remove duplicate items in a arraylist? Im so tired, ive spent hours trying to figure this out :( Please any help would be greatly appreciated.
  3. shaunieb

    Why is my dataadapter empty?

    Hi everyone. When i run my application i get the following error on the highlighted line :: Additional information: Value cannot be null. Dim connStr As String connStr = String.Format("server={0};user id={1}; password={2}; database=prodev; pooling=false", "main", "root", "root")...
  4. shaunieb

    culculating and creating column total

    Hi, i've been trying to do this for about 3 hrs and am really killing my self here. Here are my 2 tables : vat.percent,markup.percent cost.product,productname.product What i want to do is select the data and then create a total column with a value calculated from...
  5. shaunieb

    how do i populate a listbox with a dataset

    hI, I'm mailny a asp.net guy and its pretty straight forward to do this with dropdownboxes etc is asp.net but for the life of me i'm striggling in vs to populate my listbox. I get System.Data.Datarowview instead of the values from my request. Please help. I've tried to do this for about 4 hrs...
  6. shaunieb

    System.Data.datarowview error when populating listbox. Pls help me..;(

    hI, I'm mailny a asp.net guy and its pretty straight forward to do this with dropdownboxes etc is asp.net but for the life of me i'm striggling in vs to populate my listbox. I get System.Data.Datarowview instead of the values from my request. Please help. I've tried to do this for about 4 hrs...
  7. shaunieb

    removing duplicate colum records, hmm

    Hi everyone, What Im trying to do is not display duplicate color records in the pcol1 column, heres my sql string and the results are shown below that. The pcol1 column contains the 2 b/green 3 red and 2 navy records. Thanks In advance :) Shaun select pc1.id, pc1.colorid, pcolid = (select...
  8. shaunieb

    Using nested joins ?? (I think) :)

    Hi, here is my query : select pc1.colorid, pcol1 = color1, pcol2 = color2 from productcolors pc1 join colorcombo CB on (CB.id = pc1.colorid) where pc1.prodid = '8' Here are my results : colorid pcol1 pcol2 1 1 28 2 2 28 21 1 10 28 4 10 19 10 28 33 2 23 37 15 11 33 2 23 What I would like to...
  9. shaunieb

    Join when 2 columns in one table point to 1 column in another table

    Using Join when 2 columns in one table point to 1 column in another table I have spent hours on this problem and no research has turned in my favour. Does anyone have any examples they can put forward for me. I am really desperate to sort this out, and any help will be greatly appreciated...

Part and Inventory Search

Back
Top