When you go to a new row in a DataGrid, the columns display (null). To prevent this behavior and make all the columns be empty, you can set the DefaultValue property of the DataColumn to be String.Empty.

After using one of the getXXX() methods of ResultSet, you can use wasNull() method to test whether you got null value or not null. rs.getString("email"); if ( rs.wasNull() ) // no email else // use email

This sample ( download C# , download VB ) derives two custom columnstyles that display buttons. One displays a pushbutton with the cell text used as the button label. The second columnstyle displays text plus a dropdown button similar to a combobox button...

There is no text property exposed for a rowheader cell. But you can handle the Paint event and draw header text yourself. You can download sample projects ( C# , VB ) that illustrate one technique for doing so. The sample loads the DataGrid in the form's... Set the DataGrid.AllowNavigation property to false. Contributed from George Shepherd's Windows Forms FAQ

lt;asp:DataGrid id="DataGrid1" OnItemDataBound="ItemDB" ShowFooter =true runat="server"></asp:DataGrid> Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load The wrap functionality occurs for each cell and not for each row of the DataGrid. Therefore, if you disabled the wrap functionality for all of the DataGrid, text wrapping functionality is not disabled for every row or column.

This solution is based off the combobox for datagrid columns found in this FAQ . That solution replaces the standard textbox with a combobox. To get notifications of the changes, a delegate is passed into the constructor for the custom column style. This...

If you have added a TableStyle for your grid, then the code below should set the right column width to be the empty space from a button click. If you need to dynamically do this in response to the user sizing other columns, then there may be more work...

lt;asp:DataGrid id="DataGrid1" OnItemDataBound ="ItemDB" DataKeyField ="ProductId" runat="server"></asp:DataGrid> Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Protected Sub ItemDB(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.DataGridItemEventArgs) e.Item.Cells[dc.IndexOf(dc[dcCol.ColumnName])].Attributes.Add("onclick", "javascript:window.open('details.aspx?id= "+strID+"',"+"'MyPage','height=300,width=300')");

DataTable myTable = new DataTable("Customers"); ... DataColumn cCustID = new DataColumn("CustID", typeof(int)); cCustID.AutoIncrement = true; cCustID.AutoIncrementSeed = 1; cCustID.AutoIncrementStep = 1; myTable.Columns.Add(cCustID...

If you have added a TableStyle for your grid, then the code below should set the right column width to be the empty space from a button click. If you need to dynamically do this in response to the user sizing other columns, then there may be more work. But if you only need to do it at the end of your Form_Load, then this code might be sufficient. It assumes your datasource is a datatable. You can download a sample project (C#, VB). this.dataGrid1.TableStyles["customers"].

Ensure that the power adaptor is fully plugged into the electrical outlet, and that the outlet is supplying power.

This column cannot have nulls and while insertion, if no value is supplied then it wil have zeroes, spaces or date/time depending on whether it is numeric, character or date/time. Use it when you do not want to have nulls but at the same time cannot give values all the time you insert this row.

This is called a product summary, it is set on a shelf or category item with several product items cascading off it. It can be set to have 2, 4 or 6 products shown. Products shown will be from the top of the list down up to the number of items that the summary is set for. e.g. a 6 product summary will show the first 6 product items on the shelf. To activate a product summary go to the shelf item you wish to have the summary show on and right click the description field.

Here is a sample ( C# , VB ) that has column selections implemented. It derives a DataGrid, adds a columns selection array list, and maintains this list in an override of OnMouseDown. Then to handle actually drawing the selected columns, it uses a derived...

You create a custom DataTableStyle that contains column styles for each column you want to display. You add the column styles in the order you want them to appear. Here are the steps to add an string column, an int column and a bool check column to a...

You need to derive a custom column style, override its Paint method and draw the image. In the attached samples, ( VB and C# ), there are two custom column styles. One style is a stand-alone unbound column that just displays an image. The second custom...

If you have added a table style to your DataGrid (so individual column styles have been generated), then you can use code such as this to set the Format property of the particular column style. [C#] // add format column 3 columnstyle where column 3 holds...

You can derive a custom columnstyle and override its Paint method to draw the image. Here are both C# and VB.Net samples . The Paint override offers three ways to draw the bimap in the cell; size it to fit the cell bounds, size it proportionally to fit...