Mode one: Use SqlDataAdapter
SqlDataAdapter SDA = new SqlDataAdapter ();
DataSet ds = new DataSet ();
Sda. Fill (DS);//fill DataSet: If the result set has more than one, correspond to multiple table//In the DataSet
two: Use SqlDataReader
sqldatareader SDR = cmd. ExecuteReader ();
if (SDR). HasRows)
{while
(
Label:. aspx , C1 Read value if (! IsPostBack){ int id = convert.toint32 (request.querystring["infoid"]);Dataaccess.da DAC = new Dataaccess.da ();Dac.con.Open ();SqlCommand cmd = new SqlCommand ("SELECT * FROM table where id =" + id + "");Cmd. Connection = Dac.con;SqlDataReader SDR = cmd. ExecuteReader ();Sdr. Read ();Txttitle. Text = sdr["Xtitle"]. ToString (
;}
Method is called:
1 2 3 4 5 P align= ' left ' >6 7 8 9 10
staticvoidmain (string[] args) { person person = new Person (1, "Flyelephant", "Beijing"); user User = Newuser (); user. Id =; user = convertobject (user, person); console.writeline ("Id:" + user . Id + "Name:" + user. Name + "role:" + user. Group); system.console.read (); NBSP;NBSP;NBSP;NBSP;NBSP;NBSP;} NBSP;NBSP;NBSP;NBSP;NBSP;
2. I used to go back to SqlHelper when I wa
Commandbehavior. closeconnection is used to ensure that the connection is also disabled when datareader is disabled.
Public static sqldatareader (.....)
{Sqlcommand cmd = new sqlcommand ();Sqlconnection conn = new sqlconnection (connectionstring );
// We use a try/catch here because if the method throws an exception we want// Close the connection throw code, because no datareader will exist, hence// Commandbehaviour. closeconnection will not work Try{Preparecommand (CMD, Conn, null, struct
System.Configuration;Using firstmvc.models;//Note adding referencesNamespace Firstmvc.controllers{The first instance of the MVC schemaRecent exposure to MVC, see most tutorials TakeLinqtosql, here's an ADO way of writingAuthor:luckyhuDate:2012-03-30public class Membercontroller:controller{//GET:/menber/Define some global variablesString connstr = configurationmanager.connectionstrings["ConnectionString"]. ConnectionString;SqlConnection conn = null;SqlCommand cmd = null;SqlDataReader
Asp.net| Stored Procedures
Recently met some friends in csdn to ask the method of the stored procedure on the ASP.net, here will my experience summed up and the release of processing for your reference.
The basic idea is to get the parameters of the stored procedure, then collect the values based on the parameter table, and then call the stored procedure. However, the control ID required in the page must be consistent with the parameters of the stored procedure. And there are several ways to inv
ASP. NET -- Implement Dynamic Interaction between two drop-down boxes and asp.net drop-down boxes
Introduction:
We often encounter problems on webpages. First, select the province in the drop-down box. Then, the second drop-down box will automatically load the city in the province. This design greatly facilitates user search. How is this implemented?
1. Create a database
"Province" table
City table
2. Add controls
3. Bind data sources in the two drop-down boxes
Protected void Page_Load (o
Configure the database connection string in WebConfig. The Code is as follows:
Then obtain the connection string in Webform_1.aspx.cs and add the following reference;
Using System. Configuration;Using System. Data;Using System. Data. SqlClient;
Code:
SqlConnection con;
Protected void Page_Load (object sender, EventArgs e){ConnectDB ();}
Private void ConnectDB (){String ConString = ConfigurationManager. ConnectionStrings ["ConnectionString"]. ConnectionString;Con = new SqlConnection (ConString
See a post:SqlDataReader ShutdownEveryone seems confused about the link closure problem. Here we will explain it:
No matter what xxDataReader is, It inherits the implementation of DataReader, so there are commonalities, so the title is titled DataReader.
Case 1: The default link of DataReader is not closed.
Sample Code:Static void Main (string [] args)
{
SqlConnection con = new SqlConnection ("server =.; database = MySpace; uid = sa; pwd = 123456 ");
Con. Open ();
SqlCommand com = new SqlComm
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.