Visual Basic

Christian Graus21-Jan-07 21:34

21-Jan-07 21:34

The Random class will give you a random number. If you have a database, you can generate numbers to be the Ids of values in there. Or, just build arrays to look into.

Christian Graus - C++ MVP

'Why don't we jump on a fad that hasn't already been widely discredited ?' - Dilbert

mactick21-Jan-07 22:21

mactick

21-Jan-07 22:21

i have a database.but i dont know how to generate the random numbers...can you pls tell me the steps on achieving it?

Christian Graus21-Jan-07 22:23

21-Jan-07 22:23

I did - the Random class. As in

Dim r as Random = new Random()

dim i as int = r.Next(100)

that will generate a number between 0 and 100. I recommend making the random class a member, if you keep creating new ones, it's less random.

Christian Graus - C++ MVP

'Why don't we jump on a fad that hasn't already been widely discredited ?' - Dilbert

mactick22-Jan-07 19:04

mactick

22-Jan-07 19:04

i have a database of data that i wish to randomly pick out a number and extract all the data belonging to it.i dont know how to start coding it, can you tell me the steps on how to do it?

Christian Graus22-Jan-07 19:42

22-Jan-07 19:42

The SQL to get the highest possible ID is select max(ID) from dataTable, where id is the id column and dataTable is the table name. Then use that value in the Next method of the Random class, to get an Id for a select statement.

If you're saying that you have no idea how to access your database, then the web is full of articles on how that's done.

Christian Graus - C++ MVP

'Why don't we jump on a fad that hasn't already been widely discredited ?' - Dilbert

mactick22-Jan-07 21:38

mactick

22-Jan-07 21:38

the main thing is i dont know how to code the random class to randomly select the data frm the database and the logic to generate it using arraylist in a loop, etc.

i do know how to use SQL statements to access e database.yea.

pls help... Sigh | :sigh:

Christian Graus22-Jan-07 21:52

Sqlclient and SQLTransaction error:::: vb. net

22-Jan-07 21:52

The answer to that has not changed since I told you, 23 hours and 28 minutes ago. Check my response above.

Christian Graus - C++ MVP

'Why don't we jump on a fad that hasn't already been widely discredited ?' - Dilbert

Nilesh Hapse21-Jan-07 20:33

Nilesh Hapse

21-Jan-07 20:33

hello everybody,

I've created setup of my vb.net application using installshield 12.
This setup when installed on my development machine works fine.
But when i install this thing on another machine which has only .Net framework and MS-office, and try to run my exe it gives me error which says:

No accessible overloaded 'SqlCommand.Transaction' is most specific for these arguments: <br />
    Public Sub set_Transaction(value As System.Data.SqlClient.SqlTransaction)<br />
    Public Sub set_Transaction(value As System.Data.Common.DbTransaction)

Can naybody help me out and tell me what this error is about?

Thanks in advance............

Christian Graus21-Jan-07 21:34

21-Jan-07 21:34

What database are you using, Access ?

Christian Graus - C++ MVP

'Why don't we jump on a fad that hasn't already been widely discredited ?' - Dilbert

Nilesh Hapse21-Jan-07 22:29

Nilesh Hapse

21-Jan-07 22:29

No ! i am using SQL server 2000. This works fine on my developemtn machine.

But when i create a setup using installshield 12 and install it on test machine it gives the said error.

Christian Graus21-Jan-07 22:36

21-Jan-07 22:36

Nilesh Hapse wrote:
i am using SQL server 2000.

OK, but you didn't say SQL Server is installed on the target machine. so, how can it work ?

Christian Graus - C++ MVP

'Why don't we jump on a fad that hasn't already been widely discredited ?' - Dilbert

Nilesh Hapse21-Jan-07 23:00

Nilesh Hapse

21-Jan-07 23:00

on the test machine SQL client is installed.
SQL server is installed on another machine. I am getting the server details thru a file.
From those details i am formatting the connection string and connecting to the database.

