-
Anonymous users2024-02-05Contact 26819801 and I'll take a look at that for you.
-
Anonymous users2024-02-04No problem, use asp to read out the data of excel and then write it to access, and it's OK.
-
Anonymous users2024-02-03With SQL statements:
The data submitted according to the button form (such as Zhang San, which generally passes a unique ID).
delete from table name where column name (name) = value (zhang san).
-
Anonymous users2024-02-02Try to add breakpoints to see the specific ** problem?
-
Anonymous users2024-02-01set conn="")
connstr
set rs = "")
sql="select * from main order by id desc" 'Here the id is in descending order and the asc is ascending
sql,conn,1,1
Set one record to be displayed on one page.
if not or not then
if request("page")<>"" thenepage=cint(request("page"))if epage<1 then epage=1if epage> then epage=elseepage=1
end if
end if
for i=0 to
if or then exit for><=%rs("name")%>
Next idea: What is achieved by pagination is that there is only one record on one page. You try it, I don't have a test environment here and can't experiment, so let's talk about it!
-
Anonymous users2024-01-31Add a field to the table, and the numeric one can be used for sorting from small to large or from large to small
You can click the button to change the sort value of the record, which also allows you to sort in batches
-
Anonymous users2024-01-30Use the onclik event, and then call a program function or procedure that detects the user name, such as onclick="checkuser()".
Program functions that detect user names, such as:
sub checkuser()
username=trim(request("username"))set rs="")
sqltext="select * from [table] where [username column]='"& username &"'"
sqltext,conn,1,1
if not( and then
)else)end if
end sub
Check buttons such as:
The principle of defining first and then using should be put in'checkuser() function, which is placed before the html tag of the check button.
-
Anonymous users2024-01-29All you need to do is add permissions to the web page! If you don't have permission, you can't enter the web page that the button refers to.!
You can make an information query system, if you haven't done it before, it is recommended to use ASP to write it first, this is relatively simple, even people who do not have a basic knowledge of network programming can get started in a short period of time. The written web program can be called on the network, and different permissions can be set for different users. In this way, you can achieve the function you want, but this is only the basic, and you should learn more deeply to achieve more complete functions. >>>More
The database is generally composed of many tables, for example, the school builds a database, which can build a student table (including the student's name, age, student number, class, date of birth), a teacher table (including the teacher's name, age, teaching class, teaching category), a report sheet (including the student's student number, and the grades of each subject), etc. These are the ways in which the files are stored in the database, and try to make sure that the items in a table are closely related and have the same attributes, if this condition cannot be met, a table must be built (the redundancy of the built table has 4 levels). In order to meet the user's query needs, we also need to make a number of views, for example, you can make a view of his items have the name of the student, age, grades of each subject, and the teacher of each subject, etc., we can also export new items according to the existing items, for the purpose of simplicity, for example, the view can add an average grade, we add different permissions and roles to each view, and provide it to different people to query to protect the security of the database. >>>More
Create a database.
Select the Program Management SQL Server 2008 SQL Server Management Studio command in the Start menu to open the SQL Server Management Studio window and establish a connection using Windows or SQL Server authentication. >>>More
First: you are lazy and push everything to someone else.
Second: There are no bonus points for your question. >>>More
function updatepage(targetobject){if( == 4){
var response = ;Assign the value returned by ajax to the responseIf you want to use this variable, you can call it directly, or you can return it outside of the function. >>>More