Visual Basic

Re: Multiple Generic TypeParams in a VB.NET Class Definition?

19-Dec-06 4:41

You should be using the Of keyword at all. Your arguments, in the C# code, are being passed by value, so...

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

Dave Kreskowiak
Microsoft MVP - Visual Basic

Netricity20-Dec-06 10:59

Netricity

20-Dec-06 10:59

Thanks Dave, but damn I pasted the wrong C# code into my first example, I should have pasted this (the class-level typeparams disappeared because they contained HTML angle brackets):

	[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 />

How would I implement this in VB? I think my 2nd post answers what I should have asked for originally, but thanks again for any help!

how I make virtual serial port to my usb port?

Agbaria Ahmad18-Dec-06 23:16

Re: how I make virtual serial port to my usb port?

18-Dec-06 23:16

how I make virtual com port to my usb port?
simple can help thanks.

Dave Kreskowiak19-Dec-06 3:07

Re: how I make virtual serial port to my usb port?

19-Dec-06 3:07

You don't. The device you want to talk to has to have drivers that exposes it AS a COM port. USB really has nothing to do with it.

Dave Kreskowiak
Microsoft MVP - Visual Basic

roo42620-Dec-06 16:15

roo426

20-Dec-06 16:15

Check if the USB device you want to use already acts as a com port. My "USB GPS" work as a COM thru a USB port, I was lucky. If not, you can buy a USB to COM port adapter. That also works for me on an other device I use.

Hope this helps.

Rob

getting rows from more than 1 criteria? [modified]

Eric Georgiades18-Dec-06 22:12

Eric Georgiades

18-Dec-06 22:12

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.

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)

in other words i want to be able to easily execute my own sql statement.

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

(that is without going into connecting to the database, declaring a gazzilion things just to execute 1 line of sql, and pass them back to a datatable type)

-- modified at 8:10 Tuesday 19th December, 2006

Dave Kreskowiak19-Dec-06 3:03

19-Dec-06 3:03

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.

That's nice and all, but the "wizards" make it a large PITA to support the resulting code. If you want TOTAL control over the database code and develop a good understanding of how it all works and fits together, it's a good idea to scrap the wizard generated stuff and write it by hand.

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)

Now you know why I said what I did. If you search your code for the query you put into the wizard, you can usually modify the query string to what you want. The problem is that you are now adding multiple parameters to the query string and will have to modify more code to add those parameters.

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

Scrap it and write it from scratch.

Dave Kreskowiak
Microsoft MVP - Visual Basic

tbryce31119-Dec-06 5:59

tbryce311

19-Dec-06 5:59

I don't think the code is exact for an access database, but if it where sql, as a part of your data connection you apply the member variable.

<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 />

Eric Georgiades19-Dec-06 6:25

Eric Georgiades

19-Dec-06 6:25

well i manage to connect to it but it's alot of code, and
it looks like i set up another connection (apart from the one i'm activly using with
the .net components)

