I have some data that is contained in HTML tables within a webpage. I need the simplest means of extracting the data for storeage in SQL tables. I am knowledgeable of how to add the data to SQL tables...this portion of the code is already written. I would like to pull the data into the VB.NET 2008 environment using the XML DOM or a more efficient option.
View 1 RepliesI created a report using report document object model in visual studio 2008 with vb.net. But I found one error. When the user clicks export button in client side, the following error will show. But the first time is OK before the user clicks export button.
Logon failed. Details: ADO Error Code: 0x Source: Microsoft OLE DB Provider for SQL Server Description: Login failed for user 'zanhtet'. SQL State: 42000 Native Error:
This is calling report code.
Dim ReportDocument As New ReportDocument()
Dim ReportPath As String = Server.MapPath("~/ReportDocumentOM/DBlogInRDOM.rpt")
[code]....
If I am using with WebBrowser how I can add tags to source code of the page in runtime (Make a changes on site).
For example: I have site with this
<html><head>
Test page
</head><body>
this is the text
</body></html>
Now how possible to add elements/tags to text in runtime?
I have published xml document through web service like this
<WebMethod()> _
Public Function HelloWorld() As XmlDocument
Dim xmlDoc As New XmlDocument
[code]....
I have an XmlDocument object in memory which I need to update a database table with. My SQL Express 2005 DB table is three columns: Name, Telephone, Location. Below is the structure of the XMLDocument. What is the recommended technique to accomplish this?
HTML
<MyDirectory>
<Prompt>Records 1 to 561 of 561</Prompt>
<DirectoryEntry>
<Name>John Doe</Name>
<Telephone>22334222</Telephone>
[Code] .....
am currently trying to do this in MVC3, VB.NET.
Consider the following model:
Public Class SampleData
Public Property PTY_1 as String
[code].....
I'm looking for an efficient means of extracting an html "fragment" from an html document. My first implementation of this used the Html Agility Pack. This appeared to be a reasonable way to attack this problem, until I started running the extraction on large html documents - performance was very poor for something so trivial (I'm guessing due to the amount of time it was taking to parse the entire document).[code]...
View 3 RepliesSo I create the model container:
Private mdbContext As PFModelContainer
Private mdbTransactions As Object
Before I did it this way:
Private mdbContext As New PFModelContainer
Private mdbTransactions As mdbContext.Transactions
Thinking maybe I was doing something wrong I changed it over to the first way, then I do:
Public Sub New()
mdbContext = New PFModelContainer
mdbTransactions = mdbContext.Transactions
End Sub
Once I hit mdbContext = New PFModelContainer it takes me over to the PFModel.Designer.vb Where it steps through the following:
Public Sub New()
MyBase.New("name=PFModelContainer", "PFModelContainer")
At which point it terminates execution of the code. This is the error it gives me on the Immediate window:
A first chance exception of type 'System.ArgumentException' occurred
in System.Data.Entity.dll
Is there something I can do to make this error go away? I tried deleting the project and recreating it with my old .edmx model that I downloaded from Mozy from when it used to work. It stopped working (as far as I can tell) after I changed the .edmx model and updated it. Maybe I did something else in the other project too, but I'm not recalling anything.This is what is in the app.config:
<connectionStrings>
<add name="PFModelContainer" connectionString="metadata=res://*/PFModel.csdl|res://*/PFModel.ssdl|res://*/PFModel.msl;provider=System.Data.SqlServerCe.3.5;provider connection string="Data Source=|DataDirectory|inDebugMyDatabase#1.sdf"" providerName="System.Data.EntityClient" />
</connectionStrings>
Should I be referencing System.Data.EntityClient and System.Data.SqlServerCe.3.5 somewhere?The EDMX property Entity Container Name is PFModelContainer and the Namespace is PFModel.
I'm developing a business model for an application where I am representing physical entities. The hierarchy created from this is neat, but as I'm doing this, I'm beginning to think about things like, what properties should be included in one that may already be apart of another? Or what if some properties are expected to be in one object, but another object needs to return that value, how does it communicate that request through the hierarchical chain? And what is the best practice for this design?
[Code]...
But then I got to thinking, what if I have a ConnectionPoint entity and I want it to return which Panel it has? Should it have it's own Panel association as well? Or should there be a method/pattern for communicating the request up the chain? And again... what's typical best practice?
I am not sure where to post this as I didn't see a forum for SharePoint on here. I hope someone can help me with this.I have a form sitting on a webapp outside of the sharepoint server (which is why I am using the Client Object Model). To make a long story short the form is sending data to a SP list. This list is made up of regular string fields, date fields, lookup lists, choice lists and user data.
I am able to insert data that isn't part of a list with no issues. However, when I update any of the lookup lists i receive the following error:Invalid look-up value. A look-up field contains invalid data. Please check the value and try again. So I then wrote code that went to the list and got the entire item as follows (please bare in mind this is not very eloquent, but it gets the data)
[Code]...
I am working on a silverlight project in which i am using the entity data model. I have a consol application in the same solution through which i am creating the database table at runtime. Now when i moves to silverlight page i need to Communicate (load
data from newly created tables).But problem is that without updating the model how i will able to communicate with that table at runtime using entity framework model.
I have a .net asp app that updates a SP form. I am using the Client object model. Currently when inserting a record the record is inserted using the App pool ID. Is it possible to somehow set the context to use the ID of the person logged into the webapp or a custom ID separate from the default. I can't find any data in this in the web or gong through the context methods.
View 3 RepliesIn entity framework we can use 3 approaches model first , code first , database first but each one of them needs manual hand touch(means creating database or create model or write the POCO class codes or entity class codes) before proceeding to the next step ( using EF in context ).What if I want to create database and tables and table relationships programatically and still want to have to features of EntityFramework 4.3.
To be more specific ,from this example http://support.microsoft.com/kb/307283 we can create database , tables and everything using SQL command but we can't have the advantages of entity framework. So if we want to have that what should we do? To give the ability to create dynamic table fields those steps will not be sufficient. In all 3 steps database , table and table columns are fixed. There is no way that a user can create new tables or columns dynamically. http:[url].... in this post , it shows how to create manual db, tables and etc using SQL but it is based on ADO.NET but I want Entity Manager to do that.
I have an application that creates desktop shortcuts. To do this I have to reference the Windows Script Host Object Model. When I add it as a reference, it always creates the DLL, Interop.IWshRuntimeLibrary.dll, in the objx86Debug directory, then references itself to it, rather than looking at wshom.ocx. Even if I add reference wshom.ocx it reverts to saving the file in the objx86Debug directory. The problem is if I move my application to another computer without that DLL being present, the program fails to run.
View 1 RepliesI am currently developing a service using the SharePoint 2010 Client Object Model to programmatically upload Excel worksheets to a Drop Off Library and then set the properties on the file. This process is working well. However, the Drop Off Library is governed by Content Organizer Rules that aren't being applied to the uploaded file. I have examined every property I thought I could have missed: [code] What's most frustrating is that if I edit the document properties using the Web UI and check it back in without making any changes, the file is moved to its final location. What might I have overlooked that is preventing Content Organizer Rules from being applied to newly uploaded files when using SP2010 COM?
View 2 RepliesI'm trying to read a XML file, but only certain values.So my XML file is built from the result of a SQL query.[code]The probelm is the loop starts with line 1, good start.But then it will go to line one again, then line 2, line 2 again and so on.When it hits line 5, the first value I need to pull, it then stops.And thats how it is written, so that makes sence.I need to loop through this document, grab the certain values I need, and move on.
View 9 RepliesI have a program that is saving information into and XML file that is later read from to continue the users progress. I am having trouble getting the reader to work without an error This is the code that I am having trouble with and below is the error.
[Code]....
I want to be able to read my XML document but I am a little lost how to. I cant really post my XML on here because it is just trying to use markup. Anyways, I have a root node that surrounds the whole object i want to read. From there, there are a few elements. 2 of those elements can have multiple instances. There will only be one object i need to read from the XML document.
[Code]...
I am using a string builder to set up an html table row by row so that it can be emailed. I currently gather my information from the database using a data reader and while dataReader.read, I use stringbuilder.Append to add each cell value to the table.The issue is that after about 200 rows, the html breaks and displays a cell value above the table in the email. I have tried changing the cell padding, but this was not successful.
View 2 RepliesI would like to print an HTML file that I am generating myself, but I want the pages to have the same table header at the start of each page. I think the best options to print an HTML file is the webbrowser control? but this won't give the table header at the start of each page (and I will have to contend with the ugly file://c:empfile.htm at the top of each page etc)
View 1 RepliesOkay, well I have tried many things, I can type in the textbox using:
for each element as htmlelement in webbrowser1.document.all
if element.GetAttribute("ID") = "IdOfTextBoxHere"
element.innertext = "HIIIIII"
end if
next
and I can click a google button like this:
[Code]...
I was wondering if there was any way I could open a html document from url into my application so I could parse it simular to an xml document.
View 8 RepliesI've been programming in VB.NET 2005, 2008 and now 2010 for almost 2 years. Just casual little applications, nothing big.In this project I need to parse links from a web page, it doesn't quite work though, it parses the names only and no links.I'll give you my code, let's say for a random page:
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
TextBox1.Multiline = True
WebBrowser1.Navigate("http:www.buyfixuse.com")
[code]....
If I activate this function in my application instead of links to the two blog posts on that website, it only gives out the text that is related to these links - (more...)
Is there anyway to replace the parts of an html file in vb .net?
i.e.
if the html is
<html>
hello
</html>[code]....
I need to write some code that opens a Word Document and then either extracts the data so that a HTML document can be created or simply resaves it as an HTML document. I've had a quick look around the net and tried adding an Object Reference to Microsoft Word Object X.0 Library to my Project. So that I could play around with things, but immediately It was telling me the following weren't defined.
Dim objWdApp As Word.Application
Dim objWdDoc As Word.Document
Dim objwdRange As Word.Range
Could anyone either explain what kind of thing I would need to do or link me to some useful tutorial.
How can I get html document from a stream?
View 3 RepliesI have an xml file document and I am trying to display the xml contents in a datagridview.what am I doing wrong? I had it working when I pull one column at a time
[Code]...
I have some code that locates all the contact folders that a user has access to by iterating through the Application.Session.Stores collection.This works for the user's contacts and also all the public contacts folders. It also finds all the contacts folders in additional mailbox accounts that the user has added via the Tools -> Account Settings... menu command.
However, this requires the user to have full access to the other person's account. When a user only has access to another person's contacts, then that person's contacts show up under the "People's Contacts" group in the Contacts view. How do I find those contact folders that don't show up under Session.Stores?
In order to see the other user's contacts folder without adding access to their full mailbox, click File -> Open -> Other User's Folder... from the Outlook menu. In the dialog box, enter the other user's name and select Contacts from the Folder type drop down list.
Here's the code (minus the error checking and logging) I'm using to find a list of all the user's Outlook contact folders. I know this can (and maybe should) be done using early binding to the Outlook.Application type, but that doesn't affect the results. EnumerateFolders is recursive so that it searches all sub folders.
Dim folderList = New Dictionary(Of String, String)
Dim outlookApp = CreateObject(Class:="Outlook.Application")
For Each store As Object In outlookApp.Session.Stores
EnumerateFolders(folderList, store.GetRootFolder)
Next
[Code]...
I am trying to run an HTML file that I have imported into the Solution Explorer. I don't know how to refer to documents in the Solution Explorer in code. How can I do that?
I am currently using this code, but it doesn't work: process.start(".help.html")
Basically I was wondering if anybody knows how to make Visual Basic change automatically what is in
<span id="total_quantity">1</span>
change what is between > and < (for example a digit or text).