I have created an xml schema and an xml file from a datatable. I am now trying to read that data in which is working fine. I can access the data but the problem is that I want to know how many Tables there are in the xml file. For example the setup looks like this: [code] I want to know how many "<table>" objects there are.
View 2 RepliesI have an untyped-Dataset with two related DataTables, and I have a grid bound to the parent DataTable. I used the WriteXMLSchema() method of the parent DataTable in order to save the schema in a xml file. Then I opened the file with the Notepad, deleted two columns from the schema file and saved it. After that, I used the ReadXMLSchema() of this DataTable but -contrary to what I would have thought- the DataTable's structure was unchanged. Using the debugger I noticed that after calling the method the number of columns was the same. Why? How can I make the DataTable's schema to be changed by using a file?
notice that I am using the DataTable's methods and not the Dataset's because I do not want to touch the child DataTable.
I'm using vb.net 2010.I have a DataSet with a Table and data. MyDataSet1 which contains Table1 I want to create another table that is the same as the Table1 but without data, but it should have the columns, etc.
View 1 RepliesI have had a problem with my program not working on a windows 7 machines so i finally built a box with Windows7 to test it. It seems the Schema.ini file is not being created.If I manually place the schema.ini file in the directory my program runs fine any ideas on why the file is not created on a Windows7 machine but is created on XP
schema ini code
Dim safeFileName As String = IO.Path.GetFileName(Me.OpenFileDialog1.FileName)
Dim fs As New FileStream("Schema.ini", FileMode.Create, FileAccess.Write)
[code].....
Are there any commands that make life easy with respect to this? I want to take the column schema of one datatable (.net datatable) and copy it to another new datatable.
View 2 RepliesI have a datatable that was created with the dataset designer. I have it bound to my datagridview. All the columns are set up the way I want, etc. I am performing a SQL operation at runtime, so I can create SQL statements dynamically rather than creating them with the designer. When I try to fill the existing datatable, I get no results. There is no error, but the data i should be seeing in the DGV is not there. However, if I fill a dataset that is created in code at runtime, and then set table(0) of that dataset as the DGV's datasource, the data displays as it should.
[Code]...
I have a php web service that I can call from a php client. I need to call this web service from a vb.net application. When I try to add a reference to this web service I get this error:The root element of a W3C XML Schema should be <schema>here is the top of my wsdl file:
<?xml version="1.0"?>
<!-- partie 1 : Definitions -->
<definitions name="raidService"
[code].....
I created a DetailView of a DataTable in a Form. This also created a BindingNavigator and all of this works fine.However, one TextBox in the Form shows the LangaugeCode and I'd like to use my refLanguage DataTable to show the LanguageName instead. How do I go about doing that?
View 5 RepliesNo mater what I try I can not get my schema file to work, it write and is in the right directory but the column all come as strings no matter what I do?
HTML
Dim fs As New FileStream("Schema.ini", FileMode.Create, FileAccess.Write)
Dim writer As New StreamWriter(fs)
Dim fn As String = Me.OpenFileDialog1.SafeFileName
writer.WriteLine("[" & fn & "]")
If Me.OpenFileDialog1.SafeFileName.EndsWith(".txt") Then
[Code]...
Dim GridDTB as Datatable[code]...
It is updating only on the table "DT3", which is last create table in the array.
I'm developing a VB Web Application in .NET3.5 using Visual Studio 2008. I'm having difficulty in validating some XML as a string before I add it to a HTML form to post to a 3rd party. I have an XML schema file from the 3rd party to validate against and at this point I'd like the application to perform the validation before each post.
After searching I've found references to a XmlValidatingReader but this is obsolete and I'm having difficulty finding another way to do it. Also all the good examples are in C# - for now I'm stuck with VB. This is what I have so far which I'm looking for with! Public Function ValidateXML(ByVal strXML As String) As Boolean
[Code]...
I need to have some of my columns in an integer value not string.So from I can tell so far and I am extremely limited, if I use WriteXml this should write the schema and the data and the readxml will read the schema and the data, although I dont see the schema in my xml file that gets created from my oDS.WriteXml/if I use oDs.WriteSchema I can view the schema file that is created. Thats how I determined the schema is creating all string vlaues for each column..All the fields are of String value as was pointed out, so how do i create my own schema file? or rewrite the one that is created.[code]
View 5 RepliesI am using VB-2005 with SQL server. After compiling I get an error unable to copy the schema file'(null)'
I checked the net and see to check the registry for
HKEY_LOCAL_MACHINESOFTWAREMicrosoftVisualStudio7.1DeploymentSchema
other than
(Default) -
a. DefaultMSISchemaFile
b. DefaultMSMSchemaFile
and both exist, at this point I am not sure what to do other then re-installing VB
I want to select column 'F1' from an excel spreadsheet and dump the data into my datatable 'oleDT'. How do I map the column F1 to the column i've added called 'colTest' ? When i call Fill, the dataTable has 2 columns, which are 'colTest' full of nulls and a created column called F1.[code]...
View 1 RepliesI am facing a problem in inserting a datarow in the Ms access Database though visual basic application.The scenario is like this:I have a table named 'IssueReturn' for library management System. The table has these fields:
MemId Char(10)
BookId Char(10)
DateOfIssue DateTime
[code]....
I have encountered a wierd problem, and I'm unsure if this behaviour is caused by my code or by Windows itself... I can't make any sense of it! Basically, I have written an automated backup system for a text editor. It should save up to 5 backups for each filename, each in a 'AutoBackup<filename><filename>_<number>.bak' format. Here, <filename> is simply the name of the file my program is backing up, and <number> is the first 'free' number. So if the backups are "Test_1, Test_2, Test_4, Test_5", the next backup will be called "Test_3" (since 3 was 'missing'). When there are more than 5 backups, I want my code to delete the oldest files until there are again 5 backups left. I am using the following code for this:
vb.net
'Backup doc.SaveFile(path & "" & filename & "_" & newNum & ".bak") 'If more than max files, delete oldest Do While numOfFiles > maxBackups Dim d As Date Dim maxDate As Date = Date.MaxValue Dim oldestFile As String =
[code].....
Then, after another backup, Test_1.bak is again deleted!I thought this was pretty weird so I had a look at the files in windows explorer, taking a good notice of the creation date... That's when I saw that after Test_1.bak is created a second time (after a file named Test_1.bak was deleted), it carries the same creation date/time as the old (deleted) Test_1.bak..So my code still sees it as the oldest file (while it is actually the newest) and deletes it...
I recently started having problems when creating new schema (xsd) files inside Visual Studio 2008. When I create a new schema file, the only file that is created is the xsd file itself. Neither the designer.vb or xsc files are created, which of course makes it unusable. The problem seems to be caused by the fact that the CustomTool property in the property grid is missing. If I change the CustomTool property to MSDataSetGenerator, then it immediately runs and creates the missing files noted above. How do I reassociate the CustomTool with Schema files?
View 2 RepliesI have written an import routine, that imports a textfile into a database table, using a schema.ini.In the input file, 3 fields are seperated, that should be concatenated in the import-routine. Does anyone know how I can make that happen...Small part of the import-routine, first lines are the last lines of the programatically created schema.ini.
Code:
PrintLine(intFile, "Col11=mededelingen1 Text")
PrintLine(intFile, "Col12=mededelingen2 Text")
[code].....
i have been coding for years, but never integrated XML. So I guess I'm a newbie. I have inserted an XSD file in my project, ARequest.xsd. I created a folder in my project called XML just to organize things, so this file ARequest.xsd, is in this folder.
Now I have a form that displays data from a database that has the same fields that are in this XSD file. Can I load the XSD file into my Windows Form, load the elements from the data on the windows form and then create an XML file then send it? If so how? Any code snippets would be helpful. Now I do know how to create the XML file, we'll call it Test as
[Code]...
I am importing a .txt file to a gatagridview and writing out a Schema.ini fileMy columns that contains a date value is empty in my DGV when i use the:DateTime in my .ini fileIf I set it to Char then my date is populatedDoes this mean my dates in the text file are not really dates but strings ??
View 2 RepliesI was creating an XML Schema from a project 2003 XML. All was fine until I rebooted the machine and tried to re-open the file. I am now getting an error along the lines of:
"Identity Constraint not declared".
I've compressed and attached the file.
I am having a problem with my program that is desinged to read a 3rd party text file database. I posted previosuly about a problem inserting an item in a new row and the column was expectig a different data type. It appears that sometimes the column is being determined to be of decimal value, I dont understand why. the fields contain information such as
Col1
F123456
CLW-12321 etc....
So my column fills with
123456
12321 the letters just get chopped off
So I added MaxScanRows = 0 to my schema file and that took care of the problem
Except now several of my columns that contain Date Values are coming back
9/24/2010 00:00:00
without the setting MaxScanRows = 0
The date returned 9/24/2010
Here is the code for my schema ini file I am creating:
HTML
Dim fs As New FileStream("Schema.ini", FileMode.Create, FileAccess.Write)
Dim writer As New StreamWriter(fs)
[CODE]............
I have been trying different settings hence the dimmed out lines
Here is the code to fill the datatable:
HTML
[CODE].............
I am thinking that without the MaxScanRows = 0 setting the datatype for Col1 is being incorrectly determined
I am not sure what is happening with other columns that contain date values. Apparently If i use MaxScan Rows=0 all columns are being pulled over as string value which creates numerous problems. If I dont use maxscanrows then all columns appear to be correct except Col21 MLSNUM which is being pulled in as a decimal. Can I change that in the schema file?
I'm just new to the forums, so I hope you's don't mind me jumping in and asking a question Currently I am pulling out rows from my Datagridview and sending all rows to a .csv file. I now need to retrieve information from two different datatables and put them into the same .csv file I am using. Below is how I am currently retrieving the first part of my .csv file. The second part will below the rows supplied from the datagrid. Hope somebody could advise me on how i could go about or, or have support links.
[Code]...
My code is crap, so I don't really think it will be useful because I've been going about it differently than I really want to:[code].....
I really don't wanna be loading a file in, I just wanna use XMLDocument() to create a file from my DataTable.But, my file ain't coming out right and I'm sorta just lost as to how this is all supposed to fit together.
Is there a way to nest a datatable into another datatable? I know you can do this with gridviews but thats not what I'm looking for.
Also, I don't want to merge the datatables. What I'm trying to do is have a datatable with 2 columns and each column containing different datatables.
i have a datatable with some data, i need to select some of the data, and put that data in a new datatable.
View 1 RepliesI'm going through All-In-One Code Framework Coding Standards document and one of the recommendations is to add a file header comment at the start of every human-created code file. This is the first time I've seen such a recommendation and to me it's just an unnecessary and ugly clutter but I'm wondering if someone could explain why M$ recommends this?
[Code]...
I have a dbf file. I saved it as a csv file and can open it in excel.
But i cannot open it in VB.net using programming and OLEDB connection.
If i copy all these content, paste it in a new excel sheet and then save it as csv file. My VB.net program reads it absolutely fine.
Any idea what might be wrong in saving the file directly from dbf to csv using excel?
I have to generate an XML file from several database tables. I could use the WriteXml method of the DataSet to do it, but the database tables are really huge and I can't add all those tables in the DataSet at the same time or it may cause a problem because of the big amount of memory used. Then I decided to use the DataTable's WriteXml method and save table after table, but the the generated file only stores the information of the last DataTable.WriteXml's call. How can I preserve the previous XML data when adding all that information?
View 4 RepliesI want to load a csv file (A comma delimited text file) into a datatable. I found the OdbcDataAdapter Class which looks perfect, but it says it is supported only in version 1.1 of the .NET Framework.
Is there a better way to import a csv file into a datatable? the first line has the column headers.
I am using Visual Studio 2008, using version 3.5 of the .NET framework