I have a column in my GridView which pulls in an individual's name. Unfortunately, the name is contained in one column in the database - both first and last. I'd like to sort on the last name, not the first...is there a way for me to tell the GridView to sort based on a substring? [code]...
View 1 RepliesI want to sort the binding source column (Product Code) which formatted like (AA-AAA AAA AAAA)
but i do not want straight sort on product code column, i want the sort as :
substring of 1,2 + 8,3 + 3,3 and then the rest of the column.
I know i can do it in the table direct using the OrderBy and the substring function, but the problem is that sort is not static it is dynamic according to different status means it change the substring order.
xxxx,2222,3333,44444,5555555ab,6666666,500000,500000,Haaaa
How to substring it step by step load to gridview?
I am binding a data set to a GridView in VB .net. I have some custom sorting setup, and want to display an icon next to the header if one of my 3 options is selected.
I've read a lot of methods in doing this, and I see Gridviews even have a ASC and DESC header style I can associate with the view. I have 2 problems with this, though:I am sorting a List with linq on Sort Trigger, then binding it to the datagrid.
The reason I do it this way, is I want to maintain multiple sort levels, ordering by 3 columns rather than 1.
Edit for clarity Specifically what I want to do is loop through the value of a GridView's Header text, see if it matches what I have saved in viewstate, and if so add an image for that header in particular. Something essentially like below, however headerRow.Cells(y).Text is always returning "", even when the header has text:
Sub gvPatronData_RowCreated(ByVal sender As Object, ByVal e As GridViewRowEventArgs)
Dim savedSortDirection(), savedSortColumn() As String
Dim headerRow As GridViewRow = gvPatronData.HeaderRow
[code]....
I have coded my program so that when a user clicks on a column, the data is sorted in ascending/descending order.When I go to click on a column header, however, nothing actually happens.I dont get an error or anything.Here is the code that I am using to sort the records in the GridView:
Property GridViewSortDirection() As SortDirection
Get
If IsNothing(ViewState.Item("GridViewSortDirection")) Then
Return SortDirection.Descending
[code]....
I am currently trying to sort on a GridView after it has been populated with records from a SQL Server Express database. I click on a column to sort it and I get the following error: "DataTable must be set prior to using DataView." The entirety of my code is as follows: <script runat="server" >
[Code]...
I have a LINQ Query:
[Code]...
This works great and sorts on L_Name. But I am trying to allow the user to sort the gridview themselves so I am passing in the SortExpression as a string. But I don't know how to incorperate the SortExpression into the LINQ Query. I tried Order By c. & SortExpression but that did not work.
I got a gridview which auto generates columns. One of the columns is a date field.Somehow, i cant sort the date field. It's being interpreted as a string.The data comes out a database. The datatype there is set on datetime.his is the code in the aspx file:
<asp:BoundField DataField="date" HeaderText="date" SortExpression="date" DataFormatString="{0:dd/MM/yyyy}" HtmlEncode="false"/>
[code].....
i have a GridView bound to a DataView. Some columns in the DataView's table are foreignkeys to related tables(f.e. Customer). I want to enable sorting for these columns too, but all i can do is sorting the foreignkey(fiCustomer) and not the CustomerName.
I have tried this without success(" Cannot find column ERP_Customer.CustomerName "):
<asp:TemplateField HeaderText="Customer" SortExpression="ERP_Customer.CustomerName" >
A tried also the DataViewManager, but i've a problem to detect the table to sort:
Dim daCharge As New ERPModel.dsERPTableAdapters.ERP_ChargeTableAdapter
daCharge.Fill(dsERP.ERP_Charge)
Dim viewManager As New DataViewManager(Me.dsERP)
[Code].....
I am trying to program my page in vb.net and asp.net so that when a user clicks on a column heading of a gridview, the data is sorted either in ascending or descending order. note that my data is coming from an SQL Server Express database. So far, I have done it so that the gridview can be sorted:
[Code]...
I'm trying to sort records in the gridview right after a radio button is selected. My approach is with the dataview, but because the dataset variable doesn't survive a round trip to the server, I don't know how to make this happen.[code]
View 1 RepliesI have a gridview in asp.net/vb and it is bound to a list - so there's no standard sorting available. I've found this jQuery plugin for sorting tables: [URL]. The plugin requires <thead> and <tbody>. The problem is, that my gridview only renders the <tbody>.
I've already tried
DataList.UseAccessibleHeader = True
DataList.HeaderRow.TableSection = TableRowSection.TableHeader
But this changes nothing.
My gridview markup:
<asp:GridView runat="server" CssClass="grid" ID="DataList" AutoGenerateColumns="False" AllowSorting="True" ClientIDMode ="Static">
<Columns>
<asp:BoundField HeaderText="SomeHeaderText" DataField="SomeDataField" />
<asp:BoundField HeaderText="SomeHeaderText" DataField="SomeDataField" DataFormatString="{0:dd.MM.yyyy}" />
[Code] .....
I have total column in gridview in which data should like
302(33)
790(126)
936(69)
1649(132)
718(71)
973(101)
1535(165)
0(32)
When I sort this column I got result like :
973(101)
936(69)
790(126)
718(71)
302(33)
1649(132)
1553(159)
0(32)
I need output like this :
1649(132)
1553(159)
973(101)
936(69)
790(126)
718(71)
302(33)
0(32)
I'm trying to create a valid RegEx replacement pattern for correctly formatting specific .XML file names. Specifically, if a file name does not begin with a prefix, let's say, ACE_. If the XML file name and extension does not begin with ACE_, prepend the string ACE_ to the file name.For example, if my input source string is the following:
Widgets.xml
I would like to execute a single RegEx Replacement that would result in the string being:
ACE_Widgets.xml.
Conversely, if the string already begins with ACE_, I would like it to remain unchanged. Also,how can I include the pattern ".xml" to ensure that the string pattern for the file name and extension ends with ".xml" in the same matching pattern for the RegEx Replacement pattern? As for the match, I have some luck with the following:
^ACE_{1}[dD]+
Which indicates there is a match for the pattern if the input string is ACE_Widgets.xml and no match if the string is Widgets.xml
The RegEx pattern would suffice, but if you need to know the language in which I'd like to use the replacement pattern is in .NET 4.0 in either C# or VB.NET.
The following posting is close to what Im looking for, but with the inclusion of the *ix directory path prefix, and the use of preg_replace() in PHP, I'm having a bit of a struggle getting it to work with what I need to do:
Regular Expression: How to replace a string that does NOT start with something?
How will I select a substring with 2 criteria? I have a Richtextbox where I select a number after a : with this code; For Each line As String In Richtextbox1.Lines Dim equalsPos As Integer = line.IndexOf(":") + 1 txtFound.AppendText(line.Substring(equalsPos, line.Length - equalsPos)) Next This is working ok, but the whole line.length is appended for number2. The line ex. Some text:my number some text-my number2. I want my number appended to txtFound, and my number2 appended to txtFound2. With my code only number2 can be appended correct.
View 4 RepliesI have a filtered gridview in an updatepanel.I want to allow to sort filtered data.How can this be done?When I click to sort a column it reloads the entire gridview.
View 1 RepliesI want display database value in datagridview 2 coloum ..how to may i bind the dataexmp:- Suppose in Database 100Dr,200Cr i want in datagrdview 1st coloum 100Dr & Second coloum 200Cr............
View 7 RepliesI have a page which lists all the files in a particular folder (all PDFs), using a data-table and gridview. I'm currently sorting this table by the filename (by using a dataview), which isn't that helpful, and I want the gridview of files sorted by the file created or file modified date (as recorded in Windows). If that's not possible, a second option would be to extract the date from the file name string (no problem doing that), and sort the dataview/datatable or gridview based on that.
[Code]...
How can I improve this bit below to make the items in the TreeView to sort faster or something totally different to sort them easier?
[Code]...
I am trying to remove VB6 type code and use VB.Net code, in particular, remove "Left" and use "Substring". This code does not do what the old style code does. It seams to ignore the first two chars and forces the msgbox prompt no matter what I type in the textbox (at "Leave").
Private Sub TextBox5_Leave(ByVal sender As Object, ByVal e As System.EventArgs) Handles TextBox5.Leave
If TextBox5.Text = "" Then
'Do nothing
[CODE]...
I have a MyObject; myObjects as List(Of MyObject) and a delegate Comparison(Of MyObject) that uses a lot of comparison functions (ByA, ByB, ByC etc) Ã la:
Shared Function CompareMyObjectsByName(x As MyObject, y As MyObject) As Integer
Return x.Name.CompareTo(y.Name)
End Function
[Code].....
Sub Sort()
ReDim RollsCC(NumOfPlayers - 1)
For N As Integer = 0 To (NumOfPlayers - 1)[code]....
Here I am creating a temp single dimensional array, merging my 2d array into it, and then attempting to sort it by Rolls(N,1), which is a integer 1-6, Everything seems to be working right with the exception of this.
RollsCC.Sort(RollsCC, 0, 1)
How would one specify a numeral sort based on the first character in the string? im aware that I am switching Rolls(n,1) and Rolls(n,0) information during the sort.
Currently my ListView sorts items by image.index. So 0 is at the top, then 1, 2 and so on. Think of it as an IRC chat room nick list. Ops at top then the rest are sorted alphabetically
[Code]....
How to show pop up menu from database in gridview on each gridview row items ?Example of this is : http:[url].....Move your cursor to Departure time and arrival time...a want this type of popup in gridview items....which fetch entries from database..
View 2 RepliesIn my application,i have a gridview in which columns are created at runtime.Actually these columns are created when i am entering data in a database table.[code]where Column1,Column2,column3 may vary during runtime.i need to enter values to these columns during runtime.But i cant bind these columns because these are created during runtime.The first column "Description" will not change.It will remain constant.For each description, there will be values for each column.At last these data will be saved to the database.How to add columns in the gridview during runtime?
View 2 RepliesI'm getting an ArgumentOutOfRange error when using substring function in .NET. I'm new to .NET so probably doing something wrong. I have a txtField, which is a text field component in GUI. I'm using Microsoft Visual Basic 2010 Express
txtField.Substring(txtField.Length-4,txtField.Length-1)
If txt.Field contains only numberic values it works ok, but as soon as the text field contains characters it breaks.
I have a piece of code that I am using a for next statement and stepping through a string a little bit at a time. The problem is I get an error towards the end of my loop because my substring goes beyond the bounds of my string.
Dim Right As Integer = StartNumber.Value
Dim left As Integer = LengthNumber.Value
Dim i As Integer = 0
[code]....
Also my streamwriter is not writing to my file?
I have a string that contains a file location[code]..."
I want to get a substring of String 1 that does not contain the name of the actual file (e.g. "C:SomeDirectoryEntries")
Which one would you prefer to extract a sub-string from the given string and why?I am thinking that since Left and Right are VB functions and not .NET functions, they may cause problems in the future in terms of compatibility.
View 3 RepliesThis question was resolved in C#, and I don't know how to do it in VB net. I want to search through a directory of files and see if my string is contained within any of the filenames. Then I just need a bolean answer if it exists or not. I know how to use the file.exists...this is not what I need. The link below is to the C# response. How to check if filename contains substring in C#
[Code]...