forum

home / developersection / forums / datagridview sorting and filtering c#.

Ask Question

DataGridView Sorting and Filtering C#.

Anonymous User 5191 15-Jun-2013
Hi developers,

How to set Sorting and Filtering in datagridview using C#.
c# c# 
Updated on 15-Jun-2013
Anonymous User

Other

I am a content writter !

Follow
Can you answer this question?
Answer

1 Answers

Sumit Kesarwani

Sumit Kesarwani

15-Jun-2013
Hi Samuel,

You can use this code:

using System;
using System.Data;
using System.Windows.Forms;
using System.Data.SqlClient;
 
namespace WindowsApplication1
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }
 
        private void button1_Click(object sender, EventArgs e)
        {
            string connectionString = "Data Source=.;Initial Catalog=pubs;Integrated Security=True";
            string sql = "SELECT * FROM Titles";
            SqlConnection connection = new SqlConnection(connectionString);
            SqlDataAdapter dataadapter = new SqlDataAdapter(sql, connection);
            DataSet ds = new DataSet();
            connection.Open();
            dataadapter.Fill(ds, "Titles_table");
            connection.Close();
 
            DataView dv;
            dv = new DataView(ds.Tables[0], "Price > 19", "Price Desc", DataViewRowState.CurrentRows);
            dataGridView1.DataSource = dv;
        }
    }
}
MindStick Training
MindStick Training

Liked By

We use cookies to ensure you have the best browsing experience on our website. By using our site, you acknowledge that you have read and understood our Cookie Policy & Privacy Policy