I am using xml reader to read an xml file into a dataset and and then create some dataviews and bindingsources for binding combo and text boxes as such:
Dim folderName As String
Dim xmlFile As XmlReader
Dim ds As New DataSet()
[code]....
I don't know how to do the same thing I am trying something like:
Me.yearavgdomtxt.Text = CStr(ds.Tables("Property").Compute("AVG(DaysOnMarket)", Nothing))
No error but no result
here is my current line of
Me.highlistpricetxt.Text = CStr(dtlist.Compute("Max([" & Form10.lp_txt.Text & "])", ""))
I thought this was the way to format the result but obviously not
Me.highlistpricetxt.Text = Format(CStr(dtlist.Compute("Max([" & Form10.lp_txt.Text & "])", "")), "#,###")
On another note I am not even sure why this is working since my column value is in string format, i thought it would need to be in some form of integer value to compute?
Is there a way to see exactly what the functions are doing. What i mean is there a way to see the class? I know what it does, i just want to know the code.
For example the function: Membership.FindUsersByName()
What I am trying to do is have a class where the functions of the same name are both instance functions and shared functions.
Public Shared Function Get...(byval xx as xx)
and
Public Function Get...
The Public Function uses a Property xx created in the constructor, whereas the Shared Function has the parameters (byval xx as xx).
I want to access data using both the datasets.
Private Sub Button3_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button3.Click
Try
[Code]....
In my code i have dataset name ds and table named Info1,when i write ds after that how tablename is coming,its not possible? How to do that ?
I've read that API function calls in .NET aren't needed nearly as much as they were in VB 6 as .NET can do so much more directly. So, I don't suppose there is list out there anywhere that details API functions and how you can accomplish the same thing in .NET without API?
View 5 RepliesI'm having a trouble with a function from a class and I need some help.I've just 1 webpage and 1 vb file. In the vb file I have something like this:
Public Class myclass
Inherits System.Web.UI.Page
<System.Runtime.InteropServices.DllImport("somelib.dll")> _
Public Shared Function function1(ByVal par1 As string _
ByVal par2 As string) As Long
End Function
End Class
[Code]...
I have a solution with 5 visual basic projects in it. Each project has an identical module with a few functions and constants - like handling our RS232 data, outputting events to log files, etc, etc..
If I want to change any of this common code, then I have to manually go through and change in each project. Is there a way to have a single module or class that's shared throughout the projects in the entire solution? I've considered creating and referencing a class library, but I'm likely to be making several little tweaks and changes to this "global code" and that method sounds like it could be just as awkward. Can I not just have a module that's visible to all projects, and compiled into each one seperately when the solution is built?
I am trying to get a handle on SyncLock and multithreading, but I am having some trouble wrapping my head around exactly how it should be implemented. I have a Public Class Utilities with a many Shared Functions. I want to make sure that each function can only be executed when there are no other concurrent calls to the same function. So If I have 2 functions, A and B in a Public Class Utilities, what is the syntax so that a function "locks" while it is being executed, preventing any subsequent calls until the "locking" thread has completed?
CODE
Public Class Utilities
Public Shared Function A (ByRef i As Integer) As Integer
[CODE].............................
I know I need to wrap the statements of execution in a SyncLock block, but I am unsure of the scope of the parameter used with SyncLock...is it private to the function, class, etc? Can the same object be used to lock both functions if they are independent?
I am attempting to have my program select a file, create DataTables and then perform some other functions. I want to be able to open another file and re-do the same steps.The problem I am having is that I add columns to my Datatables and when I try and to open another file while one is already open I get a message that a column of xyz is already added how do I properly "clear my datatable" or perhaps that isnt even the correct approach? Here is the code I have that Opens a File
HTML
Private Sub OpenToolStripMenuItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles OpenToolStripMenuItem.Click
[code]....
This was working at one time but after adding to my project I must have placed something in the wrong place inadvertantly or it has soemthing to do with adding columns,?
1) Is it possible to access the Excel mathematical functions without actually opening Excel?
I was thinking of through a DLL WinAPI call or maybe a delegate function or smaller program?
2) Does anyone know of a MS link or area that gives instruction on "how to" use every function of every Windows DLL at all?
Or for all those that Microsoft have chosen to document online at least.
I want to check what are in the dataset, how?
?daLS.GetDataset.Tables.Item(0).Rows
16
I have the following function: Public Shared Function GetLookupTableData(ByVal TableName As String, ByVal WhereClause As String) As DataTable
[Code]...
With one xml file it loads the schema and data just fine, but with another xml file it only loads the schema and not the data. There's no error thrown - just no data loaded.
Anybody have any ideas? I've attached the .xml file for your review. I would have attached the .xsd but the system wouldn't allow it.
I've got a requirement to create report datasets by taking a list of tables, columns from those tables, filters on the tables, and relations between the tables - and build a dataset from them. All this information is contained in an xml file. So I:Read the data from the tables in the list into the dataset. Apply any filter criteria on the tables to the default views. Add any relations between the tables to the dataset relations. So far, so good, but now comes the hard part. One of the requirements is to create a default view (or table) of columns at the dataset level - with the appropriate constraints and filters applied. So there would be this default table or view that would have, for example, columns 1 & 2 from table1, columns 4 & 7 from table2, and column 5 from table3. This is where I'm stuck, because there doesn't seem to be a 'view' property or function at the dataset level.
[Code]...
I am attemting to read a .txt file database into an xml file and then read the xml file into a DataSet and then bind the dataset to bindingSources and then subsequently bind comboboxes and text boxes to the binding source. I am struggling with how to create bindingsources with different filters. I am not sure if I am even going about this the right way. Perhaps there is a better way. I already have the program working using traditional OLEDB and creating different datatables but I wanted to be able to add and edit my datafile so I decided to convert it to a xml file.
HTML
If Me.OpenFileDialog2.ShowDialog() = Windows.Forms.DialogResult.OK Then
With OpenFileDialog2
folderName = .FileName.Substring(0, .FileName.LastIndexOf(""))
'fill dataset with selected xml table
[Code] .....
Export data from Dataset with multiple table to excel sheet
View 2 Repliesi have a form which accepts inputs from the user. I want to create a crystal report ( not from the database but from the form ) and to create a crystal report, i need to create a dataset. i dont know how to create dataset from the form's input
View 15 RepliesI'm having a little trouble figuring how to do this.I have a dataset with a single table. Each row has the following fields ProductName, Version, CompanyName
The data might look like this
Visual Studio, 2005, Microsoft
Visual Studio, 2008, Microsoft
Office, 2007, Microsoft
I have already populated the TreeView with a list of Company names from a separate table. Now, what I want to do is to loop through my dataset adding a single node for each product under the appropriate manufacturer. Then under each product adding a separate node for each version of that product.
[Code]...
I create one column which is tinyint then I go to VS2008 and create typed dataset by wizard. Then I check that column's datatype it is now byte datatype. MS SQL 2005 tinyint = VS2008 byte ?
View 2 RepliesI'm a bigginer in Visual Studio. I have created the forms using Visual Studio Professional 2005 and a database using Microsoft SQL Server 2005. I have some combo boxes in the forms and want to populate them using the dataset which I have attached to the VB.net project. I used the following method.. but when I run the project, the combo box is still empty..
[Code]...
I was wondering if the following is possible. In a particular operation I want to create a dataset, bulk copy it to another SQL Server, then update a flag column in the copied rows.I'll have a system that will be regularly inserting new rows of data, then at regular intervals want to copy that data to another SQL Server. Once the rows have copied I need to change a flag column so that they won't get copied again.Whilst this is going on there is a strong possibility new rows of data will be being inserted into the source table. These new rows will be copied at another interval.
View 3 RepliesI have created a DataSet.Within the dataset I have 2 DataTables.I have created a DataSet.Relations between the two tables.Now, using DataSet.DataTables.Select.... Would it be possible to perform a search similar to this in SQL?
SELECT * FROM DataTable1
INNER JOIN DataTable2
ON DataTable1.KeyColumn= DataTable2.KeyColumn
[code].....
i try to use this yesterday it work fine..now, it will process too slow.. when fill the dataadapter into the dataset..here is the code it gives 20 menutes still no result.. "no error, no comment. it's like standby
Dim conn1 As MySqlConnection = New MySqlConnection("server=pc1;user id=user;Password=12345;persist security info=True;database=mytsmobile")
conn1.Open()
[code]....
Im inserting records from a dataset to access table by selecting a key(dix) from a listbox. below is the code Sub loop2(ByVal dix)
ds.Clear()
table_name1 = "TestStepDetailTable"
con.ConnectionString = dbprovider
con.Open()
'MsgBox("database is open")
[Code]...
The problem is when i insert a first key(dix) records its coying fine. But when i insert the second set of records in is sorting int he table. but when i looked at the dataset by using gridview the recods appears in a right order. but the updated table is somewat sorted order. Is there any possible way to insert the records in the same order in the dataset..
im having difficulty trying to do mail merge with ms word with dataset. i've tried google to search and i can't find the right solution. with little knowledge in mail merge, i only managed to do this:
[Code]...
the code above will open the document file, merge with 1st record only. what i need is open the template document, but have multiple records. let me give a scenario, i need to print out 10 letters for 10 people, the information in the letter is exactly the same except the name and address. but this should only open 1 word document with multiple records in it, how can i achieve that? then i can print the letter for 10 times with different records.
I have the following
Private ReportAdapter As OleDbDataAdapter 'used for controlling database
Private ReportTable As DataTable
Private ReportManager As CurrencyManager
[code].....
I would like to perform a mail merge between VB.net 2005 and Word 2007 using a dataset from my application, so the user doesn't have to touch word they will just be presented with the mail merged data. I have already created my connection to SQL server and populated the dataset but how can I output the dataset to Word.
View 2 RepliesThis is my vb6 programme for creating recordset in a module. and call it in class
and form
[Code]...
I have a form that has many controls. My next task is to populate the phone number (MaskedTextBox) and phone number type (ComboBox) when the cursor has lost focus from a ComboBox that has auto complete functionality. I have tried to do it and when the cursor leaves focus, the other controls are not populated. Nothing happens. I do not get any errors either. Screen shot attached for the form and I am also using a stored procedure to do this. There are two tables in question here. A client table that the name and phone number and then the second table that has the phone number type (cell, work, home, etc).There is an FK relationship between the two.
This is my stored procedure. It is called sp_GetClientInfoByName.
vb
CREATE PROCEDURE sp_GetClientInfoByName
[code].....
how to load a XML file Embedded in the resource project?
I've do some google, but did not found anything useful
I've place my XML document in the project resource, and I wish to load it in a DataSet/Datatable.