Re: How to write long string sentences

From: Felipe Blin (felipeblin_at_hotmail.com)
Date: 03/16/04 

Date: Tue, 16 Mar 2004 12:46:23 -0400

Hi jay,
I know what your are talking about. The problem if for those cases (they
always exist in complex systems) where that kind of solution is not good
enough or definitely not possible.
So what I want is a way to manage long string manipulation.
Thanks anyway
"Jay B. Harlow [MVP - Outlook]" <Jay_Harlow_MVP@msn.com> wrote in message
news:%23v9Z2B3CEHA.2616@TK2MSFTNGP12.phx.gbl...
> Felipe,
> My first choice would be a Stored Procedure.
>
> Whether or not a stored procedure was an option, within my code I would
use
> a data command object placed on an Component to manage my SQL statements
> (either stored procedure calls or straight SQL statements such as your
> select).
>
> You use "Project - Add Component" to add a new component to your project.
>
> Using the visual designer of the Component you can then drag the
Connection,
> Command, and DataAdapter objects that you want to it from the Toolbox.
> Alternatively you can drag & drop items from the Server Explorer. You can
> set properties of these with the properties window. Using the visual
> designer & property window of the component will allow you to use a visual
> query designer on the SQL statement itself (similar to the query builder
in
> Access).
>
> Then from the Code Behind I add any methods that I want exposed via the
> Component. Such as a Fill & Update that calls all of the contained
> DataAdapters to fill or update the selected DataSet.
>
> Hope this helps
> Jay
>
>
> "Felipe Blin" <felipeblin@hotmail.com> wrote in message
> news:%23y0T371CEHA.2616@TK2MSFTNGP12.phx.gbl...
> > Hi,
> > Sorry for this newbie question.
> > I usually have to write long string sentence like this:
> >
> > strSQL= " select ........." _
> > + " from ......." _
> > + " where ....." _
> > + " and....." _
> > + " and ..." _
> > + " group by..."
> > etc....
> > (Note: I can not use store procedure)
> > This kind of sentence is hard to maintain and to write.
> > Is there a way to do it better??
> > Thanks
> > Felipe Blin
> >
> >
> >
>
>

Relevant Pages

  • Re: How to write long string sentences
    ... Whether or not a stored procedure was an option, within my code I would use ... a data command object placed on an Component to manage my SQL statements ... Using the visual designer of the Component you can then drag the Connection, ... set properties of these with the properties window. ...
    (microsoft.public.dotnet.languages.vb)
  • RE: Databinding error using LINQDatasource with stored procedure
    ... SPROC from server explorer to the dbml file designer window and dragging it ... check the GetproductsResult class. ... procedure in the designer by dragging the stored procedure from the Server ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Looking for Comments on Code
    ... I was talking about capability of LINQ to SQL designer to create wrapper methods for stored procedure invocation IOW it creates a C#/VB method with all the parameters that sp expects. ... "Jonathan Wood" wrote in message ... I preffer doing a strong typed approach - i.e. use a code generator (think CodeSmith, or LINQ Designer if you work with VS2008) that generates strong typed methods for me. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: ASP.NET 2.0 Themes are not WYSIWYG
    ... I don't ever see the designer load the ... > I have a skin file where I define WebPartZone's WebPartVerbRenderMode to ... > the properties in the properties window accordingly. ... Maybe simpler controls implement this ...
    (microsoft.public.dotnet.framework.aspnet)
  • Where The Hell is My Stored Procedure?
    ... I created a non result returning query using the Dataset Designer that ... titled QueriesTableAdapter with the stored procedure name in the box. ...
    (microsoft.public.dotnet.languages.vb)
Loading