.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Stuck in xml

Posted By:      Posted Date: September 08, 2010    Points: 0   Category :Sql Server
Hi everybody,   dealing with xml for the first time, I'somewhat stuck here. I have little xml-snippets stored in a xml-column. These snippets look like this (storing xaml-styleinfos):   <Style xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation" TargetType="TextBlock">   <Style.Resources>     <ResourceDictionary />   </Style.Resources>   <Setter Property="TextElement.Background">     <Setter.Value>       <SolidColorBrush>#FF00FFFF</SolidColorBrush>     </Setter.Value>   </Setter> </Style>   I need to query the xml-column to get detailes data from the xml (in this case I need the <Setter Property> and the <SolidColorBrush>) So far I tried this:   DECLARE @docHandle int DECLARE @xmlDocument xml SET @xmlDocument = (SELECT XMLColumn from someTable WHERE id = 1) EXEC sp_xml_preparedocument @docHandle OUTPUT, @xmlDocument SELECT  * FROM  OPENXML (@docHandle, '*')             WITH (xmlns  varchar(100),                   TargetType varchar(100),          &n

View Complete Post

More Related Resource Links

MVC2 issue - Stuck. Trying to create a cms with nested partials


I am currently trying to display multiple items on a single page. I am not sure as to how to tackle this. What I have is a database table that has all the page data in. I have this run as a PagesController and this works fine. However what I would like to do is, if say the Products page is selected via the menu, I want to pull back not only the Products page html but also get all the products, and even be able to pull them through via category. I was trying to use a partial view, but I can't get it to work. The same would be for other pages, having partial views to display the other content, ie if Gallery is selected, the page html for Gallery shows and it then can push to a partial view that pulls all the gallery images from the gallery db table and so on. 

Maybe I am tackling this the wrong way. I have the pages stored in the db to allow for a CMS system I have setup. Maybe I need to use models for all the other items(Products, Gallery, Videos and such) and use the partial for the page html?

Any help would be greatly appreciated as I am confused.

infopath form stuck with installing or deleting



I am deploying an infopath form in central admin and it stuck with the message "installing" and if i try to remove it stuck with message 'deleting". I restarted timer as well admin jobs in all servers (front end and app) but it is still showing the same. I also renamed my form and tried..no result. Can any one suggest me how to resolve this? I am wondering how it s happening just from one week.there are no changes in servers as well in environment. It works well before.



crawl stuck on "stopping"


Hi all

I have a problem wiht Moss 2007 search crawl. It was working fine, and suddenly it didn't show new content. I tried to trouble shoot, and saw that it had been running a crawl for more than 2000 hours. I stopped the crawl, and now it's stuck on "stopping".

I have googled and seen that a lot of people had that problem, and this might be because of maintenance job on the sql server (2005) with duplicated index values in the search database, or not having sp2 for sql. I checked, and we didn't have that problem.

Anybody here that has been on this problem, and fixed it? :)


Status "Installing" keeps stuck

Hi All..

