To sum up the DataGrid, datalist, Repeater
I. Differences between Data Access Controls1. repeater-> datalist-> DataGrid2. Function detailsAbility to bind and display basic data for ease of use, flexibility, and high autonomous SelectivityFive
1. The followingCodeImplement. Three columns are displayed in each row.
Front-end code:
Background code:Protected int I = 1; Private void page_load (Object sender, system. eventargs E){
xmlserializer SER = new xmlserializer (typeof (Dataset);
Use the image field to save these documents.VaRWord_stream: tmemorystream;Filename: string;BeginIf odgdoc. Execute then // odgdoc: opendialogBeginFilename: = extractfilename (odgdoc. filename );Word_stream: = tmemorystream.
Implementation of the button trigger event Method in datalist
1. Set the name in commandname, for example:
2. In datalist-> properties-> event tag-> double-click "itemcommand" (you can also define the name yourself)
3.CodeImplementation:
First, retrieve the Excel data, which is similar to the access operation. You can use olede, and then put the data in the datatable, and then bind it.SampleIf (! Ispostback){String strcon = "provider = Microsoft. jet. oledb.4.0; Data Source = "+
Repeater exports data in Excel format to repeater1. The following is an example of how to export repeater1 content.
Code
System. Io. stringwriter SW
=
New
System. Io. stringwriter ();System. Web. UI. htmltextwriter HW
=
New
The stored procedure can be used for implementation, that is, the output parameters of the stored procedure. For details, see the demonstration, creation process, and calling process to obtain the output parameters: -- create proc SSB @ flag int
In the DB environment of SQL Server 2005.
How to obtain: the last position where character B appears in the string abcefbpqbe.Can any function obtain this position?
Declare@ Str Varchar(8000),@ Search_str Varchar(10)
Select@ Str =
Today, I finally finished modifying the problem that has been entangled for several days. In the end, it is only a small problem, that is, a small attribute of adoquery.
Set the checkbox of a column in the control dbgrideh to true and
In the stored procedures of ms SQL Server, it is best to add transactions. This is not mentioned in General books. Pay attention to the following points:
Set xact_abort onBegin transcation/** SQL statement executed in the middleCode*/Commit
Adoquery usage in Delphi
We all know that Delphi is very useful in database operations. Delphi integrates some method attributes of ADO. The following is my summary: ************************************ SQL stored procedures: addWith
1. use an SQL statement to query the names of students whose scores are greater than 80 in each course. name kecheng fenshu Zhang San Chinese 81 Zhang San mathematics 75 Li Si Chinese 76 Li Si mathematics 90 Wang Wu Chinese 81 Wang Wu mathematics 100
Student (S #, Sname, Sage, Ssex) Student table Course (C #, Cname, T #) curriculum SC (S #, C #, score) Student table Teacher (T #, tname) Instructor table questions: 1. query the student ID of all students whose score is higher than that of the "002
Environmental Systems Research Institute, Inc. founded in 1969 and headquartered in RedLands, California, ESRI is the world's largest Geographic Information System GIS technology provider. ESRI China (Beijing) Co., Ltd. is the only branch of ESRI in
Author: Flyingis
You are welcome to repost this article, but please note the author and original article links,
Prohibited for commercial purposes! WGS 1984 is one of the commonly used coordinate systems for 3 S applications and is closely related
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.
A Free Trial That Lets You Build Big!
Start building with 50+ products and up to 12 months usage for Elastic Compute Service