Populate GridView without DataSource [Answered]RSS

• • Reply
  maddtechwf

  Member

  17 Points

  146 Posts

  Populate GridView without DataSource

  Jul 16, 2012 08:37 AM|maddtechwf|LINK

  I want to populate a GridView without using a DataSource.  I want to created a Protected Sub that will take information I have calculated and display it on multiple rows (5 to be specific).  Can this be done easly?

• • Reply
  Keyur Shah

  Member

  507 Points

  267 Posts

  Re: Populate GridView without DataSource

  Jul 16, 2012 08:43 AM|Keyur Shah|LINK

  It means you want to fill grid using through code not directly throug DataSource?? Right?

  Try and Try You will Success..!!
• • Reply
  swaiss

  Member

  163 Points

  195 Posts

  Re: Populate GridView without DataSource

  Jul 16, 2012 08:43 AM|swaiss|LINK

  you can put your results in a DataTable then make the data source your DataTable.

  hope this helps you.

  regards.

• • Reply
  Keyur Shah

  Member

  507 Points

  267 Posts

  Re: Populate GridView without DataSource

  Jul 16, 2012 08:45 AM|Keyur Shah|LINK

  // May be this can help you.

  public void fillGrid()
  
  {
  
  con.Open();
  string sql = "select *from contact";
  cmd = new SqlCommand(sql, con);
  dt = new DataTable();
  da = new SqlDataAdapter(cmd);
  da.Fill(dt);
  grid_contact.DataSource = dt;
  grid_contact.DataBind();
  cmd.Dispose();
  con.Close();
  
  }

  
  
  

  Try and Try You will Success..!!
• • Reply
  EhsanMubeen

  Member

  281 Points

  95 Posts

  Re: Populate GridView without DataSource

  Jul 16, 2012 08:51 AM|EhsanMubeen|LINK

  Module Module1
      Sub Main()
  	' Get a DataTable instance from helper function.
  	Dim table As DataTable = GetTable()
      End Sub
  

   Function GetTable() As DataTable
  	' Create new DataTable instance.
  	Dim table As New DataTable
  	' Create four typed columns in the DataTable.

          table.Columns.Add("column name",column type)
  	table.Columns.Add("column name",column type)

  	' Add rows with those columns filled in the DataTable.

          for example
  	table.Rows.Add(25, "Indocin", "David", DateTime.Now) 
  	table.Rows.Add(50, "Enebrel", "Sam", DateTime.Now)
  	
  	Return table
      End Function
  End Module

  then bind the table to the Gridview 

  GridView1.DataSource = dt
      GridView1.DataBind()

  BSCS-MCTS-MCP-MS
  Mark As Answer if my reply helped you
  Pray|Game|Code - My Way of Living
• • Reply
  maddtechwf

  Member

  17 Points

  146 Posts

  Re: Populate GridView without DataSource

  Jul 16, 2012 09:50 AM|maddtechwf|LINK

  I'm a little confused on how to implement this.

  I tried the above code but I was not able to reference any of my Protected Sub's to populate some of the rows.

• • Reply
  swaiss

  Member

  163 Points

  195 Posts

  Re: Populate GridView without DataSource

  Jul 16, 2012 10:59 AM|swaiss|LINK

  please refer these links

  http://www.dotnetperls.com/datatable-vbnet

  http://www.dotnetperls.com/datatable

  http://www.dotnetperls.com/convert-list-datatable

• • Reply
  maddtechwf

  Member

  17 Points

  146 Posts

  Re: Populate GridView without DataSource

  Jul 16, 2012 11:41 AM|maddtechwf|LINK

  EhsanMubeen

  Module Module1
      Sub Main()
  	' Get a DataTable instance from helper function.
  	Dim table As DataTable = GetTable()
      End Sub
  

   Function GetTable() As DataTable
  	' Create new DataTable instance.
  	Dim table As New DataTable
  	' Create four typed columns in the DataTable.

          table.Columns.Add("column name",column type)
  	table.Columns.Add("column name",column type)

  	' Add rows with those columns filled in the DataTable.

          for example
  	table.Rows.Add(25, "Indocin", "David", DateTime.Now) 
  	table.Rows.Add(50, "Enebrel", "Sam", DateTime.Now)
  	
  	Return table
      End Function
  End Module

  then bind the table to the Gridview 

  GridView1.DataSource = dt    GridView1.DataBind()

  I'm confused on the Binding part.   Where is dt coming from?

• • Reply
  EhsanMubeen

  Member

  281 Points

  95 Posts

  Re: Populate GridView without DataSource

  Jul 16, 2012 01:30 PM|EhsanMubeen|LINK

  Actually the line of code should be 

  Gridview1.Datasource = table; // table which you are declarating on Main

  Gridview1.databind();

  My bad 

  BSCS-MCTS-MCP-MS
  Mark As Answer if my reply helped you
  Pray|Game|Code - My Way of Living
• • Reply
  maddtechwf

  Member

  17 Points

  146 Posts

  Re: Populate GridView without DataSource

  Jul 17, 2012 01:35 PM|maddtechwf|LINK

  When I have the code you provided in the Module Module 1, I can't access any of my other functions in my Partial Class _Default.   Any suggestions?

• • Reply
  maddtechwf

  Member

  17 Points

  146 Posts

  Re: Populate GridView without DataSource

  Jul 17, 2012 05:46 PM|maddtechwf|LINK

  Had to add this line of code to fix it not showing up.

  TuitionGridView.AutoGenerateColumns = True