can tel me easy and fastest method for fetch data value from database to gridview using asp.net with c#

This is the simpleast and easiest way to get the data from DB to dgv:

private void Form1_Load(object sender, System.EventArgs e)
    // Bind the DataGridView to the BindingSource
    // and load the data from the database.
    dataGridView1.DataSource = bindingSource1;
    GetData("select * from Customers");

private void GetData(string selectCommand)
        // Specify a connection string. Replace the given value with a 
        // valid connection string for a Northwind SQL Server sample
        // database accessible to your system.
        String connectionString =
            "Integrated Security=SSPI;Persist Security Info=False;" +
            "Initial Catalog=Northwind;Data Source=localhost";

        // Create a new data adapter based on the specified query.
        dataAdapter = new SqlDataAdapter(selectCommand, connectionString);

        // Create a command builder to generate SQL update, insert, and
        // delete commands based on selectCommand. These are used to
        // update the database.
        SqlCommandBuilder commandBuilder = new SqlCommandBuilder(dataAdapter);

        // Populate a new data table and bind it to the BindingSource.
        DataTable table = new DataTable();
        table.Locale = System.Globalization.CultureInfo.InvariantCulture;
        bindingSource1.DataSource = table;

        // Resize the DataGridView columns to fit the newly loaded content.
    catch (SqlException)
        MessageBox.Show("To run this example, replace the value of the " +
            "connectionString variable with a connection string that is " +
            "valid for your system.");

Some additional info you can find here: http://www.switchonthecode.com/tutorials/csharp-tutorial-binding-a-datagridview-to-a-database
REMEMBER: nothing will be gifted to you, all you will have to learn by your self. So, please be good, and do some teaching. Google knows many, many things as well.
And good Luck,


This article has been dead for over six months. Start a new discussion instead.