visual studio 2010 - How to create DropDownList in VS2010 .NET 4.0 Dynamic Data Website -


i'm newbie visual studio 2010 .net 4.0 dynamic data. i'm trying simple dropdown list web site (written in c#).

i've got field called protocol (as in tcp-protocol). want user able choose 1 of static values. in olden days classic asp , html have used this:

<form name=form1 method="post" action="./insert.asp"> ... <select name="protocol" size="1"> <option value="https" selected>https <option value="sftp">sftp <option value="ftps">ftps </select> ... </form>

... , handled database in ./insert.asp.

so far i've found instruction on how in visual studio 2008 (.net 3.5), doesn't work in ws2010 , .net 4.0: http://csharpbits.notaclue.net/2008/07/dynamic-data-and-field-templates-your.html

following instructions in http://www.asp.net/web-forms/videos/aspnet-dynamic-data i've figured in order customize fields need

  • create file custom code in app_code folder (myservice.cs).
  • create 'public partial class' ms-sql -table (service).

here's (¿pathetic?) effort (app_code/myservice.cs):

// myservice.cs using system; using system.componentmodel.dataannotations; using system.web; using system.componentmodel; [metadatatype(typeof(servicemetadata))] public partial class service { } public class servicemetadata { [enumdatatype(typeof(protocoltype))] public object protocol { get; set; } } public enum protocoltype { https, sftp, ftps }

this builds ok, running ends "argumentexception unhandled user code / value passed in must enum base or underlying type enum, such int32." message in \dynamicdata\fieldtemplates\enumeration.ascx.cs -file.

help appreciated.

ok, since nobody has tried answer this, i'll try answer own question.

seems me there not out-of-the-box method problem. however, in mind (please correct me if i'm wrong) there 3 possible solutions problem:

  1. change database structure
    • add new table, contains protocols , link service table:
      • add protocols -table containing these fields.
        • protocols.id (int, primary key)
        • protocols.protocol (char(10))
    • delete (drop) service.protocol -field
    • add service.protocols_id -field.
    • make relation: fk:service.protocols_id --references-->> pk:protocols.id

  2. change service.protocol -field numeric (int)

  3. create own fieldtemplate

    • requires in-depth knowledge on .net 4.0, dynamicdata, c# (or whatever programming language is), data context (=classes represent database entities)
    • you can started right-clicking ...\dynamicdata\fieldtemplates\ -folder, choose dynamicdatafield, rename mydropdownlist, click add.
    • more on subject: http://msdn.microsoft.com/en-us/library/cc488522.aspx

comments welcome.


Comments

Post a Comment

Popular posts from this blog

javascript - backbone.js Collection.add() doesn't `construct` (`initialize`) an object -

<!doctype html public "-//w3c//dtd xhtml 1.0 strict//en" "http://www.w3.org/tr/xhtml1/dtd/xhtml1-strict.dtd"> <html> <head> <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.7.2/jquery.min.js"></script> <script src="http://documentcloud.github.com/underscore/underscore-min.js"></script> <script src="http://documentcloud.github.com/backbone/backbone-min.js"></script> </head> <body> <button id="cmd_create_event" name="cmd_create_event" type="button">create new `event`</button> <script type="text/javascript"> var eventmodel = backbone.model.extend({ initialize : function() { console.log("`event` initialized. id: " + this.cid); this.bind("change:status", function() { console.log(this.get("status") + " value `status`"); }); this.bind("error", function(model, e...
Read more

php - Get uncommon values from two or more arrays -

is there function in php give array of uncommon values 2 or more arrays? for example: $array1 = array( "green", "red", "blue"); $array2 = array( "green", "yellow", "red"); .... $result = function_needed($array1, $array2,...); print_r($result); should give output: array("blue", "yellow", ...); use array_diff , array_merge : $result = array_merge(array_diff($array1, $array2), array_diff($array2, $array1)); here's demo. for multiple arrays, combine callback , array_reduce : function unique(&$a, $b) { return $a ? array_merge(array_diff($a, $b), array_diff($b, $a)) : $b; } $arrays = array( array('green', 'red', 'blue'), array('green', 'yellow', 'red') ); $result = array_reduce($arrays, 'unique'); and here's demo of that.
Read more

Adding duplicate array rows in Php -

i create function in php adds rows of array shared column value. so input. $test = array( array("c", 5, 6), array("c", 2, 3), array("test", 5, 6) ); and output. $testduplicatefree = array( array("c", 7, 9), array("test", 5, 6) ) ); i'm thinking function combine_duplicates($array,$col){ ... ... return $duplicatefreearray; } where $col duplicate free array. so, in case, combine_duplicates($test,0); would me desired output. this. <?php function combine_duplicates($array,$col) { $index = array(); foreach ($array $row) { $key = $row[$col]; if (!isset($index[$key])) { $index[$key] = $row; } else { ($i = 0; $i < count($row); ++$i) { if ($i != $col) { $index[$key][$i] += $row[$i]; } } } } return array_values($index); } $array = array( array("c", 5, 6), array("c", 2, 3), array("test", 5, 6) ); print_r(combine_duplicates($array, 0)); try here: http://codepad.org/mdhesqhi
Read more