I have an Edit FormTemplate in my Grid that is bound to an OleDb dataset (Access). On submission of the edit form, control goes to my OnItemCommand routine. The statement:
Thanks for asny suggestions. Dan
GridEditableItem grdSelected = (GridEditableItem)e.Item;
Results in the error:
{"The current EditFormType does not support the requested editing capabilities."}
and I am unable to retrieve the form's data values from their controls.
This same code works fine with a SQL dataset. Here is my OleDb code that populates the grid:
OleDbConnection accConn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=//webservice/C$/temp/fcData.mdb"); |
OleDbCommand accCommand = new OleDbCommand("select mmw_drug_disp.descdisplay,strength,strengthunit,ddid,dosechekunit, strength+' '+strengthunit as dispdose, mmw_drug_name.descdisplay as drugname, " |
+ "'' as freq, '' as route, '' as comments, null as startdate, null as stopdate, null as dcdate, '' as therapy " |
+ "from mmw_drug_disp " |
+ "inner join mmw_drug_name on mmw_drug_disp.pnid = mmw_drug_name.pnid " |
+ "where mmw_drug_disp.haspackdrugind=1 and mmw_drug_disp.descsearch like '" + searchtext + "%' order by mmw_drug_disp.descdisplay", accConn); |
OleDbDataAdapter myDataAdapter = new OleDbDataAdapter(accCommand); |
accConn.Open(); |
DataSet myDataSet = new DataSet(); |
myDataAdapter.Fill(myDataSet, "Names"); |
RadGrid1.DataSource = myDataSet; |
RadGrid1.DataMember = "Names"; |
this.DataBind(); |