How to pass variable in model to view?

Question

This is my code in my model, I want to use the variable lat to my view. Is there a way to use it there?

The string has a lat and lng with it. What I want to happen is when the string is selected in the text the lat and lng is selected as well but it will be stored in the variable and I will use it in the view and pass it to the script where it will view it in the google map api.

 public IEnumerable<String> GetStartList()
            {
                //int count = 0;
                var result = new List<String>(10);
                string query = "SELECT PlaceName, Lat, Lng from Places";
                SqlCommand cmd = new SqlCommand(query, con);
                con.Open();
                using (SqlDataReader dr = cmd.ExecuteReader())
                {
                    while (dr.Read())
                    {
                        var mystring = dr.GetString(0);
                        var lat = dr.GetDouble(1);
                        result.Add(mystring);
                        //result.Add(lat.ToString());
                        //count++;

                    }
                }
                con.Close();
                return result;
            }

You could make Lat a property and then using binding in the WPF to bind your control to the Lat property. — Keithin8a
– Keithin8a, Commented Sep 25, 2015 at 15:29
how can i do that? by using a stored procedure? sorry Im really new to this — Migs Zuniga
– Migs Zuniga, Commented Sep 25, 2015 at 15:33
Check out my answer to this question. In your case you wouldn't need a converter. You would just save lat to a property and bind that property using XAML stackoverflow.com/questions/32769120/… — rmn36
– rmn36, Commented Sep 25, 2015 at 15:43

Fancy MyReality · Accepted Answer · 2015-09-25 16:16:01Z

0

Data queries should be in a separate repository.

However if you are passing back just the two strings add both of them to a parent list

IList<IList> model = new List<IList>();
//code to get lat and result
model.add(result);
model.add(lat);
return View(model);

Then in the View, parse the model using Razor.

@model List<IList>
//... body before using model
@foreach (var lat in model[1]) { ... }

answered Sep 25, 2015 at 16:16

Fancy MyReality

133 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Mohammad Soori · Accepted Answer · 2017-10-18 12:30:14Z

0

In action

    int model = 0;
    return View(model);

In View

@model int @{ //Layout = null; } @if(Model == 0) { //You'r Code }

answered Oct 18, 2017 at 12:30

Mohammad Soori

2,4281 gold badge20 silver badges17 bronze badges

Collectives™ on Stack Overflow

How to pass variable in model to view?

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related