How do I setup a dropdownlist for (***Type***) in editmode.
Any starters. Any sites.I would appreciate any help.

How do you create and Impliment a new intance or edit an instance
in a datalist?


<ItemTemplate>
<table width="400" style="font: 10pt verdana">
<tr>
<td>
<tr><td>***Type:****</td>
This dropdownlist works in browse <td><asp:DropDownList
AutoPostBack="True" id="ddlCOMMANDTYPE" DataSource='<%# BindTBCOMMANDTYPE() %>'
mode. selectedindex='<%#
GetSelectedIndexCOMMANDTYPE(DataBinder.Eval(Contai ner.DataItem, "CT_REF").ToString())%>' runat="server"
DataTextField="CT_DESCRIPTION"
DataValueField="CT_REF"></asp:DropDownList></td></tr>
<tr><td>Content:</td>
<td><%# Convert.ToString(DataBinder.Eval(Container.DataIte m,
"CM_CONTENT"))%></td></tr>
</td>
</tr>
</table>
<asp:LinkButton id="EditButton" Text="Edit" CommandName="Edit"
runat="server" />
</ItemTemplate>
<EditItemTemplate>
<table width=400 style="font: 10pt verdana">
<tr>
<td>
<tr><td>***Type:****</td>
<tr><td>Content:</td>
<td><asp:TextBox id="CM_CONTENTTextBox" Text='<%#
DataBinder.Eval(Container.DataItem, "CM_CONTENT") %>' runat="server"/></td></tr>
</td>
</tr>
</table>
<asp:LinkButton id="UpdateButton" Text="Update" CommandName="Update"
runat="server" />
<asp:LinkButton id="DeleteButton" Text="Delete" CommandName="Delete"
runat="server" />
<asp:LinkButton id="CancelButton" Text="Cancel" CommandName="Cancel"
runat="server" />
</EditItemTemplate>
</ASP:DataList>
<input type="hidden" id="PageSize" value="1" runat="server"
NAME="PageSize"> <input type="hidden" id="CurrentPage" value="1" runat="server"
NAME="CurrentPage">
<input type="hidden" id="TotalSize" runat="server" NAME="TotalSize">
<asp:LinkButton id="Prev" Text="<< Previous" OnClick="Page_DataList"
runat="server" />
&nbsp;
<asp:LinkButton id="Next" Text="Next >>" OnClick="Page_DataList"
runat="server" />
</form>
////////////////////////////////////////////////////////////////
public int GetSelectedIndexCOMMANDTYPE (string CT_REF)
{
int iLoop;
DataTable dt = ddlDataSet1.Tables["ddlCOMMANDTYPE"];
for (iLoop=0; iLoop < dt.Rows.Count; iLoop++)
{
string srow = dt.Rows[iLoop]["CT_REF"].ToString();

if(srow == CT_REF)
{
return iLoop;
}
};
return 0;

}
//////////////////////////////////////////////////////////////////
public DataSet BindTBCOMMANDTYPE()
{
OdbcConnection myConnection = new
OdbcConnection("DSN=POS;UID=system;PWD=system");

// Populate the ddlDataSet1
myConnection.Open();
const string strSQLDDL = @"SELECT CT_REF, CT_DESCRIPTION FROM
TBCOMMANDTYPE ORDER BY CT_REF";
OdbcDataAdapter myDataAdapter = new OdbcDataAdapter(strSQLDDL,
myConnection);
ddlDataSet1.Clear();
myDataAdapter.Fill(ddlDataSet1, "ddlCOMMANDTYPE");
myDataAdapter.Dispose();
myDataAdapter = null;
myConnection.Close();
return ddlDataSet1;
}
//************************************************** *********************

Any Advice you can give me would be so appreciated.

Thank you Sincerely.
Matt


Knowledge is to be shared.

__________________
Knowledge is to be shared.