i have to declare oledb connection strings
connect to it (add the fact it's got security blah)
read it to a dataset
specify my sql command
execute the command into a new dataset
and then use datatables and datarows to access it

isn't there a simpler way ?
that what i'm looking for Big Grin | :-D

(something in the lines of the new ado.net help thingys)

Ericos Georgiades

tbryce31119-Dec-06 7:36

tbryce311

19-Dec-06 7:36

Trying using the datagrid control. After you follow the wizard setting up the connection you have the option of changing your query. You can also add additional queries with buttons to run the specific query.

Eric Georgiades19-Dec-06 7:51

Eric Georgiades

19-Dec-06 7:51

"the specific query"

yeah i dont want to run pre-defined queries cause i cannot specify my criteria freely.

i want to return to a table all the rows of a table
given a selection of parameters

for instance, if a listbox shows me all the customers and i select 4 of them, i'd like to
have a table as datatable which has the rows of the sales table which match the 4 customers i chose.

with the wizard i can only predefine the criteria Frown | :(

anyways it doesnt seem as though there is a simpler way rather than writing the entire connection string

oh yeah and i know, i talk alot... :P

Ericos Georgiades

To Dave Kreskowiak .

Agbaria Ahmad18-Dec-06 20:36

18-Dec-06 20:36

I want to read data from USB IR receving device.

Re: To Dave Kreskowiak .

Dave Kreskowiak19-Dec-06 2:57

19-Dec-06 2:57

Then it's probably exposed as a COM port (Serial port). You'll have to check with any documentation you got with the device or the machine. Google for "VB.NET Serial Port" and you'll come up with all kinds of stuff on it, that's IF it's exposed as a serial device.

Dave Kreskowiak
Microsoft MVP - Visual Basic

Re: To Dave Kreskowiak .

Dave Kreskowiak19-Dec-06 2:57

Whay I dont have the "system.io.ports" class ? [modified]

19-Dec-06 2:57

Keep your posts in the same thread. Don't start a new thread just because you have something need to say about the old one.

Dave Kreskowiak
Microsoft MVP - Visual Basic

Agbaria Ahmad18-Dec-06 20:28

Re: Whay I dont have the "system.io.ports" class ?

18-Dec-06 20:28

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

-- modified at 2:38 Tuesday 19th December, 2006

Michael P Butler18-Dec-06 22:20

Michael P Butler

18-Dec-06 22:20

agbaria ahmed wrote:
Whay I dont have the "system.io.ports" class in vb.net?

Which version of .NET are you using.

System.IO.Ports is only supported in .NET 2.0 and .NET 3.0

Michael

CP Blog [^] Development Blog [^]

Re: Whay I dont have the "system.io.ports" class ?

Agbaria Ahmad18-Dec-06 23:18

Inserting Data along with HtmlTags.

18-Dec-06 23:18

Thank's.

vin107018-Dec-06 19:34

vin1070

18-Dec-06 19:34

Hi,
Can you Help me.
I am having one multiline textbox.i am selecting some content from word document and paste it in textbox.the data is being inserted into database when button is clicked.The problem is the data is not inserting along with html tags.
And when i retrive the data into datagrid the htmlformat is not there i.e without line breaks,spaces..etc...

vin1070

Re: Inserting Data along with HtmlTags.

Guffa19-Dec-06 1:32

Guffa

19-Dec-06 1:32

A textbox does not support formatting. Perhaps you should use a RichTextBox instead.

---
It's amazing to see how much work some people will go through just to avoid a little bit of work.

Re: Inserting Data along with HtmlTags.

vin107019-Dec-06 1:42

vin1070

19-Dec-06 1:42

Thanks for quick reply
but there is limitation for me, i have to use only multiline textbox and if i am not wrong there is no Richtextbox in .Net webapplication and i dont want to buy any third party tool either.

regards,
vin1070.

Required Urgent.

RAHUL200618-Dec-06 19:33

RAHUL2006

18-Dec-06 19:33

Hi Friends,

Today, i required one small project which i need to submit on my univesity.i required souce code of the project also.

project in VB ok, Small c++ it's also okay... I want to submit this project but tommrrow onyl... this is my humble request you to pls so the needful..

I already submited project but, my they cancle for some resion. request you yo send me as soon as possible. i want to take printout hardcopy also..pls do the needful

RAHUL

The ANZAC18-Dec-06 21:03

The ANZAC

18-Dec-06 21:03

I understand that its urgent but you failed to say what the project is and what it should do. We need to know this.

Posted by The ANZAC

Dave Kreskowiak19-Dec-06 2:54

19-Dec-06 2:54

No we don't. He needs to write it himself. He can come here and ask questions, but we're not going to write it for him just to save his butt.

Dave Kreskowiak
Microsoft MVP - Visual Basic

Paul Conrad19-Dec-06 5:21

Paul Conrad

19-Dec-06 5:21

Dave Kreskowiak wrote:
ask questions, but we're not going to write it for him just to save his butt

Yep. If I were his teacher and found this thread, well.......

Some people have a memory and an attention span, you should try them out one day. - Jeremy Falcon

Dave Kreskowiak19-Dec-06 5:37