Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- List<Dictionary<Object, Object>> responseList = new List<Dictionary<object, object>>();
- Database db = new Database();
- Street myStreet = new Street();
- using (db.sqlConnection)
- {
- db.sqlConnection.Open();
- using (var cmd = new SqlCommand("areaGetStreetTypes", db.sqlConnection))
- {
- cmd.CommandType = System.Data.CommandType.StoredProcedure;
- cmd.Parameters.Add(new SqlParameter("@city_id", city_id));
- cmd.Parameters.Add(new SqlParameter("@language_id", language_id));
- using (SqlDataReader dr = cmd.ExecuteReader(CommandBehavior.KeyInfo))
- {
- while (dr.Read())
- {
- Dictionary<Object, Object> newDictionary = new Dictionary<object, object>();
- for (int lp = 0; lp < dr.FieldCount; lp++)
- {
- newDictionary.Add(dr.GetName(lp), dr.GetValue(lp));
- }
- responseList.Add(newDictionary);
- }
- }
- }
- }
- return responseList;
- } //returnes a list of street types
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement