On this form, all of the fields will go into one row in a table. However, depending on which product the user is ordering, not all of the fields are required. If a field is not required it will get a Null value.

I have the logic in the code behind to determine which fields should be visible.

I am currently using a formview control (that defaults to insert mode) to collect the information but am not having any luck hiding a row, I can't figure out how to reference it in the code behind.

Feel free to let me know if I am going about this entirely the wrong way too please.

I don't see a way of eliminating a row from the formview. You will need to exclude the row(s) you want from the datasorce used for the formview.

I am sorry, I misspoke on the first request, the form view is only in insert mode, so I don't need to exlude a ROW from the form, but specific COLUMNS based on values in another table.

Here is simplified example.

jobType Table has 2 columns, requiresName and requiresDate

the form in question, will be collecting data to go in the jobs table.
When the form is compiled, it will check the jobType tbl to see if the requiresName and requiresDate fields are checked. If they are, those fields should be visible in the form. If they are not checked, those two fields should not be visible on the form and they will be submitted into the jobs table with NULL values.

Here is what I have so far.

if (!Page.IsPostBack)
        {
            SqlConnection MyConnection;
            SqlCommand MyCommand;
            SqlDataReader MyReader;
            SqlParameter lobParam;

            MyConnection = new SqlConnection();
            MyConnection.ConnectionString = ConfigurationManager.ConnectionStrings["rdConnectionString"].ConnectionString;

            MyCommand = new SqlCommand();
            MyCommand.CommandText =
               " SELECT * FROM LinesOfBusiness WHERE lobID = @lobID ";
            MyCommand.CommandType = CommandType.Text;
            MyCommand.Connection = MyConnection;

            lobParam = new SqlParameter();
            lobParam.ParameterName = "@lobID";
            lobParam.SqlDbType = SqlDbType.Int;
            lobParam.Size = 4;
            lobParam.Direction = ParameterDirection.Input;
            lobParam.Value = "2";

            MyCommand.Parameters.Add(lobParam);

            MyCommand.Connection.Open();
            MyReader = MyCommand.ExecuteReader(CommandBehavior.CloseConne ction);





            if (MyReader.Read())
            {
                string codeStr = "";
                if (MyReader.GetBoolean(MyReader.GetOrdinal("requires PropAddress")) == true)

                    //code to set visiblility of form field, this is the part I can't get to work.

            }

            MyCommand.Dispose();
            MyConnection.Dispose();

        }
    }

FormView1.Row.Cells(0).FindControl("YourControl"). Visible = false;

Thanks, that worked.

glad to help :)