Serzhik
22-11-2006, 15:05
С aspx странички передаются данные в sql. Подскажите пожалуйсто где здесь переменные которые передаются в SQL? Или обьясните что куда идет?
____________________________________________________________________________________________________
private XmlDocument GetAllRenewsXml() {
string sql = "SELECT id, name " +
"FROM renews " +
"WHERE deleted = 0" +
"ORDER BY type, priority, code_name";
SqlConnection conn = Database.OpenConnection();
DataSet oDataSet = new DataSet("AllRenews");
SqlDataAdapter oDataAd = new SqlDataAdapter(sql, conn);
oDataAd.Fill(oDataSet, "Renew");
conn.Close();
XmlDataDocument xmlDataDoc = new XmlDataDocument(oDataSet);
return (XmlDocument)xmlDataDoc;
}
private XmlDocument GetUserRenewsXml(int id) {
string sql = "SELECT renews.id, renews.name " +
"FROM users_renews " +
"LEFT JOIN renews ON users_renews.id_renew = renews.id " +
"WHERE users_renews.id_user = " + id.ToString();
SqlConnection conn = Database.OpenConnection();
DataSet oDataSet = new DataSet("UserRenews");
SqlDataAdapter oDataAd = new SqlDataAdapter(sql, conn);
oDataAd.Fill(oDataSet, "Renew");
conn.Close();
XmlDataDocument xmlDataDoc = new XmlDataDocument(oDataSet);
return (XmlDocument)xmlDataDoc;
}
private XmlDocument GetUserXml(int id) {
string sql = "SELECT * FROM users WHERE id = " + id.ToString();
SqlConnection conn = Database.OpenConnection();
DataSet oDataSet = new DataSet("Users");
SqlDataAdapter oDataAd = new SqlDataAdapter(sql, conn);
oDataAd.Fill(oDataSet, "User");
conn.Close();
XmlDataDocument xmlDataDoc = new XmlDataDocument(oDataSet);
return (XmlDocument)xmlDataDoc;
____________________________________________________________________________________________________
private XmlDocument GetAllRenewsXml() {
string sql = "SELECT id, name " +
"FROM renews " +
"WHERE deleted = 0" +
"ORDER BY type, priority, code_name";
SqlConnection conn = Database.OpenConnection();
DataSet oDataSet = new DataSet("AllRenews");
SqlDataAdapter oDataAd = new SqlDataAdapter(sql, conn);
oDataAd.Fill(oDataSet, "Renew");
conn.Close();
XmlDataDocument xmlDataDoc = new XmlDataDocument(oDataSet);
return (XmlDocument)xmlDataDoc;
}
private XmlDocument GetUserRenewsXml(int id) {
string sql = "SELECT renews.id, renews.name " +
"FROM users_renews " +
"LEFT JOIN renews ON users_renews.id_renew = renews.id " +
"WHERE users_renews.id_user = " + id.ToString();
SqlConnection conn = Database.OpenConnection();
DataSet oDataSet = new DataSet("UserRenews");
SqlDataAdapter oDataAd = new SqlDataAdapter(sql, conn);
oDataAd.Fill(oDataSet, "Renew");
conn.Close();
XmlDataDocument xmlDataDoc = new XmlDataDocument(oDataSet);
return (XmlDocument)xmlDataDoc;
}
private XmlDocument GetUserXml(int id) {
string sql = "SELECT * FROM users WHERE id = " + id.ToString();
SqlConnection conn = Database.OpenConnection();
DataSet oDataSet = new DataSet("Users");
SqlDataAdapter oDataAd = new SqlDataAdapter(sql, conn);
oDataAd.Fill(oDataSet, "User");
conn.Close();
XmlDataDocument xmlDataDoc = new XmlDataDocument(oDataSet);
return (XmlDocument)xmlDataDoc;