Stored Procedure using SQLDataAdapter , DropDownList

Your select statement is a likely culprit here, try:
Why is the field name and table name the same? Means that you are still likely to get an error? You may also run into probs later inserting the id this way.

You may need further resources to learn about sql :hint:, try stickies, tutorials etc.

Your select statement is a likely culprit here, try:

Expand|Select|Wrap|Line Numbers

1. insert into Specialty (SPID,Specialty)
2. values(@SPID,@Specialty)

Why is the field name and table name the same? Means that you are still likely to get an error? You may also run into probs later inserting the id this way.

You may need further resources to learn about sql :hint:, try stickies, tutorials etc.

Hi Kenobewan

I have changed the select statement into the statement that U have given above as

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go





-- =============================================
-- Author: <Author,,Name>
-- Create date: <Create Date,,>
-- Description: <Description,,>
-- =============================================
ALTER PROCEDURE [dbo].[Pro_Specialty]

@SPID nvarchar(12)output,
@Specialty nvarchar(50)output


AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.


-- Insert statements for procedure here
-- select @SPID=SPID,@Specialty=Specialty from Specialty
insert into Specialty (SPID,Specialty)
values(@SPID,@Specialty)

END




In form I have given the coding as

protected void Page_Load(object sender, EventArgs e)
{

if (!Page.IsPostBack)
{

SqlConnection con = new SqlConnection("user id=sa;password=cast;database=Hello_Dr;server=AUROR A-SERVER;");
con.Open();
SqlCommand cmd = new SqlCommand();

cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "Pro_Specialty";
cmd.Connection = con;

SqlParameter SPID = new SqlParameter("@SPID ", SqlDbType.NVarChar, 12);
SPID.Direction = ParameterDirection.Output;
Specialty_DropDownList.Text = SPID.Value.ToString();

SqlParameter Specialty = new SqlParameter("@Specialty ", SqlDbType.NVarChar, 50);
Specialty.Direction = ParameterDirection.Output;
Specialty_DropDownList.Text = Specialty.Value.ToString();

cmd.Parameters.Add(SPID);
cmd.Parameters.Add(Specialty);
cmd.ExecuteNonQuery();


SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
Specialty_DropDownList.DataValueField = "@SPID";

Specialty_DropDownList.DataTextField = "@Specialty";

Specialty_DropDownList.DataSource = ds;

Specialty_DropDownList.DataBind();
con.Close();



}

But still I m getting the error as

Object reference not set to an instance of an object.