C# 2008 linq to sql paramters

Question

After I parse out a company name and contact name from an excel spreadsheet 2010, I need to query a sql server 2008 r2 database, to obtain more information that is needed for processing. My problem is the  name and/or contact name that is obtain from the file name, may be different than the actual value in the database.

For example the company name obtained from the file name may look like:
'Blue group' however the actual file company name in the database may be
'Blue (of northeast) group' or 'Blue inc'?

Note: I am told that the combination of company name, contact name will be distinct enough so I can obtain the database rows I am looking for.

Thus can you tell me how I could use linq to sql to query the database using the company name with the value obtain from the filename where the database value could be different?

Answer 1

listView.Items.Add(fileName) will add the parent item in the list view. Then you'd issue, listView.SubItems.Add(subItem) to add subitems under the parent item in ONE row. Imagine how the Windows Explorer displays files. First Filename, Data, Size, etc etc. That's what it does. So, retrieve the data from using data reader and insert it right in the list view; listView.Items.Add(dataReaderReadItem); listView.SubItems.Add(dataReaderReadItemFromtheNextColumnInTheRow); If you need to do casting before adding..take care of that . Regards, JJ

Answer 2

Unfortunately it didn't.. :( What does the following line actually add in to the list view??? anything? listview.Items.Add(fileName); I am sort of new to all this so please forgive me.. I have a database which I can successfully connect to. I am trying to use the data reader to read records from a table and then populate this information in to the list view. I guess I don't understand how I can get the information from the DB... reader.GetInt32(0).tostring(), **as information for column 1 ** reader.GetString(1).tostring(), ** as information for column 2 **... etc.. Thanks, Bob

Answer 3

You'll have to add the columns first, which you know how. Then add subitems under the columns: Follow this: listview.Items.Add(fileName); //fileName is your parent Column listview.Items[count].SubItems.Add(size); //size is the child under the Parent Column listview.Items[count].SubItems.Add(date); //another child. so this will look like in ListView with 3 columns. First row is the column. File Name Size Date fileName1 size1 date1 fileName2 size2 date2 Hope that helps. JJ