kangalert's Q&A profile

• SQL Server Extracting MS Excel Data in MSSQL Server 2005 Express

  Is there a way of extracting data from MS Excel using MS SQL Server 2005 Express hi, you can set up a linked server ( http://msdn2.microsoft.com/en-us/library/ms190479.aspx ) to the xls file and get relevant data into your SQLExpress table... consider having a d:\Students.xls file with 2 columns, FirstName and LastName ... SET NOCOUNT ON; CREATE TABLE dbo.Students ( FirstName VARCHAR(10) , LastName VARCHAR(10) ); GO EXEC sp_addlinkedserver 'ExcelSource', 'Jet 4.0', 'Microsoft.Jet.OLEDB.4.0', 'd:\Students.xls', NULL, 'Excel 5.0'; GO EXEC sp_addlinkedsrvlogin 'ExcelSource', 'false', 'sa', 'Admin', NULL ; GO SELECT * FROM ExcelSource...[Sheet1$]; -- import into ...Show All

• SQL Server Object reference not set to instance of the object while trying to sync.

  Hi, I am trying to configure web syncronization using the wizard for a merge replication. However when I am trying to add users (in authentication mode), I get an exception "Object reference not set to instance of the object ". Please let me know if you have any inputs on this. It will be highly appreciated.. Can you tell what OS you are using and what SP Has it worked in the past On clicking which button do you see this error Some more details will help us to troubleshoot the problem. ...Show All

• Visual C# Variables and Methods

  I have passed two variables into a method, and it modifies them internally, and then assigns them. For example: public void MyMethod(String var1, String var2) { String methvar1 = "x"; String methvar2 = "y"; var1 = methvar1; var2 = methavr2; } When the method exits teh external variables (var1 and var2) are unchanged, even though in the method they have been reassigned. Normally I would just return the variable to avoid this problem, but how do I return two variables at once Arrays dont work as in my actual code they are each arrays. Any ideas Mike Parameters are passed by value, for strings that means that you get a copy of the reference. In your method you are changing the reference ...Show All

• Visual Studio Express Editions search in TextBox, mark (highlight, ..) all found

  I wanted to explore the \Projects\ directory more efficiently, so I wrote an app that searches the \Projects\ directory recursively for *.vb files that contain a user-entered search string. The result list of files I put into a ListBox. When the user selects a file in the ListBox, I put the file contents in a TextBox. Now I want to highlight all occurences of the search string in that TextBox. I should use the InStr() function with a smart repeat loop. I want the code for that loop, and the code for highlighting all occurences of the search string. Anyone I would use a richtext box for this. There is an example on the vb-tips website. ...Show All

• .NET Development how to retrieve from existing file

  hi, I'd like to get data from existing file. I downloaded yahoo! logo to my computer. Then I go back to Visual Studio, go add item, existing item, then yahoo.jpg. Then go to Form2.cs I'm trying to something like shown below; m_BrowserLogoPictureBox.Image = Image.FromFile("yahoo.jpg"); But if I run it, it says "FileNotFoundException". When I test the other project, I successfully compile. I though I did the same thing but it doesn't compile. If anyone can help, I appreciate it. Thanks. KentaroM wrote: Thank you for the tip. I could surely get logo data if I did what you told. It's a bit difficult for me to understand the code from "Image.FromStream(System.R ...Show All

• Visual Studio 2008 (Pre-release) Open a xaml window from a C# form

  This is probably a newbie question, but why cant i start a new c# windowform project and add a new xaml window to the project, and then add a button in the c# form to show the xaml window i got all the referances added, but it gives this error: "Error 1 The name 'InitializeComponent' does not exist in the current context" so i comment it out. then it shows a empty window, but none of the xaml elements are loaded. I also tried to give the xaml elements name, but i cant reference to it in the Window1.xaml.cs file... Thx for response Found the answer to all my problems here: http://www.windowsforms.net/Samples/Go%20To%20Market/InterOP/Crossbow%20FAQ.doc " In addition, you will n ...Show All

• SQL Server Accessing previous row in Asynch Script Component

  I have a series of records that are timestamped and ordered by time ascending. i.e. Time TimeToNext 02/07/2007 11:38:22 0:00:21 <--- Need to calculate these 02/07/2007 11:38:43 0:00:22 <--- Need to calculate these 02/07/2007 11:39:06 0:00:00 <--- Need to calculate these 02/07/2007 11:39:06 0:00:36 <--- Need to calculate these 02/07/2007 11:39:42 0:00:28 <--- Need to calculate these 02/07/2007 11:40:10 0:00:26 <--- Need to calculate these 02/07/2007 11:40:36 Last Record <--- Need to calculate these I need to calculate the difference in time between each of these records.  The flow ...Show All

• Software Development for Windows Vista Expanded Memory in Vista for DOS Applications

  A DOS application which requires expanded memory (EMS) is required to be run on Vista. In earlier releases the expanded memory could be set to auto using the command.com->properties->memory tab. Vista does not allow to change this settings due to security reasons. Is there a way of increasing the expanded memory to allow a huge DOS application to run in the Vista environment Hello Namrata_Gupta, You can change these settings by running explorer as Administrator or you can also change it from Safe Mode. To run explorer as Administrator, open up a new elevated command window by right clicking cmd.exe -> Run as administrator, then open Task Manager and End Process on explorer, then from the elev ...Show All

• Visual Studio Team System How to creat an Unassigned user for the AssignedTo feild?

  How can I customize the template so I can have an Unassigned option in the Assigned To dropdown The VALIDUSER key will restrict the values to users in that group, so you can try doing the below instead to use LISTITEM: <STATE value="Created"> <FIELDS> <FIELD refname="System.AssignedTo"> <DEFAULT from="currentuser" /> <ALLOWEDVALUES expanditems="true" filteritems="excludegroups"> < LISTITEM value="[Project]\Business Analysts" /> <LISTITEM value="Unassigned" /> </ALLOWEDVALUES> </FIELD> </FIELDS> </STATE ...Show All

• .NET Development custom plugin questions!

  Hi there. I have no idea but had a sudden urge to ask about things like this, I guess its good for the knowledge! I have an app created in .NET 1.1 I *may* wish to implement plugin's with the application, so developers can create their own plugin's for the application. Question 1) If a plugin was created in .NET 2.0, will it still work with the .NET 1.1 application (obviously assuming they have both frameworks installed) Question 2) How would one go about creating plugin's for their application Question 3) Is it possible for this plugin to implement/"subscribe" to public events exposed by my application, so when I raise an event, any of the plugin's who have a subscription to the event, is notified Th ...Show All

