I am getting the following screen shot error when I am testing my code.
vb
Private Sub cmdLogin_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmdLogin.Click
'get todays date and assign it to a variable
Dim TodaysDate As Date = Now
[code]....
I have this code and I get an error when I try to debug "must declare scalar variable @blobf" can you tell me where is the error here?
[Code]...
I'm new in vb I just wanted to learn vb so I have to search. I learn vb in a self study way(using youtube and other tutorial sites) . but I have this problem i want to connect my login form of vb.net 2003 to the table namely login.db in sql 2005
View 1 Repliesi made 2 reports but when i execute report so is always ask for username and password. please assist me that how to execute reports directly without inserting everytime username and password?
View 8 RepliesDoes anyone know how to store the connection string in a file rather than hard coding it in the application. For example i have declared this connection string in the form to connect to oracle database and it works. But i assume this is not the right way to go by if one is looking for more secured environment.
strcon = "Provider=MSDASQL;" & _
"Driver={Microsoft ODBC for Oracle}; " & _
"CONNECTSTRING=(DESCRIPTION=" & _
[code].....
I want to know how to include username and password of sql express 2005 for creating setup file in vb dotnet.Also how can i create an instance of sql and include it in setup project.
View 2 Repliessend a solution for this "update login SET password=@password,username=@username where username=@user"
while executing i got the error"syntax error in update statement "
I have code on log in form but it only get the latest data on username and password column on my database
Here is my code
Public Class Users
Dim MyLogIn As New myRecords
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles
[CODE]...
This is my connection:
Imports MySql.Data
Imports MySql.Data.MySqlClient
Module myconnect
[CODE]...
This is my record:
Imports System
Imports System.Data
Imports MySql.Data
Imports MySql.Data.MySqlClient
[CODE]...
i have a main menu on my program which has the option of registering. I have enter name and password ..and a button Confirm
i want to be able to store the added username and pasword to the login form so that it will work...
what must i do? also where would this data be stored...
I have a problem with the code, I have input the valid username and password in the form textbox to input the strings in php, but it keep displaying the messagebox that says login failed.
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
MessageBox.Show("Please enter your username")
ElseIf Textbox2.Text = Nothing Then
MessageBox.Show("Please enter your password")
Else
[CODE]...
I don't really know why it keep displaying the messagebox that says it failed when I have input the valid strings in the first place.
I have been debugging my code for a while and looking at posts in other forums, but it seems to be that everyone has a different problem than mine and what works for them will not work for me.My dropdown list is supposed to filter a gridview by choosing all the Companies that are associated to a certain product. The solution I have found online is that most people did not have DataKeyNames set in their gridview. I do have this set, but not to CompanyID. It wouldn't make any sense. So I have no idea what I am supposed to do since this is the only answer I have found.
<asp:DropDownList ID="ddlCompany" runat="server" DataSourceID="dsCompanyFilter"
DataTextField="CompanyName" DataValueField="CompanyID" AppendDataBoundItems="true"
AutoPostBack="true">
[code]....
I have one scalar value function defined in sql database.It accespts 2 parameters and return an integer.Can anyone please help how to call UDF from vb.net using oledeb?
View 1 RepliesMust Declare Scalar Variable @ID?
View 11 RepliesThis seems so basic but I've been struggling to find a solution! I have a web page that take user data from aspx textboxes. Upon hitting a button, the click event submits the responses to a SQL table. Seems easy.I'm using VS10, dev express and VB code. I have established my datacontext class using LinqToSql...In a nutshell, the code is as follows...within the click eventNote that "database" was earlier defined as my datacontext sql connection, "Request" tablee
Dim vname As String = AspxTextbox1.Text
database.executecommand("INSERT INTO [Requests] (ContactName) Values (@vname)")
[code].....
im having this prob, when deleting a line from my gridview, this error shows out.Must declare the scalar variable "@productid".Well, i dont know whats wrong with the coding. As i have already declared the productid.
<table style="width:100%;">
<tr>
<td class="style24" colspan="2">
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
[code]....
Can you show a coding example that has the "Using" statement with a scalar query?
View 1 RepliesI've done some research and I'm not sure what to look for or what my problem is.My error is: "Must declare the scalar variable '@client_id'"
[Code]...
The program is for users to submit their username by typing in their username and pressing the submit button. The username may be able to display on the Usernamelabel in form1.(I made the button on form2) I have problems coding to make the text to come out in form2.My code comes out as error.
Here is the code in form2.
Public Class Form2
Private Sub Form2_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
[CODE]...
At first I was using this as an extension method to update my detached entities...
Public Sub AttachUpdated(ByVal obj As ObjectContext, ByVal objectDetached As EntityObject)
If objectDetached.EntityState = EntityState.Detached Then
Dim original As Object = Nothing
[code]....
Everything has been working great until I had to update non-scalar properties. Correct me if I am wrong but that is because "ApplyCurrentValues" only supports scalars. To get around this I was just saving the FK_ID field instead of the entity object relation. Now I am faced with a many to many relationship so its not that simple. I would like to do something like this...
Dim Resource = RelatedResource.GetByID(item.Value)
Condition.RelatedResources.Add(Resource)
But when I call SaveChanges the added Resources aren't saved. I started to play around with self-tracking entities but it seems they cannot be serialized to ViewState and this is a requirement for me.how to either save my many to many relationships or serialize self-tracking entities?
I am trying to write VB.NET query without writing SQL stored procs. I have already gotten many dataset text queries to work. But I am having trouble with getting this scalar query to work. All I want to do is to get the result of this T-SQL query. How can I code this successfully? select (DateDiff(w, '1/1/' + '2011', getdate())) / 7 AS SELECTED_WEEK (What this code does is it returns the current week of the year). And will this query above return the value as an integer datatype or string?
I tried your answers but it gave me this exception error:
System.InvalidOperationException: ExecuteReader requires an open and available Connection. The connection's current state is Closed.
I double check the query and it is still throwing the error..
sql = "INSERT INTO " & tbl & " (userName,userPassword,userAccessLevel, "
sql = sql & "userDateCreated,userFirstName,userMiddleName,userLastName, "
sql = sql & "lastUpdateDate,lastUpdateBy) "
sql = sql & "VALUES (@u,@p,@lvl,@dateC,@Fname,@MName,@LName,@lud,@lub)"
Dim p As SqlParameter() = New SqlParameter() _
[Code] .....
I'm trying to get a connection established for an OLEDB connection, but since I've never used it, I don't really know what I am doing wrong. I managed to get a connection in the web.config file, I think, but now I get the 'must declare scalar variable' error. I thought I declared it, but it. [code]
View 1 RepliesWe build a class (i.e. Server) and create a LOAD method that loads a dataset with all the details of that object.We need all that information sometimes... but what about when we only need one piece of data from that object (i.e. webserviceUrl).Should we build classes with a bunch of scalar methods that get back single pieces of data as opposed to only getting ALL the data and then only taking what we need?It's a waste to get all the data when we dont always need all of it but it also will take longer to write the extra methods..
View 2 RepliesWhen I type in cntrows. I get all my table variables except the one I want which is TotalComments. How do I return the Count from my scalar query? I have a Table Adapter named :
[Code]...
I have been stuck for a long time on this simple but obtuse message "Must Declare the Scalar Variable"
I have a vb.net and SQL code that inserts data into a simple table. It works OK with sample data, but when I try to use a parameter (insertcommand.Parameters.Add("@ID", SqlDbType.Int, 3).Value = 50) it gives me the error. If I replace the @ID with just a number it works.
Eventually .Value = txtid.text if I can get the parameter to work.
Dim connection As New SqlConnection
Dim connectionString As String =
"Data Source=LAPTOP-PCSQLEXPRESS2008;Initial Catalog=golf;" &
[Code]....
how i would check to see if a given class supports the >, = and < operators?
Given an object passed in, I am looking for code that implements the following logic:
If GetType(someObj).SupportsScalarComparisons() Then ...
I don't know if this is a case for Reflection, or ?
I am trying to update a table. I am trying to add the value 1 to the cells the user querys, i.e.,
user enters 1124
I want to add 1 to all of the cells the AccntRep = 1124
I am receiving this error
"Additional information: Must declare the scalar variable "@RepNo""
I get the the value the user enters and store it in the variable RepNo
'Query to return tuples of AccntRep
Me.CustomerContactsTableAdapter.Search(Me.CompanyDatabaseDataSet.CustomerContacts, New System.Nullable(Of Double)(CType(RepNoToolStripTextBox.Text, Double)))
'Get value from Query Box
Dim RepNo As String
RepNo = RepNoToolStripTextBox.Text
[Code] .....
I have Customers table in a database. I'd like to create List of CustomerNames using entity framework 4.1. How can I do that in Visual Basic?
Dim customerNames = (From c In _context.Customers
Select New With {c.CustomerName}).ToList()
brings a list of anonymous objects.
I want to retrieve total value from sales table in sqlcommand object. Below is my sample code.I will get error if there was no data in the tabel that matched my query saying that null could not be converted into decimal.
I would not get error if there was data that matched my query and returned the total value in tmpSales variable.My question is what is the best way to deal with this situation?
Dim CmdTmp As System.Data.SqlClient.SqlCommand
Dim tmpSales As Decimal
CmdSales = New System.Data.SqlClient.SqlCommand("SELECT SUM(Total) FROM Sales WHERE Date>= '1 Jan 2011' And Date<= '30 Jan 2011", ConDB)tmpSales = CmdSales.ExecuteScalar
I am currently writing a scalar valued function and I'm having a few issue with the returned result. I have narrowed the problem down to a calculation that convert the difference between two dates as a percentage/decimal. No matter what I try the return value is always a whole number
set @earnedpremium = (@premium * @pretripearnings) + ((@premium - (@premium * @pretripearnings)) * cast((datediff(day, @outdate, @experiencedate) / datediff(day, @outdate, @returndate))as decimal(5,2)))
The cast section needs to return the percentage, I know the rest is working fine through some elimination and testing.