So I have the following
objCommand = New OleDbCommand("SELECT right(invoice.Barcode,5) AS [Book Title], format(stamp,'mm/dd/yyyy') AS [Date Scanned], count(*) AS [Returned] FROM invoice WHERE class IN ( @classString ) GROUP BY right(invoice.Barcode,5), stamp ORDER BY
[code].....
after that, I try to add crystal report 2008 component to VB.net .By right click on toolbox choose items and checked crystal report viewerIt doesn't seem works, there is no crystal report 2008 component on toolbox
View 17 RepliesI am trying to returns records based on the last name of a customer in an access db. When I run the query in Access it works fine, the name in the examples returns 3 records with that last name. I use the same basic structure for other queries based on other fields (ID, UnitID etc) and they work fine.
[Code]...
I am getting the missing operator error with this, could you help.
Dim s As String
If ListBox1.SelectedIndex >= 0 Then
s = " WHERE SalesRep = '" & ListBox1.SelectedItem.ToString & "'"
End If
If ListBox2.SelectedIndex >= 0 Then
[Code]...
I am trying to format xml entries I have so that I can use the xmltextreader without getting errors. I added a default header and footer in the event I notice there is no opening or closing tags. I remove illegal characters and check for unicode but I always find an issue where an entry slips in and gives the error: data at the root level is invalid and when I check that entry is slipped through the cleaning process or just has an unmatched tag somewhere.
Now I use
Dim stringSplitter() As String = {"</entry>"}
' split the file content based on the closing entry tag
sampleResults = _html.Split(stringSplitter, StringSplitOptions.RemoveEmptyEntries)
To split my xml into individual entries before I start the cleanup process.
Here are my default headers:
Private defaultheader = "xmlns=""[URL]"""
Private headerl As String = "<?xml version=""1.0"" encoding=""utf-8""?>" & vbNewLine & "<entry " & defaultNameSpace & ">"
Private footer As String = "</entry>"
Is there any tool in the .net framework that can detect and cleanup unmatched tags so that I can get this to work.
Just a quick questio with what I'm sure will recieve an incredibly simple answer.Problem: After saving and restarting Vb the project I am working on seems to lose design view. In the 'view' drop down menu where you would see 'code menu f7' 'design view shift + f7' I only see the code view and not the design view. The tab for my project which would normally say form1.vb (design) now only says form1.vb. The coresponding window for that tab does not show the GUI I had created just a blank white page.
View 8 Repliessome of the xelements within the query were calling for tags that didn't exist in the original xml, heres a simple example of what i mean.
element = _
<xml>
<object>
<string>someString</string>
[code]....
So how do i change the querry so that it wont produce a null error if the tags asked for are not present.
I've just set up Visual studio 2003 on a new machine, and I'm not getting the tooltips appearing when I hover over variables in debug mode.Strangely enough, I've also just installed VB6 on the same machine, and I'm getting the same problem on there.
View 1 RepliesOk, so, as you know [or not], I've been working on a custom file format,I have a basis code down. I've modified it to something a little different.The problem is not in the saving, which works just fine. It's the loading.Here's the ENTIRE
vb.net
Imports System.IO
Imports System.Text.Encoding
[code]....
I have VSTS 2008 SP1 with Extensions for SharePoint Svcs 1.3 running on Windows Server 2008. I VB Class Library project and I am trying to add a new CSS file to the project. My instructions were to use Add New Item and use the Stylesheet Template. But I do not see any such installed template under the categories.Where do I find this CSS Stylesheet template for VB porojects and install it in VSTS 2008 ?
VSTS 2008 installed products:
Microsoft Visual Studio 2008
Version 9.0.30729.1 SP
[code]....
I'm having a hard time figuring out why my code will not produce a datatable with text.
VB
For Each line In Values
' Create rows collection using TableRow object to dynamically add rows
Dim tRow As New TableRow()
[code]....
I'm reading three bytes from a byte array. They are supposed to be the "Binary code of the e-card no". (e-card is a electronic card used for storing different information). Well, it works fine sometimes, and sometimes not.
[Code]...
Ok so I have a small problem with an error I am catching. It only produces the file name and not the actual path of the file.I want to delete a folder and all the files and folders inside of it. However an error is thrown when a file is "read-only". A quick fix would be to set the attributes of that file to normal and then try again, the only problem is the error doesn't give you the location of the file.
2008
Module Module1
Sub Main()
[code]....
I have program, which takes scripts (RGSS) and inserts them into a database. These scripts have lots of quotes and things like that inside them, but I don't think thats the issue here.
The error: Syntax error (missing operator) in query expression
[Code]....
How can i do a workaround for this? I two databases(.sdf). Database A has table A1 Database B has table A2 Table A1 is an exact duplicate of A2 minus 3 columns My dataset(.xsd) is based off of tableA2 in Database B. I can fill all my tableadapters in Database A and all info in table A1 using the dataset. My problem lies when I do TableAdapter.Update() for Table A1(Since the dataset has the 3 missing fields) it tries to update table A1 with info that isn't there and I get an error. How can I update table A1 and ignore the 3 missing columns using the single dataset? Or is TableAdapter.Update() designed to Update the Database with all columns found in the dataset ?
View 1 RepliesI've been trying to pass two parameters to my report using code the two parameters are DateTime type, my problem is crystal report viewer is still asking for the first parameter only and it accepts the second one?! in my report i've used two parameters ?firstDate and ?secondDate as dateTime parameters and used them in selctionformula where the date is between the two paramters.[code]...
View 4 RepliesHow can I set up parameters to work with my project?
Like execute_shell("myapplication.exe -filename.txt") or anything like that.
I need to call a function that expects a DataType as a paremeter. I fail to get the right syntax to specify a datatype (integer, string, single, boolean, etc):
Public Sub AddSetting(ByVal PropertyName As String, ByVal PropertyType As Type, ByVal DefaultValue As String)
Dim p As New SettingsProperty(PropertyName)
p.PropertyType = PropertyType
p.DefaultValue = DefaultValue
[Code] .....
I am working vb.net08. Access Db. I am sending my below code for refference. Actually i am getting error when i am sending values from datatable to Temp Table in the Access Db. Error is : "No value given from one or more requaired parameters". In my datatable name called 'Crosstab1' few columns having text type and few columns having Value type. So i am getting error while i am Inserting values into Temp Table Called 'Official'. My Code is:
[Code]....
Can anyone see what I'm doing wrong in this
Dim connStr As String = "connection string goes here"
Dim conn As New Odbc.OdbcConnection(connStr)
Dim comm As New Odbc.OdbcCommand("insert into mytable values (0, @P1, @P2, null, @P3, 'n')", conn)
[Code]....
I get "A syntax error has occured." It appears as though my parameters aren't getting replaced with the values I'm telling it to use.
I get this error every time I try to debug.But, I do not know how to fix it or why it started occurring.
View 1 Replieswe are suposed to create a program that we like with certain peramiters, I have done as much however I have an error and I can not find a solution anywhere. We are, before you ask, able to seek help on this matter. Here is what I have:
[code]...
I cant seem to find a solution on how to pass parameters to another exe like adding some parameters after path in shortcut, and then launching that shortcut, only I want to do it directly without making shortcuts. So ,how would I pass parameters needed to start another exe (console in my case)?
View 1 Replies[code]That code will add a new DropDownItem everytime I click on it, then everytime I click on those new created items it calls my "aa" function. How to I set this up so I can send a parameter? It just needs to be a single int parameter.
View 15 Repliesi've got a database with a table called Customers, and i've created a form so that i can edit the customer details and update the database. However when i click the update button, it doesn't work and keeps coming up with the error which i've put in the title.
Private Sub btnupdatecustomer_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnupdatecustomer.Click
If MessageBox.Show("Are you sure you want to update your details?", "Save", MessageBoxButtons.YesNo) = Windows.Forms.DialogResult.Yes Then
Dim intPosition As Integer
[code]....
The bold/underlined text is where the error is coming up.What am i doing wrong? I've got a feeling it is something really stupid as i modelled the code on an example project that a teacher gave me, so it's practically the same code except for the field names etc.
as i need add the two commandline parameter on debug window.
/url=
one is okay
[code].....
i would like to know something more relating to parameters. i have always been adviced to use parameters but i am bit confused as to how to use parameters while filling a dataset like if i am using a oledbcommand i can always use paramters but how do i parameterise the following :
dgMastDet.DataSource = Nothing
myBindingPenBase = Nothing
txtCd.DataBindings.Clear()
[code]....
i am using the above code to filter a list in the dgv as a help dialog for the selection of a master.my prob. is the now xFilter is to be typed in a regional language. so it is bound to have an ' as a character at some point or the other and if that comes in the char. then it will b giving me an error.. so how do i use it as a parameter ?
i know how to use parameters on INSERT, UPDATE and DELETE into sql server.like:
VBNet
updateCMD = "UPDATE table SET somevalue= @valueparam1 WHERE ID = 2"
Adapter.SelectCommand = New SqlCommand(updateCMD)
[code]....
I am using Visual Basic 2008 / MYSQL
Basically i have 2 tables in mysql called Data and products
The first sql query i want to do is something like this to scroll through the recordset of products and bring back information;
dbquery.commandtext = "select quantity, sku, condition from products"
But then what i want to do is bring back information from the Data table based on the sku and condition of the first sql?
so it would be something like this
subquery.commandtext = "select lowestprice from data where sku = *SKU FROM FIRST TABLE* and condition = *CONDITIONFROM FIRST TABLE*"
In java the constructor is as follows
[Code]...
can i make 4 constructors with diffrent parameters. now in vb how can i write constructor with parameters.