binding data from database to two column of gridview programmatically in asp.net

Question

Please help me out, I am new to asp.net. my gridview have 5 columns and I want to bind two columns of this gridview to select data from database while user enter data through the other columns of the gridview in order to save the gridview data to another table. But I have problem with binding data to 2 columns out of 5 columns of the gridview. How can I achieve this. Here is my code

string classid = query.Class + query.Class_division;
var q = (from cl in db.StudentTbs where        cl.Admission_class == classid select new {
id=cl.UnquieStudentId, Name= cl.Surname+", "+ cl.FirstName +" "+ cl.OtherName
}).ToList();

DataTable dt = new DataTable();
if(q.Count>0)
{
    DataRow row = null;
    dt.Columns.Add("Series No");
    dt.Columns.Add("name");
    foreach( var row2 in q)
    {
        row = dt.NewRow();
        dt.Rows.Add(row2.id);
        dt.Rows.Add(row2.Name);
    }
     GridView1.DataSourceID = null;
    GridView1.DataSource = dt;
    GridView1.DataBind();
}

Image code

Pls dont include text images.

AndreyS Scherbakov
– AndreyS Scherbakov

2018-03-19 00:44:27 +00:00
Commented Mar 19, 2018 at 0:44 — AndreyS Scherbakov
– AndreyS Scherbakov, Commented Mar 19, 2018 at 0:44

ElasticCode · Accepted Answer · 2018-03-19 06:36:59Z

1

Format your GridView1 in your as below

<asp:GridView ID="GridView1"runat="server" AutoGenerateColumns="false">
<columns>
<asp:BoundField HeaderText="Series No" DataField="Series No" />
<asp:BoundField HeaderText="Name" DataField="name" />
</columns>
</asp:GridView>

answered Mar 19, 2018 at 6:36

ElasticCode

7,9252 gold badges38 silver badges49 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

binding data from database to two column of gridview programmatically in asp.net

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related