I have a problem about status that is stucked.. I've read many forums that related to my problem, but still can't solved it yet :(

Here is my problem...

After 3 months I keep on uploading, removing, and uploading form, I have no problem.. Until today, when I want to upload my form, the status keeps on "Installing", instead of "Ready".
Then I removed my form using Timer Job Definitions, and I delete form.wsp. It works.
Afterwards, I try to upload form again, I have the same problem with stuck status. And then I delete again using same way.
I've tried more than 10 times, and the result still the same one.

Things that I've tried are:
- Reset IIS.
- Reset Application Pool.
- Check the services (e.g: Windows Sharepoint Services Administration, Search, Timer, Tracing) -- all are already started.
- Use "stsadm -o execadmsvcjobs"
- Reset Infopath Form ID
- Publish and change Infopath Form Name
- Command "net start SPTimerV3" and "net start SPAdmin"

Tried all things above, but still can't work. Status is still stuck.

Then, I try to upload other forms, but still have the same problem.

Please help me. I'm stuck already... :((

Is there anything I can do again?


C# newbie stuck - trying to access column data in a SharePoint list in an SSIS script task

Hello, I'm sure this is the simplest question but I can't figure it out, even with Google's help. I am trying to stumble through some C# code in an SSIS script task and I am frustrated that I can't figure out how to do the easiest things.  I eventually want to find data in a column,and then use another list as a lookup to replace that value with another where the existing value matches a value in the lookup list.  So, the data in my (multiple choice) column might be "apples; bananas" and in another list I have a row that contains two columns, the first holding the value "Apples" and the second containing "Red Delicious" and my original column should read: "Red Delicious; bananas." But, alas, I can't even figure out how to see the data that is in a column. Here is my code: /*<br/> Microsoft SQL Server Integration Services Script Task<br/> Write scripts using Microsoft Visual C# 2008.<br/> The ScriptMain is the entry point class of the script.<br/> */<br/> <br/> using System;<br/> using System.Data;<br/> using Microsoft.SharePoint;<br/> using Microsoft.SqlServer.Dts.Runtime;<br/> using System.Windows.Forms;<br/> using Microsoft.SharePoint.Utilities;<br/> <br/> namespace ST_08becda4c05c49cd9f30ea76110076cd.csproj<br/> {<br/> [

WorkFlow will not start. Stuck on workflowRuntime.CreateWorkflow?

In Visual Studio 2008/C# using the wizard I created a 'Sequential WorkFlow Console Application'.  I have made no changes to the project genreated by Visual Studio 2008.  The code gets stuck on:   WorkflowInstance instance = workflowRuntime.CreateWorkflow(typeof(WorkflowConsoleApplication1.Workflow1));Application never timeouts or fails.Any ideas?twahl

Workflow stuck on starting When using Win 7 / Office 2007

I've recently created custom workflows for a document approval process. At first I set the workflows to be started manually, for testing purposes and everything worked well. However when I changed the workflows to start automatically I started get problems. The workflow progress would stick on "Starting". Im running Win 7 And Office 2007, so i decided to do some troubling shooting on a different machine (XP and 2003) This time the workflow work perfectly...!   It is really strange as to why the workflows work fine on XP and 2003 and not with Win 7 and 2007. Can anybody shed any light on this or had the same problem? Thanks Chris

Stuck during restore process, no error messages

I need to restore a solution (a webpart) from a Sharepoint 2010 backup to another Sharepoint 2010 installation on another server. In CA and exactly in the page _admin/BackupStatus.aspx I see that: A backup or restore is currently in progress. There are no current or recent backup or restore processes to show. If you recently started a backup or restore process, you may need to refresh this page after several minutes for it to appear. Hours have passed since I started the restore process In _admin/ServiceRunningJobs.aspx there is no backup/restore job running. The question is: What can I do to try again a restore if I cannot stop the restore that is "running"? Please Help.  

stuck in "Analysis Services Tutorial" Lession1 "????????" step 3.

Hi, I am stucking in the lession1 The error message ??: Microsoft OLE DB Provider for SQL Server ------------------------------ [DBNETLIB][ConnectionOpen (Connect()).]SQL Server ????????? ------------------------------ ??: ??(&R) ?? ------------------------------ Could someone help me to teach me how to solve this problem. Then I can keeping my learnibng. Thank you very much.

User Profile Syncronization - Stuck in Progress

Hi all, I have been working to get some of the MySite properties exported to Active Directory (such as thumbnailphoto). Today, I created a new domain service account (sa-sharepointadds) and granted it the nesecarry permissions on the domain. In SP, I configured the User Profile Sync to connect to the domain and do a full sync (import only at this time) which completed correctly. I then enabled exporting a couple of profile properties and started another sync. I saw in the Application Event Log that an error occured, so I used the FIM Sync Service Manager application to view the steps and the errors. I saw that the sync was running with my sa-sharepoint service account which is the Farm account and not the sync account sa-sharepointadds, and that a permission error occured because this account has no rights to modify Active Directory. I went into the User Profile Sync Connection and verified the correct account was in use and it was. I then went to Security > Configure Service Accounts and saw that I needed to change the service account for the User Sync service. I changed it to the sa-sharepointadds account. I went back to User Profile Sync, however my connection had disappeared. I tried to create a new connection and got the error that a sync is already in progress and that I cannot make changes until it finishes. I knew that nothing was currently running, so I did an iis

InfoPath template status stuck installing...

running in to this on MOSS 2007 , only 1 wfe in the farm. tried renaming template, resetting form id stsadm -o execadmsvcjobs Job status is 100% completed, no jobs are failing. stopped timer service, restarted no diff rebooted server, no diff I'm running out of ideas. any suggestions?    

Stuck in Page Approval Workflow "Do-Loop"

My colleagues and I are building an intranet site. I have created a page, and am attempting to submit it, so my colleague can add content. So far I have gone through this process 18 times (to no avail): 1) Checked Page In 2) Submitted Page on the Publish Tab 3) Opened Status window on Publish Tab. Selected the open Approval Workflow. Selected Edit. Selected Approve. Hit OK. I receive confirmation emails -- yes, the page has been submitted. yes, the page has been approved. Checking back at the Status page, the workflow shows that it is complete/approved HOWEVER -- my colleague cannot access the page. It shows on her screen that the page is checked out and I am editing it. When I click on the page link, it opens immediately in the EDIT PAGE view (with Editing Tools already launched)...it will not allow me to get out of this mode. Also, if this is germane, the auto-generated URL ends in "ControlMode=Edit&DisplayMode=Design"...

