I want to be able to get the values of the boundfields on data controls such as Details View at runtime. I'm debuggong a project and stepping through the fields of a details view. I have a template field that's using the Text='<%# Bind("LastName") %>' syntax. What is the best way to monitor the values in this situation? Should I use "Add watch"? Is there a better way?
View 3 Replies
I have several configuration entries for application.
Identical entries are stored in Machine.config/Web.config etc..
How would I determine which one is read at run time..
I have a user control which I call like this:
<MyNamespace:MyControl runAt="server" ID="foo" /> Is there any way I can determine the ID parameter at run-time and pass it in?
I have a GridView, and I want Column1 to be equal to datatable data (filled by a SqlDataAdapter). Then I have two other fields by the SqlDataAdapter (first name, last name), and I want to have those two fields combined to form Column2. I have a TemplateField for my GridView that combines the first name and last name with Eval()'s, but the GridView places this combined field TemplateField and puts it as the first column.
How can I do this so that TemplateField can go in between fields that are databound?
I am using TempleteFields for all columns in my GridView. In that columns I am using only some fields for customization but not all.
Is there any performance issue with Databound Fields vs Templete Fields in a GridView...?
Do I need to replace the remaining columns with Databound Columns instead of TempletField columns...?
Is it possible to determine at runtime when my site is running in the debugger? I want to use one setting for production and another when I'm running in the debugger.
View 3 RepliesI am creating a WebApp and got stuck on the "Save" process. I am gathering data from a SQL DB and using a DataReader to populate the DataList. The DataList hold employee data and there are quite a few. What is the best way to save the data to the database?
I had originally thought that once a Supervisor has verified the employee data, just click the "Update" button and save to the DB but how would I determine which fields in the DataList have been changed? I only want the changes saved.
use a Dataset to populate the DataList then build a second Dataset with the same structure and compare the two. Then save the changes to the DB. I had read before on the 4GuysFromRolla website that using Datasets in a web app wasn't the greatest ...
How to determine whether the table is not empty?
Using reader
I have a gridview with a template filed which contains an embedded gridview, which may or may not contain any records. I want to be able to make the master gridview row a different color for those rows whose child gridview has records. My plan is to add a sqldatasource to the page that targets the child gridview table and during the master gridview RowDataBound event I would check to see if there are any records and apply the formatting accordingly.
View 3 RepliesI am using the ItemDataBound event of a ListView to attach data for the different kind of templates I am using. Well, actually, want to use - I have not yet figured out how to know which template is coming in in the ItemDataBound event. I want to figure out if it is the edititemtemplate, insertitemplate, itemtemplate, etc. All these templates have different controls (edit and insert are the same though) and I need to set the controls contained in them.
View 3 RepliesI have wired an event to handle delete command for my GridView. But I cannot determine which the record's unique key, in my case stored in DOCIDNO field. All I get is a row index, such as 0, 1, 2 which obviously cannot be used to accurately delete a record from database.
<asp:GridView
ID="gridTimeOff"
runat="server"
HeaderStyle-CssClass="gridHead"
RowStyle-CssClass="gridRow"
[Code].....
Anyone know how to determine which ImageButton was clicked in a gridview when there are multiple Imagebuttons in a row. I am guessing it's gotta be done in SelectedIndexChanged.
View 4 Replieshow can we determine the exactly datagrids row and column that exists a button that has been pushed?
Protected
Sub ela(ByVal
sender As
Object,
ByVal e
As
System.Web.UI.WebControls.DataGridCommandEventArgs)
' Dim id As Integer = datagrid1.DataKeys(CInt(e.Item.ItemIndex))
Dim id
As
Integer = e.Item.Cells.GetCellIndex
Response.Write(ID)
End
Sub
but how exactly we determine the row and the column?
I am trying to determine if the user selected a checkbox for each row in a ListView after hitting a submit button. If so, I need to get the record ID and one other piece of information from that row to insert their selection into a table. I would use a GridView but the questions must be grouped by their categories with the category names displayed followed by their corresponding questions (from what I've read ListView makes this easier).
I tried the code in this forum posting
[URL]
The problem I am encountering so far is that it keeps returning null even if the Checkbox is checked.
Here is my code:
foreach (ListViewDataItem lvi in lvQuestions.Items)
{
// Find the checkbox in each row
CheckBox cb = (CheckBox)lvQuestions.FindControl("cbQuestion");
// If the checkbox is ticked
[Code]....
In my application I've allowed users to upload Excel 2003 .xls files, and import them into a Gridview. This has been working fine using the following connection string:
[Code]....
Now my users are using Excel 2003, 2007 or 2010, I need to allow the newer file extensions (.XLSX) to be accessible too.
Therefore, within the connection string above I presume I could change the Excel version from 8.0 to 9.0 or 10.0 respectively, but is there much difference between Excel 2007 and Excel 2010 files?
If so, is it possible to 'detect' the Excel file version so that I can use the appropriate connection string to read the data from the files?
I have an application that I would like to be able to allow the user to modify multiple characteristics of each record within a datagrid.
Most characteristics require data to be entered in a text box but some a check box would be more appropriate.
My question is does a gridview column need to have all the same item template controls? or could I read from the database the control type and dynamically alter the template control for each row as it loads?
I have a listview control bound to an SqlDataSource. As part of the formatting I want to add a title to the data returned from my database. For instance if the data base returns a phone number I want to add 'Tel.' first. However I do not want to diplay this
title if the datafield is empty. Here is what I have done so far.
<ItemTemplate>
<asp:Label ID="BusinessLabel" runat="server" Text='<%# "Tel. "+Eval("Business") %>' CssClass="TeleStyle" />
Or This:Tel.
<asp:Label ID="BusinessLabel" runat="server" Text='<%# Eval("Business") %>' CssClass="TeleStyle" />
</ItemTemplate>
Business is a phone number. If the data field contains a number I get: Tel. 1234 123456. If the field is empty I get Tel. If Business is null I want nothing dsplayed, how do I do this?
I have a sql database in which table may varies runtime some time there 3 tables, some time more then 3, means there is no fix no of tables. These database updated from different program.
Now I want to populate each table in gridview using asp.net (C#) page. Some time in pae it will display 3 grid, some time it will be 4 or more or less.
How can I add gridview runtime for each tables in asp.net page?
I want to add one extra Template Field at runtime based on the User-Profile.
View 3 RepliesI have to develop web page, page have gridview with some controls, intially only one row is there with controls like textbox and dropdownlis on specific colum, while user enter text to textbox and select value from dropdown now user want to add new row to gridview than how can i append new row to gridview with textbox and dropdown control same as first row.and data of the first row should be keep as it is as user input or user select any value from dropdown.
First Column Second Column
Row1 TextBox Dropdown Here user can able to enter value for textbox and select item from dropdown
Row2 TextBox Dropdown Dynamic new row and first row shold be keep as user selected.
i have a dataset filled from the DB, let assume the data in the dataset is: -
[code]....
I have a datatable with the following column names
ProviceID, ProvinceName, Year,
TPM, PM 10, PM 2.5, B(a)p
I'm trying to display data from this table in a gridview using template fields. Here's an example of a label in my item template
[Code]....
When i bind data to this grid view, i get an error saying column "PM 2" was not found. For some reason, the program is dropping the .5 from the column name. I am exploring the possibility of replacing the number with alphabets only but this may not be possible as the end user may not find it user friendly. Is there a way for me to get around this problem? I get a similar problem with B(a)p, it drops everything after the B. Any ideas on how to get the gridview to bind column names with special chars in it?
just starting strongly typed data sets, I have managed to fill my data set and bind the gridview, but now I dont understand where to map the fields ? Inside the business logic layer or presentation layer.
working example to map fields with a select query and with an update .
my code for BLL file
[Code]....
I understand in a gridview that is databound by default HtmlEncode is set to trueHow do I protect template fields in any data presentation control?
View 1 RepliesI am having an issue with a simple databind to a datagrid. What happens is that for some reason, the first character of the data going into the 4th column is getting placed at the end of the data in the third column; but only on the first row. Here is an example of what I mean:
Form ID
Employee No
Associate Name
Start Date
End Date
Form Status
1234
5000187
Stan Marsh1
1/16/2010
11/30/2010
Approved
1234
5000187
Eric Cartman
11/16/2010
11/30/2010
Approved
1234
5000187
Kyle Broflovski
11/16/2010
11/30/2010
Approved
As you can see, in the first row of data, a "1" has been moved from the Start Date column to the Associate Name column. Because this is a databind I don't see how this is even possible. I'm just curious if this is a known issue or just some random fluke. Here is the relevant code:
[Code]....
