Search results for query: *

Hi Jason, This does exactly the same as before. If its a large file is looks like its taking the whole file into memory. Also, the file will be on a remote client machine, so we cant refer to the file with a path. So the only options I can think of are to: 1) Upload the file (using a...

Hi Jason, I still a bit confussed ..How do you just read the first line and then dispose of the file? could you provide sample code? (vb or c#). thanks

Hi, I am trying to open a remote file to read the header row to establish which columns the file has. The code below works but takes ages with a large file. I have a feeling the whole files contents is being read into memory? Is it possible to read a header row of a remote file without...

thanks!

thanks but I need this to specifically be a string byte array. :-/ i.e MySByteArray() as sByte you cant use .GetBytes(s) for sByte arrary. ..pulling my hair out...still..

Hi, vs2005. how do I convert a string to a string byte array? thanks

hi, It is possible to connect a SQL server 2005 db to an oracle db over the internet and specifically over HTTPS? i.e. is it possible to set up a linked server (or equivalent) between the 2 dbs (not on the same network) to communicate securely over the internet? The remote oracle db would...

Hi there, I am using VS2005 - .NET framework 2. I have 2 textboxes on a form: - txtEmailAddr - txtCustomerNumber I need to be able to validate that either 1 is populated. I can find lots of examples of validating all fields seperately i.e. : <asp:textbox id="txtEmailAddr" runat="server"...

hi, vb.Net 2005. I need to be able to convert an array to an array list. is this possible? If possible, an example would be great. thanks david

Hi, VS.NET 2005 - Visual Basic I have just written my first Webservice and have exposed a couple of funtions/subs using: <WebMethod()> Public Sub Finish(ByVal JobID As Integer, ByVal JobStatus As JobStatus) I would like to expose a class also and its public properties. Is it possible to do...

thanks earthandfire. ..this is pretty much the way it has to be done. 1st loop through the whole file and note where the changes will be made - then re-write the entire file. thanks again

thanks - This doesnt quite work - it just appends the changed line to the end of the file. This is what I need: If we had a file like this.. http://www.line1 http://www.line2 http://www.test3 http://www.line4 we would get this result: http://www.line1 http://www.line2 http://www.xxx3...

Hi, Using VB.NET 2005. I am trying to create a sub which loops through each line in a text file and does a string replace on a certain word. The sub also needs to log the line number/s which have changed and write these to a log file. All the examples I have seen so far use the following...

ok... well if I make this schema binding then this cuases a lot of heartache in other areas - i.e. replication. will have to find a work around for this. thanks

Hello, I have a view created from a Pivot. I am trying to create an index on this view but get the following error: Cannot create index on view 'testview' because the view is not schema bound. It is possible to create an index on view which is created from a pivot? Thanks David Here is...

works a treat. thanks.

Hello, I have a sub which I need to be able to pass an exception. Public Sub WriteLog(Optional ByVal Exception As Exception) This Exception needs to be an optional input parameter. Optional parameters require a defualt value. If this is where I am having the problem. I do not know how to...

thanks for your suggestions. Was actually a number of issues in the end - but now works. thanks FROM SalaryReport INNER JOIN EffectiveDate_Max ON (SalaryReport.EmployeeID=EffectiveDate_Max.EmployeeID) AND (SalaryReport.EffectiveDate=CDATE(EffectiveDate_Max.EffectiveDate));

Hi there, using Access 2003. I am use to using T-SQL (sql server). I am having problems joining 2 tables with 2 conditions in the join. in t-sql the following would work fine: SELECT x,y,z FROM table1 INNER JOIN table2 on (table1.memberid = table2.memberid AND table1.Date =...

Hi onpnt, Im not sure you read the question properly. I am not performing a standard substring here. the "SavedFilterName" appears more than once. That is the issue. There could be 1,2,3,4 or more instances of this in the one field. If it only occured once I could do the following. select (...