There's more than one place to put .DLL's. GetFolderPath[^] and the Environment.SpecialFolder Enumeration[^] A guide to posting questions on CodeProject[^] Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic      2006, 2007, 2008

ok stupid question - just googled VARBINARY(MAX) thanks for that it seems to fit what I neeed Martin life is a bowl of cherries go on take a byte

hey thanks luc thats another good idea Martin life is a bowl of cherries go on take a byte

hi, thanks for that c# seems to be the next comming thing but argh I find it cumbersome to read!! I have programmed in Delphi, RPG , C++ , VBA , VB etc but c# just seems - ugh! cant place why though - maybe its too much like javascript - maybe I dont like braces!! (tell me why! I dont like mon.... er sorry cant get that tune out my head) I will probably trickle into it eventully. Of course it doesnt help if your company is currently a VB shop - anyhoo... you havent seen any good online articles have you?? thanks martin life is a bowl of cherries go on take a byte

Actually what I want to do is pass a dataset to the GUI holding say Select * from Customers. then use the User input and build a Dataset/DataView Filter on the returned dataset so no SQL injection but its a good warning. thanks also in this app , some data will come from SQL DB and other data from Oracle DB so I have written a middleware layer which will retrieve the data but I dont want to use stored procedures at the DB level when my middleware is currently generic enough to handle both DB's via "standard" SQL. thanks Martin life is a bowl of cherries go on take a byte

Dave Kreskowiak wrote: replace the standard OnPaint drawing code with your own hi, I have added this to the properties grid onpaint event Protected Overrides Sub OnPaint(ByVal pevent As PaintEventArgs) ' MyBase.OnPaint(pevent) Dim g As Graphics = pevent.Graphics Dim gradBrush As System.Drawing.Drawing2D.LinearGradientBrush gradBrush = New System.Drawing.Drawing2D.LinearGradientBrush(New Point(0, 0), New Point(Me.Width, Me.Height), Color.Green, Color.Blue) ' g.FillRectangle(gradBrush, 0, 0, Me.Width, Me.Height) g.FillRectangle(gradBrush, pevent.ClipRectangle) End Sub and I expected the control contents to vanish and be replaced with a gradient colour but nothing happened. does this mean each cell has its own onpaint function?? if so how do I find them ??? Dave Kreskowiak wrote: Is it worth it? yes if I can - I am trying to have a consistant look n feel in my gui app. of course scroll bars seem to be a problem because I cant find where to cheange them either. so yes any help would be appreciated Martin thanks Martin life is a bowl of cherries go on take a byte

Hello, The lpsource stream I am populating with the string defined by objMail.Fields(CdoPR_RTF_COMPRESSED).Value which is the compressed RTF stream of the Mail item as extracted by CDO - hence the Open and writeText Its values in my example is "C9020000750400004C5A46759FA2E86903000A0072637067313235163200F80B606E0E103033334F01F702A403E3020063680AC073F0657430200713028300501066187072710E5010D85461689B037102807D0A8008C8203B096FED0E3035028014322A09B009F00490D4617405B1520DE068098001D00020352E35302E3939922E01D0303902805C760890A4776B0B8064340C606300503D0B036312020BC50F0201D035370F0AA20A811A2011516E79206F6E7417A005C01730700DE0042079A10860206775790420770070FB05400B80630A4001000B311B831B739B139017A0200AC005406F661D50526F047020620AC062059075F90B80673F20F01E8A1A131B7703C17C31381AD30F4205D01F910B8020CA4B09F0640510636B033000A05122D136284C022064022029030C4022B42020782038361E311B561A9F21670B036C6933DE36014012B01C5005907411F42500FC205F2A6F2B7F2C280AE30A8229740729410B132976692D3134343D27416922F018900CC12F4362205A4603613A03300C9262115043F1036075742C24101C302D3630701B066002303A30F626014A756CCB1C301881373370353A18A0322774546F32F75308902080032053187570700911322875626A8B29A132F74116D164612002107F05C00780113020C11C4003A0309069653890793227496D3682007063C26532F74869676827EC2D CF1F29A229040BB538451E8A2A2050E3036037822055703890299010B0D33FF50800616400C07033F418819323003FF64D4D3FE641751D60967305400460761F7028410540386C65614451031003206B6EDA6F07E07717A003A04A457245307620097041F02036601CA11CA068ED04002036800B807425903FF523B1F524902D07B34310F00F201F7119505F13900790054029613B2064087065EF1E8A1C1F1D2F1E3320211B31E02317FF212B25E331E1317324B52620252626307E380E404FA025B30C011E99142100015440" {String} The lptarget stream I assumed was going to be populated by the uncompressed version of the text. I read somewhere the ADODB.Stream was in effect a derived istream and could be used like that. Is that true? with your changes added , the API complained about an unopen lptarget stream so I added an lptarget.open now when I run it I get no error number but the lptarget.size is 0 any ideas?? Thanks Martin life is a bowl of cherries go on take a byte

Hello!!!!!!!!!!!!!!!!!!!!!!!!!!!! anyone there!!!!!!!!!!!!! yoohoo!!!!!!!!!!! life is a bowl of cherries go on take a byte

wow I never knew that existed NET is getting bigger and bigger - sigh - brain overload!! Thanks for that - very interesting Martin life is a bowl of cherries go on take a byte

yup - in a nutshell- couldnt find the correct search criteria on CP though. do you where the app skinning example is?? thanks