Datagrid & Checkboxs [Resolved]

[Draven Chen Zhen]

Hello, this is what I want to do...
I'have got a value in my database that can be true or false, en when I read out my table into a datagrid, I want a checkbox that is checked when the value is true and unchecked when it is false.

First it was a pain just getting the checkbox in the datagrid, but I got this solved by using a template Column.

But I realy haven't got a clue how to preset the checkbox ....


My code behind code

myCommand = myConn.CreateCommand();
			myCommand.CommandText = "select * from tbl_firm";

		    OracleDataAdapter oda = new OracleDataAdapter(myCommand);
			DataSet myDs = new DataSet("Firms");
			myCommand.Transaction = myOracleTransaction;
			oda.Fill(myDs);
			myCommand.ExecuteNonQuery();
			GridFirms.DataSource = myDs;
			GridFirms.DataBind();
			myOracleTransaction.Commit();
			this.myConn.Close();

And this is my asp code :

<asp:datagrid id="GridFirms" runat="server" AutoGenerateColumns="False" GridLines="Vertical">
							<AlternatingItemStyle BackColor="Silver"></AlternatingItemStyle>
							<ItemStyle BackColor="DarkGray"></ItemStyle>
							<HeaderStyle Font-Bold="True" BackColor="LightGray"></HeaderStyle>
							<Columns>
								<asp:BoundColumn DataField="FIRM_NAME" HeaderText="Firm">
									<HeaderStyle Width="50px"></HeaderStyle>
								</asp:BoundColumn>
								<asp:BoundColumn DataField="FIRM_IS_OEM" HeaderText="OEM?">
									<HeaderStyle Width="50px"></HeaderStyle>
								</asp:BoundColumn>
								<asp:BoundColumn DataField="FIRM_IS_TIER1" HeaderText="Tier1">
									<HeaderStyle Width="50px"></HeaderStyle>
								</asp:BoundColumn>
								<asp:BoundColumn DataField="FIRM_IS_RECTICEL" HeaderText="Recticel?">
									<HeaderStyle Width="50px"></HeaderStyle>
								</asp:BoundColumn>
								<asp:EditCommandColumn ButtonType="LinkButton" UpdateText="Update" CancelText="Cancel" EditText="Edit">
									<HeaderStyle Width="50px"></HeaderStyle>
								</asp:EditCommandColumn>
								<asp:ButtonColumn Text="Delete" CommandName="Delete">
									<HeaderStyle Width="50px"></HeaderStyle>
								</asp:ButtonColumn>
								<asp:TemplateColumn HeaderText="Test">
								 <ItemTemplate>
								  <asp:CheckBox id=test Runat=server></asp:CheckBox>
								 </ItemTemplate>
								</asp:TemplateColumn>
							</Columns>
						</asp:datagrid>