Samy Khalil Abushanab's Q&A profile
.NET Development xsl: sort
I'm trying to get my xsl transform to sort descending: < xml version="1.0" encoding="ISO-8859-1" > <xsl:stylesheet version="1.0" xmlns:xsl=" http://www.w3.org/1999/XSL/Transform "> <xsl:template match="/"> <ul> <xsl:for-each select="sitemap/menu[@location='main']/page"> <xsl:sort select="page" order="descending" /> <li> <a href=" {@url }"> <xsl:value-of select="@title"/> </a> </li> </xsl:for-each> </ul> </xsl:template> </xsl:stylesheet> This is my xml file: < xml version="1.0" encoding="ISO-8859-1" > <sit ...Show All
Visual Basic How can i print excel document from ASP.Net web apge?
I try to use printout function to print excel file from my web page. It does not work. It only works in windows application. here is my code Dim Xl As Excel.Application = New Excel.Application Xl.Workbooks.Open("C:\XXX.xls") Try Xl.Workbooks("XXX.xls").PrintOut() Catch ex As Exception End Try Xl.Workbooks("Chaohong Wu.xls").Close( False ) Xl.Quit() I need help. How can I print existing excel file from user's brower The above code only can work in windows application. Thanks I think you question is better directed at the forums on asp.net site as its a ASP.NET issue. The problem comes that you VB.NET code is running on the ...Show All
Visual Studio Tools for Office Generate Excel file using ASP.NET
I am currently working on a page that will generate dynamic reports for my company. These generated reports are building an excel file using C# and the Microsoft.Office.Interop.Excel dll. While most of this works the way I would like it to I have run into one problem. When I use Pictures.Insert() I recieve an error stating that I am not including an assembly reference. When I tracked this down, it appeared to be because I needed the office.dll in my bin folder, which fixed the compiling issue but now I get an error that says there is a vesion problem. Does anybody know why this is My server has Excel 2000 on it, if you need other information let me know. Any suggestions would be greatly appreciated, and thanks in advance. ...Show All
Microsoft ISV Community Center Forums Can't open regedit
Hai.... Why if I want open regedit (run>regedit), and then show message error like that The application failed to initialize properly (0xc0000005) Please anybody help me... Jebat Thanks I canot open regedit,cmd. But when i typed in the run regedit.exe not just "regedit" it works and cmd too. ...Show All
SQL Server SSIS Error 12291
I have an SSIS package that runs just fine. However, when I schedule it as a job, it fails with this in the Event Viewer: Source: SQLISPackage Event ID: 12291 Description: Package "<package name>" failed. I have many other SSIS packages scheduled on the same server using the same security. What can be wrong, or where can I look to find out what the problem is Neal Got it! UNC versus mapped drives! The manual process uses my credentials, which has a mapped drive reference. The job uses the SQL Server Agent account, which does not. I just found out that the programmer is using the mapped drive. Solved! ...Show All
Gadgets Debugging gadgets
Okay, I've seen a lot of little 'snippets' of try this or try that, but how do you debug a gadget I've been doing fine until I tried to do some script. My script is okay, I've tested the same script in an asp page. But I don't even know if it's getting called. <body onload="init()"> <div id="city"></div> <div id="current"></div> <div id="low"></div> </body> and in my script I assign values to the innerText. Nothing. I've made a solution in VS 2005, and attached to the SideBar process, my code is in the ...microsoft sidebar/gadgets/mygadget.gadget folder. When I run, break points set in the js files don't get hit. I'm missing somethin ...Show All
Visual Studio Team System VSTT agent error
Hi All I have been facing problem running the Load tests for quite sometime now. We want to automate the process of running performance test, so we have created a batch file which runs various load tests using mstest utility. While running these load tests, sometimes the Test Runs abort abruptly with the errors: Test/Run was aborted on agent due to error: The Agent process timed out waiting for a start command from the controller. SynchronizedTestTimeoutInSeconds = 120. To rectify this error, I modified the Agent Config files and increased the Timeouts period. Test/Run was aborted due to error: Agent service cannot start the Agent Process or test run stopped on Agent. In Agent Eve ...Show All
Visual Basic Alternative to Data Reader (VB.NET 2003)
In my following code I want to use any Array variable that can store the result. I don't want to use the Data Reader as given below. Is there any alternative. ----------------------------------------------------CODE--------------------------------------------------------------- Private Sub cmdModify_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmdModify.Click Dim strFind, strModify As String Dim FindDr As OleDb.OleDbDataReader Dim cmdFind As New OleDb.OleDbCommand(strFind, cn2) myRecID = Val(InputBox("Enter Item ID:", "Modify Item Entries")) strFind = "Select * from Firms_Master Where FirmID=" & myRecID FindDr = cmdFind.ExecuteReader(CommandBehavior. ...Show All
SQL Server How the windows forms application get the notification when record inserted in Table
I have an application, which is developed in windows forms, where one of the form is admin form, it contains the data grid. It fills the record of user details from user table. When other user creates the new user account, the admin forms gets the notification automatically and refresh the data grid information. Can any one give the guide line or sample code It will be great help full. Thanks Hi - There are plenty of examples of using Query Notifications on the internet. Google for it and I'm sure you'll find something relatively close to what you're trying to accomplish. If you're still considering using SQLNS to address the issue, I don't know of an example to direct you to. S ...Show All
SQL Server How to change the SSMS default file location ?
After editing a SQL query, I'd like the Save As... dialog to default to a specific folder on my local hard drive. At the moment it is pointing me to MyDocuments\...\Projects. Where can I change the default folder I couldn't find anything under Tools, Options... Could you file this as a suggestion on Microsoft Connect http://connect.microsoft.com/SQLServer/ . I believe we store our settings in files here: Documents and Settings\%username%\Application Data\Microsoft\Microsoft SQL Server\90\Tools\Shell I could not figure out which file to edit. Before you mess with those files, you should probably take a backup. If you figure it out, let us know. Paul A. Mestemaker II Program Manager Micr ...Show All
SQL Server Load data from .DAT file
Hi All, I am using Bulk Insert task to laod data from .dat file to SQL table but getting an error below. [Bulk Insert Task] Error: An error occurred with the following error message: "Cannot fetch a row from OLE DB provider "BULK" for linked server "(null)".The OLE DB provider "BULK" for linked server "(null)" reported an error. The provider did not give any information about the error.The bulk load failed. The column is too long in the data file for row 1, column 1. Verify that the field terminator and row terminator are specified correctly.". Any help will be appreciated. Thanks. i have the same problem like you, but i don't have solve, w ...Show All
SQL Server Strange Behaviour excecuting procs from Visual Studio 2005
Hi there, I am having possibly the weirdest problem I've ever had with Sql Server. I have a database project in a Visual Studio 2005 solution (ASP.NET 2.0 Web App) and am loving the source control that gives me, but desperate to get to the bottom of this. I made some changes to a proc in VS, then execute the create script by right clicking and clicking execute. I then execute the proc from Management Studio and it returns no results . I cut and paste the query from the proc first and run it, it returns results . I run from VS - Execute - no results I copy the create script from VS and run it in Management studio - results I run from VS - Execute - no results I script the create proc from Management Studio an ...Show All
Visual Studio Express Editions Can not run the exe file in the other computer
After compile, I copied the .exe file from /bin/release directory to the other computer, and run the exe. And I got the error message " To run the application, you must install one of the following .net frame work v 2.0 50727....." I don't want to install it in that computer. Anyway to reslove that Thanks, Fish ...Show All
Visual Studio Tools for Office Installing word 2007 add-in
I write word 2007 add-in.Then I create installation package.Then I install this add-in on other PC. Then try to add add-in in word settings(select dll or manifest) them I have error = not valid word add-in! How I can install add-in in client PC Could you give some more details on what you have and what you try to do - What is the OS and Office version at the client machine - How did you build your addin, is it a VSTO addin - If so what is your OS/Office Version/Visual Studio Version/VSTO version used - Be more detailed on the error (exact error message, and when does it occur) Al of this information is important before someone can answer your issue. -= Maarten =- ...Show All
.NET Development Passing user32.dll GetDC() IntPtr value from C# into C++?
In C#, I'm getting the DC object via interop by calling GetDC() from the user32.dll. I want to pass this into another DLL that I'm writing in C++, but I'm not sure what the parameter type should be in C++. Am I passing a pointer to a CDC object Or do I need to do some type conversion C# code looks like: ------------------------------------------------ [DllImport("user32.dll", EntryPoint="GetDesktopWindow")] public static extern IntPtr GetDesktopWindow(); [DllImport("user32.dll",EntryPoint="GetDC")] public static extern IntPtr GetDC(IntPtr ptr); [DllImport("mine.dll", SetLastError= true )] static extern IntPtr getSymbol( IntPtr DC ); // Get the handle to the desk ...Show All