faintfascinatio

I'm using C# to run a couple stored procedures and return in dataset. I've been using: [CODE] if(dset.Tables.Count > 0) { for(int i = 0; i < dset.Tables[0].Rows.Count; i++) { //some code } } [/CODE] is there a shorter way to do this without the if statement?

I'm trying to use lucene in my project to search for people. I created the index using records from a db table of people (firstname, lastname, social, phone, address, etc). However, in the db, some of these fields are missing (ie, no address supplied). In my project, users can search …

For example, my query is something like: [CODE] SELECT fullName = firstName + ' ' + middleName + ' ' + lastName, streetAddress = address1 FROM Person [/CODE] How would I be able to reference fullName directly without having to type out first+middle+last again? If I just added "WHERE fullName …

Hi, Wondering how I would be able to implement an efficient fuzzy match algorithm in either c# or sql. I was using levenshtein's distance for my test data (~10 records) but once I started using a larger data set (~800 records), I realized this may not be the best way …

I need to get values from a couple xml files that vary. Ex. one file could contain: [CODE] <typeB> <people.b> <person.1> <fname.1>brian</fname.1> <lname.1>smith</lname.1> </person.1> <person.11> <fname.1>joe</fname.1> <lname.1>carey</lname.1> </person.11> </people.b> </typeB> [/CODE] and another would replace B with A and even have an extra group [CODE] <typeA> <people.a> <person.2> <name> <fname.2>brian</fname.2> …

I have an xml file, structure like so: [CODE] <people> <person.1> <fname>brian</fname> <lname>smith</lname> </person.1> <person.11> <fname>joe</fname> <lname>carey</lname> </person.11> </people> [/CODE] I am using openxml to read this file and insert names (and other person information) into a table. [CODE] DECLARE @person xml, @idoc int EXEC sp_xml_preparedocument @idoc OUTPUT, @person INSERT …