Visual Basic

mit2223 wrote:

i use like this code also. "insert into saleitm select * from datatable"
but its giving me error

Dave Kreskowiak wrote:

Might I suggest something from the menu

Public Class PairTT(Of T1, T2)<br />
<br />
End Class

Imports System
.
.
.
Public Class PairTT
    Public First As T1
    Public Second As T2
 
    Public Sub New(ByVal first As T1, ByVal second As T2)
        Me.First = first
        Me.Second = second
    End Sub
End Class

	[Serializable]<br />
	public class PairTT<T1, T2><br />
	{<br />
		public PairTT(T1 first, T2 second)<br />
		{<br />
			this.First = first;<br />
			this.Second = second;<br />
		}<br />
<br />
		public T1 First;<br />
		public T2 Second;<br />
	}<br />

ad3z wrote:

i'm really enjoying the simplicity in how to pull data in vb.net 2005
i've got a data source (pointing to an access db),
i throw a few controls in my form, i open that cute database designer
add my query which selects various fields from a table WHERE (ID=?)
and voila, i can pull data in my program.

ad3z wrote:

but now i don't want to get data "where id = ?" only, but i want "where id = ? or id = ? or ..."
so i tried "WHERE (?)" but u arent allowed to pass sql code, only parameters. (obvious)

ad3z wrote:

does anyone know the easiest, least painful way to do this ?

<br />
Dim Sql1 As String<br />
<br />
sSql1 = " Select * where id like '%'"<br />
<br />
'connection<br />
"osql -S " & [Server] & " -d " & [database] & " -U [User] -P [Password] " & "-Q """ & sSql1 & """" & " -n -o """ <br />

agbaria ahmed wrote:

Whay I dont have the "system.io.ports" class in vb.net?