blocks|key|4961859|text|我认为这将取决于情况，例如从您的基本查询返回的数据量，如果您正在对数据进行大量过滤，您会希望尽可能接近数据库。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4961860|此外，存储的proc将允许您在不重新部署应用程序的情况下更改查询。|4961861|但是，您可能会觉得在代码中或在数据集上进行筛选会更方便。|4961862|如果加载了数据库服务器，则应用程序的过滤速度可能会更快。|4961863|性能可能表明，在大多数情况下，您在数据库方面会做得更好。|4961864|entityMap^0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|M|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|N|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|O|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|P|8|@]|9|@]|A|$]]|$1|J|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|K|$]]

I think that would depend on the situation, such as ammount of data being returned from your basic query, if you are heavilly filtering the data you would want that done as close to the database as possible.

Also a stored proc would allow you to change the query without redeploying your application. 

However you might feel more comfortable doing your filtering in code or on the dataset.

If the database server was loaded then the the application would probably be faster at filtering.

Performance would probably dictate that you would be better off at the database in most circumstances.

blocks|key|3492775|text|你会执行什么类型的操作来获得“最终结果”？在数据库端执行大量工作通常比在数据库端处理大量数据然后执行一些操作(或者更糟，主要过滤)要快得多。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3492776|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

What type of operations will you perform to get the "final result?" Performing the bulk of the work on the database side is generally faster rather than bringing over loads of data then performing some manipulation (or worse, major filtration) that could've been handled on the database end.

blocks|key|1176769|text|您可以使用DataSet对象来实现此目的。调用存储过程并使用DataAdapter.Fill方法和填充DataSet对象|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1176770|可以使用以下命令分配网格视图的数据源|1176771|DataSource+roperty|1176772|如果需要循环访问datatable，可以使用dataset中的相应datatable来完成。|1176773|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|J|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|K|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|L|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|M|8|@]|9|@]|A|$]]|$1|H|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|I|$]]

You can use a DataSet object for this purpose. Call the stored procedure and fill the DataSet object using DataAdapter.Fill method and

you can assign the datasource of the gridview using 

DataSource roperty.

If you need to iterate through the datatable it can be done using the corresponding datatable in your dataset.

blocks|key|3492839|text|我的选择是在iteration.Because的存储过程中做得更好。如果数据变得很高，proc是更好的选择。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3492840|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

My option is better to do in stored procedure for iteration.Because if the data goes high ,proc is the better option .

blocks|key|1176901|text|我相信，通过阅读一些关于最佳实践的知识，这个问题可能会得到更好的回答。我认为在你的情况下，你可能会考虑一个编程模型，它将帮助你定义一些最适合你的实践，以及你试图实现的目标。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1176902|在这种情况下，有几个问题，比如你要为你的代码写单元测试吗？关注点分离对你来说是一个问题吗？你的程序会有多大？|1176903|为什么不考虑像Model+View+Presenter这样的最佳实践方法，有时称为Supervising+Controller+or+Passive+View，或者像ASP.NET+MVC这样更结构化的ASP.NET框架，在这些框架中，您可能会发现最佳实践更容易遵循。|offset|length|1176904|entityMap|0|LINK|mutability|MUTABLE|url|http://msdn.microsoft.com/en-us/magazine/cc188690.aspx|1|http://martinfowler.com/eaaDev/ModelViewPresenter.html^0|0|0|7|K|0|15|12|1|0^^$0|@$1|2|3|4|5|6|7|R|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|S|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|T|8|@]|9|@$F|U|G|V|1|W]|$F|X|G|Y|1|Z]]|A|$]]|$1|H|3|-4|5|6|7|10|8|@]|9|@]|A|$]]]|I|$J|$5|K|L|M|A|$N|O]]|P|$5|K|L|M|A|$N|Q]]]]

I'm sure this question might be better answered by reading a little about best practices. I think in your situation you might look into a programming model that will help you define some practices that best suit you and what you're trying to achieve. 

In this case there are a few questions like are you going to write unit tests for your code? Is Seperation of Concerns an issue for you? How large is your program going to be?

Why not look to a best practice like approach like the <a href="http://msdn.microsoft.com/en-us/magazine/cc188690.aspx" rel="nofollow noreferrer">Model View Presenter</a>, sometimes called the <a href="http://martinfowler.com/eaaDev/ModelViewPresenter.html" rel="nofollow noreferrer">Supervising Controller or Passive View</a> or a more structured framework for ASP.NET like ASP.NET MVC where you might find that best practices are a lot easier to follow.

blocks|key|1184470|text|我将使用情况1，但我也会尽量避免迭代数据，并在一个或几个查询中完成所有操作。对SQL+server数据库进行迭代并不快，并且离数据越远，它就变得越慢(就像在gui中迭代并调用调用数据库的业务层)。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1184471|这就是我尝试去做的方式。|1184472|1184473|创建临时表|ordered-list-item|1184474|使用筛选器将基本查询中的数据放入临时表中，并执行所有可能的操作。|1184475|如果我无法执行基本查询中的所有操作，则我将对临时表执行某些设置操作|1184476|将临时表返回到调用应用程序|1184477|<代码>G29|1184478|像这样|1184479|CREATE+PROC+myProc+@myParam+int
AS
CREATE+TABLE+#temp1(myCol+int)+
--only+get+the+required+data+and+apply+any+operations
INSERT+INTO+#temp1+(myCol)+
SELECT+myCol+FROM+myTable+WHERE+myCol2=@myParam+


UPDATE+#temp1+--do+any+operation+on+the+temporary+table

SELECT+myCol+FROM+#temp1+--apply+any+additional+filter+or+operations
GO|code-block|syntax|javascript|1184480|entityMap^0|0|0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Y|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|Z|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|10|8|@]|9|@]|A|$]]|$1|E|3|F|5|G|7|11|8|@]|9|@]|A|$]]|$1|H|3|I|5|G|7|12|8|@]|9|@]|A|$]]|$1|J|3|K|5|G|7|13|8|@]|9|@]|A|$]]|$1|L|3|M|5|G|7|14|8|@]|9|@]|A|$]]|$1|N|3|O|5|6|7|15|8|@]|9|@]|A|$]]|$1|P|3|Q|5|6|7|16|8|@]|9|@]|A|$]]|$1|R|3|S|5|T|7|17|8|@]|9|@]|A|$U|V]]|$1|W|3|-4|5|6|7|18|8|@]|9|@]|A|$]]]|X|$]]

I would use case 1, but I also would try to avoid iterating the data and do all operations in one or a couple of queries. Iterating against an SQL server database is not quick, and the further away from the data, the slower it gets (like iterating in the gui and call a business layer that calls the databas).

This is how i would try to do it.

<ol>
<li>Create a temprary table</li>
<li>Get the data from your basic query with a filter into the temporary table and do all possible operations.</li>
<li>If i cant do all operations in your basic query, then I would perform some set operation on the temporary table</li>
<li>Return the temporary table to the calling application</li>
</ol>

Like this

<pre><code>CREATE PROC myProc @myParam int
AS
CREATE TABLE #temp1(myCol int) 
--only get the required data and apply any operations
INSERT INTO #temp1 (myCol) 
SELECT myCol FROM myTable WHERE myCol2=@myParam 


UPDATE #temp1 --do any operation on the temporary table

SELECT myCol FROM #temp1 --apply any additional filter or operations
GO
</code></pre>

I am working on ASP.NET 2.0 application with c# language.

Can anyone tell me which is the best way of the following :
scenario:
I need to get data from the database and bind it to the grid view.

case 1:
I can use a stored procedure(for iteraing the result which is obtained from the basic query and do operations on this result set) for getting the final result.

case 2:
I can get the result ( obtained from the basic query) and do the iteration and operations in the code behind file.

Please let me know which case is best way of good programming.

Thanks
Rupa

calling a procedure or handling in code behind - which is better?

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

教程

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云智能顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云AI代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

功能1上新10个字符

功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符。

功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符。

功能5描述100个字符功能5描述100个字符功能5描述100个字符功能5描述100个字符功能5描述100个字符功能5描述100个字符

功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符

功能4上新

文章&问答评论现已支持表情

全新交互，全新视觉，新增快捷键、悬浮工具栏、高亮块等功能并同时优化现有功能，全面提升创作效率和体验

社区富文本编辑器全新改版！诚邀体验～ 

精选全网热门MCP server，让你的AI更好用 🚀

💥开发者 MCP广场重磅上线！

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

聚焦“写作效率、视觉美观与运行性能”三方面进行全面升级，为您提供更高效、稳定的创作环境

社区富文本&Markdown编辑器全新改版上线，欢迎大家体验!

诚挚邀请您参与本次调研，分享您的真实使用感受与建议。您的反馈至关重要，感谢您的支持与参与！

社区新版编辑器体验调研

我正在用c#语言开发ASP.NET 2.0应用程序。谁能告诉我以下哪种方法最好:场景:我需要从数据库获取数据并将其绑定到网格视图。案例1:我可以使用存储过程(用于迭代从基本查询获得的结果并对此结果集执行操作)来获得最终结果。案例2:我可以获得结果(从基本查询中获得)，并在代码隐藏文件中进行迭代和操作。请让我知道哪种情况是最好的编程方式。谢谢Rupa

问调用过程还是在后台代码中处理-哪个更好？
EN

回答 6

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问调用过程还是在后台代码中处理-哪个更好？EN

回答 6

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问调用过程还是在后台代码中处理-哪个更好？
EN