How do you make a Data Grid Hyperlink Column pass information from two columns in the database?

The Datagrid Property Builder allows me to insert anything in the URL Field, but when I put date, category in the URL Field I receive an error.


Can anyone provide me with some help?

What error did you receive?

I tried it using & and received this error:

A field or property with the name 'category&date' was not found on the selected datasource.

Is there a way for it to recognize two fields?

Can you post your code?

Sure, but this is where I'm speaking of is in the Data Grid Property Builder

public class MonthControl : System.Web.UI.UserControl
    {
        protected System.Web.UI.WebControls.DataGrid DataGrid1;
        protected string smonthnumber;
        protected string syearnumber;
        //protected System.Web.UI.WebControls.DataGridItem syearnumber;
        //Open Connection
        SqlConnection objConn = new SqlConnection(ConfigurationSettings.AppSettings["MyConn"]);
        protected System.Web.UI.WebControls.HyperLink MonthLink;
        SqlCommand objComm = new SqlCommand();
        SqlDataReader objRead;

        //char nYear;

        public string MonthNumber
        {
            get {return smonthnumber;}
            set {smonthnumber= value;}
        }

        public string YearDate
        {
            get {return syearnumber;}
            set {syearnumber = value;}
        }




        private void Page_Load(object sender, System.EventArgs e)
        {
            // Put user code to initialize the page here

            // nYear=char.Parse(Request["@Year"].ToString());
        }



        #region BindGrid()
        public void BindGrid()
        {

            objComm.CommandText = "sp_myStoredProcedure";
            objComm.CommandType = CommandType.StoredProcedure;
            objComm.Connection = objConn;
            objComm.Parameters.Add("@Month",SqlDbType.Char,2);
            objComm.Parameters["@Month"].Value = smonthnumber;
            objComm.Parameters.Add("@Year",SqlDbType.Char,4);
            //Change 1-11-05
            objComm.Parameters["@Year"].Value = syearnumber;
            //Change
            objComm.Connection.Open();
            DataGrid1.DataSource = objComm.ExecuteReader();

            DataGrid1.DataBind();

            objComm.Connection.Close();
            objComm.Parameters.Clear();

            MonthLink.NavigateUrl="monthabc.aspx?month=" + smonthnumber.ToString() +
                "&syearnumber="+syearnumber.ToString();

Is it possible to create a Hyperlink Column here in the code behind?

Private void DataGrid1_SelectedIndexChanged(object sender, System.EventArgs e)
{

}