anyone know how sql pick a random number of primary keys, I know get max number and call a random number work but what if there a missing numbers like 1,2,4,6,7 so max 5 and random will missing 6 and 7 also there a error if 3 and 5 come up.
View 1 RepliesI have this code to pick a random number Between X and Y
X = Minimum Number
Y = Maximum Number
But the problem is i wanted to know if there is a better random function than the one i have.
Because right now i put
Min = 1
Max= 2
and it keeps picking 1
if i had min =1 and max =2 i want it to pick 1 sometimes and 2 sometimes
and now i tried min = 1 max = 3 and it never picks 3, it only picks 1 and 2
ok
Public Class Form1
Public Function RandomNumber(ByVal MinNumber As Integer, ByVal MaxNumber As Integer) As Integer
[Code].....
I have an array of integers like these; dim x as integer()={10,9,4,7,6,8,3}.Now I want to pick a random number from it,how can I do this in visual basic?
View 2 RepliesOn a client i have an anonymous list containing a multi-column primary key previously selected from the DB.Then i need to select all the records from the DB that equals the primary key list i have stored in the memory.[code]
View 1 RepliesSELECT
T.TABLE_NAME as TableName,
T.CONSTRAINT_NAME as CONSTRAINT_NAME,
K.COLUMN_NAME as FieldName,
K.ORDINAL_POSITION
FROM
INFORMATION_SCHEMA.TABLE_CONSTRAINTS T
INNER JOIN
INFORMATION_SCHEMA.KEY_COLUMN_USAGE K
ON T.CONSTRAINT_NAME = K.CONSTRAINT_NAME
WHERE
T.CONSTRAINT_TYPE = 'PRIMARY KEY'
AND T.TABLE_NAME = 'mytable'
ORDER BY
T.TABLE_NAME,
K.ORDINAL_POSITION
Query for getting pk of a table. When I Run this query to fill dataset from dataadapter it does not return any value while it returns a row when executed from sql server. Fill method is called correctly as it is working from past 8 months and no problem is yet is there any special property of dataadapter. I also used to put above query in a sp and when try to execute that sp the result was sq not found.
i have four labels, and for item on Arraylist. how do i set the text of the labels from the Array list, at Random
Each label should pick and display one of the colors. one label should display different item each time i run the program[code...]
how to pick a random file out of a folder and open it, lets say we have text files. And i want to click a button and a random .txt file opens in my programs textbox.
View 11 RepliesI have a file that has names of competitors. I want to write a VB code that selects a random name from the file.What I need is show the names moving quickly once I press enter it will select the name.
View 1 RepliesI have quick questions for you guys how do I pick a random string from a listbox ? and also second question how do I randomize which line to pick out of a string array? lets say I have 5 strings
[Code]...
how I pick a random item from a array?Here's the little bit of code I got:
Dim array() As String
Dim words As String
words = "hello*123*abc*zxw"
array = Split(words, "*")
But what should I do next to randomly select a item from "array"?
So what I'm trying to do is not so much generate a random word but pick one from a collection. I was thinking on generating a random number since that is very easy, then picking a word acording to the number generated. Is there a more efficient way of doing this?
View 9 RepliesI have myMultiLineTextBox. How do I pick a random line of data from it?
View 4 RepliesI'm working on a new project and i need the program to pick one of the lines from textbox1 on a ramdom way: I have 1 timer and i want something like when the timer "ticks" to pick a different line from the textbox ex:
[Code]...
EDIT: was a design issueI am undergoing a computing project for Alevel computing.The project consists of a 6 tabled Microsoft access database. I am using vb.net to code the application for a student tracking system.My ERD is below:My problem: How to insert a new compound Primary key into a existing table?If I increment StudID and CourseID in tblContact then I need to increment them in tblStudentCourse which leads to records not pointing to the right directions..For enforcing the relationships I am using the .relations with the dataset.
'Student - StudentCourse
DS.Relations.Add(New DataRelation("StudStudCorRelation", DTStudents.Columns("StudID"), DTStudentCourses.Columns("StudID"), True))
[code].....
i have a project where I need to concatenate strings from 4 different tables based on a sequence of numbers. I created a 5th table that holds the number sequence and dictates in what order the strings get appended. I have created primary keys on the tables, but 3 of the tables are composite primary keys. I have written up to where I start referencing the primary keys, but am not sure how I should reference the keys on the actual tables. I saw some examples for creating composite keys from an array which I did. The main questions are did I declare the composite keys correctly, am I creating the composite key reference from the array correctly, and how should I reference it all to append to the stringbuilder variable.
[Code]...
And yes I kn ow it would be easier if I used Strongly Typed Dataset, but this is a clr sql stored procedure and have not found any examples on how to add a .XSD to a stored procedure. The add item option is not available, besides a bunch of typing
I am not so good at VB.NET, well, I am working with a school to run a Spelling Bee aimed at children in year 7. And to make it fair and unbiased i need an application that can choose randomise a word from the list box then transfer the string to the text box. So basically something that can pick a random string from the listbox and show it in the textbox1.text property.
View 4 RepliesWhat is the best way to manually generate Primary Keys in Entity Framework 4.1 Code First?
I am programming ASP.NET MVC 3 and I use a repository pattern.
I currently generate keys in a sequential order by using the [code]....
I had a post about how to disable monitors, but someone suggested just making it not possible to leave the primary screen. This was obviously a good suggestion, but im not sure how i would accomplish this.
I need to prevent the user from entering the ctrl, alt, delete, escape, and windows key. I also need to prevent the mouse from leaving the primary screen.
My program is a security login system. It requires a username and password to close, and i want to make sure that it cannot close unless the user supplies the correct username and password.
[Code]...
The Textbox.Text will be a new Item in ListBox when Button1.Click I want button2.click to pick a random item from the listbox and display it as the label. Think of it as a random raffle picker lol.
I need to have two pieces of software, made in vb where one encrypts the contents of a .txt file, and the other decrypts it, and then picks one word at random and displays it each time a button is pressed, but never displays the same word. Or, if there was a way to hard code it into the program as there is only 5 words that would be better.
View 1 RepliesI'm having some major issues trying to figure out What's going wrong with my code.
The general problem is that I can't get the foreign key in one of my child tables to populate the primary key from the parent table. I have a parent table named "ISSUES" and a child table named "ISSDESC". The primary key for ISSUES is ISS_ID which is an autonumber. The foreign key is ISS_ID in the ISSDESC table which is just a number. I'm using MS Access and an OLEDBConnection as the method. I've created the relationship in MS Access and also created the datarelation in the VB.NET code.
I am able to submit the information into the database into the two tables but the foreign key isn't being populated therefore not being linked to the other table.
I think it's probably a very simple fix, but it's been eluding me for a good 8 hours or so. I am using a dataset and 2 data adapters, one for each table.
Code:
i'm using an sql database, and on my application i load a listbox with data from table1. like:
Code:
dim sqlstr as string = "select name, code from table 1"
dim sqlcmd as new sqlcommand(sqlstr, conn)
dim dr as datareader
[Code]....
what i want now, is for the code also to be loaded to my listbox, but for it not to be visible to the user, so thet it can in the future be used in where statements.
I'm doing a project at the moment for school,I need to randomly pick a number from an array,which I can do but I can only use that number three times,I dont want an answer
View 8 RepliesI've read numerous posts and threads about random number generation, but I havent' run across this.If I generate a bunch of random numbers, the results are radically different if I create a new Random generator for each number than if I use on Random generator for all the numbers. The results are much more consistent and evenly distributed if I use the same Random generator.I would have thought the opposite,because creating a new Random generator each time should reduce the number of random repetitions, if a different time slice is used to create the random number.[code]......
View 9 RepliesI am trying to make a texas hold em game and it is of the utmost importance that my code generate a random number. But using a random number function that I always end up with a lot of the same numbers over and over again. Any ideas on how to make it "TRULY" random? [code]
View 3 RepliesI've made an image viewer which opens a random image from a specified folder, but the random number is not that random at all... I've already used Randomize(), but without result.
View 3 RepliesHow do you pick a random piece of text from a text file in this manner....
[Code]...
I need to pick a random answer, not including the question. let it be the simplest solution. I am only a beginner.
I have written a program which uses a SQL exception class and then use it show custom messages for the primary key violation. Also i want the primary key value that caused the violation. How can i get all the primary keys which generated the exception from the sqlexception object.[code]
View 1 RepliesI have a database program, and the first row of the table i'm inserting into is a primary key, just a number that increments by one each row. This is my SQL statement,
SQL = "INSERT INTO Squad VALUES('" & (NUMBER) & "','" & txtfirstname.Text & "','" & txtsurname.Text & "','" & txtdob.Text & "','" & cbxposition.SelectedItem & "','" & lblhiddenid.Text & "')"
I am in the process of creating a system using VB in Microsoft Visual Studio 2008. The system which I am creating is connected to an Access database via a tableadapter.Currently, I am coding a form for a table called Employee and this form allows the user to create a new employee, edit or delete an existing employee. Editing and deleting an existing employee works fine but adding a new employee is causing me trouble. When I specify an employeeID (this is the primary key), the declared value is stored appropriately in memory and it also displays in the form, however once I save the new employee to the database, the employeeID always defaults to 0 for some unknown reason. So, the record which I've just entered has a primary key of 0 regardless of what the the primary key should be.
The employeeID is declared as an integer and the value is obtained by getting the employeeID of the last record in the table and adding 1 onto it. I've also tried hard coding the employeeID and a specific number, but this does not make any diffence. I've reused the code from another part of the system which works fine before, but why it suddenly doesn't work is baffling me. The employeeID field in Access is a long integer.
[Code]...