4
in my dropdown list, all company's name lists,and what i want is to save primary key of company only.Here my coding...
file.aspx
[<asp:DropDownList ID="dropselectProvider" runat="server" DataSourceID="selectProvider" DataTextField="name" DataValueField="providerID" Visible="False" AppendDataBoundItems="True" AutoPostBack="True">
<asp:ListItem>Select Provider/Organiser</asp:ListItem>
</asp:DropDownList>
<asp:SqlDataSource ID="selectProvider" runat="server" ConnectionString="<%$ ConnectionStrings:hrTraining %>" ProviderName="<%$ ConnectionStrings:hrTraining.ProviderName %>" SelectCommand="SELECT providerID, name FROM hrts.provider ORDER BY name"></asp:SqlDataSource>
here my code behind file.aspx.cs
protected void btnAddNewSubmit_Click(object sender, EventArgs e)
{ DropDownList myproviderID = (DropDownList)ddselectProvider.FindControl("provid erID");
OdbcConnection myconn = new OdbcConnection(ConfigurationManager.ConnectionStri ngs["hrTraining"].ConnectionStrings);
OdbcCommand cmd = new OdbcCommand("INSERT INTO training(providerID) VALUES (?)", myconn)
{ cmd.Parameters.Add("@providerID", OdbcType.Int).Value = Convert.ToInt32(myproviderID.Text);
}
myconn.Open();
cmd.ExecuteQuery();
}
