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]....
I have image in the image folder and in my oracle database I have a column with the name IMG which has the name of the image like ab.jpg
I have another column with name IMG1 which is storing the whole url like images/ab.jpg
I can see all the values of my database table in my dataset as well including IMG column and IMG1 column
In my aspx file I wrote code
<asp:imagefield dataimageurlfield="IMG"
dataimageurlformatstring = "~/images/ab.jpg"/>
but it is not displaying anything, however aspx page is working fine, it is showing a field but no image and it is blank, same is the case with IMG1 column as well
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 have a dataset into which I load an xml file using DS.ReadXml("~/Example.xml"). I have a column labeled show which is a checkbox. Below the gridview I have a button which says show all. When this is pressed, I want it to check every checkbox in the gridview and save the dataset back to the xml file.
My xml file has the following format:
[Code]....
My code is as follows:
[Code]....
Why doesn't this code work? I get the following error whilst executing it:
Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index
The number of 2'values in Column of gridview?
View 5 RepliesPlease let me know if there are any sample code to introduce filtering column values in gridview, similar to telerik and devexpress controls. I have sample code for dropdown box filtration. But I am looking for one based on textbox entered values
View 1 RepliesI have a gridview that has certain values in it that I would like to change based on a condition. For example, if a value in the column is 'x', I would like to make that Value Bold and have text that says 'Not applicable'
How can I do this? How can I programtically chnage values in a gridview?
I need to create a scheduler for a hospital appointment screen.. i am taking a time interval value and doctor schedules from MyDb. I want to fill the gridview based on the doctor's schedule timings and interval....
for Ex;
if Doctor A .
Time schedule is 09:00 Am - 09:40 AM && 10:00 Am - 11:00 AM
time interval is 20 minutes
i need to show the grid like this ....
09:00 AM
09:20 AM
10:00 AM
10:20 Am
10:40 AM
11:00 AM
I want to retrieve and store(in an array) all the row values of a particular column in a gridview..i.e,if I have gridview with columns col1,col2 and col3, I want to retrieve rows of col1 by specifying col1..And,store all the rows in an array
View 4 RepliesI have to select checkboxes besed on group column values. If you see below gridview, column 3 (GroupN) has 1,1,1,1,2,2,2,2....etc (this column data is not static, will change based on page index. i.e PageIndex =2 may starts with 7,7,7,8,8,8,8,8,9,9,9 etc).
Now My question is.
1). If user selected '1', we have to store value and user must and should select another '1' (atleast two times).
2) If user selected '1', and user trying select '2'. Giving error says "Must have select one then one record in group to combine' (will not allow) and unselect '2'.
3) If user selected '1' atleast two times, and user trying select '2'. Will allow.
4) If user selected '1' atleast two times and selected '2' one time, trying to select '3'. will not allow user to select '3'.
I want to display gridview column heading when mouse over to the particular column in the gridview.I am working in VisualStudio 2005 with MS.Net2.0 framework.I don't want to use ajax.
View 4 RepliesHow to retrieve data from itemtemplate of gridview
View 1 RepliesHow To Multiply TwO Values In GridView In asp.net using c#
View 1 Replies[Code]....
Main Gridview[Code]....
ViewState["Index"] = reader[0].ToString();
Using sqlDataAdapter, I wanna save one column to view state like this.
as all can see, i'm already able to create another gv that contains data selected by a checkbox from the first gv..
now is i want to show the image (from column tittled cover), also i want to sum the total of column 2 (ukuran) at the footer of second gv..
I have a GridView that gets populated with data from a SQL database
Now i want to replace values in my one column like so......
If category value is a 0 then display Admin in the GridView.
If category value is 1 then display user in the GridView
category is col name in gridview and sql table
how to implement Insert feature to a grid view?I need to use fields with scroll bar inside of a grid view. Is that possible through the template field?
View 23 RepliesI'm facing a wierd problem with GridView and ObjectDataSource. I bind GridView to my business objects via ObjectDataSource. Everything was working fine until I decided to add a new field in my buisness object and wanted to add a column to GridView to show it. Somehow that column is NOT shown in the GridView's list of available columns. I have tried refreshing schema, rebinding, etc. I'm using GridView inside a user control which is used as a web part. Does that make a difference ?
View 3 RepliesI'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.
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.
How to pass gridview particular column values to another page's table header...
View 1 Replieswant to display gridview column heading when mouse over to the particular column in the gridview.
View 9 RepliesHow to add a button at first column of gridview and get cell value in another column?
For example, add a button named it as "Click me". Once user clicks will get third column cell's (ID) value.