AugustWind's Q&A profile

• Windows Forms how to make gridview to change datasource

  i want my gridview to change the datasource when i click on a button. eg. i have button1 and button2 and SqlDataSource1 and SqlDataSource2 ... so when i click on button1 i want the content of the gridview to change to SqlDataSource1 and the same with button2. how can i do that I would have hoped that you had supplied more information on what FRamework version you are using and what kind of tools or IDE you are using(such as VS.net 2003/2005 etc.), But I am going to assume that you are using .NET v2.0 because of "GridView"(thinking of DataGridView) In .NET 2.0 using VS.NET 2005, your proble ...Show All

• .NET Development Should I call Dispose on a SQLCommand object?

  Should I call Dispose on a SQLCommand object If I do, what exactly gests disposed Jonathan Hi, Disposing an object is just like marking an object for disposal when the Garbage collector runs. So that it would be removed from the memory. Well, if you don't need your object then you must indeed call a dispose against it... cheers, Paul June A. Domag ...Show All

• SQL Server Unpivot Transformation Null Values

  Hi, I am trying to use the Unpivot Transformation, and I have the following mapped out, following the example from the SQL Server 2005 BOL Unpivot Transformation: Input Destination Column Subject ValueNumeric ValueString ValueNumeric Pivot Key Value RACE OTHRRACE GENDER Column Name Subject RACE OTHRRACE GENDER Data Records 99999 1 NULL 1 88888 NULL Hispanic 2 77777 2 NULL 2 Desired Output Pivot Key FALSE TRUE ...Show All

• SQL Server Storing images in sql server 2005

  Hi There I have not had much luck finding info in BOL. I have a directory with many images, i need to load these images into sql server.We want to staore them in the database instead of the file server. What is the best way to do this TSQL (i am hoping), .NET code or maybe even SSIS I have been reading what i can find in BOL basically all i know so far is that image data type will be no more in the future and i should use a varbinary(max) data type. Basically i need a good link or something that can demonstrate how one can go about loading images into Sql Server 2005. Thanx In SQL 2005 yo ...Show All

• SQL Server columns in select list

  In your client, sure -- every client library can do that.  In SQL Server, probably not.   What is the business or technical problem you're trying to solve   Perhaps we can come up with a better way of handling it. -- Adam Machanic SQL Server MVP http://www.datamanipulation.net --     < buragohain@discussions.microsoft.com > wrote in message news:6926c563-86b6-40a5-a3f0-3bc32f8e9e94@discussions.microsoft.com ... hi friends! Suppose, i have a query: SELECT fname AS Firstname, lname AS Lastname FROM Customer Now is it possible to get the column ...Show All

• SQL Server Programmatically Render Report to PDF

  Hello, I'm looking for an example on how to programmatically render a report to pdf in C#. I don't want to use a url with the rs:Format=pdf querystring. Any help would be much appreciated!! Hello, Have a look at this doc page: http://msdn2.microsoft.com/en-us/library/microsoft.wssux.reportingserviceswebservice.rsexecutionservice2005.reportexecutionservice.render.aspx There is a full example of how to render reports programmatically using the Render method. -Chris ...Show All

• Visual Studio 2008 (Pre-release) XAMLPAD integration in VISUAL Studio 2005 Beta 2?

  Hi! I am starting to try out functionality in the new Avalon, and wish to use XAMLPAD as an external tool in Visual Studio. It seems like there is no support for loading .XAML files in XAMLPAD XAMLPAD / does not give any hints.  Any suggestions I have tried to use MOBIFORM Aurora, but it seem to put in some extra markup that i do not need, and I miss intellisense. By the way is there a more efficent way to "refresh" synchronization between .XAML and the code-behind file than doing a build before getting access to UI objects Henning K. Skoglund Hi Henning, I'm wondering about what extra markup that you ...Show All

