My Grid is bound to a collection type datasource. When I try to sort the Columns in the Grid I get Javascript error saying sorting event not implemented. Why is the default inbuilt sort functionality not working which worked fine when I directly used a sqlDataSource using smart tag. Do I have to write some code to achieve sorting ?
View 1 Repliesi'm looking for a control with following functionality in GridView or other data control
1. Excel Type Editing, with ability copy to and from excel
2. Ordering the rows with Drag and Drop functionality
I have a manually binded gridview, which I set AutoGenerateColumns=False. I then tried to set AllowSorting=true at runtime, but it wont work.
My gridview are created during runtime.
i have an objectdatasource bound to the System.Web.Security.Roles getAllRoles methods, this method returns an string[] with the names of the roles, then i wanna bind a gridview with this datasource, but it shows me just a one column named length(the length of each role name), how can i instead the length of the string that represent the role name, put the role name?
View 3 RepliesIn gridview I am able to sort on 1 column as mentioned below, I want to add one more column in sorting, what is the best way to do this,
[Code]....
I have this code that once a column in gridview is clicked, it sort the record. Can someon explain to me what does
static Int32 cntsortSecurityID = 0; // declare var to hold 0 or 1 // what is this, I dont understand why. what is the meaning of zero or One in this case . Oh yeas, the code is working for me, but I need to understand the concept behind it.
if (e.CommandName == "sortSecurityID")
{
DataView dv = ((DataSet)(Session["data"])).Tables[0].DefaultView;
if (cntsortSecurityID == 0)
{
dv.Sort = "SecurityID asc";
cntsortSecurityID = 1;
}
else
{
dv.Sort = "SecurityID desc";
cntsortSecurityID = 0;
}
gvTrans.DataSource = dv;
gvTrans.DataBind();
}
I have a GridView in ASP.Net 3.5. I added BoundFields as columns, set DataField and Header Text. Total I have 6 columns like that. Although I set "AllowSorting=True" in design view, when I run this page, all the columns didn't have hyper link that I can click on it and sort that particular column. I bind this column at code behind by using datatable.
gv.DataSource = dtDispatch
gv.DataBind()
I have a grid view with manual sorting. In some cells, the data are numeric and datetime. But due to some constrains, the data type on tables are varchar. The problem here is when I sorting those numeric data, it is treated as varchar.Eg: 1, 12, 13, 2, 23, 3, ...But I wanted the order to be: 1, 2, 3, 12, 13, 23, ...I have tried these method, but it doesnt works.
[Code]...
wondering if someone can possibly help me out with a gridview. I have data coming into a grid and I know how to filter the data using one dropdown, I'm trying to get a little more advanced now. I'd like to filter using three dropdowns.
This is what I have so far: I don't know how to hook the downlists to the query?
<asp:DropDownList runat="server" id="DropDownList1" Width="90px">
<asp:ListItem Value="item_num">Item #</asp:ListItem>
<asp:ListItem Value="lot_num">Lot #</asp:ListItem>
<asp:ListItem Value="production_code">Production Code
</asp:ListItem>
<asp:ListItem Value="batchcode">Batch Code</asp:ListItem>
<asp:ListItem Value="inbound_no">Inbound #</asp:ListItem>
<asp:ListItem Value="recv_date">Received Date</asp:ListItem>
<asp:ListItem Value="location">Location</asp:ListItem>
<asp:ListItem Value="category">Category</asp:ListItem>
</asp:DropDownList>
<asp:DropDownList runat="server" id="DropDownList2" Width="160px">
<asp:ListItem Value="=">is equal to</asp:ListItem>
<asp:ListItem Value="<=">is less than or equal to
</asp:ListItem>
<asp:ListItem Value=">=">is greater than or equal to
</asp:ListItem>
<asp:ListItem Value="<>">is not equal to</asp:ListItem>
<asp:ListItem Value="begins with">Begins With</asp:ListItem>
<asp:ListItem Value="Like">Ends With</asp:ListItem>
</asp:DropDownList>
<asp:TextBox runat="server" id="TextBox1" Width="150px">
</asp:TextBox>
<asp:Button runat="server" Text="Go" id="Button8" BackColor="Lime" />
<asp:Button runat="server" Text="Clear Filter" id="Button9" /><br />
<input name="Checkbox1" type="checkbox" /><label id="Label5">
Include Items containing "Zero on Hand" Quantity.<br />
Group by Fields: <input name="Checkbox2" type="checkbox" />
Item/Lot
<input name="Checkbox3" type="checkbox" /> Production Code
<input name="Checkbox4" type="checkbox" /> Batch Code</label><label id="Label4"></label><br />
<hr />
<asp:GridView runat="server" id="GridView1" AutoGenerateColumns="False" DataSourceID="SqlDataSource1" Font-Size="Small" BorderStyle="None" BackColor="White" GridLines="Vertical" BorderColor="#999999" BorderWidth="1px" CellPadding="3" Font-Underline="False"
AllowSorting="True" AllowPaging="True" PageSize="20">
<RowStyle BackColor="#EEEEEE" ForeColor="Black" />
<Columns>
<asp:boundfield DataField="STATUS" HeaderText="Status" SortExpression="STATUS">
</asp:boundfield>
<asp:boundfield DataField="ITEM_NUM" HeaderText="Item #" SortExpression="ITEM_NUM">
</asp:boundfield>
<asp:boundfield DataField="LOT_NUM" HeaderText="Lot #" SortExpression="LOT_NUM">
</asp:boundfield>
<asp:boundfield DataField="LOT_EXT" HeaderText="Lot Ext" SortExpression="LOT_EXT">
</asp:boundfield>
<asp:boundfield DataField="RECV_DATE" HeaderText="Recv Dt" SortExpression="RECV_DATE">
</asp:boundfield>
<asp:boundfield DataField="PRODUCTION_CODE" HeaderText="Prod Code" SortExpression="PRODUCTION_CODE">
</asp:boundfield>
<asp:boundfield DataField="QTY_ONHAND" DataFormatString="{0:NO}" HeaderText="OnHand" SortExpression="QTY_ONHAND">
</asp:boundfield>
<asp:boundfield DataField="QTY_RESERV" HeaderText="Reserv" SortExpression="QTY_RESERV">
</asp:boundfield>
<asp:boundfield DataField="QTY_AVAIL" DataFormatString="{0:N}" HeaderText="Avail" SortExpression="QTY_AVAIL">
</asp:boundfield>
<asp:boundfield DataField="QTY_ADJUST" HeaderText="Adjust" SortExpression="QTY_ADJUST">
</asp:boundfield>
<asp:boundfield DataField="QTY_SHIP" HeaderText="Shipped" SortExpression="QTY_SHIP">
</asp:boundfield>
<asp:boundfield DataField="QTY_RECV" HeaderText="Recv" SortExpression="QTY_RECV">
</asp:boundfield>
<asp:boundfield DataField="PROD_DATE" HeaderText="Prod Date" SortExpression="PROD_DATE">
</asp:boundfield>
<asp:boundfield DataField="RELEASE_DATE" HeaderText="Release" SortExpression="RELEASE_DATE">
</asp:boundfield>
</Columns>
<FooterStyle BackColor="#CCCCCC" ForeColor="Black" />
<PagerStyle HorizontalAlign="Center" BackColor="#999999" ForeColor="Black" />
<SelectedRowStyle BackColor="#008A8C" Font-Bold="True" ForeColor="White" />
<HeaderStyle BackColor="#000084" ForeColor="White" Font-Bold="True" />
<AlternatingRowStyle BackColor="#DCDCDC" />
</asp:GridView>
<asp:SqlDataSource runat="server" id="SqlDataSource1" ConnectionString="<%$ ConnectionStrings:RemoteRooster %>" SelectCommand="SELECT * FROM [INVENTRY] WHERE OWNER = 'CompanyName' AND QTY_ONHAND > '0'">
</asp:SqlDataSource>
sorting of datatable and bind it to grid view
View 1 RepliesI have a custom object and a generic collection of this object.When databinding, how can you get a reference to the object's collection similar to how DataRow.Table works? I understand I may need to write code to handle this but I'm not sure where to start.I considered adding a property to my custom object class to store the collection in, but would this generate too much overhead setting this for every object in the collection?
View 3 RepliesI'm trying to pass email addresses from an array to a stored procedure, then display the results in my gridview. I get the following error:No mapping exists from object type System.String[] to a known managed provider native type.On this line: Dim DR As SqlDataReader = MyCommand.ExecuteReader
[Code]....
The stored proc fired to populate my grid view gets a column CasNo.The GridView has a DataBound item for CaseNo.
[Code]....
Then Why does this get null value: string caseNo = dataRow["CaseNo"] as string;
[Code]....
[Code]....
how to write grid view template (All option sort,) in code behind
View 1 Repliescan we bind any type of System.Collection to DataSource property of a DataGrid ?
View 6 RepliesI'm a newbie to .NET, so the solution might be really trivial. I have a database, I have an Entity Data Model, I add in my Index.aspx page an EntitryDataSource and a GridView. I connect them and everything works fine (the data is displayed as expected). The problem is that clicking on the coulmn name or on the pagination lists doesnt do a thing... Although I did set the properties AllowSorting="True" and AllowPaging="True". I also tried with another datasource type (SqlDataSource) and the same problem.
View 2 RepliesI'm developing a bilingual web site, and therefore, I'm changing the text of the headings and the select buttons of my gridviews. I just discovered that if I set some code like below in the rowdatabound event of the gridview, the "linkbuttonish" headings get replaced by unclickable text. In another thread, I was told to change
If Session("lang") = "en" Then
If e.Row.RowType = DataControlRowType.Header Then
e.Row.Cells("name").Text = "Given name"[cod]...
in the myGV_DataBound sub.This works well, but not everywhere. A few gridviews are populated from codebehind, and this is where things go wrong. What happens is that - nothing happens (it's still the original heading). I added a Watch, but once the HeaderText property changed, the Watch never yielded another result, but stayed with the new value.
Now I suspect that even though the HeaderText property has changed, this doesn't get reflected in the GV when populated from codebehind.
I guess that I should write something else than "e.Row.Cells("name").Text" to still have the click-behaviour, but I don't know what.
The same question arises for the select linkbutton in a cell of the gridview's datarows.
If the grid column is clicked to sort i dont want to retireve data agian, i can get it from viewstate, but i dont know if that triggered the post back or if the ImageButton on the page triggered it
View 5 Repliesam newbie to asp.net 3.0 ,req: is like ...whn user enters id in the textbox,the query has to run against the sql server DB and has to generate the result inside a gridview with a chkbox field by default chked,now in the DAL layer ,is it better option to use datareader(think not,since it has to always maintain connection)..or webservice or WCF or are there any other simple optios available??
View 2 RepliesI'm developing a bilingual web site, and therefore, I'm changing the text of the headings and the select buttons of my gridviews. I just discovered that if I set some code like below in the rowdatabound event of the gridview, the "linkbuttonish" headings get replaced by unclickable text. Thus, sorting the gridview is suddenly not working. What should I write instead?
If Session("lang") = "en" Then
If e.Row.RowType = DataControlRowType.Header Then
e.Row.Cells("name").Text = "Given name"
End If
End If
I guess that I should write something else than "e.Row.Cells("name").Text" to still have the click-behaviour, but I don't know what. The same question arises for the select linkbutton in a cell of the gridview's datarows.
i am developing a sharepoint webpart. In this webpart i need to use a repeater control. The problem is, i can only use codebehind for creating and using the control. So i have some questions:
1. After creating the repeater control in codebehind, how to create some templates (itemtemplate, footertemplate, etc.) and use it?
2. How to bind a object collection to a repeater control?
the code is like,
namespace DataControlsSample.App_Code.PL
{
public partial class GridView : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
[Code]....
the data table is getting rows ,as i had chked ,,,but grid view is not getting displayed ..wat could be the problem?
I have an gridview consisting pager Templet. In pager templet, add first, previous,next and last Buttons to control records. PageSize is 3. First I am binding first 3 records from the list (Consisting 9 records) to the GridView.
My question is:
<1> Is it possible to bind the next 3 records(record4, record5,record6) to GridView when click on next Button?
<2> Similally, Is it possible to bind records for other buttons?
Unable to cast object of type 'System.Web.UI.LiteralControl' to type 'System.Web.UI.WebControls.TextBox'.
[code]....
I have a Listview control that DataBind programatically... ie I am NOT using SqlDataSource or such... I am attempting to sort a column... clicking on a link button that fires the "Sorting" event. So, after cliking on the column heading... I end up in this routine, where I hardcoded the .Sort = values (just for testing). The code is executed... but the RESULT show via Listview remains the SAME. No change!
How to fix this? I've seen some other posts examples that uses this event (ListView1_Sorting) and then sort via LINQ. I am not ready to try that...
Just want to know why dsPaymentList.Tables[0].DefaultView.Sort does not work?
I followed the example at: [URL]
protected void ListView1_Sorting(object sender, ListViewSortEventArgs e)
{
string sortExpression = e.SortExpression + " " + e.SortDirection;
DataSet dsPaymentList = new DataSet();
[Code]....