|
There are many ways to get a dynamic connection string, one of them is supported directly by .NET through the application config, which has a connection string section, and even a way to encrypt that part. Start Googling! I'm pretty sure you even will find articles here on CodeProject that illustrate it all.
|
|
|
|
|
i found it, check this out :
Private Sub Button1_Click(sender As System.Object, e As System.EventArgs) Handles Button1.Click
Dim FileName As String = Application.StartupPath + "\Config\conString.txt"
Dim TextLine As String = String.Empty
If System.IO.File.Exists(FileName) = True Then
Dim ObjectReader As New System.IO.StreamReader(FileName)
Do While ObjectReader.Peek() <> -1
TextLine = TextLine & ObjectReader.ReadLine()
Loop
Else
MessageBox.Show("Connection String not found " + vbNewLine + vbNewLine + FileName, "Failed", MessageBoxButtons.OK, MessageBoxIcon.Exclamation, MessageBoxDefaultButton.Button1)
End If
End Sub
working perfectly, thankyou.. 
|
|
|
|
|
you're welcome.
However:
1. That wasn't what I suggested, through the official app config file.
2. You could read all content of a text file without using streams, just a single Dim Text As String = File.ReadAllText(Path)
|
|
|
|
|
Have a read of this Connection Strings and Configuration Files (ADO.NET)[^]
This is what Luc was pointing you towards
Lobster Thermidor aux crevettes with a Mornay sauce, served in a Provençale manner with shallots and aubergines, garnished with truffle pate, brandy and a fried egg on top and Spam - Monty Python Spam Sketch
|
|
|
|
|
did SQL Server need ADO.NET? 
|
|
|
|
|
When programming for the .NET framework, ADO.NET is the normal way to interact with an SQL Server database.
|
|
|
|
|
Sending SMS using .NET[^]
I used this code to send SMS by an application. it's need to pass com port as a parameter. But my PC doesn't have com ports. it only have USB ports only. So how do i find the com port which attached my phone. (Here i use a mobile phone instead of a GSM Modem)
|
|
|
|
|
One can buy USB-to-serial convertors e.g. here[^]. They tend to add a serial port to your system, hardly distinguishable from motherboard ports (very fast toggling of the control lines may be a problem, but they are fine for normal use).
They normally come with their own driver. Sometimes, the driver allows you to assign a static name to the new port, it may not even have to start with "COM". So you could have your app connect through such fixed name; or, what most programs do, have a ComboBox show all available ports (as obtained from SerialPort.GetPortNames[^])
|
|
|
|
|
I tried that SerialPort.GetPortNames function. It shows COM1 only. So if I connect my phone to a USB port can I use the port as COM1?
|
|
|
|
|
Plug it in and TRY IT. Chances are, you cannot use your cell phone as a modem without installing some software on the PC to enable it and that's IF you phone even comes with the software to enable it. Check with the cell phone vendor to find out.
|
|
|
|
|
You could use Device Manager (one of the options when right clicking My Computer), locate COM1, and try and decide whether it is hooked up to your phone.
Note: some PCs have a built-in modem which is implemented as a serial port, so your COM1 might be that too.
You'll have to look around and experiment, there isn't a fixed way to identify ports unfortunately.
|
|
|
|
|
SYSTEM/Hardware/USB -HUD devices reveals the identity. Use this ID to communicate via USB.
Interesting Velleman project K8055_VB communicates with an experimenting board, has VB source. Uses C-DLL, however which does not reveal code.
VB-source to locate, open-close, read write USB devices in VB is out there too.
|
|
|
|
|
Is there any method to insert a combo box in to list box. I want to allow users to choose items in a list box. It just like check boxes in a list box. But i want to use combo boxes instead of check boxes.
|
|
|
|
|
No, there isn't. You'd have to create your own custom control to do this. But, I've never seen or heard of anything like this being done. I have heard of nested listbox controls, but only in WPF, not Windows Forms.
|
|
|
|
|
|
|
hello:
I am trying to copy one two-dimensional array to another. The elements of the arrays are list of integers.
I want to copy by value. I mean, I need to change the second array without changing the first one.
I have tried with both array.copy and array.clone
Dim myarray1(3, 4) As List(Of Integer)
Dim myarray2(3, 4) As List(Of Integer)
Dim mylist As New List(Of Integer)
For i = 1 To 3
mylist.Add(i)
Next
For i = 0 To 3
For ii = 0 To 4
myarray1(i, ii) = New List(Of Integer)
myarray2(i, ii) = New List(Of Integer)
myarray1(i, ii).AddRange(mylist)
Next
Next
'Array.Copy(myarray1, myarray2, myarray1.Length)
myarray2 = CType(myarray1.Clone, Global.System.Collections.Generic.List(Of Integer)(,))
myarray2(2, 2).Clear()
In both cases, the original array (myarray1(2,2)) is changed too.
I want the first array (myarra1) stay unchanged.
Any sugestion appreciated.
Greetings,
Alex
|
|
|
|
|
Array.Copy and Array.Clone create a shallow copy, i.e. for each array element they copy the value (for value types) or the reference (for reference types); they do not create a whole lot of new elements.
As you want a deep copy, you have to program that with explicit loops, copying each element, one by one.
|
|
|
|
|
Your code won't work because you're not making copies of the List(Of Integer) objects. Your code holds references to 12 seperate List(Of) objects, and when you use Array.Copy or Array.Clone, you are copying the references to those Lists, not the values in them. So, you now have two arrays with references to the same 12 Lists. Any changes you make in one array will be seen in the seconds array because they both point to the exact same objects.
' Setup source array of Lists.
Dim originalLists(3, 4) As List(Of Integer)
For i = 0 To 3
For j = 0 To 4
originalLists(i, j) = New List(Of Integer) From {1, 2, 3}
Next
Next
' Now make copies of the original Lists.
Dim copyLists(3, 4) As List(Of Integer)
For i = 0 To 3
For j = 0 To 4
copyLists(i, j) = New List(Of Integer)
copyLists(i, j).AddRange(originalLists(i, j))
Next
Next
|
|
|
|
|
I was doing that way, looping each element, but it is slow and unefficient. I wondered if there exist a better approach.
|
|
|
|
|
Because you're using Lists for what is essentially the 3rd dimension of your array, no, there isn't.
|
|
|
|
|
Am i wrong?
I'm using DevExpress TreeList and I want to use it as button.
I disabled the AllowEdit and adding some nodes.
But there's no Node.Click or else, did DevExpress TreeList support that? 
Real Programmers code in Binary?? 
|
|
|
|
|
Since we didn't develop the DevExpress TreeView, we're not the ones you should be asking about this.
Ask this in DevExpress support forums. Since they wrote the control, they are FAR better equiped to answer questions about it, wouldn't you think?
|
|
|
|
|
Alpherattz wrote: I'm using DevExpress TreeList and I want to use it as button.
Their documentation can be found here[^], and they have an active forum.
No, can't help, my knowledge on DevExpress-stuff is limited to "need-to-know".
Bastard Programmer from Hell 
|
|
|
|
|
You can use the CalcHitInfo method of TreeList control in the MouseUp event to catch the required click event as shown below
Private Sub treeList1_MouseUp(ByVal sender As Object, ByVal e As System.Windows.Forms.MouseEventArgs) _
Handles treeList1.MouseUp
ShowHitInfo(treeList1.CalcHitInfo(New Point(e.X, e.Y)))
End Sub
Private Sub ShowHitInfo(ByVal hi As DevExpress.XtraTreeList.TreeListHitInfo)
Dim msg As String = hi.HitInfoType.ToString() & vbCrLf
If (hi.Column Is Nothing) Then
msg &= "No column" & vbCrLf
Else
msg &= "Column: " & hi.Column.GetCaption() & vbCrLf
End If
If hi.Node Is Nothing Then
msg &= "No Node" & vbCrLf
Else
msg &= "Node: " & hi.Node.Id.ToString() & vbCrLf
End If
If hi.Column IsNot Nothing AndAlso hi.Node IsNot Nothing Then
msg &= "CellValue: " & hi.Node.GetDisplayText(hi.Column.AbsoluteIndex) & vbCrLf
End If
MessageBox.Show(msg)
End Sub
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
