Forms Data Controls :: Sorting In Dataview?

Aug 10, 2010

I want to sort the string which is in the format given below15% Test;15% Sear;40% Santhosh;30% Jeeson;
The output that I am expecting is

40% Santhosh;30% Jeeson;15% Sear;15% Test;

I wrote the following code but it does not work .

string str = "15% Test;15% Sear;40% Santhosh;30% Jeeson;";
Console.WriteLine(str);
DataTable dt = new DataTable("SortBenchMark");
DataRow dr;
dt.Columns.Add("Weightings", typeof(int));
dt.Columns.Add("BenchMark", typeof(string));
string weightings = string.Empty;
string BenchMarkName = string.Empty;
foreach (object o in str.Split(';'))
{
if(o.ToString().Length > 0)
{
dr = dt.NewRow();
dr["Weightings"] = Convert.ToInt32((o.ToString().Split('%'))[0].ToString().Trim());
dr["BenchMark"] = (o.ToString().Split('%'))[1].ToString().Trim();
dt.Rows.Add(dr);
}
}
dt.AcceptChanges();
DataView dataview = new DataView(dt);
dataview.Sort = "Weightings DESC,BenchMark Asc";
string final = string.Empty;
foreach (DataRow drow in dataview.Table.Rows)
{
final += drow["Weightings"].ToString().Trim() + "% " + drow["BenchMark"].ToString().Trim() + ";";
}
Console.WriteLine(final);
Console.ReadLine();

View 2 Replies


Similar Messages:

DataSource Controls :: Sorting And Selecting From A DataView Or DataTable?

Apr 23, 2010

I am trying to do something I thought would be simple but something isn't working for me.

I have a DataTable that I need to sort by a price ascending, then select an 'nth' row value. The 'nth' value is the row count/10.

[Code]....

What happens is I get the "nth" value from the original tblDeals.

View 1 Replies

ADO.NET :: Sorting AlphaNumeric Column In DataView?

Oct 28, 2010

I have a sorting issue with DataView.

View 2 Replies

VS 2008 - Sorting Date Column In DataView

Jul 12, 2011

I've got a datagrid which i wanted to sort, since i dnt have much knowledge of .Net, so what i did was to save that datagrid in a DataTable, then again save the same DataTable in a DataView, then apply sorting on that DataView. this is the code, and its working fine.

