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 %>
|
|
|