|
Here you go;
Sub Main()
Dim arrayLines As List(Of String()) = New List(Of String())
For Each line As String In IO.File.ReadAllLines("TextFile1.txt")
arrayLines.Add(line.Split(" "))
Next
Dim theArray As String()() = arrayLines.ToArray()
Console.ReadLine()
End Sub
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
|
|
|
|
|
I want to implement a function in my program, to judge if the active solution configuration in build configuratioin manger is Debug, or Release.
Can anybody tell me how to do it?
modified 5-Mar-13 11:11am.
|
|
|
|
|
See here[^].
Use the best guess
|
|
|
|
|
Here you go;
Private Enum CompileMode
Debug
Release
End Enum
Private Function GetCompileMode() As CompileMode
#If DEBUG Then
Return CompileMode.Debug
#Else
Return CompileMode.Release
#End If
End Function
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
|
|
|
|
|
I'm not sure if it's appropriate to talk about it here, hereby let me mention something about visualized data computing.
Usually, we use R,SQL or esProc scripts for complex data calculation and analytics, while the process of them is quite abstract and difficult for general users. Now, there are some new technology like esCalc, to make the computing more visual and direct,how do you think about it for data calculation?
|
|
|
|
|
David venewald wrote: I'm not sure if it's appropriate to talk about it here, No it's not; this forum is for technical questions on Visual Basic issues (see here[^]). If you want to advertise your product then contact the administrators and buy some ad space. If you want a general philosophical discussion then try the Lounge.
Use the best guess
|
|
|
|
|
Hi, Richard,
I just wanna to talk about visualized computing mode with users, it's not advertising.But thank you for your email anyway.
|
|
|
|
|
Which is why I explained (or tried) to you that this is not the appropriate place. This forum is for technical questions on Visual Basic. If you want to have a general discussion then the Lounge is the place for it..
Use the best guess
|
|
|
|
|
Considering the chances of anyone using any given 3rd party library seeing your post are very, very low, the odds of you getting any meaningful response to this are equally low.
|
|
|
|
|
Hi, Dave, thank you for your answer, but hereby I mentioned is visualized data computing instead of abstract scripting like R, SQL or esProc. Such computing mode may help users more agilely and directly while dealing with complex data process.
I think users will get interested in it if such mode can improve their convenience and efficiency.
|
|
|
|
|
You're not really expecting a discussion on this, are you??
I don't have time for this.
|
|
|
|
|
Hi guys,
i would like to ask on how to use the control Adobe Pdf Viewer in Visual basic 2010 in terms of Saving ,Retreiving and modifying the pdf file displayed on it through sql server 2005 database.
I can do this with image using picture box but how about in pdf files using Adobe Pdf Viewer?
i have a code for saving and retrieving my image
any modification to my code to solve my problem would be appreciated ..
Imports System.IO
Module ModReadWriteImage
Public Sub writeImage(ByVal picbox As PictureBox, ByVal sql As String)
Dim imageBinary = Nothing
Dim myImage As Image = picbox.Image
Dim imgMemoryStream As MemoryStream = New MemoryStream()
Dim imgByteArray As Byte() = Nothing
myImage.Save(imgMemoryStream, System.Drawing.Imaging.ImageFormat.Jpeg)
imgByteArray = imgMemoryStream.GetBuffer()
saveImage(imgByteArray, sql)
End Sub
Public Function readImages(ByVal pic As Byte()) As Image
Dim imgMemoryStream As MemoryStream = New MemoryStream()
Dim imgByteArray As Byte() = Nothing
Dim myimage As Image
imgByteArray = pic
imgMemoryStream = New IO.MemoryStream(imgByteArray)
myimage = Drawing.Image.FromStream(imgMemoryStream)
Return myimage
End Function
End Module
Many Thanks.
|
|
|
|
|
As far as sotring and retrieving the PDF file in the SQL server, it's no different. An image file is no different than a PDF file. To SQL server, it's all just bytes.
The problem your have is displaying the PDF. AFAIK, since the Reader Viewer will not use a MemoryStream object, you have to write the file to disk, then tell the Reader the file to load.
|
|
|
|
|
Thanks for your reply
But is there any other soulution to my problem rather than writing the file to the disk?
i just want a direct communication between the pdf file viewer to the database
if you dont mind do you have sample codes for pdf? this will be very helpful for me.
thanks a LOT!
|
|
|
|
|
J.Mañago wrote: But is there any other soulution to my problem rather than writing the file to
the disk?
What did I say?? Using Acrobat Reader, it will ONLY work with files, so NO, there is no other solution. Unless you want to scrap Acrobat and use a 3rd party component. In which case, you've got some researching to do to see what's going to fit your needs and if it's going to be supportable by you.
J.Mañago wrote: if you dont mind do you have sample codes for pdf? this will be very helpful for
me.
I don't have any examples, but I'm sure the Web does. A simple Google for "Using Acrobat Reader with VB.NET" should come up with lots of them.
|
|
|
|
|
I'm trying to create a class which behaves like a Double only allows values within a certain range.
One of the goals is to have it behave as a normal Double, i.e.: being able to assign Double values to it and pass it to functions taking a Double value.
Public Class RDouble
Public Sub New(ByVal D As Double, Optional ByVal Min As Double = 0, Optional ByVal Max As Double = 100)
_MinValue = Min
_MaxValue = Max
_dValue = D
If _dValue < _MinValue Then
_dValue = _MinValue
ElseIf _dValue > _MaxValue Then
_dValue = _MaxValue
End If
End Sub
Public _MinValue As Double
Private _MaxValue As Double
Private _dValue As Double
Public Shared Widening Operator CType(ByVal d As RDouble) As Double
Return d._dValue
End Operator
Public Shared Narrowing Operator CType(ByVal d As Double) As RDouble
Return New RDouble(d)
End Operator
End Class
Sub Main()
Dim rd As New RDouble(50.0, 10.0, 100.0)
rd = 20.54
Dim D As Double
D = Math.Round(rd)
End Sub
The problem with this code is of course that any assignment to the RDouble causes its boundaries to be "reset" since a new one is created with the default _MinValue and _MaxValue; and with the conversion operators being shared there is no way to access the Min/Max values of an instance.
Is there any way to fix this?
|
|
|
|
|
If I understand what you're doing correctly, there is no way to fix this. You're trying to use a class instance as a value type and that doesn't work.
Take a look at the BigInterger structure in .NET 4.0 and 4.5. This is about the closest you're going to get.
|
|
|
|
|
Let me explain in advanced what my goal is and then later I will ask the question. I have to get data from an Oracle database that is spread over several tables. The database connection and view to get the data is already up and running. I am now breaking my head over what the best way is to use the data from the database. The system I am working on work per document. To each document there needs to be data added from the database. I can run a query for each document when needed but I am thinking of loading all the data in to a recordset and use that recordset as a database. I know that if the amount of data is large the memory of the clients computer needs to be sufficient.
So the question now is how would I go about with this?
What is the best way of doing this?
Can I cache the record sets data and then perform SELECT * FROM obj.Recordset?
Any information will help here.
Thanks in advanced.
|
|
|
|
|
You'd have to "roll your own" class to do this. VBScript doesn't have any built-in caching capabilities.
In my humble opinion, I would move this project up to PowerShell at the very least, which has native access to anynthing in the .NET Framework, including it's built-in caching classes.
|
|
|
|
|
Thanks for the reply. But I can't move to Powershell because this scripting has to be done within an application that only can use VBScript. Actually the script language is called WinWrap Basic.
|
|
|
|
|
oh....joy.
OK, then you would need to roll your own class to do the caching. Your biggest problem is going to be implementing a some kind of SQL (or some other dialect you invent) parser to do queries against the cached data.
OOOOORRRRR you could write a COM-exposed class in C# or VB.NET and use the DataTable.Select to do the heavy lifting for you. Then you would need to install and register this component and have to VBScript code CreateObject an instance of it, ...blah, blah, blah.
|
|
|
|
|
I wanted to avoid installing extra libraries and keep the footprint on the client minimal. I already used a DSN-less connection to the database.
I can instantiate a recordset object so why can't I use the properties you mentioned of the recordset object?
|
|
|
|
|
Feurich wrote: I already used a DSN-less connection to the database.
Which is very common. All a DSN is is a connection string in a text file. Ask some people why their obsessed with using a DSN and they can't give you an answer other than "that's the way I was taught!"
Feurich wrote: I can instantiate a recordset object so why can't I use the properties you
mentioned of the recordset object?
You can, so long as you don't want to do "SELECT * FROM ..." on that RecrodSet object. You can Filter on the RecordSet and alter what it iteractes over, but whether that will do what you want is unknown. Only you can answer that question.
|
|
|
|
|
Feurich wrote: can instantiate a recordset object so why can't I use the properties you
mentioned of the recordset object?
...and because the Select method doesn't exist on the ODBC.RecordSet object. It exists on .NET's DataTable class, which VBScript cannot use unless you write a COM-exposed wrapper class around it as I mentioned.
|
|
|
|
|
Thanks for your reply and time. I'll keep your suggestions in mind and try to keep to my goals while considering your comments.
Best regards,
Eric
|
|
|
|