ASP.NET Á¬½ÓSQLÊý¾Ý¿âÎÊÌâ
ÎÊÌ⣺ASP.NET³ÌÐò£¬ÓÃADO.NET·ÃÎÊSQLÊý¾Ý¿â£¬ÓÃVB.NETÓïÑÔ±àд´úÂë¡£
´úÂëÈçÏ£º
Imports System.Data
Imports System.Data.OleDb
Imports system.Data.Sql
Imports System.Web.UI
Imports System.Web
Imports Microsoft.VisualBasic
Imports System
Imports System.Collections
Imports System.ComponentModel
Imports System.Reflection
Imports System.Data.SqlClient
Dim Server As String
Dim Uid As String
Dim Pwd As String
Dim Gdatabase As String
Server = "WWW-WGYS" '·þÎñÆ÷Ãû
Gdatabase = "wgysmulu" 'Êý¾Ý¿âÃû
Uid = ""
Pwd = ""
Cn.ConnectionString = "Driver={SQL Server};Server=" & Server & ";Database=" & Gdatabase & " ;Uid=" & Uid & ";Pwd=" & Pwd
Cn.Open()
´íÎóÌáʾ£º [Microsoft][ODBC SQL Server Driver][SQL Server]ÎÞ·¨´ò¿ªµÇ¼ËùÇëÇóµÄÊý¾Ý¿â "wgysmulu "¡£µÇ¼ʧ°Ü
²»ÖªÎªºÎ£¿
ÏàͬµÄ´úÂëÔÚVB 6.0ÉÏÈ´¿ÉÒÔ·ÃÎÊ£¬ÓÖ²»ÖªÎªºÎ£¿
²¹³äÒ»¸öÉùÃ÷´úÂ룺
Public Cn As New ADODB.Connection '¶¨ÒåÖ÷Á¬½Ó
vb????????//²»»á£¡°ï涥һϣ¡
ÓÐûÓÐʵÀýÃûÒª¼ÓʵÀýÃû ip\ʵÀýÃû
---------------------------------------
Asp.Net,C#,SQL,JS,WCF,AJAX,¹¤×÷Á÷,WPF,MVC,LINQ,Éè¼ÆÄ£Ê½(
Ïà¹ØÎÊ´ð£º
function CheckOpwd(){//ÑéÖ¤Óû§Ãû
var pwd=document.all.txtOpwd;
var div1=document.getElementById("divPwd");
if (pwd.value=="")
{
......
½ñÌì×öÁËÒ»¸ö´æ´¢¹ý³Ì »·¾³ÊÇSQL2000Êý¾Ý¿â
´óÖÂÈçÏÂ
½¨Á¢ÁÙʱ±í
¶¨ÒåÔ±¹¤Óαê
Ñ»·Ô±¹¤£¨ÊôÓÚ1¸ö¹«Ë¾)
......
´ÓÊý¾Ý¿âÖвéѯһÕűíµÄÊý¾Ý
select ²¿ÃÅ,ÐÕÃû from tb
ÈçºÎ²ÅÄÜÉú³ÉÏÂÃæµÄxml¸ñʽ
XML code:
<folder state="unchecked" label="È«²¿">
¡¡¡¡ <folder state="unchecked&qu ......
tab1 ×Ö¶Î:billdate,goodsid,incount,inmoney,outcount,outmoney,endprice,endcount,endamt
tab2 ×Ö¶Î:goodsid,goodskind£¨ÉÌÆ·ÀàÐÍ£©
tab3 ×Ö¶Î:goodskind£¨ÉÌÆ·ÀàÐÍ£©,kindname
½á¹û£º
µÃµ½ÉÌÆ·ÀàÐÍÔÚÒ»¶Îʱ¼ä ......
ÎÒÏëʵÏÖÒ»¸öЧ¹ûÊÇ£ºÄܰÑÒ³Ãæ·Ö³É¼¸¸ö´ó¿é£¬µãÏ´ó¿éÉϵÄ+±ãÕ¹¿ª£¬µãÏÂ-±ãÕÛµþ¡£
Õâ¸öÓÐʲô¿Ø¼þ¿ÉÒÔÓò»£¬Çë¸ßÊÖ²»Áߴͽ̣¡
ÓÃjs´úÂëÀ´ ¿ØÖÆ divµÄ¶¯×÷´Ó¶øÄÜʵÏÖ
js¿ØÖÆdivÏÔʾ/Òþ²ØÁË
VS2008×Ô´ø·â×°Á ......