How to pass a variable from my controller to the view? ... Vb.net MVC

Question

0.00/5 (No votes)

See more:

I Want to pass the data inside "Var" to the view but I don´t know how to catch it into the view

What I have tried:

conn.Open()
                   sql = New System.Data.SqlClient.SqlCommand
                   sql.CommandText = "exec areas '" & user & "' "

                   sql.Connection = conn
                   reader = sql.ExecuteReader()

                   If reader.HasRows Then
                       reader.Read()
                       var = reader.GetValue(0)
                       var2 = reader.GetValue(1)
                       Session("UserName") = var2

                       Return View()
                   End If
                   conn.Close()

Posted 9-Apr-18 14:44pm

Member 13585404

Updated 9-Apr-18 20:44pm

Add a Solution

Comments

Bryian Tan 9-Apr-18 21:53pm

What wrong with Session("UserName") = var2?

Member 13585404 9-Apr-18 23:28pm

"Session("UserName") = var2" contains the user name(from my form) because I'm doing a login, the only thing I want to do is to show in mi view "var" because it has the department name of the user name.

Member 13585404 9-Apr-18 23:29pm

I don´t know if I explained it well

Bryian Tan 9-Apr-18 23:44pm

for simplicity, you can stick with Session variable,

dim dept = reader.GetValue(0)
Session("department") = dept

Member 13585404 10-Apr-18 0:03am

It works! thank you

Bryian Tan 10-Apr-18 0:06am

awesome!

Member 13585404 10-Apr-18 0:09am

something else this is my connection "Module". I want to do a query into a "Model" so How can I use this module into my class
Module
cnx
Public cnx As New SqlConnection("Data Source=;Initial Catalog=;Integrated Security=")
End Module

GKP1992 10-Apr-18 0:40am

Use web config connection string properties for that.

Member 13585404 10-Apr-18 9:38am

I've put my connection properties in the file "web.config" but I don't know how to use it to call for doing queries to the database. is there any examples that you can provide to me because I've looked for and I can't find no one in vb.net

GKP1992 10-Apr-18 23:36pm

A simple google search takes you to the MSDN page where you can find examples on both c# and vb.net. Visit here.

Member 13585404 10-Apr-18 23:46pm

it seems what I was looking for, so I'm going to try with this examples

GKP1992 9-Apr-18 23:53pm

Have you looked at model binding?

Member 13585404 10-Apr-18 0:05am

No, I haven´t, "model binding" is new for me. It is the first time I work with vb.net MVC.

GKP1992 10-Apr-18 0:38am

Take a look, it does exactly what you're looking for.
Visit here.

Member 13585404 10-Apr-18 9:33am

ok, I'm going to check it thank you

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Sunasara Imdadhusen · Answer 1 · 2018-04-09T20:45:00

Solution 1

You can use

ViewBag to pass the value from Controller to View

for example in the .vb file

VB

ViewBag.Title = "Put your page title here"

in the html or razor page or view

HTML

<h1>@ViewBag.Title</h1>

Posted 9-Apr-18 20:45pm

Sunasara Imdadhusen

Updated 9-Apr-18 20:46pm

v2