显示数据库返回的结果 [英] Display returned results from the database

问题描述

我正在尝试仅将查询中的记录放入页面中.查询从下拉列表中选择要在where子句中使用的值.

SqlConnection sqlCon =新的SqlConnection("Server = FNUEXCPC01 \\ SQLSERVER2005; Database = PREMIUM; Trusted_Connection = yes;");
sqlCon.Open(); SqlCommand sqlCmd =新的SqlCommand();
sqlCmd.Connection = sqlCon;



sqlCmd.CommandText =从RECORDSMG WHERE部门中选择Ref_Link =" + ddview.SelectedValue; //AND School = + ddlistschools.SelectedValue AND Doc_Category = + ddview.SelectedItem;

var结果= sqlCmd.ExecuteReader();
//var myArray = new string [，] {};
while(results.Read())
{

Response.Write(results);
sqlCon.Close();
}


}

Im trying to just dipslay the records from a query in a page.The query select values from the dropdownlist to be used in the where clause.

SqlConnection sqlCon = new SqlConnection("Server=FNUEXCPC01\\SQLSERVER2005;Database=PREMIUM;Trusted_Connection=yes;");
sqlCon.Open(); SqlCommand sqlCmd = new SqlCommand();
sqlCmd.Connection = sqlCon;



sqlCmd.CommandText = "Select Ref_Link from RECORDSMG WHERE Department ="+ddview.SelectedValue; //AND School= + ddlistschools.SelectedValue AND Doc_Category= +ddview.SelectedItem";

var results = sqlCmd.ExecuteReader();
//var myArray = new string[,] { };
while (results.Read())
{

Response.Write(results);
sqlCon.Close();
}


}

推荐答案

需要帮助.现在我已经稍微更改了代码，但仍然出现错误，如"of"关键字附近的语法不正确". "..现在的代码是...

SqlConnection sqlCon =新的SqlConnection("Server = FNUEXCPC01 \\ SQLSERVER2005; Database = PREMIUM; Trusted_Connection = yes;");
sqlCon.Open(); SqlCommand sqlCmd =新的SqlCommand();
sqlCmd.Connection = sqlCon;



sqlCmd.CommandText =从RECORDSMG WHERE部门中选择Ref_Link =" + ddview.SelectedValue +"School =" + ddlistschools.SelectedValue +"Doc_Category =" + ddcat.SelectedItem;
SqlDataReader dr = sqlCmd.ExecuteReader();//在此行发生错误
//var结果sqlCmd.ExecuteReader();
//var myArray = new string [，] {};
while(dr.Read())
{

Response.Write(dr);
sqlCon.Close();
}

need help please..now i have changed the code little bit but it still gives a error as"Incorrect syntax near the keyword ''of''."..the code now is...

SqlConnection sqlCon = new SqlConnection("Server=FNUEXCPC01\\SQLSERVER2005;Database=PREMIUM;Trusted_Connection=yes;");
sqlCon.Open(); SqlCommand sqlCmd = new SqlCommand();
sqlCmd.Connection = sqlCon;



sqlCmd.CommandText = "Select Ref_Link from RECORDSMG WHERE Department ="+ddview.SelectedValue + "School=" + ddlistschools.SelectedValue + "Doc_Category=" +ddcat.SelectedItem;
SqlDataReader dr= sqlCmd.ExecuteReader();//error occurs @ this line
// var results sqlCmd.ExecuteReader();
// var myArray = new string[,] { };
while (dr.Read())
{

Response.Write(dr);
sqlCon.Close();
}

这篇关于显示数据库返回的结果的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！