Click here to Skip to main content
15,896,118 members

Comments by Sai Prasad anumolu (Top 141 by date)

Sai Prasad anumolu 1-Dec-14 8:04am View    
sovled sir
Sai Prasad anumolu 11-Oct-14 9:59am View    
Thank you it is working
Sai Prasad anumolu 11-Oct-14 9:05am View    
null is comming brother

ObjectRepresentDL = DataAccessDAL();
lbloutputData.Text = ObjectRepresentDL._Message;
Sai Prasad anumolu 11-Oct-14 8:38am View    
SqlCommand cmd = new SqlCommand("InsertEmployeeBioData_SP", con); //This is Insert the All Values From the Tables
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@FirstName", ObjectRepresentDL.FirstName);
cmd.Parameters.AddWithValue("@LastName", ObjectRepresentDL.LastName);
cmd.Parameters.AddWithValue("@Gender", ObjectRepresentDL.Gender);
cmd.Parameters.AddWithValue("@Experience", ObjectRepresentDL.Experience);
cmd.Parameters.AddWithValue("@Designation", ObjectRepresentDL.Designation);
cmd.Parameters.Add("@Message", SqlDbType.VarChar, 500);
cmd.Parameters["@Message"].Direction = ParameterDirection.Output;
string outputValue = cmd.Parameters["@Message"].Value.ToString();
int result= cmd.ExecuteNonQuery();



cmd.Dispose();
con.Close();
return ObjectRepresentDL;
Sai Prasad anumolu 11-Oct-14 8:26am View    
already data is Stored procedure

set @Message='Your Record Inserted Successfully'
SELECT @Message;

This data is in stored procedure

+ My Dataacesslayyer Code is this one ....
cmd.Parameters.Add("@Message", SqlDbType.VarChar, 500);
cmd.Parameters["@Message"].Direction = ParameterDirection.Output;
string outputValue = cmd.Parameters["@Message"].Value.ToString();
int result= cmd.ExecuteNonQuery();

My webpage Code is L this one

lbloutputData.Text = DataAccessDAL();

That @meassage value will display in Labal