I m Using DataList Controll for the time being. But i wana use DridView Controll that should display Data Horizontally. Is it Possible? if Yes then How?
[Code]....
I have gridview and want to show datalist in grid view view column on click of linkbutton show.
[Code]....
I have in my code a gridview that I redirect to excel, it works fine when I have data in the data set. waht I want is to show column headers when there is no data right now what i get is empty sheet.
View 7 RepliesI have a grid view with a few columns, for example a column in the grid view contains description of a product. The description might be very long, so i want to display only first 100 characters of the description and then provide a . when we click on the. then the whole description should be displayed.
View 3 RepliesI am trying to show/hide TemplateField of gridview but not getting it... here is ma sample aspx code
<asp:TemplateField HeaderText="ColumnA">
<ItemTemplate>
<asp:Label ID="lblTest" runat="server" Text=' <%# Eval("Test")>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
Now in server side i am trying to hide this column but failed !!
protected void gv_RowCreated(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.Header || e.Row.RowType == DataControlRowType.DataRow)
gv.Columns[2].HeaderStyle.CssClass = "hiddenClass"; // here i am setting display:None using css class
}
how to show/hide TemplateField on server side
i want show ten record from table in the gridview at 2 column in five row.
like this:
------------gridview-------------
record1 | record2
record3 | record4
record5 | record6
record7 | record8
record9 | record10
1 2 3 ...
-----------------------
I have a GridView that isn't databound until the user clicks a button...
[Code]....
The GridView has one bound column: the employee name. It also has a template field that has an empty asp:Table.
[Code]....
I populate the tblInfo in the RowDataBound event.
[Code]....
The CreateInfoTable(...) method manually creates the rows and columns for the employee. This works, and I can see my dynamically created table; however, after the user submits the form back to the server for PostBack, the rendered page after submission is missing my manually populated table. How can I save my table across PostBacks?
I have a gridview, which contains a template field with a button. On this button, I want to show and hide another column with this one button. I don't want to use Java Script because my site already uses a lot of this and AJAX. So, can someone show an example of some code behind, which is what I want to do on how to show and hide another column on a gridview?
View 1 RepliesI want to display data in gridview in horizontal format (column wise). I mean similar to the RepeatColumns="Horizontal" format of the datalist.
View 6 Repliesas 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..
How can i make a gridview always started ascending, depending on one of my columns? considering that is Populate it from database SqlDataSource
View 1 Repliesi have a gridview, in my gridview, i have a attachment button.
when user click on the attachment button, it will direct them to EquipmentAttachment.aspx.
what i want to do right now is, if the attachment exist, then the attachment button visible, else the button attachment set to false.
I have a gridview with around 250 columns which are generated automatically except first column which is fixed. Is there any way I can fix the first column but allow horizontal scrolling on remaining columns.
I have only 6 rows in gridview so don't need vertical scroll.Here is my code.
<div id="dvShipmentGrid" style="width: 1000px; padding-right: 10px;
I need to display a table but in a horizonal manner, i should be able to catch the item selected event.
View 2 RepliesI have a dataset which I bind to a gridview for display. Normally, the gridview shows the dataset table column name as the column header and the data is bound vertically - i.e. the dataset table rows are created in a vertical/downward fashion. What I would i like do however in my application is to get the GridView to bind in the horizontal direction. So the data that is bound "moves" towards the right. Before suggesting a repearter or datalist, I also have a requirement to not wrap. I have not been successfull getting the repeater/datalist not to wrap unless you know of a setting you can share.
View 1 Repliesi designed a gridview with HeaderStyle Freeze like this
<HeaderStyle CssClass="FreezeMe" Wrap="true" />
.FreezeMe
{
background: #ecf5ff;
color: #333;
background-color: #6D91BF;
border-style: solid;
border-width: 1px;
border-color: #9cc9ed #5c9fde #6daddb #b4d2f0;
font-weight: bold;
text-align: center;
color: white;
text-decoration: none;
font-size: 13px;
position: relative;
top: expression(this.offsetParent.scrollTop);
z-index: 10;;
height:40px;
font-size:30px;
}
i have applied my gridview within DIV tag because i need horizontal scrool bar(if no. of record is high) but i didnt see the scrollbar ...
my sp return resultset with different column names based on different parameters passed to sp and now i want to show that data in asp.net(c#) gridview so how can i achieve this
View 1 Repliesi have created a simple view, and display it into gridview.. i have successfully created view but it is not shown in grid view , it return nothing...
protected void Button3_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection(@"Data Source=.SQLEXPRESS;AttachDbFilename=E:
arenHDI-AJAX-TK-Calendar-CSApp_DataDatabase.mdf;Integrated Security=True;User Instance=True");
con.Open();
SqlCommand cmd = new SqlCommand("select * from nview", con);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
GridView1.DataSource = ds;
GridView1.DataBind();
con.Close();
}
I am referring below url , there is one column which has some large data i dont want to show in grid, but on clicking show detail i want to show detail in Modal Popup, right now it shows blank data, is there any solution for it. URL..
View 1 RepliesI am checking string  and then bind category. If condition is false then i  need anchor tag in which i pass querystring to specific link.
<itemtemplate>
<asp:Literal runat="server" ID="litPrice" Text='<%#((String.IsNullOrEmpty(Eval("Price").ToString()) || Eval("Price").ToString()=="00/0.00" || Eval("Price").ToString()=="0/0.00") ? "<span font-family="arial"><a href="http://www.xyz.com/web/enquiries.asp?category="+ Eval("category")>Enquiry</a></span>" : Eval("Price"))%>' >
</asp:Literal>
</itemtemplate>
I am getting error. CS1010: Newline in constant
I need to set 1px Image as Horizontal and Vertical GridLines, gridBorder, HeaderSeperator in a GridView.
View 2 RepliesI have a gridview which is binded to a Sqldatasource. I would like to replace a column data field value to 'Not Applicable' if that column has got a value of 2 in database.
View 2 RepliesI have on a page a gridview that can be filtered with one text box. I set up the gridview to show select and wanted to then connect a details view so that when you selected a row the entire details would show up. When I run it I get this error. Data keys must be specified on GridView 'GridView1' before the selected data keys can be retrieved. Use the DataKeyNames property to specify data keys.
<%@ Page language="C#" masterpagefile="MainContent.master" title="Electrical Storage" EnableEventValidation="false" %>
<asp:Content id="Content1" runat="server" contentplaceholderid="Content">
<div id="Rightside">
<h2>Search Electrical Storage
</h2>
<li><a href="EStorageResultsAll.aspx">View All Files</a></li>
<li>Specify Projects to View</li>
<br />
<br />
<form>
Search: <asp:TextBox id="Search" runat="server"></asp:TextBox>
(% is wildcard)<br /><br />
<asp:Button runat="server" Text="Search" id="Button1"
PostBackUrl="electrical_storage.aspx" Height="26px" BackColor="#000066" ForeColor="White" Width="129px"></asp:Button>
<br />
<hr />
<asp:GridView id="GridView1" runat="server" AutoGenerateColumns="False" BackColor="#CCCCCC" BorderColor="#999999" BorderStyle="Solid" BorderWidth="3px" CellPadding="4" CellSpacing="2" DataSourceID="AccessDataSource1" ForeColor="Black" Width="820px" AllowSorting="True">
<RowStyle BackColor="White" />
<Columns>
<asp:commandfield ShowSelectButton="True">
</asp:commandfield>
<asp:boundfield DataField="CoID" HeaderText="Co ID" SortExpression="CoID">
</asp:boundfield>
<asp:boundfield DataField="ProjClass" HeaderText="Project Class" SortExpression="ProjClass">
</asp:boundfield>
<asp:boundfield DataField="Project" HeaderText="Project" SortExpression="Project">
</asp:boundfield>
<asp:boundfield DataField="FileName" HeaderText="File Name" SortExpression="FileName">
</asp:boundfield>
<asp:boundfield DataField="FileAddInfo" HeaderText="File Add Info" SortExpression="FileAddInfo" Visible="False">
</asp:boundfield>
<asp:boundfield DataField="FileNumber" HeaderText="File Number" SortExpression="FileNumber" Visible="False">
</asp:boundfield>
<asp:boundfield DataField="BoxNumber" HeaderText="Box Number" SortExpression="BoxNumber" Visible="False">
</asp:boundfield>
<asp:boundfield DataField="Location" HeaderText="Location" SortExpression="Location" Visible="False">
</asp:boundfield>
</Columns>
<FooterStyle BackColor="#CCCCCC" />
<PagerStyle BackColor="#CCCCCC" ForeColor="Black" HorizontalAlign="Left" />
<SelectedRowStyle BackColor="#000099" Font-Bold="True" ForeColor="White" />
<HeaderStyle BackColor="#000066" Font-Bold="True" ForeColor="White" />
</asp:GridView>
<asp:AccessDataSource ID="AccessDataSource1" runat="server" DataFile="\Elec1DATABASEStorageElectricalFilesBook.mdb" SelectCommand="SELECT [CoID], [ProjClass], [Project], [FileName], [FileAddInfo], [FileNumber], [BoxNumber], [Location] FROM [FilesWithLocation]
WHERE (([CoID] LIKE '%' + ? + '%') OR ([ProjClass] LIKE '%' + ? + '%') OR ([Project] LIKE '%' + ? + '%')OR ([FileName] LIKE '%' + ? + '%')OR ([FileAddInfo] LIKE '%' + ? + '%')OR ([BoxNumber] LIKE '%' + ? + '%'))">
<SelectParameters>
<asp:controlparameter ControlID="Search" Name="CoID" PropertyName="Text" Type="String" />
<asp:controlparameter ControlID="Search" Name="ProjClass" PropertyName="Text" Type="String" />
<asp:controlparameter ControlID="Search" Name="Project" PropertyName="Text" Type="String" />
<asp:controlparameter ControlID="Search" Name="FileName" PropertyName="Text" Type="String" />
<asp:controlparameter ControlID="Search" Name="FileAddInfo" PropertyName="Text" Type="String" />
<asp:controlparameter ControlID="Search" Name="FileNumber" PropertyName="Text" Type="String" />
<asp:controlparameter ControlID="Search" Name="BoxNumber" PropertyName="Text" Type="String" />
</SelectParameters>
</asp:AccessDataSource>
<asp:AccessDataSource id="AccessDataSource2" runat="server" DataFile="\Elec1DATABASEStorageElectricalFilesBook.mdb" SelectCommand="SELECT * FROM [FilesWithLocation] WHERE ([SearchString] = ?)">
<SelectParameters>
<asp:controlparameter ControlID="GridView1" Name="SearchString" PropertyName="SelectedValue" Type="String" />
</SelectParameters>
</asp:AccessDataSource>
<asp:DetailsView id="DetailsView1" runat="server" AutoGenerateRows="False" DataSourceID="AccessDataSource2" Height="50px" Width="442px">
<Fields>
<asp:boundfield DataField="CoID" HeaderText="Company ID" SortExpression="CoID">
</asp:boundfield>
<asp:boundfield DataField="ProjClass" HeaderText="Project Class" SortExpression="ProjClass">
</asp:boundfield>
<asp:boundfield DataField="Project" HeaderText="Project" SortExpression="Project">
</asp:boundfield>
<asp:boundfield DataField="FileName" HeaderText="File Name" SortExpression="FileName">
</asp:boundfield>
<asp:boundfield DataField="FileAddInfo" HeaderText="File Additional Info" SortExpression="FileAddInfo">
</asp:boundfield>
<asp:boundfield DataField="PeriodBegin" DataFormatString="{0:d}" HeaderText="Period Begin" SortExpression="PeriodBegin">
</asp:boundfield>
<asp:boundfield DataField="PeriodEnd" DataFormatString="{0:d}" HeaderText="Period End" SortExpression="PeriodEnd">
</asp:boundfield>
<asp:boundfield DataField="FileType" HeaderText="File Type" SortExpression="FileType">
</asp:boundfield>
<asp:boundfield DataField="FileNumber" HeaderText="File Number" SortExpression="FileNumber">
</asp:boundfield>
<asp:boundfield DataField="BoxNumber" HeaderText="Box Number" SortExpression="BoxNumber">
</asp:boundfield>
<asp:boundfield DataField="SearchString" HeaderText="Search String" ReadOnly="True" SortExpression="SearchString">
</asp:boundfield>
<asp:boundfield DataField="Location" HeaderText="Location" SortExpression="Location">
</asp:boundfield>
</Fields>
</asp:DetailsView>
</form>
</div>
</asp:Content>
<asp:Content id="Content2" runat="server" contentplaceholderid="head">
<style type="text/css">
table {
width: 820px;
}
.gridview {
width: 820px;
position: fixed;
}
</style>
</asp:Content>
I have a GridView control in my aspx page with a column that represents logging levels. Instead of displaying the word, e.g"Info", "Debug", "Error", etc. I want to display an image from a file. It seems like I may be able to do this with a template but I have been unable to find any examples of exactly how I would do this.
If "Info" then display "images/info.gif
If "Error" then display "images/error.gif
etc.
Here is my code snippet
[Code]....
I just started to new asp.net.
how set a column of gridview?
and how to add data from text box to gridview?