Search:
Type: Posts; User: Alfarata
Search:
Search took 0.03 seconds.
-
As you may have noticed I am having problems with this database query. I have little or no training in VB.net or SQL. But, I am trying to figure this out. Let me explain what I’m try to do.
I have a...
-
SQL.ExecQuery("SELECT VendorName, MachineNumber,Date, Description, Quantity, Price, Quantity * Price AS TOTAL " &
"FROM Parts " &
"WHERE...
-
I had written this 6 months ago. with some help. I stepped away for a while due to health problems. I was aske to do some additional work making a grid to show monies spent on a piece of equipment....
-
I HAVE A SYNTAX PROBLEM THAT IS KICKING MY BUTT. I'M SURE THE ANSWER WILL EMBARASS ME BUT HER IT IS.
'****EXECUTE QUERY AND POPULATE GRID*****
SQL.ExecQuery("SELECT VendorName,...
-
I am using the openfiledialog to pick a file which I then use the
OpenFileDialog1.ShowDialog()
FilePathtxt.Text = OpenFileDialog1.FileName
...
-
Thanks
I like the last item best
-
Imports System.IO
Public Class testform
Private Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click
FilePathtxt.Text = Nothing
...
-
-
Private Sub cmdSearch_Click(sender As Object, e As EventArgs) Handles cmdSearch.Click
Dim MyDays As Integer
Integer.TryParse(txtDays.Text, MyDays)
'EXECUTE QUERY AND...
-
This appears to work.
Private Sub cmdSearch_Click(sender As Object, e As EventArgs) Handles cmdSearch.Click
SQL.ExecQuery("SELECT PartusedID, VendorName, MachineNumber,...
-
I can run this query using this form no problem
Private Sub cmdSearch_Click(sender As Object, e As EventArgs) Handles cmdSearch.Click
SQL.ExecQuery("SELECT PartusedID,...
-
I have uninstalled the report viewer and reinstalled it with no errors. All my error remained every page showed errors. The error said I had to fix the problem from the design view and not to change...
-
Every page I have the references a reportviewer control shows this error
The designer cannot process the code at line 28: Me.HiTechDataSet8PrintWO = New HiTech3.HiTechDataSet8PrintWO() The code...
-
I need to find the autofill # named WorkOrderID in table Workorders
SQL.ExecQuery(" SELECT * " &
"FROM WorkOrders " &
" ORDER BY WorkOrderID " &
...
-
thanks for your time and help. This might not be kosher but it is working and a 2:00 AM that's cool. Here is my code change i'm sure tomorrow I can clean it up some.
Try
...
-
I have the second query that uses the Parameter Mine is named WOID, that data has had the information passed from a text box. That part is working. when I run the query from the query builder it...
-
I guess I slow but do not seem to be able to figure out how to do a query without asking for the particular item I want to query on. Its not a known item until you decide to ask for it. If I have a...
-
I guess I slow but do not seem to be able to figure out how to do a query without asking for the particular item I want to query on. Its not a known item until you decide to ask for it. If I have a...
-
I am trying to print out a report based on the data entered in a text box as the parameter for the ALLWorkOrdersTableAdapter. it has listed one normal Fill,GetData() all items, and one...
-
I GET THIS ERROR
'Private Shared Function NEWMethod()
' Dim WOID As New ReportParameter
' Return WOID
'End Function
Private Sub cmdPrint_Click(sender As Object, e...
-
Yes one record is what should be printed. I enter a 12 in the txtbox on the PrintWO page with the .ReportViewer1 on it The txtBoxWO gets the Input The cmdPrint buttons collects it and the code Runs....
-
Been fighting this for a week. I have deleted all and restarted. I have a Query that works correctly in my table adapter as a FillBY, GetDataBY(WOID). It runs and works in query builder.
But when I...
-
HEE IS THE CODEIN XML STARTING LINE 97 THRU 126
Deserialization failed: The element 'Report' in namespace
'http://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition' has invalid...
-
sO I HAVE BEEN FIGHTING THIS FOR 5 DAYS. I HAVE FOUND MORE ISSUES THAN I CARE TO THINK ABOUT. BUT APPARTENTLY VISUAL STUDIO HAS AN ISSUE WITH REPORTS AND A FILLBY ADAPTER. FIRST MY LIST OF DATA...
-
oK I MADE THIS CHANGE AND NOW HAVE THIS ERROR
System.InvalidCastException
HResult=0x80004002
Message=Conversion from string "WOID" to type 'Integer' is not valid.
...
-
Sorry here is the error description:
Severity Code Description Project File Line Suppression State
Error BC30455 Argument not specified for parameter 'WOID' of 'Public Overridable Overloads...
-
I have been working on doing some reports with a Parameter entered prior to printing I seem to be narrowing the problem But I now have another one that I need help with,
Imports...
-
I have been looking and reading and have made some additional changes.
Private Sub txtPrint_Click(sender As Object, e As EventArgs) Handles txtPrint.Click
Dim WOID As New ReportParameter...
-
SORRY
THE 'WO' parameter is missing a value
-
I AM TRYING TO PASS A USER INPUTED VARABLE INTO A PARAMETER FOR THE REPORT BUT NO MATTER HOW I LOOK AT THIS AND THE DIFFERENT WAY I HAVE SEEN IT DONE ON THE WEB I CAN NOT GET IT TO WORK. MOST...
-
HOW CAN I HAVE THE CHILD FORMS ALWAYS OPEN IN THE MAXIMUM SIZE. TO FILL THE MDI PARENT? THE WINDOW STATE I AM USING DOES NOT ALWAYS WORK MOST TIMES IT DOES NOT.
THANKS
Private Sub...
-
Thanks
I will do so.
But this appears to work
Private Sub DGVIEW5_MouseClick(sender As Object, e As MouseEventArgs) Handles DGVIEW5.MouseClick
TextBox1.Text =...
-
Thanks
I will do so.
But this appears to work
Private Sub DGVIEW5_MouseClick(sender As Object, e As MouseEventArgs) Handles DGVIEW5.MouseClick
TextBox1.Text =...
-
I need to figure out how to find the row number of a Data Grid View when I click on a row.
I'm thinking I need to use Mouse Click event but how to I ask for the row selected.
Thanks
-
-
I am only guessing here but are you saying I should look at the msgboxes with any exception text? If so then I'm lost because I have seen nothing about a problem. I just see and empty data view grid...
-
This is my query in MSSQL 2017 works fine in the database
SELECT WorkOrderID, MachineNumber, WorkorderDate, Priority, Problem, Description, EmployeeName
FROM dbo.WorkOrders...
-
Thanks
I never gave that a thought.
Thanks
Bill
-
When trying to save my data I am getting this error. "Conversion Failed when converting date and/or time from character string.
I collect my date time from a Date Picker Box. this variable is to be...
-
In the code below near the bottom is marked the line I need to translate. I want to be able to update this Datagridview
This code I have found and have be using from youTube. It is working fine in...
|
Click Here to Expand Forum to Full Width
|