Forms Data Controls :: Best Method To Bind SQL Datasource - Views For Show 50000 Record In Grid

Nov 10, 2010

I have 50000 record in two tables which need to show in grid? and the records in the table use to insert , update and delete frequently. I need to load fast all the records. which method i should bind to get as quick as early as possible. Which z best method to bind whether using SQL datasource, creating views, using datatable, creating stored procedure etc?

View 8 Replies

Similar Messages:

Forms Data Controls :: Display Child Record Details On Click On Parent Record In Grid

Jul 6, 2010

i have one parent grid on which if user clicks a record ,the child details should get displayed on same page.

for example :

There is one department details table and employees table:

if user selects a record in department details grid,then employees in the selected department should get displayed in the next grid in the same page

View 2 Replies

Forms Data Controls :: Create A Second Grid In The Same Page With Detailed Info For A Given Record Of The First Grid

Jul 6, 2010

I am trying to create a second grid in the same page with detailed info for a given record of the first Grid, but when I press select in the first grid nothing happens. I follwed everything I read.

<asp:GridView runat="server" AutoGenerateColumns="False"
DataSourceID="SqlDataSource1" style="margin-right: 0px" Width="659px"
AutoGenerateDeleteButton="True" AutoGenerateEditButton="True"
AllowSorting="True" DataKeyNames="accession_num,organ"
EnablePersistedSelection="True" EnableSortingAndPagingCallbacks="True" onselectedindexchanged="Unnamed1_SelectedIndexChanged"
<asp:BoundField DataField="organ" HeaderText="organ"
SortExpression="organ" />
<asp:BoundField DataField="weight" HeaderText="weight"
SortExpression="weight" />
<asp:BoundField DataField="unit" HeaderText="unit" SortExpression="unit" />
<asp:BoundField DataField="accession_num" HeaderText="accession_num"
ReadOnly="True" />
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%&#36; ConnectionStrings:pdmstestConnectionString %>"
SelectCommand="GetGrossOrgan" SelectCommandType="StoredProcedure"
UpdateCommand="UpdateGrossOrgan" UpdateCommandType="StoredProcedure"
DeleteCommand="DELETE FROM [Pathology_Gross_Organ] WHERE [accession_num] = @accession_num AND [organ] = @original_organ"
> <SelectParameters>
<asp:ControlParameter ControlID="accession_num" Name="accession_num"
PropertyName="Text" Type="String"/>
<asp:Parameter Name="accession_num" Type="String" />
<asp:Parameter Name="original_organ" Type="String"/>
<asp:Parameter Name="accession_num" Type="String"/>
<asp:Parameter Name="organ" Type="String"/>
<asp:Parameter Name="weight" Type="Int16" />
<asp:Parameter Name="unit" Type="String"/>

View 8 Replies

Forms Data Controls :: Pop Up To Show When No Record Is Selected And Tell The User To First Select A Record?

Mar 21, 2011

I have a delete button bellow my gridview and I want a pop up to show when no record is selected and tell the user to first select a record. The button click event would show the pop up, but my gridview data blanks out.

Here is my code:


View 1 Replies

Forms Data Controls :: Two Grid Views - Out Of Line

Jul 16, 2010

I have two grid views in my page..first one normally displays many number of rows..But the second one displays 3 or 4 rows....when the project running, the second one seems to appear at the centre of the first..that is if the first grid has 12 and second grid has 4 rows ..the first row of the second is in line with the 5th row of the second..why this happen? I want a normal display..The first row of the second grid should be in line with the first row of the first grid.

View 3 Replies

Bind Selected Record To Grid Fro Xml Sheet?

Dec 7, 2010

I have a xml sheet in the form of

<marker name="abc1" label="xyz" place="mno">
<marker name="pqr2" label="lmn" place="mno">
<marker name="abc3" label="xyz" place="mno">
<marker name="pqr4" label="lmn" place="mno">
<marker name="abc5" label="xyz" place="mno">
<marker name="pqr6" label="lmn" place="mno">

I have to bind this xml file to a grid view and with "name" field as linkbutton.
Clicking on the linkbutton should display a separate grid displaying only that particular record with edit/delete options.first part I am able to do successfully with the help of google. But I am unable to do second part. I am very new to programing.

View 1 Replies

Forms Data Controls :: Aligning Columns Of Two Separate Grid Views?

Jun 10, 2010

I am using two Grid Views to display data. One (headersGV) is used to show custom headers which change depending on the device type in the second table (dataGV).

The second displays device data and is bound to db tables. This table has a sort mechanism enabled, the functionality of which is in the header cell of the table, hence the need for the headerGV for column headers.

I need to align these two seperate tables so that the headers align with the data columns in the other table. The dataGV columns dynamically resize depending on the data displayed.

I have tried inline styles, css bound to both tables at different levels of priority, onbind methods, and overriding DataBind() method.

View 6 Replies

Forms Data Controls :: Export To Excel With Two Sheets From Two Grid Views?

Jun 16, 2010

Export to Excel with two sheets from two grid views. I am in need of export two grids into a single excel with two sheets.

View 2 Replies

Forms Data Controls :: Show Grid With All Orders And In Grid One Column With Last State Of Order?

Feb 2, 2011

I have an entity "Order", which contains a set of states. Every state has date and name.

I want show grid with all orders and in grid one column with last state of order. But I dont understand how to do it.

View 1 Replies

Linq To Xml Datasource For Grid View Is Not Working - The Grid Show No Rows

Jun 30, 2010

I'm getting some Xml back from a service. I would like it to be the datasource of a grid view on my aspx page. Here is a sample of the Xml

<?xml version="1.0" encoding="utf-16" ?>
<ArrayOfTripTollCompleteDC xmlns:xsi=[URL]"
<DMSLaneModeID xsi:nil="true" />

and here is my code that parses the xml and tries to bind the grid. What am I missing here?

