假設(shè)以下代碼返回整個(gè)結(jié)果行:using (SqlCommand cmdMessages = new SqlCommand("SELECT * FROM Email where Sender = @usernameLog", conn)){ cmdMessages.Parameters.Add(new SqlParameter("@usernameLog", Sender)); using (SqlDataReader reader = cmdMessages.ExecuteReader()) { while (reader.Read()) { Console.Write(); // Receiver's Name which comes from database Console.Write();// The message which comes from same row as the receiver's name } }}該查詢在SQL Server中工作正常。SQL Server的輸出: User hi 我想在控制臺中有相同的輸出。
如何從數(shù)據(jù)庫讀取整個(gè)行到C#?
炎炎設(shè)計(jì)
2021-05-06 14:18:24