session value in anaother panel in the same page

You need to change just line with "@VisitID" to  "@Visit_ID"

and your filnal code should look like,

using (SqlCommand command1 = new SqlCommand("strtVisit", con))
{
    command1.CommandType = CommandType.StoredProcedure;

    con.Open();
    command1.Parameters.AddWithValue("@Visit_ID", Convert.ToInt32(Session["VisitID"]));
    command1.Parameters.AddWithValue("@Visitor_name", VisitorName.Text);
    command1.Parameters.AddWithValue("@Nationality_ID", NationalDD.SelectedIndex);
    command1.Parameters.AddWithValue("@org_id", Org.SelectedItem.Value);
    command1.ExecuteNonQuery();
    con.Close();
}

Hello Name,

Your procedure parameter is  @Visit_ID and you are passing @VisitID. So change 

command1.Parameters.AddWithValue("@VisitID", Convert.ToInt32(Session["VisitID"]));

To 

command1.Parameters.AddWithValue("@Visit_ID", Convert.ToInt32(Session["VisitID"]));

 

Thanks

Naimish Makwana

Many thanks for your help ...

it's work :) ...

Now , in 2nd part ,i wrote this code which i bring the session Visit_ID to this part 

using (SqlCommand command1 = new SqlCommand("strtVisit", con))
                    {
                        command1.CommandType = CommandType.StoredProcedure;

                        con.Open();
                        command1.Parameters.AddWithValue("@VisitID", Convert.ToInt32(Session["VisitID"]));
                        command1.Parameters.AddWithValue("@Visitor_name", VisitorName.Text);
                        command1.Parameters.AddWithValue("@Nationality_ID", NationalDD.SelectedIndex);
                        command1.Parameters.AddWithValue("@org_id", Org.SelectedItem.Value);
                        command1.ExecuteNonQuery();
                        con.Close();
                    }

 

and the message is appear 

 {Procedure or function StrtVisit expects parameter @Visit_ID, which was not supplied.}    System.Exception {System.Data.SqlClient.SqlException}

and the save not complete :( 

Note: " i  need procedure which save a list of names and their details and then store it in the database after it split "

Hi,

Can you please share your code using session or session conversion to list?

use below parameters

 command.Parameters.AddWithValue("@VisitID", Convert.ToInt32(Session["VisitID"]));
        command.Parameters.AddWithValue("@Visitor_name", VisitorName.Text);
        command.Parameters.AddWithValue("@Nationality_ID", Convert.Toint32(NationalDD.SelectedValue));
        command.Parameters.AddWithValue("@org_id", Convert.Toint32(Org.SelectedValue));

Make sure, VisitID, Nationality_ID and Org_Id are if int type in your table, Otherwise type cast accordingly.

Hello Name,

The problem may be 

 command.Parameters.AddWithValue("@Nationality_ID", NationalDD.SelectedItem);

Try one of the below.

command.Parameters.AddWithValue("@Nationality_ID", NationalDD.SelectedIndex);

OR

command.Parameters.AddWithValue("@Nationality_ID", NationalDD.SelectedValue);

OR 

command.Parameters.AddWithValue("@Nationality_ID", NationalDD.SelectedItem.ToString());

Thanks.

change your session to Convert.ToInt() then it should work

command.Parameters.AddWithValue("@VisitID", Convert.ToInt32(Session["VisitID"]));

Thanks sir 

when running the code after the changing , it give me this error 

(System.Data.SqlClient.SqlException: 'Error converting data type nvarchar to int.'
) for the  (command.ExecuteNonQuery();)

Hello,

You are passing dropdown.SelectedItem, you should pass selectedItem.Value

using (SqlConnection connection = new SqlConnection(connoctionString))
{
    using (SqlCommand command = new SqlCommand("AddVisitor", connection))
    {
        command.CommandType = CommandType.StoredProcedure;

        connection.Open();
        //command.Parameters["@VisitID"].Direction = ParameterDirection.Output;
        command.Parameters.AddWithValue("@VisitID", Convert.Tostring(Session["VisitID"]));
        command.Parameters.AddWithValue("@Visitor_name", VisitorName.Text);
        command.Parameters.AddWithValue("@Nationality_ID", NationalDD.SelectedItem.Value);
        command.Parameters.AddWithValue("@org_id", Org.SelectedItem.Value);
        command.ExecuteNonQuery();
        connection.Close();