|
Sir/Madam
Can i please get to know the various types of connection to do the code.
I mean if the application is based on three database.Can this be possible to lock the database and keep it open.and simultaneoluly open the another database.
I finally wanted to know the various types of connection
Thanks and regards
Pankaj
|
|
|
|
|
amaneet wrote: I mean if the application is based on three database.Can this be possible to lock the database and keep it open.and simultaneoluly open the another database.
You can open as many connections as the databases will allow. However, remember that the preferred pattern is to open a connection, perform the query and then close the connection as quickly as possible so you don't tie up resources.
amaneet wrote: I finally wanted to know the various types of connection
There are as many types of connections as databases that support the .NET Framework.
|
|
|
|
|
Sir,
can u please provide any link?
Thanks and regards
Pankaj Garg
|
|
|
|
|
amaneet wrote: can u please provide any link?
A link to what?
|
|
|
|
|
|
But it does not list ALL connection types. Just the most common ones.
|
|
|
|
|
Sir/Madam,
Can i programically find out the current date format in my machine.
I mean whether it is mm/dd/yy or dd/mm/yy
PLease help.
Thanks and Regards
Pankaj Garg
|
|
|
|
|
Have a look at your current culture info
System.Threading.Thread.CurrentThread.CurrentUICulture.DateTimeFormat
|
|
|
|
|
Sir/Madam,
I wanted to store the images in the database(MS-Access)
Please let me know the way how to do the same.
Thanks and Regards
Pankaj
|
|
|
|
|
There's tons of examples out of the web. All you have to do is Google for "vb.net store image access[^]".
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
|
Sir/Madam,
I wanted to know something about the transactions .Currently i am using the MS-Access.I wanted to code on transactions So from where should i start from the scratch
Please help.
Thanks and Regards
Pankaj Garg
|
|
|
|
|
You can start with this article[^] on MSDN. There's also this one[^].
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
Sir/Madam,
I wanted to know the utility of Masked textbox especially in showing the date in the single textbox .I mean in wanted to insert the slashes in the textbox , so whenever the user clicks the left or right key the control navigates to month or year.I mean there should be some space left in between the slashes for insertig the month year day.and all this i wants in the single textbox .Can i make it possible.
Please help.
Thanks and regards
Pankaj Garg
|
|
|
|
|
In maskedTexbox there are predefined formats under its properties. You can define custom format but It will not allow you to use slashes between month, day and year.
I think you have to write a class to produce your own maskedtextbox.
What a curious mind needs to discover knowledge is noting else than a pin-hole.
|
|
|
|
|
Sir,
I am in urgent need to solve this problem.
If u please provide any link to solve this very problem.
Thanks and Regards
Pankaj Garg
|
|
|
|
|
|
How to convert DRM protected audio file to unprotected audio files, that are brought from iTunes.
Bala
|
|
|
|
|
You picked the wrong website to ask this question...
Let's see, "How do I strip the protection from something I may or may not have bought?". Sounds like piracy to me...
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
Hello,
i m using vb.net (winforms) & i have written class called employee.
& make object of employee on my form & accessing all the properties of emp like id, name,sal etc.
i shuld access all the values...so i wrotee property for each like
Public ReadOnly Property BasicSal() As Integer
Get
Return BS1
End Get
it is good whn property values are less but as i wnt to access all salary info like HRA, Basic Sal....etc total 20 fields.
So i decided to use Array....I fill all values in array in my employee class's function itself.
Th problem is i wnt to access this array of all values on my forms.How to do it plz tell me.
Thanks for any help in advance.
--Regards priya
"The Difficult i can do it now...
The Impossible will take a little longer."
|
|
|
|
|
You can implement the property list using, for instance, a SortedList . See the following MSDN excerpt:
Imports System
Imports System.Collections
Imports Microsoft.VisualBasic
Public Class SamplesSortedList
Public Shared Sub Main()
' Creates and initializes a new SortedList.
Dim mySL As New SortedList()
mySL.Add("one", "The")
mySL.Add("two", "quick")
mySL.Add("three", "brown")
mySL.Add("four", "fox")
' Displays the SortedList.
Console.WriteLine("The SortedList contains the following:")
PrintKeysAndValues(mySL)
End Sub
Public Shared Sub PrintKeysAndValues(myList As SortedList)
Console.WriteLine(ControlChars.Tab & "-KEY-" & ControlChars.Tab & _
"-VALUE-")
Dim i As Integer
For i = 0 To myList.Count - 1
Console.WriteLine(ControlChars.Tab & "{0}:" & ControlChars.Tab & _
"{1}", myList.GetKey(i), myList.GetByIndex(i))
Next i
Console.WriteLine()
End Sub
End Class
' This code produces the following output.
'
' The SortedList contains the following:
' -KEY- -VALUE-
' four: fox
' one: The
' three: brown
' two: quick
Hope that helps
If the Lord God Almighty had consulted me before embarking upon the Creation, I would have recommended something simpler.
-- Alfonso the Wise, 13th Century King of Castile.
|
|
|
|
|
hi i have to insert a string into database but while inserting it is not allowing me to insert as ther is some special characters and my main problem is string contains ( ' ) this character .i am in need of escape characters in vb.net
thanks
with regards
Balagurunathan.B
|
|
|
|
|
Hi,
You can try Asc(27) or Char(Asc(27)) or Char("ESC") .
Good luck,
Johan
My advice is free, and you may get what you paid for.
|
|
|
|
|
HI
SHOULD I HAVE TO REPLACE COMMAND
I NEE THE ORIGINAL CONTENTS BACK WHILE RETRIVING
IN C# WE USE \\ R @ CHAR WAT HAVE TO USE FOR THIS
with regards
Balagurunathan.B
|
|
|
|
|
Hi Balagurunathan,
No need to shout, I can hear you just fine (please press your Caps Lock key).
It seems that I did not quite understand you. You are not looking to identify the Escape character but the ' character.
In VB.NET you can use the Replace method:
YourString.Replace("'", "´")
The first string is the string (or character) that you want to remove, and the second string is the string that you want to put in its place.
If you only want to remove a certain string or character from a String you could try:
YourString.Replace("'", "")
Johan
My advice is free, and you may get what you paid for.
|
|
|
|