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 Repliesi 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
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"
>
<Columns>
<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" />
</Columns>
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ 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"
OldValuesParameterFormatString="original_{0}"
> <SelectParameters>
<asp:ControlParameter ControlID="accession_num" Name="accession_num"
PropertyName="Text" Type="String"/>
</SelectParameters>
<DeleteParameters>
<asp:Parameter Name="accession_num" Type="String" />
<asp:Parameter Name="original_organ" Type="String"/>
</DeleteParameters>
<UpdateParameters>
<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"/>
</UpdateParameters>
</asp:SqlDataSource>
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:
[Code]....
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 RepliesI have a xml sheet in the form of
<markers>
<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">
</markers>
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.
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.
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 RepliesI 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.
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]"
xmlns:xsd=[URL]>
<TripTollCompleteDC>
<TripTollId>5</TripTollId>
<DMSLaneModeID xsi:nil="true" />
<HOVOnly>false</HOVOnly>
<CreateDateTime>2010-06-07T15:54:01.023</CreateDateTime>
<ConfigVTMSDelaySeconds>5</ConfigVTMSDelaySeconds>
</TripTollCompleteDC>
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;
grdTripDetails.DataBind();
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" />
I want to update a particular record in the grid. This is wat i am writing
[Code]....
why is the RowUpdating() event not happening...
Is there any way to bind my grid from javascript.
How can I do this in asp.net?
I'm getting an xml stream from one website.and i need to bind my grid with that xml value.
View 5 RepliesHoe can search a particular record in a data grid-view
View 4 RepliesI 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) ,
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.
[Code]....
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 Replieshow 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.
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...??
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 RepliesI 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
FileContents,
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.
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 RepliesI'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).
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.
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;
grdCustomer.DataBind();
}
else
{
lblMsg.Text = "Customer List Is Empty";
}
}