Á¬½ÓaccessÊý¾Ý¿â¼ìÑéÕ˺ÅÎÊÌâ
Public Class loginform1
Dim strCon As String = "Provider = Microsoft.Jet.OLEDB.4.0;Data Source =8021.mdb"
Dim strCom1 As String = " SELECT * from loginname "
Private Sub OK_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles OK.Click
If ComboBox1.Text = "Íø°ÉÓû§" Then
Form1.Show()
Me.Hide()
Else
Dim myConn As OleDbConnection = New OleDbConnection()
myConn.ConnectionString = strCon
myConn.Open()
Dim strselect As String = "select * from loginname where username='" & Trim(ComboBox1.Text) & "'and pd='" & Trim(textbox1.Text) & "'"
Dim da As New OleDbDataAdapter(strselect, myConn)
Dim ds As New DataSet()
da.Fill(ds)
If ds.Tables(0).Rows.Count = 0 Then
MsgBox("ÄãÊäÈëµÄÕʺŻòÃÜÂëÓÐÎó£¡", , &q
Ïà¹ØÎÊ´ð£º
ÄÄÀï³ö´íÁË£¬Êä³öÕâÑùµÄ½á¹û£¿£¿
<%@ Page Language="VB" AutoEventWireup="false" aspcompat="true" CodeFile="Default.aspx.vb" Inherits="_Default" %&g ......
ÔÚMSSQLÖУ¬ÎÒÃÇ¿ÉÒÔÒ»´Î²éѯ¶à¸öÊý¾Ý±í²¢¼ÓÈëµ½Êý¾Ý¼¯ÖУ¬ÖмäÖ»ÐèÓ÷ֺŸô¿ª£®È磺
£¢select * from A;select * from B;select * from C£¢,Ìî³äÊý¾Ý¼¯ºóÔÚDSÖоÍÓÐÁËÈýÕÅ±í£®
µ«ÔÚÓÃͬÑùµÄÓï¾ä·ÃÎÊACCESSÊý¾ ......
µÚÒ»´Î½Ó´¥CrystalReport
¼±Ñ°ÕÒVb.net Access ͨ¹ý²éѯ³öµÄÊý¾ÝÊä³öµ½CrystalReportµÄÀý×Ó.
ÓеÄÅóÓÑÂé·³·¢À´Ñ§Ï°.¶àл!
¸úÄãµÄÒªÇó²î²»¶à£¬²Î¿¼Ò»Ï£º
http://topic.csdn.net/u/20090823/21/87af02d3-f4ca-480 ......
dwr.xml:
<create creator="struts" javascript="PrisonerActionForm">
<param name="formBean" value="prisonerForm"/>
< ......