jqModalPopup Stuck Behind Overlay

Hi,I am attempting to use jqModalPopup in an application.  However, when the PopupDisplays, it is always behind the overlay (it is under the gray.  I have tried adjusting the z-index.  Nothing seems to fix this.  Here is my code and html.  Any suggestions would be appreciated:function initAssignmentEditor() {    $j('#EditOneModal').jqm();    $j('#EditOneModal').jqmAddClose('#btnCloseEditOneModal');    $j('#SharedContentModal').jqm();    $j('#SharedContentModal').jqmAddClose('#btnCloseSharedContentModal');         setEditButton();}function setEditButton() {    $j('p.assignment-controls').children(':submit:eq(0)')        .click(function(event) {            var selectedAssignments = getSelectedAssignments();            if (selectedAssignments.length > 1) {                if(duplicateContentSelected(selectedAssignments)){                    $j('#SharedContentModal').jqmSh

ListBox.SelectedItem stuck at whatever is first selected and other strange ListBox behavior

Hi, I've built a List<Participant> (Participant being my custom type) and assigned this to ListBox.ItemsSource. (I'm aware this is more the Windows Forms way than the WPF way of databinding, but I'd still like to understand what's going on here - even though suggestions on how to perform my task in a more WPF-y way are also welcome.) I've set ListBox.SelectionMode to Single, and attached an event handler to the SelectionChanged event. In this handler, I dump the SelectedIndex and SelectedItem to debug output. Contrary to my expectation, 1) SelectedIndex is always -1. This isn't really causing me any trouble, but it's certainly not what I'd expect. 2) SelectedItem refers to the correct object the first time (in the windows lifetime) I select an item, but then keeps referring to this first-selected item regardless of whether I deselect (by clicking the item again while holding down the CTRL key) or select some other item. 3) If I keep clicking around and scrolling a bit (the list has ~320 items) within the list, now and then the list suddenly displays a bunch of items - sometimes many in a row, sometimes non-contiguous items, but it seems always "nearby" items! - as if they were selected. The list keeps firing the SelectionChanged event, but SelectedIndex is forever -1 and SelectedItem (and SelectedValue) always refers to whatever I had selected the fir


Hi there my name is Gus and im very glad to have found this forum, im hoping i can find all the help i need here.I am pretty good with HTML, PHP & MYSQL but this is my first go at working with a windows host and an ASP script. I recently purchased a script that matches my clients needs and when i have opened the folder to view the files its all double dutch to me apart from one css files which makes perfect sense to me!Im stuck with is the database file included in the template, i ave been unable to import it into MSSQL using 'My Little Admin' which is the control panel provided by my hosting provider. Looking through the file  with notepad it seems to contain the information for several tables but i cannot figure out for the life of me how i import it with 'My Little Admin'I will probably have a few more questions but i'll chuck this one out to start with :)

Configuration Wizard - Stuck on Microsoft SQL Server 2008

I have tried this three times and don't know what to try to be different. Configuration Wizard - Microsoft SQL server 2008  R2 Fails on Microsoft SQL server 2008  R2 Microsoft SQL server 2008  R2 is required in this training Kit Down load I have go though the download process at least 3 times and the configuration wizard still gets stuck on this step.   Any suggestions are appreciated.   I have a Window 7 PC.  

Setup Progress bar get stuck when launch the executables.

Hi I am using Visual studio 2008 to make setup without using Installer class. I have created Primary Output for custom action and called at Commit and set the Installer Class propety to False. Setup launch the application but at the back end setup progress bar get stuck. Is there any work around so that it shoud close. Thanks Himanshu  
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend