I have multiple questions about doing gridview in code behind.I used this code to fill my gridview at runtime.
[Code]....
My questions are:1. How to edit the column headers? When I bind the database to my gridview, obviously, the column headers of the database will be binded. For example "First_Name", I want to edit the column so I can omit the underscore.2. How to edit the column width?
Is there a way to turn this
[Code]....
[Code]....
First, what I am showing here works fine, and I know how to do this if the nested control comes from the same bound table. I could leave it at that, but I don't like SQL code in my aspx page, and want to move it. I'm keeping it simple here, but I can move it to a data access layer later on..... for now, I want to understand what's going on when the page loads and the nested control is rendered and populated. WHAT I LEARN FROM THIS WILL BENEFIT ME ACROSS THE BOARD - NOT just for this instance!!!
My question is, how to grab the SQL query from the aspx page for the NESTED control and move it to the codebehind. I'd LOVE to also move the Selected Value parameter if possible, but mainly want to get the SQL out of the page. I KNOW HOW TO DO THIS for a GridView or any control, but I DO NOT know how to do it for a NESTED CONTROL from a different table - i.e. WHERE it fires (on GridViewEditing or GridViewUpdating or PageLoad....) so I can put in the SQL where it belongs.... and I'm PRETTY darn SURE this can be done without a 'foreach' loop. For discussion's sake here, imagine
1. DATABASE: simple table with employee_ID, employee_name, employee_city as fields
2. DATABASE: simple table containing all cities (city, cityval)
2. simple GridView that displays these 3 fields in same order ON VIEW
3. Template field for city. On PAGE LOAD, this is a simple label bound to the 'city' field. HOWEVER - On EDIT (with edit button), the field changes to a nested DropDownList that is bound to the 'city' table, NOT to the employee table.
4. Selected value is the current city for employee The PROC you see here in the edit item SQL is actually SELECT * FROM [cities] ORDER BY [city_name]
<asp:GridView ID="grdEmployee" runat="server" AutoGenerateColumns="False"
CssClass="grdE" DataKeyNames="employee_ID"
ShowFooter="True">
<Columns>
<asp:BoundField DataField="employee_ID" HeaderText="ID" ReadOnly="True" />
<asp:TemplateField HeaderText="Employee Name">
<ItemTemplate>
<asp:Label ID="lblEmployeeName" runat="server" Text='<%#Eval("employee_name")%>'></asp:Label>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="txtEmployeeName" runat="server" Text='<%#Eval("employee_name")%>'></asp:TextBox>
</EditItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="City">
<EditItemTemplate>
<asp:DropDownList ID="cboCity" runat="server"
DataSourceID="SqlDataSource1" DataTextField="city" DataValueField="cityval"
SelectedValue='<%# Bind("employee_city") %>'>
</asp:DropDownList>
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="Data Source=XXXXXXXXXXXX;Initial Catalog=xxxxxxx;Integrated Security=True"
ProviderName="System.Data.SqlClient"
SelectCommand="QUERY_CITY" SelectCommandType="StoredProcedure"></asp:SqlDataSource>
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="lblEmployeeCity" runat="server" Text='<%# Bind("employee_city") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
ALL I want to do is move the SQL Query in the EDIT template above to the code behind. I just don't know WHERE or WHEN in the code this fires and how to handle it when the table is different from the original GridView table. AND the cboCity.SelectedValue, if possible.
I've been trying to accomplish this for days without joy. I need to update a specific cell in a gridview with some static text when a button click that is outside the gridview. The cell i need to update is a template field.
View 10 RepliesI have a method I want to use on two gridviews which contain different information, ideally i want to do an if statement, something like
if (GridView.ID = "GridView_ABC") {
// do this
}
else if (GridView.ID = "GridView_2") {
// do this
}
is it possible to have a button that points to a method you have defined in codebehind, that passes in a record from the row as a parameter? for example, id.something like:
<asp:CommandField ButtonType="Image" EditImageUrl="/editbutton.jpg" ShowEditButton="True" OnClick="editRow(int id)"/>
it wouldnt necessarily 'edit' this row. i'd like it to instead load an editable grid corresponding to the id passed.
a Gridview contain itemtemplate(using code behind) and
Textbox with random id
how to access the the textbox id in code behind
[Code]....
This is my gridview with an item template, I have NO boundColumns.TO get data to codebehind I use Eval(" <Field name >"), but this returns something to a control. Not making data available for codebehind code for general use.
Question: As I have no boundcolumns I dont know how to get data to codebehind to to use as I wish??
how can i set DateFormatString inside GridView column in codebehind page?
View 6 Repliesi saw this post on[URL] so the problem is .... if there is a datasource in some editeitem template in grid view .... it won't be accessible from out of the edit-item field.....
here's my code...
[Code]....
that i have here is ID-column which contains a linqdatasource taking a where parameter from a dropdownlist and they are both in the same edit-template field.
and i have in another column (CourseTypeID-column ... edit-item template) a dropdownlist ..... now this dropdownlist i want to bind it to the linqdatasource exists in the ID-column (edit-item template)..... is that possible in the designer (or from) not code behind ..... and how ????
I'm making the switch from vb.net to c#, and am just trying to bind some data from a reader in my c # codebehind, but no matter what, the gridview always skips the first row returned from my stored procedure. What am I doing wrong?
[Code]....
I know I can use a code like this:
[Code]....
To create a DIV in my body but how do I then add innerHTML to this control? Or can I directly add an Label to the newly created control and set tag ones text?
search for a item, display the results in a datagrid, have a LinkButton (per item in the datagrid) to show a popup modal and insert this data to a new table. I have the search, the datagrid, and popup modal all working. I need help with the add button in the popup modal (which insert into a new table in the db). In my datagrid im using DataFields - how would I get access to this in the codebehind so I dont have to re-query the db again for the ID that i'm trying to insert?
View 5 RepliesI have gridview and sqlDataSource. In edit mode, if the user checks closed checkbox closeDate parameter is set to today and appears in a label near to checkbox. So, I need to control isClosed checkbox and then if it is true closeDate=GETDATE()
[Code]....
Only CloseDate parameter need to be set in codebehind, other parameters handled in gridview.
So im building a table from codebehind that plops data into each cell like so -
[Code]....
This just doesnt work, i was wondering if there was something else i could try to get this working....
Given the following code for a textbox in the EditItemTemplate of ListView:
TextBox txt = (TextBox)ListView.EditItem.FindControl("ImageURLTextBox");
How would we code for a textbox in the ItemTemplate of the same ListView?
I have a DDL bound to a sqldatasource where the dataTextName is the storeName (varchar) and the dataValueField is the storeID (PK Int). I'm holding the value of the storeID in a user's profile (using ASP.NET membership profile). So, when a user is created, they're assigned to a store (or not...it's optional). When I edit the user, I populate the DDL with all the stores in the table, but I need to set the selected item to the storeID in the profile (if it exists)...I'm not sure at what point to do it though. In my codebehind, I bind the ddl to the datasource and insert an additional item: if not page.ispostback then
REM: bind the company ddl
I am getting error when i write the belwo code in the code behind.
Error: The name DataIem Does not exist in the context
protected void getHotDeals()
{
D4T.tbDealDataTable dealTable;
dealTable = dealTA.HotDeals();
StringBuilder sb = new StringBuilder();
[Code]....
i hav created different rolegroups such as candidate,content developer etc... i hav put datalist views in different rolegroups i want to access those datalist view's controls in codebehind how do i do it? my code behind is in vb.....the code .aspx :
[Code]....
code behind is wat i want for OnClick="TestCheck" so tat whn i click on tat link i cn verify whether candidate has given the test or not...rght nw i cnt access datalist1 in code behind..
I hve this gridview
v style="overflow: auto; height: 250px">
<asp:UpdatePanel UpdateMode="Conditional" ID="up1" runat="server">
<ContentTemplate>
<asp:GridView ID="gv" runat="server" DataKeyNames="row_id" AllowSorting="True" AutoGenerateColumns="false">
<Columns>
<asp:TemplateField>
<ItemTemplate>
<asp:CheckBox ID="chkDelivery" runat="server" />
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Sequence No">
<ItemTemplate>
<%# Container.DataItemIndex + 1 %>
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
</ContentTemplate>
</asp:UpdatePanel>
i want to add this two columns dynamically to gridvew in codebehind.
I am trying to access accessing a control in a Formview. I have tried several methods, but nothing seems to work
[Code]....
[Code]....
In the gridview we are using edit button. Once the edit button click Controls in the edit template will display in the same row with update button. That row has two dropdownlist control.
Process flow:
controls:d1 and d2
d1 is using sqldatasource for item display : working fine.
d2 is using codebehind code to load the item based on the selected value in the d1 : Not working
How to findthe control in the edit template to display item value for d2.
I'm trying to pass in an ID of an activity (RefNum) to my codebehind via OnDataBound called in the CheckBoxList, but can't seem to find the correct syntax.
I know I'm supposed to use parentheses when passing parameters to subroutines and methods, and I've tried a number of ways and keep receiving the following error:
BC30203: Identifier expected.
So I tried to hard-code it in the code below [ OnDataBound="FillSectorCBList("""WK.002""")" ], but it's obviously wrong. :(
Front-end:
[Code]....
Code-Behind:
[Code]....
I have a detailsview with three textboxes as itemtemplates. Each for holding a different date. To avoid the option of users entering invalid values the textboxes are disabled and the user can use a calender control to fill the dates. Because the textboxes are disabled I added a linkbutton to empty a date, if the user decides to clear it.
Asp:
[Code]....
In the code behind is the following for linkbutton on click:
[Code]....
Now, the problem is that no matter which linkbutton a user clicks all three textboxes are cleared/emptied. Why?
I have working code similar to the following in my Detailsview:
<asp:SqlDataSource ID="SqlDataSource3" runat="server" ConnectionString="<%$ ConnectionStrings:DATABASE %>"
SelectCommand="SELECT Id, PracticeId, FirstName, LastName, Notes FROM Providers WHERE Id=@Id"
UpdateCommand="UPDATE Providers SET
PracticeId = @PracticeId,
FirstName = @FirstName,
LastName = @LastName,
Notes = @Notes
WHERE Id = @Id"
InsertCommand="INSERT INTO Providers (
PracticeId, FirstName, LastName, Notes
) VALUES (
@PracticeId, @FirstName, @LastName, @Notes)">
<SelectParameters>
<asp:QueryStringParameter Name="Id" QueryStringField="Id" Type="String" />
</SelectParameters>
<UpdateParameters>
<asp:Parameter Name="Id" Type="Int32" />
<asp:Parameter Name="PracticeId" Type="Int32" />
<asp:Parameter Name="FirstName" Type="String" />
<asp:Parameter Name="LastName" Type="String" />
<asp:Parameter Name="Notes" Type="String" />
</UpdateParameters>
<DeleteParameters>
<asp:Parameter Name="Id" Type="Int32" />
</DeleteParameters>
</asp:SqlDataSource>
I would like to move all of this to codebehind so it's easier to work with programmatically. For instance the PracticeId is a selection from a dropdownlist that is populated from another table... i need to determine what the current selection is first so i can display the record / bind properly.