string myConnectionString;myConnectionString = "server=localhost;uid=root;pwd=root;database=medicloud;SslMode=None;charset=utf8";MySqlConnection connection = new MySqlConnection(myConnectionString);MySqlCommand cmd = new MySqlCommand();cmd.CommandType = CommandType.Text;string sqlStr = "Select arm from assign where userId=@name";cmd.Parameters.AddWithValue("@name", txtValue.Text);cmd.CommandText = sqlStr;cmd.Connection = connection;EncodingProvider ppp;ppp = CodePagesEncodingProvider.Instance;Encoding.RegisterProvider(ppp);connection.Open();MySqlDataReader reader = cmd.ExecuteReader();reader.Read();string databaseLine = (reader["arm"].ToString());connection.Close();#endregiontxtExercise.Text = databaseLine + " (Uncomplete)\n" + databaseLine;我正在嘗試查看數據庫中的兩行數據。但是,我不知道如何查看它。有人能幫我嗎?我嘗試輸入“databaseLine”兩次,但都查看同一行如您所見,Rachel有兩種類型的鍛煉。我想在txtExercise.Text上查看這兩個練習。但是我只能查看第一個,我無法查看第二個。
- 1 回答
- 0 關注
- 147 瀏覽
添加回答
舉報
0/150
提交
取消