求ASP.net 从MySQL数据库中查询，把数据写入对应的TextBox中实现方法

Question

TextBox1~8

 MySqlConnection conn = new MySqlConnection(str);
            conn.Open();
            //string sql = "select * from Sys_Person where PersonName='" + admin_id + "' and password='" + admin_psw + "'";
            string sql = "select * from inf_Benefit where personID = '" + user_ID +"' and MONTH(InputDate)='"+DateTime.Now.Month.ToString()+"'";
            MySqlCommand mcom = new MySqlCommand(sql, conn);//执行数据库查询代码
            MySqlDataReader sdr = mcom.ExecuteReader();
            if (sdr.Read())
            {
                while (sdr.Read())
                {
                    for (int i = 0; i < 9; i++)
                    {
                        TextBox[i].Text = sdr.GetString(3).TrimEnd();//报错
                    }
                }
                sdr.Close();
            }

如上代码无法实现请各位大神有没有好的办法？

Answer 1

數據怎麽來，就怎麽給到對應的對象