Visual Web Developer 05用户输入查询 [英] Visual Web Developer 05 User input Query

问题描述

您好，我甚至不知道这是否有人会在这里回答，但我想我给了她一个机会！


我是VWD的新手，我我迫切需要一些帮助。我已经搜索谷歌数小时无济于事，我不知道还有什么去看。我认为我的部分问题是我甚至不知道正确的术语是用于我想要的东西。


这里我的情景：

我有一个非常大的sql数据库，需要每周由几个不同的人查询。我是使用VWD 2005的新手，但是我觉得我可以通过教程等很好地掌握它，所以如果我的术语关闭，请原谅我。我可以在这个数据库上设置我自己的查询并运行它们，但问题是需要访问此数据库的人会希望始终运行不同的查询。 EX-''检查商店XX从此日期到此日期的销售额''另一个例外：''检查商店x，x，x，x，x，x，x，x从此日期到此日期的销售情况''另一个例如：''检查在此日期存储的所有优惠券的数量''

列表可以继续..所以我想创建一个表单，让他们轻松设置查询参数所以我会有一些文本框，可能是一些单选按钮和复选框，一旦提交按钮被点击，这些将成为查询的参数。


现在我不希望任何人都要抓住这个，但我只是想知道是否有人可能告诉我A-这个过程在技术上被称为什么，B-指向任何可能有关于这样一个过程的教程的页面，以及C-任何信息你感觉我会从中受益。



非常感谢您的任何时间，并度过美好的一天!!!

Hi there,I dont even know if this is something that anyone will answer on here but I thought Id give her a shot!

I am super new to VWD, and I am in desperate need of some assistance. I have searched google for hours to no avail, and I dont know where else to look. I think part of my problem is I dont even know what the correct terminology is to be used for what I am looking for.

Here my scenario:
I have a very large sql database that needs to be queried by a few different people on a weekly basis. I am new to using VWD 2005 but I feel I can grasp it quite well through tutorials, etc so forgive if me if my terminology is off. I can setup my own queries on this database and run them fine, but the problem is that the people that need to access this DB will want different queries run all the time. EX- ''check sales from store XX from this date to this date'' another ex: ''check sales from stores x,x,x,x,x,x,x,x from this date to this date'' another example: ''check amount of coupons used from all stored on this date''

The list could go on.. So I was thinking to create a form for them to easily set the query parameters So I would have some text boxes, maybe some radio buttons, and check boxes and those would be the parameters for the query once the submit button is hit.

Now I dont expect anyone to hold my hand through this, but I was just wondering if someone could possibly tell me A- what this process is technically called, B- point toward any page that maybe has a tutorial on such a process, and C- any information you feel would I would benefit from.


Thank you so much for any of your time, and have a great day!!!

推荐答案

我还没用你也指的微软新工具。我知道我认为它是什么。


您可能需要在VB.NET和ASP.NET中进行编码以创建表单，并处理参数并将其发送到您的SQL查询。


您将需要通过触发控件的某些事件上的代码来操纵数据。

I have yet to use Microsofts new tool you are referring too. I know what it is I think though.

You will likely need to do your coding in VB.NET and ASP.NET to create a form, and process the parameters and send them to your SQL querys.

You will need to manipulate the data by triggering code on certain events of the controls.

我还没有使用你所指的微软新工具。我知道我认为它是什么。


您可能需要在VB.NET和ASP.NET中进行编码以创建表单，并处理参数并将其发送到您的SQL查询。


您需要通过触发控件的某些事件的代码来操纵数据。

I have yet to use Microsofts new tool you are referring too. I know what it is I think though.

You will likely need to do your coding in VB.NET and ASP.NET to create a form, and process the parameters and send them to your SQL querys.

You will need to manipulate the data by triggering code on certain events of the controls.

好​​的交易，一个良好的开端。当然，表单不是问题..它正在操纵我遇到问题的查询数据。我认为在VWD中设置查询时会有点简单，但我不知道如何做到这一点。我在大量的搜索中读到了将过滤器堡垒设置为某个字段的？。没有引号意味着用户必须输入该字段的查询字符串，但之后没有进一步解释用户如何将数据传递给它......所以我仍然迷路了！我仍然在网上搜索，仍然希望得到一些指示！


谢谢！

Good deal, off to a good start. The form is not a problem, of course.. its making manipulate the query data I am having problems with. I thought it would be something kind of simple while setting up the query in VWD but I don;t see too much on how to do it. I read somewhere in my tons of searching that setting the filter fort a certain field to "?" sans the quotes would mean that a user would have to input the query string for that field, but then did not explain further on how the user would pass that data to it... So I am still lost! and I am still searching online and still hoping for some pointers!

Thanks!

如果你不太担心安全性，你可以生成您的SQL查询字符串在运行中使用基于用户输入的简单字符串连接。


我宁愿建议你为SQL查询设置一些基础。类似于组的类似类似的查询并限制他们可以做什么和不能做什么。考虑到你想要的选择类型有多宽，也许这不是一个选择。


看起来你想要创建的是一个动态的SQL查询创建者。可行但不简单我不会想。


您对文本框/下拉菜单/单选按钮/等的想法可能在正确的轨道上。

If you are not worried about security too much, you can generate your SQL query string "on the fly" using simple string concatination based on user input.

I would much rather suggest that you set some groundwork for the SQL queries. Sort of like "group" similar queries and restrict what they can and cannot do. Maybe that''s not an options considering how broad a selection types you want.

Seems like what you would like to create is a dynamic sql query creator. Doable, but not simple I wouldn''t think.

Your idea for textboxes/dropdowns/radio buttons/etc is probably on the right track.

这篇关于Visual Web Developer 05用户输入查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！