If you want to populate from database and have a data filed like PhoneNumber then. simple
<asp:DropDownList ID="ddlVndrName" runat="server" AutoPostBack="True" onselectedindexchanged="ddlVndrName_SelectedIndexChanged/>"
Then code behind
protected void ddlVndrName_SelectedIndexChanged(object sender, EventArgs e)
{
string selectedValue = ddlVndrName.SelectedValue.Tostring();
TextBox1.Text = GetData( selectedValue);
}
public string GetData(string id)
{
var ConnectionString= "your connection string";
var query = string.formet( SELECT PhoneNumber FROM tableName WHERE id ={0},id};
using (var conn = new SqlConnection(ConnectionString))
{
try
{
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
string returnValue = string.Empty;
var selectCommand = new SqlCommand(query, conn);
var myReader = selectCommand.ExecuteReader();
while (myReader.Read())
{
returnValue = myReader.GetString(0);
}
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
return returnValue;
}
}
catch (Exception e)
{
throw new Exception(e.Message);
}
}