where子句不与orded一起使用

本文介绍了where子句不与orded一起使用的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

string sql1 = "Select * from callpad_def where read_status=@read ORDER BY time_stamp DESC"; SqlCommand cmd = new SqlCommand(sql1, con); SqlDataReader sqlReader = cmd.ExecuteReader(); while (sqlReader.Read()) { c_address =Convert.ToInt32(sqlReader.GetValue(0).ToString()); c_status = sqlReader.GetValue(1).ToString(); token_no = (sqlReader.GetValue(2).ToString()); if (c_status != null) { status_reader(c_status); } } sqlReader.Close();

推荐答案

您需要编写查询，例如 You need to write query such as "Select * from callpad_def where read_status=" + 'read' + "ORDER BY time_stamp DESC"

修改您的查询，例如， 这里读取的是一个变量，所以你就像这样传递它的值.. 从callpad_def中选择*，其中read_status = +读+ORDER BY time_stamp DESC; 谢谢 快乐编码... Modify your query such as, here read is a variable so you passed its value like this way.. "Select * from callpad_def where read_status=" + read + "ORDER BY time_stamp DESC"; Thanks Happy coding...

String readValue; string sql1 = "Select * from callpad_def where read_status=@read ORDER BY time_stamp DESC"; SqlCommand cmd = new SqlCommand(sql1, con); cmd.Parameters.AddWithValue("@read", readValue); SqlDataReader sqlReader = cmd.ExecuteReader(); while (sqlReader.Read()) { c_address =Convert.ToInt32(sqlReader.GetValue(0).ToString()); c_status = sqlReader.GetValue(1).ToString(); token_no = (sqlReader.GetValue(2).ToString()); if (c_status != null) { status_reader(c_status); } } sqlReader.Close();