how do i fill my textbox based on the selection in dropdownlist using sql procedure

Question

User-1849856862 posted

Hi, how do i fill my textbox based on the selection in drop downlist using sql procedure.

i select Name in the dropdownlist 

i wish to have contact number and department display in my textbox.

Answer 1

User61956409 posted

Hi,

The OnSelectedIndexChanged event of DropDownList control will fire when the selected index has been changed, in this event you can call your Stored Procedures using ADO.Net to retrieve contact number and department information from your database and assign the value to textbox.

You can refer to this article: “Calling Select SQL Server Stored Procedures using ADO.Net” to call your Stored Procedures.

With Regards,

Fei Han

Answer 2

User-1716253493 posted

It's similar when using sql command with commandtype.text

You need a parameter in stored procedure, then modify your code

cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "mysp";
cmd.Parameters.AddWithValue("@param1", ddl.SelectedValue);

CREATE PROCEDURE mysp(@Param1 varchar)
AS
BEGIN
	select * from Users where userName=@Param1
END
GO