How to dynamically create columns in a datagridview and assign titles to it and its rows?

Question

3.00/5 (1 vote)

See more:

hi there
I want to generate reports of student attendance according to date that user selects.suppose user selects date 1/1/2012 to 10/1/2012 then 1 datagridview should be get generated dynamically. Plz help me.

Posted 26-Jan-12 20:58pm

SantoshRohinSantosh

Add a Solution

Comments

Sergey Alexandrovich Kryukov 27-Jan-12 3:01am

What have you tried so far? What's the problem?
--SA

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2012-01-26T21:33:00

Solution 1

Filter the data as part of your SELECT statement:

SQL

SELECT * FROM myTable WHERE dateColumn BETWEEN '2011-1-1' AND '2011-1-10'

Then use that as part of your DataAdapter, and use the Fill method to prepare a DataSet or DataTable.
You can then use that as the DataSource property of your DataGridView, and it will sort it all out for you.

Posted 26-Jan-12 21:33pm

OriginalGriff

Comments

SantoshRohinSantosh 27-Jan-12 3:48am

Will you please elaborate.

OriginalGriff 27-Jan-12 3:50am

Which bit?

SantoshRohinSantosh 27-Jan-12 3:56am

You just tell me GRIFF how i'l give title to the datagridview?

OriginalGriff 27-Jan-12 4:04am

If you fill a DataGridView from a DataAdapter, then whatever column titles you return from your database will be set as the Table Column titles:
SELECT Id, username AS [User Name] From MyTable
Will give you two columns, with the titles "Id" and "User Name"

IkhwanKrisnadi · Answer 2 · 2012-01-26T22:02:00

Assume that your results from database is put on list, and each row of results is put on Student class.

C#

IList<student> listStudent</student>

Assume that Student class is below:

C#

public class Student {
  public string StudentID {set; get;}
  public string StudentName {set; get;}
}

In aspx file, put tag gridview, see the below for example:

ASP

<asp:gridview runat="server" id="gvStudent" autogeneratecolumns="False" xmlns:asp="#unknown">
  AllowPaging="True" AllowSorting="False" EmptyDataText="No Data Found"
  HorizontalAlign="Center" Width="100%" DataKeyNames="StudentID " PageSize="20">

  <emptydatarowstyle horizontalalign="Center" verticalalign="Middle" width="100%" />
  <columns>
    <asp:templatefield headertext="No.">
      <headerstyle width="5%"></headerstyle>
      <itemtemplate>
        <asp:label id="Label2" runat="server" name="No" text="<%# (gvStudent.PageIndex * gvStudent.PageSize) + gvStudent.Rows.Count + 1 %>">
        </asp:label>
      </itemtemplate>
      <itemstyle horizontalalign="Center" />
    </asp:templatefield>
    <asp:boundfield headertext="Student ID" datafield="StudentID" />
    <asp:boundfield headertext="Student Name" datafield="StudentName" />
  </columns>
</asp:gridview>

And in code behind, see the below for the example:

C#

private void BindGridView()
{
  //Retrieve student from database, and put on list
  IList<student> listStudent = ......

  //Bind Result to GridView
  this.gvStudent.DataSource = listStudent;
  this.gvStudent.DataBind();
}
</student>

And call method BindGrindView on button click

Or you can see from other tutorial about gridview in codeproject http://www.codeproject.com/Articles/14249/How-to-populate-DataGridView-GridView-with-SQL-sta[^]