I need to get values of all individual cells from the row of a grid view and assign eac one fo them to seperate variables. Should i just access the control values directly from the gridview (the controls are template fields) or is it best to run an sqlq select query for each value i want to retrieve.
so I am new to ASP and I am confused here about how to obtain specific data from a specific cell.so, i have a gridview that i fill from a SQL source, this works fine. what i have been task to do is add an editable text box and a comments portion to the site. these controls are to be inside the gridview. my dilema is getting the primary key of the row i am inside of.
Example when i click in the text box i created and i change the text the "ontextchanged" event fires; however, i am having difficultly at that point getting the primary key from column [0] of that specific row. i need this so that i can update the database.here is some of my code
ASP (Markup)
[Code]....
Code Behind (it is blank becuase i have run out of ideas and need your help filling it)
[Code]....
I have a gridview with a column of text boxes bound to a value from a database. I should be able to edit the values in each of the text boxes and just print those new values(dont have to update into the database). But my method returns only the old values, not the new values entered into the text boxes.
View 5 Repliesi take data from Sqlserver database , and my prblem is that i want to get old and new values from gridview and base on that i want to change there background colors .. i try gridview rowupdating , editing ,updated Events but when i debug no break point hit and there was no value in ViewSate that i declare ,
View 2 Replies I am trying to set up a GridViewUpdate, I need to find the Parameter and I am having trouble figuring it out.
How would I go about obtaining the value for "@ID" parameter in order for the user to update the required "TAUpdateDate" field?
[Code]....
i am using a gridview in my web page,i used to bind the database records to the gridview..my columns are name,empid,company name,pl leave,sl leave,total leave taken here total leave taken is not a database fields,in the page i want to fill the records once loaded pl leave and sl leave is added and display in the total leave taken column..it working properly when all pl ans sl columns fill with numbers,if some pl and sl leave having blank values.it showing an error like input sting was not in correct format..this is my code
<Columns>
<asp:BoundField DataField="slno" HeaderText="SerialNo"
SortExpression="slno" />
<asp:BoundField DataField="ecode" HeaderText="Employee Code"
SortExpression="empcode" />
<asp:BoundField DataField="ename" HeaderText="Employee Name"
[code]....
I'm lost. I have a sub gridview in a gridview. In subGridbiview I have a button. How do I can clicking the button and get values outside the gridview? The subgridview not present the events ...
------------------------Gridview 1------------------------------------------
| cell(0) | cell(1) | Cell(2)| Cell(3 - ITEM TEMPLATE) | -
| | | | # # # SubGridview1 ######### -
! x1 | Y1 | Z1 | # Cell(0) ! Button #-
! | | | ######################-
------------------------------------------------------------------------------
| | | | # # # SubGridview1 ######### -
! x2 | Y2 | Z2 | # Cell(0) ! Button #-
! | | | ######################-
------------------------------------------------------------------------------
how do I click on the child gridview and get the values of the parent gridview? no events in the child gridview no number indexrow on the parent gridview I'm lost.
I have one filed that is encrypted using Rajindal algorithm and stored in MSSQL db.When I retrieve that column in gridview it's displayed in encrypted. I have the code that decrypts it but the problem is:How can I all loop throw this column values in the gridview and decrypt them all and display it in the gridview decrypted.See my code below:
[Code]....
how to get the values text box values to gridview..
if i enter any text in text box those values should display in gridview.
after entering of 2 or 3 records, i will click on save then all the values of grid should insert in to DAta Base.
i dont want to get the values form Database to Gridview.
how to retrive the values form Database to Gridview.
i just want to display the values which are there in Textbox...
I would like to ask a question on the visual basic codes to loop the gridview to retrieve the values and based on the values, it will be provided as parameters to update to the database table using stored procedure.
Firstly, I have a gridview named grvProduct. The page (ui) will be loaded with data from the database with the use of stored procedures. And only certain values can be edited through the use of template in gridview. So based on those edited values, I'm supposed to pass these values as parameters to the stored procedure which will then update a database table.
Let say, I have 3 records retrieved from the database and displayed in the gridview. And I would like to edit a values in the 3 records, how do I do batch update and pass those parameters to the stored procedure? I went to debug and step through the visual basic codes and realised there were too many arguments specified because I actually loop the gridview.
Below is my visual basic codes:
[Code]....
Below is my Stored Procedure code:
[Code]....
I believe it is the error in the looping of the gridview which results that I could not batch update the data/values.
I have a problem that can't find a way to do it, I have a gridview with this columns:
ID | AreaName | CostCenter
with the "Enable Editing" option check and what I want to do is to get the values of areaname and costcenter and assign them to a label control so I can use the values for something else, for example:
ID AreaName CostCenter
1 Multiconector 1025
2 One Conector 2065
3 Plug & Play 1445
4 Splitter 1598
5 FNI 4298
and if I hit the edit button of the row with ID 4, assign the values to the labels lblAreaName = Splitter and lblCostCenter = 1598
Before I edit them, and so on with the rows I want to edit.
I want to get the values from a cell in a gridview so can I do that without selecting a row. Its something like this I have a drop downmenu and based on the value selected in the dropdown menu I have to change the presentation of gridview without going to the database.
View 3 RepliesHere is the code with the issue:
[Code]....
The value of txtName, for example, contains the value prior to editing and clicking update. Here is the grid code:
[Code]....
Snap shot of asp code
<Columns>
<asp:BoundField DataField="DeptarmentID" HeaderText="DeptarmentID" ReadOnly="true" />
<asp:BoundField DataField="DepartmentCode" HeaderText="DepartmentCode" />
<asp:BoundField DataField="DepartmentName" HeaderText="DepartmentName" />
<asp:BoundField DataField="Active" HeaderText="Active" />
</Columns>
snap shot of page behind
protected void GridViewDept_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
GridViewRow row = GridViewDept.Rows[GridViewDept.EditIndex];
string code = ((TextBox)(row.Cells[2].Controls[0])).Text;
string name = ((TextBox)(row.Cells[3].Controls[0])).Text;
bool active =((TextBox)(row.Cells[4].Controls[0])).Text=="True"?true:false;
//bool active = ((CheckBox)(row.Cells[4].Controls[0])).Checked;
int id = System.Convert.ToInt32(row.Cells[1].Controls[0]);
}
I get error on the last line stating out of index error, how do get the value which is not set editable in the gridview
I'm writing a gridview in VB.NET that is bound programatically in the Page_Load function. I am binding the data in the 'If Not Page.IsPostBack Then..." structure. And as you can see, I'm using TemplateFields instead of BoundFields. And I need to access the e.OldValues in my RowUpdating function, but they come up empty.
Here's my code:
[Code]....
I have a gridview with a dropdownlist (ddlGrade) in one column and a textbox (txtText) and checkbox(cbxCheck) in another. When the checkbox is checked I to fire an event that will use the data from other controls in that row. In the method can get the checkbox value using:
public void onCheckedChanged_CheckedInfo(object sender, EventArgs e)
{
Checkbox cbxChecked = (Checkbox)sender;
}
how do I get the value of the other two controls that are in the same row (dropdownlist and the textbox) at the same time? But not the values from any other rows?
Im displaying a Gridview full of data but the column "Country" is displaying the CountryID and I want it to display the Country 'Name'", same with State/Prov and a Status column I have. I've looked around at BoundField Properties and such and can't seem to find where I can configure this. Is it straight within my DataSource? Here's my code:
GridView Code
[Code]....
Here is my DataSource Code
[Code]....
Is it within the SELECT statement of the DataSource where I can need to configure using "Country" not "CountryID"or "Status" not "StatusID"?
I am trying to update a table using gridview. I have dynamically assigned an sqldatasource having update command to it. I am taking values from textbox in edititem template. but problem is textbox doesnt show the new value that i write in it to update the row.
It gives me the old values from the table.
here is some of my code
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
Label lbPatientOID = (Label)GridView1.Rows[e.RowIndex].FindControl("lbPatientOID");
TextBox tbFirstName = (TextBox)GridView1.Rows[e.RowIndex].FindControl("tbFirstName");
TextBox tbLastName = (TextBox)GridView1.Rows[e.RowIndex].FindControl("tbLastName");
sds.UpdateCommand = "UPDATE Patient " +
"SET FirstName=@FirstName, LastName=@LastName " +
"where PatientOID=@PatientOID";
Parameter fname = new Parameter("FirstName");
Parameter lname = new Parameter("LastName");
Parameter pid = new Parameter("PatientOID");
sds.UpdateParameters.Add(fname);
sds.UpdateParameters.Add(lname);
sds.UpdateParameters.Add(pid);
GridView1.DataSource = sds;
GridView1.DataBind();
lbtest.Text = e.Keys.Count.ToString();
}
sds = sqldatasource.
I have a number of checkboxes embedded in a gridview. I would like to give users a dropdownlist based on when certain checkboxes have been selected.
I have tried to accomplish this by adding an onlick event to the checkboxes when they are loaded.
[Code]....
In my javascript i try to get the value that was selected. That worsk okay but when i item is de-selected i am confused about how to determine if there are no more selected rows that satisfy the condition i mentioned above.
Below is the javascript i came up with
[Code]....
Is there a way to get the values on a selected checkbox to determine if it satisfies a certain condition for displaying a dropdownlist?
Also, how can i loop through the checkbox items to make sure the conditions are met in order to display the dropdownlist
I currentlly am trying to get a bit value from a specific cell, i can get a text value from text cell but i cant seem to fiqure out how to access the bit value. This is on a dgvRowCommand event so im using datakeys to access the row and a column index for the coloumn like so.
lblFolderRead.Text = dgvCollabFolder.Rows[currentIndex].Cells[1].Text;
This works if im trying to get a text value but obviously a bit value isnt text and thus does not return anything, How would i access a bit value in the manner above, or if it is not possible that way what other alterntives are there?
I have a problem. I'm using a gridview to show some values of a xml.
this is my gridview
[Code]....
The last templatefield i want it to work as a deletebutton... Onclick it will erase the row of the xml.
My problem starts because i dont know how to get the number of the row that contains the button that was clicked or the id that is passed by datakeyvalues on the click of that same button.
if imagebutton had the value property i could send the id by eval by i know it doesn't have that property.
ex: value="<%#Eval("ID")%>"
So what do you thinks it's the best option, maybe do a redirect and there make the onclientclientclick attribute and the code to delete the xml row or can i do that on the codebehind of the page where my gridview is...
i used the following line of code in the row editing event to extract values from the gridview.
x = GridView1.Rows(e.NewEditIndex).Cells(1).Text
However i am getting the old values from the cell!
I need to extract the new values which i enter during updating.
In my gridview, I want to count the number of times each value (based of course on a field in my gridview) occurs. For example, if I have a field called Dept, in my result there is the following:
Dept A
Dept A
Dept A
Dept B
Dept B
Dept C
What I am trying to do is to show that for each Dept A, the count is 3, and for Dept B, the count is 2 and for Dept C the count is 1. When I have my count, I want to save them into my hidden field, which I am going to use else where in my code.
I know I need to do this in my rowdatabound event, and I have had ago, but the results I am getting back are not correct.
I have a list of cases that are displayed on our intranet home page. They are all in a gridview. I have a view button which will go and display more information about the case on a different page. Now for some reason the jobID is the same as the ClientID so instead of being say clientID=34&jobid=148 its just clientID=34&jobID=34. I have posted the code which i am using. I believe this started when i deleted a load of unwatned test cases from the DB itsself
ID="SqlDataSource2" runat="server"
ConnectionString="<%$ ConnectionStrings:sqlCS %>"
SelectCommand="SELECT [Date], [Time], [EndUser], [Problem], [Status], [ClientID], [id] FROM [supportcalls] WHERE ([Status] <> @Status) ORDER BY [Date] DESC, [Time] DESC">
<SelectParameters>
[Code]....
I have a Grid view with a button under all the rows(in a footerTemplate). I need to create event that iterate all the values of the second columns in the gridView.
How can I do that?