LINQ with Datetime

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ Ado
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - OleDb delays commits and unlocks? I've seen other posts with similar problems, but no solutions. I have two hair-pulling dilemmas that have been frustrating me for months now. Is there no solution? (C#.NET, Framework 2.0, Jet OleDb 4.0) The general goal is to read one MDB file and copy relevant info into another MDB file (copied from an empty template), replacing the old file with the new file. DataAdapters are used only to read (or re-read) the data from the file into the in-memory DataTable. All data INSERTs and UPDATEs are done with OleDbCommand.ExecuteNonQuery(). Problem 1: To retain the original version of the file, the process requires two rename operations. The first renames the original file. The second renames the new file to have the original file's name. Half the files I process do this OK. The other half fail on one of the renames, claiming that the file is still locked by another process. Checking the directory just prior to the rename attempt confirms that the corresponding LDB file still exists when the rename fails and doesn't exist when it succeeds. I've gone so far as to put all the data copying into a separate Main and invoking it with a Process.Start() so that the locking process has to be terminated before I attempt the rename. No dice. Aaaaargh! Problem 2: In the last-called method of the copy process, one new record is written to each of two empty tables. After that, a message is written to a log file, the method returns, and the OleDbConnection is closed. All of that occurs in about a dozen lines of code. This works almost all the time, except on one of my test files. With that file, the first inserted row appears in the output mdb file, but the second one does not! There is nothing particularly unusual about this file; other test files have identical structures. The tables involved are new tables, not present in the source data file, and every test file requires that these two rows be created. No errors are reported by the INSERTs or any other statement; it just doesn't get committed to the table. Double-Aaaaargh!! Tag: LINQ with Datetime Tag: 145059
  - 2
    - Books recommendations please Hi I need to develop winform database applications and wondering is these two books will get me there; Data Binding with Windows Forms 2.0: Programming Smart Client Data Applications with .Net http://www.amazon.co.uk/Data-Binding-Windows-Forms-2-0/dp/032126892X/ref=wl_it_dp?ie=UTF8&coliid=I2L84GECRS6E6P&colid=399925I1FY0N8 Windows Forms 2.0 Programming http://www.amazon.co.uk/Windows-Forms-Programming-Chris-Sells/dp/0321267966/ref=wl_it_dp?ie=UTF8&coliid=I1RY8RDOG4LBP1&colid=399925I1FY0N8 I already have Bill's 'Hitchhiker's guide to VS and SQL Server'. Any additional recommendations would be appreciated too. Basically anything that will get me off your backs. Thanks Regards Tag: LINQ with Datetime Tag: 145053
  - 3
    - typed dataset Hi all, I need to make a typed dataset cause i import a dataset from foxpro I use this code Dim oDbcommand As New SqlDataAdapter(Sql, Conn_SqlServer) oDbcommand.MissingSchemaAction = MissingSchemaAction.AddWithKey oDbcommand.Fill(Me.DataSet, Me.TableName) My Problem is vs 2005 or Framework 2.0 don"t return the well definition a numeric field (from sql server 2000) the xsl returned for the numeric Field <xs:element name="cli_pricemin" type="xs:decimal" minOccurs="0" /> for the string field <xs:element name="cli_email" minOccurs="0"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="50" /> </xs:restriction> </xs:simpleType> </xs:element> I would like to have the maxlength and the decimal, for the numeric field , pricemini <xs:maxLength value="10" /> Have you an Idea ? Olivier Tag: LINQ with Datetime Tag: 145047
  - 4
    - Connection works but returns no records Hi, I have been studying the books (2 ADO.NET and 1 VB.NET) and still can't work out why the records in the database aren't being read. >>>> Dim sConString As String = "Data Source=. \SQLEXPRESS;AttachDbFilename=""C:\Active Access Library\FigaroNET \Figaro\Figaro\FigaroData.mdf"";Integrated Security=True;Connect Timeout=30;User Instance=True" Dim conDivisions As New SqlConnection(sConString) conDivisions.Open() MessageBox.Show(conDivisions.State.ToString()) Dim sCompanySelect As String = "SELECT * FROM Entities.tbl1_company" Dim daCompanies As New SqlDataAdapter(sCompanySelect, conDivisions) Dim dsCompanies As New DataSet() Dim intCompanies As Integer intCompanies = daCompanies.Fill(dsCompanies, "Companies") MessageBox.Show("Found " & intCompanies & " records.") dsCompanies.Clear() conDivisions.Close() <<<< I get an "Open" message from the first MessageBox.Show, and 0 from the second, even though there are some records in Entities.tbl1_company. Thanks for any help, Ray Tag: LINQ with Datetime Tag: 145045
  - 5
    - Rado Ladies Watches Crysma R41762713 - AA - Replica Watch Fake Rado Ladies Watches Crysma R41762713 - AA - Replica Watch Fake Rado Ladies Watches Crysma R41762713 - AA Link : http://www.watchesprice.net/Replica-Rado-12198.html Replica Watches Home : http://www.watchesprice.net/ Replica Rado Brands : http://www.watchesprice.net/Rado-Replica.html Replica Rado Ladies Watches Crysma R41762713 - AA --- one of best selling replica watches, it is crafted in high quality, please click image 'buy now' to buy this chic but inexpensive replica to save you a lot of money . Rado Ladies Watches Crysma R41762713 - AA Description: no Rado Ladies Watches Crysma R41762713 - AA Details: Brand: Rado Band material: Yellow Plated Bracelet Case material: Yellow Plated 23mm Dial color: Black with Diamonds Movement type: Quartz Water-resistant to 30 meters Thank you for choosing www.watchesprice.net as your reliable dealer of quality waches including Rado Ladies Watches Crysma R41762713 - AA . we guarantee every watch you receive will be exact watch you ordered. Each watch sold enjoy one year Warranty for free repair. Every order from aaa-replica-watches is shipped via EMS, the customer is responsible for the shipping fee on the first order, but since the second watch you buy from our site, the shipping cost is free. Please note that If the total amount of payment is over $600(USD), the customer is required to contact our customer service before sending the money in case failed payment. If you have any other questions please check our other pages or feel free to email us by service@watchesprice.net. Cheapest Rado Ladies Watches Crysma R41762713 - AA The Same Rado Series : Rado Ladies Watches Crysma R41764103 - AA : http://www.watchesprice.net/Replica-Rado-12199.html Rado Men's DiaMaster watch #R14343163 : http://www.watchesprice.net/Replica-Rado-12200.html Rado Men's Diamaster Watch #R14470151 : http://www.watchesprice.net/Replica-Rado-12201.html Rado Men's DiaMaster watch #R14341173 : http://www.watchesprice.net/Replica-Rado-12202.html Rado Women's DiaMaster watch #R14342173 : http://www.watchesprice.net/Replica-Rado-12203.html Rado Women's DiaMaster watch #R14344163 : http://www.watchesprice.net/Replica-Rado-12204.html Rado Women's Diaqueen Watch #R23411152 : http://www.watchesprice.net/Replica-Rado-12205.html Rado Women's Diaqueen Watch #R23428902 : http://www.watchesprice.net/Replica-Rado-12206.html Rado Women's Diaqueen Watch #R23445102 : http://www.watchesprice.net/Replica-Rado-12207.html Rado Women's Diaqueen Watch #R23446102 : http://www.watchesprice.net/Replica-Rado-12208.html Rado Men's Watches DiaStar R18570103 - AA : http://www.watchesprice.net/Replica-Rado-12209.html Rado Men's Watches DiaStar R18565253 - AA : http://www.watchesprice.net/Replica-Rado-12210.html Tag: LINQ with Datetime Tag: 145043
  - 6
    - Citizen Chronograph Blue Dial (Women's Watch) - Replica Watch Fake Citizen Chronograph Blue Dial (Women's Watch) - Replica Watch Fake Citizen Chronograph Blue Dial (Women's Watch) Link : http://www.watchesprice.net/Replica-Citizen-6169.html Replica Watches Home : http://www.watchesprice.net/ Replica Citizen Brands : http://www.watchesprice.net/Citizen-Replica.html Replica Citizen Chronograph Blue Dial (Women's Watch) --- one of best selling replica watches, it is crafted in high quality, please click image 'buy now' to buy this chic but inexpensive replica to save you a lot of money . Citizen Chronograph Blue Dial (Women's Watch) Description: Citizen Women's Eco-Drive Watch . Water resistant. Date indicator at between 4 and 5 o'clock position. Chronograph. Eco-Drive 150 day power reserve. Blue dial. Leather strap. Stainless steel case. # FA2020-02A FA2020 #. Citizen Chronograph Blue Dial (Women's Watch) Details: Watches-Price Sales Rank: #46746 in Watches Brand: Citizen Eco-Drive Dial color: Blue Thank you for choosing www.watchesprice.net as your reliable dealer of quality waches including Citizen Chronograph Blue Dial (Women's Watch) . we guarantee every watch you receive will be exact watch you ordered. Each watch sold enjoy one year Warranty for free repair. Every order from aaa-replica-watches is shipped via EMS, the customer is responsible for the shipping fee on the first order, but since the second watch you buy from our site, the shipping cost is free. Please note that If the total amount of payment is over $600(USD), the customer is required to contact our customer service before sending the money in case failed payment. If you have any other questions please check our other pages or feel free to email us by service@watchesprice.net. Cheapest Citizen Chronograph Blue Dial (Women's Watch) The Same Citizen Series : Citizen Chronograph Green Dial (Women's Watch) : http://www.watchesprice.net/Replica-Citizen-6170.html Citizen Chronograph Leather Strap (Women's Watch) : http://www.watchesprice.net/Replica-Citizen-6171.html Citizen Ciena Eco-Drive Ladies Watch EG2100-55E : http://www.watchesprice.net/Replica-Citizen-6172.html Citizen Eco Drive Ladies Stilleto (Women's Watch) : http://www.watchesprice.net/Replica-Citizen-6173.html Citizen Eco Drive Ladies Stilleto (Women's Watch) : http://www.watchesprice.net/Replica-Citizen-6174.html Citizen Eco Drive Ladies Stilleto (Women's Watch) : http://www.watchesprice.net/Replica-Citizen-6175.html Citizen Eco Drive Ladies Stilleto (Women's Watch) : http://www.watchesprice.net/Replica-Citizen-6176.html Citizen Eco Drive Ladies Stilleto (Women's Watch) : http://www.watchesprice.net/Replica-Citizen-6177.html Citizen Eco Drive Ladies Stilleto (Women's Watch) : http://www.watchesprice.net/Replica-Citizen-6178.html Citizen Eco Drive Ladies Watch EW0230-57H : http://www.watchesprice.net/Replica-Citizen-6179.html CITIZEN Eco Drive Women's Black Dial 2-Hand Watch SY2030-54E : http://www.watchesprice.net/Replica-Citizen-6180.html Citizen Eco-Drive Alarm (Women's Watch) : http://www.watchesprice.net/Replica-Citizen-6181.html Tag: LINQ with Datetime Tag: 145042
  - 7
    - Patek Complicated Chronograph Men's Watch 5960P - Replica Watch Fake Patek Complicated Chronograph Men's Watch 5960P - Replica Watch Fake Patek Complicated Chronograph Men's Watch 5960P Link : http://www.watchesprice.net/Replica-Patek-Philippe-18262.html Replica Watches Home : http://www.watchesprice.net/ Replica Patek Philippe Brands : http://www.watchesprice.net/Patek-Philippe-Replica.html Replica Patek Complicated Chronograph Men's Watch 5960P --- one of best selling replica watches, it is crafted in high quality, please click image 'buy now' to buy this chic but inexpensive replica to save you a lot of money . Patek Complicated Chronograph Men's Watch 5960P Description: The Patek Complicated Chronograph Men's Watch is a Automatic watch with a Platinum case and Matt dark brown alligator bracelet. The color of the dial is Anthracite with a Sapphire cover. The case diameter is 40.5 mm and water resistant up to 25 m / 82 ft. Patek Complicated Chronograph Men's Watch 5960P Details: Brand: Patek PhilippeDial Color : PurpleClasp : Purple LeatherWater Resistant : 25m/80ftCase Material : PlatinumMovement : AutomaticCase Diameter : 5960PDial Color : PurpleCrystal : Scratch Resistant SapphireGender : Mens Thank you for choosing www.watchesprice.net as your reliable dealer of quality waches including Patek Complicated Chronograph Men's Watch 5960P . we guarantee every watch you receive will be exact watch you ordered. Each watch sold enjoy one year Warranty for free repair. Every order from aaa-replica-watches is shipped via EMS, the customer is responsible for the shipping fee on the first order, but since the second watch you buy from our site, the shipping cost is free. Please note that If the total amount of payment is over $600(USD), the customer is required to contact our customer service before sending the money in case failed payment. If you have any other questions please check our other pages or feel free to email us by service@watchesprice.net. Cheapest Patek Complicated Chronograph Men's Watch 5960P The Same Patek Philippe Series : Patek Complicated Annual Calendar 18 kt Rose Gold Men's Watch 5396R : http://www.watchesprice.net/Replica-Patek-Philippe-18263.html Patek Philippe Twenty~4 Ladies Watch 4910/11R : http://www.watchesprice.net/Replica-Patek-Philippe-18264.html Patek Philippe Twenty~4 Mini Watch 4908/11R : http://www.watchesprice.net/Replica-Patek-Philippe-18265.html Patek Philippe Aquanaut Mens Watch 5065A : http://www.watchesprice.net/Replica-Patek-Philippe-18266.html Patek Philippe Calatrava 18kt Yellow Gold Mens Watch 5127-1J : http://www.watchesprice.net/Replica-Patek-Philippe-18267.html Patek Philippe Calatrava 18kt Rose Gold Mens Watch 5127R : http://www.watchesprice.net/Replica-Patek-Philippe-18268.html Patek Philippe Calatrava Travel Time Platinum Mens Watch 5134P : http://www.watchesprice.net/Replica-Patek-Philippe-18269.html Patek Philippe Calatrava Perpetual Calendar 18kt White Gold Mens Watch 5140G : http://www.watchesprice.net/Replica-Patek-Philippe-18270.html Patek Philippe Calatrava 18kt White Gold Mens Watch 5196G : http://www.watchesprice.net/Replica-Patek-Philippe-18271.html Patek Philippe Calatrava 18kt Rose Gold Mens Watch 5196R : http://www.watchesprice.net/Replica-Patek-Philippe-18272.html Patek Philippe Calatrava 18kt Yellow Gold Mens Watch 5196J : http://www.watchesprice.net/Replica-Patek-Philippe-18273.html Patek Philippe Twenty~4 Diamond Ladies Watch 4910-10A-10 : http://www.watchesprice.net/Replica-Patek-Philippe-18274.html Tag: LINQ with Datetime Tag: 145041
  - 8
    - Saving Data with DataAdapter to Jet DB I am trying to save changes to a dataset using the dataAdapters update method to an Access 2003 DB, therefore I'm using an OleDbDataAdapter to accomplish this. I am using a For/Next loop to change a single column of data in the dataTable, & I know this works. The problem arises when I try to write the changes to the Access DB, nothing happens but the code process properly. I use virtually the same code set in another project writing to a SQL server DB & that works just fine. Is there some issue with OLEDB & Jet that this does not work or that i must do something different? Just for laughs I included a code snipit of what i'm doing. Try Conn.Open() daVoters.Update(dsCommittee, "Voters") Conn.Close() dsCommittee.AcceptChanges() Catch ex As OleDb.OleDbException Conn.Close() MessageBox.Show("There was an error updating the Database" & vbCr & vbLf & ex.Message, "Prep Data", MessageBoxButtons.OK, MessageBoxIcon.Error) End Try BTW I can do this by writing each change to the DB as I change it in the datatable, but this requires me to open & close the connection nearly 1/2 million times (there are over400,000 records in the DB) Thanks Gary Tag: LINQ with Datetime Tag: 145037
  - 9
    - SqlCommandBuilder DeriveParameters Ouput Arg gets wrong direction First, I am using the Enterprise Library DatabaseFactory to get a Database object. I have traced the issue down to the SqlCommandBuilder DeriveParameters method. Given a stored procedure args: CREATE PROCEDURE UpdDept ( @KeyDepartmentIdentifier UNIQUEIDENTIFIER, @KEYTimestamp BINARY(8), @NewName NVARCHAR(50), : : @OutTimeStamp BINARY(8) ) Wheh I call the Database.DiscoverParameters (aka - SqlCommandBuilder.DeriveParameters) the @OutTimeStamp DbPArameter (SqlParameter) has its direction set to InputOutput. SQL procedure parameters are either input or output. InputOut is not defined (SQL 2005). Why is the direction set to InputOutput? This requires that I initialize the output parameter. JM Tag: LINQ with Datetime Tag: 145034
  - 10
    - Brand Watches Seiko Wrist Watches-Seiko 5 Automatic Mechnical Brand Watches Seiko Wrist Watches-Seiko 5 Automatic Mechnical Self- Winding Watch Blue Stainless Steel Water Resistant Men Watch Model SNKA39K1 Discount, Replica, Fake Browse our Seiko Wrist Watches-Seiko 5 Automatic Mechnical Self- Winding Watch Blue Stainless Steel Water Resistant Men Watch Model SNKA39K1 replica watches, which is sure the watch you are looking for at low price. There are more high quality designer watch replicas for selection Seiko Wrist Watches-Seiko 5 Automatic Mechnical Self-Winding Watch Blue Stainless Steel Water Resistant Men Watch Model SNKA39K1 Link : http://www.watches-brand.com/Replica-Seiko-13560.html Brand : Seiko ( http://www.watches-brand.com/Seiko-Replica.html ) Model : Seiko Wrist Watches-Seiko 5 Automatic Mechnical Self-Winding Watch Blue Stainless Steel Water Resistant Men Watch Model SNKA39K1 Description : <p>Japan 21 Jewels Automatic Self-Winding Movement. Stainless Steel Case and Band with Push Button Deployment Clasp. Day/Date Display with Spanish Option. See-Thru Screwdown Caseback. Water Resistant - 30 meters</p> Sale Price : $ 210.00 Seiko Wrist Watches-Seiko 5 Automatic Mechnical Self-Winding Watch Blue Stainless Steel Water Resistant Men Watch Model SNKA39K1 Details : <ul> <li>Watches-Price Sales Rank: #13997 in Watches </li> <li>Brand: Seiko</li> <li>Band material: stainless-steel</li> <li>Case material: stainless-steel</li> <li>Dial color: Blue</li> <li>Dial window material: Hardlex</li> <li>Movement type: automatic-self-wind</li> </ul> Seiko Wrist Watches-Seiko 5 Automatic Mechnical Self-Winding Watch Blue Stainless Steel Water Resistant Men Watch Model SNKA39K1 is new brand replica, join thousands of satisfied customers and buy your Seiko with total satisfaction. A watches-brand.COM 30 Day Money Back Guarantee is included with every Seiko Replica Series for secure, risk- free online shopping. watches-brand.COM does not charge sales tax for the Fake Seiko Wrist Watches-Seiko 5 Automatic Mechnical Self-Winding Watch Blue Stainless Steel Water Resistant Men Watch Model SNKA39K1. All of our replica watches are shipped via EMS to worldwide. Normally it takes 3days to prepare the fake watch you ordered and 5-10days to transmit depending on the different destination.We pay for the free shipping cost for total quantity over 20 pcs. The EMS tracking NO. will be sent by email when an order is shipped from our warehouse. No more other charges from watches-brand.com such as the tax. If you have any other questions please check our other pages or feel free to email us by sales@watches-brand.com. The Same Replica Seiko Watches Series : Seiko Wrist Watches-Seiko 5 Automatic Mechnical Self-Winding Metal Bracelet Silver Dial Men's Water Resistance SNXS75K : http://www.watches-brand.com/Replica-Seiko-13561.html Seiko 5 Men's Automatic Green Dial with Green Nylon Strap Watch : http://www.watches-brand.com/Replica-Seiko-13562.html Seiko Men's Sports Automatic (Made in Japan) Watch # SKZ211J1 : http://www.watches-brand.com/Replica-Seiko-13563.html Seiko Men's 5 Sports Automatic Watch #SNZ309K : http://www.watches-brand.com/Replica-Seiko-13564.html Seiko Wrist Watches-Seiko 5 Automatic Mechanical Self-Winding Date Day Silver-White Dial Stainless Steel Water Resistance Men's Watch SNK601K1 : http://www.watches-brand.com/Replica-Seiko-13565.html Seiko Automatic Black Dial (Men's Watch) : http://www.watches-brand.com/Replica-Seiko-13566.html Seiko Men's 5 Automatic Two Tone Stainless Steel Watch #SNXJ90 : http://www.watches-brand.com/Replica-Seiko-13567.html Seiko Men's 5 Sports Watch #SNK031K : http://www.watches-brand.com/Replica-Seiko-13568.html Seiko Men's Automatic (Made in Japan) Watch # SNKC47J1 : http://www.watches-brand.com/Replica-Seiko-13569.html Seiko Wrist Watches-Seiko 5 Automatic Mechnical Self-Winding Date Day Men's Gold Tone Watch SNXA06K : http://www.watches-brand.com/Replica-Seiko-13570.html Brand Watches Seiko Wrist Watches-Seiko 5 Automatic Mechnical Self- Winding Watch Blue Stainless Steel Water Resistant Men Watch Model SNKA39K1 Discount, Replica, Fake Tag: LINQ with Datetime Tag: 145033
  - 11
    - Brand Watches Audemars Piguet Edward Piguet Diamond 18kt White Gold Brand Watches Audemars Piguet Edward Piguet Diamond 18kt White Gold Black Ladies Watch 77206BC.ZZ.D001CR.01 Discount, Replica, Fake Browse our Audemars Piguet Edward Piguet Diamond 18kt White Gold Black Ladies Watch 77206BC.ZZ.D001CR.01 replica watches, which is sure the watch you are looking for at low price. There are more high quality designer watch replicas for selection Audemars Piguet Edward Piguet Diamond 18kt White Gold Black Ladies Watch 77206BC.ZZ.D001CR.01 Link : http://www.watches-brand.com/Replica-Audemars-Piguet-19131.html Brand : Audemars Piguet ( http://www.watches-brand.com/Audemars-Piguet-Replica.html ) Model : Audemars-Piguet-77206BC.ZZ.D001CR.01 Description : 18kt White Gold Case. Black Leather Strap. Black Dial With 4 Diamonds. Diamond Bezel. Deployment Clasp. Scratch Resistant Sapphire Crystal. Manual Winding Movement. Water Resistant At 20 meters (60 feet). Audemars Piguet Edward Piguet Diamond 18kt White Gold Black Ladies Watch 77206BC.ZZ.D001CR.01 Sale Price : $ 210.00 Audemars Piguet Edward Piguet Diamond 18kt White Gold Black Ladies Watch 77206BC.ZZ.D001CR.01 Details : <ul><li>Brand: Audemars Piguet</li><li>Gender : Ladies</li><li>Dial Color : Black</li><li>Bezel : Diamond</li><li>Clasp : Black Leather</ li><li>Water Resistant : 20m/60ft</li><li>Case Material : 18kt White Gold</li><li>Movement : Manual Winding</li><li>Crystal : Scratch Resistant Sapphire</li></ul> Audemars Piguet Edward Piguet Diamond 18kt White Gold Black Ladies Watch 77206BC.ZZ.D001CR.01 is new brand replica, join thousands of satisfied customers and buy your Audemars Piguet with total satisfaction. A watches-brand.COM 30 Day Money Back Guarantee is included with every Audemars Piguet Replica Series for secure, risk- free online shopping. watches-brand.COM does not charge sales tax for the Fake Audemars Piguet Edward Piguet Diamond 18kt White Gold Black Ladies Watch 77206BC.ZZ.D001CR.01. All of our replica watches are shipped via EMS to worldwide. Normally it takes 3days to prepare the fake watch you ordered and 5-10days to transmit depending on the different destination.We pay for the free shipping cost for total quantity over 20 pcs. The EMS tracking NO. will be sent by email when an order is shipped from our warehouse. No more other charges from watches-brand.com such as the tax. If you have any other questions please check our other pages or feel free to email us by sales@watches-brand.com. The Same Replica Audemars Piguet Watches Series : Audemars Piguet Edward Piguet 18kt White Gold Black Mens Watch 25987BC.OO.D002CR.01 : http://www.watches-brand.com/Replica-Audemars-Piguet-19132.html Audemars Piguet Edward Piguet Diamond 18kt White Gold Black Mens Watch 25946BC.ZZ.D001CR.01 : http://www.watches-brand.com/Replica-Audemars-Piguet-19133.html Audemars Piguet Edward Piguet 18kt White Gold Black Mens Watch 15121BC.OO.A002CR.01 : http://www.watches-brand.com/Replica-Audemars-Piguet-19134.html Audemars Piguet Edward Piguet 18kt White Gold Black Mens Watch 15015BC.OO.D001CR.01 : http://www.watches-brand.com/Replica-Audemars-Piguet-19135.html Audemars Piguet Millenary Steel Mens Watch 25897ST.O.1136ST.01 : http://www.watches-brand.com/Replica-Audemars-Piguet-19136.html Audemars Piguet Millenary Diamond 18kt White Gold Ladies Watch 79351BC.ZZ.1137BC.01 : http://www.watches-brand.com/Replica-Audemars-Piguet-19137.html Audemars Piguet Millenary Steel Brown Mens Watch 26150ST.OO.D084CU. 01 : http://www.watches-brand.com/Replica-Audemars-Piguet-19138.html Audemars Piguet Millenary 18kt Rose Gold Mens Watch 15051OR.OO.1136OR. 01 : http://www.watches-brand.com/Replica-Audemars-Piguet-19139.html Audemars Piguet Millenary 18kt White Gold Mens Watch 15051BC.OO.1136BC. 01 : http://www.watches-brand.com/Replica-Audemars-Piguet-19140.html Audemars Piguet Millenary 18kt Yellow Gold Black Mens Watch 14908BA.OO.D001CR.01 : http://www.watches-brand.com/Replica-Audemars-Piguet-19141.html Brand Watches Audemars Piguet Edward Piguet Diamond 18kt White Gold Black Ladies Watch 77206BC.ZZ.D001CR.01 Discount, Replica, Fake Tag: LINQ with Datetime Tag: 145032
  - 12
    - Datatable beginners question: Merge and row deletions... Hi! I'm trying to use merge in order to apply differences to a table. However, I can't seem to get the hang of it. Here's the short version: I got two data tables, one containing one row and one containing no rows. What I'd hoped to do was to merge the empty one into the non-empty one and get a roe deleted event and a deleted row. Is this possible? Maybe I'm missing something simple here? This is my code: using System; namespace DataSet { class Program { static void Main(string[] args) { // Init System.Data.DataTable Old = new System.Data.DataTable("T"); System.Data.DataTable New = new System.Data.DataTable("T"); // Add columns Old.Columns.Add("X", typeof(System.Int32)); New.Columns.Add("X", typeof(System.Int32)); //Making good Old.AcceptChanges(); New.AcceptChanges(); //Add Row to Old System.Data.DataRow R=Old.NewRow(); R["X"]=0; Old.Rows.Add(R); Old.AcceptChanges(); //Merge Old.Merge(New); Old.AcceptChanges(); //Check foreach (System.Data.DataRow Row in Old.Rows) {Console.WriteLine(Row["X"].ToString()+"/"+Row.RowState.ToString());} } } } Lots of Greetings and thanks! Volker -- For email replies, please substitute the obvious. Tag: LINQ with Datetime Tag: 145028
  - 13
    - how to extract value from LINQ query? Is it possible to extract a single value from the results of a LINQ query with out iterating over the results. For example I have a table in SQL Server: tblExample Type int <--this is a key field Descr nvarchar(5) I would like to get the description (Descr) field something like this in C#: string Description = from Example in db.tblExample where Example.Type = 1 select Example.Descr; I know this query returns an IQueryable and the above query won't compile because of type mismatch. Is there a way to get the string from the database field using a LINQ query? Thanks Tag: LINQ with Datetime Tag: 145026
  - 14
    - How to gei Last ID When I write new record with INSERT INTO i need to get ID (Autonumber, key of this table) from this, just written record. How to do that in ASP.NET (VB or C#) and SQL Server? Thanks Tag: LINQ with Datetime Tag: 145023
  - 15
    - OracleDataReader in Enterprise Library 3.1 I am trying to convert my code from straight ADO.NET to the Enterprise Library 3.1 Data Access App Block. It's mostly straightforward, but I ran into a problem with datareaders. The OracleDatabase.ExecuteReader method only returns an IDataReader object, which is mostly okay, except that IDataReader does not implement HasRows. I hoped that I could get past that by casting the IDataReader to an OracleDataReader, but when I try that, I get an InvalidCastException (Unable to cast object of type 'Microsoft.Practices.EnterpriseLibrary.Data.Oracle.OracleDataReaderWrapper' to type 'System.Data.OracleClient.OracleDataReader'). Is this a bug in the Enterprise Library, because this behavior doesn't appear to make sense. I believe I read that this cast works for the SqlDataReader, but I haven't tried that yet. Any ideas? Tag: LINQ with Datetime Tag: 145021
  - 16
    - Problems with LINQ and CLR Stored Procedure Hi all, I'm having a bit of a problem with Linq and a CLR Stored Procedure. I'm just trying to fill a gridview with a simple query that depends on multiple (one to n) search terms. The sproc is as follows: ALTER PROCEDURE [dbo].[CMS_Pages_Search] @searchString varchar(500) AS BEGIN SET NOCOUNT ON EXEC clr_CMS_Pages_Search @searchString END This works fine (returning a dataset from SQL Management Studio). The VB Procedure is as follows: Protected Sub btnSearch_Click(ByVal sender As Object, ByVal e As System.EventArgs) Dim db As New migkbDataContext grdResults.DataSource = db.CMS_Pages_Search(txtKeywords.Text.Trim) grdResults.DataBind() Dim iRowCount As Integer = grdResults.Rows.Count If iRowCount > 0 Then ResultMessage1.ShowSuccess("Search returned " & iRowCount & " results") Else ResultMessage1.ShowFail("No records found for search " & txtKeywords.Text.Trim) End If End Sub From the cms_Pages_Search call, there is no Intellisense to specify ToList etc. The code generated from the *.dbml designer file is trying to return an Integer (not what I want): <FunctionAttribute(Name:="dbo.CMS_Pages_Search")> _ Public Function CMS_Pages_Search(<Parameter(DbType:="VarChar(500)")> ByVal searchString As String) As Integer Dim result As IExecuteResult = Me.ExecuteMethodCall(Me, CType(MethodInfo.GetCurrentMethod,MethodInfo), searchString) Return CType(result.ReturnValue,Integer) End Function End Class When the btnSearch_Click sub is executed, when attempting to bind the grid to the datsource, the message "Data source is an invalid type. It must be either an IListSource, IEnumerable, or IDataSource." is displayed. Anyone have any ideas what's going on or ideas to work around this? Regards Jules Tag: LINQ with Datetime Tag: 145020
  - 17
    - Problem with ADOMD.NET and Pentaho (XMLA) Dear NG, I use ADOMD to programmatically access MS Analysis Service. In collaboration with the MS SQL Server works well. I wish to use in my project next to the MS Analysis also Pentaho Analysis Services. Since both do XMLA support it shouldn't be a problem. Problems occur, however, when I try to query ADOMD Pentaho to get more than three dimensions. I have inspected the XMLA, which exchanged and found that the ADOMD client requestes another (axis) format , if more than 2 dimensions are requested and Pentaho can unfortunately not answer in this required format . my question is now whether someone ever had this issue, and whether and how it has solved. Maybe there is a possibility that the ADOMD his client requests in a different format.Otherwise, is there any chance to get Pentaho to understand the different format (axis) without a lot of implementing? Maybe there is even an adapter somewhere. I would be grateful for any tip. Best Regards, Yvette Tag: LINQ with Datetime Tag: 145019
  - 18
    - Oracle access issue from tableadapter Hi, I got error when I tried to use OLEDB for oracle provider to insert/update data in oracle 10g by sql statement or stored procedure withing a transactions scope. Basically I open a transactionscope ( TransactionScope trans = new TransactionScope(TransactionScopeOption.Required ), and initialize a tableadapter, and proceed insert and update, and set trans.complete(). At first I got error of Transaction Manager not available. I changed registry for three oralce client to piont to 10g dlls. Then I got "Exception from HRESULT: 0x8000D048", and the StackTrace is "at System.Data.Common.NativeMethods.ITransactionJoin.JoinTransaction(Object punkTransactionCoord, Int32 isoLevel, Int32 isoFlags, IntPtr pOtherOptions)\r\n at System.Data.OleDb.OleDbConnectionInternal.EnlistTransactionInternal(Transaction transaction, Boolean forcedAutomatic)\r\n at System.Data.OleDb.OleDbConnection.Open()\r\n.....". Any idea? Thanks. William Tag: LINQ with Datetime Tag: 145014
  - 19
    - ADO.Net BID tracing, EWT and Logman.exe for dummies I'm trying to enable BID tracing of ADO.Net + SQL Server 2005 as described in http://msdn2.microsoft.com/en-us/library/aa964124.aspx. I only get an empty out.etl file which contains no events. My problem I think lies in the setup/config of ewt on my system. When I run "logman.exe query providers" I get the below output which doesn't seem healthy. But I can find no sources on the web indicating what might be the matter. c:\>logman.exe query providers ************************************** Provider GUID ------------------------------------------------------------------------------- SQLOLEDB.1 {C5BFFE2E-9D87-D568-A09E-08FC83D0C7C2} MSDAPRST.1 {64A552E0-6C60-B907-E59C-10F1DFF76B0D} SQLSERVER.SNI.1 {AB6D5EEB-0132-74AB-C5F5-B23E1644DADA} MSADDS.1 {13CD7F92-5BAA-8C7C-3D72-B69FAC139A46} HTTP Service Trace {dd5ef90a-6398-47a4-ad34-4dcecdef795f} SQLSRV32.1 {4B647745-F438-0A42-F870-5DBD29949C99} WSAT Trace Provider {7f3fe630-462b-47c5-ab07-67ca84934abd} MSADCE.1 {76DBA919-5A36-FC80-2CAD-3185532B7CB1} Error: Not found The command completed successfully. ******************************* So was it successful? did it "Not find" an error? or what? I held SysInternals procmon against it and discovered that it wasn't finding the file given by HKLM\Software\Microsoft\BidInterface\Loader\:Path So I changed it from the suggested "%SYSTEMROOT%\Microsoft.NET\Framework\v2.0.50727\ADONETDiag.dll" to "Microsoft.NET\Framework\v2.0.50727\ADONETDiag.dll" and it seemed to at least find it, but things didn't improve. So I thought perhaps there was a problem with another collection so I would delete all the collections and set them up from scratch. But "Logman delete" of every collection it shows in the list above didn't seem to have any effect. "Logman query providers" still shows the same output. Any help appreciated. Tag: LINQ with Datetime Tag: 145008
  - 20
    - error that occur in StoredProcedure it's throw exception to Ado.net? I ask it before and I got this answer: ====================================================== yes errors with a certain severity level will throw exceptions in your code try this in your stored proc RAISEERROR(N'This is a message %s %d', -- message text 16, --severity 1, --state N'number', --first argument 5); --second argument and in your code you can get this error message in the SqlException object -- Misbah Arefin https://mcp.support.microsoft.com/profile/MISBAH.AREFIN http://www.linkedin.com/in/misbaharefin ======================================================= I have to ask more: the built-in errors have high level for breack the SP and throw it to .NET? if have, How I trap this error in SP to rollback my transaction or do somthing else within the SP instead thorow it immediately to .NET? Tag: LINQ with Datetime Tag: 145000
  - 21
    - SqlCommand.ExecuteReader takes too much time Hi, I have a table containing about 14,5 million records and I want to iterate over the complete data. If I execute a "select * from mytable", the call to ExecuteReader takes some hours to return. In T- SQL I can open a cursor and start reading immediately. As far as I understand, ExecuteReader/SqlDataReader should behave the same way - but it seems like I'm wrong. Any hint? regards, Achim Tag: LINQ with Datetime Tag: 144997
  - 22
    - Querying a Runtime Dataset with LINQ Hi, Can you query a run time Dataset with LINQ or must the Dataset be strongly typed? If not, how can this be simply accomplished? Many thanks for any ideas on this Ant Tag: LINQ with Datetime Tag: 144995
  - 23
    - GC.Collect() not cleaning memory, how to find out what references to lots of memory still exist? GC.Collect() not cleaning memory, how to find out what references to lots of memory still exist? When all my processign is done i set everything to null and then: GC.Collect(); and then GC.WaitForPendingFinalizers(); but it still shows that my process takes 400 MB of memory. Is there any easy way to see what references that I forgot to set to null so that the memory cleas up on GC.Collect() ? Tag: LINQ with Datetime Tag: 144992
  - 24
    - slowing/halting stored procedure from ado.net Hi, I've strange problem with an application developed with VB.NET 2008/ADO.NET framework target 2.0 and SQL Server 2005. Sometimes a certain stored procedure wich normally executes in seconds, suddenly takes forever (15minutes plus). When I execute the stored procedure from within SQL Server Management Studio it always executes fast (42000+ records in 1 second), even when from ADO.NET it takes forever. When the slowdown appears, restarting the application does not help. When I do modify/execute in man.studio, the slowdown goes away, and application does it normal quick response. Activity monitor show no blocking other queries. The stored procedure is called with a command object and an dataadapter filling a dataset. When I break the application in visual studio, it breaks on the da.fill(ds) line. I cannot find any pattern in when the slowdown starts, sometime once a week, once a day or 3 weeks without a problem. Records added to the table are about 45 records per day (mean). Can anyone shed some light on this problem?? Tag: LINQ with Datetime Tag: 144990
  - 25
    - Open Source Typed DataSet Generator Drawing a blank, even googling some keywords and still gives me either too much or too little. Basically, anyone know of any custom open source typed dataset generators for use with the 3.5 framework? I am looking for a generator that exposes the column properties as public instead of internal/friend. (wish MS would just make their generator expose these as public, would make my life a little easier). Thanks, Mythran Tag: LINQ with Datetime Tag: 144979
- Next
  - 1
    - ADOMD client I have a webserver talking to a different server hosting SQL 2005. The webserver seems to need the ADOMD client on it.. Is this a seperate install? If so, is it free to install or is there licence issues? help is appreciated. Tag: LINQ with Datetime Tag: 144970
  - 2
    - SQL Coalesce in Linq syntax How would the following SQL Coalesce statement need to be written in Linq to SQL: SELECT COALESCE(LastName, '') + ' ' + COALESCE(FirstName, '') + ' ' + COALESCE(MiddleName, '') + ' ' + COALESCE(SuffixName, '') AS ClientName, ClientID FROM tblClient WHERE LastName LIKE @Letter + '%' ORDER BY ClientName Thanks, Dean Slindee Tag: LINQ with Datetime Tag: 144962
  - 3
    - First chance exceptions Hi When running my app in vs 2008 IDE I get the below messages in the Immediate Window repeatedly. A first chance exception of type 'System.NullReferenceException' occurred in MyApp.exe A first chance exception of type 'System.Runtime.InteropServices.InvalidComObjectException' occurred in MyApp.exe A first chance exception of type 'System.IO.FileNotFoundException' occurred in System.Drawing.dll A first chance exception of type 'System.ArgumentNullException' occurred in mscorlib.dll They don't crash the app but it seems the app slows downs when one of these errors occurs. What is the problem and how can I fix tit? Thanks Regards Tag: LINQ with Datetime Tag: 144958
  - 4
    - Datatable equivalent code with OleDbDataReader Hi I have below code which is written using a datatable dt. What is the equivalent code using a OleDbDataReader? For j = 0 To dt.Rows.Count - 1 Dim dataArr(dt.Columns.Count) As String For i = 0 To dt.Columns.Count - 1 dataArr(i) = dt.Rows(j)(i) Next Next Thanks Regards Tag: LINQ with Datetime Tag: 144954
  - 5
    - OleDbDataReader to datatable Hi Sorry, I am new to this. Is there a way to cerate a datatable from a OleDbDataReader? Thanks Regards Tag: LINQ with Datetime Tag: 144953
  - 6
    - error that occur in StoredProcedure it's cause exception or not? error that occur in StoredProcedure it's cause exception or not? and when I need to use with @@error? Tag: LINQ with Datetime Tag: 144952
  - 7
    - Tracking source of web service call Hi, I hope I'm posting this in the right group. I have a shared .net 1.1 web service that is accessed by many applications across multiple sites. I was wondering if there is an enterprise level tool that I could use to identify the source application (virtual directory of the originator, etc.). The IIS logs do not give me this information just the C-IP which is our web server, the CS-HOST which is our web services VIP, and the CS-Referrer which is blank. Any ideas? Tag: LINQ with Datetime Tag: 144948
  - 8
    - Designer generated code fails to compile I have a project whose default name space is Wearther and form in the project which is in this default namespace. I have also generated a dataset and adapters to access a table in a database. I am using as a datasource this dataset via the generated DatasetBindingSource. The problem is that the code the designed generates includes the lines this.wEATHERDETAILSTableAdapter = new Weather._WeatherDetailsDataSetTableAdapters.WEATHERDETAILSTableAdapter(); this._WeatherDetailsDataSet = new Weather._WeatherDetailsDataSet(); which explicitly specify the Weather namespace although the class is actually in this namespace and so the compilation fails unless I remove the namespace qualification by hand. How do I stop the designer from setting the namespace explicitly. Thanks Pat Tag: LINQ with Datetime Tag: 144939
  - 9
    - Slow app response Hi I have replaced an ms access app with its vb.net version at a client site. Now the clients keeps complaining about how slow the app response is. The complains they have are for example when app is minimised and then trying to maximise it after a while takes a while for app to get maximised. Also form painting of controls is slow and app is generally slow in terms of response to user clicks. I am using Infragistics controls and my feeling is that makes the app bit sluggish compared to the original controls shipped with vs 2008 but I need the Infragistics controls for their features. I have also ngen'd the app but surprisingly only the main app executable gets ngen'd and not any of the dependency dlls such as Infragistics dlls. Are there any tips to make app response better for user? Thanks Regards Tag: LINQ with Datetime Tag: 144937
  - 10
    - Inherited DataTable Serialization Problem in WCF Any help would be greatly appreciated. I am using WCF (3.0) to provide a services layer sitting on a server between a web server hosting ASP.NET 2.0 and SQL Server 2005. Some of these services provide a strongly typed inherited DataTable for the ASP.NET application. Below is a partial listing for one such DataTable. The code compiles successfully, and the service which returns this DataTable seems to start normally. A problem arises when using Add Service Reference in Visual Studio to generate a client class to communicate with the service. The error below the listing results when this generation is attempted. The most informative message in the error seems to be: "Schema type 'Components.DataStructures:EquipmentList' returned by CLR type 'Components.DataStructures.EquipmentList' is not found in the XmlSchemaSet." This says to me that in my class's GetXmlQualifiedName method, the schema for the EquipmentList class is not being added to XmlSchemaSet passed in by System.Runtime.Serialization.SchemaExporter.ExportXmlDataContract. To test this, I created a simple Windows form with a button which executed the following code: XmlSchemaSet xss = new XmlSchemaSet(); EquipmentList.GetXmlQualifiedName(xss); I checked the Count of xss.Schemas() before the static method on EquipmentList was called, and it was 0 as expected. I checked it after this method was executed and it was 1, also as expected. Further, 'Components.DataStructures:EquipmentList' did indeed exist in xss. In the quick watch window, the QualifiedName of the only schema is Components.DataStructures:EquipmentList. If it is there correctly when executed with this simple test code, I would expect the schema to be properly included in the XmlSchemaSet when called by System.Runtime.Serialization.SchemaExporter. Why am I getting this error? Am I misunderstanding the error, or is there something wrong in how I have tested my code? Any help to resolve this error is appreciated. INHERITED DATATABLE CODE [XmlSchemaProvider("GetXmlQualifiedName")] [Serializable] public class EquipmentList : DataTable, IXmlSerializable { private static string _tableName = "EquipmentList"; private static string _namespace = "Components.DataStructures"; private static XmlSchema _schema; . . . public EquipmentList():base(_tableName, _namespace) { Initialize(); } . . . private void Initialize() { _equipmentId.AllowDBNull = false; _name.AllowDBNull = false; _category.AllowDBNull = false; _type.AllowDBNull = false; base.Columns.Add(_equipmentId); base.Columns.Add(_name); base.Columns.Add(_category); base.Columns.Add(_type); if (_schema == null) { _schema = base.GetSchema(); } } . . . System.Xml.Schema.XmlSchema IXmlSerializable.GetSchema() { throw new System.NotImplementedException(); } void IXmlSerializable.ReadXml(System.Xml.XmlReader reader) { base.ReadXml(reader); } void IXmlSerializable.WriteXml(System.Xml.XmlWriter writer) { base.WriteXml(writer, XmlWriteMode.DiffGram); } public static XmlQualifiedName GetXmlQualifiedName(XmlSchemaSet xss) { if (_schema == null) { // Schema is set when an instance is created, so create // an instance if the schema is not yet set EquipmentList list = new EquipmentList(); } xss.Add(_schema); return new XmlQualifiedName(_tableName, _schema.TargetNamespace); } } SERVICE CLIENT GENERATION ERROR Error: Cannot obtain Metadata from net.tcp://localhost:52000/ComponentProviderListService/mex If this is a Windows (R) Communication Foundation service to which you have access, please check that you have enabled metadata publishing at the specified address. For help enabling metadata publishing, please refer to the MSDN documentation at http://go.microsoft.com/fwlink/?LinkId=65455. WS-Metadata Exchange Error URI: net.tcp://localhost:52000/ComponentProviderListService/mex Metadata contains a reference that cannot be resolved: 'net.tcp://localhost:52000/ComponentProviderListService/mex'. <?xml version="1.0" encoding="utf-16"?><Fault xmlns="http://www.w3.org/2003/05/soap-envelope"><Code><Value>Receiver</Value><Subcode><Value xmlns:a="http://schemas.microsoft.com/net/2005/12/windowscommunicationfoundation/dispatcher">a:InternalServiceFault</Value></Subcode></Code><Reason><Text xml:lang="en-US">An exception was thrown in a call to a WSDL export extension: System.ServiceModel.Description.DataContractSerializerOperationBehavior contract: http://tempuri.org/:IComponentProviderListService</Text></Reason><Detail xmlns:s="http://www.w3.org/2003/05/soap-envelope"><ExceptionDetail xmlns="http://schemas.datacontract.org/2004/07/System.ServiceModel" xmlns:i="http://www.w3.org/2001/XMLSchema-instance"><HelpLink i:nil="true"></HelpLink><InnerException><HelpLink i:nil="true"></HelpLink><InnerException i:nil="true"></InnerException><Message>Schema type 'Components.DataStructures:EquipmentList' returned by CLR type 'Components.DataStructures.EquipmentList' is not found in the XmlSchemaSet.</Message><StackTrace> at System.Runtime.Serialization.SchemaExporter.ExportXmlDataContract(XmlDataContract dataContract) at System.Runtime.Serialization.SchemaExporter.ExportDataContract(DataContract dataContract) at System.Runtime.Serialization.SchemaExporter.Export() at System.Runtime.Serialization.XsdDataContractExporter.Export(Type type) at System.ServiceModel.Description.MessageContractExporter.ExportType(Type type, String partName, String operationName, XmlSchemaType& xsdType) at System.ServiceModel.Description.DataContractSerializerMessageContractExporter.ExportBody(Int32 messageIndex, Object state) at System.ServiceModel.Description.MessageContractExporter.ExportMessage(Int32 messageIndex, Object state) at System.ServiceModel.Description.MessageContractExporter.ExportMessageContract() at System.ServiceModel.Description.DataContractSerializerOperationBehavior.System.ServiceModel.Description.IWsdlExportExtension.ExportContract(WsdlExporter exporter, WsdlContractConversionContext contractContext) at System.ServiceModel.Description.WsdlExporter.CallExtension(WsdlContractConversionContext contractContext, IWsdlExportExtension extension)</StackTrace><Type>System.Runtime.Serialization.InvalidDataContractException</Type></InnerException><Message>An exception was thrown in a call to a WSDL export extension: System.ServiceModel.Description.DataContractSerializerOperationBehavior contract: http://tempuri.org/:IComponentProviderListService</Message><StackTrace> at System.ServiceModel.Description.WsdlExporter.CallExtension(WsdlContractConversionContext contractContext, IWsdlExportExtension extension) at System.ServiceModel.Description.WsdlExporter.CallExportContract(WsdlContractConversionContext contractContext) at System.ServiceModel.Description.WsdlExporter.ExportContract(ContractDescription contract) at System.ServiceModel.Description.WsdlExporter.ExportEndpoint(ServiceEndpoint endpoint, XmlQualifiedName wsdlServiceQName) at System.ServiceModel.Description.WsdlExporter.ExportEndpoints(IEnumerable`1 endpoints, XmlQualifiedName wsdlServiceQName) at System.ServiceModel.Description.ServiceMetadataBehavior.MetadataExtensionInitializer.GenerateMetadata() at System.ServiceModel.Description.ServiceMetadataExtension.EnsureInitialized() at System.ServiceModel.Description.ServiceMetadataExtension.WSMexImpl.GatherMetadata(String dialect, String identifier) at System.ServiceModel.Description.ServiceMetadataExtension.WSMexImpl.Get(Message request) at SyncInvokeGet(Object , Object[] , Object[] ) at System.ServiceModel.Dispatcher.SyncMethodInvoker.Invoke(Object instance, Object[] inputs, Object[]& outputs) at System.ServiceModel.Dispatcher.DispatchOperationRuntime.InvokeBegin(MessageRpc& rpc) at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage5(MessageRpc& rpc) at System.ServiceModel.Dispatcher.MessageRpc.Process(Boolean isOperationContextSet)</StackTrace><Type>System.InvalidOperationException</Type></ExceptionDetail></Detail></Fault> Please excuse me for crossposting this here and (yesterday) on the dotnet.xml group. I have not been able to find an MSDN Managed group for WCF specifically and am guessing about the most appropriate group to post this to. Tag: LINQ with Datetime Tag: 144935
  - 11
    - export to csv Hi Is there a way to export the records from a datareader into a csv file? Thanks Regards Tag: LINQ with Datetime Tag: 144933
  - 12
    - Calling a form in second project Hi Can I run a from in one project from a second project, both projects being in the same solution? Thanks Regards Tag: LINQ with Datetime Tag: 144930
  - 13
    - PerformanceCounterCategory.Create() takes 3 minutes to add a new category!! How come? What can cause this? PerformanceCounterCategory.Create() takes 3 minutes to add a new category!! How come? What can cause this? Tag: LINQ with Datetime Tag: 144929
  - 14
    - Problem binding dataset to several controls on a Winform Hi; I have a dataset containing two tables which are related the primary table is bound to a Nav control an two one grid view and the relationship of the second table is bound to a second gridview. I also have two textbox controls which I use to look up records in either table two, or table one. My problem is that if I do a lookup in table two it retrieves that record and displays it, but the relationship is lost, so the corresponding record in table one is not displayed in it's gridview. Also I lose my orginial navagation coordination between the first dataset and the two gridviews. Here is a little code that I use for the lookup and also a procedure that I thought would restore the original gridview behavior. LOOKUPS Private Sub ToolStripButton1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ToolStripButton1.Click ' Look up branch Try Me.Branch_CodesTableAdapter.LookUpBranch_Matches(Me.TCMS_TempDataSet1.Branch_Codes, ToolStripTextBox1.Text) Me.Branch_CodesBindingSource.DataSource = Me.TCMS_TempDataSet1.Branch_Codes Me.Branch_managerDataGridView.DataSource = Me.TCMS_TempDataSet1.branch_manager Catch ex As Exception MessageBox.Show(ex.Message) End Try End Sub REFRESHES Gridviews Private Sub RefreshData() Try Me.TCMS_States_DS.Clear() Me.StatesTableAdapter.Fill(Me.TCMS_States_DS.States) Me.TCMS_TempDataSet1.Clear() Me.Branch_CodesTableAdapter.Fill(Me.TCMS_TempDataSet1.Branch_Codes) Me.Branch_managerTableAdapter.Fill(Me.TCMS_TempDataSet1.branch_manager) ToolStripTextBox1.Text = "" ToolStripTextBox2.Text = "" Catch ex As System.Exception MessageBox.Show(ex.Message) End Try End Sub Thanks for any suggestions ! -- Gordon Tag: LINQ with Datetime Tag: 144928
  - 15
    - Should a LINQ DataContext be created for each query? As in these examples, referring to the first line of code in each set. Would a form-level only datacontext be wise? If a form did many Select queries against the same table, would one datacontext suffice for all the Select queries? Query: Dim dc As New dcAdminDataContext Dim query = From tblAdminAddressType In dc.tblAdminAddressTypes _ Order By tblAdminAddressType.AddressTypeID _ Select tblAdminAddressType Delete: Dim dc As New dcAdminDataContext Dim delete = From tblAdminAddressType In dc.tblAdminAddressTypes _ Where tblAdminAddressType.AddressTypeID = Trim(txtAddressTypeID.Text) _ And tblAdminAddressType.Guid = guid If delete.Count > 0 Then For Each tblAdminAddressType In delete dc.tblAdminAddressTypes.DeleteOnSubmit(tblAdminAddressType) Next dc.SubmitChanges(Data.Linq.ConflictMode.FailOnFirstConflict) Else Throw New Data.Linq.ChangeConflictException End If Insert: Dim dc As New dcAdminDataContext Dim insert As New tblAdminAddressType With insert .AddressTypeID = AddressTypeID .AddressTypeName = Trim(txtAddressTypeName.Text) .Inactive = CType(Trim(cboInactive.Text), Char) .InactiveDate = IIfNothingDate(txtInactiveDate.Text) .EffectiveDate = IIfNothingDate(txtEffectiveDate.Text) .AuditLog = AuditLog .Guid = newGuid End With dc.tblAdminAddressTypes.InsertOnSubmit(insert) dc.SubmitChanges(Data.Linq.ConflictMode.FailOnFirstConflict) Update: Dim dc As New dcAdminDataContext Dim update = From tblAdminAddressType In dc.tblAdminAddressTypes _ Where tblAdminAddressType.AddressTypeID = Trim(txtAddressTypeID.Text) _ And tblAdminAddressType.Guid = guid If update.Count > 0 Then For Each tblAdminAddressType In update With tblAdminAddressType .AddressTypeID = AddressTypeID .AddressTypeName = Trim(txtAddressTypeName.Text) .Inactive = CType(Trim(cboInactive.Text), Char) .InactiveDate = IIfNothingDate(txtInactiveDate.Text) .EffectiveDate = IIfNothingDate(txtEffectiveDate.Text) .AuditLog = AuditLog .Guid = newGuid End With Next dc.SubmitChanges(Data.Linq.ConflictMode.FailOnFirstConflict) Else Throw New Data.Linq.ChangeConflictException End If Tag: LINQ with Datetime Tag: 144927
  - 16
    - Hide data object property VS2005 pro The short question is this: How do I hide public properties of my class from binding in a datagrid for example. Setting <Browsable(false)> will not work since I have to bind to these properties in some win forms. In need the property available when binding, but not to display in grids. Here is the detail: I have custom data classes for my business objects. Amoungst the properties are other "nested" child objects like this: Class Invoice public property ID as Integer get ... set ... end property ... more properties public readonly property InvItems as InvoiceItems get ... end property end class Normally I would have a BindingSource bound to Invoice and then another BindingSource bound to Invoice.InvItems. All is ok so far, but when I load this object into a DataTable the InvItems object is included which I do not want. I can get rid of it by deleting the Column, but I would rather do it in the object itself using an attribute. I have tried to set the unwanted property with the attribute <Browsable(False)>, but then I cannot bind to it at runtime. So I need some other attribute or method to acomplish this. The only thing I can think of is a custom attribute. Any other ideas? Regards, Rick Tag: LINQ with Datetime Tag: 144922
  - 17
    - (oracle) problem with variable in 'in' condition Hi everybody ! I have a problem with a Select procedure in package. I have a condition like : select ..... from .... where blahblah in (myvariable).. 'myvariable' is like : 1001, 1002, 1003, .... I have an exception with the OracleDataAdapter : ORA-01002: fetch out of sequence do you have an idea ? Thanks by advance. Ju Tag: LINQ with Datetime Tag: 144919
  - 18
    - Varbinary col in datatable Using SQL Server 2005, Visual Studio 2005 (8.0.50727.762) Framework 2.0.50727 SP1 I have a varbinary column in my database. I am trying to set the DataColumn.DataType in the dataset designer to byte[] but it is not in the selection list. I tried changing it in the xxxxx.Designer.cs file but of course the changes were lost when the project was re-built. What is the solution? Can I code this.columnMissionStatusImage = new global::System.Data.DataColumn("MissionStatusImage", typeof(byte[]), null, global::System.Data.MappingType.Element); in the .cs file? If so, what event do I put it in? Tag: LINQ with Datetime Tag: 144915
  - 19
    - linqdatasource runtime connection string I want to set the connection string to use at runtime for my linqsql datacontext. I am using the dbml or mapper in Visual Studio. The way I created objects was by dragging objects from the server explorer onto the design surface. When I dragged the first object it made a connection string in my web.config called: XXX with integrated security. I want the datacontext to use connection YYY which I have in the web.config. If I change the Connection property in the dataContext object the next time I add something to the designer it forces me to change the connection string back to XXX. My connection strings in the web.config get changed by MsBuild for test and release. I am really worried that someone will make a change to the DataContext designer and the connection string will get set to XXX for use in Production. Is their a good way to work around this? Tag: LINQ with Datetime Tag: 144912
  - 20
    - How to to handle a set that had a row added and then deleted before Adapter Update? I have a scenario where I am processing a batch of changes to a table. The changes can result in an Insert or a Delete. So I Fill a DataSet with the table's current contents, then I process the changes, then call Update on my SqlAdapter. Psuedo Code: Fill(DataSet, MyTable) Foreach( Statement in UpdateCollection) { Foreach(Row in DataSet.Tables[MyTable].Rows) { if(Statement matches Row & !found) Row.Delete() found=true } if(!found) DataSet.Tables[0].Rows.Add(NewRowFromStatement) } Update(DataSet, MyTable) Unfortunately, there is a small chance that two records in the current batch of changes are related, basically one record will be the delete for one of the inserts in the update collection and this seems to cause a host of problems I cannot get arround. If I call Update, then since the Deleted row never had an original version the DeleteCommand can't find an original row to delete from the source table and throws an exception (Deleted 0 rows, expected 1). I had thought maybe if I found a row that was state Added and I needed to Delete it I could just call Remove, or AcceptChanges->Delete->Acceptchanges to cause the row to essentially disappear from the scope of the update. But this blows up the enumeration since it alters the Rows collection. I think my only option is to add a new column to my table MarkedForDelete and change the code to only Add and Update then make a seperate process to cull rows marked for delete asynchronously. Any tips? Thanks, Jason Tag: LINQ with Datetime Tag: 144911
  - 21
    - Re: Batch updates on generated TableAdapters throws Set the UpdatedRowSource property of your command to UpdateRowSource.None command.UpdatedRowSource = UpdateRowSource.None; Tag: LINQ with Datetime Tag: 144910
  - 22
    - SqlParamater where type=SqlDbType.VarChar allows a size of -1!!! I've just finished writing some unit tests to test some SqlParameter functions I created for a DAL helper class. I have included the base version of the method below. One of the tests I wrote is a boundary test and checks to make sure a size of -1 throw an 'ArgumentOutOfRange' exception. For some reason, it does not....however, anything less than -1 does. Does anyone know why? BTW: I'm using .Net 2.0 and Ado.NET public SqlParameter createStringParameter(string paramName, int size) { SqlParameter result = new SqlParameter(paramName, SqlDbType.VarChar); result.Size = size; result.Value = DBNull.Value; return result; } Cheers, Ed Tag: LINQ with Datetime Tag: 144907
  - 23
    - Anyone know of a Silverlight newsgroup? I am looking for a Silverlight newsgroup, I can't find one on news.microsoft.com. Thanks Brian K. Williams Tag: LINQ with Datetime Tag: 144903
  - 24
    - How to make CLR stored procedure generate comments in TSQL when it is deployed via visual studio? How to make CLR stored procedure generate comments in TSQL when it is deployed via visual studio? e.g. when i right click the project and hit deploy, i want some comments to appear in or around the SQL wrapper that calls the CLR function. Tag: LINQ with Datetime Tag: 144894
  - 25
    - Call Dispose on OleDbCommand? 1. Should you explicitly call Dispose on OleDb objects like OleDbCommand or OleDbConnection? 2. In VB.NET for the keyword USING (as in "Using cn As New OleDbConnection(...)...") Should you explicitly call the Close method on the OleDbConnection object or will the object be closed and disposed automatically once the Using block is exited? Thanks for your insights. Tag: LINQ with Datetime Tag: 144892

Hi,
How can I use a date string to test a date in a LINQ query.
Below is a query in Northwind

Many thanks for any help

Ant

NorthwindDataContext db = new NorthwindDataContext();

var resultSet = from o in db.Orders
where o.OrderDate >= Convert.ToDateTime("20080601")
select o;

Top

Re: LINQ with Datetime by Miha

Miha
Wed Apr 23 12:41:49 CDT 2008

Not sure what are you asking for....
Can you provide some more details?
What's wrong with your code (except for the fact that you should use new
DateTime(2008, 6, 1) instead)

--
Miha Markic [MVP C#, INETA Country Leader for Slovenia]
RightHand .NET consulting & development www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/

"Ant" <Ant@discussions.microsoft.com> wrote in message
news:D5CFD66A-93F9-468D-A3D3-AA7E17AD2F53@microsoft.com...
> Hi,
> How can I use a date string to test a date in a LINQ query.
> Below is a query in Northwind
>
> Many thanks for any help
>
> Ant
>
> NorthwindDataContext db = new NorthwindDataContext();
>
> var resultSet = from o in db.Orders
> where o.OrderDate >= Convert.ToDateTime("20080601")
> select o;
>

Top