Iam try to retrieve the cell " customer name" to a text box if i select any row in the grid view,
i already tried the following
[Code]....
it highlighted this GridView2.Rows[GridView2.SelectedIndex][3];
as an erorr in red , the erorr says :
Error Cannot apply indexing with [] to an expression of type 'System.Web.UI.WebControls.GridViewRow'
I would like to add a column in my datagridview that takes the value from the database and asigns it to the text of a linkbutton or make it a hyperlink. i know how to handle getting the value from the row but dont
know how to make a value a link, or set the text to a link button
i am having my text file data as follows
101011111111101111111111007060540A0941
I would like read this data and place it to the Corresponding cell in data grid.
I want to highlight thext in the gried which i am searching . It should become yellow background
View 3 RepliesI'm trying to execute a query and display the result in grid view.Its working well...
However,I wish to display some simple text like"No tuples selected" making gridview visible to false if there are no rows selected for that query executed.Is there a way to do that?
i want know, How we can select and pass a grid column value to a text box for other work
View 3 Repliesi 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 RepliesI am retrieving data from a web serivce and storing the data into a dataset.
I'm then populating a gridview with the data from the dataset.
Before each row of data is displayed on the website, I need to check and make sure the user has proper permissions to view that data.
Can this be done with a gridview(or any other .NET data control)?
Or would I need to loop through the data manually, and then write each row out manually?
i have web application it should create single HTML page . that one HTML page should send to the customers.how to create HTML page .i created one page but it retriveing single record from the databse values . my problem is i have to pull all the records from the database and papulate the HTML page. but i am getting only onerecord on that page.my code as follows
string type = ds.Tables[0].Rows[i].ItemArray[4].ToString();
string WAIVN = ds.Tables[0].Rows[i].ItemArray[0].ToString();
string status = "cdcr";
[code]....
but iam not getting all records only single record only iam retriving
I have a search option which a person can use a multi select listbox. I have it coded so it would loop through to see if its selected or not. I also have a stored procedure where the sql statement is coded for the select statement. For some reason, its not populating my gridview. Where am I doing wrong? Below is the code and stored procedure.
[Code]....
[Code]....
I have a page with a series of Gridviews to display summarised information. There a three Gridviews which need to be selected as criteria and then a Go Button is clicked to retrieve the info.
At the moment the information is retreived as the dropdowns are selected. Can this be stopped until the user clicks GO?
I am somewhat new at C# so forgive me if I have something listed wrong. This is what I got:
I am working on a school project designing a car dealership website. I have an inventory list that allows you to edit any car in the inventory. When you click on the edit button it takes you to the edit page and populates the controls with selections from the database. I have an options table that stores the VehicleID and Option ID. When the page loads it fills all the DropDownLists for the vehicle info with the data and selects the correct item according to the database selection but the CheckBoxList does not select the items that are on the Options table. I checked the query in SSMS and it returns the correct data. I have stepped through the method and it works till the "(currentCheckBox != null) if statement. It doesn't throw any errors but it also doesn't select items when the page renders.
I thought it might have been something with the page life cycle since databound controls don't render until the end but the DropDown's I have fill and selects the correct item according to the database.
I've created a data bound gridview to a SQL database. I am retrieving the data with a simple select for a specific date, and then populating my gridview. The one caveat is that I have added a second header row to my gridview, and then I am hiding parts of another row that was retrieved to only populate the main header row. I believe that this is causing my issue. However, when I step through the code it appears that my ids are proper (the first row has an id of 0, etc....). However, when I check the checkbox in row 4, the actual data from row 3 is being pulled out of the gridview.
[code]...
I'm in the process of developing a survey system. The tables / fields that are related to my question are:
[Code]....
My issues with this way were:
1) The Data Adaptors receive ALL the records from their correspondent tables. Not a good practice, I believe.
2) If, at some point, the survey had no categories, questions or choices under its child records, an error occurs when the page tries to build the Data Relation. With the work flow I had in mind for the system, this is bound to happen becuase all the Data entry pages (Add Category, Add Question, Add Choice) will be displaying the newly-created survey in a similar fashion (at which point, the survey will have no child records and so an error would occur)
If I have the ListView on a mode which only displays data (no editing or inserting), how do I reference data in a list view item using the code behind?
In other controls I have used e.Items and e.Values, but I can't seem to work out how to do it in the listview.
For example if I wanted to set the image based on a database column (I know I can do this in the HTML but just for the purpose of the example, what would I put in place of the *** below:
[Code]....
I am using the SQLDataSource.
I want to show a list of all the events between two dates i.e. list of events during a perticular time span. So for that I am making the user select two dates and then after he clicks the "SHOW EVENTS" button,I am trying to display the list of all the events present during that time span.
[code]...
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 would like to retrieve each row (data) from the database and assign it on the Label1.Text.. i've already retrieve the data but the problem is the last record was repeatedly display in the control... I need to display each record from the database in each usercontrol...
this is my code: takeQuiz.aspx.cs
[Code]....
UserControl Code (answer.ascx.cs)
[Code]....
i am trying to add subtotal in gridfooter with has grid inside grid
View 1 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 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 Repliesi need to make a web form in asp.net and i need to collect the filled data in a table created in sql. Given below is the format when the save button clicks i need to save the entered data in to the corresponding table which is created in sql.
name (text box)
gender female male mixed (radio button list)
country (test box)
state "
district "
e-mail "
phone "
photo (upload)
Save (button)
after saving the data ,when clicking another button for example view i need to show the complete record in one line including photo(size of the photo 120X120)