DataSource Controls :: Pull A Random Record From The Db?

Jan 22, 2010

I want to pull a random record from the db.

Here what I have so far.

Dim RandomNumber As New Random()
Dim num As Integer
num = RandomNumber.Next(1, 75).ToString
Try
Dim Cnn As New OleDb.OleDbConnection("File Name=E:WebRHIUDLShelf_Life.UDL;")
Dim da As New OleDb.OleDbDataAdapter("SELECT tbMaster_List.dbMFG, tbMaster_List.dbDescription, tbInStock.ID, tbInStock.dbMFG_Lot_Code, tbInStock.dbDateReceived, tbInStock.dbDateOpened, tbInStock.dbExpireDate, tbInStock.dbLocation FROM (tbInStock
INNER JOIN tbMaster_List ON tbInStock.LnkToMaster = tbMaster_List.ID) ", Cnn)
Cnn.Open()
Dim dtt As New DataTable()
da.Fill(dtt)

This is were I am stuck.

I need to filter all rows out except where row(index) = num

Me.GridView4.DataSource = dtt
Me.GridView4.DataBind()
Catch
Label1.Text = "Error: Unable to Pull Data"
End Try

View 7 Replies


Similar Messages:

C# - How To Pull A Random And Unique Record From SQL Via LINQ

Apr 23, 2010

how to pull a RANDOM item from the database when using LINQ. There seems to be a couple of differnet ways to handle this. What I need to do though is pull a RANDOM item from the database that the user has not seen before.

The data I am pulling from the database is very small. Is there any way I can just hit the database once for 1000 records and then randomly scroll through those?

Should I put a cookie on the users system recording the IDs of which items they have seen, pull a random record, check to see if it is seen and if so, pull from the database again? That seems like performance issues just waiting to happen.

View 1 Replies

DataSource Controls :: Can Pull A Top Record And Avoid Duplicates

Feb 3, 2010

I have location #s, date, time, the sales amount, and tax in a excel file. The system pulls sales numbers throughout the day from each store location and places the total sales and tax numbers along with the polling date into a file.

So the most current date/time has the most upto date sales numbers at the time for that location number, but it also lists the older entries so mgmt can see how sales went during the day, and this is where my issue is, I don't need to see the old numbers from this generated file (atleast at this part of the program).

What I would like to do is write a query that only selects the most recent sales numbers for each location. I will output this to a table in ASP.NET. The query I tried using the TOP 1 clause only gave me the very first row listed below.

[code]....

View 5 Replies

DataSource Controls ::character To Column Name Then A New String Random Will Auto Insert Into Column Random?

Dec 15, 2010

I create a table as picture below :

when I insert any character to column Name then A new string random will auto insert into column Random (picture below) I had used Trigger but It was error !

I want to column Random use to code :

DECLARE @myid uniqueidentifier
SET @myid = NEWID()
insert into table_1 values(@myid, substring(CONVERT(varchar(255), @myid), 1, 5))

but It must auto like column Number (column Number is Identity)

View 1 Replies

Forms Data Controls :: Selecting Random Record From Database

Apr 21, 2010

I'm trying to select a random record from my database and display the details of the record on screen. The table I am using is the aspnet_Users table which as I'm sure you all know holds the details of users. After a bit of googling, I found the following code:-

[Code]....

I've built my page and I get no errors which is a great start I just can't seem to figure out how to then display the results of this query on the page. I just want to display the username for the record that is selected.

View 16 Replies

DataSource Controls :: Pull All SQL Objects From A Database?

Jun 10, 2010

I was put in charge of a database that has no source control, and all work was done in the database. I want to pull all the objects (stored procs, views, tables) from the database, and add to my new source control.

Is there a way to get all the objects into individual files out of a database?

Our database is SQL 2005. I have Visual Studio 2005/2008/2010 (beta 2) at my disposal.

View 5 Replies

DataSource Controls :: How To Pull Only The Current Month Data From SQL

Jan 20, 2010

How would you pull only the current month data from SQL?

View 9 Replies

DataSource Controls :: Pull Google Maps Date From SQL Database?

May 27, 2010

On a test page, I successfully created a google map that pulls both marker and infoWindow information from an XML file. I did this just to get a feel for working with the API. It works fine. However, I do have a SQL database that has this information in it already. This database is updated behind the scenes regulary via a webservice.

I would like to try pulling the map information from my SQL database instead so I don't have to hand maintain the .xml file. The dabase alread has the lat/long information needed for markers. What is the easiest way for me to get that data from the SQL database? Is there a way to run a query and use the data, or will I need to run the query and somehow have it write/update my .xml file for me?

View 4 Replies

SQL Server :: Show 5 Random Record From Table?

Jul 17, 2010

i need to show for every refresh of page five categories, every time different how can i do? in SQL do not exist select RND(field)...

View 5 Replies

DataSource Controls :: Row Count Shows 1 Record But There Is No Record In Database Table

Jun 24, 2010

I am counting from a table for that i have written code as below

protected void get_Id_Afterpoint()
{
int counter = 0;
string strSql = "select count(*) as ID from tblEnergy where ID=?";
OdbcCommand com = new OdbcCommand(strSql, con);
com.Parameters.AddWithValue("ID", DropDownList1.SelectedValue);
OdbcDataAdapter oda = new OdbcDataAdapter(com);
DataTable dt = new DataTable();
oda.Fill(dt);
if (dt.Rows.Count == 0)
{
lblID2.Text = "1";
}
else
{
counter = dt.Rows.Count;
counter = counter + 1;
lblID2.Text = Convert.ToString(counter);
}
}

there is no record related to DropDownList1.SelectedValue. but as i am counting if(dt.rows.count) and i put break point on the bolded part it shows 1 record. how it can be possible?

View 5 Replies

DataSource Controls :: Pull A SubString From A Linq Datasource But Can't Use INTs Per .SubString(int, Int)

Feb 5, 2010

I need to pull a SubString from a Linq Datasource, but can't use INTs per .SubString(int, int) I have strings such as xxxx.xxxx.xxxxx.AAAA.xxxx.xxxx.xxxx.xxx and I need to pull AAAA out. the preceeding x's will be varying lengths, so I can't use a static int. What I do know is that there will be a static number of periods (.) leading up to the AAAA. I can't figure out how to use the SubSting with characters rather than indexs. This is what I have so far:

[Code]....

View 2 Replies

DataSource Controls :: Getting The PK ID Of The Newly Created Record After Inserting A New Record?

Dec 20, 2010

I am creating an album using the following stored procedure, which returns the primary key for the newly created record:

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[fpa_sp_albums_update_insert]
@album_id int,
@album_name nvarchar (50),
@album_descr nvarchar(250),
@album_img_cover_id_FK int,
@album_creation_date date
AS
If @album_id > 0
UPDATE [fpa_albums]
SET
album_name=@album_name,
album_descr= @album_descr,
album_img_cover_id_FK = @album_img_cover_id_FK,
album_creation_date = @album_creation_date
Where ((album_id = @album_id))
Else
INSERT INTO [fpa_albums] (
album_name,
album_descr,
album_img_cover_id_FK,
album_creation_date)
VALUES (
@album_name,
@album_descr,
@album_img_cover_id_FK,
@album_creation_date)
Return SCOPE_IDENTITY();

I execute the above stored procedure using the SQLHELPER. The VB.NET code for the page is as follows:

[Code]....

However, the createdAlbumID always shows -1 instead of the id for the newly created album.

View 1 Replies

DataSource Controls :: MSSQL Select A Random Row?

Jan 14, 2010

How can I select a random row and then update or delete it? I've found how to get a random row, using SELECT TOP 1 column FROM table ORDER BY NEWID() do I have to make another select using this result in order to update the row, or it can be done more efficiently?

View 10 Replies

DataSource Controls :: Random Results From A LINQ To SQL Query?

Jan 23, 2010

I have this LINQ query:

var agnts = (from a in db.agents select new { a.userid, a.name }).Take(10);

How can I get randomly get 10 records from my agents table?

I have tried:

agnts = agnts.OrderBy(n => Guid.NewGuid());

but this doesn't seem to do anything.

View 5 Replies

DataSource Controls :: Select One Random Photo From Each Event?

Apr 2, 2010

I have two tables, events and photos, in the relationship one event to many photos, joined by Event_ID.

I want to write an SQL Query, to display one random photo from each event in the database.

What would I have to write to make it do this? I know its something to do with Inner Join and Group by, but I'm not sure.

Field Names:

Photos.PhotoID
Photos.Event_ID
Events.Event_ID
Events.Event_Title

View 25 Replies

DataSource Controls :: Method To Retrieve Random Data From Dataset?

Apr 15, 2010

Is there any method by which we can retrieve random data from a dataset or rather directly from a table.

For example, I have around 30 questions in my table, I just wanted to display 20 among them and that too in a random order without the same item repeating. Can we achieve this using SP or through some Dataset manipulation?

View 1 Replies

DataSource Controls :: Create Sql Server Table With Unique Random Identity Between 45365 - 5782155129452?

Jun 12, 2010

How to create sql server table with unique random identity between 45365 - 5782155129452 ?

View 5 Replies

DataSource Controls :: Using LINQ To Pull Out A Single Value From A Single Result Row Of A Join Query?

May 25, 2010

For context: First of all, I am new to LINQ, as I have been using SubSonic for quite some time now.

I have two tables, Users, and Affiliates. They both have a very typical schema. The FK that joins them is the UserId field, which is in the Affiliates table. I want to create a LINQ query that pulls the Username from the Users table using the AffiliateId value. The AffiliateId is a primary key of the Affiliates table.

I have tried to accomplish this using many variations of the following code:

[Code]....

In the above query, I expect to get a single row result set. However, I instead receive the entire table of results.

How can I make this work? I have yet to see an example or article out there to do what I am trying to do.

View 9 Replies

DataSource Controls :: SQL Insert A Record Using VB?

Mar 31, 2010

I'm very new to this area and am using ASP.NET 3.5 with WMD 2008 Express Edition and VB code.

How do I write records to the SQL database using VB? I want to use the connection string, etc used in the ASP.NET controls if possible.

My website is a Rugby Club site and I've an SQL database of match fixtures which include TeamId(1XV, 2XV, etc.), Season(2008, 2009, etc) and match date.

I allow some users to update the fixture details but want to insert a series of new fixture records for the neext season which contain just TeamId Season and Match Dates. I therefore want to take the season and Team Id from label fields and then create match dates by adding seven days to a start date.

View 4 Replies

DataSource Controls :: How To Get And Use Record ID In Same TableAdapter

Feb 5, 2010

There are several articles and blogs that are sort of about this subject but I haven't found one on point. Wondering if anyone has done this? Using VS2008 creating an ASP.NET 3.5 app with a strongly-typed dataset connecting to an MS SQL backend. In one TableAdapter, I have a custom Insert statement that inserts the record into the primary table. There are two other tables the also need records inserted into them and those records contain the record ID from the primary table. Here's an example of what I'm trying to accomplish:

[Code]....

View 3 Replies

DataSource Controls :: Linq To XML - Get The Next Record?

Jan 28, 2010

I have the following xml:

[Code]....

If I have an ID, I would like to retrieve the next item that also has the same category as the item ID I have. So, for example, if I have ID=2, I would like to return the item with ID=4 (as item ID=3 has a different category).

View 2 Replies

DataSource Controls :: Get Last Record Of Each Group?

Apr 22, 2010

This is my table.

I want ms sql query to get result

ID ProcessID Processname Date
105 123
Sammying 2010-04-22 12:09:02.827

View 8 Replies

DataSource Controls :: Select Top Record From Sql Statement

Mar 17, 2010

If I run the following SQL script:

[Code]....

View 3 Replies

DataSource Controls :: Best Way To Find Out If Record Exists?

May 14, 2010

best Way to find out if record exists?

[Code]....


View 2 Replies

DataSource Controls :: How To Check If Record Exists

Jan 6, 2010

Just have a problem, I want people to join a mailing list, I just have a textbox and button. When a user enter's their email address, the address and time are inserted into a database. However, if the same email is added again I would like for a message to appear saying the record already exists.

Can someone show me how to do this, here is my current code:

[Code]....

View 3 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved