mysql 条件查询view_C#mysql数据库查询根据条件显示dataGridView
直接查询显示全部，也可以根据条件查询代码privatevoidbuttonX1_Click(objectsender,EventArgse){stringstrStartDate=dateTimePicker1.Text.Trim();stringstrEndDate=dateTimePicker2...
直接查询显示全部，也可以根据条件查询代码 private void buttonX1_Click(object sender, EventArgs e) { string strStartDate = dateTimePicker1.Text.Trim(); string strEndDate = dateTimePicker2.Text.Trim(); int itIndex = strStartDate.IndexOf("星期"); if (itIndex >= 0) { strStartDate = strStartDate.Substring(0, itIndex).Trim(); } itIndex = strEndDate.IndexOf("星期"); if (itIndex >= 0) { strEndDate = strEndDate.Substring(0, itIndex).Trim(); } if (!DateTime.TryParse(strStartDate, out _zyq_rq)) { _zyq_rq = DateTime.MinValue; } if (!DateTime.TryParse(strEndDate, out _zyh_rq)) { _zyh_rq = DateTime.MaxValue; } if (_zyq_rq > _zyh_rq) { DateTime datime = _zyq_rq; _zyq_rq = _zyh_rq; _zyh_rq = datime; } _Name = textBox1.Text.Trim(); _CodeID = textBox2.Text.Trim(); _Code = textBox3.Text.Trim(); if (true) { } string constr = "server=localhost;database=db_17_816;uid=root;pwd=root;"; MySqlConnection conn = new MySqlConnection(constr); conn.Open(); MySqlDataAdapter cmd = new MySqlDataAdapter("select * from `db_list`", conn); strsql.Append("select * from `db_list`"); strsql.Append("where zyh_rq between"); strsql.Append(string.Format("'{0}'and '{1}'and", _zyq_rq, _zyh_rq)); if (_Name != null && _Name != "") { strsql.Append(string.Format(" NAME LIKE '%{0}%' AND", _Name)); } if (_CodeID != null && _CodeID != "") { strsql.Append(string.Format(" CodeID = '{0}' AND", _CodeID)); } if (_Code != null && _Code != "") { strsql.Append(string.Format(" CODE LIKE '%{0}%'", _Code)); } DataTable dt = new DataTable(); cmd.Fill(dt); dataGridViewX1.DataSource = dt; }sql语句已经没问题了，就是不能运行。
展开