C# SQL taking out date's data from table to C#

See more:

C#

ASP.NET

SQL

SqlCommand cmd = new SqlCommand("SELECT * FROM [t_memsch] where [m_memcode]='" + m_memcode_input.Text + "'", conn);
                SqlDataAdapter sda1 = new SqlDataAdapter(cmd);
                DataTable ds1 = new DataTable();


                sda1.Fill(ds1);                

                try
                {   
                    //int temp = ds1.Rows.Count

                    decimal[,] allowance = new decimal[31,6]; //[day, session]

                    for (int row = 0; row < 31; row++)
                    {
                        for (int col = 0; col < 6; col++)
                        {
                            allowance[row, col] = 0;
                        }
                    }

                    for(int temp = ds1.Rows.Count; temp > 0; temp--)
                    {
                        temp--;
                        string date1 = ds1.Rows[temp]["m_schdate"].ToString();
                        temp++;

                        if (chk_date(date1, conn))
                        {
                            MessageBox.Show(date1);

                            if (chk_late(date1, conn))
                            {
                                MessageBox.Show("Good Boy!!");
                                
                                //int day = (int)cmd.ExecuteScalar();

                                allowance[28,3] = 30;
                                allowance[29, 1] = 12.7M;
                            }
                            else 
                            {
                                MessageBox.Show("Late! No pay.");
                                allowance[28,3] = 0;
                            }

There is a column call "t_scantime" in my table [t_memsch], and the format of t_scantime is "12-31-2011 10:30:00"

Now i want to insert the day only from "t_scantime" into my array's day column - allowance[day,session], may anyone please give me some helps or idea?
P.S. wanna do the insert statement under "MessageBox.Show("Good Boy!!");" this line.

pleaseeeee.