The way we create our DataSet right now is right click on project then choose dataset and create every table then each element that makes up the table. There are at least 10 tables with over 10 elements in each.
View 1 RepliesHow can I generate a Crystal Report without dataset?I want to use Storedprocedure from SQL Server 2005.
View 1 RepliesI need to generate a flat file from my scanner MC9090 or MC9060 to my computer.
View 1 Replieshow to make a program generating exe file?I want to do something where i can click to a button and exe file will be generated napr.in C:
View 29 RepliesJust recently got into experimenting with NLog, and it occurs to me that I would like to be able to add header information to the top a log file such as:
Executable name
File version
Release Date
Windows User ID
etc...
After some searching I have been unable to find anything in the existing on-line documentation or code forums which indicates this type of functionality. Is this possible? I have always previously included this sort of information in log files, and have found it useful on numerous occsions in the past, when sourcing information on production issues at customer sites. Admittedly, this functionality was custom built for the solutions and not based on any of the current .NET logging frameworks.
How can I stop the ProjectFile.xml file appearing every time I build my project file in the release folder?
View 3 RepliesMajor problems with the Schema. I am using the DataGrid and not the VB Express 2010 DataGridView. Using code to make a new DataSet and DataView. What is confusing me is when adding Items after right clicking the application in the Solution Explorer, the add items shows DataSet, Xml To Schema, and Xml File. It is obvious that I don't know how to generate an xsd file that I can read into a code generated DataSet. If someone is familiar with xml and VB Express2010. how to generate an xsd file using DataGrid instead of DataGridView that I can read into a code generated DataSet?
[Code]...
I would like to know how I could generate code from a text file in a particular format into a VB.net or C# source file.I would like my code generating program to read text file having the following format:[code]The idea is to compile the main code after the user have modified the txt file and used the code generating program. I would prefer to write the code generating program in C, python or C#.
View 4 RepliesI've two Strings which I'm loading from a SQL Server 2008 database (nvarchar-field)After loading them from the database Visual Studio 2010 displays them as follows in the watch window:
str1 = "Test"
str2 = "Test"
But the comparison with str1 = str2 returns False If I write those strings to a file with UTF8 Encoding the result is as expected:
Test
Test
If I write those strings to a file with ANSI (Default) Encoding the result is NOT as expected:
?Test
Test
Converting the strings to bytes:
System.Text.Encoding.Default.GetBytes(str1) 'Returns ByteArray {63, 84, 101, 115, 116}
System.Text.Encoding.Default.GetBytes(str2) 'Returns ByteArray {84, 101, 115, 116}
System.Text.Encoding.UTF8.GetBytes(str1) 'Returns ByteArray {239, 187, 191, 84, 101, 115, 116}
System.Text.Encoding.UTF8.GetBytes(str2) 'Returns ByteArray {84, 101, 115, 116}
Where is the Byte 63 in case of ANSI Encoding OR Bytes 239, 187, 191 in case of UTF8 Encoding for str1 coming from?Well, Bytes 239, 187, 191 are the BOM for UTF8. The question here would more likely be: Why do I get the BOM for str1 but not for str2?(Well, the values are values passed to a webservice which inserts them into the database, the initial values are passed to this webservice by a client I've no control over)
I am using source safe to maintaine my code.Recently I copied my code to another machine.But everytime i build my project i am getting below error:Problem generating manifest. Could not load file or assembly
'D:WorkingFolderProjectSubFolderobjReleaseSubFolder.exe.manifest' or one of its dependencies. An attempt was made to load a program with an incorrect format.When i check above manifest file is empty (0k).I tried rebuilding (after cleaning solution) , also tried with copy pasting previus manifest file content.None of above solution worked.
I am using Microsoft OpenXml SDK 2.0 to create Office 2007, 2010 files, specifically a very simple excel file. It has a simple header which is merged with 6 cells to center. Bold font size 16. There are 6 columns and each has a header. Bold font size 14. There are rows of data related to each 6 columns. I am looking for decent examples of OpenXml SDK 2.0 to get started.
View 4 RepliesWhen in VS 2008 if a developer hits the ''' it generates the XML comment tags for you, but this only works when the project setting for "Generate XML documentation file" is checked. Is there a way to tell VS to generate the XML Comment tags, regardless of the project setting? I think it is possible that someone may want comments but not create a XML documentation file. In this case I am exceeding the current Team Settings, yet other developers don't want me to change this project setting. This forces me to flip this back before checking in the project. I have the same problem with other Project settings like "code Analysis". This is only a problem for VB.NET projects.
View 4 RepliesI have a form with a datgridveiw on it, but rather than connecting to a data source (SQL 2005 Express), I want to use a .uld file to do it. I can create the .udl file fine and the connection test works, but I havn't got a clue how to connect to my datagrid, or what the code is and when and where to create the connection and disconnect from it.
View 6 RepliesI have the following code which output data in an XML format and updates a row in the dataset to say its been exported.[code]...
View 5 RepliesI'm getting this error 'column' argument cannot be null. Parameter name: column at the bold character instruction. Also I would like to know how to relate two tables with two key columns in each table
I'm getting this error 'column' argument cannot be null. Parameter name: column at the bold character instruction. Also I would like to know how to relate two tables with two key columns in each table
[Code]...
I want to create a web application,specifically an e-shop and I want to be able to export a xml file from a dataset with products.
Is this feasible with visual studio and vb.NET? If so
How would you export a dataset to a csv file?
View 4 RepliesI have a form which contains a datagridview which lists items.I have a button that will export all of my dataset to a text file:-
Dim str As New System.Text.StringBuilder()
For Each dr As DataRow In Me.ContactsDataSet.Contacts
For Each field As Object In dr.ItemArray
str.Append(field.ToString & ",")
[code]....
How can I export only the rows that I select (if I setup a checkbox column in my datagridview, I want be be able to only export the items that are checked)
I'm using the code below to filter a large xml file which causes it to run too slow, how do I convert the code below to filter my large xml file by using a dataset instead, I believe that would help speed up my search results.[code]
View 4 RepliesI am creating XML files and load them back again. I use this following code to write xml to a folder. the code below will put date and time to the file name. and this code works fine.[code]...
Again, I want to load the last xml file back and put in a dataset. I normally write code like [url]...
I am trying to populate a dataset from an XML file. Within the xml file are some € signs. However, when the data is read from the XML, the € sign is displayed as a ?. Has anyone seen this behaviour before, and if so do you know how to correct this? Below is a copy of the code i use to read the data from the xml file:
Public Function ReadExportFile(ByVal sFilePath As String) As Boolean
Try
msExportFile = sFilePath
[Code].....
My problem is, I'm using a very large xml file (260MNB) and my search results takes too ong, I believe running a search against a dataset would be a lot quicker.
Dim SearchCriteria As String = "Link_ID <> -1"
If Not (TextBox7.Text = String.Empty) Then
If astrixState = 0 Then
[code].....
However, now when I open it in design view and add a new tableadapter I now cannot reference the new objects from the code. Likewise if I delete one of the existing tables in the dataset, it still appears to be there from the code (ie in intellisense)Similarly, when I examine the .xsd file, the changes I've made i the designer appear, but the changes are NOT happening in the dataset.designer.vb file. It's as if the two files are somehow out of sync
View 3 RepliesI have a comma delimited text file. I need to write this file to xml. I was thinking of first loading a dataset from the text document and then working from there. Is this a good way to go about it?Also how would I load the dataset from a comma delimited text file. The text is enclosed in quotation marks which I want to be removed
View 7 RepliesWhen i output my dataset to an xml file, 87 nested tables with 218 class object (system.type.object) columms i get 247,691 instances of output like this."msdata:InstanceType="LotNet.LForm+Pointer, Learing Programs, Version=1.3.0.9, Culture=neutral, PublicKeyToken=null" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata">" In this case the decluration is more then twice the size of the Pointer. Is there any way to supress this kind of output the data is only used for internal consumption by other moduals.
View 2 RepliesI want to load an xls file to dataset, edit the data, and import them in mysql.My problem is that I can't load the file. It seems like it ignores the file completely.
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmd1.Click
Dim MyConn As OleDbConnection
Dim myPath As String = "C:TempManinLottery2009.xls"
[code]....
I am stack at work finishing my program.I have a piece of code to write an xml file.
Dim ds As New DataSet
Dim dt As DataTable = GetDtable()
ds.Tables.Add(dt)
[code]....
That work will write an XML file whatever I put in the datatable (or dataset). It is just a simple code and it works fine. The problem is it will replace the old file everytime the new file is created. I really don't want that to happen. I also want to include 2 variables (username, sessionID) also time of the file created in the file name. So file name will be Username_sessionID_time.xml rathen than a fixed name.
How to write xml foreach datarow in dataset? I have dataset with 5 record in table, i want write to xml file with 5 xml file. in one xml file have one record.
View 2 Replieshow to populate my Dataset into Crystal Reports and exporting to PDF File?
View 2 RepliesI am creating a database application via visual studio, using VB.NET and with an access database. I've connected them and have been using them fine so far however I've had to make some changes to the original access database. I am unable to find an obvious way to update the current dataset object within the project from the new updated source file. My database has this new schema but the dataset has the old one so its causing conflicts. The only way I've found to do this in the past is to manually update the dataset with the changes I've made in the access file, so actually doing the same thing twice! Surely this isn't the only way? The changes I've recently made are massive so will take sometime to have to do it all again. If I delete the current datasource object and add it again, there are many errors left from the deletion. If I manually try to update the files, there's always some hidden ones I've missed. Ive found some sort of guide for updating the datasource via the dataset but what I want to do is the opposite!
View 4 Replies