c# - Range datetime on chart -


i have chart x axis gets values ​​"datahoraevento" query, set axis datetime, in chart x-axis values ​​appear hourly. know how can shorten time , show these values ​​for example minute minute on x axis.

enter image description here

follow code:

using system; using system.collections.generic; using system.linq; using system.web; using system.web.ui; using system.web.ui.webcontrols; using system.data.sqlclient; using system.data; using system.web.ui.datavisualization.charting;  public partial class graficos : system.web.ui.page {      protected void page_load(object sender, eventargs e)     {         sqlconnection con = new sqlconnection(system.configuration.configurationmanager.connectionstrings["connectionstringsql"].connectionstring);         con.open();         sqlcommand cmd = new sqlcommand("select top 20 log.valorentrada, log.datahoraevento log inner join equipamento on log.idequipamento = equipamento.idequipamento inner join entradaestado on equipamento.idequipamento = entradaestado.idequipamento inner join entrada on entradaestado.identrada = entrada.identrada entrada.descricao = 'controle de acionamento relé xr' , log.valorentrada not null order datahoraevento desc ");         cmd.connection = con;         sqldataadapter da = new sqldataadapter(cmd);         datatable dt = new datatable();         da.fill(dt);         chart1.datasource = dt;          chart1.chartareas["chartarea1"].axisx.title = "hora dia";          if (request.form["descricao"] == "tensão carregador solar -de 11v à 14v")             chart1.chartareas["chartarea1"].axisy.title = "tensão (v)";         else             chart1.chartareas["chartarea1"].axisy.title = "corrente (a)";            chart1.chartareas["chartarea1"].axisx.labelstyle.format = "hh:mm:ss";         chart1.chartareas["chartarea1"].axisx.linedashstyle = chartdashstyle.dot;         chart1.chartareas["chartarea1"].axisy.linedashstyle = chartdashstyle.dot;         chart1.chartareas["chartarea1"].axisx.majorgrid.linecolor = system.drawing.color.darkgray;         chart1.chartareas["chartarea1"].axisx.majorgrid.linedashstyle = chartdashstyle.dot;         chart1.chartareas["chartarea1"].axisy.majorgrid.linecolor = system.drawing.color.darkgray;         chart1.chartareas["chartarea1"].axisy.majorgrid.linedashstyle = chartdashstyle.dot;           chart1.series["series1"].xvaluetype = chartvaluetype.datetime;         chart1.series["series1"].borderwidth = 5;         chart1.series["series1"].xvaluemember = "datahoraevento";         chart1.series["series1"].yvaluemembers = "valorentrada";          chart1.width = 800;         chart1.height = 350;          chart1.databind();         con.close();     }   }


Comments

Post a Comment

Popular posts from this blog

javascript - Create a stacked percentage column -

i have collection of data : var data = [ {"p301a":"10","p301b":"7","p301c":"7","p301d":"3","p301e":"8","p301f":"8","p301g":"8","p301h":"8","p301i":"8","p301j":"8","p301k":"8","p301l":"8","p301m":"8","p301n":"8","p301o":"8","age":"31-40 years","profesion":"2","position":"2"}, {"p301a":"5","p301b":"4","p301c":"4","p301d":"4","p301e":"4","p301f":"4","p301g":"4","p301h":"4","p301i":"4","p301j":"4","p301k":"4...
Read more

Optimising Firebase database by automatically overwriting data -

in firebase app have following structure: posts latest all users can write posts > latest . want limit entries 20 posts save space in database. , posts beyond 20 unnecessary never shown on homepage. how can limit posts 20, when user writes posts > latest posts @ end drop off (be deleted) automatically? this sample should you. you need : const max_log_count = 20; exports.removeold = functions.database.ref('/posts/latest/{postid}').oncreate(event => { const parentref = event.data.ref.parent; return parentref.once('value').then(snapshot => { if (snapshot.numchildren() >= max_log_count) { let childcount = 0; const updates = {}; snapshot.foreach(function(child) { if (++childcount <= snapshot.numchildren() - max_log_count) { updates[child.key] = null; } }); // update parent. removes children. ...
Read more

javascript - Angular UI-Grid customTemplate directive causing rows to load slowly/? -

Image
each grid cell can have more 1 customtemplate loaded. have directive holds watcher on model_col_field listen cell updates on scroll when dom rows updated , recompile celltemplate . without watcher , $compile rows repeat on scroll, showing same set of rows. is there more angular way of approaching or way improve performance? relevant controller code: create gridoptions.data & gridoptions.columndefs : var customtemp = '<div ng-repeat="opt in grid.appscope.colvalueoptionsmodel" ng-init="tempstring=model_col_field.clazz+opt.key;"><comparison-directive dbo="model_col_field" attobj="opt" fff="grid.appscope.getattributetemplate(tempstring)" /></div>'; $scope.gridoptions.columndefs = [ { name:'yindex',pinnedleft:true,celltemplate: customtemp, displayname:'index'}, { name:'col1',celltemplate: customtemp}, { name:'col2',celltemplate: c...
Read more