C# chart

最新推荐文章于 2024-08-23 15:40:32 发布

转载最新推荐文章于 2024-08-23 15:40:32 发布 · 677 阅读

收录于

C# 同时被 2 个专栏收录

94 篇文章

订阅专栏

SQL server

6 篇文章

订阅专栏

http://blog.sina.com.cn/s/blog_621e24e20101cp64.html

Chart SQL server 数据绑定：

       private void button_Inquiry_Click(object sender, EventArgs e)
        {
            //MessageBox.Show(dateTimePicker1.Value.ToString());
            try
            {
                string strConn = @"data source=PANLEE-PC;initial catalog=DB15728;integrated security=true";
                SqlConnection conn = new SqlConnection(strConn);
               //conn.Open();
                string sql = "select data_value,data_time from FrequencyOfNode_1 where data_DateTime Between '" + dateTimePicker1.Value + "'" + "and '" + dateTimePicker2.Value + "'";
                SqlCommand cmd = new SqlCommand(sql, conn);
                chart5.DataSource = cmd;
                //chart5.Series[0].XValueMember = DateTime.Now.ToShortTimeString();
                chart5.Series[0].XValueMember = "data_time";    //DateTime 类型数据在须数据库中存为字符型
                chart5.Series[0].YValueMembers = "data_value";
                chart5.DataBind();
                conn.Close();

            }
            catch { MessageBox.Show("ERROR"); }
        }