• SQL Server 100 Embedded Images, how to reuse them

  Hello, I've created 101 images to represent a gaugebar. There where other ways to achive this with a full image and padding but this didn't render fine in every format. I find no way to load all these images in one go, so i'm importing them one by one .... (any suggestion). Now i would like to have a way to included this in all my reports (i know, i can copy paste the xml), is there a way to achieve this by a kind of #include Kind Regards. ...Show All

• Visual C++ How do you create a pointer to class funcitons (not members)?

  Hey, I was jsut wondering, how do you create a pointer to a function that is a member of a class Note that I don't want to make a pointer to member, I just want to be able to do something like this: class ClassA { public: void SayHello() { MessageBox(0, "Hello", "", 0); } }; int main() { ClassA a; void (*ptr)() = a.SayHello; // this would be how i would suspect it to be done ptr(); } How do I acomplish this Yeah, this is cool. But it is still not what I am looking for. Ok, here's a good example. Say I have a class called CWnd, and this managed a window. It also manages creation, registration of the window, and the wnd proc. I can't, however, do this: Class CWnd { public: voi ...Show All

• Software Development for Windows Vista Inconsistent File System Enumeration with FindFirstFile / FineNextFile

  I'm working to get a commercial application to run on Vista. Among the many broken things, the first one I encounter is a crash due to a stack overflow due to a recursive function that goes bad. The app enumerates files in various places using FindFirstFile | FineNextFile in a recursive function (C++). I'm using retail Vista Ultimate with VS 2005 sp1 plus the VS Vista update beta. What I see in the debugger is that when I start out enumerating drive "c:", I come to the "Documents and Settings" folder and recurse into it. When I get to "c:\Documents and Settings\All Users\Application Data", FindNextFile then returns "Application Data" over and over again and I recurse into "Application Data&qu ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Polys far away appear in front of close polygons.

  I just have a simple question. I have made a little program in Visual Basic that loads a 64x64 landscape from a heightmap. This is my first application in Direct3d, so this is my first problem: Some polygons seem to appear behind others, while they are closer, and vice versa. What could be the problem Thanks in advance, Michel EDIT Could this be because I have put all of the vertexes in one and the same custom vertex   You need to define a Stencil Depth buffer in the present parameters This stencil will fill itself with depth value and prevent the render to render pixel to be drawn if they are behing this buffer pixel You also need to set this buffer ''on'' by setti ...Show All

• Windows Live Developer Forums Window and button styles in WLM

  Does someone know of some documentation which covers the drawing of window styles and buttons etc for WLM Either something that shows how to directly use the exact same method (could it be a manifest file ), or something that explains the gradient fills etc would be incredibly helpful. Thanks in advance It is a very advanced method, and I don't think you will get information about this. I'm pretty sure that Microsoft will not give any info, and the very few coders that know how it works neither... Why would you like to know it maybe you can solve that in a different way ...Show All