• SQL Server Upgrade worked. Thanks.

  Hi, I am trying to make some stored procedures that take in lists of well sites and well ids and find the wells in the sites except for those in the list of well ids. I have a stored procedure like this. ALTER     procedure sp_wellSelect (@criteria ntext) as DECLARE @hDoc int   --Prepare input values as an XML documnet exec sp_xml_preparedocument @hDoc OUTPUT, @criteria   --Select data from the table based on values in XML SELECT distinct w.well_id, w.well_name FROM Wells_by_site ws      INNER JOIN well w      ON ws.well_id = w.well_id WHERE ws.SITE_ID IN (   & ...Show All

• Visual Studio 2008 (Pre-release) ScaleTransform for all the controls of the grid at SizeChangedEvent of the window

  Hi, I was wondering if anyone knows how can I aplly the same ScaleTransform to all the controls of the grid while a window resizes. Appreciate your help. I can't bring up an example just yet, but this is what you'd want to do: 1. Define a LayoutTransform for the main Grid. 2. Determine a "default" size, or a size the window can be that will not scale the grid. 3. Bind the ScaleX to the Window.Width / DefaultXSize and do the same for ScaleY I'll try to build you a quick example when I have some time. ...Show All

• Visual Studio Document Explorer crashes

  Thought I'd start a new thread, since I'm using Visual C# Express, rather than full VS2005. Windows XP Pro SP2, Visual Studio 2003 Pro, SQL Server 2000 Developer Edition, Visual C# Express, Visual Web Developer Express, SQL Express 2005, MSDE. I also have Virtual Server 2005 SP1 beta installed. Problem just started this weekend. Whenever I click on any topic in the Index, Document Explorer crashes. I've tried Repair on Visual C# Express, Visual Web Developer Express and MSDN 2005 Express. Same problem. It was working fine last week, I'm not sure what's changed. I have previously had VS2005 beta2 installed, but I removed that by following the ...Show All

• .NET Development Handling Special characters in Indexing service

  There are certain documents in the Indexing server that have special characters like ' and - in the document title (Document properties -> Title). On querying for these documents, these values are corrupted in the title example - is converted to ... How can this be fixed to get the correct results use contains in the query @Doctitle contains 'xyz' i think the following link explains http://ncrules.state.nc.us/searchHelp.asp ...Show All

• Visual Basic erroneous "Unused local variable" warning

  Hope I am posting this to the correct forum. I get the diagnostic Warning 1 Unused local variable: 'ex'. D:\ODP\Core\NetMover.NET\NMServe\Database.vb 1211 15 NMServe Here is a snippit of code showing what is being highlighted with the above diagnostic... CommitTrans:     Try        Plog( "" )       Plog( "Committing changes to the database" )       trx.Commit()     Catch ex As Exception       Plog( " - " & ex.Message)       ...Show All

• Visual C# server client data send problem

  Hi. I am able to successfully connect the client and server together using the Sockets/tcpclient/tcplistener and able to send messages between each other successfully. the problem is this: when the client sends "[-]RF[-]" to the server, the server checks the incoming data, if it is "[-]RF[-]" then it sends back to the client the file name, for each file in the current working directory of the server. after each filename, it sends that name back to the client, the client should recieve it... and it seems to do this. however, it seems as if the client is recieving this in 1 big long string. This is not what I have told the server to do: SERVE ...Show All

• Visual Studio DSL and visual studio

  I'm coming to terms with the differences in VSTS and VS Professional. I have experience of producing my own template classes and simple wizards with Visual Studio. How does this compare with producing a DSL using VSTS I think I know but I'd like to hear other experiences. How did other people go about moving forward to a DSL approach from "adding my own class or wizard" Thanks Jason For me, the key difference between Domain-Specific Modeling and wizards is that whilst both generate large amounts of code for a small input, I can ignore the code generated by DSM, only interacting with th ...Show All

• Visual Studio Team System Permanently Delete Work Items?

  Hi, I'm running TFS Beta 2 and VS 2005 Beta 2. I was wondering if there is any way to permanently delete work items Not just to mark them as Closed, but completely get rid of them I have full access to the server. Is there a safe way to go into SQL Server and delete items from the database, or are there command lines tools to perform this Thanks, Kevin We had the same problem and where able to delete them via this SQL statement. Make sure you set the DELID (1729) to the Work Item ID that you want to delete. Tread Lightly.... I am no expert but it seams to work for us. Declare @DELID int ...Show All