Answer Questions

• Jianxing Import data from Excel workbook to x64 Sql Server 2005 ???

  Hi all, I am trying to import data from excel workbook to Sql server x64 2005 version. But OLEDB provider does not support 64 bit applications. Is there any alternative ways to solve this issue Platfroms using : ASP.NET 2.0 Sql Server 2005 x64 Excel 2003 WorkBook Thanks in advance. Omer Unfortunately there is no data access support from the 64-bit side through Jet, ODBC or the ISAM drivers. Excel automation is probably the only practical solution. I think you can get to 32-bit SQL Server from the 64-bit side and if you used that approach you could probably create a linked server entry for the Excel Workbook/Worksheets in the 32-bit version. ...Show All

• geliser131 How to emit delegate call (System.Reflection.Emit)?

  I have to emit delegate call into dynamic method. What is the right way to do it del(...); should do it... More is found at MSDN2 . I hope this helps: MethodInfo method = // Get the method to invoke from somewhere. DynamicMethod setter = new DynamicMethod ( "MyMethod" , typeof ( void ), arguments, container); ILGenerator generator = setter.GetILGenerator(); // Emit the call to the mehtod. generator.EmitCall( OpCodes .Callvirt, method, null ); // Emit the return call. generator.Emit( OpCodes .Ret); // Create a delegate. GenericDelegate del = (GenericDelegate)setter.CreateDelegate( typeof (GenericDelegate)); This will create delegat ...Show All

• Smitha Ajay xsl tranformation file problem

  i have an xsl file like this; < xml version = " 1.0 " > < xsl:stylesheet version = " 1.0 " xmlns:xsl = " http://www.w3.org/1999/XSL/Transform " xmlns:xsi = " http://www.w3.org/2001/XMLSchema-instance " xmlns:xsd = " http://www.w3.org/2001/XMLSchema " xmlns:msxsl = " urn:schemas-microsoft-com:xslt " > < xsl:strip-space elements = " * " /> < xsl:output method = " xml " omit-xml-declaration = " yes " indent = " yes " standalone = " yes " /> < xsl:template match = " / " > < xsl:for-each select = " annPanel " > < xsl: ...Show All

• RobSteele How to sign an assembly that is already compiled?

  I am building an application in 1.1, and all the assemblies in my application are strongly named. I want to reference an external assembly that is not strongly named/signed from one of my strongly named assemblies. The build in VS fails because strongly named assembly cannot reference weakly named assemblies. I do not have the source code for the weakly named assembly. What are my options Can I sign the weakly-named assembly using any tool so that it can have a strong name. Thanks. sweet. Thanks. Here's the cammand that does the trick - ilmerge weak.dll /keyfile:key.snk /out:strong.dll strong.dll is same as weak.dll with a public-key. I remember this problem bitti ...Show All

• a23rd Easy ways to distribute .NET Framework 2.0 to end users?

  Hello everyone, Since our app is built on .NET Framework 2.0, our end users will have to have .NET Framework 2.0 to run our app. The framework is about 22MB. Even on a decent internet connection, it takes around 7-8 minutes for the download and installation and also we dont have any control as to whether the installation went right or crashed in the middle for any reason etc I know a lot of people would have come across this issue, Can you let me know of ways of I can better this process. I am using ClickOnce Deployment and it generates a Setup.exe file (which includes the Framework). I tried InstallShield, even that takes same amount of time and the process is pretty much the same. Any or all suggestions is highly appreciated. ...Show All

• C NOOB which is the best obfuscation tool?

  There are many obfuscation tools in the market-Dotfuscator, CLiSecure, CodeVeil and PcGuard...... Many of u might have used them. Can u tell me which one is the best at obfuscation with respect to non-deterministic reverse logic, anti-debugging, tamper-proofing, anti-profiling. What is the most essential thing that is required to protect intellectual property what are the known limitations of obfuscation tools Please tell from ur experience. Thanks for reading. I usually use Dotfuscator... for simply obfuscation... and SafeKey-Hardware coding for the assembly. Dario what is SafeKey-Hardware coding I'm using Spices Obfuscator Recently, I have been evaluati ...Show All

• Joel Triemstra Wants to create an application which run in background

  Hi, I have to create a application that runs when client starts his computer for autoupdates Can anybody pls help me how should i start my application in background when user starts his machine Waiting for ur reply Thanks, Nilesh Nilesh Ingale wrote: Hi, Is there any other option available for my query Nilesh What's Your question Hi, Thanks for reply... one more thing i want to run the Windows Service when user gets connected to Internet and also check when user starts his machine if already connected to Internet then run the service otherwise whenever he gets connected to Internet How should i do this waiting for ur reply... Thanks, Nilesh Hi, ...Show All

• HKEC Measure data-traffic per IP-adress

  I have a pc with a number of devices connected to it. They are all connected via an utp cable. All devices have their own IP-adress. Now I want to measure the traffic of this data. In this way I want to check wether there is activity at the device (scanner). So when the number of bytes during a certain period is below a certain value, it must start another process. This must be monitored per IP adress. I want to use C# code to make this work. It's not my goal to measury the connectivity, I've read several articles on that subject. It's really about the quantity of data. Other recommendations regarding this subject are welcome as well. Thanks in advance! Using the System.Diagnostics.PerformanceCounter class would probably ...Show All

