Hi Can anyone advise/help me with the following I am trying to Select from table where xfield HAS either (,),/,%, : in the first 3chars For instance, the query should return the row G1: darararararararar and not G12 easfsafsafsfsfsfsfsf Thanks in advance

Thank you so much, it seems that this will do the trick But the moment I start typing in the textbox, the grid is empty and stays empty.

Private Sub TextBox1_TextChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles TextBox1.TextChanged

BindingSource.Filter = "ColName Like '" & textbox.text & "'"

End Sub

Hi I have a windows app with a datagridview and a textbox On form load I bind the grid with all records in a table. What I want to do is as I type in a textbox I want it to filter the grid to give me only what I have typed so far in the textbox.The seach will only filter on a specific colom and not on the entire grid's coloms. Cna someone help me on this, I do it this way, because I dont want to hit the DB everytime I type a letter in the textbox. Any ideas how to approach this?

Hi Im totally confused with Assembly Version vs Publish version. I have a windows application.I use a SetupProject --> rebuild it --> ,I get the MSI file and Install. I am trying to do a Auto Update on the application and would probably have to play with the version numbers in order to do this. My 1st problem is, when I change the applications assembly version and install the new msi - I get an error that there is already a application installed with the same version, but when I change the publish version it uninstalls the installed app and install the new one. My 2nd problem is I dont really know the best way to check if a new version is available. My idea is to take the running apps version and compare it with the version of the msi file on the server.If they are not the same, it will popup a message on the application saying "A new version is available, please click yes to install the new version" What I want to know: 1.How do I get the application to work on the assembly version and not the publish. 2.I would really appreciate tips what is the best way to write an auto update check. Thank you everyone

Brilliant, thank you it's working just the way I wanted it to work.

Thank you for your respond It will always be one form, but I need the form name or id to close it and I dont want to hardcode the forms name. I want basically: Is there a form open, if there is retrieve its id and then say id.close

I have a splitcontainer on my form. Panel1 has my menu and panel2 holds the WindowForms. If I click on my menu in panel 1 it should check if a form is loaded in panel2.If there is a form, then it closes it. Thanks for everyones help

Hi All I am really struggeling with DateTime Formats. I have an incoming table of data coming in.It is constantly busy. I am writing a monitor system on this table.So what I want to do is retrieve the last entries dateTime. SELECT TOP(1) DateTime FROM TABLE ORDER BY DateTime DESC. What I want to know is: How do I determine if the DateTime I received is older than 1 Hour from DateTime.Now AND Ex How do I determine if the DateTime I received is older than 5 Minutes from DateTime.Now OR EX How do I determine if the DateTime I received is older than 1Hour.5 Minutes from DateTime.Now Thanks a million in advanced

Thank you so much Steven I have changed the second line of code and replaced today with mindate and its working perfect. Im just wondering now what would happen if this month has 31 days and 3 months back has only 30.

Thank you Steven, but if I work it from todays day it should be 01/01/2010 but the result your code gives is 3/1/2010. I do appreciate your effort in helping.I'll try to work with this code and try to change it. Thank you so much

Hi I have DatePicker and the Maxdate is set to today: I am struggling with the MinDate. I need to set the Mindate to the 1st of 3 Months back(Keep in mind that the current month will be 3rd Month). Ex.1 For instance if we work it out as today the MinDate has to be: 01 January 2010 Ex.2 if today is the 16th of April 2010 the min date has to be: 01 Feb 2010 I hope someone can help me with this as I am really struggling with this calculation Thank you in advanced

modified on Tuesday, March 30, 2010 5:39 AM

Thanks guys, this helped alot.Thanks a million

Hi All, Can anyone help me. I have tried various methods and it doesnt seem to work. I'm trying to get string before the @ in an email address strEmail = Eddiez@gmail.nl //Something happens here strBefore = Eddievdz Messagebox.show("Hello" + strBefore) Thank you all

Hi all Though its great to have new features with every release, it sucks if Microsoft takes away old stuff that worked actually great. I have a searchtextbox with a search button. And what I want to build in is if someone enter something in the textbox and press enter it should hit the underlying code. For this I need to use the textbox Keypress Event. If you look at the code below, I get an error: Event 'KeyPress' cannot be found I have to use VB, its the company's policy.No Javascript Private Sub SearchTxt_KeyPress(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyPressEventArgs) Handles SearchTxt.KeyPress If Asc(e.KeyChar) = Windows.Forms.Keys.Enter Then GoButton.PerformClick() End If End Sub Thank you for your time

Hi All, I've been searching for this topic for days, am I wrong or aint there alot of articles about this? All I see and popsup everywhere is a few things "Google Earth API", "API Key", "KML" , "GE Plugin" Can someone please help me understand this: All I want is a VB.NET Webpage where I can enter a Adress and it navigates to it.Thats all. What the hell is the api? Is it a DLL? Is tha api key the same thing as a api. I have the plugin installed. What is KML in english please. How do I use/call these in my code :"Google Earth API", "API Key", "KML" , "GE Plugin" Please can anyone please please give me a usefull link or any sound advice. Thank you guys

Yes indeed

Hi there, hope someone can assist me on this. Ive got a datatable that gets Data from SQL. Now what I want to do is add a unbound Image datacolumn to this datatable. But the image must be a linkbutton. When its gets click it should redirect to a page carrying over the other datagrid Colums as parameters.For instanse ------------------------------------------- Col1 | Col2| Col3| Col4 | NewImageColumn -------------------------------------------- Row1 Row1 Row1 Row1 Row1 Row2 Row2 ROw2 Row2 Row2 Row3 Row3 Row3 Row3 Row3 Lets assume the DataTable has 3 rows When clicking on the NewImageColumn on lets say row 2 it should Redirect(pgSomepage.aspx? Row2.Col1 & Row2.Col2 & Row2.Col3 & Row2.Col4

Hi all, I never really played with small applications.Now I want to write an application, really small.Its only going to be used by a homeuser. Therefore its not really going to be that smart using SQL server. But I need some suggestions.What will be the best technology? I thought of XML, but Im not that clued up with it and it gives me the idea it will get tricky with big functionality.And then theres MS Access, but on the net it looks like its not really being used as much anymore.What will be the practical thing to use? Thank you