I have a grid containing images loaded from database. the images are displayed in the order as they are stored in the database. Is there any way to change the order of the images manually once after they are uploaded to the database.. the admin before publishing the images to front end, should be able to arrange the images as he/she wish and then finally stores them in database.
View 5 RepliesI have a datagrid that has photos and a description of the individual in the photo. I have a procedure that works and if I execute it with the correct parameters it changes the rows in the table. I have a datagrid with two image buttons, MoveUp and MoveDown. I just want to be able to reorder the photos when needed.
In my proc called "MoveMember" I have these parameters that are passed in. The column that gets swapped in my table is the "OrderBy" column, they are just numeric numbers 1,2,3,4 etc.
So in my procedure 2 and 3 can be interchanged.
I have 2 datsets named ds and ds1 and merged that datasets into a single table named dt. Now, i want to compare the first dataset row value with second dataset column values For Ex: 1 dataset row contains the value as "SriDevi" means, i want to compare and find how many times the value "SriDevi" appears in second dataset columns and count the appearance. And give the answer as the "count".
[code]....
I am looking to sort a column on my gridview by simply clicking on the column rather than clicking on the column header. In the design I have been given, the column header will not be shown, and I need to be able to give the user to sort this column, by simply just clicking any where on the column.
View 2 RepliesI have a datagrid and a template column which is bound. I don't understand how to set the sortExpression to make sorting on that column work.
View 2 RepliesI have 5 bound columns to be retrieved from the database but I want that on page load event the retrieval of data should be sorted according to that column only
View 1 RepliesI have a GridView that exports to .csv just fine with the code below. The problem is that I have a TemplateColumn with a TextBox which isn't wrote to the .CSV at all!
<asp:GridView ID="GridView1" runat="server" DataSourceID="as400"
AutoGenerateColumns="False" CellPadding="4" ForeColor="#333333"
GridLines="None">
<RowStyle BackColor="#FFFBD6" ForeColor="#333333" />
<Columns>
<asp:BoundField DataField="IMSKU" HeaderText="SKU" />
<asp:BoundField DataField="IMDESC" HeaderText="Description" />........
I have a .aspx file with a datagrid in it:
<asp:DataGrid ID="Gifts"
AutoGenerateColumns="True"
runat="server" AllowSorting="True">
</asp:DataGrid>
The .aspx.vb file associated with it fills it in with a datagrid object.
Protected WithEvents Gifts As System.Web.UI.WebControls.DataGrid
Public GiftData As DataTable
Gifts.DataSource = New DataView(GiftData)
Gifts.DataBind()
That all works fine. However I want to format one of the columns with a particular date format. Is there a way of doing that in the vb code? I know I can do it in the .aspx by specifing AutoGenerateColumns="False" and then explicitly defining the columns, but I want to do it in the code as it's more future proof for my application.
I've created a Column button in datagrid using this code
<Columns>
<asp:ButtonColumn Text="Resend" ButtonType="PushButton" CommandName="Resend"></asp:ButtonColumn> </Columns>
But I don't know where to access the event of this Button, also I would like to know how to retrive the row data of this button
I take a data grid for display item in data grid I can edit and update and this is work fine but I do not want that my HolidayID column will not be editable ...
<Columns><asp:BoundColumn DataField=HolidayID HeaderText="HolidayID" >
<ItemStyle BackColor=GhostWhite />
</asp:BoundColumn> </Columns>
Let's say I have a DataGrid that looks something like:
<asp:DataGrid ID="SomeDataGrid"
runat="server">
<Columns>
<asp:BoundColumn HeaderText="A Header" SortExpression="Sort" DataField="Data"></asp:BoundColumn>
</Columns>
</asp:DataGrid>
In this Grid, I set the datasource to some collection that contains a public property called "Data" and do a databind(). Every works as expected.Now let's say I want to set the DataField attribute of the column to a public member, or a property, or some other thing I've computed. What is the easiest way to go about this without creating intermediate objects or adding public properties to the objects in the collection?So what I want to do is something like:
<asp:BoundColumn HeaderText="A Header" SortExpression="Sort" DataField="someMethod()"></asp:BoundColumn
I have "Order" object with Columns Ticket,OTP and CustomerName etc.Intially on DataGrid, I'm binding Ticket only , when user clicks on "Column Chooser" button, another windows appears to pickup CustomerName,OTP columns to add specified column dynamically on Datagrid. Environment : Asp.net ,C# with Object Data source
Public Class Order
{
publc void Order()
{
}
public string Ticket
{
get
{
return this.strTicket;
}
set
{
this.strTicket = value;
}
}
public string OtpNumber
{
get
{
return this.strOtpNumber;
}
set
{
this.strOtpNumber = value;
}
}
public string CustomerName
{
get
{
return this.strCustomer;
}
set
{
this.strCustomer = value;
}
}
}
}
I have a datagrid which I only want the maintenance column to be editable (the other fields are only editable to admins at a different web page)
I've only just started messing with asp/SQL and would be very grateful for the help :)
Below is my code. I have tried messing with the update queries and it seems to mess up everytime some way or another. I'v
[Code]....
I've got a typed dataset that populates programmatically based upon dropdown selections from the user, and then is bound to a datagrid. One of the cols is a bit type (indicating whether or not that record is "active"). I would like that datagrid col to be exposed to the user as a bunch of checkboxes, which the user could turn on and off as needed, and then update the entire recordset according upon clicking Submit.
Is converting a dg column into checkboxes a straightforward thing to do?
how to sort DataGrid column. (Say like FirstName) I have done snippet like: (see Bold text) For HTML :
<asp:DataGrid ID="dtgCustomerSearch" runat="server" AllowSorting="true">
<Columns>
<asp:BoundColumn HeaderText="CustomerID" DataField="CustomerID" />
<asp:BoundColumn HeaderText="First Name" DataField="FirstName"
SortExpression="FirstName" />
<asp:BoundColumn HeaderText="Last Name" DataField="LastName"
SortExpression="LastName" />
<asp:BoundColumn HeaderText="Phone No." DataField="Phone" />
<asp:BoundColumn HeaderText="Email ID" DataField="EmailID" />
</Columns>
</asp:DataGrid>
On Page_load I have wrote: this.dtgCustomerSearch.SortCommand += new DataGridSortCommandEventHandler(dtgCustomerSearch_SortCommand);
private void dtgCustomerSearch_SortCommand(object source, System.Web.UI.WebControls.DataGridSortCommandEventArgs e)
{
SortExpression = e.SortExpression;
BindTheGrid();
}
string SortExpression
{
set
{
if (ViewState["SortExp"] == null || value != ViewState["SortExp"].ToString())
{
ViewState["SortExp"] = value;
}
else
{
ViewState["SortExp"] = value + " DESC";
}
}
get
{
return ViewState["SortExp"] == null ? string.Empty : ViewState["SortExp"].ToString();
}
}
I have a datagrid that is supposed to display the list of uploaded word doc containing a specific word , this sort by the one having the greatest number of occurences(relevance).
It should allow the user to download one of the file by clicking on the button column .But im unable to get the text appearing in the datagrid nor the one in the button column
these are the table column
Firstname,Lastname,Path and Relevance
This is the code on item command:
[Code]....
the datagrid code:
<asp:DataGrid ID="DataGrid1" runat="server" AllowPaging="True"
BackColor="White" BorderColor="#DEDFDE" BorderStyle="None" BorderWidth="1px"
CellPadding="4" ForeColor="Black" GridLines="Vertical" ShowFooter="True"
AutoGenerateColumns="False" onitemcommand="DataGrid1_ItemCommand"
Width="353px">
<FooterStyle BackColor="#CCCC99" />
<SelectedItemStyle BackColor="#CE5D5A" Font-Bold="True" ForeColor="White" />
<PagerStyle BackColor="#F7F7DE" ForeColor="Black" HorizontalAlign="Right"
Position="TopAndBottom" />
<AlternatingItemStyle BackColor="#6699FF" Font-Bold="False" Font-Italic="False"
Font-Overline="False" Font-Strikeout="False" Font-Underline="False" />
<ItemStyle BackColor="#F7F7DE" />
<Columns>
<asp:BoundColumn DataField="firstName" HeaderText="FirstName" ReadOnly="True">
</asp:BoundColumn>
<asp:BoundColumn DataField="lastName" HeaderText="LastName" ReadOnly="True">
</asp:BoundColumn>
<asp:ButtonColumn CommandName="getCv" DataTextField="Path" HeaderText="Cv"
Text="Path"></asp:ButtonColumn>
<asp:BoundColumn DataField="NumberOfOccurences" HeaderText="Relevance">
</asp:BoundColumn>
</Columns>
<HeaderStyle BackColor="#6B696B" Font-Bold="True" ForeColor="White" />
</asp:DataGrid>
May i know how to get the value of the button column been click?
I want to autosize the last column so it spans to the full width of the datagrid. I've messed about with the width and autosize but can't seem to get it right.
**figured it out with dataGrid_customer.Columns[4].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
[Code]....
Summing a column in a datagrid
I have a datagrid with columns programatically populated. I need access to the columns to modify the sort expression prior to render, but the column count is 0 at every stage I try to access them. Break points are hit, but each check of the count = 0.Have tried the following, accessing in various stages of the page / control life cycle, but in all instances, the column count is 0.
protected void Page_PreRenderComplete( object sender, EventArgs e )
{
if (dgPriceInfo != null)
[code]...
I had a datagrid and I was hiding columns. This was working fine to show just the columns I wanted.
[Code]....
And then I realised I wasn't paging the data so I ticked that on then above code no longer worked. The Count was equalling 1 with the paging ticked on. Why would that be?
I also used the classic formatting and when I sort the columns the classic formatting goes funny, how can reapply the sorting to make it look classic?
Using ASP.NET Web Forms.I am databinding a DataView to a DataGrid with AutoGenerateColumns set to trueThe final column of the DataView is not rendering.Using the debugger I can see that the column definitely exists in the data grid's datasource. The column is of type decimal and some of the rows in the column have data in them.The column has a column name.The other columns are rendering fine.What's going on?Some more infoFunnily enough, I can set AutoGenerateColumns to false, then just add the columns manually:
datagrid.Columns.Clear();
foreach(DataColumn column in dataView.Table.Columns)
{
datagrid.Columns.Add(new BoundColumn {
HeaderText = column.ColumnName });
}
datagrid.DataSource = dataView;
This works fine. Why can't .NET do this with AutoGenerateColumns?
I have a requirement to display alphabets above each datagrid column names (like shown in excel). The datagrid columns (and header text) are dynamically created at run time and the alphabets on top could grow like excel A, B, C,....Z, AA, AB, AC,.....AZ etc. Any suggestions on how to get the alphabets showing for each columns?
View 1 RepliesIs there a way to make a hyperlink column in datagrid on the fly... I have a search page and would like the user to be able to click a button to few full contents about the item for editing, etc.
View 11 RepliesHere is my code which insert listbox items table and create record.
protected void Button1_Click(object sender, EventArgs e)
{
ListItem li = new ListItem();
System.Data.OleDb.OleDbConnection conn = new System.Data.OleDb.OleDbConnection();
conn.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;" + @"Data source= C:Ruchitaweb" + @"WebSite527afcergonomic.mdb";
conn.Open();
for (int i = 0; i < ListBox1.Items.Count; i++)
{
li.Text = ListBox1.Items[i].Text;
}
OleDbCommand cmd = new OleDbCommand("insert into record(recorditem) values('" + li.Text + "')", conn);
cmd.ExecuteNonQuery();
conn.Close();
}
this is inserting in diffrent rows but i want this in one row with (,)so i can parse it and get it back which items user selected. and i also want to show messge box that show the record number.
I want to copy data from a table[tblExcel][No.of columns:2] to another table[ev_event] which has 5 columns, 2 columns from the another table, 3 columns from user defined value
[code].....