Code:
protected void dgEOBSearchResults_SortCommand(object source, DataGridSortCommandEventArgs e)
{
DataTable dtEOBDocumentListTable = (DataTable)Session["sEOBDataTable"];
if (ViewState["sortExpression"] == null)

[code]...

but the issue comes when the i try to sort the Date Column, the dates are in MM/DD/YYYY format, so if i try to sort the date column, the dates are sorted on month basis, rather than year basis. now i cant change the date format, is there any way to sort dates in DataView?

View 10 Replies

Forms Data Controls :: Getting The Custom Sorting And Paging With Images To Indicate The Sorting Direction In Gridview

Jul 18, 2010

Moderators Note: THIS ISSUE IS BIG FOR ME AND EVEN IF POSSIBLE, GET THE REPLY FROM THE DESIGNER OF GRIDVIEW. I have been looking for him for long. I am really fed up with reviewing a good lot of web pages on how we can possibly customize the gridview to enable sorting and paging. So many sites have listed out a lot of information and so many guidances. But the problem is that one works out fine and the other is a burden. I really feel bad about being given the job of customizing this kind of a gridview which has no user friendly approach to it. Also, this control is rendered without the pager links inside the <tfoot> tag. I have tried the Pear Pager in php. It is that good and easy to use and compared to that, the gridview in asp.net is the worst ever control i have ever tried so far.

1. i can use the images to indicate the sorting direction
2. I can have the custom pager like

[code]

<<Previous 1 2 3 .. 7 Next >>.

[/code]

When i click the next when i am viewing the page at 3 , the pager links should change as

[code]

<<Previous 2 3 4 .. 7 Next >>

[/code]

Kindly look into this type of requirement and firstly tell me whether this is possible with the gridview control. I would like this request even to be escalated to the designers of the gridview control also, so that Microsoft comes out with a reply THAT WORKS and not the kind of stuff like surfing through a lot of links and pages and finally wasting a lot of days precious time and still breaking the head with this useless control. I have spent a lot of time in searching for a perfect way. Not writing a code that is non-standard. I am really serious b'cos I have spent weeks in customizing this control. If I dont get a solid reply atleast now, I am going to generate all the output by HTML content by custom coding.

View 7 Replies

Forms Data Controls :: Can A Dataview Be Declared As Public

Mar 29, 2010

Can a dataview be declared as public?

Dim dvEditTreatmentType As DataView = New DataView(dsTreatmentEndDate.Tables(0), "IsNull(DialysisEndDate, '') = ''", "", DataViewRowState.CurrentRows)

can this be declared as public Dataview? is there a way to do it?

View 2 Replies

Forms Data Controls :: What Is The Difference Between Dataview And Datarowview

Mar 15, 2010

What is the difference between dataview and datarowview?

What is the use of datarowview?

View 2 Replies

Forms Data Controls :: Specify Which Columns Are In A DataView From A DataTable?

Mar 24, 2010

HOW TO specify which columns are in a DataView from a DataTable. I want to create a DataView, that only has the columns from a DataTable that I choose, and in the order I want.

Example:
// DataTable_MyTable ~~ Column #0 is for ID. I do not want my view to get this column.
// DataTable_MyTable ~~ Column #1 is for TYPE. I want this column to come in 2nd place in my view.
// DataTable_MyTable ~~ Column #2 is for NAME. I want this column to com in 1st place in my view.

DataView DataView_MyView = new DataView(DataTable_MyTable ~~ some how only get the columns I want, and in the order I want ~~);

// DataView_MyView now has only 2 columns.
// DataView_MyView ~~ Column #0 is NAME.
// DataView_MyView ~~ Column #1 is TYPE.

View 4 Replies

Forms Data Controls :: Exclude A Row From Dataview Sort?

Mar 5, 2010

I have a datatable which contains the summery row as well. I just assign the datasource property of a gridview and call databind method to fill and display the records.

Now, when I applied sorting through dataview to the gridview, the sorting happens along with the summery row, which is a normal behavior. As a result the "Total" - column took place inside the data some times. I want to prevent this.

The best way out for that can be done by creating the summery row at grid view row databound. But unfortunately I could not change the datatable as per this requirement.

Can the dataview sorting exclude the last row of the datatable through any process?..

View 3 Replies

Forms Data Controls :: Determining A Row And Column In A Dataview?

Aug 9, 2010

I know how to do this in a datatable but I would just like to learn how to do it in a dataview.

I have a dataview which is used to populate a gridview. It has the following column

userid Location
123 New York
124 Chicago
125 London

Now, I would like to know how to determine the 124 row and highlight it to a blue in a dataview used to populate a gridview. kindly note, i can do this in a datatable but not a dataview. I would like to learn how to do it in a dataview.

View 6 Replies

Forms Data Controls :: How To Convert DataView To DataSet

Jul 27, 2010

converting a DataView to a DataSet?

I have a DataSet 'programs'. I want to sort if before passing it to a user control where it will be rendered.

I created the DataView and sorted it successfully like so:

[Code]....

The line of code to pass my old (unsorted) dataset to the UC is like this:

[Code]....

What is the syntax for passing the dvPrograms to the UC in a similar manner?

View 16 Replies

Forms Data Controls :: Dataview Control Not Appearing?

Jan 10, 2010

I have the following code in place:

[Code]....

and the following stored procedure:

[Code]....

The Dataview control is not appearing when the page is loaded. Has anyone any ideas ?

View 3 Replies

Forms Data Controls :: Convert DataView Line From VB To C#?

Jan 12, 2010

I have tried the online converters, and none of them that I have tried will accurately convert this. It still tries to add a .Item property to the dataview and that does not exist in c#. I know this is simple...

dv.Item(e.Item.ItemIndex).Row.Item(1)

View 3 Replies

Forms Data Controls :: Export To Excel Using Dataview?

Dec 1, 2010

I'm trying to export a filtered dataview to excel. The code to export works just fine but it exports all the records, not just the ones I filtered on. For example, I have three dropdowns and the dataview seems to work just fine filtering on the dropdown parameters because it shows up correctly in my datagrid on my screen.

This line of code is where I am confused.

[Code]....

View 2 Replies

Forms Data Controls :: Populate FormView From A DataView?

Feb 23, 2010

Im trying to populate my formview from a dataview in the codebehind and the order in which things are happening is causing it to fail.my formview itemtemplate is setup with some eval("fields") which is initially not populated (nothing bound to it) and the page loads ok. i think click on my graph which generates a query and populates a dataview.i then assign that dataview to the formview and run the bind.what happens when i actually run the app is that it says no data is bound to it.i set the debugged to stop at the point where my DV is assigned to my FV and the FV shows a data item count of 1 (as expected) if i keep stepping it puts me in to the eval statements on the aspx page says the data isnt bound.
the error i get is

Databinding methods such as Eval(), XPath(), and Bind() can only be used in the context of a databound control.

[Code]....

View 2 Replies

Forms Data Controls :: Changing The Date Format In A Dataview?

Oct 27, 2010

I am using a dataview to read a certain record from a database and then adding these values to different elements on a form (label, textbox) ..

One of the fields is a date/time and i only want to display the date without the time..

code:

{on page load}
Dim dv As System.Data.DataView = CType(DEDS.Select(DataSourceSelectArguments.Empty), System.Data.DataView)
lbl_startdate.Text = dv.Table.Rows(0).Item("'<%# Eval("evt_startdate","{0:d}")%>'").ToString()
' DEDS is my SqlDatasource ..
'evt_startdate is the date field coming from the DEDS datasource

.. It's not working .. I'm not sure how i should alter the date format ..

View 5 Replies

Forms Data Controls :: Editing Populated Textbox From A Dataview?

Sep 28, 2010

I have a dataview running a stored procedure that's populating a textbox. I then want to edit (or not) that text and insert it using another query. However, whenever I populate the text box, it will always insert the original text. If i don't populate it, it will insert whatever text I input.

[Code]....

View 2 Replies

Forms Data Controls :: Sort DataView Ascending With Nulls Last?

Aug 16, 2010

how to sort a datatable (dataview) so that the second column is ascending but nulls are last.

I'm trying to do the following Date1 ASC, DATE2 ASC (but if DATE2 is null it is last in this Date1 group)

Note: Date1 can never be null so a Date2 that is null should still be grouped in with its Date1.

View 4 Replies

Forms Data Controls :: Change The Visibility Of A Field In Dataview?

Jul 17, 2010

I have developed my application using Visual Web Developer 2008 express with Visual Basic code.

If I am working with 2 textboxs on a form, and I set the "Autopostback" to "true" for the first texbox then on the "changed" event, I can just add code to set the visibility to "true or "false" for the second textbox - it works fine. However, I do not seem to be able to figure out how to do the same thing when I am using a Dataview.

I have a table called "Customer" that contains 4 fields "CustomerName", "BasePrice", "LevelOfActivity", and "Discount".

My user enters information into this table using a Dataview form that displays the 4 fields.

When the user enters the value "L" in the field "LevelOfActivity", I would like to then set the visibility of the field "Discount" to "false" - (I want to hide the field as this customer should not get a discount). If the user enters the value "H" in the field "LevelOfActivity", I would like to then set the visibility of the field "Discount" to "true" - (I want to show the field so the user can enter the "Discount").

View 6 Replies

Forms Data Controls :: Bind Gridview Using Dataview In The Code Behind?

Jan 26, 2010

How to bind gridview using dataview in the code behind?

View 1 Replies

Forms Data Controls :: Extracting Price From DataView Or From The Database?

May 11, 2010

Currently I am developing an ecommerce web site where

1. I choose the Product from a GridView (by pressing Select)

2. This product gets added to a DataView

The problem arises because I have a quantity textbox and wish to multiply the price by the quantity textbox.

How can I extract the price from the gridview to multiply it ? (and then subsequently display it in a label)

View 7 Replies

Forms Data Controls :: Access Gridview's Sorted Dataview?

Jul 16, 2010

ASP.NET 3.5

I've got a Gridview bound to an objectdatasource. Sorting is enabled in gridview, but objectdatasource isn't doing any sorting. I can pick up the unsorted datatable from the Selected event of the objectdatasource, but I really want the sorted version. Is there any event on the gridview where I can access the sorted dataview it must be using internally?

Why am I asking? We're using paging as well (i.e. truncated data in gridview) and I want to loop through the full sorted dataview to find the primary key value to set selectedindex.

View 4 Replies

Forms Data Controls :: Dataview - How To Use Each Field To Populate Other Controls

Apr 30, 2010

I have a Dataview that has several fields. I want to use each field to populate other controls. How do I access each particular field?

View 2 Replies

Forms Data Controls :: How To Select Rows From Dataview Using Filter In The Index

Mar 9, 2010

I need to retrieve data from DataView/DataTable. I need to retrieve the top4 records, then, 5th - 10th recoed.

This is how I do this, but I am looking for a clean code, doing it correctly:

[Code]....

View 5 Replies

Forms Data Controls :: Can Specify A Fixed Number Of Rows By Index To Add To A Dataview

Feb 20, 2010

I have a table that contains about 8000 records and I need to be able to select any given sequence of 250 subsequent rows by a specific row index of teh table...

how I can go about that easily using a dataview without building a secondary table and just pushing the records I need into it?

View 2 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved