如何使用包含ADO.net连接模式中的参数的查询从数据表中读取数据 [英] how to read data from a datatable using query consisting parameters in ADO.net connected mode

问题描述

我是ADO.net的新手。我已经学习了连接模式下的编程。现在我正在学习ADO.net断开连接模式。我现在面临一个问题： - 我有一个数据表名称Info。它有四个字段： - ID，名称，地址。现在我希望当用户编写ID号并单击按钮时，其他两个文本框将显示相应的名称和地址。我认为SQL语句应该像

I am new to ADO.net. I have learned programming in Connected mode. Now i am learning ADO.net disconnected mode. I am facing a problem now:- I have a datatable name "Info". It has four fields :- "ID","Name","Address". Now i want that when user write a ID number and click on button then other two textboxes will show corresponding Name and address. I think SQL statement should be like

SqlCommand cmd = new SqlCommand();
    Cmd.CommandText = "Select Name, Address from Info where ID = @id";
    cmd.Parameters.AddWithValue("id", TextBox1.Text);

我正在使用我的连接模式ADO.net体验编写上面的代码。我们在连接模式下使用了Datareader。但是我们不能在Disconnected模式下使用DATAREADER，所以如何才能完成。请帮帮我..



还告诉我一个很好的链接，我可以学习INSERT，UPDATE和删除操作使用（i）SQLDataAdapter（ii）SqlCommandBuilder



我已经google了很多很好的教程，但每个人都有自己的编码和逻辑风格因此我真的很困惑...

I am writing above code using my connected mode ADO.net Experience. We used a Datareader in Connected mode. But we cannot use DATAREADER in Disconnected mode so how can it be done. Please help me..

Also told me a good link where i can learn INSERT, UPDATE and Delete operation using (i)SQLDataAdapter (ii) SqlCommandBuilder

I have googled alot for good tutorial but everyone has own style of coding and logic therefore i am really confused...

推荐答案

这对我来说很好（我在学校）。你不期待只有一张唱片吗？所以用DataReader读取它并断开连接。有什么问题？



但是，我想知道为什么用户需要输入ID - 在我看来用户应该永远不知道任何ID。

That looks OK to me (I''m olde school). Aren''t you expecting only one record back? So read it with a DataReader and disconnect. What''s the problem?

However, I wonder why the user would need to enter an ID -- in my opinion users should never know any IDs.

这篇关于如何使用包含ADO.net连接模式中的参数的查询从数据表中读取数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！