DwZone Forum DwZone Forum
Welcome to the DwZone-it Forum
 
  FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups  
    RegisterRegister -->   LoginLogin  
Ajax DataGrid  
DwZone Forum Index -> Ajax DataGrid
.
Moderators: AdministratorsModerators 
Hint: For improved responsiveness, use Internet Explorer 4 (or above) with Javascript enabled, choose 'Dynamic' from the View dropdown and hit 'Set Options' to save your changes.
New Topic Search for
 View     Per page     Messages Since 
Messages 31 to 40 of 96 (Total: 94) First |  Prev |  Next |  Last  
 Subject Author Date  
   Re: DataGrid not displaying in page (page is blank)  
View this persons public profile  Gianluigi   8:08 3 Jul 2015  
   Re: DataGrid not displaying in page (page is blank)  
View this persons public profile  Esperanza   7:08 6 Oct 2016  
   Re: DataGrid not displaying in page (page is blank)  
View this persons public profile  Gianluigi   11:53 6 Oct 2016  
   how to remove message on update  
View this persons public profile  ulises   7:05 8 Jun 2015  
   Re: how to remove message on update  
View this persons public profile  Gianluigi   10:09 8 Jun 2015  
    Did not get Dynamicly data as URL  
View this persons public profile  Andreas   9:22 21 Apr 2015  
 
Hi there. I will post my code from an easy DataGrid. There is a LINK on a field. The LINK should geht the data DYNAMICLY from database like this: goto.asp?Postalcode=<% etc PLC %> so the grid should make the data on the LINK dynamic (each Postalcode ...). BUT at the MOMENT there is on EVERY ROW the SAME FIRST LINK! From database.
I have created the Grid with the tool and maked it with the Tool. Here is my code, what is wrong? Can i Post an Image to Show this...?!



<%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"%>
<!--#include file="../dwzGrid/AspAjaxDataGrid.asp" -->
<!--#include file="../Connections/DB_AKi203.asp" -->
<%
' Connection-String
'Dim MM_DB_AKi203_STRING
'MM_DB_AKi203_STRING = "Provider=SQLNCLI;Server=WSAH2\hyta02;Database=DB_AHi203;Trusted_Connection=yes;"
' Connection-String
Dim MM_conDBAKi203_STRING
MM_conDBAKi203_STRING = "Provider=SQLNCLI;Server=WSAH2\hyta02;Database=DB_AHi203;Trusted_Connection=yes;"
%>
<%
Dim Recordset1
Dim Recordset1_cmd
Dim Recordset1_numRows

Set Recordset1_cmd = Server.CreateObject ("ADODB.Command")
Recordset1_cmd.ActiveConnection = MM_DB_AKi203_STRING
Recordset1_cmd.CommandText = "SELECT * FROM dbo.V_CIB_FID_O ORDER BY MMSENGNO ASC"
Recordset1_cmd.Prepared = true

Set Recordset1 = Recordset1_cmd.Execute
Recordset1_numRows = 0
%>

<%
'******************************
'http://www.DwZone-it.com
'AspAjax DataGrid
'Version 1.4.20
'******************************

Dim dwzGrid_1
Set dwzGrid_1 = new dwzAspAjaxDataGrid
dwzGrid_1.Init()
dwzGrid_1.SetInstance "1"
dwzGrid_1.SetRootPath "../"
dwzGrid_1.SetCnString MM_conDBAKi203_STRING
dwzGrid_1.SetEditPar "void|_@_|void|_@_||_@_|IDNR|_@_|ALL|_@_|false"

dwzGrid_1.Add "MMSEWW02", "dddddddd", "333", "String", "Left", "N", "N", "N|_@_|Y|_@_|50|_@_|3|_@_|TextBox|_@_||_@_||_@_||_@_||_@_||_@_||_@_|Void|_@_||_@_|false|_@_||_@_||_@_||_@_||_@_||_@_||_@_|20|_@_|12|_@_|201.asp?test=" + (Recordset1.Fields.Item("IP_STRHN").Value) + "&test2=" + (Recordset1.Fields.Item("IP_ORT01").Value) + "&test3=" + (Recordset1.Fields.Item("IP_PLZ01").Value) + "|_@_||_@_|None|_@_|rec_placeholder|_@_|Y|_@_|None|_@_|None|_@_|"

