This should not be as hard as it seems to be, but I can't for the life of me create a table in VB using Razor syntax. The following does not work (despite what some examples would lead me to believe):[code]
View 2 RepliesMVC 3 is great but in some cases I am having trouble translating the Razor syntax. Anyone know of a good VB.Net Razor reference?
View 1 RepliesTrying to create VB.net equivalent for following code and I get error
<ul>
@for (int i=0; i < ViewBag.NumTimes; i++) {
<li>@ViewBag.Message</li>
}
</ul>
In the MVC 3 book by Steven Sanderson on p185 at the bottom, the following expression is used to render the paging links.
@Html.PageLinks(Model.Paginginfo, x=> Url.Action("List", new {page = x}))
What is the VB.NET equivalent? I am stuck on the x url lambda bit.
I am new to Razor view syntax and as most of the examples are in C# in coverting the below Razor syntax to vb.net
<div>
@using (Html.BeginForm())
{
[code].....
I am working on MVC3, i have a situation where i want to do something like this:
<Div>
@Code
Dim i = 1
[Code]....
but razor is throwing wrong syntax error message. how to do this properly in side razor code.
I have no problem creating it. I have created a yes/no (bit) field and set it's default to False. once created if i open the database this column shows data as 0 or -1 as expected. If i created it in Access it would display as a checkbox
View 3 RepliesI want to create a new MS Access database table using ADOX. On this page, is code in VB.NET, but obviously it's not working in C# (when I want to "convert" the code). I'll be grateful if someone converts it correctly.
View 2 RepliesUsing MVC3 and Razor View engine, I created a VB.NET web application in VS 2010. This creates the default Account and Home Controller along with corresponding Action Views.Now if I open any vbhtml file I get the following error message in the Error List window.
Error 50 Syntax error. C:****MVC3AppVBViewsAccountLogOn.vbhtml MVC3AppVB
(See screenshot here http://www.flickr.com/photos/7672540@N07/5469248676/)
[code].....
In other languages (PHP/Python), I am used to creating a class which represents a given HTML page layout. These classes can have an unlimited number of attributes and dynamic features, such as Navigation (multi level), error messages, info messages, footer text, etc... Most of these items have defaults, but may be overridden on a per-page level. For example:
[Code]....
My question is: how do I implement similar functionality into ASP.Net MVC 3 Razor (VB)? So far, I have been able to see how you can use ViewData to pass various bits of data to a view. Also, I have been working with strongly typed views. Frankly, I'm not sure who's job it is to have this logic, the controller or the view (or is there a model that should be in there somewhere). Here is a summary of what I am shooting for:
A single place to initialize the default values for the layout (like the first layer of navigation, etc...) Strongly typed attributes, such as Public Readonly Property Nav1 as List(of NavElement) And a single place to render these layout elements (I assume _Layout.vbhtml) forgive the here-and-there of this post... I'm trying to figure out the "right way" it's done on a platform that is both new (Razor) and new to me (ASP.Net MVC).
I have created the following code and I keep getting an errorstating that the "UPDATE" is syntaxtically incorrect.
[code]...
I have an sql table called products, which has a data field called product defined as a text field, how do I assign a VB variable to this data field?[code]...
View 1 Repliesthis is my public function to return the conn (this works perfectly fine, using it to bind things else were)
Public Function ReturnMyConn() As MySqlConnection
Dim conn As New MySqlConnection("server=testestest.com; user id=kavx; password=test123; database=321test")
[code]....
cmd = New OleDbCommand("ALTER TABLE " & ComboBox1.Text & " ADD COLUMN " & TextBox1.Text & " TEXT", cn)
Syntax error in ALTER TABLE statement.
VS 2010 [RESOLVED] UPDATE table SET( syntax error
View 3 RepliesI m getting a syntax error (oledbexception was unhandled, Syntax error in INSERT INTO statement.) while trying to add a new record to my access table. This is the
[code]...
Everything runs smoothly up untill this line daadmin.Update(dsadmin, "AdminLogin")I dont see what im doing wrong, the database name is booking.mdb and the table name is AdminLogin
I keep getting an error saying "there is an error in your sql syntax." when i use this sql statement:SELECT * FROM gsm_oceanwide_integrationEDIT:To put this in context heres the code im using this query statement in (VB.net):
Dim con As MySqlConnection = New MySqlConnection("Data Source=" & frmLogin.txtserver.Text & ";Database=stratocast;User ID=" & frmLogin.txtusername.Text & ";Password=" & frmLogin.txtpassword.Text & ";")
[code]......
Using VS-2008, VB and SQL 2005 Developer:
I'm using Queries within the TableAdapter to grab certain data record field validations, most of them are using the Scalar Query to see if a certain condition returns a record or not.
I have one check I need to do that SUMs three fields and have tried it with both a Scalar and Regular Select, both return the results fine, my problem is creating the right syntax in the VB code to check the returned values.
Here's the Query Code in the Adapter (called GetInvoiceSum) and I pass it the cJobNum
SELECT sum(taxable) as taxable, sum(material+labor) AS subtotal, sum(tax) AS tax from ticket where jobnum = @cJobnum Here is the Code in the VB app - it gives me errors on the declaration and I've tried various types DataRow, DataSet, etc....not sure what I'm missing here and am very new at this....
Dim nSumTicket As DataSet = Me.TicketTableAdapter.GetInvoiceSum(cJobnum)
Using VB.NET with ASP.NET and and ms-access 2003 data, I'm trying to input data from a web form to the a table in db.mdb called 'USER'.[code]...
View 1 Repliessql = "CREATE TABLE tblPrograms ([index] Counter," & _
"[lngPlatformFK] TEXT(255) NOT NULL," & _
"[strCompany] TEXT(255)," & _
"[strProgramName] TEXT(255) NOT NULL," & _
[Code].....
When running the previous sql query i am getting a syntax error. This database is a access 2003 database using the Jet 4.0 OleDB driver.
I created a function that creates a global temporary table to stage data from a excel sheet I need the table to persist for me to map the columns using a form. The table is still there when the code goes back to the sub that calls the function until I call the form where I do the mapping. I am trying to avoid create/drop table scenario with a perm stage table.How can I get this table to persist until the data gets loaded into the perm table?
View 8 RepliesI am working with a Vb.net 2005 application. On the application I have a Create table button which when clicked creates a table in Sql server with the code shown below;
Code: Private Sub BtnCrtTable_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles BtnCrtTable.Click
[Code]...
This is really a pre-defined table and the data is already specified to be inserted to the table. However, my primarily task is to read a flat file which has the data and consider the first line as the column to be column names.
Therefore, initially I created an open dialogue to browse for the text file and store the path such as E:Datafile est.txt, in a TextBox1 visible at run time. Now the task is to change the above "create table" to read the txt file (column names are on the first line) and then create the table in the database.
I'm trying to create table in my database, that would have name like i type in Textbox and than i have to click the button With code like this :
sqlCmd.CommandText = "CREATE TABLE NAME = '" & TextBox1.Text & "' (First_Name char(50))"
I'm getting erorr : Incorect syntax near "name that i type"
I am new to nodes() method. I am getting the foloowing syntax when trying to create a stored procedure using the nodes() method.
The syntax error:
Msg 170, Level 15, State 1, Procedure spmTestSelect, Line 19
Line 19: Incorrect syntax near '.'.
[code]...
I'm following the ASP.NET MVC Tutorial and having started in VB.NET I'm having trouble converting the following razor code:
[code]...
on both the <li> tags. I understand I need to use line continuation but can't figure out where. I'd be greatful if you can point out the problem.
how do I add this htmlAttribute on MVC 3 Razor view?
New With {.watermark = "sometext", .title = "sometext"}
I tried the C# way but it's not working (@watermark) but it's not working.
UPDATE here is the current usage I am trying but it's not working.
@Html.EditorFor(Function(model) model.FirstName, New With {.maxlength = "50"})
This isn't working either
@Html.EditorFor(Function(model) model.FirstName, New Object() {"maxlength=50"})
How do I do this in Razor (VB.NET):
[Code]....
I have a razor.vbhtml view and would like to use string resources normally accessible via My.Resources. Seems like I can only get to My.Computer, My.Log and couple other namespaces from the view, but not My.Resources. I've tried changing access modifier to public and adding Imports, neither worked.
View 1 RepliesIs not the @Model MyModelClass notation not supported in VB Razor Views? It's not working for me. What is the construct for it?
View 1 RepliesI have this C# code in a Razor view:
@(Html.CheckBoxFor<RazorSamplesWeb.Models.SamplesModel>(i => i.IsActive))
I tried translating it to this:
@Code Html.CheckBoxFor(Of RazorSamplesWeb.Models.SamplesModel)(Function(i) i.IsActive)End Code
But it's complaining.