Weste's Q&A profile

• SQL Server Unable to get return value of execute sp_executeSql @sqlString

  Hi All, Create proc sproc_Insert @TableName varchar(50), @InsertColumns varchar(1000), @InsertValues varchar(2000), @WhereCondition varchar(200) as Begin Declare @CheckStr nVarchar(2000) Declare @RetVal int Set @checkStr = 'Select * from '+ @TableName + ' '+ @WhereCondition execute sp_executesql @checkStr,@RetVal output print @RetVal End I am not able to retrieve the return value in the above procedure. For example if data exists then 1 else o Thanks & Regards Bijay Hi Andrea Montanari, Thank you very much for your support. Now I am able to check the condition and retrieve the return value.Now it is working properly. Thanks & Regards, Bijay ...Show All

• .NET Development obtain the same value

  Hello, i'm a freshman on C#...,seems that's a simple question but i can't do it..., please give me some clue on it... i've a text file as below, every string line ends with CR & LF A A B B C ..... how can i retrieve the lines which has the duplicated ones, as the text file, there're two lines of A & two lines of B... etc. please forgive me if it's really very easy... thanks Richard You will have to revamp the code but the trick is to change the hash. Instead of holding an int as the value..it will hold a list of strings. It should look something like this Dictionary< string , List< string > > theList = new Dictionary< string , List ...Show All

• .NET Development Clipboard...

  Hi guys, have a problem with the clipboard. When I do: ClipBoard.SetText("Test"); It sometimes works, but most of the times it doesn't and you can simulate this by placing the code under a button and clicking multiple times on it. The error I get is:The requested clipboard operation failed Thanks, Nick ok thanks for the reply guys. The problem isn't fixed but I was able to use another more reliable way of transfering the data. As the data is very limited I was able to transport it via atoms (unmanaged) but hey it works ;-) Grtz, Nick ...Show All

• SQL Server Trying to connect to SharePoint database

  I am having trouble connecting to the SharePoint database on my web server. Our company intranet is accessed by http://webservername/ and the SharePoint site is accessed by http://webservername:2020/ (I wanted to put it on a different port to not interfere with our old intranet). Anyway, I need to connect to the DOCS table on the content database, but I can't seem to connect with SQL Server 2005. When I connect to webservername I see our company database but I don't see anything that has to do with our SharePoint stuff. I've tried connecting to webservername, webservername:2020 and webservername\SharePoint and webservername:2020\SharePoint with no results. If this isn't the right MSDN forum for this I apologize, but any advice would ...Show All

• Visual C++ Is the MFC Font Dialog resizeable?

  hello there! Can the MFC Font Dialog box be resized If yes, what particular method in the source code can do this I mean, do I have to include a constant in the CFont Dialog constructor (like the OFN_ENABLESIZING in Open by File Dialog) Or is there a flag in one of the CFont Dialog class members that needs to be set Thanks, doyle What does the documentation say I am not sure, but it is my understanding that questions such as this are supposed to be off-topic for this forum. I think that the MFC document/view newsgroup is the best place to ask this question, or another web site's forums such as CodeProject or CodeGuru. ...Show All

• SQL Server Trouble creating function

  DECLARE @winnings select @winnings = sum ( amt ) FROM player WHERE st in ( 'GW' , 'BW' ) and id = 'var' Select @winnings DECLARE @plawin money SELECT @plawin = sum ( amt ) FROM player WHERE st in ( 'GB' , 'GP' ) and id = 'var' Select @plawin DECLARE @credit money SELECT @credit = ( @plawin - @winnings )/ 100 From player where id = 'id' and date between '01/20/2007 08:00:00AM' and '01/21/2007 08:00:00AM' select @credit ...Show All

• Visual Studio 2008 (Pre-release) Why doesn't this Code work?

  Hello, my Code: Public Class Class1 Dim frame As Frame Dim _name As String Public Sub New ( ByVal name As String ) _name = name Dim win As frmMain = Application.Current.MainWindow Dim g As Canvas = win.FindName( "can" ) frame = New Frame frame.Name = name g.Children.Add(frame) End Sub Public ReadOnly Property Name() As String Get Return _name End Get End Property Public Sub BlendIn() Dim ani As New Animation.DoubleAnimation ani.From = frame.Opacity ani.To = 1 Animation.Storyboard.SetTargetName(ani, Name) Animation.Storyboard.SetTargetProperty(ani, New PropertyPath(frame.OpacityProperty)) a ...Show All

• Visual C# How to read from a text file?

  I want to read the words from a file and store the words in a 2D array. The first word in store in the first row of the array.the second word in second row..etc.. How can I do that Because that's my assignement. Our professor wants to test our ability to handle array. ...Show All

