oatman's Q&A profile

• SQL Server CLR test script SELECT returns no row data

  Hi, The test.sql scripts I write to test CLR stored procedures run successfully, but when I want to display the resulting data in the database with a simple "SELECT * from Employee" I get the result as: Name Address ---- ------- No rows affected. (1 row(s) returned) But not the actual row is displayed whereas I would expect to see something like: Name Address ---- ------- John Doe No rows affected. (1 row(s) returned) I have another database project where doing the same thing displays the row information but there doesn't seem to be a lot different between the two. Why no results in first case Thanks, Bahadir You maybe still have the ...Show All

• Visual C# C# Programming->Structure

  Hi Ques1 :-> Can be instantiate the object of a strcuture using default constructor after declaring the parameterised constructor in the structure if yes why bipro wrote: No. Let's say that you have the following code: public struct MyStruct { private int _x; private int _y; public int X { get { return this._x; } set { this._x = value; } } public int Y { get { return this._y; } set { this._y = value; } } } what you'll find is that the compiler adds in a default public constructor like so: public MyStruct() { } as a non static class needs to be instantiated in some manner. If, however, you specify a constructor, say: public MyStruc ...Show All

• SQL Server SQL Mobile create sdf file from SQL 2005 DB

  Hi, I'm trying to create a SQL Mobile .sdf file from my SQL Server 2005 database and cannot. I read the ms support docs for doing this and have had no luck . I created the respective publication and SQL Subscription for the db and when i run the process (not sure if i'm running the right process - docs don't say) it creates a directory under a "unc" directory with all my table objects (articles) with subscription/replication files for each table such as .cft, .bcp, .dri, .prc, .sch, and .trg. But no .sdf file for my SQL Server 2005 database. All I want is the .sdf file so that i can copy it to my Pocket PC device and then connect my mobile application to it. I want to copy my SQL Server 2005 database to my device so that t ...Show All

• Smart Device Development Creating Single Insatance Application in SmartDevice Application

  Hai,            I have created DeviceApplication present under Visual C#\SmartDevice\Windows Mobile 5.0 Pocket PC.The out of this is an exe.I want to make this exe to have single insatnce i.e if one instance is running,if u click on that exe for multiple times it must not new instances,instead it must pop-up some message.I have developed the exe in .NET 2.0 version.I tried to do fix the problem using mutex,but it did not work.Another approach is to derive a class from the WindowsFormsApplicationBase class in the Microsoft.VisualBasic.ApplicationServices namespace and set IsSingleInstance property.Can anyone explain how to do this for Smart Device Application.I found that GetProcessByName ...Show All

• Visual C# How can I find whether the current thread is exited or not?

  Is there any property or method is available for checking whether the current threading is exited or not. If so can you place provide me the code snippet and some of the useful tutorial & samples links for learning about this concept. I am not dealing with multiple processes. I am dealing with a multiple functions in same application. Here is my usage scenario. I have been creating a project that checks whether all the projects in given directory gets build successfully or not. The recursion function will be evaluated unto its leaf folder of the given path. While running all the processes, I need to give the option to stop the testing process. That’s why I am using thread concept for this purpose. I need ...Show All

• Visual Studio Team System vsts developer - testing question

  I've got VSTS Developer installed. I am wanting to conduct load testing on a web site and have reviewed some of the information on Microsoft's site. It appears that I'm only capable of performing unit testing on class files. Is that correct I'd like to do a load test and don't see where I can get Application Center Test in VS 2005. Is that tool still available Can I download it Do I need VSTS Tester to do load testing or can I download the template to do that If not would I have to uninstall developer and install tester to do load testing I really don't want to have to uninstall/install each version just to do a load test. I spend most of my time developing and after words, I need to do load testing. Any suggestions ...Show All

• Visual Studio Add Resources using EnvDTE in VS 2005

  Hi, I am using EnvDTE to generate a project from templates. What I would like to do is, in my Wizard, I give the user the option of selecting an Icon file. I can programmatically add this icon file to my Project. But I cannot add it to the Resx file as a resource. If I add a token "placeholder" for it in my csproj file, it does not find the file since my token replacements occur on RunStarted() whereas I add the file programmatically only on RunFinished(). Any assistance would be greatly appreciated! Regards AFAIK, project.Object would return a VSLangProj.VSProject object, not a ProjectProperties object. I guess that you mean project.Properties instead. About resources, if you ...Show All

• Visual Studio 2008 (Pre-release) Button Events

  Newbie question If if place a button on a window how can I set the mouse click event. I thought I could just click on the button like a normal Winform application and add the event code. Yeah, serious. Can someone make event code-behind generation and Snap-To a priority ...Show All

• Visual Studio Express Editions Mouse and Keyboad events question

  I am trying to process some data using an external application. This external application processes data from a binary file and performs some algorithm on it. I would like to automate processing these files and send the processed data to the database. To do this I have tried to use the user32.dll library and the FindWindowA, mouse_event and setCursorPos functions. I am also using the SendKeys function as well. Everything seems to work fine until I use the mouse_event function is called. After I use the mouse_event function then the SendKeys function no longer responds. All these pieces of code work fine seperately but when I put them together they do not work. Any help is appreciated, Thanks, price private void button1_Click ...Show All

• SQL Server Cannot find SQLResourceLoader.dll

  We have a server with the default instance and 2 addtional named instances running SQL 2000 SP4. I attempted to install another instance for SQL 2005 and promptly ran into the above error when running DTS packages on the default SQL 2000 instance. The legacy components had been installed and the server had been re-started. I also tried re-registering the dll as suggested on another forum post. Any ideas on what I could do to get around this problem We need to keep our existing SQL 2000 installs as is until we have a SQL 2005 server setup ready to take over the workload with absolute minimal downtime. Thanks Phill mailto:philcart@gmail.com http://www.philcart.net/blog http://www.sqlserver.org.au/user/bio/ViewBio.aspx bioId=46 ht ...Show All

• SQL Server Desprate..Please Help

  I wrote an application using Visual Studio 2005. This app requires a login that get that accesses SQL Express Data. I have an XP Pro box set up as a server using DSL Modem and connected to that is a Wireless hub. I used Network Wizard to set up a Home/Small Business Network on all the computers. My laptop has XP Pro and has Visual Studio and that's where I wrote the application. It's connect to the wirless hub with a cat 5 cable. The other laptop has XP Home Edition and is in another room is connected with wirless only. I set up a user called user1 in SQLExpress with a password. I set it up using MIXED MODE. (SQL server and Windows authentication mode) Connection String: myCn.ConnectionString = "Provider=SQLOLEDB;Data Sou ...Show All

• SQL Server OLE DB Source using table name variable

  I have a package-level variable [User::viewName], type = string, containing a view name. I want to setup an OLE DB source to use this variable value as the source, so Data access mode = "Table name or view name variable". The Variable name dropdown contains [User:viewName], so I select it. When I click OK to leave the edit dialog I get the error: The variable User::viewName is required to be of type "VT_BSTR". Only variables of type String occur in the Variable name dropdown; if I try changing it to a type other than string it doesn't occur in the dropdown. What is VT_BSTR and how can I change the variable type to it I've never seen VT_BSTR in my life, that isn't a data type that ...Show All

• Windows Forms How to hide properties in a custom control

  I'm creating a custom control derived from the masked textbox. I need to get rid of the set mask link that appears at the bottom of the properties editor, I have no idea how to do this other than maybe creating a custom designer. Is there an easier wayand if not how exactly would I accomplish this with a custom designer Hello Justin, You will need to put a Designer on your control to get access to the Verbs collection. I have never needed to do what you are attempting but perhaps something like below will help. Good Luck! private DesignerVerbCollection designerVerbs = null; public override DesignerVerbCollection Verbs { get { if (designerVerbs == null) { designerVerbs = new DesignerVerbCollection(); foreach (DesignerVe ...Show All

• Software Development for Windows Vista TC 20 - App Verifier error messages

  I am performing the following steps for the Certified for Windows Vista Test Case 20 7.Open AppVerifier 8.Attach application’s main executable to AppVerifier including a.Check the LuaPriv check 9.Launch the application 10.View application’s main executable AppVerifier log a.Search log for LuaPriv (Simpilest way to search is to search for “Severity=”Error””) I'm working on isolating the cause of the following App Verifier error generated when launching my app: OpenFileMappingW: Section (\Sessions\2\BaseNamedObjects\windows_shell_global_counters) only grants requested 'READ_CONTROL' to 'NT AUTHORITY\SYSTEM' Has anyone encounter a similar error and successfully tracked ...Show All

• SQL Server "Creating a Mobile Application with SQL Server" Tutorial Problem

  I am attempting to go through the "Creating a Mobile Application with SQL Server" walkthrough found in the SQL Mobile Books Online help file. Towards the end of this document (under SQL Server Mobile Tasks), they show how to create a new subscription. Unfortunately, after step 10--when you are asked to click finish--I get the following error: TITLE: Microsoft SQL Server Management Studio ------------------------------ Failure to connect to SQL Server with provided connection information. SQL Server does not exist, access is denied because the IIS user is not a valid user on the SQL Server, or the password is incorrect. HRESULT 0x80004005 (29061) ------------------------------ One potential area of concern is in setting up the w ...Show All