Lawrence Parker's Q&A profile
SQL Server ConnectionManagerOleDb usage in a Script Component
Hi, I have a need to use a shared connection manager of type OLEDB inside a Script Component. I guess that the right way to get the OLEDB connection is to override the AcquireConnections method, case the shared connection manager to the ConnectionManagerOleDb interface and call the AcquireConnection method. The problem is in the return value of the AcquireConnection method (it’s Object). My assumption is that in case of OLEDB connection usage, the AcquireConnection method returns some OLE DB COM interface. Does some of you tried to cast it to some interface/class exposed by DTS (or some standard COM interface from MDAC) PS I’m aware about the possibility to use ADO.NET connection managers, however it’s n ...Show All
.NET Development help: Update Records In a Database
I'm not using sql. All I've done is placed a dataview grid on the form and set up a datasource. Then I set up the text boxes so when you click on one of the records on the dataview grid it will shows the rest of the data from that set into the textboxes (That works). Then when I click an add button a new row appears (This also works) and then I am able to type into the textboxes with the information as required (this works). Then I'm stuck to actually update the database file because as soon as you close the form the new data is lost. I have tried using this code construct (not included all textboxes though) DataSet .tablename.column = textbox1.text; this .tablenameTableAdapter.update( this .dataset.tablename); The error ...Show All
Visual C# Exception in custom sink not handled when debugging
I have a very odd problem which I hope someone can help me with. I have written a very simple test program as an excercise in using a custom sink - just a simple server with a single method called GetReply() and a simple client. After configuring the remoting the code in the client looks like this: try { responseTextBox.Text = server.GetReply(); } catch (Exception MyErr) { MessageBox.Show(MyErr.Message, MyErr.GetType().ToString()); } Now, if I run the client without running the server I expect to get an exception, which indeed I do - a SocketException with the message "No connection could be made because the target machine actively refused it", and without the custom sink this exception is caught in the above code and the ...Show All
Windows Forms Prerequisistes to run a Winforms application
Hi, I already tried a search but didn't find the right answer. I just wrote a Winforms application and tried to run it on 3 different computers, other then mine. On 2 PCs it doesn't work. I think there's something to install on that computer. What do a generic user have to install on his computer to be able to run Winforms applications Is it necessary to install the entire .NET framework or are there other options you can either download and install the correct .NET Framework version on the PC or you can create a setup and deployment project which will create a setup for your application. The advantage of this is that it will automatically download the .NET Framework for you before proceeding to install y ...Show All
SQL Server Multiple Subtotals and Subtotal Expression
Windows Search Technologies wds exception error when clicking file types tab
System WinXP current with all updates. WDS 3.0 beta 2. Uninstalled previous version of WDS prior to installing 3.0. When using control panel to access indexing options, then advanced button, then file types tab, I recieve the following error. RUNDLL An exception occured while trying to run "C:\WINDOWS\system32\shell32.dll,Control_RunDLL "C:\WINDOWS\System32\srchadmin.dll",Indexing Options" When accessing indexing options from right click on tray icon, then advanced button, then file types tab, I get the following. RUNDLL An exception occured while trying to run "shell32.dll,Control_RunDLL "srchadmin.dll"" I've spent most of the morning trying to find any information on this with no luck. I've also un ...Show All
SQL Server "header should remain visible while scrolling" question
Hello i design a report in Reporting Services 2005 while using the feature "header should remain visible while scrolling". The problem is that it work fine in some cases and in others it's dont. when it's works fine the table header stays visibale while scorlling ,when i choose a different value for the parameters report the header in not remain visible. i dont have any explanation to why this happens beacuse the feature is for the table appearance without carry to which parameter i choose. does anyone have explanation to this Regards, Amir ...Show All
SQL Server Broken BI Studio after Office 2k7 install
After an install of Office 2k7 last night, I'm getting some errors in my event log when i run BI Studio. The errors occur when i click a tab that tries to browse the metadata of the cube. IE: The calculations tab, or KPI's, etc.. These are the 2 errors: Event Type: Error Event Source: MSOLAP$LocalCube Event Category: (289) Event ID: 1 Date: 1/09/07 Time: 8:54:08 AM User: N/A Computer: WS124 Description: The description for Event ID ( 1 ) in Source ( MSOLAP$LocalCube ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The f ...Show All
Commerce Server Catalog Navigation Bar
I would like to keep the Catalog Navigation bar (on the left hand side of the screen) still displaying when I get down to the last item of the chain. Once you get to the product list screen the Navigation bar "Disappears" and you then have to use the Bread Crumb to get back. Please Advise. Hi, Did u get the solution for this I need to implement the same in my website.. Kindly help. Thanks, Regards, Hari ...Show All
SQL Server Exporting Data from Database to a csv file
Hi, How do I export data from my database table into a Comma separated value file format. I am using SQL Server 2005 with vb.net Thanks Hi Greg, Thank you for the reply,I am writing a program in VB Express (SQL server express 2005) and I have to do it through coding...I tried data reader writer.writeline but it didn't work out... Do you have an idea how can I do it using ADO or BCP but through coding.... Thanks®ards, Can ...Show All
Visual Studio Express Editions I can't use my own program!
Ok, so. I go into VB Express Edition and make my program. Now, its just something simple that i would like to launch on my own computer. I know in the older version of VB what you do is go to the 'File' menu and select make application executable but there isn't that in this edition and I don't know where to find it! Someone please help! It's in the Bin\Debug folder of your project. Which is in a sub-folder of your solution. You ought to build the Release version into the Bin\Release folder: Build + Configuration Manager, change Active Configuration from Debug to Release. Build + Build. ...Show All
Visual Studio Express Editions Drag Drop a Node from tree list to a Rich Text Box
How would u make it so that u can drag a node from the tree and put it into The Rich Text thing. Lets say that the tree is TreeList1 and the the Rich Text thing is RichTest1, please be specific on how u would do it, thanks for your help! UPDATE: Or how would you do this "if you click a node, the text from the node goes into the RICH TEXT BOX." For a treeview: Private Sub TreeView1_NodeMouseDoubleClick( ByVal sender As Object , ByVal e As System.Windows.Forms.TreeNodeMouseClickEventArgs) Handles TreeView1.NodeMouseDoubleClick Dim n As TreeView = CType (sender, TreeView) RichTextBox1.Text = RichTextBox1.Text & n.SelectedNode.Text End Sub ...Show All
Windows Forms How to Enumerating the Serialports automatically which are exist in the system.
hi, i want to enumerating the Serialports automaticall to a combobox for example if in my system have com1,com2,com6, it automatically read thes comports and show in the box. is there any namespace provided by .net for these type of application if so then how i want it in c#.net. regards RPM! thanks in Advance i write a sol for the above problem if any body required he may go through the following code bellow it a classi made to read all Hardware configuration of the system. then from this u get u suitable port. every body can use this class /*call this method on button click*/ private void load() { StringBuilder devices= new StringBuilder(""); UInt32 Index=0; int result=0 ...Show All
SQL Server AS 2000, Excel 2003 and calulated measures
Hi I have created a calculated measure - which when i view in the Analysis Manager - Browse it displays what I need. In my Excel Pivot Table I cannot see the field when I Show Field List is it possible to have calc members in Excel 2003 however, my initial problem is this (and I am hoping someone can come up with a better solution): I have a fact table that is simply number of hours worked per month and linked to dimensions such as the customer. Each Customer has a budgeted time (which is on the customer dimension) - I need to include this budget. I have a separate cube that is the detail of the budget and I have tried creating a virtual cube - the problem with this is the budget is only visible if I use dimensions from th ...Show All
Game Technologies: DirectX, XNA, XACT, etc. My Game's "Engine" So Far
So using my game engine (I hate that phrase, it should really be called a game code library), I made a quick little 2D shootemup scroller in a few hours for my girlfriend. That's when I realized how powerful my code has gotten in just a few days of work. So, I guess that means it's time for a vanity post :) Right now, I have these mid-level components implemented - StaticSprite AnimatedSprite Tile TileLayer TileMap GuiMouse All of the components are serializable as well. Here's what I need to do next - Particle AnimationEditor TileMapEditor ParticleEditor The only problem with the editors is the lack of a GUI system. I don't really want to write another GUI system. I wrote one really crappy one ...Show All