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?
How to retrieve the data from the session (Dataset) and save it into a database
[code]...
I have created a Dataset object (XSD file) whithin it there is a procedure called InsertWebsite.
In my code, I call this like this:
[Code]....
When I execute the commans it retrievs value "1" which is not the actual ID genereted by Insert event.....
How can I retrieve this ID and stll using the current design?
I have a dataset where I would like to upper all string fileds and when done check each field for a value. The other way i thought to do it is to do an upper of each string when I do the conditional check. I would like to know what is quicker upper of the values in the dataset or upper in the conditional statement? Knowing the dataset will contain a max of 10.000 rows and there are multiple conditional statements in the complete process.
View 4 Repliesit is apparent that "string builder" is better for building large string compared to sMyString = sMyString + "something";
what is a better way to search large in memory datasets? (like the example above - i know i could use loops, is there another way that i dont now about?)
I added a new table to my type dataset. When the code tries to execute the new row on that table I get the error message.
(if you can't see the error. "MissingMethodException was caught" "Method not found: 'MyTableDataTable MyNamespace.get_SSCase().")
I've tried the wizard and also click and drag the table from solution explorer to the xsd file. The other tables work, just this one table won't work. What should I check?
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)
how to retrieve all records of dataset for calculation with each record? with sample coding.
View 3 RepliesI wanna iterate the "DataColumn" values, I have retrieve data column from a dataSet.
GridView1.DataSource = ds.Tables[0];
DataColumn colt = ds.Tables[0].Columns["dorc"];
the dorc field is a boolean value, I want to replace the boolean value from:
true-->debit
false-->Credit
But I can't access the Columns["dorc"] values..
I dont know why my GridView.DataSource is become nothing when the Page.IsPostBack = true.What i did is bind the dataset to the GridView.DataSource when page load. Then when the button click event is trigger i need to get all the records from GridView. But when i debug and check i found that the GridView.DataSource is become nothing. how should i get all records from the GridView and assign to dataset. I'm using VB.net to work on.
View 6 RepliesI am having dataset and I want to validate particular column for Integer(Numeric) value.
e.g.
ErrorRows = dt.Select("LEN(Year) <> 4 ")
Above I have to validate Year column for Numeric value otherwise it should give me erroneous records which have data other than numeric.
i have 2 dropdown list and i need to create a Generic method so that I an reuse it...
View 1 RepliesToday I am facing the problem with Typed DataSet using DataSet.XSd file, And How to fetch, Delete and Update the Database through Dataset.xsd file.
View 9 Replieshow do i copy required row in dataset to a new dataset. i have bind a xml into a dataset and i need to display say row 3 to 5 only so i do a for loop but i have encounter problem when trying to copy the rows to a new dataset.
do i have to write the xml to datatable and bind it to dataset and from there copy over ?
I'm building a Remoting Demo, and here's my scenario:
There are 4 projects:
ServicedCOM: This project I've built a ServicedComponent, this component using for access data from database.
RemoteLoader: I using this to load ServicedCOM to RemotingServer.
RemotingServer: This is an console application, and this application can be running from another computer.
WebApp: Client, this is inteface using for End User.
and my results: I can access and retrieve data with function is called SpeakHello (test function), but I cannot do the same thing to get sectors using this model, I think I'm doing something wrong. and here's my code snippet:
1. I have a ServicedCOM and a function to get Sectors is called GetSectors (I test OK)
[Code]....
[Code]....
2. I have a Remote loader
[Code]....
3. And here's RemotingServer
[Code]....
4. And the last is Client
[Code]....
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
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 Repliesi have two sqldatasource controls. one i use to display data in textbox's ,filter'd by a select parameter in page behind code. Once checked, i want to copy this data to the other datasource ,by selecting checkbox.Then display this data in detailsview control.
At present the two datasource controls declared , render data to the page simultaneously during pageload. I want to first check data in textbox's from first source, before second datasource is rendered to screen. note, both are filtered by a page variable. i wish to leave the textbox datasource control in situ, as other controls and code depend on it.The other detailsview datasource is my problem?
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.
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
i create a loop for select data from one table based on different condition.
e.g.
for ......
select * from [table] where condition 1
select * from [table wheere condition 2
i have a problem, how can i fill each select into one dataset
since i want to display all and bind into gridview
is datable data store in asp.net dataset.. ?
View 1 RepliesI have an application that needs to read data from a view and do some extensive manipulation prior to delivering it to a chart control (without modifying the original data in the database). I have the chart control on the page, and in the code-behind I've built a dataset which I load and manipulate programmatically to have the table, columns and rows needed (no datareader involved) I'm having considerable trouble binding the chart to the 'in memory only' dataset. Chart Control;
[Code]....
Code-behind; The arrays arDate(), arPropBase(), arPropRisk() and arProject() are declared and loaded prior to this code. I am certain that the arrays do contain valid data - I have verified that while debugging
[Code]....
I have tried many different ways to bind the chart to my dataset at runtime without any success;
[Code]....
I am having trouble inserting data into the table using dataset..following is my code:
[Code]....
The m_id is a primary key..I want to auto-increament it everytime a data is inserted into the table so I have configured (isIdentity) to Yes and Identity increament to "YES"..I don't know if its right or not..I already added some data manually into the table but now I want to add more data using the above code..but its not working..
[code]....
I've got a SqlDataSource that is created in the markup and would like to transfer the data to a dataset in code behind. How do i do this?
View 2 Replies