I have created an program that can produce an XML file from the SQL database.and the code is looks like below:
[Code]....
why is there a <NewDataSet></NewDataSet> node?2. How to remove that node?
I'm trying to create a VBasic executable to read a SQL server database and produce a mailing list.I have the SQL routine working fine and had set it up as a stored procedure, but I've just discovered the manager I've written this for is an Access-type and does not have SQL Server installed on her machine. So, I figured I'd make a front end in VBasic.
Dim con As New SqlClient.SqlConnection
con.ConnectionString = "Data Source=mySQLServer;User ID=Username;Password=myPass;"
con.Open()
I am now looking for a way to produce pdf files from xls files. Since the completed programme will be distributed to others, it would have to work on environment without the "pdf producer" I am using.Which is the "pdf producer" to use"?I am now working on the express version of VB 2005 (which does not have crystal report). I have acrobat 8.0 installed but have not figured out how to do that...
View 2 RepliesI've been working creating a few programs in visual studio 10. These work fine on my own PC because I have the .net framework installed. However I need to be able to distribute these programs as a single .exe file download from our website and also as a single .exe file via CD.
Most of the PCs which will be installing my programs won't have .net framework installed and I don't want to force people to have to download the files from the internet (it just seems like so much hassle and I can't guarantee that everyone who wants to install my programs will even have access to the internet).I know that I can set pre-requisites in the publish tab and I have done this whilst setting "Download prerequisites from the same location as my application". I've already downloaded the redistributable files WindowsInstaller-KB893803-v2-x86.exe and dotNetFx40_Full_x86_x64 and I've put the files in the same folder as my project.I then go into the publish wizard and select that users will install the application from a CD-ROM or DVD-ROM. Unfortunately I then get the following errors:
Error 2 The install location for prerequisites has not been set to 'component vendor's web site' and the file 'WindowsInstaller3_1WindowsInstaller-KB893803-v2-x86.exe' in item 'Windows Installer 3.1' can not be located on disk. See Help for more information.ConsumptionCalculatorDraft1
Error 3 The install location for prerequisites has not been set to 'component vendor's web site' and the file 'DotNetFX40dotNetFx40_Full_x86_x64.exe' in item 'Microsoft .NET Framework 4 (x86 and x64)' can not be located on disk. See Help for more information.
ConsumptionCalculatorDraft1
i am developing an application for generating xml file with some details inside and regenerating it whenever i need.Step1: In the user interface,i have placed a gridviewcontrol during run time. i used Datatable for building the table and assign this table as datasource to the datagridview control. last column("GHI") is a checkbox column and its is successfully viewable in the datagridview. the snippet is like this.
dim iDGVWCount as integer
iDGVWCount =1
Dim oDGVW As DataGridView
[code]....
Step 3: if i reopen this xml file and populate the celll details in datagridview, the column 'GHI' is not viewable as checkbox column. it is simply shown like an ordinary cell. the snippet for opening the xml file is shown here.
dim ds as dataset
ds = New DataSet
ds.ReadXml("C: estxml.xml")
[code]....
Question1 : is there any setting needs to be done for bring back this checkbox column automatically in the datagridview while reading from the xml file.
Question2 : how we can bring the value of unchecked column as false in the xml file. the node is included in the xml only if a checkbox is checked.
I am using window programming in visual studio(2008) and i am using LINQ and need to get the data from three table's column e.g A table's 1st column(x),b table's 2nd column(y) and c's table third column(z), and then i have to produce the excel sheet(CSV file).I want to get the table's data in string format in visual studio and then produce the excel sheet.I don't want to use Store procedure and grid view in my program.
View 5 RepliesIs there a way in vb.net to produce a excel file from a certain series of code that could be use for report generation.
View 1 RepliesI have produced an application which works with datasets but I now wish to provide the user the ability to add and admend records within the database.But i wish to do this in a seperate form.My current dataset instanciates classes onLoad.Should i try passing the Dataset to the new form class? although I have the problem where by when i pass the dataset to the form class using code below i get this problem:[code]Should i just create a create a new connection to the database and produce a new dataset for this form? or is there a better way to do this?
View 2 Replies[URL] to create my sqlite db file. I created it as a sqlite db version 3 file. When I go to open the connection
[Code]...
PrivateSubForm1_Load(ByValsender
AsObject,
ByVale
AsSystem.EventArgs)
[code]....
'I am having trouble with the line "senda = suba(sendaobj, EventArgs.Empty)". [code]...
View 12 RepliesHere's the
Sub DestroyUser(ByRef Victomcheck As Integer, ByRef Victorcheck As Integer)
Dim num As Object
WriteSub("destroyuser")
[Code]......
i am making a hairstyle and makeup software in vb and i need to upload the picture which will be edited, to put a hairstyle and makeup on. ive no idea how i can do it.. it is a virtual makeover software and i need to produce the before and after images. please someone help me, my deadline is on the 31st
View 3 RepliesAre the following 2 SQL statements the same? Will they produce the same results?
sql1 = "SELECT * FROM [StudentDetials] WHERE ([Subject1] LIKE '" & Subject(0) & "' OR [Subject2] LIKE '" & Subject(0) & "') AND ([Day1] LIKE '" & TabDay & "' OR [Day2] LIKE '" & TabDay & "') AND ([Time1] >= '" & Time(0) & "' AND [ETime1] <= '" & Time(1) & "' OR [Time2] >= '" & Time(0) & "' AND [ETime2] <= '" & Time(1) & "')"
sql1 = "SELECT * FROM [StudentDetials] WHERE ([Subject1] LIKE '" & Subject(0) & "' AND [Day1] LIKE '" & TabDay & "' AND [Time1] >= '" & Time(0) & "' AND [ETime1] <= '" & Time(1) & "') OR ([Subject2] LIKE '" & Subject(0) & "' AND [Day2] LIKE '" & TabDay & "' AND [Time2] >= '" & Time(0) & "' AND [ETime2] <= '" & Time(1) & "')"
In my case they simply produce the same results but that's because of the data i'm using.
I tried to convert following C# code into VB.NET and got "Expression does not produce a value" error while compiling the code
C# Code
return Fluently.Configure().Mappings(m => m.FluentMappings.AddFromAssemblyOf<MyEntityMapping>())
.Database(SQLiteConfiguration.Standard.InMemory().ShowSql())
.ExposeConfiguration(x => new SchemaExport(x).Execute(false, true, false))
.BuildSessionFactory();
VB.NET Code
Return Fluently.Configure() _
.Mappings(Function(m) m.FluentMappings.AddFromAssemblyOf(Of SubscriptionMap)()) _
.Database(SQLiteConfiguration.Standard.InMemory().ShowSql()) _
.ExposeConfiguration(Function(x) New SchemaExport(x).Execute(False, True, False)) _
.BuildSessionFactory()
The error happens on 2nd last line of VB.NET code, while C# code is compiled without problem.What is wrong with the converting?
I tried to convert following C# code into VB.NET and got "Expression does not produce a value" error while compiling the code
[Code]...
I am porting over some code from .net (vb) to php and I came across some md5 hashing that I can't reproduce in php. In the .net one there are two functions one uses UTF-8 encoding and the other uses Unicode encoding. The output is a different hash when passed in a string
// First function (returns GUID)
Dim oHasher As Cryptography.MD5 = Cryptography.MD5.Create()
Dim oEncoder As New System.Text.UTF8Encoding()
Dim csData() As Byte
[Code]...
but they both produce the same result. Is it possible to produce the same results in php with md5 hashing?
I'm using the below code to produce a ToolTip for each row of a ListView.
When moving vertically across the ListView a ToolTip will appear when the mouse touches between two rows - bypassing any of the ToolTip's options.
Private m_HoveredItem As ListViewItem
Private Sub ListView1_MouseMove(ByVal sender As Object, ByVal e As System.Windows.Forms.MouseEventArgs) Handles lv.MouseMove
[Code].....
I'm not using the ShowItemToolTips property of the ListView because I want to have a more formatted ToolTip (ToolTipIcon, Title etc) I don't believe these options can be set for the ListViews ToolTip?
I've updloaded a sample project of the issue here: [URL].
I noticed that when I build a given C# or VB.NET source to produce a DLL, the binary output is different each time. It would be helpful for our build / deployment process if this was not the case. Can I control this?
View 3 RepliesI am trying to create a custom datasource control.
I have been following this article to the letter (I think...).
I have a skeleton / basic implementation of my datasource, however when I declare it in the markup and try to statically bind it to a gridview, I receive the following error:
The DataSourceID of 'grdVw' must be the ID of a control of type IDataSource
This seems extremely strange to me, since my datasource inherits from DataSourceControl, which in turn implements IDataSource. Even if I explicitly implement IDataSource in my custom datasource, it makes no difference.
My Markup is:
<DataBrokerDataSource ID="objSrcDBroker" runat="server" />
<div>
<asp:GridView ID="grdVw" DataSourceID="objSrcDBroker" DataMember="Table0" runat="server">
[Code].....
Why I cannot get a variable to come in. I keep on getting the error "Expression does not produce a value" for one of my Dims.
Imports System.IO
Public Class Main
Dim image_1 As Integer = Openimg1.FileName
'The line below is the one causing my problem
Dim image_2 As Integer = My.Computer.FileSystem.RenameFile(Openimg1.FileName, "_hid" + System.IO.Path.GetExtension(Openimg1.FileName))
[Code] .....
So basically, how can I create a variable from something that has yet to be created?
I have done the following in a LoginForm:
Private Sub OK_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles OK.Click
If UsernameTextBox.Text = ("username") And PasswordTextBox.Text = ("password") Then MainMenu.Show(Me.Hide) Else MsgBox("Wrong")
End Sub
But it gives me the following error:
Error 1 Expression does not produce a value (on Me.Hide)
how to create data charts in Access / VB ?
View 2 RepliesI am trying making a appliction that produce a invoice, its just a type of business application, in that i want to and form that contain a email sector divided on two tabs one to send email, and second to receive email (like to check my inbox, etc)
View 1 RepliesI have 36 numbers in sets of 5. (eg. 1-2-3-4-5, 2-3-4-5-6 etc..) I need to find all the possible combinations of these numbers which total the same sum. For instance the lowest sum would be: 1 + 2 + 3 + 4 + 5 = 15. The highest possible sum is: 32 + 33 + 34 + 35 + 36 = 170. Now every five number combination within these 36 numbers will sum up between 15 and 170. How would I go about this in vb.net to produce all the possible combinations which would total say 92.
View 6 RepliesI want to re-produce the equivilent of the DowArrow sign on a VB2010 Form label. label1.Text = Chr(ConsoleKey.DownArrow) doesn't work. The nearest character seems to be ASCII DEC 30 value., which will do fine, but Is there anyway I can reproduce this char on my form label, using one line of code, viz- label1.text =
View 6 RepliesIn my project I have a summary data table which i want to export in Excel document, for this purpose i have deployed the following code:
Public Shared Function Main() As Integer
Dim exc As New Application
exc.Visible = True
[Code]....
I get the error of : Exception has been thrown by the target of an invocation
For my applications I created a class to produce custom cursors. One of them is a waitcursor with a percentage in it. It has several backgrounds each one with a filled circle on it and they are positioned in a circle it self (a bit like the java wait thingy). Since I put it in my application I started to get errors at different places in my code, but all related to some memmory problems.
[Code]...
Lets say i have three buttons[cod]e...
how do i write my code under button3 that my result will output 27 on the textbox
I have a scientific datalogging program which I have been developing for a number of years now. We now need to add some functionality so that it produces a moving average of the data being gathered. I can create a queue of myDataClass to do the fifo buffer but I was wondering what the best way doing the averaging might be. As you can see from the code example below myDataClass contains various data structures some of which can be averaged and some which cannot (e.g. the string).
View 6 Replies