• Jon Braganza Stored Procedures takes long time to execute from Web Application

  Hi, We have a got unique problem with one of our Stored Procedure. This stored procedure takes a long time to execute when called from data access layer which is in C#, takes around 5 minutes but takes very less time to execute when executed from query analyzer, takes around 6 seconds. We are using data access block of Enterprise Library 2. All the other stored procedure within the application works fine. It is only this one stored procedure which is behaving very odd. The same stored procedure works fine if we give a short date range (6 months) from the data access layer but takes lot of time to execute when you give a bigger date range (4 years). Also doesn't seem to be a data load or network issue the reason being the 4 ye ...Show All

• ermark FAQ

  <asp:HyperLink NavigateUrl='<%# "FaqAns.aspx id="&databinder.eval(container.datait em,"faq_id")%>' Runat=server><%# DataBinder.Eval(Container.DataItem, "question")%></asp:HyperLink> The above does send to the page faqAns.aspx. If i want to send to the same page,meaning question on the top of the page and when clicked answer to the particular question showing at the bottom of the page How would i do this If i have to use the anchor tag could you show some ex using the above code please Thanks. Why would you late bind an ASP:Hyperlink The ASP:Hyperlink NavigateURL property should really be set in the code behind. You would probably use an an ...Show All

• Nadav Popplewell Cannot add a SimpleContent column to a table containing element columns or nested relations

  Hi, i'm trying to populate my dataset with one XML and i get the error: "Cannot add a SimpleContent column to a table containing element columns or nested relations" There is the code: Dim ds As New DataSet Dim doc As XmlDocument = New XmlDocument() doc.Load(URL) doc.Save("players.xml") ds.ReadXml("players.xml") Can someone help me out please It looks like your xml contains an element which has both text children (simple content) and other element children. DataSet does not allow a table to have both simple content columns as well as element columns. See http://msdn2.microsoft.com/en-us/library/zx8h06sz.aspx Thanks, Priya Fou ...Show All

• Revenicus Windows Vista x64 Conexant Audio Driver Problem

  I Have a gateway Laptop, Model number MX6437. AMD Turion64 processor, ATI Radeon Xpress 200m Graphics, 1 Gig of Ram (upgraded from 512). I Downloaded The Windows Vista Beta 2 x64 bit Version. It installed ok, but I have Found I have no Sound driver. I have Tried Windows Update, no luck. I Have Also Rebooted my pc and pressed f8 and turned off the Assighn digital signiture. Rebooted, Still no sound. I have tried Drivers that people on here have recomended but still no luck. Even the ati south bridge driver. every time i do an install on thier recommended driver they say worked for them, i get an error message saying: error installing software. The specified file cannont be found. I still have a red x in the sound icon. I have a conexant aud ...Show All

• Euclidez ftp sockets in c#

  hello sir, iam using ftp server(c#), thru my client ftp program is connected to remote server ftp. but iam unable to access like listing files in the remote host, uploading and directory creation and removing . Is that do we need any permissions for doing above operations. well sounds like a permissions issue. you have to give it the credentials to use when connecting/performing the action you want. What .NET Framework version are you using Can you also show us the code you are using while iam downloading a list of files from the remote machine . it shows "one error " The system can't find the specified file. This is my client ftp program ...Show All

• robinjam DataView Query

  I'm using VB 2005 My database is Oracle 9i I have a dataview of a very large table. I want to query it for a specific date or range of dates. My query looks like this: Select * FROM TableName WHERE (DATE_UPDATED >= TO_DATE(:PARAM1, 'rrrr/MM/DD HH:MI:SS')) No matter how I format the TO_DATE or the PARAM1 date I cannot retreive records for the current date. When I query yesterday I get yesterday and today. When I query for anything else I get everything. There are over 32 million records in this table so getting everything is not an option. Current Date = 11/07/2006 Example: PARAM1 = 2006/11/07 05:00:00 - I get no records Example: PARAM1 = 2006/11/06 05:00:00 - I get yesterday and today Example: PARAM1 = 2006/11/03 05:00:00 - I g ...Show All

• Grant Holliday How CLR Works

  Hi there Can any body tell me (or site link) that, How does CRL able to know that the Object is not further going to used by programmer. CLR able to know which object is not in use, but what if it used afterwords (i know about the B+ Tree algo. for the know the deletion & about Generation 0,1,2) Regards, Thanks. Gurpreet S. Gill Here are 2 excellent and in depth resources that discuss the .NET Garbage Collection http://msdn.microsoft.com/msdnmag/issues/1100/GCI/default.aspx http://msdn.microsoft.com/msdnmag/issues/1200/GCI2/default.aspx Definitely not for the weak at heart though. Lots of reading and synthesizing to do. Hi MarcD thanks really Gr8. I wil ...Show All