Click here to Skip to main content
15,920,217 members
Home / Discussions / ASP.NET
   

ASP.NET

 
Questiontrying to get some measurement data to ASP from Microsoft SQL? Pin
auting824-Oct-20 11:07
auting824-Oct-20 11:07 
AnswerRe: trying to get some measurement data to ASP from Microsoft SQL? Pin
Richard Deeming5-Oct-20 2:53
mveRichard Deeming5-Oct-20 2:53 
Well, your view is wrong to start with. You've put:
Razor
<td> "measurement.Timestamp</td>
when it should be:
Razor
<td> @measurement.Timestamp</td>

You should also be wrapping the disposable objects in a using block:
C#
public List<Measurement> GetMeasurementParameters()
{
    const string connectionString = "DATA SOURCE=LAPTOP-1T8PALVT\\CITADEL;UID=LAPTOP-1T8PALVT\\AdisP;DATABASE=MEASUREMENTDATA;Integrated Security = True;" ;
    const string sqlQuery = "Select Timestamp, MeasurementValue, ControlValue from MEASUREMENTDATA";

    List<Measurement> measurmentParameterList = new List<Measurement>();
    using (SqlConnection con = new SqlConnection(connectionString))
    using (SqlCommand cmd = new SqlCommand(sqlQuery, con))
    {
        con.Open();
        using (SqlDataReader dr = cmd.ExecuteReader())
        {
            while (dr.Read())
            {
                Measurement measurementParameter = new Measurement();
                measurementParameter.Timestamp = dr["TimeStamp"].ToString();
                measurementParameter.MeasurementValue = dr["MeasurementValue"].ToString();
                measurementParameter.ControlValue = dr["ControlValue"].ToString();
                measurmentParameterList.Add(measurementParameter);                  
            }
        }
    }

    return measurmentParameterList;       
}

Beyond that, we can't help you. You haven't told us what you mean by "some code text", and you haven't shown us any of the data from your database.



"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

QuestionComplex View Model with Nested Item List / ModelState Pin
Guillermo Perez18-Sep-20 15:49
Guillermo Perez18-Sep-20 15:49 
AnswerRe: Complex View Model with Nested Item List / ModelState Pin
Richard Deeming27-Sep-20 22:21
mveRichard Deeming27-Sep-20 22:21 
QuestionFireFox Upload Images Pin
Member 105489774-Sep-20 6:23
Member 105489774-Sep-20 6:23 
AnswerRe: FireFox Upload Images Pin
Richard Deeming6-Sep-20 23:09
mveRichard Deeming6-Sep-20 23:09 
GeneralRe: FireFox Upload Images Pin
Member 1054897717-Sep-20 5:31
Member 1054897717-Sep-20 5:31 
GeneralRe: FireFox Upload Images Pin
Richard Deeming17-Sep-20 9:06
mveRichard Deeming17-Sep-20 9:06 
GeneralRe: FireFox Upload Images Pin
Member 1054897718-Sep-20 5:48
Member 1054897718-Sep-20 5:48 
GeneralRe: FireFox Upload Images Pin
Richard Deeming20-Sep-20 23:40
mveRichard Deeming20-Sep-20 23:40 
GeneralRe: FireFox Upload Images Pin
Member 1054897717-Sep-20 5:36
Member 1054897717-Sep-20 5:36 
GeneralRe: FireFox Upload Images Pin
Member 1054897718-Sep-20 5:29
Member 1054897718-Sep-20 5:29 
QuestionShow DataTable in Json Pin
Member 149089644-Sep-20 0:20
Member 149089644-Sep-20 0:20 
AnswerRe: Show DataTable in Json Pin
F-ES Sitecore4-Sep-20 2:43
professionalF-ES Sitecore4-Sep-20 2:43 
GeneralRe: Show DataTable in Json Pin
Member 1490896421-Sep-20 1:48
Member 1490896421-Sep-20 1:48 
GeneralRe: Show DataTable in Json Pin
F-ES Sitecore21-Sep-20 1:51
professionalF-ES Sitecore21-Sep-20 1:51 
GeneralRe: Show DataTable in Json Pin
Member 1490896421-Sep-20 3:47
Member 1490896421-Sep-20 3:47 
GeneralRe: Show DataTable in Json Pin
Richard Deeming21-Sep-20 4:20
mveRichard Deeming21-Sep-20 4:20 
QuestionHotel ERP system Pin
Member 1492170724-Aug-20 4:36
Member 1492170724-Aug-20 4:36 
AnswerRe: Hotel ERP system Pin
Richard Deeming24-Aug-20 4:52
mveRichard Deeming24-Aug-20 4:52 
AnswerRe: Hotel ERP system Pin
Mycroft Holmes24-Aug-20 12:22
professionalMycroft Holmes24-Aug-20 12:22 
GeneralRe: Hotel ERP system Pin
CHill604-Sep-20 0:37
mveCHill604-Sep-20 0:37 
AnswerRe: Hotel ERP system Pin
Eddy Vluggen24-Aug-20 12:39
professionalEddy Vluggen24-Aug-20 12:39 
Question.Net Core 3.2 Controller, using route and HttpGet attribute with CreatedAtRoute Pin
jkirkerx19-Aug-20 8:39
professionaljkirkerx19-Aug-20 8:39 
AnswerRe: .Net Core 3.2 Controller, using route and HttpGet attribute with CreatedAtRoute Pin
jkirkerx19-Aug-20 10:04
professionaljkirkerx19-Aug-20 10:04 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.