microsoft.public.dotnet.framework.adonet | Forum profile

  Hi Gregory I need to do this at runtime as there are two many options to add at design time. Thanks Regards "Gregory A. Beamer" <NoSpamMgbworld@comcast.netNoSpamM> wrote in message news:7DAA3EDF-74DF-435D-B085-B7CA2D068C46@microsoft.com... > Open the DataSet in the designer and right click on the table in question. > you can then choose to add a new command. Add each command you desire,...

   

  Cor Ligthert[MVP] wrote: > John, > > In my idea do you first have to determ what is the next in those > collections, I'm not sure if it means the same as I was also about to write: If you have company type: 1, name: Ligthert company type: 1, name: Ligthert which is the first and which the second? That's what you, John, have to determine first. Armin  

  John, At least I can not imagen any thing you mean by your problem. Can you show us the Transactcode Cor "John" <info@nospam.infovis.co.uk> wrote in message news:OemiVSYcJHA.4480@TK2MSFTNGP06.phx.gbl... > Hi > > I need to add additional SELECT commands to dataadapter that take various > filter and order by parameters. How do I add these additional commands to > the...

  The (obsolete) DataAdapter can only accept on SelectCommand. While that Command can contain several SELECT statements and these can have multiple Parameters, it returns one resultset and generates one DataTable for each rowset returned. I expect what you need is a TableAdapter. This class can have several Fill methods that can be programmed to return a rowset/DataTable given different SELECT statements (as long as the same columns...

  Open the DataSet in the designer and right click on the table in question. you can then choose to add a new command. Add each command you desire, one by one, and you are done. While this is not a precise answer to your question, there is a step-by-step for creating new queries in this blog entry: http://gregorybeamer.spaces.live.com/Blog/cns!B036196EAF9B34A8!974.entry -- Gregory A. Beamer MVP: MCP: +I, SE, SD, DBA Blog:...

  Hi!!! i need to show report from database (I use MicrosortReportViewer) by insert a date to textBox and press on Query How can i use the date from the textBox in the query i try SELECT מזהה, id, last_name, first_name, num_car, insurance_type, insurance_company, end_insurance, num_file, phone, mobile, address, city, reference_company, reference_type FROM phon WHERE (end_insurance = textBox1.Text) it's not good  

  On 01/01/2009 in message <a6ca3628-b7a7-4a45-be05-ac3900b06d47@v5g2000prm.googlegroups.com> menidavid@gmail.com wrote: >WHERE (end_insurance = textBox1.Text) textBox1.Text is a string, try converting it to a DateTime. I always use integers for this sort of thing - calculate the number of days from a fixed start date when adding/updating a record and keep it in the DB as an integer. It overcomes any differences...

  In a SqlCommand array, I would just use a Clear command. -- Dmitry http://www.svarga.biz From http://www.developmentnow.com/g/7_2005_7_0_0_568239/SqlParameter-error.htm Posted via DevelopmentNow.com Groups http://www.developmentnow.com/g/  

  Where you can add a touch of romance to success and achievement! Find your perfect match at free of cost FREE SIGN UP Verify Photos/Age Verify Education Verify Occupation Contact 1,072,566 quality members now! http://www.marriagedatabank.com