I have 1 row of data in data set and want to bind to a numeric box. I
figured that nUpDwnMin1.DataBindings.Add("Value", ,"Min_1"); but I
having an issue figuring out the source notation.

Unfortunately, I am getting confused about setting the value from the
data set. I created all my tables with table[0].

Do I have to use a get and set statement for the valuesl in the class?
Can I directly load from the dataset? Also, these are numbers that
will be updated that's why I decided to use a dataset to write back
easily? This data set only contains 1 record. I put the code below to
see if I am going over board.

Any help is greatly appreciated.

Mark

//Call over
private void Load_CodeAssignments()
{
DataTable dt = new DataTable();
Codes dsCodes = new Codes(cbDept.Text, cbPyramid.Text);
dt = dsCodes.Get_Codes;

//nUpDwnCodeA.Value = dsCodes.Get_Codes.Columns["A_pct"]; No good
//nUpDwnMin1.Value = Convert.ToDecimal(dt.Columns["Min1"]); No good

nUpDwnMin1.DataBindings.Add("Value", ,"Min_1");
}

//Class

public class Codes
{
#region Private Members
private DataSet _dsCodes;
#endregion

#region Public Properties
public DataTable Get_Codes
{
get { return _dsCodes.Tables[0]; }
}
#endregion

#region Constructors
public Codes(string Department, string Pyramid)
{
//This will establish the database connection
Database db = DatabaseFactory.CreateDatabase("Test");
//This will allow you to call a SP and use parameters
DBCommandWrapper dbc =
db.GetStoredProcCommandWrapper("usp_Inv_SS_GetCodes");
dbc.AddInParameter("@Department", DbType.String, Department);
dbc.AddInParameter("@Pyramid", DbType.String, Pyramid);
_dsCodes = db.ExecuteDataSet(dbc);
}
#endregion