Data Grid Interview Questions and Answers

Answer: The DataGrid Web server control is a powerful tool for displaying information from a data source. It is easy to use; you can display editable data in a professional-looking grid by setting only a few properties. At the same time, the grid has a sophisticated object model that provides you with great flexibility in how you display the data.

Answer: As they ask you to do it at run time, you need to add the controls to the control collection of the cell of the footer row of the gridView.Button myBtn = new Button(); gvTest.FooterRow.Cells[1].Controls.Add(myBtn);Play caution where the dynamic addition is done if you want it to persist.

Answer: If you want to add the controls on the grid, you can use item template.Example:<asp:TemplateField><ItemTemplate><asp:CheckBox ID="Chk" runat="server" /></ItemTemplate></asp:TemplateField>

Answer: ItemCommandItemDataBoundEditCommandUpdateCommandCancelCommandLoadinitDataBinding

Answer: Exampledim da as new sqldataadapter("select...",conn)dim ds as new datasetda.fill(ds,xyz)dim dr as datarowdr=ds.tables(0).rows.newrowwith dr.items(0)=textbox1.text.items(1)=textbox2.text.items(2)=textbox3.textds.tables(0).addrow(dr)datagrid1.datasource=ds.tables(0)

Answer: A basic MTS architecture is made up of: The MTS Executive (mtxex.dll) The Factory Wrappers and Context Wrappers for each component The MTS Server Component MTS clients Auxiliary systems like: COM runt...

Answer: Binding Data in DataGrid means how we show the data from a table or a relation in our DataGrid.Suppose We want to show the data of "Customers" table of "Northwind" database present in SQL Server on the Button Click. Now Follow the given steps....step 1: Drag a DataGrid and a Button control on the Page.step 2: In the Code behind Use the namespace asusing System.Data.SqlClient;step 3: Write the following code in the Button's Click event handler...protected void Button1_Click(object sender,EventArgs e){SqlConnection con=new SqlConnection ("server=rajkumar;uid=sa;pwd=kumar;database=northwind) ;SqlDataAdapter da_show=new SqlDataAdapter (" select P...

Answer: After a SELECT query is executed, we must retrieve the rows from the Oracle server to your PC. We do not retrieve the rows all at once, nor do we retrieve them one at a time (unless there is a LONG or LOB column involved). We retrieve the rows in blocks. The number of rows retrieved in each block is the number of rows you specify with "OCI Array Buffer Size". TOAD defaults to 25 because SQL*Plus defaults to 25. In my opinion, an optimal setting is more like 500 or 1000. Here is why: If your dataset has 1,000 rows, and your OCI Array Buffer size is set to 25, then TOAD has to make 40 (that's 1000 / 25) round trips across the network to retriev...

Answer: Please upgrade your copy of TOAD to at least version 7.4.0.3. This functionality has been restored

Answer: After a SELECT query is executed, we must retrieve the rows from the Oracle server to your PC. We do not retrieve the rows all at once, nor do we retrieve them one at a time (unless there is a LONG or LOB column involved). We retrieve the rows in blocks. The number of rows retrieved in each block is the number of rows you specify with "OCI Array Buffer Size". TOAD defaults to 25 because SQL*Plus defaults to 25. In my opinion, an optimal setting is more like 500 or 1000. Here is why: If your dataset has 1,000 rows, and your OCI Array Buffer size is set to 25, then TOAD has to make 40 (that's 1000 / 25) round trips across the network to retriev...