c# - Populating GridView, dynamically templating the edit fields, saving to database -

alright, going try , thorough possible. have gone through several (many) tutorials before resorting posting here if wondering /=

i have several tables - 1 contains text/stored-procedure-name pairs populate dropdown menu on front end (web form). other tables accessed via stored procedures. idea want able able control back-end fields viewable/editable user on front end. able add / remove stored-procedures retrieve data without having mess front end.

the user can select drop down, , based on selection stored-procedure executed , populate gridview. no problems far.

now, ideally, user able edit data presented in gridview. easy enough, until start getting fancy (i.e. overriding default textbox controls generated). example, when user presses "edit" in gridview row, , record has datatype "datetime", want sort of calendar/clock pop , allow user pick date , time, , update database.

i've been running roadblocks @ point. i've followed tutorial on dynamically generating editable gridviews (http://aspalliance.com/1125_dynamically_templated_gridview_with_edit_delete_and_insert_options.1), not work trying do.

any appreciated, , hope have explained enough depth!

code:

protected void dropdownlist1_selectedindexchanged(object sender, eventargs e) {     this.setdata(); }  public void setdata() {      //establishing sql connection     using (sqlconnection conn = new sqlconnection(system.configuration.configurationmanager.connectionstrings["myconnstring"].connectionstring         ))     {          //string query;         sqlcommand sqlcommand;         sqldatareader reader;          sqldataadapter adapter = new sqldataadapter();         //open connection db         conn.open();          //generating query fetch contact details         //query = "select * " + dropdownlist1.selectedvalue + ";";          sqlcommand = new sqlcommand(dropdownlist1.selectedvalue, conn);         //execute query         reader = sqlcommand.executereader();         //assign results          gridview1.datasource = reader;          //bind data         gridview1.databind();          conn.close();     } } 

the issue when gets triggered:

  protected void gridview1_rowediting(object sender, gridviewediteventargs e) {     gridview1.editindex = e.neweditindex;      this.setdata(); } 

all of editable fields default text boxes. have been unable them format according datatype. again, example, if datatype datetime, calendar should pop , let user select date/time.

i know there way using except statically generated gridviews. gridview dynamic , contents depend on procedures executed backend, can't hardcode edit formats front end.