Steve1999's Q&A profile

• .NET Development Cannot obtain schema information in the middle of a transaction

  Our application accesses a SQL Server database. It occasionally uses the GetSchema method to verify whether a table exists in the database (or sometimes that a specific column exists on a specific table). It occasionally uses transactions. Until recently, we had been using the OleDb data provider (with "Provider=SQLOLEDB.1" in the connection string), and OleDbConnection.GetSchema always worked fine for retrieving schema information. We recently switched to use the SQL Server data provider (System.Data.SqlClient). Now every time we call the SqlConnection.GetSchema method in the middle of a transaction, we get the following exception: System.InvalidOperationException occurred Message="Unable to b ...Show All

• .NET Development Future XSLT/XPath features in .NET Framework

  In effort to prioritize our goals we composed the list of random features each of them may add value to set of XSLT tools offered from Microsoft.   1.        XSLTc (Compiler for XSLT stylesheets, that generates .NET assemblies) 2.        Performance improvements in the XslCompiledTransform 3.        Compilation XSLT to JScript (like AjaXslt) 4.        Compilation XSLT to C++   5.        XSLT 2.0 in the XslCompiledTransform 6.        XSLT 2.0 in the MSXML 7.        XPath 2.0 ...Show All

• .NET Development Server Error in '/' Application.

  i got this error while publishing my webservice in my remote server.how to clear it.help me Server Error in '/insertWS' Application. There is one other error which you might run into is a what version of .Net that ASP.Net is set to use. For example when one upgrades to .Net 2, asp.might still be set to use .Net 1x. To check/change it to use v2 do this: aspnet_regiis Check via aspnet_regiis in the Framework version directory such as: C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727> aspnet_regiis -lv 1.1.4322.0 Valid C:\WINDOWS\Microsoft.NET\Framework\v1.1.4322\aspnet_isapi.dll 2.0.50727.0 Valid (Root) C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_isapi.dll If root is on 1.1..do the following if the web service ...Show All

• Visual Studio Express Editions Data Grid Question

  This is from the help Private Sub ResetSource() DataGrid1.SetDataBinding(adoPubsAuthors, "Authors") End Sub I would like to set my Data Source to be based on the results of two combo boxes in my form. I guess my question is, can it be set on a query vice a table. SELECT * from Ply WHERE LN = '" & cmbL.Text & "' and TN = '" & cmbT.Text & "'" ahmedilyas wrote: if you have the dataset filled with records, then you can use a DataView to filter the results without having to re-query SQL which is ineffecient. Example: Dim theResults as new DataView( theDataSet.Tables(index )) theResults.RowFilter = "LN = '" & ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Putting a hole in a sprite

  Hi all I am currently wondering how I could put a hole through a sprite "on the fly" during gameplay, such that the background behind will show through Some sort of blending, or combination in the spritebatch class I suppose, but I havn't yet worked out how. Any suggestions Chris J. Actually, recently I've made an example on exactly what you described. Here it is: http://www.hot.ee/qstorage/AlphaTest2.rar There are 2 different ways to do that: 1. With the separate mask file (you apply a predefined masking texture to another texture). The advantage of this method is that you can make a hole of any shape (just edit the mask file). 2. Without the mask texture, just using some s ...Show All

• SQL Server FullText Results from what column

  I am running SQL 2000 - upgrading to 2005 hopefully Q1-2007 I have a table that has 12 columns fulltext indexed for searching. Is there a way to tell what column has the search string If it is not possible in 2000 what about 2005 Thanks If you do a query like select * from t1 where contains(*,'term') you cannot tell which column the hit was in. You could do a set of queries with each column in turn if you wanted to tell where the term was found: select * from t1 where contains(col1, 'term') select * from t1 where contains(col2, 'term') etc.. In SQL 2005 you can specify a column list in the query (rather than just a single column or *) so you could do queries like: select * fro ...Show All