dwzGrid_1.AddDetailPar ""
dwzGrid_1.AddDetailFields ""
dwzGrid_1.SaveDelete()


%>


<%
'******************************
' http://www.DwZone-it.com
' AspAjax DataGrid
'******************************
dwzGridSkin = "black-tie"
'******************************
' http://www.DwZone-it.com
' AspAjax DataGrid
'******************************
%>




<%
'******************************
' http://www.DwZone-it.com
' AspAjax DataGrid
' Version 1.4.20
'******************************

dwzGrid_1.AddEditRecordset "MMSEWW02", Null
dwzGrid_1.SetRecordset Recordset1
dwzGrid_1.SetDetailRecordset Null
dwzGrid_1.SetMainPar "400|_@_|250|_@_|void|_@_|false|_@_|false|_@_|false|_@_|false|_@_|false|_@_|false|_@_|false|_@_|false|_@_|false|_@_|false|_@_|false|_@_|false|_@_|false|_@_|false|_@_|false|_@_|15|_@_|10,15,20,25,40|_@_||_@_|Form|_@_|en|_@_|utf-8;65001;Unicode (UTF-8)|_@_|%|_@_|#|_@_||_@_|false|_@_|Required|_@_|Max length must be {1}|_@_|Text format|_@_|Date format|_@_|Min value must be {1}|_@_|Max value must be {1}|_@_|Not the first item|_@_|false|_@_||_@_|false|_@_|false|_@_|false|_@_|false|_@_|false|_@_|,|_@_|No|_@_|false|_@_|root|_@_|row|_@_|Nodes|_@_|false|_@_|Arial;12;#000000;false;false;false;#FFFFFF|_@_|Arial;12;#000000;false;false;false;#FFFFFF;0;#000000;0,3|_@_|A4;L;25;25;25;25;false;Center;1|_@_|No|_@_||_@_||_@_||_@_|#000000|_@_|0.6|_@_|10|_@_|350|_@_|_s|_@_|false|_@_|None|_@_|<b>{0} - {1} Item(s)</b>|_@_|false|_@_|false|_@_|false|_@_|false|_@_|false|_@_|ASC|_@_|false|_@_|false|_@_||_@_||_@_||_@_||_@_|false|_@_|false|_@_|false|_@_|0|_@_|false|_@_|false|_@_||_@_||_@_||_@_|false"
dwzGrid_1.CreateData()
%>
<%
Dim Repeat1__numRows
Dim Repeat1__index

Repeat1__numRows = -1
Repeat1__index = 0
Recordset1_numRows = Recordset1_numRows + Repeat1__numRows
%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Test</title>
<%
'******************************
' http://www.DwZone-it.com
' AspAjax DataGrid
'******************************
dwzGrid_1.GetHeadCode()
'******************************
' AspAjax DataGrid
'******************************
%>
</head>

<body>




<%
'******************************
' http://www.DwZone-it.com
' AspAjax DataGrid
'******************************
dwzGrid_1.CreateGrid()
'******************************
' http://www.DwZone-it.com
' AspAjax DataGrid
'******************************
%>



</body>
</html>


<%
Recordset1.Close()
Set Recordset1 = Nothing
%>

<%
'******************************
' http://www.DwZone-it.com
' AspAjax DataGrid
'******************************
Set dwzGrid_1 = nothing
%>

 
Reply to this current thread  View this persons public profile  Send Private Message
   Re: Did not get Dynamicly data as URL  
View this persons public profile  Andreas   9:40 21 Apr 2015  
   Search and then create record on other table  
View this persons public profile  ulises   6:53 27 Mar 2015  
   Re: Search and then create record on other table  
View this persons public profile  Gianluigi   10:51 27 Mar 2015  
   datagrid pops blank  
View this persons public profile  ulises   13:18 26 Mar 2015  
Last Visit: Saturday 4 May, 2024 5:51 am First |  Prev |  Next |  Last  
 Login
Username:  Password:    
Read Message Read Message   Unread message Unread message
Read message [popular] Read message [popular]   Unread message [popular] Unread message [popular]
Read message [locked] Read message [locked]   Unread message [locked] Unread message [locked]
All times are GMT-2

Jump to: