maheshshinde2000's Q&A profile
Visual Basic Executing stored procedure that returns parameters
I'm trying to execute a stored procedure "spImport" that returns three values: @InvalidCount (bit), @InputRecords (int), @Message (str) The following code gives me an error about SQLCommand: Dim TransferCommand As SqlCommand = stConnection.CreateCommand() TransferCommand.CommandType = CommandType.StoredProcedure TransferCommand.CommandText = "spImport" Is there a better way to write the code ...Show All
Visual Studio Can't get CSharp Web templates using GetProjectTemplate (bug?)
Hi, I'm trying to get the a CSharp version of a custom template for a Web application and I always get FileNotFound exception. I tried putting MyWebApp.zip file in the local User's template folder and the VS Web templates folder (and ran devenv /setup) and none of that is working. I tried the example given in another thread for VS Built in templates solution.GetProjectTemplate( "WebApplication.zip" , "W ...Show All
Visual Studio Team System I can't create PrivateObject, an exception thrown out
When i try to create a PrivateObject object[] args = new object[1] { "test" }; Microsoft.VisualStudio.TestTools.UnitTesting.PrivateObject priv_obj = new Microsoft.VisualStudio.TestTools.UnitTesting.PrivateObject(typeof(global::Class1), new System.Type[1] { typeof(string) }, args); An Exception thrown out Test method Class1Test.testTest threw exception: System.TypeLoadException: Could not load type 'Class1' from assembly 'Objec ...Show All
SQL Server Double quotes in ASCII file
I've an issue with double-quotes in CSV file. One of the columns may contain this kind of value: "STATUS ""H"" " I've got quote set to " The file source fails on such records. I found this thread and Scott tells us there that the file can't contain " in data. Is this 100% correct I've got mutliple text columns and the pain is that I don't know which column might have these cases in future. T ...Show All
Smart Device Development Playing sounds
HI im writting a new program and i need to be able to play sound files. Mp3 files prefered but i can use wave files or anything else that works. Forgetting to post probably ill put it in my sig. I use vb.net 2005 for smartphone 2003 Thanks all I simply lost the dogbark.wav file on my smartphone when I did the reset. Can anyone please tell me where I can download it or a way I can retrieve it again. I searched the device and for some re ...Show All
.NET Development Discard changes made to datatable columns of a Dataset?
Hello, I have a windows form with several text boxes. OnLoad, I use a DataAdapter which calls a SQL sproc to retrieve it's info. The sproc returns has 3 select statements so when all is said and done, the dataset ends up with 3 tables. (table, table1 and table2) Next I use databindings.add for each of the textboxes and bind them to the appropriate column in the appropriate tables. The textboxes are readonly by default and I have an Edit ...Show All
Visual Basic Add different database column values together
Hi How do one add a value entered in one table column to a other table's column I cant find a answer anywhere, I think this is a general problem for people new to database programming. Add a calculated column to your data table. There is an example on the vb-tips website ...Show All
.NET Development Standard Person definition schema
Hi all, I've been working with several industry standards for vertical matters such as Human Resources, Accounting, Billing, etc... However, none of those standards seem to follow a standard definition to declare person information. Do not misunderstand myself, they do greatly the job and I couldn't found any missing information but they just use their own schema definitions. I'm right now working on a project which mainly focus on mana ...Show All
.NET Development Using Bluetooth with VS 2005 beta 2
I was watching the " Creating a Managed Bluetooth Application Using Microsoft Visual Studio 2005 " MSDN video, and there was an example of using new bluetooth classes for connecting to a PocketPC via bluetooth. I have the VS 2005 and i didn't fount these classes. Classes like "ServerHandle" or "Core" and others dosn't exist. I want to use bluetooth to make my laptop as a Headset for my phone. I need to register a bluetooth Head ...Show All
Visual Studio 2008 (Pre-release) IIS Hosted COM+ Component
I have written a COM+ component that does a simple string echo. The component is set to run as a server and I can communicate with it via WCF when it is configured to be hosted by COM+ but whenever I set it to be web hosted and exposed via IIS I get a timeout when I call any methods on it. I can see the process load in the component services MMC snap-in but the calls to it never return. It also works fine if I set the component to use library a ...Show All
SQL Server SCD Wizard
I have created a dimension table for a star schema and included the following columns for treatment of historical changes: [StartDate] datetime, [EndDate] datetime, [Current] varchar(5), [IsInferred] bit My Business key is code and the historical attribute is code_desc. I run the wizard and nominate the Current attribute to be set to True or False. What should the type of this column be as it is not being populated TIA, Mi ...Show All
Visual Studio Express Editions How to activate the cursor in TextBox1
I would like to have the program activate the cursor in TextBox1, so the user can start typing immediately without having to first click on TextBox1. TextBox1.Select did the trick! ! ! Thanks a lot, guys! ...Show All
Visual Studio Subreport, business objects, VB, Local report
I've been looking at the Orders example (from GotReportViewer.com) and some of the other examples, trying to figure out how to get a subreport to work using business objects. I seem to have it all correct but I get: Error Subreport could not be shown. I'm using AddHandler for the LocalReport.SubReportProcessing call and it seems to work because the Subroutine gets called for each master record in the report. I have the parameter to tie the main ...Show All
Visual Studio Team System AT for Team 1 on same machine as DT for team 2
Another wierd configuration question: I have a machine that's currently hosting the DT for a TFS installation. I'd like to install the AT on that machine, pointing at another machine for the new DT. I have three machines: S1 - AT (machine is flakey) S2 - DT S3 - unused I'd like to end up with the configuration S1 - unused S2 - AT S3 - DT So, can I install the AT on my current DT machine (S2), pointing at my ...Show All
SQL Server RowNumber in Report builder?
Is there a way to create a row number column in reports created using Report Builder and Report Models eg. Seq Product 1 Book 2 Pencil 3 .... ...Show All
