.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

Web Q&A: Passing XML to SQL Server, Document.write on Resize, Transformations on the Fly, and More

Posted By:      Posted Date: August 21, 2010    Points: 0   Category :ASP.Net

More Related Resource Links

How to write an event to manage permissions on a document while uploading, depending on custom field



I am trying to find a solution to manage permissions on a document, while uploading it into a document library. This event has to be fired if a custom field is populated (it's a check box field).

How to write an event for this, i tried writing ItemAdded event, but this is getting fired as soon as a document is uploaded, before coming to the page, where we populate all the fields and hit check in.

can i capture Check-in event.

Please advise.


passing object values from server to client problem


I get a message that x_login is not declared.  I added Dim login as String = "123", but that didn't help.  What's the problem?

code behind....

Dim Login = "123"
x_login.Value = loginID


<%@ Page Language="vb" AutoEventWireup="false" CodeBehind="Default.aspx.vb" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" >
<form id="simForm" runat="server" method='post' action='https://test.authorize.net/gateway/transact.dll'>
        <input id="HiddenValue" type="hidden" value="Initial Value" runat="server" />
        <input type='hidden' runat="server" name='x_login' id='x_login' />
        <input type='submit' runat="server" id='buttonLabel' />



TSQL: Passing array/list/set to stored procedure (MS SQL Server)

Passing array/list/set to stored procedure is fairly common task when you are working with Databases. You can meet this when you want to filter some collection. Other case - it can be an import into database from extern sources. I will consider few solutions: creation of sql-query at server code, put set of parameters to sql stored procedure's parameter with next variants: parameters separated by comma, bulk insert, and at last table-valued parameters (it is most interesting approach, which we can use from MS SQL Server 2008). Ok, let's suppose that we have list of items and we need to filter this items by categories ("TV", "TV game device", "DVD-player") and by firms ("Firm 1", "Firm2", "Firm 3). It will look at database like this So we need a query which will return us list of items from database. Also we need opportunity to filter these items by categories or by firms. We will filter them by identifiers. Ok, we know the mission. How we will solve it? Most easy way, used by junior developers - it is creating SQL-instruction with C# code, it can be like this List<int> categories = new List<int>() { 1, 2, 3 };   StringBuilder sbSql = new StringBuilder(); sbSql.Append( @" select i.Name as ItemName, f.Name as FirmName, c.Name as CategoryName from Item i inner join Firm f on i.FirmId =

SQL Server 2008 installation fails There was an error generating the XML document. Error code 0x84B

My system config: window XP - SP3 4 GB RAM, I have VS2008 with SP1, VS2010 Ultimate installed First when I tried to install SQL 2008 R2 Dev edition I got an error saying vs2008 SP1 was not installed, infact I had the SP1 installed in my m/c.  I did reinstalled the SP1 and tried to install SQL again. while in the final installation process I got the error  "Setup has encountered the following error: There was an error generating the XML document. Error code 0x84B10001." I uninstall the SQL server again to remove the files which were created from Unsuccessful installation I removed the register entry as suggested by this forum. reinstalled but no chance, I have tried all the option which I can get know in web. Please help me. here is the log files details  Exception type: Microsoft.SqlServer.Chainer.Infrastructure.ChainerInfrastructureException 2010-08-26 14:54:53 Slp:     Message: 2010-08-26 14:54:53 Slp:         There was an error generating the XML document. 2010-08-26 14:54:53 Slp:     Stack: 2010-08-26 14:54:53 Slp:         at Microsoft.SqlServer.Chainer.Infrastructure.DataStoreService.SerializeObject(String rootPath, Object objectToSerialize, Boolean saveToCache) 2010-08-26 14:54:53 Slp:   &nb

The URL 'ao/AO Document/Admin Guideline/xxxxx.jpg' error on 2nd SharePoint server in farm

We just added a 2nd SP2007 server to mirror our site.  The original site is in China, the new site in the US.  They are connected via a permanent  site to site VPN.  We are hitting the errors when attempting to upload files to the US mirror.    Environment: US server site: OS: Windows Server 2008 R2 Enterprise (64 bit) APP: Windows Sharepoint Server 2007 Enterprise SP2 (64 bit) DB: Windows SQL Server 2008 Enterprise R2 (64 bit) China site: OS: Windows Server 2003 Enterprise SP2 (32 bit) APP: Windows Sharepoint Server 2007 Enterprise SP2 (32 bit) DB: Windows SQL Server 2008 Enterprise R2 (32 bit) Background: We setup two test Sharepoint farm to be syncronized with only its content database. The upload works good on SZ site. But we got the following 2 error messages randomly when uploading file to document library of SF side. Error message: 1. The URL 'ao/AO Document/Admin Guideline/xxxxx.jpg' is invalid.  It may refer to a nonexistent file or folder, or refer to a valid file or folder that is not in the current Web. 2. Cannot open file "ao/AO Document/Admin Guideline/xxxxx.jpg". -- We've tried the official hotfix, altering the schema, changing the IIS memory limit settings, and restarting the application pool. Could the issue be related to the different OSes 2008 vs 2003, or 32 vs 64bit?  

Cannot add SQL Server 2008 R2 Report items to SharePoint Server 2010 document library

Using account which is the primary parent site administrator, can upload RDS and RDL files to the document library (however, cannot open report). User is also a domain admin with SA on the database instances. Cannot add Report Data Source with "New Document" icon. The permissions granted to user '[domain]\[user]' are insufficient for performing this operation. Under "Site Settings", "Managed Shared Schedules" fails with same error. Attempting to deploy from BIDS results in the same permissions error. Sharepoint Server 2010, Report Server 2008 R2. RS and SP databases hosted on remote server (SQL Server 2008 R2). All connections (SharePoint services, RS services, users) except SQLAgent authenticating to remote SQL Server with Kerberos (all SPNs look correct). Single site, site collection "/". Document directory called "Reports". Windows Integrated Security (Negotiate). How would I troubleshoot/solve problem?

Cube Writeback SQL Server 2008 R2 (SSAS, write back)

CUBE WRITE BACK in SQL SERVER 2008 R2 Did anybody get the SSAS write back functionality to work against a decent sized datawarehouse? I'm not asking about a little demo but a significant sized footprint e.g. 14M Rows measures, 6-8 wired Dimensions with 8-10 attributes each. I setup a test server using a Dell XEON ( 2x4core) with 48 GB RAM hardware and the latest Sql Server 2008 R2 release. I used the What-If scenario in Excel 2010 and modified a higher level, hoping SSAS would push the values down. After about 15 minutes and after having used 48 GB memory (on average 5% CPU) Excel throw an error - short on memory - and stopped the action. I found the same behavior in Sql server 2005 and 2008 and was hoping this would work now but apparently not so. Here are my questions: Is anybody using this at all? how can one calculated (roughtly) how much memory is requiered? is there any paper that describes best practise? Thanks for any help in advance, Dirk  

Can't save SQL Server Management Studio sql file back into Sharepoint Document Library

I created an sql query file in SQL Server Management Studio and saved it onto my hard drive.  I then moved that file into a Sharepoint Document Library so others on my team could use that query.I opened the file from within sharepoint, it launched SSMS.I made a change to the file and pressed save.here is the error message that comes up."The operation could not be completed.  The process cannot access the file because it is being used by another process"Am I doing something wrong?

Passing security credentials to the third server

I have the following scenario.  An user uses the desktop application to call our WCF Service which has windows authentication.  The WCF Service calls the Office Communication Server (OCS) in order to do some custom work.  When the WCF Service calls OCS we have to pass an instance of NetWorkCredential into the call.  I want to pass in the original calling users NetworkCredential object into the OCS call rather than constructing it using a custom username and password.  How do I get access to the calling users NetworkCredential object from the WCF service and pass it to the OCS call?ThanksArjuna.

Converting Word Documents library to PDF document library in SharePoint Server 2007

My project requires me to create an event reciever such that when a word file is added to one library the same content pdf file should be added to other library also when a word file is updated,edited or checked in the respective pdf file in other document library should be replaced by a new pdf file with the edited word content . Can we do this in Sharepoint 2007 I have seen this can be done in Sharepoint 2010 http://msdn.microsoft.com/en-us/library/ff181518.aspx

Office 2010 can not integrate with Sharepoint Server 2010 document library, both RTM

Hi I have one standalone SharePoint Server 2010 and Office 2010 on Windows Server 2008 SP2. Both SharePoint and Office are RTM. When I create new document from the document library, it can open the Office Word.  When I save the document, Office gives me the local browser dialog other than remote sharepoint library. When I try to enter the sharepoint site url in the dialog, it tells me: path does not exist. On another machine, Windows 7, the Office 2010 RTM can open and save docs from/into the document library. There seems something wrong with the Office client. Maybe someone can tell me how to fix it. Thanks. Xiaofeng?????,?????@??/??/????+????+????+all the context of the issue Hope Helpful | http://www.leoworks.net

not able to write log messages in event log on windows 2008 server

Hi, I am trying to write in Event Log on windows 2008 server with a windows service application. But I got this error: Service cannot be started. System.ComponentModel.Win32Exception: The parameter is incorrect at System.Diagnostics.EventLog.InternalWriteEvent(UInt32 eventID, UInt16 category, EventLogEntryType type, String[] strings, Byte[] rawData, String currentMachineName) at System.Diagnostics.EventLog.WriteEntry(String message, EventLogEntryType type, Int32 eventID, Int16 category, Byte[] rawData) at System.Diagnostics.EventLog.WriteEntry(String message, EventLogEntryType type) at Siemens.SHS.Utilities.Common.LogManager.LogToEvent(String pLogName, String pSource, String logEntry, EventLogEntryType type) at Siemens.SHS.PEP.TaskCore.StartTask(String pPluginFilePath) at Siemens.SHS.PEP.TaskCore.RecurseStart(String pPluginPath) at Siemens.SHS.PEP.TaskCore.RecurseStart(String pPluginPath) at Siemens.SHS.PEP.TaskCore.StartTasks() at Siemens.SHS.PEP.PlugnExecute.OnStart(String[] args) at System.ServiceProcess.ServiceBase.ServiceQueuedMainCallback(Object state)How can I write to Event Log on x64 platform as Windows 2008 server?Any help appreciated, thanks in advance,Cigdem

SharePoint Users Behind a Forefront TMG Server Cannot Access Explorer View in Document Libraries

SharePoint server via a Forefront TMG server in a separate sub-domain. These users cannot access Explorer View in Document Libraries nor can they map a drive to the SharePoint directory structure, as users who are in the same sub-domain as the SharePoint server can. How do I setup SharePoint and the TMG server so that these users can map a drive to the SharePoint site? Office SharePoint 2007 SP2 Windows 2008 Server SP2

Passing credentials from Sharepoint application to Reporting Server

Hi, Think of an environment where SSRS is deployed in share point integrated mode. There is a sharepoint application which is using user authentication (not windows authentication) for validating the login credentials of users using the application. There are some reports presented as web parts in the sharepoint application. Now, how should the user credentials be passed from Sharepoint application to Reporting services and how should they be validated? How the user credentials from sharepoint to be passed to report server and validate the permissions before showing up the report? Please let me know.  Phani Note: Please mark the post as answered if it answers your question.

Passing value from one web application to another hosted in different server

I want to redirect from one aspx page to another aspx page of different application. Both applications are hosted in different application servers. I want to pass a value from one application to another. I tried - 1. Response.redirect with Query string - But query string is not secure as it is visible to user in browser. 2. Cookies - This is also not a secure way. Again if the cookies are disable in the browser it may not work. 3. Server.transfer - In different web application we cant use server.transfer. Please provide any easy solution how to achieve this.  I dont want to display the values to the user as it is confidential data.

Word 2010 Crashes When Editing Server or Document Properties

I don’t know if I’m doing something wrong or if this is a bug. We are using Metadata in our SharePoint 2010 implementation and I have linked this to the various document templates. If the template is a docx or dotx extension then, in a document library, going New Document and editing the Server or Document Properties causes Word to crash. Document templates based on .doc extensions work fine. Once the document has been created you can edit the properties but obviously this isn’t the best process. Does anyone have any advice on this? Thanks Neil

write server side code in External JS files

Salam To All,for my JS code, some times i need to organize my code, so i prefer to put some of javascript functions in external js files and  include it in my page as well.but i am face a problem if i need to write some .Net code especially to Get the Client ID for any of .net controls.so do you have a way to write the following code in External JS file?('#<%= this.ddlMake.ClientID %>').change(function(
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