I have made a smtp client in c# and I use this code to split a string that contains multiple recipients.
foreach (var n in txtSendTo.Text.Split(';'))
{
mail.To.Add(n);
[code].....
I have the following code:
Imports System.Data.SqlClient
Public Class Main
Protected WithEvents DataGridView1 As DataGridView
[code]....
When I debug this, I put the line break on that line and look at the Table Value, which shows 0, but I know that there is data for that time frame.
i am using DateTimePicker control....my code is TextBox2.text=DateTimePicker1.Text.......while changing it correctly dispaly the selected date in textbox......the problem is i want to store the date in my database of field datetime type........when i click the add button it shows "Syntax Error Converting DateTime from String"
View 1 RepliesGetting this error when updating a row via a gridview with a sqldatasource in Vb.net/SQL Server 2000. No matter what input (1/1/2010, blank, etc) I give it I can't seem to get it right.
Code before the input is passed to the sp:
Dim sqldatenull As DateTime
Dim DateVerify As DateTime
sqldatenull = DateTime.MaxValue
[Code]....
Im in the process of building a call loggin system and its finally been put on the server, but i keep getting the above error "Title" the first stage it goes to be authorised and when the authoriser auths it...it updates the table with the date they authorised it. which is fine, the next stage is the Business Analyst where they check all the content of the task and then approve it but for some reason unknown to me it keeps falling over on the .dateAuthorised
My Sql Column to hold the date authorised is a Datetime datatype and im converting a string to a data time within the procedure this is my Code behind page
Dim StatusNew As Integer = 53
Dim CurrentStage As Integer = 51
ITUpdateTaskTable.Add("@spWorkID", Replace(TskNumLab.Text, "LC", ""))
[Code].....
I have the following code:
Imports System.Data.SqlClient
Public Class Main
Protected WithEvents DataGridView1 As DataGridView
[Code]....
When I debug this, I put the line break on that line and look at the Table Value, which shows 0, but I know that there is data for that time frame.
There was a syntax error while converting from one data type to another. [ Expression = -1 ].
This part of the code where the issue starts is here: Do While JVReader.Read()
Here is the
CODE:
I have this sql statement to update a column in access db from vb but when I run the program it shows that there is a syntax error in the statement. [code]...
View 2 RepliesI converted a lot of code, and I had some errors in the conversion. There is one that I can't seem to figure it out[code]...
View 2 RepliesI want to select some rows from a sql express 2005 table. I am using this expression: "Starttime >= " & dtpStart.Value dtpStart is a DateTimePicker But I am getting this error: Syntax error: Missing operand after '14' operator.
View 18 RepliesBelow is the code that we have been working on. We have bolded the parts which we are unsure about - they are producing errors. (its near the bottom)The program is designed to generate a random hand of cards out of our list of them. This program is a smaller version of what we hope to have in the full one - ie. It tries to get a random hand of 3 cards out of a possible 5.
The part we are having errors with is getting the images to display on each of the 3 'picturebox' objects using a loop (so we don't have to type each picturebox individually).
[Code]...
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].....
The following code works fine in VBA Goal of the code is to find (select) all cells in an Excel worksheet where the backgrounf cell color is Yellow (6) or Rose (38)
Sub SelectColorsViaArray()
Dim e As Variant
Dim r As Range
Dim x As Range
[code]....
3) With the above, I still do not understand how to integrate the Variant and Array differences from VB6 to VB.Net. I know what to do with all other like: Application.FindFormat.Interior.ColorIndex ... etc.
I'm trying to update data to a Access data base using the following [code]...
View 3 RepliesThis is not a homework of mine and i had never tried ms access database with vb so i just gave it a shot. so this is my first time and i am just trying not asking anyone to complete my homework. I have been searching for this a lot on internet but couldn't find a solution to this so i decided to ask this question here.
i have this sql code. what i want to do is that create a basic login form where users puts it's username in the UsernameTextbox and Password in the PasswordTextbox. If the the information match then a message box appears saying that the user is valid and if the information does not exist, a mesage box appears saying the users is not valid. now everytime i execute(run) the code, i come up with this error: Syntax error (missing operator) in query expression ''UserName' = 'Admin' 'PassWord' = 'testing123''.
The field names(UserName, PassWord) are also correct they are same as in the database. the information put in the username and password textbox are correct and they match the information on the database. But i dont know why this error comes up.
My code module is the following:
Imports System.Data.OleDb
Public Class LoginForm1
' Cancel button
Private Sub Cancel_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Cancel.Click
Me.Close()
End Sub
[CODE]...
I am trying to upload a file to Mainframe machine from my VB.net application. I am getting the following error.The remote server returned an error: (501) Syntax error in parameters or arguments
[code]...
this is my code for adding users in my database but it has an error on the INSERT INTO statement.here is the error: Microsoft office access database engine: syntax error in INSERT INTO statement.
vb.net
Private Sub Button6_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button6.Click
Dim conn As New OleDbConnection(cn)
Dim check As Integer
[code]....
Using 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].....
i use a database in access and I use a query for adaptor and dataset.
The query is next:
Select * from table1, table2 where table1.idsomething=table2.id and table2.name= 'Name1' AND datebirth>=#07.25.1988# AND datebirth<=#07.31.1988# order by datebirth asc
The error is: Syntax error in date in query expression
In the database the format date is dd-mm-yy.Why I have this problem? What is wrong at the query?
the error i get while executing the code below in OleDb
Try
con.Open()
Dim cmd As New OleDbCommand("Select * from customer", con)
cmd.CommandText = " update customer set hr =@hr,min =@min "
cmd.Parameters.AddWithValue("@hr", ComboBoxHr.SelectedIndex.ToString())
cmd.Parameters.AddWithValue("@min", ComboBoxMin.SelectedIndex.ToString())
cmd.ExecuteNonQuery()
[Code]...
Am getting the below error at run-time of executing query in VB.Net. Please give the solution for this
Error : "Syntax Error in INSERT INTO statement" My code is given below
[Code]...
It may be a weird question but it's there a possibility to send an e-mail after an pplication has crashed?
View 3 RepliesI'm looking for some good tutorials for building applications with visual studio 2008
the programming language i prefer is VBA
How can i connect two VB.net applications together so that they can send each other informations ???
View 3 RepliesI've looked around and I haven't found anything that fits my needs.I wish for the program to be able to intercept the Win32 (?) messages that are being sent to my own application, which is written in Visual Basic.As a side note, is "intercept the Win32 messages" the correct phrasing?Either way, an elaboration won't hurt; I wish for the spy tool to intercept the same messages that I would programmatically intercept with WndProc, i.e: the SendMessages and PostMessages.
I wish to make it clear that I am not seeking a program that intercepts the .NET framework events.
Edits:I can see my window and the handles of its child controls, but I do not receive any messages.I am using Windows 7 64 bit.My Spy++ version is 8.00.50727 Semi-solved; I have got a Spy++ alternative ([Window Detective][1]) to work on my virtual machine, which I am most certainly happy with, and would definitely not mind settling for. Although I am still wondering why all the "spy-like" programs I found did not work on my "main" PC... but I guess I needn't care.
Is it possible to run VB applications on a mobile?
View 2 Repliesi get this error when i try to publish my application.I downloaded CAPICOM 2.1.0.2 and copied the CAPICOM.dll but nothing happened
View 1 Replieswhen i publish my applications in visual studio 2008. when it is installed i only see the entry in the programs list at the start menu and the application folder is thrown some where else(wonder where). So i was wondering is there a way to publish an application so that when it is installed, it gets installed in the program files folder on C:\
View 2 RepliesHow I can generate barcodes in my vb.net applications?
View 3 RepliesIs there any real point to learn VB besides as an introductory to grasping the concepts of programming? You never (at least myself) hear of any apps like, Winamp, Windows, Firefox, etc. that used VB.
View 2 Replies