i have a dropdown which is displaying two columns ( port, country ), i want a dropdown selected value to be stored in seperate two columns (lastPort, lastCountry) of another table, when i am entering data, only one port name is saving, how to save the country
name in the table
here is my code
protected void Page_Load(object sender, EventArgs e)
{
BindDropDownList();
}
private void BindDropDownList()
{
DataTable dt = new DataTable();
string id = string.Empty;
string name = string.Empty;
string newName = string.Empty;
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ConectionString"].ConnectionString);
try
{
con.Open();
string sqlStatement = "SELECT * FROM ForiegnCountryPorts";
SqlCommand sqlCmd = new SqlCommand(sqlStatement, con);
SqlDataAda ...
Go to the complete details ...