C#

USE [Books]
GO
/****** Object:  StoredProcedure [dbo].[usp_SelectBasedonAuthor]    Script Date: 02/08/2010 17:52:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
/* Name: usp_SelectBasedonAuthor
   Description: Get authorfirst and last from user and do a select to get all the rows 
                meeting that criteria
   Author: Tony Stegall
   Modification Log: Change
   
   
   Description                           Date                           Author
   Created Procedure                    2/8/2010                       Tony Stegall
 
 
*/
ALTER PROCEDURE [dbo].[usp_SelectBasedonAuthor]
--Variables
@AuthorFirst varchar(50),
@AuthorLast  varchar(50)

AS

SELECT Book.*, Authors.*
FROM Book INNER JOIN 
(Authors INNER JOIN BookAuthors ON Authors.ID = BookAuthors.AuthorID) 
ON Book.ID = BookAuthors.BookID
WHERE AuthorFirst = @AuthorFirst AND AuthorLast = @AuthorLast;

private void treeView1_AfterSelect(object sender, TreeViewEventArgs e)
        {
            try
            {
                using (var db = new mombooksDataContext(Properties.Settings.Default.BooksConnectionString2))
                {


                    String[] splitstring = null;
                    string treeviewtext = treeView1.SelectedNode.Text;
                    splitstring = treeviewtext.Split(',');
                    var filter = db.usp_SelectBasedonAuthor(authorFirstTextBox.Text, authorLastTextBox.Text);

                    bindingNavigator1.BindingSource.DataSource = filter.ToList();

                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.ToString());
            }

            
        }

private void Compress(XDocument doc, string fullUserFilePath)
{
            byte[] buffer;

            MemoryStream memoryStream = new MemoryStream();
            XmlWriter writer = XmlWriter.Create(memoryStream);

            doc.Save(writer);

            writer.Close();

            memoryStream.Position = 0;

            buffer = new byte[memoryStream.Length];
            memoryStream.Read(buffer, 0, buffer.Count());
            using (FileStream outfile = new FileStream(fullUserFilePath, FileMode.Create, FileAccess.Write))
            {
                using (GZipStream stream = new GZipStream(outfile, CompressionMode.Compress))
                {
                    using (BinaryWriter sw = new BinaryWriter(stream))
                    {
                        sw.Write(buffer);
                    }
                }
            }
}