I have a GridView with a SQLDatasource. All of the columns in the gridview are bound to a field. Now they want a column that is not a field returned but would be two of the fields combined together. How can I do this exactly? Can someone show a line of code to display this in a column?
View 8 RepliesI am trying to create a multi column listbox by combining fields in Linq select statement, as Let Name = Last + First. The problem is how to pad the Last column with spaces as you would in SQL using REPLICATE so when I bind the listbox to the data, it looks like two columns.
View 5 RepliesI have a dataset which I am binding to a listbox. However, I want to combine two of the fields to make up the DataTextField. Is this possible, or am I going to have to loop through the Data Rows?
lstAddressDropdown.DataSource = dsAddress;
lstAddressDropdown.DataTextField = "StreetAddress" + "Place";
lstAddressDropdown.DataBind();
lstAddressDropdown.Items.Insert(0, new ListItem("Please select"));
It's worth noting that the dataset comes back from a web service so I can't change any stored procedure to combine the columns there.
[Code]....
which is giving me
And i tried
select * from @jax
group by rep
and it did not group them. How would i bring the sum ly up with the sum? so it shows 1-10 cust,sum,sumly
My users will enter a city/station where an incident occured, and the date. The trigger below does work, but it will occasionally put spaces between the citystation and the date. I think this happens when the citystaion name is not very long, but not sure.
(ex: city____08242010)
How can I make sure that if the incidentid is going to have spaces, that sql deletes those spaces? I need the id to be space free.
ALTER
AS
TRIGGER [dbo].[tr_AddID1]
ON [dbo].[tblIncidents]
INSTEAD
OF
INSERT..........
I have two tables (Person and Location) In the Dynamic Data Site, when adding Location info, I am need to choose a person from the dropdown box which is populated via a FK. That dropdown box defaults to the field in "Person" that is titled "fname" which is first name, so it looks like "Jim" or "Steve".
I'm trying to have that dropdown box display the full name of the person it references which would be combining the fields fname and lname.
Would I do this inside a Field Template? Metadata? I'm kind of stuck on this.
If I look at the FieldTemplate for ForeignKey_Edit I see this:
[code]...
and it seems like I should be able to make something similar to "PopulateListControl" and use that instead, but I have no idea where this method even resides.
Is it possible in SqlDatasource Update command to combine two parameters to make a third?
[Code]....
this is what I need to do Combine First and Last names with a space between.
I have a web page with an object data source that is connect to an object access layer which retrirevs an Id, Name_En and Name_Local from some table, the object data source is connected to a GirdView, In the girdview i have a template control with a label inside it, i want to change the binding expression for the label depending on the current states of localization so for example if the page is arabic the label should bind to "Name_Local", if it's english then it should bind to "Name_En"
View 1 RepliesI 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
I have used datagridview to display certain data to users...
It works f9 but what I am concerned with is that there are a few columns having large text...n the text moves to the next line...i want that after a fixed length of letters it should display "......"
So the my datagridview would be of fixed size....
I have a gridview with textbox and that textbox is for searching. My question is do you know how to search with all fields in gridview.For example: I have a gridview contains, FIRST NAME, MIDDLE NAME, and LAST NAME, and if I type in the textbox the gridview will automatically get what I've inout in textbox.
View 1 RepliesI have a gridview control connected to a sqldatasource control. I am allowing the user to sort the columns in the gridview control. The user can click a row and visit another page. When they return I need to set the column sort again. I have seen that I can use the Sorting event to set the sort order of the data when I return to the page in the Sorting event. But before I leave the page where can i get the column it is currently sorted on along with the direction?
View 3 RepliesI need a textbox for each column of the header row of my Gridview. Then whatever I type in, say the first column is a Surname, the Gridview needs to be filtered by records with only that Surname.
View 3 RepliesI have a gridview control on .aspx page. Situation is, the columns in the gridview control are not databound. I query the database and load the gridview control using the following code.
GridViewstockcalc.Visible = true;
GridViewstockcalc.DataSource = dataSetstockcap.Tables[0];
GridViewstockcalc.DataBind();
The gridview control shows about 13 columns from the database. But we want the user to be able to edit only one column. Rest of the 12 columsn should be read only. When the clicks one Edit button button, as usual the Update and Cancel buttons should come up. It is not happening. Only the _Rowediting event is getting trigged. Following is the code from my .aspx page. I don't know anything about template columns and not sure if I have to use that concept in my situation.
<asp:GridView ID="GridViewstockcalc" runat="server"
HeaderStyle-BackColor="#444444"
HeaderStyle-ForeColor="White"
onrowcommand="GridViewstockcalc_RowCommand" Height="150px"
Font-Size="Small" onrowediting="GridViewstockcalc_RowEditing"
onrowupdating="GridViewstockcalc_RowUpdating">
<Columns>
<asp:CommandField ShowEditButton="true" ShowCancelButton="true" />
<asp:TemplateField HeaderText="ticker">
<ItemTemplate>
<%# Eval("ticker")%>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox runat="server" ID="txtticker" Text='<%# Eval("ticker")%>' />
</EditItemTemplate>
</asp:TemplateField>
<asp:BoundField DataField="fhlb_ID" HeaderText="ticker" ReadOnly="true" />
</Columns>
I am trying to create a bound column and bind the data with the below piece of code . And the column has two files Name and Fee but the code binds only the Fees column and Name column become empty..
Code:
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
[Code] ....
Design Part
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>Untitled Page</title>
<style type="text/css">
[Code] ....
how to put three rows of one table data in gridview one coloumn
how to add text1,text2,text3 rows data in upper as i write but the proper code
<asp:BoundField ItemStyle-Width = "150px" DataField = "LT_SHOWNAMETEXT1" HeaderText = "SHOW NAME"/>
<asp:BoundField ItemStyle-Width = "150px" DataField = "LT_TEXTTYPE" HeaderText = "TEXT TYPE"/>
<asp:BoundField ItemStyle-Width = "150px" DataField = "text1,text2,tex3 " HeaderText = "TEXT"/>
[Code].....
Right now when I bind data to my gridview, I have a column MemberNo that I use in the RowDataBound in another column for creating a link. Anyways, in the DataBound event i hide the MemberNo column. But I also have a routine where I need to loop through the rows and use the MemberNo. Can I unhide the column MemberNo to use for this routine and then hide it again? I assume I cannot use the data if it is hidden right?
View 2 RepliesI have a gridview that I am loading from a stored procedure. I need to be able to hide certain columns and change the column names. Since it is loading with stored procedure the columns aren't listed in the gridview->edit columns properties.
View 1 RepliesSOURCE CODE -
Code:
<asp:GridView runat="server" ID="Grd" AutoGenerateColumns ="false" >
<Columns >[code]....
You can see in Pic Attached, Records of table TBL_STUDENT, and also find the output what I am getting . For the records - 2 and 3 whose Name is B and C, I m getting the correct status,But for the Record whose Name is A, I am not getting correct Output, Because in Database null is dere, I want if in database null is dere then checkbox is Unchecked. How to to dat???
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...?
I am in VS2008 and in ReporViewer's Design page.
I have "Fruits" as column fields and Months as row fields and Sales as data field.
I have these columns:-
Apple, Orange, Pear.
However, I want it be displayed as
Orange, Pear, apple.
Any work around ?
Also I need a 4th column adding the Apple, Orange and Peer numbers total. How to do it in design view in VS2008 ?
Is there anyway to have a detailsView auto Generate the fields in a Table.I am binding my detailsview to a datatable but only getting the first two fields ....
View 1 RepliesI am writing an SQL query in which that I will need to perform a sub select on a table, which will usually return multiple rows. I need to be able to join together the results of a certain field from all the rows into one field to output. Is this possible, and how?
For example, if the SQL query returns
id | field
1 | test1
2 | test2
3 | test3
I need the outputted field to be "test1 test2 test3".
In sql table I have fields which needs to be mapped with ALIAS field names. How to do the mapping when coding. Currently I have
select *,,data_type from mappingtable,information_schema.columns where where mainfield='City' or aliasfield ='City'
execute query using reader
This table does not contain the actual data
Its contains onky the mainfield and its alias field name
I get City from a variable
I have a second table which contains mainfield ie the column names & the actual data then I use
if( reader["data_type"].ToString() == "numeric")
do something and so on
make label control visible true
else
make dropdown visible true
but there is lot of performance and speed issue. What would be the correct method so as to enhance the above...
On my form I have a button that pops up a panel to select an option from. It does a postback to fill in a textbox with the selected data. The other controls such as other textboxes and dropdowns are reset. Any way to stop this? Or do I have to save the settings and set it back on the postback?
View 4 Replies