Yes, you are right. I was working with a not too good method. With a dataset it's better implemented. Thanks a lot.

I want to redim an array to the number of rows selected, and fill this array from one of the columns of the query.

When I make a query in sql server 2005 like "SELECT something FROM somewhere", there is a way to know the number of selected rows without the need of other query "SELECT COUNT(*) FROM somewhere" ? Thanks

OK!! this works well!! There is any inconvenience doing this?

Thanks to both, but it doesn't work. In 2005 express edition I can't (or don't know) select "sub main" as the startup object.

Roy Heil wrote:

Why are you trying to do this?

How you work with multiple forms then without using an mdi environement?

I have 2 forms. When I click on a button of form 1 I want to open form 2 and close form1. The problem comes when form 2 closes when form 1 closes. One solution will be to define a class and define the forms in it and not in the form 1, but I don't know how to do it. Someone can help me to do this or give me another solution? Thank you

I'm trying to make a program that sends data to another computer throught a net. I have follow an example but I can not establish connection. In the sender, I have this code: 'CREAR EL SOCKET Y CONECTAR Dim iphe As IPHostEntry = Nothing iphe = Dns.Resolve(server) Dim ipad As IPAddress = iphe.AddressList(0) ipad = iphe.AddressList(0) Dim ipe As New IPEndPoint(ipad, port) Dim tmpS As New Socket(ipe.AddressFamily, SocketType.Stream, ProtocolType.Tcp) tmpS.Connect(ipe) '****************************************** 'ENVIAR Dim ASCII As Encoding = Encoding.ASCII Dim envio As String = Me.txtAccion.Text Dim ByteGet As [Byte]() = ASCII.GetBytes(envio) Dim RecvBytes(255) As [Byte] Dim strRetPage As [String] = Nothing tmpS.Send(ByteGet, ByteGet.Length, 0) And in the client pc I have this code: 'CREAR EL SOCKET Y CONECTAR Dim iphe As IPHostEntry = Nothing iphe = Dns.Resolve(server) Dim ipad As IPAddress = iphe.AddressList(0) ipad = iphe.AddressList(0) Dim ipe As New IPEndPoint(ipad, port) Dim tmpS As New Socket(ipe.AddressFamily, SocketType.Stream, ProtocolType.Tcp) tmpS.Connect(ipe) '****************************************** 'RECIBIR Dim ASCII As Encoding = Encoding.ASCII Dim [Get] As String = "GET / HTTP/1.1" + ControlChars.Cr + ControlChars.Lf + "Host: " + server + ControlChars.Cr + ControlChars.Lf + "Connection: Close" + ControlChars.Cr + ControlChars.Lf + ControlChars.Cr + ControlChars.Lf Dim ByteGet As [Byte]() = ASCII.GetBytes([Get]) Dim RecvBytes(255) As [Byte] Dim strRetPage As [String] = Nothing ' Receive the server home page content. Dim bytes As Int32 = tmpS.Receive(RecvBytes, RecvBytes.Length, 0) ' Read the first 256 bytes. strRetPage = strRetPage + ASCII.GetString(RecvBytes, 0, bytes) While bytes > 0 bytes = tmpS.Receive(RecvBytes, RecvBytes.Length, 0) strRetPage = strRetPage + ASCII.GetString(RecvBytes, 0, bytes) End While MessageBox.Show(strRetPage) Maybe all the code is wrong (sure!). Someone can help me with this? Maybe there is an easy way to make this... I'm sure someone will teach me :)

I have seen in this site a few ways to create an auto update feature in aplications (and are good), but seems to be a "home" solutions. Which is the "profesional" way to make this? Thanks.

Thanks a lot! Very useful links!!

I need to establish a connection between one PC and a PocketPC. Someone can guide me about how can I start? Thanks

Well, I solved the problem this workaround: "select id, text, DATE_FORMAT(time,'%H:%i:%S') from table" Hope this helps to somebody!

I have an sql query like "select id, text, time from table" filling a datagrid. i have a problem with the datagrid values in the time cell. It says that has null values or 00:00:00 value. I don't know why. If I make the same query directly in mysql, it returns correct values. I test the same query with a little variation "select id, text, HOUR(time) from table".This time, the datagrid shows the correct values (12, 06, etc). Someone knows why is happening this?

But that I want is to show the tooltip without the cursor. Maybe I'm not explaining well... I'm reading the link you share and in one of the first lines says "The ToolTip class allows you to provide help to users when they place the mouse cursor over a control." I think that this explanation answer my question. It's not posible to show the tooltip if the cursor don't moves over him.

Yes, I know. But this tooltip will show when user stops the cursor over the control. I want to show it with no action from the user. Thanks anyway

Thanks a lot, it works well!!

There is any way to show a tooltip within the need of stop the mouse over a control? For example show the tooltip when a timer counts to 5 seconds... Thanks

I'm trying to move the mouse over a button with code but I can't. I found this property "Control.MousePosition" but I can't do it. Someone can help me? Thanks

It works like you say... but why in access my query returns values and in VB not? Thanks a lot!

In a test I'm making I type this oledbDataAdapter.SelectCommand.CommandText = "SELECT * FROM tbl_clientes;" oledbDataAdapter.Fill(Dataset) Me.DataGridBuscar.DataSource = Dataset Then I change the code to oledbDataAdapter.SelectCommand.CommandText = "SELECT * FROM tbl_clientes WHERE nombre LIKE '*j*';" oledbDataAdapter.Fill(Dataset) Me.DataGridBuscar.DataSource = Dataset And nothing is selected!!! If I copy and paste the SQL in the access editor, it returns a few records that begins with "j" (what I want!) Why this not runs in VBNET? Thanks.

It's ShowDialog() Thank you!!