/ Published in: SQL
Expand |
Embed | Plain Text
######### SQL ######################################### CREATE PROCEDURE dbo.getTwoValues ( @param1 int ) AS SELECT returnval1, returnval2 FROM tblWhatever WHERE param1 = @param1 ########## C# ######################################### string connString = ConnectionManager.ConnectionString["ConnString"].ToString(); USING(SqlConnection conn = new SqlConnection(connString)) { SqlCommand getTwoValues = new SqlCommand("[getTwoValues]", conn); getTwoValues.CommandType = ...StoredProcedure; getTwoValues.Parameters.AddWithValue("@param1", 1); conn.Open(); SqlDataReader reader = getTwoValues.ExecuteReader(); // Repeat FOR ALL returned rows while(reader.READ()) { string firstValue = reader.GetString(reader.GetOrdinal("returnval1")); int secondValue = reader.GetInt32(readder.GetOrdinal("returnval2")); // Do stuff WITH VALUES } }
You need to login to post a comment.
