Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/-->
///
///
Converts a collection of query statements to a able object.
///
///
Query statement set
///
Query Result
Public
Static
Datatable getdataforsqls (system. Collections. Generic. List
String
>
Selectsqls ){
Using
(Sqlconnection Conn
=
New
Sqlconnection (connectionstring )){Conn. open ();
Try
{Sqlcommand
Introduced:In the Web page, we often encounter the situation in. Select the province in the drop-down box first, and then the second drop-down box will automatically load the city in the province. This design greatly facilitates the user's search. So how does this work?1. Establish a database"Province" table"City" table2. Adding controls3, two drop-down boxes bind the data source separately protected void Page_Load (object sender, EventArgs e) {//Determines whether to enter the page for the
1 usingSystem;2 usingsystem.web;3 usingSystem.Web.Services;4 usingSystem.Web.Services.Protocols;5 usingSystem.Data.OleDb;6 usingSystem.Data;7 usingSystem.IO;8 9 Ten[WebService (Namespace ="http://tempuri.org/")] One[WebServiceBinding (ConformsTo =wsiprofiles.basicprofile1_1)] A Public classService:System.Web.Services.WebService - { - PublicService () { the - //If you are using a design component, uncomment the following line - //InitializeComponent (); - } + - //[
storage locations.
First, reveal the secret of Firefox Password Management. To meet the needs of developers to create applications that meet various Security standards, Mozilla developed an Open Source library called "Network Security Services" or "NSS. Firefox uses an API called Security Decoder Ring or SDR to encrypt and decrypt the account certificate. Although the name is very literary, let's take a look at how firefox uses it to encrypt. When a
Sqlconnection conn = new sqlconnection ("Server =.; uid = sa; Pwd = 123; database = 08_09cgywdb; connection timeout = 2 ");
Conn. open ();
Sqlcommand comm = new sqlcommand ("select object_name (ID) from sysobjects where xtype = 'U' and name like 'tbl20% 'order by name", Conn );
Sqldatareader SDR = comm. executereader ();
While (SDR. Read ()){// MessageBox. Show (SDR
To configure the database connection string in Webconfig, the code is as follows:
Copy Code code as follows:
Then get the connection string inside the Webform_1.aspx.cs to add the following reference;
Copy Code code as follows:
using System.Configuration;
using System.Data;
using System.Data.SqlClient;
Code:
Copy Code code as follows:
SqlConnection con;
protected void Page_Load (object sender, EventArgs e)
{
Connectdb ();
}
private void Connectdb ()
{
string c
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.