finding distinct rows

ADO.NET implements three basic forms to locate Rows - The Find method as applied to the Rows collection, the Find method as applied to the DataView object and the Contains method as applied to the Rows collection.

DataRowCollection Find and Contains Method

The DataRowCollection is a major component of the DataTable. While the DataColumnCollection defines the schema of the table, the DataRowCollection contains the actual data for the table, where each DataRow in the DataRowCollection represents a single row.

You can call the Add and Remove methods to insert and delete DataRow objects from the DataRowCollection. You can also call the Find method to search for DataRow objects that contain specific values in primary key columns, and the Contains method to search character-based data for single words or phrases.

DataView Find and FindRows Method

Using the Find and FindRows methods of the DataView, you can search for rows according to their sort key values. The case-sensitivity of search values in the Find and FindRows methods is determined by the CaseSensitive property of the underlying DataTable. Search values must match existing sort key values in their entirety in order to return a result.

Hi all,   i have a table SBTRAN i have to select distinct rows of that table in which it should elminate the duplicate rows depending on the accno that is ACCNO should be unique my table has the collumns that look like below SB_TYPE   ACCNO  NAME   ACC_TYPE   GENDER   ADDRESS   PINCODE   i should get the distinct rows in which ACCNO should not have duplicate valuesother collumns can have duplicate values. please help me out thanks in advance   Regards Sunil Yoganna  

Hi

There are many duplicate rows on the Table. where I need to pick the Distinct Values.

 

Ref	Adur	Achg	Bdur	Bchg	TotChg	StartBal	EndBal
Adding Dynamic Rows in ASP.NET GridView Control with TextBoxes and with Delete functionality    In my previous examples, I have demonstrated on how to add dynamic rows in GridView control with TextBoxes and how to save the values into the database. Now, seems that most of the developers are asking if how to add a delete functionality with it. So in this example, I'm going to show on how to delete a certain row in the dynamic GridView with TextBoxes. jQuery: Highlight Gridview Rows with Checkbox    Im learning and experimenting with jQuery and ASP.NET. Below is a simple solution I created to highlight rows in a gridview by clicking on a checkbox next to the row. Gridview setup: Highlighting Rows with TextBox OnFocus    In another article I explained that how you can make the rows of the GridView control clickable and highlight them when they are clicked. In this article I will explain that how you can highlight the GridView rows when you focus on the TextBox which is contained inside the GridView control. jQuery: Highlight Gridview Rows with Checkbox    Im learning and experimenting with jQuery and ASP.NET. Below is a simple solution I created to highlight rows in a gridview by clicking on a checkbox next to the row. jQuery: Styling DropDownList Alternating Items (Rows)    In the following example, I will show how you can style any asp:dropdownlist very easily. The example demonstrates how you can change alternating row items background color, using the fadeTo() to add a nice touch in the dropdownlist. You can change alt rows with a couple lines. MS SQL Server: Search All Tables, Columns & Rows For Data or Keyword Query    If you need to search your entire database for specific data, this query will come in handy. So when a client needs a custom report or some sort of custom development using Great Plains, most of the time I will have to track down the data in the system by running this query and find the table(s) it is in. How to format and update GridView and DataGrid rows using JQuery    The behavior described in this question is as expected. When you set text of a cell in grid, it directly affects HTML that is going to be rendered. When you set text value of a cell, it means that you are setting innerText of the cell. The column that GridView creates for command fields (Edit, Delete and Select) are a (anchor) or button elements. So you can see what will happen if you set text value in that cell. It will wipe out those link or button controls and replace them with simple text string. Using jQuery to Filter Table Rows    The project is using the .net GridView control, so I had limited control over the output HTML code. Still, I think this code can work for most tables. One thing to notice: you should use the class "filterable" on your table or on one of its parents for the code to work. First, we need a text box: Insert Rows with a GridView    In ASP.NET version 1.x, I used the footer on the DataGrid control to insert new rows by placing a series of TextBox, DropDownLists, CheckBoxes etc. controls on it and then handling a save button. This also works with the GridView in version 2.0 but with one major exception: if your data source is empty, the GridView will hide your footer (and header) and only display the EmptyDataText. Problem to group radio button across gridview rows    In general no one can easily group or make a single selection from radio button list inside gridview rows. There are a lot of way to make a single or unique selection from list. Here i want to share how i can address this problem in the most easiest way. Googling the problem most of the cases i saw the grouping in horizontal way. Thats why i tried to group the radio buttons in vertical manner. Let i have a requirement like below: RadioButton Groups, Table Rows And NamingContainers in asp.net    The RadioButtonList. Very handy for inviting users to select just one item from a list although because of the screen real estate it takes up, used less and less in favour of the DropDownList. In plain HTML, the browser knows to enforce the unique selected value amongst a list of radio buttons because they all have the same value for their name attributes. RadioButton Groups, Table Rows And NamingContainers    (In which AJAX-enhanced CheckBoxes become more useful than RadioButtons but inheritance saves the day, and a simple RadioButton-derived control establishes the purpose of a control's naming container) The RadioButtonList. Very handy for inviting users to select just one item from a list although because of the screen real estate it takes up, used less and less in favour of the DropDownList. In plain HTML, the browser knows to enforce the unique selected value amongst a list of radio buttons because they all have the same value for their name attributes. Adding Rows in GridView without using a Database    This article describes on how to add rows in GridView without using a database. Basically the GridView will be populated with data based on the values entered in the TextBox on Button Click and retain the GridView data on post back.
Categories:
ASP.Net Windows Application   .NET Framework   C#   VB.Net   ADO.Net   Sql Server   SharePoint   Silverlight   Others   All