var retVal = service.GetTripDetailsByTripID(tripId);
var xmlTrips = XDocument.Parse(retVal);
var tripTolls =
from t in xmlTrips.Elements("TripTollCompleteDC")
select new {
TripTollId = (int)t.Element("TripTollId")
, DMSLaneModeID = (int?)t.Element("DMSLaneModeID")
, HOVOnly = (bool)t.Element("HOVOnly")
, CreateDateTime = (DateTime)t.Element("CreateDateTime")
, ConfigVTMSDelaySeconds = (int)t.Element("ConfigVTMSDelaySeconds")
grdTripDetails.DataSource = tripTolls;

I realize these are anonymous types. Is that a problem? I have verified the service is returning the Xml as stated above. Can anyone out there point me in the right direction? Just for completeness, here is the grid markup <asp:GridView runat="server" ID="grdTripDetails" />

View 1 Replies

Forms Data Controls :: Update A Particular Record In The Grid?

Jan 30, 2010

I want to update a particular record in the grid. This is wat i am writing


why is the RowUpdating() event not happening...

View 3 Replies

Forms Data Controls :: Bind Grid In JavaScript?

Oct 25, 2010

Is there any way to bind my grid from javascript.

How can I do this in

View 3 Replies

Forms Data Controls :: Bind Grid With Xml Stream?

Aug 12, 2010

I'm getting an xml stream from one website.and i need to bind my grid with that xml value.

View 5 Replies

Forms Data Controls :: Search A Particular Record In Grid View?

May 30, 2010

Hoe can search a particular record in a data grid-view

View 4 Replies

Forms Data Controls :: GridView Bind Field Foreign Key's Data Record

Dec 6, 2010

I have two tables

Employee Table : ( EmployeeID,EmployeeName,... Etc )
Bonus Table : ( BonusID,EmployeeID,BonusDate,Bonus Reason,... Etc )

I wanted to list the bonuses in a gridview, so i made a query to return list of bonus records and my data access object returns the result set as Bonus business object ( generic collections of bonus BO ). i have bind my gridview with the bonus collection.

now my problem is that collection has the property "EmployeeID" and it will be displayed but instead of showing EmployeeID, i wanted to show Employee Name in that grid. I have a gridview where i want to list the bonus records ( bonus ID, bonus date, bonus description, employee ID) ,

View 5 Replies

Forms Data Controls :: Select Query For Each Record Of Dataset Then Bind In Gridview?

Jun 10, 2010

i wants to display the related informations of each record of dataset. That mean, dataset having rows for A,B,C and etc..

Then i wants to display the information in same Gridview of each record(A,B,C). i wrote the below my coding, it dispaly info of the last row of dataset only. pls correct the coding.


View 3 Replies

Forms Data Controls :: How To Bind Large Number Of Record At Single Click In C#

Nov 18, 2010

I have developed one simple application in that i am using mysql database. but my database size more thatn 4,50,0000, as well as ecah and every second my database is updated i.e record ll be added to the table how can i get the details for one single click.

View 1 Replies

Forms Data Controls :: How To Bind Video Object To Grid

Nov 9, 2010

how to bind video object to gridview.

i have tried this

<asp:Label ID="lblAns" runat="server" Text='<%# DataBinder.Eval(Container.DataItem, "Answer")%>'></asp:Label>

but it is not working.

View 3 Replies

Forms Data Controls :: How To Bind Fields Dynamically In Grid

Jan 20, 2011

I dont understand how to bind grid view fields dynamically..

whenever user send question then i directly bind that

but whenever same user share their images then i want to bind that images into same grid...

so what can i do for that...??

View 5 Replies

Forms Data Controls :: Bind A Table To Grid View?

Sep 6, 2010

I am trying to bind a table to my grid view. This grid view has an extra column Serial Number where I want to show numbers starting from 1 till the last entry.

View 4 Replies

Forms Data Controls :: How To Download Files From A Grid View Record

Nov 10, 2010

I have a grid view that I made dynamically based on a data table. The fields that are displayed on the grid view are as follows:

File Name
File TyPe
Uploaded On

Where as the data table on which this grid is based contains one extra filed that is


This filed contains the contents of the file in binary format retrieved from the data base.

Now I wanted to download the file say by clicking on the file name on the grid or even I an agree to add a Download button to the grid that will download the relevant file.

View 2 Replies

Forms Data Controls :: DataGrid Or Grid-like Control For Record Selection?

Feb 20, 2011

I would like to ask if there is any control act like grid to display records.The 'datasource' will be a customed class, this dataclass has List<T>, so I will populate each element by iteration into the grid.Any control can I use to work like a grid?The number of records will around 100.This control should also allow the user to select a record.

View 2 Replies

Forms Data Controls :: Updating Fields In A Passed Record From Grid?

Apr 17, 2010

I've got a gridview with three fields, the last of which is a template field with an imagebutton in.

The first field is a Date, and the second is a time field (it is however just varchar field as it may differ and will not be programmatically used).

I want the following to happen if I click on the imagebutton (reserve):

Four other fields must be inserted into the record.

Is the best way to launch a detailsview where the row.imagebutton@=ID and just edit the fields like that or should I pass the two fields (and RecordID) along with the query string to a new page where the passed information can be in invisble textbowes and just have the user enter (UPDATE) the four outstanding fields? I feel like doing it this way?

can read on 1. setting up the onrowcommand code for the templatefield 2.

This should be simple as it is only one table with records that has to be partially inserted by an admin person (2 Fields) and then completed by a web user (4 fields).

View 4 Replies

Forms Data Controls :: Find Total Number Of Record(s) In A Grid?

Jan 8, 2011

I have data grid with page size 15. I need to find total number of record(s) in a grid. How to do it?There is two ways to do:

1) Here I have used LINQ. So calling stored procedure again and we can done using .Count () property. But here I don't want make call to data base again.2) Creating our own logic like here I have done like:

(dtgCustomerSearch.PageCount - 1) * (dtgCustomerSearch.PageSize) + dtgCustomerSearch.Items.Count

The above result gives me correct result only when I am on last page.

View 8 Replies

Forms Data Controls :: How To Count Total Record In Data Grid And Export To Excel

Aug 6, 2010

how to count total record in my data grid and after that export the records to excel ?

Below are the coding of my datagrid .

GridView id="grdCustomer"
void Data()
qry = "select * from customer order by customerId DESC";
DataSet ds = new DataSet();
ds = DBUtil.getTable(qry);
if (ds.Tables[0].Rows.Count != 0)
grdCustomer.DataSource = ds;
lblMsg.Text = "Customer List Is Empty";

View 2 Replies

Copyrights 2005-15, All rights reserved