I have a SqlDataSource that pulls data from a table randomly. When I get this data in a formview, i want to be able to page through it (< prev next >) in that random order. Make sense? So in other words, whenever the query is run, I want it to pull a list from a table in a random order (which I've already got). I just want to be able to click next and prev within that random order?
View 2 Replies
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.
display record in label on "first last next prev" buttons
View 9 RepliesHow do I sort my results in a random order. my code looks something like this at the moment:
Dim searcher As IndexSearcher = New IndexSearcher(dir, True)
Dim collector As TopScoreDocCollector = TopScoreDocCollector.create(100, True)
searcher.Search(query, collector)
Dim hits() As ScoreDoc = collector.TopDocs.scoreDocs
For Each sDoc As ScoreDoc In hits
'get doc and return
Next
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)
I have an asp.net 2.0 web app and one of the pages uses a grid to add/edit items before exporting the contents to excel. The items in the grid are selected based on a dropdown list--after the item in the list is selected, the grid goes and gets the items, populates a dataset and binds the dataset to the gridview. Some of my users are experiencing an issue where after deleting a random number of rows, a row not deleted will disappear or reappear. Though I have witnessed the behavior, I cannot duplicate it on my machine where the developement occurs (Win XP Pro, IIS 5.1, vwd2005 express). The windows 2003 server uses ASP.Net 3.5
Here is the code related to editing and deleting:
[Code]....
If I had to make a guess as to what was occuring, I would say that it appears at times to retain the deleted item's index after the grid is sent back to the user and tries to delete another row. But like I said, I can't duplicate the problem on my dev machine. if this might be caused by .Net 3.5 trying to run a 2.0 site?
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.
Why is this so hard? Seems like a simple task:
Here is what I am doing. Gridview to list a table. The table is mostly keys so I display one value and have a dropdown list to update the Instructor (key). Like one normally does, the dropdown list has a display value and a 'hidden' value which should be the value updated to the table, in the UPDATE event.
It does not work.
(1) When I click 'edit' the value in that field that was on the list of the grid is NOT the same value in the DropdownList, so the index of the ddl is not coming from the value on the grid (which is a hidden field on the grid).
(2) When I pick a new instructor, the value put into the table is basically random.
I would debug it but I have no idea what events to look at or how to look at the actions taking place during edit and update.
[Code]....
i use this query as my sql query :
SELECT TOP 5 * FROM MyTableName WHERE ID=@ID ORDER BY NEWID()
As you may know it gets 5 records by random. I use it with dataset and bind the listview to this dataset and in ItemDataBound i want to do some programming (like making some controls visible or invisible) i need itemindex.
but the question is : how can i get the itemindex of a listview when sql query selects records randomly?
I have a datagridview control that I'm using to display cache data to the end used on a web form. The issue that I'm having is that every time I re-run the application, and the cache data is re-generated... it loads duplicate data that's being displayed to the end user. I can't seem to figure out how to keep this from happening.
What I would like to have happen is that only unique data rows be returned and cached for the end user. Unless there are new data rows on the database that needs to be included in the cache data results...the previous data results should not be duplicated. I've tried to change a few properties on the datagridview control, but nothing seem to keep this from happening.
[code]....
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?
I am search option(textfield), normally i am giving exact input and click on button to get the result, but i want If I enter some character into seach field I need to return all results that have in the datase in the search field so that user need not type all the information in textbox like we have in google search.
I tried with following way but not able to acheive it, it pull only first letter match records..
Dim query As String = "Select vendor,ponumber,partno,description,qtyorder,qtybalance,duedate,processStep,ETA, Comments from openorder where PartNo like '" + txtSearch.Text + "%' "
I have a page where users can search by company name, the data list is pulled from an Excel spreadsheet hosted on the site. I'm seeing some strange results returned, for example:
In the company field say there are the following entries:
Anns Company
Bernards Business
Company B
Dermots Domain
Property Company
If I search for "Com" I get the following returns (correct):
Anns Company
Company B
Property Company
If I search for "Der" I get my "Sorry there are no matching results" message (Incorrect)
If I search for "Ann" I get the following returns (Correct):
Anns Company
And if I search for "e" I get the following returns (Correct):
Bernards Business
Dermots Domain
Property Company
It seems random as to why it doesn't return some values, I've tried moving rows around to see if that's the problem but it makes no difference. My range is set correctly in the spreadsheet.
When I debug the VB code behind, when I search for something that works correctly e.g. "Com" in the above example, once enter the value and click search Visual Studio begins steping into the code and shows me the contents of the variables however when I search for something that's not working e.g. "Der" and click search it immediatly returns the "Sorry there are no matching results" message and the code behind does not get steped into.
I have a page where I will insert all the data into the database. The page where I'm having problems is when I select an item from the checkboxlist it only displays one item. The data which is displayed is only the one that was inserted with one selected item from the checkboxlist. The following code is the page I'm using to try to retrieve the data from the database. I am trying to do is when a user selects the first, second, or third, or fourth item. The corresponding data appears in the gridview. In my current code, the record which has one item selected appears. If the user has more than one selected it does not appear. It comes up as empty. Is there a way I can do it?
[Code]....
(Mods, move if I put this in the wrong place) I'm running queries against SQL databases, and I'd like for the results of my searches to appear in table form in an email that is then sent out dynamically. I currently have the results appearing in a Datagrid on a webpage which I'm then manually transferring to an email form to send. I'd like to streamline the process so I don't need to do any manual entry.
How can I have a table/datagrid/whatever in an email that gets populated with the results of a SQL query?
am having three dropdownlists on my webform. On the based on their selection I am retriving records from a databas table. my code for retrieving records as follows.when I didnt select ant dropdownlist ans click the search button then it featch all records. but when i select an option from suppose i select from ddlDivision, even there is many records related to selected Division but it shows sorry no record found.
View 4 RepliesGridview is not being populated now that i built my objectdatasource in the code behind.. why. If i build the source on the aspx page and configure it that way, it returns results.. but when i try to build it in the code behind it just displays my empty template for the gridview.
[Code]....
see the below code. just sample page.
<body>
<form
id="form1"
runat="server">
<div>
<asp:GridView
ID="press_dl"
runat="server"
AutoGenerateColumns="False"
PageSize="1"
ShowHeader="False">
<Columns><asp:TemplateField><ItemTemplate>
test head
test shortnews
</ItemTemplate>
<HeaderTemplate>
</HeaderTemplate>
</asp:TemplateField></Columns>
</asp:GridView>
</div>
</form>
</body>
Protected
Sub Page_Load(ByVal
sender As
Object,
ByVal e
As System.EventArgs)
Handles
Me.Load
If
Not Page.IsPostBack()
Then
bind_press()
' bind_events()
End
If
End
Sub
Sub bind_press()
ds = Nothing
ds = New DataSet
Dim query
As
String
query = "select top 1 * from tbl_press order by press_id desc"
myConnection.Open()
da = New OleDbDataAdapter(query, myConnection)
da.Fill(ds, "Press")
myConnection.Close()
press_dl.DataSource = ds.Tables("Press")
press_dl.DataBind()
End
Sub
its dislpayes like this
test head test shortnews
test head test shortnews
this gridview displaying twice. i dont know why.
I have a gridview on a page with search boxes at the top.
The wildcard for these is % so in every serach box I set the default to be % so that when the page loads all records are shown and then they can be narrowed down by what you search for but when the page opens the gridview does not show all results.
Here is my code:
<%@ Page language="C#" masterpagefile="MainContent.master" title="Electrical Storage" EnableEventValidation="false" %>
<asp:Content id="Content1" runat="server" contentplaceholderid="Content">
<div id="Rightside">
<h2>Search Electrical Storage
[Code].....
My sql statement is not functioning correctly. The gridview does post the items correctly but the results are not correct. Can someone assist me with the sql statement where I'm going wrong with it?
I only have one being reffer to the code because I was testing to see it work. Eventually, the search will be base on multi select and the selected items are going to the stored procedure to search for the proper records.
The following is the site code and sql code. -carlos
Site behind code:
[Code]....
[Code]....
I read a few VB books and ready or not, I going to start building!I am "very afraid" of code behind. Frankly, much of what I read about OOP went a bit over my head and am hoping by "doing" it will all come together. That said...
Datalist results. I want them to hyperlink to another page with a querystring. I moved a hyperlink control into the EDIT TEMPLATE box and removed the origianal label that was in the box. I did some editing and was able to come up with a hyperlink, but I really need a hyperlink to a new page with the original result of the datalist being the querystring parameter. For example...
If BABE RUTH is the datalist result, I want the querystring to be www.mysite.com?athlete=BABE%20RUTH. I am fairly competant in asp classic. I feel like a guy who has amnesia and has to learn the most basic stuff from scratch.
I have a list box which gets the value from a datasource as
[Code]....
Here, 'ALL' passes all the WORKSHOP_REQUEST_ID
Now, once the user enters the "Search" button on the window, the listbox shows all the searched values and also the "ALL" option. But here also , this "ALL" doesn't care of the searched values displayed on the listbox but sends all the WORKSHOP_REQUEST_ID if it is selected.
But i want to pass only the values which are searched and displayed on the listbox if the user selects "ALL" after searching some text.
Depending on the data returned from a Stored Procedure, I need to add specific controls to a page and then when they are populated by the user, write them back to the database. What is the easiest way of doing this?
View 9 RepliesI am using visual studio 2010, asp.net 4.0 (c#)
My problem is:
How do I display results from my database on a gridview based on the selected row of another gridview.
For example, I have a e-shop web app and I have a product categories table in my database displaying the data on a gridview.
I want to be able to click on the select button on each row and use that event to populate another gridview based on the ID of the product category that is clicked. E.g say the 'CDs' row is clicked, another gridview shows all the different CDs.
As a result, I need the select(sql) statement for the second table to be dynamic based on what the user clicks.
Has anyone done anything like this before?
i have table that trace views of my page. every row has the id, date view (dd/mm/yyyy hh/mm/ss) how can i distinct the data into gridview (or something else) and display only the days (01/03/2011, 02/03/2001, 03/03/2011) and to sum the numbers of views (01/03/2011 1,290 views, 02/03/2011 867 views.....)
View 7 Replies
