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 回答
- 1 回答
- 0 关注
- 136 浏览
添加回答
举报
0/150
提交
取消