rottengeek's Q&A profile

• .NET Development Help running SQL Transaction in 2005 vb expess

  I may have this in the wrong forum but, here goes... I need to run a SQL transaction against an SQL database in my vb2005 express application to remove duplicate records. I am really in need of some direction. Now here are the problems: I saved the transaction as a procedure in the database. (A sproc I believe). If I open SQL Server Manager Studio and execute it, it runs like a clock. There is a warning message about it not supporting the OVER command, but it works ok. So Here is the Btn_click to run the procedure; Private Sub Btn_sql_deletedups_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Btn_sql_deletedups.Click Dim MyCmd As New OleDb.OleDbCommand Dim Cnxn As New OleDb.OleDbConnection("Data S ...Show All

• .NET Development Permissions problem running from IIS

  Web application uses old style ASP pages at the front, and a vb.net 2005 DLL at the backend. The IIS web is setup with Integrated authentication, and Anonymous is turned off. One option in the app involves running through the shell command a .NET EXE. That .NET EXE attempts to do some WMI stuff but it doesn't have the permissions to do that. The Shell command is inside the vb.net 2005 DLL. I log into the browser as Administrator, and the winapi username shows up correctly as administrator in debug sessions. So why doesn't my shelled application have all the permissions that administrator has ------------------------------ more info.. ASP Page > x = createobject("mydll.myclass") c = x.shellthatEXE () In My ...Show All

• SQL Server SSIS Registry Configuration

  Hi, I have an SSIS Package which reads the properties values from Registry. As per the constraint of SSIS I have created the keys under HKCU in the registry and things work fine from the designer. But, when I schedule the SSIS Package to run under SQL Agent (which is running under Local System) the values of configuration do not seem to be picked up from Registry. How I tested was: I am picking up the server name for the Connection Manager from Registry and I set that value to an invalid servername. But, the job seems to be executing fine. Using DTEXEC it fails as expected since, this is running under my credentials. Also, SYSTEM has full control on the new regsitry keys. Any information on this Thanks, Gaurav ...Show All

• Visual Studio Express Editions How to tell when F18 key is pressed

  I have a keypad that looks like a usb keyboard to xp but sends F18 through f24 keypress when the buttons are pressed. How can I read these in C# Keydown and key press don;t work for F keys this high. Thanks Ringo That's odd, Windows defines virtual key codes for these keys (VK_F18..VK_F24) and the .NET Keys enumeration defines them too (Keys.F18 thru Keys.F24). You may have a problem with the USB driver for this keyboard... ...Show All

• SQL Server Report Server problem

  I am using SQL Server 2000 reporting services.I created a report in VS.net 2003.Report is showing in preview pane properly.But when i press start it gives a messege "No Reprot Server was found at http://localhost/ReprotServer". Is reprot server required for the reprot.whats other alternative to show the report on web browser Hi, The account that you specified in the setup must have the rights to run a service (Logon as a service permission). This can be set in the windows policy. Maybe that this is not set. I know that for 2005, the setup gives the necessary permissions but for 2000 it can be that you need to do this manually. Greetz, Geert Geert Verhoeven Consu ...Show All

• .NET Development WebClient.UploadFile

  I am using WebClient class to upload files from client side to server side, the system succeed to copy the file but fails to open it due to header lines were added, Please advice How can i upload the file from the client to the server successfully Nadia I create a txt file which name xx.txt, then I execute the WebClient.UploadFile to upload the file to the server side. The file was uploaded successfully but few lines of header and footer was added to the original context of the file. Please see the example bellow. -----------------------8c8883ecf24ad9e Content-Disposition: form-data; name="file"; filename="xx.txt" Content-Type: application/octet-stream Context of the txt file --------------------- ...Show All

• Visual Studio Express Editions Help Text to ACCESS problem

  I have a small problem I am reading a Text File and then Inserting it into an access file. It was working and now it crashes once the data has been inserted. The program used to stop when the file was read but it seems that now it wants to keep going. It crashes on " Dim IDid = S.Substring(0, 3) + S.Substring(7, 2) " becasue there is nothing to split I have been tring to Kill this with a While Exit statement but it does not work. ANy sugestions Here is my code: Dim connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=project.mdb" Dim theOleDbCommand As New OleDb.OleDbCommand( "INSERT INTO tblmain (PlayerID, Name, Team, Position1, Hits, Games, 1B, TB, OBP, SLG, OBPS, BA) VALUES (@p0,@p1 ...Show All

• Windows Forms Visual Studio 2005 Service Pack 1

  What I want to know is when can we expect the desperatly needed service pack 1 for Visual Studio 2005 I've had so many errors so far when working with the Windows Forms designer, it is not only VERY frustrating and wasting my valuable time, but, it is also embarrsing when my projects and clients are being delayed because of a low quality tool. I expected higher quality standards from Microsoft! Don't get me wrong, I love .Net and especially version 2. It's just getting so frustrating to experience these errors in Viusal Studio and then red about them on the web to find out that I'm not the only one experiencing them and nothing is being done so far to come out with fixes or a Service Pack! WHERE is Servic Pack 1 When can we expect ...Show All

• Smart Device Development Dll method problem

  Hi Guys I am new bie in Windows mobile platform. I am building a smartphone application using c#. It uses our own NetwrkAction.lib. Can you guys help me how can i use this lib in the project. I have follwoing functions that has to be used in the application. EXPORT CNetwrkAction* CALLBACK CreateNetwrkAction(); EXPORT void CALLBACK DeleteNetwrkAction(CNetwrkAction* obj); EXPORT int CALLBACK Configure(CNetwrkAction* obj,LPVOID aErrorNotifier,LPVOID aEventNotifier, const char *aPrimaryGateway); EXPORT int CALLBACK ConnectToServer(CNetwrkAction* obj); EXPORT int CALLBACK RequestToServer(CNetwrkAction* obj,const char *aPrimaryGateway); Can anybody tell me how to use this DLL with my program. Here's a classic example of call back if ...Show All

• SQL Server Fulltext indexes on separate catalogs

  For performance reasons if I have 2 separate fulltext indexes on 2 separate tables, should they also be in two separate catalogs Will putting them in the same catalog slow things down. I assume that catalogs cannot span filegroups. Thanks for your replay. So is it faster to put the two fulltext indexes in two separate catalogs on two separate filegroups or is keeping it all in one catalog and one filegroup prettyy much the same ...Show All

• Visual Studio Express Editions Reading a web page...

  I have been trying to read from a Web page inside of a WebBrowser control. I can read the entire page code, but can not specify certain areas of the page to read, like a text box. I would like to be able to read just the text box in my web page and have it write the context of the web page text box over to my application textBox... This is the closest I've been, but I can not get it to work at all. It will do the "if ()" event, which is just a message box, but it will not copy the web pages text box contents to my application textBox. <input name="txtName" type="text" id="txtName"> in order to get that element, I would do this: HtmlElement theTextBox = this.theWebBrowserCont ...Show All

• Visual Basic Through VB IDE, how can I find out if a particular program or EXE is running or not?

  Through VB IDE, how can I find out if a particular program or EXE is running or not Please advise on what function to use. A code snippet would be more helpful. thanks. The IDE itself does not have any typoe of function for that purpose...However you can use the process class to check to see if a process is running on your computer: http://msdn.microsoft.com/library/default.asp url=/library/en-us/cpref/html/frlrfSystemDiagnosticsProcessClassTopic.asp ...Show All

• Windows Forms Datagridview change the background color of some rows.

  Hi all. Picture this datagridview. Column a / Column b / Column c row1 = 1 / something / plain row2 = 1 / else / data row3 = 2 / dosent / dah row4 = 3 / mater / data row5 = 4 / else / just row6 = 4 / plain / for row7 = 4 / text / filling row8 = 4 / something / end row9 = 11 / else / some row10 = 6 / domain / nothing I want to change to change the background color of all the rows that have the same value on Column a. Row1/Row2 background color white (for all cells), Row3 backgound color grey (for all cells), Row5/Row6/Row7/Row8 background color white (for all cells), Row9 background color grey (for all cells), Row10 background color white (for all cells). I'm able to change the color of a cel ...Show All

• Visual Studio 2008 (Pre-release) No appropriate XAML tags for inline code

  According to the documentation (...), in an XAML document one can have inline code which contains, say, C# code for event handlers. Is it possible to insert such code in an XAML created with Visual Studio If yes, what is the correct tag which should contain the CDATA element In the articles that I consulted, either <def:Code> or <x:Code> is used; however, these tags always generate errors when I try to compile the project. This is what I did: - I created a new project (WPF or XAML browser); - in the XAML editor, I added some controls - say, a <Button>; - I added a handler for the button, with ' Click="OnClick" ' - I wanted to have the code of the handler in the XAML file. For this I tried to ...Show All

• Visual Studio Team System This type of page is not served.

  This type of page is not served. Description: The type of page you have requested is not served because it has been explicitly forbidden. The extension '.asp' may be incorrect. Please review the URL below and make sure that it is spelled correctly. Wat is solution This happens in Visual Studio 2005 when a "classic" asp page (not an ASP dot net page) is open and "View in Browser" is selected. How can the older ASP pages be edited and served using VS 2005 Jim ...Show All