<% dim CnnBill ,cmd set CnnBill =server.createobject("adodb.connection") set rs =server.createobject("adodb.Recordset") CnnBill.open "provider = sqloledb ;user id =sa ;initial catalog = krt" If Request.Form("Save")<>"" Then Save() End IF Private Sub Save dim cmdbill set cmd =server.createobject ("adodb.command") cmd.activeconnection = CnnBill cmd.commandtext = "SP_insert_Visitors" cmd.commandtype = 4 cmd.parameters("@VisitorName") = Request.Form("VisitorName") cmd.parameters("@Notes") =Request.Form("Notes") cmd.execute Response.Redirect "Visit.asp" End Sub %> ولاية الخرطوم - عن السودان

 

 

 

الاسم :

 

 

 

الاقتراح:

<% rs.open "Select * from Visitors order by VisitID desc",CnnBill,1,1 %> <%if rs.eof or rs.bof then%> <% Else dim str strBgColor = "#EDFED8" While Not rs.EOF if strBgColor = "#EDFED8" then strBgColor = "#D0E7B6" else strBgColor = "#EDFED8" end if str =rs("VisitorName") & " ( " & rs("visitDate") & " )"%> <% rs.movenext() wend end if %>

 

سجل الزوار


عفواً سجل الزوار خالي
<%=str %>
<%=rs("Notes")%>
سجل الزوار