Click here to Skip to main content
15,885,931 members
Home / Discussions / ASP.NET
   

ASP.NET

 
GeneralRe: How to I make EmailButton_Click work? Pin
F-ES Sitecore8-Jan-20 22:11
professionalF-ES Sitecore8-Jan-20 22:11 
QuestionHow do I make my GetCasesButton_Click work? Pin
Member 114033048-Jan-20 4:46
Member 114033048-Jan-20 4:46 
AnswerRe: How do I make my GetCasesButton_Click work? Pin
ZurdoDev8-Jan-20 5:19
professionalZurdoDev8-Jan-20 5:19 
GeneralRe: How do I make my GetCasesButton_Click work? Pin
Member 114033048-Jan-20 7:56
Member 114033048-Jan-20 7:56 
QuestionHow do I make my GetCasesButton_Click work? Pin
Member 114033048-Jan-20 4:33
Member 114033048-Jan-20 4:33 
AnswerRe: How do I make my GetCasesButton_Click work? Pin
ZurdoDev8-Jan-20 5:18
professionalZurdoDev8-Jan-20 5:18 
QuestionText with Audio Pin
Member 104440587-Jan-20 21:19
Member 104440587-Jan-20 21:19 
AnswerRe: Text with Audio Pin
ZurdoDev8-Jan-20 0:57
professionalZurdoDev8-Jan-20 0:57 
GeneralRe: Text with Audio Pin
Member 104440588-Jan-20 19:47
Member 104440588-Jan-20 19:47 
QuestionName of the software that can package websites to install on smartphones: android and iphone ? Pin
Member 24584677-Jan-20 17:34
Member 24584677-Jan-20 17:34 
GeneralRe: Name of the software that can package websites to install on smartphones: android and iphone ? Pin
Richard MacCutchan7-Jan-20 21:21
mveRichard MacCutchan7-Jan-20 21:21 
GeneralRe: Name of the software that can package websites to install on smartphones: android and iphone ? Pin
Member 24584679-Jan-20 19:44
Member 24584679-Jan-20 19:44 
GeneralRe: Name of the software that can package websites to install on smartphones: android and iphone ? Pin
Richard MacCutchan9-Jan-20 23:08
mveRichard MacCutchan9-Jan-20 23:08 
QuestionScrape with htmlagilityapck question Pin
Member 17532506-Jan-20 12:10
Member 17532506-Jan-20 12:10 
SuggestionRe: Scrape with htmlagilityapck question Pin
ZurdoDev7-Jan-20 9:04
professionalZurdoDev7-Jan-20 9:04 
GeneralRe: Scrape with htmlagilityapck question Pin
Member 17532507-Jan-20 9:57
Member 17532507-Jan-20 9:57 
QuestionRe: Scrape with htmlagilityapck question Pin
ZurdoDev11-Jan-20 8:55
professionalZurdoDev11-Jan-20 8:55 
AnswerRe: Scrape with htmlagilityapck question Pin
Member 175325011-Jan-20 9:36
Member 175325011-Jan-20 9:36 
QuestionAssigning data from sql database to a chart C# and entity framework Pin
Member 146959565-Jan-20 22:07
Member 146959565-Jan-20 22:07 
AnswerRe: Assigning data from sql database to a chart C# and entity framework Pin
Richard Deeming7-Jan-20 9:08
mveRichard Deeming7-Jan-20 9:08 
Loading data from the database is best done in the controller, rather than the view.

Assuming you're using raw ADO.NET to access the database, something like this should work:

Controller:
C#
public ActionResult YourAction()
{
    var xValues = new List<string>();
    var yValues = new List<string>();
    
    using (var connection = new SqlConnection("... YOUR CONNECTION STRING HERE ..."))
    using (var command = new SqlCommand("SELECT ConDate, ConUnits FROM TBL_MYdata ORDER BY ConDate", connection))
    {
        connection.Open();
        
        using (var reader = command.ExecuteReader(CommandBehavior.CloseConnection))
        {
            while (reader.Read())
            {
                xValues.Add(Convert.ToString(reader["ConDate"]));
                yValues.Add(Convert.ToString(reader["ConUnits"]));
            }
        }
    }
    
    var model = new Chart(width: 600, height: 400, theme: ChartTheme.Green)
        .AddTitle("Product Life Cycle")
        .AddSeries(name: "Employee", chartType: "Spline", xValues: xValues.ToArray(), yValues: yValues.ToArray());
    
    return View(model);
}
View:
Razor
@model Chart
@{
    Layout = "~/Views/Shared/_Layout.cshtml";
    Model.Write();
}




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

QuestionCan i use timer control without use java sicrpt? Pin
Nowiglah4-Jan-20 6:26
Nowiglah4-Jan-20 6:26 
AnswerRe: Can i use timer control without use java sicrpt? Pin
Eddy Vluggen4-Jan-20 8:36
professionalEddy Vluggen4-Jan-20 8:36 
QuestionTrying to open a pdf file in a new Tab on Chrome browser - not happening Pin
simpledeveloper3-Jan-20 5:59
simpledeveloper3-Jan-20 5:59 
AnswerRe: Trying to open a pdf file in a new Tab on Chrome browser - not happening Pin
ZurdoDev3-Jan-20 6:29
professionalZurdoDev3-Jan-20 6:29 
GeneralRe: Trying to open a pdf file in a new Tab on Chrome browser - not happening Pin
simpledeveloper3-Jan-20 6:50
simpledeveloper3-Jan-20 6:50 

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.