Christian Graus21-Jan-07 23:08

listview in vb.net 2005 [modified]

21-Jan-07 23:08

It's the exact same project ? It looks to me like you need to be more specific about which item you're trying to pass through.

Why did yo usay you had Office installed, when you're using SS ?

Christian Graus - C++ MVP

'Why don't we jump on a fad that hasn't already been widely discredited ?' - Dilbert

amaneet21-Jan-07 20:09

amaneet

21-Jan-07 20:09

Sir/madam,
There is a listview in my form. I added the checkbob option into it.Now the problem is , I don't know the event , Which should activate when i check/uncheck the checkbox into the listview.
Please help.
Thanks and regards
Pankaj

-- modified at 2:41 Monday 22nd January, 2007

Incrementing the date by one year

Rajiya21-Jan-07 19:37

Rajiya

21-Jan-07 19:37

Hi
I have a datetime picker and a textbox on my form.... Which ever date i select from the datetime picker,i want the date tobe incremented by one year on the next textbox.

For e.g: If the date selected in the dateTime picker is '10/11/2006' then in the other textbox i want the date to be '10/11/2007'.

How to go abt in doing this?

Thanks

Riz

Re: Incrementing the date by one year

Dave Sexton21-Jan-07 19:47

Dave Sexton

21-Jan-07 19:47

Private Sub DateTimePicker1_ValueChanged _<br />
    (ByVal sender As System.Object, ByVal e As System.EventArgs) _<br />
    Handles DateTimePicker1.ValueChanged<br />
        TextBox1.Text = DateTimePicker1.Value.AddYears(1).ToShortDateString<br />
    End Sub

Project help

Sachin Pimpale21-Jan-07 19:34

21-Jan-07 19:34

Hello all i want to create a project in VB.net so please help me for any topic regrding that

SP
--
Bugs can neither be created nor be removed from software by a developer. They can only be converted from one form to another. The total number of bugs in the software always remain constant.

Dave Sexton21-Jan-07 19:49

Dave Sexton

21-Jan-07 19:49

Create a multithreaded file indexing service that is launched remotely. Poke tongue | ;-P

Sachin Pimpale21-Jan-07 19:55

21-Jan-07 19:55

hello tx
but i dont have any ide about that so can u please give me idea about it so i can impliment
Smile | :)

SP
--
Bugs can neither be created nor be removed from software by a developer. They can only be converted from one form to another. The total number of bugs in the software always remain constant.

Dave Sexton21-Jan-07 20:08

Dave Sexton

21-Jan-07 20:08

Dude, seriously?

Perhaps you should aim a little lower... A calculator perhaps?

Sachin Pimpale21-Jan-07 20:11

21-Jan-07 20:11

yes seriously it my final presentation of project so please guide me Smile | :)

SP
--
Bugs can neither be created nor be removed from software by a developer. They can only be converted from one form to another. The total number of bugs in the software always remain constant.

Christian Graus21-Jan-07 21:36

21-Jan-07 21:36

You're going to fail. Seriously.

We're not here to tell you what your project should be, much less write it for you. Your failing will help maintain a high standard of graduates, people willing to work for themselves.

Christian Graus - C++ MVP

'Why don't we jump on a fad that hasn't already been widely discredited ?' - Dilbert

Sachin Pimpale21-Jan-07 22:50

21-Jan-07 22:50

hi
actually i want the concept description of that
multithreaded file indexing service that is launched remotely
not whole description

SP
--
Bugs can neither be created nor be removed from software by a developer. They can only be converted from one form to another. The total number of bugs in the software always remain constant.

Christian Graus21-Jan-07 22:56

21-Jan-07 22:56

He was making fun of you by suggesting a complex project, on the basis that you gave him no information to go on. Surely it would be best that you decide, based on where your strengths are, what your project should be ?

Christian Graus - C++ MVP

'Why don't we jump on a fad that hasn't already been widely discredited ?' - Dilbert

Sachin Pimpale21-Jan-07 22:58