asp.netÈçºÎ²éѯÊý¾Ý¿âÐÅÏ¢
£¨Çë¸øÒ»¶ÎÍêÕû¿ÉÐеĴúÂ룩ÎÒÏëÒªÓÃasp.net C#²éѯsql server µÄÍêÕû³ÌÐò¶ÎC# code:
using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
namespace WebApplication2
{
/// <summary>
/// WebForm1 µÄժҪ˵Ã÷¡£
/// </summary>
public class WebForm1 : System.Web.UI.Page
{
protected System.Web.UI.WebControls.TextBox TextBox;
protected System.Data.SqlClient.SqlDataAdapter sqlDataAdapter1;
protected System.Data.SqlClient.SqlCommand sqlSelectCommand1;
protected System.Data.SqlClient.SqlCommand sqlInsertCommand1;
protected System.Web.UI.WebControls.Button Button1;
protected System.Data.SqlClient.SqlConnection sqlConnection1;
protected System.Data.SqlClient.SqlCommand sqlCommand1;
protected System.Web.UI.WebControls.DataGrid Grid1;
private void Page_Load(object sender, System.EventArgs e)
{
// ÔÚ´Ë´¦·ÅÖÃÓû§´úÂëÒÔ³õʼ»¯Ò³Ãæ
SqlConnection con = new SqlConnection("server=XCH;database=aaa;uid=sa;pwd=");
con.Open();
SqlDataAdapter da = new SqlDataAdapt
Ïà¹ØÎÊ´ð£º
function CheckOpwd(){//ÑéÖ¤Óû§Ãû
var pwd=document.all.txtOpwd;
var div1=document.getElementById("divPwd");
if (pwd.value=="")
{
......
<table style="width: 1000px"><tr>
<td style="height: 38px; width: 35px;">
ÐÕÃû</td>
......
id name gongzi
1 ÕÅÈý 1000
2 ÀîËÄ 2000
3 ÕÅÈý 2000
4 ÀîËÄ 3000
5 ÍõÎå 3000
ÎÒÓÐÕâÑùÒ»¸öÊý¾Ý¿â£¬ÏÖÔÚÎÒÒªsql²éѯµÄÊý¾ÝÊÇ ÕÅÈý£¬ÀîËÄ£¬ÍõÎåµÄ ºÏ¼ÆµÄ¹¤×Ê¡£¾ÍÊǰÑËûÃǵĺÍÇ ......
Ëæ×ÅIIsµÄÆô¶¯ ¶¨ÆÚµ÷ÓÃij¸ö·½·¨À´Éú³É¾²Ì¬Ò³£¬ÈçºÎʵÏÖ
¿ÉÒÔÔÚ Application_Start ʼþÀïÖ´ÐÐÄãµÄÉú³É²Ù×÷
µ«²»ÍƼöÕâô×ö,Äã¿ÉÒÔ×ö³É¶ÀÁ¢µÄ³ÌÐòÀ´ÔËÐÐÄãµÄÉú³É²Ù×÷
webdownload »ò Ä£°åÉú³É
»¹ÓÐ×Ô¶¯Éú³ ......
protected void btnLogin_Click(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection("Server = (local);user id = sa;pwd = 1;database = Login");
&nb ......