Void PicMessage ()
{
String id = Request ["cartype_id"];
SqlConnection conn = new SqlConnection (System. Configuration. ConfigurationSettings. deleettings ["connstr"]);
SqlCommand cmd = new SqlCommand ("sp", conn );
Cmd. CommandType = CommandType. StoredProcedure
Cmd. Parameters. Add ("@ id", SqlDbType. NVarChar, 50 );
Cmd. Parameters ["@ id"]. Value = id;
Cmd. Parameters. Add ("@ marketprice", SqlDbType. Float );
Cmd. Parameters ["@ marketprice"]. Direction = ParameterDirection. Output;
Cmd. Parameters. Add ("@ length", sqldbtype. nvarchar, 50 );
Cmd. Parameters ["@ length"]. Direction = parameterdirection. output;
Cmd. Parameters. Add ("@ width", sqldbtype. nvarchar, 50 );
Cmd. Parameters ["@ width"]. Direction = parameterdirection. output;
Cmd. Parameters. Add ("@ height", sqldbtype. nvarchar, 50 );
Cmd. Parameters ["@ height"]. Direction = parameterdirection. output;
Cmd. Parameters. Add ("@ ccv_1_qiliang", sqldbtype. nvarchar, 50 );
Cmd. Parameters ["@ ccv_1_qiliang"]. Direction = parameterdirection. output;
Cmd. Parameters. Add ("@ Fueleconomy", sqldbtype. nvarchar, 50 );
Cmd. Parameters ["@ fueleconomy"]. Direction = ParameterDirection. Output;
Conn. Open ();
Cmd. ExecuteNonQuery ();
Cmd. Dispose ();
Conn. Close ()
Marketprice. Text = cmd. Parameters ["@ marketprice"]. Value. ToString ();
Length. Text = returnStr (cmd. Parameters ["@ length"]. Value. ToString ());
Width. Text = returnStr (cmd. Parameters ["@ width"]. Value. ToString ());
Height. Text = returnStr (cmd. Parameters ["@ height"]. Value. ToString ());
Ccv_1_qiliang.text = cmd. Parameters ["@ ccv_1_qiliang"]. Value. ToString ();
}
Create procedure sp
@ ID int,
@ Marketprice float output,
@ Length nvarchar (50) output,
@ Width nvarchar (50) output,
@ Height nvarchar (50) output,
@ Ccv_1_qiliang nvarchar (50) output,
@ Fueleconomy nvarchar (50) Output
As
Select @ marketprice = round (marketprice, 1), @ length = length, @ width = width, @ Height = height, @ ccv_1_qiliang = ccv_1_qiliang, @ Fueleconomy = Fueleconomy
From table where cartype_id = @ ID