Answer Questions

• GSReddy String Functions

  Through playing I have noticed that whenever I type the name of a string, for example str, with a . after it a list appears with common and all functions availible. Commom: Contains EndsWith IndexOf ..... etc. I am trying to find which functin would accomodate me the best. I am currently using the .Contains to find if a specific "key" word appears in the string I just read in. But what I don't know how to do is extract data that appears after the "key" words. Can someone please help me.....!!!! Example: Itinerary for Doe,John on 01-01-1001 The informaion in yellow is the data that I need. The red ar the "key" words. Mark, Thanks for the example, ...Show All

• KrishnaUNISYS Setting a dropdown combo to read-only in visual studio 2005 in vb

  Greetings, I don't want the user to be able to write in a combo box. How do I set the combo to read-only. Thank you, Set the DropDownStyle property to: "DropDownList" this will allow the user to only select those items that are already in the combobox....the other solution owuld be to use a listbox control Thank you, very much. ...Show All

• toforo What is the SQL insert statement for the data in dataset/datagrid?

  Can anyone help me in solving this qns on how to insert the data in to new table in database provide u do it by the dataset but not indivdual i wan the whole dataset data to be put in the table in database instead but not add new rows/records to it.... Pls reply asap for any answer ok firstly you have to got to frame your question in a way where we can understand what your tryin to ask for...cos im sure the other person who replied to u previousy will agree with me when i say that i really do not understand what you need. the info u gave is i knz but i need is to transfer the new data to the database'table as a whole dataset ...Show All

• singam Next Monday.

  Hello, How can I define the date of the next coming Monday (calculated from today onwards) Here's a one liner using the not often seen Choose function: MyDate.AddDays(Choose(MyDate.DayOfWeek + 1, 1, 7, 6, 5, 4, 3, 2)) Hi, In your output you may want to use.>> Dim myDateString As String myDateString = myDate.ToLongDateString 'or myDateString = myDate.ToShortDateString if you prefer one of those formats.  I believe it won't work on the end of the lines in this code as myDate is the full System.DateTime.       Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click    &nb ...Show All

• Seshagiri SQL command to Access database in vb2005

  Hopefully someone can shed some light on the problem I’m experiencing. I’m fairly new to vb2005 but I’ve managed to totally confuse myself. Below is an example I’m using to extract data from an access database however when I try to include a "Where/Like" command I’m getting no data returned. The really confusing thing is that if I paste the sql string into access it works fine. The actual sql string I build is:- “Select * from M_Businesses Where Description Like 'B*' Order by Description;” I’ve included code and an access database to recreate. Any comments would be much appreciated. Cheers John Private Sub TextBox1_TextChanged( ByVal sender ...Show All

• Yeshia I can't check for updates for VB 2005

  Hello I know that we can check for updates for VB 2005 via Windows Update. But when I check for updates via Windows Updates, it doesn't display VB 2005 updates; it just displays Windows Updates. What's problem Thanks because there are no updates :-) SP1 was released a little while ago for VS2005.... http://msdn.microsoft.com/vstudio/support/vs2005sp1/default.aspx none :-) ahmedilyas wrote: because there are no updates :-) SP1 was released a little while ago for VS2005.... http://msdn.microsoft.com/vstudio/support/vs2005sp1/default.aspx I've installed SP1. Are there no updates except SP1 ...Show All

• Adagio59675 passing a function's name to another function (or sub)

  Dear all when programming in FORTRAN I was used to pass the name of a function to another sub or function. With VB.NET I have some problem. Suppose I have several functions, named F1,F2, F3,.., and that I have to perform some common task on these functions (for instance numerical integration). Well, I wish to manage things in such a way to have a library function or subroutine (to do integration) and to call it passing various parameters 'and' a function name ( e.g. F3 ) to perform the integration of F3 . In other words I wish something similar to this fragment of code to work (declarations and initialization omitted): module main integ1= integration(a,b,step,F1) integ2= integration(a,b,step,F2) end module m ...Show All

• idorner vb code part 1

  Hi all, I ported a class from c# to vb, it's bassicly a class for the systray icon with balloontip it compiles and i think the code is correct, but for some reasen i got some problems 1. the std tooptip is truncated eg "hallo" becomes "h" 2. the balloon never shows up when the sub ShowBalloonTip is called I stairing to the code and slowly driving me nuts, i must be overlooking something simple the origional c# code is here I'm ghoing to cut the vb code in peaces en post them for some reason i can not post 'big'messages remco Have you tried using the windows form component NotifyIcon There's an icon property and a text property that ...Show All

