how to fill datagridview with table column names

Question

User920022889 posted

i want to fill datagridview with table column names. i created student table in database. i want to fill student table column names  in data grid view. please help me.

here i have one condition. datagirdview contain only one column(rows are no of table column names) in that column i want to fill tables column names. howw to done

Answer 1

User-1965857832 posted

See if this helps

protected void Page_Load(Object sender, EventArgs e)
{
    if (!IsPostBack)
    {

        // Declare the query string.
        String queryString ="Select [Column1], [Column2], etc From [Student]";

        // Run the query and bind the resulting DataSet
        // to the GridView control.
        DataSet ds = GetData(queryString);
        if (ds.Tables.Count > 0)
        {
            UrGridView.DataSource = ds;
            UrGridView.DataBind();
        }
    }

}

private DataSet GetData(String queryString)
{
    // Retrieve the connection string if its stored in the Web.config file
    String connectionString = ConfigurationManager.ConnectionStrings["UrConnectionString"].ConnectionString;
    //else set it manually as below
    //String connectionString = @"Data Source=myServerAddress;Initial Catalog=myDataBase;Integrated Security=SSPI;User ID=myDomain\myUsername;Password=myPassword;";

    DataSet ds = new DataSet();

    try
    {
        // Connect to the database and run the query.
        SqlConnection connection = new SqlConnection(connectionString);
        SqlDataAdapter adapter = new SqlDataAdapter(queryString, connection);

        // Fill the DataSet.
        adapter.Fill(ds);

    }
    catch (Exception ex)
    {
        // The connection failed. Display an error message.
    }

    return ds;
}

Answer 2

User920022889 posted

i have to done in windows form. iam using data grid view

Answer 3

User920022889 posted

thanks..

i done this.

first i want retrived data from database,stored in datatable.

after that i created datatable dynamically then after i filled second data table rows with first data table column names, after  i bind second datatable to datagridview.