• Windows Live Developer Forums More efficient way to draw a circle then this...?

  I got this code form the VIAEarth website... it works great but it pretty slow to use. Does anyone know or have code that can produce the same effect but more efficiently this.circle = function(id, latin, lonin, radius, polygon) { // ref: http://viavirtualearth.com/Wiki/Draw+a+filled+Circle.ashx // returns polygon (if polygon != null) and polyline if not var locs = new Array(); var lat1 = latin * Math.PI/180.0; var lon1 = lonin * Math.PI/180.0; var d = radius/3956; var x; for (x = 0; x <= 360; x++) { var tc = (x / 90)* Math.PI / 2; var lat = Math.asin(Math.sin(lat1)*Math.cos(d)+Math.cos(lat1)*Math.sin(d)*Math.cos(tc)); lat = 180.0 * lat / Math.PI; var lon; if (Math.cos(lat1)==0) { lon=lonin; // endpoint a pole ...Show All

• Visual Studio Express Editions Stupid Developer News Doesn't Update

  In all most my Express Editions, the Developer News is dated back to the "12 Finalists Announced in...." In C#/XNA, however, it's updated to the "Coding4Fun Face lift." How do I update all my others like this   I registered them all. I found that this is a known bug that will be addressed in SP1. In order to update the content you can do the following: Tools->Options->Environment->Startup (make sure the show all settings button is checked) Set the "Download Content Every" box to 5 minutes. This will pull in the updated feeds. ...Show All

• Visual Studio Express Editions Moving files between projects

  Just transitioning to C#VS2005 so forgive the obvious. I have a solution with a single project that is getting cluttered. I can easily partion to multi projects but when I move source from "Project1" to new "Project2" I get muriad errors mostly related to not finding things. What is correct procedure for doing this well make sure that you are not referencing anything from one project to the others otherwise the project/class files/namespaces etc... may not exist what errors are you getting how are you doing this process ...Show All

• Visual C# problem with datasets for reports.

  Hi, I've recently testing the Microsoft report viewer and Microsofts reports and I discover some problems that I don't know how to solve I tested some datasets each one made with a diferent database (using always the same report), but the problem is that after I created one dataset and succesfull tested it, I deleted the Dataset and objects created and started over with another.... after that (when I feel confident enough) I started to build the report I was really going to use... but.. .BUT when I was going to set the Grid Data Set I realized that the name of the older datasets still exists but they DO NOT exists enywhere else in the project and I don't know how to get rid of those options. I even search throuh all the project fot the nam ...Show All

• Visual Studio 2008 (Pre-release) XAML to C# Code Covertor

  Is there a way to convert XAML code to a C# code that can then be linked into a project or solution There are several samples in the SDK like FontDialog that work fine by themselves but adding them to a solution that has WPF windows and Windows Forms, the XAML will not compile. It will not give a reason except for error messages stating that methods like InitializeComponent could not be found. This is becoming a showstopper as one can not re-use code. It would be great that all samples have a programmatically created UI version also till such time tools catch up with XAML. Thanks Hoon, It sounds like your problem is that you have created a Windows Forms project and added XAML files. A Windows Forms project can't compi ...Show All

• .NET Development WebMethod returning DataTable

  I got an improper result in dot Net web service. For example, I have a WebMethod GetData, [ WebMethod ] public virtual DataTable GetData( string tableName) { DataTable retDataTable = obj.GetData(tableName); return retDataTable; } Whenever WebReference to client application, in client stub (Reference.cs) GetData webmethod return type taken as GetDataResponseGetDataResult instead of DataTable . This behavior only in case of DataTable, in other case it is okay. public GetDataResponseGetDataResult GetData( string tableName) { object [] results = this .Invoke( "GetData" , new object [] { tableName}); return (( GetDataRespons ...Show All

• SQL Server populate catalog Full Text Search SQL 2005

  Hi To All I'm trying to populate catalog in SQL 2005, but it doesn't work because in tables there are ntext fields. In SQL 2000 it works normally. I've made some test in both sql server. Why Is there something to set in sql 2005 Thanks Bye Yes ok ... the problem remains ....I can't change the columns in nvarchar(max) tnx for answers. ...Show All

• Visual Studio 2008 (Pre-release) How to handle nullable values?

  I've built a custom user control and gave it a dependency property called "value". I've set property "value" to be a nullable boolean (bool ). Now I want to databind this property to a dataColumn of type "bool". Open the project in VS2005 and see that null does not bind correctly. http://www.simed-si.com/tmp/WPFcontrolsTester.zip   ...Show All

• Visual FoxPro CPU Usage when using Timer

  Hello, I am using an VFP 6.0 executable which contains a timer control which will constantly monitor for some files in another machines in the same network. This executable is not a visible one. But when used at the client I found in the task manager process the CPC memory resource is occupying some 50 to 70 % of resource and hence slowing down the other processes. Can any one give a solution for this problem Try using the SLEEP Windows API instead: Declare Sleep In Win32API Integer nMilliseconds nSleepSeconds = 1 nMilliseconds = nSleepSeconds * 1000 =Sleep(nMilliSeconds) ...Show All