I need help with creating CAML

Question

I have a document library MyLib and i need to find specified file in it .

        query.Query = @"
              <Where>
                 <Eq>
                    <FieldRef Name='Title' />
                        <Value Type=" + name + 
                         @">as</Value>
                 </Eq>
              </Where>
         "; 

how can I specify my Document Library?

Thank you!

Answer 1

const string camlQuery = @"<query><where><and><gt><fieldref name="Price"><value type="Number">1000</value></fieldref></gt><leq><fieldref name="Price"><value type="Number">10000</value></fieldref></leq></and></where><orderby><fieldref ascending="False" name="Price"></fieldref></orderby></query>";    
try
            {
                using (SPSite objSite = new SPSite("sitename"))
                {
                    using (SPWeb objWeb = objSite.OpenWeb())
                    {
                        // Building a query
                        SPQuery query=new SPQuery();
                        query.Query=camlQuery;

                        // Retrieving the data from the List
                        SPList objList=objWeb.Lists["Product List"];
                        SPListItemCollection items= objList.GetItems(query);

                        // Prinitng the header
                        Console.WriteLine("{0,-25} {1,-20} {2,-15} {3}", "Title", "Price", "Qunatity", "Is Available");

                        foreach (SPListItem objListItem in items)
                        {
                            Console.WriteLine("{0,-25} {1,-20} {2,-25} {3}", objListItem["Title"], objListItem["Price"],
                                                                             objListItem["Quantity"], objListItem["Is Available"]);
                        }

                    }
                    Console.ReadLine();
                }

            }
            catch (Exception ex)
            {
                Console.WriteLine("Error Occured:", ex.Message);
            }
            Console.ReadLine();