• anderskj1 Reading from database

  Hopefully someone can help me with this problem. I am using the below code to read data out from an oracle db and put the data found into a string. For some reason it wont work though. I know the oracle connection works fine as the 'insert' statement which is commented out allows me to write info to db, but some reason reading info is causing me a problem. Any help would be greatly appreciated. Private Function login() As OracleString Dim myConn As New OracleConnection( "Data Source=bnp;Persist Security Info=True;User ID=bnp;Password=bnp" ) Dim query As String = "Select * from USERS_TEST where USERID = 'david' AND PASSWORD='mcgarry'" 'Dim query As String = "insert into users_test (us ...Show All

• Stephen Crabb Cascading combo lists

  Does any one know how to create cascading combo lists where in one combo list, you select a product and another combo list would display the sub-products/subcategory related to the product. How would the database design work so that the information can be correctly displayed in the combo lists. I have been trying to get my head around implementing this, but I have not found any suitable answers on the web. Any help would be great. Regards Dipendra Thanks for the details I had a look at the link that you gave me and found the Phonebook examples that you had given together with the code. By the way, what does the database structure look like for the phonebook so that the drilldown comb ...Show All

• Frank Uray Relations for 3 levels of tables

  Hello. A question please. I have 3 tables. Relations are: Table1 ---> Tables2 (1 to Many) Table2 ---> Tables3 (1 to Many) MasterBS.DataSource = dataset MasterBS.DataMember = "Table1" I create 1 DataRelation ---> Relation1 DetailBS.DataSource = MasterBS DetailBS.DataMember = "Relation1" how can I relate the 2nd and 3rd table. Thanks... Here is an example Imports System.Data.OleDb Public Class Form1 Dim ds As DataSet Private Sub Form1_Load( ByVal sender As System. Object , ByVal e As System.EventArgs) Handles MyBase .Load Dim daEmployees As OleDbDataAdapter Dim daOrders As OleDbDataAdapter Dim daOrderDetails As OleD ...Show All

• nbrege contorl's desktop location

  Hi, how can i get the desktop location of a control on a form i mean i want to know where my contol is on the desktop and not on the form.... thnx Hello Attila Fogel. This is done using one structure and one method. Each control has a property that is a Point called the Location. This location is relative to the Parent. It also supports 2 methods. One of which is used here. PointToScreen. This method takes a Point that should be relative to it and then it converts it to screen coordinates. Dim TmpPoint As Point = TreeView1.PointToScreen(new Point(0,0)) MessageBox.Show("X: " + TmpPoint.X.ToString() + " Y:" + TmpPoint.Y.ToString()) Probably the only thing that should be noted is people who are runni ...Show All

• Drew Marsh how to place a command for windows to execute during boot

  Hello All, I am tring to figure out how to place a hook of somesort to execute a command upon reboot programatically. I have a dos command "del index.dat \s" that I want to run during boot. The reason I cannot run this during the running of windows is becasue some index.dat files are in use. What is the proper method of doing this Thanks! Ahh this is exactly what I was looking for! For some reason I didnt think you could execute a bat file in startup. Thanks a million. Hi, Put the line>>   del index.dat \s in a text file called delDATfile.bat or similiar and put it in the root i.e. C:\ make delDATfile one of your startup acti ...Show All

• Zep-- using File.WriteAllText vrs a StreamWriter

  My question: VB 2005 now offers different methods to write/read a file, such as the File.WriteAllText, the My.Computer.FileSystem.WriteAllText and the StreamWriter. Can anybody explain when is it better to use which method, which one is more efficient in term of memory/processor use and performance time Thanks!! yup yup yup I would agree to that and is what I would have stated also. however If I may make one suggestion in regards to this: When you have a large amount of text to write, using WriteAllText() is generally not a good idea because you'll be creating large temporary strings true so in this case, you are better, in general anyway, to use a StringBuilder to appen ...Show All

• Ljan Query about invoking an application when an Event going to Occur

  Hai all, I need to invoke an application (developed by us - it may be anything) when we click Shutdown option or when the system one for getting going to Shutdown.Is there any provision for this thing . Thanks S.Sheik I believe you are asking how you can run an application when windows is shutting down If that is the case I think you can use the SystemEvents which is located in the Microsoft.Win32 Namespace. You can find more information about these events at http://msdn2.microsoft.com/en-us/library/z1bwe429.aspx You should learn about SessionEnded and SessionEnding . Try adding an event handler to a windows service that runs at startup. When y ...Show All