• SQL Server Object reference not set to an instance of an object

  Hi all I m trying to access a server report through report viewer control. I got the error "Object reference not set to an instance of an object". I have administrator rights on the reporting server. I have created this report using Business Intelligence Projects. I am using textboxes and rectangles throughout the report. When I compile and run the project through Business Intelligence Studio, it works very fine, but when I try to access it through direct url or by report viewer control, it gives the above mentioned error. I tried to deploy a blank report (having no controls like textbox, label, rectangle) to the report server, but got the same error, "object reference not set to an instance of an object&qu ...Show All

• Visual Basic finding a certain process

  i'm wondering how to find a particular process that is associated with a certain folder. My issue is that In my program when I go to delete a folder that I have created for a temporary workplace I use Directory.Delete(tempPath, True) to recursively delete the folder and all of its sub-folders and files. But sometimes I get an exception stating: "The process cannot access the file "C:\temp\compress\dest2\0\source\2006.9.22_28" because it is being used by another process." i can see through other tools that process 1932 is associated with that lock, but how can I find that out through code and kill that process Dim procs As Process() = Process.GetProcesses Dim theproc As Process For Each theproc In procs thepr ...Show All

• Windows Forms Create a Strong Name for Com DLL so ClickOnce will work

  I'm having a heck of a time tryin to get this stuff working. Here's my problem: We have a 2.0 VB.NET desktop app that uses Com components from our phone system. When you make references to the COM components for the project, they create the Interop.xxx.dll files in the project's bin folder. Well, I'd like to figure out how to get them into the GAC or how to some how make them strong named so that they'll work when I try to deploy them with ClickOnce. I've tried to use regfree com to deploy them and that doesn't work (I can provide the error if it will help). I've also tried to drop the Interop.XXX.dlls into the GAC and that won't work because they're not strongly named. Now, maybe if I could figure out how to name them strongly it would wo ...Show All

• .NET Development Connecting to Access Database

  Does anyone know how to connect to a access database using vb.net I created the database in access and added the Odbcdataadapter and was able to preview the contents of the database. I have a text box with a next button and a new button. Each time I click next i want to see the names that i have in the database appear. When i click new i want to be able to enter a new name in the textbox and it gets written to the database i already have with the names. Any thoughts Thanks!! You have this code: if Me.theDataSet.Tables(0).Rows.Count <= curPos then Me.theTextBox.Text = Me.theDataSet.Tables(0).Rows(curPos)(" ColumnName ").ToString() curPos = curPos + 1 else Me.theTextBox.Text = & ...Show All

• Microsoft ISV Community Center Forums Problem with Connection Strings

  Hi All, I have an excel spreadsheet, which I want to use like a database table and access using ADO from another spreadsheet, but whenever I attempt to assign my connection string to the ActiveConnection property of my ADODB Recordset, I get the following error: Could not find installable ISAM. Below is the connection string: Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\Le09\kpl_biskra\personal_biskra\ksmith\Reporting\Weekly\Christmas Analysis\DataFile.xls;Extended Properties=Excel 8.0;HDR=Yes; Can anyone help Many thanks! Keith Excellent! It works when I use the quotes. I use connectionstrings.com quite a bit and it quite clearly uses the quotes. I must have been half asleep! S ...Show All

• SQL Server SSIS package designer lookup component GUI error?

  Has anybody seen this issue already If you try to "enable memory restriction" from the Lookup component GUI you need to input both 32 and 64 bit size of maximum memory. However when clicking "OK" on the editor you get a message like : TITLE: Microsoft Visual Studio ------------------------------ Error at Update Execution Logs [Lookup folder path 1 [4429]]: Failed to set property "MaxMemoryUsage64" on "component "Lookup folder path 1" (4429)". ------------------------------ ADDITIONAL INFORMATION: Exception from HRESULT: 0xC0204006 (Microsoft.SqlServer.DTSPipelineWrap) ------------------------------ BUTTONS: OK ------------------------------ You can only set the p ...Show All

• SQL Server jumping to report from report within a same frame

  Let's say I have a web page that has two frames, A and B. Frame A shows lists of products, Frame B shows the Inventory Chart of after clicking a product at Frame A. The inventory Chart has a drill down link to another report XYZ. Once you click on the drill down link, the whole IE will be occupied by the report XYZ. How can I have the drill down report XYZ to be shown in Frame B and Frame A still remain there Thanks Jens. But the script void(window.open('xxx','_blank'))" " is already coded in clicking on a product at Frame A. My question is on the drilldown link in a report showing at Frame B whereby after clicking at the drilldown link, the next report will shows at Frame B. Any suge ...Show All