I have a look-up grid with two columns, Last name and AddressI need that look-up grid to take as little screen real estate as possible, but I have to include the "Select" function next to every row.Any way I could fire the Select function by clicking on the ROW verses the "Select" function
View 8 Repliesi am developing real estate website.
i want to integrate MLS (Multiple Listing Service ) to my website.
how can i integrate this in my site..
i am developing real stat project i want that user add their property,mark their property in google map then these mark are stroe in sql database
and when other user search this property then it shows this property marks in google map
just done by a developer in website [URL]
i have one grid and one button when i click on that button then it expand and showing another grid under the row of parent grid how to do that.
View 2 RepliesWe have a requirment to draw a graph (line or bar), where the data will be changed 40 to 50 times in second , we want to refresh data automatically.
Which chart component should we use for drawing graph and how do i make sure that the data will be refreshed very fast on the graph web page.
Following is my case in detail.I have a class against which I will configure an objectDatasource(I have a datatable in the class which the data will be initially loaded from the database.)A gridview which has provisions to add/update/delete records will be bound to the objectdatasource
My methods i.e. insert/update/delete will be manipulating the datatable and NOT the database directly(I DONT WANT TO CONNECT TO THE DATABASE IN THESE STEPS. THE REASON IS THAT THE INSERTS/UPDATES/DELETES WILL BE PERSISTED ONLY WHEN THE USER CLICKS A SAVE BUTTON(MAY BE PLACED OUTSIDE THE GRID) . My class to which the objectDatasource points to will have anadditional AcceptChanges method which will be called on clicking the save button. This method is the one which connects to the database and where the adapter.update will be called.The query here is that how do I call the AcceptChanges method of my class instance which is bound to the grid? Also I would like to get some websites where I can see the real world implementations of gridview(with insert/update/delete options) so that I can improve my implementation.
I have a Table (in SQL Server) that is being updated roughly every minute or so with new records being inserted from various sources. The number of records inserted in this duration varies from a few records up to dozens of new records. I am using an update panel to rebind my data every minute to keep the GridView current. Now that I have the data refreshing I am looking for a better solution than reloading the data every minute. how to best keep my GridView up to date? Here is what I would like to accomplish:
1. Load the GridView and refresh the contents every minute. (60 second intervals)
2. When the GridView is refreshed every minute I would like to append only the new records to the existing grid, rather than bringing back the entire result set with each round trip to the database.
3. I would like a visual cue to identify the rows that have been inserted into the GridView. If new rows were to flash/flicker with a background color (yellow) that would be ideal.
Am I even using the correct control for displaying real time data, or are their other options? I essentially am looking to find the preferred method of displaying data that is being updated in real time in a web application. I'm hoping there is a solution involving AJAX but I haven't been able to find much on The Google. I am open to changing anything and everything about my approach -- this is largely a learning exercise. For testing purposes I am currently using LinqDataSource in conjunction with a GridView in an UpdatePanel being refreshed by a Timer control every 60 seconds. Informational: I have also started playing with the [URL] in place of the Timer control. However, for the purposes of this example I would be content to achieve the desired behavior using native controls as I have described them above.
im using Vs2010 to plot real time line chart. i have been looking for the section that allow me to set X and Y axis..
i jus couldn't find the place for me to set.
my Y axis is a double, min =0, max = 100 and my X axis, min =0, max = 300(seconds).
Problem: How to display more columns in a Telerik grid than are displayed in the rendered grid?
eg I'd like to only display on the screen the Surname, but on dump to csv would like firstname too.
I've tried visible = false, and display = false on the GridBoundColumns, but then they don't come out on the csv.
<telerik:RadGrid ID="grdAuctions" runat="server" AllowAutomaticDeletes="True" AllowAutomaticUpdates="True"
AllowPaging="False" AllowSorting="True" AutoGenerateColumns="False" DataSourceID="odsAuctionSales"
GridLines="None" EnableEmbeddedSkins="False" OnItemDataBound="grdAuctionSales_ItemDataBound">
<ExportSettings HideStructureColumns="true" />
[Code]....
I have upgraded web application from VS.2008 to vs 2010. I was using previously ReportViewer 2008 control in a page and replaced with 2010 ReportViewer Control.
I have installed the ReportViewer Redistributable also in my local pc as well as in the server. Also as per the new requirement I have placed the Scriptmanager in the web page where the reportviewer control located.
While running the page, the reportviewer run the report and is not showing the data on the screen. It shows the blank screen. But If I export the data to execl or world it is showing the data. Also the page numbers in the reportviewer showing the total pages available in the navigation bar. I am sure the report is running and bringing the data to the screen but not showing it.
Have a GridView with a templated select button hidden and using
e.Row.Attributes.Add("onclick",Page.ClientScript.GetPostBackEventReference(this.grdMaster, "Select$" + e.Row.RowIndex.ToString())); to select a row .
When user like to update the datasource he will select one row from gridview then in selected indexchanged event i would display the selected row values beneath the form under the grid , Then user will update the contents displayed from grid and click an update button which is outside the grid . After updating the displayed row , i got to get the values of the next row in the grid and display them for next updation , i'e if users maually selects row 3 from grid then he can update the values using the update button and then on update click itself i'll have to display next row contents of row 4 and this process could go on .
I have Parent/Child Grid (also called Nested Grids).
Parent Grid (PG) :: PG has two template fields. 1st template field has "Category ID" and 2nd template has Child Grid
Child Grid (CG) :: CG is populated in PG's RowDataBund event based on "Category ID". In CG's DataBound event, I am doing something which I need to display in CG's footer row.
Problem :: In the footer row of each CG, I have to show the "Category ID" which is in PG' row. How can I get hold of the PG's row which hascurrent nested grid (there will 'n' child grids, one for each 'Category ID' in the PG ) so I can read the "Category ID"
I was thinking if I could do something (DataBound event of CG) like this..
string catId = ChildGrid.Parent[get the index of the current row in PG].Cells[0].Text;
i am trying to add subtotal in gridfooter with has grid inside grid
View 1 Repliesi have C# Winform program and i need to convert it to Webform. can i get any simple sample for how to show database grid on screen,
add new, update and delete ?
i try to show table on screen like this:
SQL = "SELECT * FROM MEN order by Lname";
dsView = new DataSet();
adp = new SqlDataAdapter(SQL, Conn);
adp.Fill(dsView, "MEN");
adp.Dispose();
GridView1.DataSource = dsView.Tables["MEN"].DefaultView;
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.
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 grid view that does add, edit update and delete. ( I draged the grid to the aspx page ) it is working. I would like to have the following : once I lick on edit, I open a form inside the grid view to edit the fields. How can I do that.
View 4 RepliesI'm using ASP.NET/VB and am wanting to nest a grid inside of another grid. I've seen them but am unsure how to make them work. I have a Orders table with an OrderID and it is linked to a Orders_Detail table. I would like to be able to select the order and see the details. I've done it differently with 2 grids outside of each other, but this isn't the solution I need.
View 1 RepliesIs it possible to Copy & Paste Data from Excel to asp.net page and if user click save it save in database table. Excel steet
id name age
1 raj 10
2 bill 15
3 chris 14
Asp screen textbox or any other control ID Name age Paste above data to asp screen as input.
I want to create a page on which the website's sponsors are displayed. The information about the sponsors is coming from the database via an ObjectDataSource, and I'm retrieving an Image (company logo), the name of the company, and a url to the company's website. Each Image (logo) is of the same height, but of varying width. I want each Item to be formatted so that the Image is on top, and underneath is a centered hyperlink with the name of the company.
This all seems pretty straightforward ... now for my problem: I want to display as many of these on the page as possible. Essentially, start off horizontally and fit as many as possible on each row. A DataList or Repeater with RepeatDirection=Horizontal doesn't quite do what I want as I don't want to have a fixed number of columns.
Is there an easy way to achieve this, or do I have to manually add up the width of each item on an ItemDataBound event, and then somehow move to the next row when the maximum width is reached? In addition I have to deal with the fact that the width of my Item is the maximum of the Image width and the text underneath.
User clicks the Edit Link Button on my grid and I want to launch a new screen for the user to do some edits...I need to be able to pull the ID but I cannot figure out what I need to pass to the HandleSelect function and then how to read my column3 to get selectButton.Attributes.Add("onClick", "return HandleSelect(????);")
View 8 RepliesWeb form displays a blank screen at
http://cforedu.com
The front page code is located at
http://cforedu.com
The behind code reads:
[Code]....
How to make the selected record (area) for editing to be in the center of the screen?
I have a GridView with custom Edit functionality. I have panel, table and some controls for updating in the EditItemTemplate area. When the user selects to edit a record, I want the edited record area to be aligned in the center of the screen. What is happening now is, with the gridview having many records; the user has to navigate to find where the edit box displayed!
i have a grid view with some coulmns like Name,Phone no etc with Edit,Delete column in grid view. I click a row in grid view to Edit,it goes another page where i can edit all fields .Once i update i redirect the page to gridview. I want the grid view to remain in that particular page say 4 of the grid view
View 5 RepliesIt happened to add an extra Gridveiw Header in row_databound event , It did worked fine on !Postback but disappered on Page.Postback . Quick google search guided me to move the event to Row_Created event and every thing is okay .
Can any expert post some pointers , differnces between grid row_created vs row_databount with some sample table data created dynamically behaviour of both the events in !Postback and page.Postback .