hipswich's Q&A profile

• SQL Server Cannot get CREATE LOGIN from a Windows group to work

  I have created a database fronted by an ASP.Net application. It's all nice and simple, and I only need a very simple level of security (and even that is only as a protection against accidents rather than maliciousness). My intention is that users connect using Windows impersonation (<identity="true">), with the database creator having full access and the public group (I'm talking SQL groups here) having specific premissions granted on specific tables. If I set <identity="false"> on my XP box the application connects to the database as [MACHINE\ASPNET]. This is easy to set up access for - I simply do a CREATE LOGIN [MACHINE\ASPNET] FROM WINDOWS and then within the actual database do a CREATE USER [MACHINE\AS ...Show All

• Visual Studio 2008 (Pre-release) Set Focus / Selection to child item

  Hi All, I have a TreeView control with several TreeViewItem objects. My TreeViewItem object consists of a DockPanel and my DockPanel consists of an Image object and a TextBlock object. Now what I basically want to do, is on the selection of the TreeViewItem, bubble the selection down to the TextBlock. So that my Image is not in a "selection" mode. The reason for this is once I select my TreeViewItem, it selects my entire TreeViewItem giving my Image an ugly blue background colour which I would like to avoid if possible... Alternatively, if someone could help me "override" the default selection style so I can set it transparent and force my TextBlock item to then have the "selection" background... K ...Show All

• Visual Studio 2008 (Pre-release) Xbap download gets 404 not found for a DLL

  I've setup IIS for deploying an xbap application. I navigate to the page and it starts to download, but I get a 404 not found error for a DLL I'm trying to include: ERROR SUMMARY Below is a summary of the errors, details of these errors are listed later in the log. * An exception occurred while downloading the application. Following failure messages were detected: + Downloading http://localhost/TaxBap/XamlUtils.dll did not succeed. + The remote server returned an error: (404) Not Found. However, this file is in the directory. I can see it from IIS as well. Why would I get a 404 here My application uses an Images directory and I got a 404 for that. I copied the Images directory and the 404 went away. I thought the same thing woul ...Show All

• Visual Basic Passing a Byte Array to a COM object expecting a variant

  I'm trying to pass a byte array to a COM object, SHDocVw.dll, which expects a variant variable. VB.NET won't let me do this. I understand that the variant type is no longer supported in VB.NET, and I have come accross several references to marshaling, but none that make any sense to me. Anyone have any ideas [my appologies, but as this is an urgent issue for my project, I posted this issue (sort of) on another thread with a subject meant to attract a different knowledge base - sorry for the duplication] Right, I understand what the %.... is. But when you pass data as post, you can't do it that way, else it doesn't extract correctly, using request(<varname>). Your suggestion works ...Show All

• SQL Server Is SSB the correct tool

  We have an sql database where the performance is being impacted by a number of secondary applications performing complex queries for reporting and other business requirments off the database We have considered a solution where when an update is made to the primary database we use an asynchronous trigger to kick off a SP. The SP will then use service broker to send a message to a secondary database which updates the data on that secondary database. Note the data on the secondary database is a denormalised subset of the data. We think Service broker is the right solution as we get the updates to the secondary database asynchronously, reliably and in order. Is this a good solution for Service broker or can anyone advise a better ...Show All

• Windows Forms How to commit data changes from DataGridView to SQL database?

  Hi I can not find the right way to commit the data changes from DataGridView to SQL database. Let's say I have a table in DB. A typed Dataset was created from DB via VS2005 wizard. The table in DataSet was populated via Fill() method of TableDataAdapter, also created by VS2005 wizard. The table in DataSet was binded via BindingSource to DataGridView. When user changes any values in a cells, BindingSource.ListChange event was used to commin the changes to DB via TableDataAdapter.Update method. The code shows data fine, but the data modification works only one time, the second change causes NoNullAllowedException from inside of TableAdapter.Update method. Curiously, this second change happen to be commited to DB inspite of exception... He ...Show All

• Visual Studio Express Editions Another Problem

  Hi, I was wondering if there is anyway to turn a huge amount of code into a simple function. Right now I have a bunch of check boxes and they are all named C1-C7 and W1-W7, instead of putting in code for each one when clicked, which results in a large amount of code, is there anyway I could make one function to handle all of these. I tried something like this. If C(num).checked=true then W(num).checked=false endif its just a basic example of what i want and i could really use this later on. Thanks I am getting a nullreferenceexception was unhandled error for the code posted last. It looks like what I want, just needs to work. ...Show All

• .NET Development Problem with 'Oracle client' and 'ODPnetOnly'

  Hi all ! I have both Oracle Client and ODPnetonly on my system. They have their different homes. If the path of Oracle Client (D:\oracle\ora90\BIN) is before the path of ODPnetonly (D:\odpnetonly\bin), then I have a problem. In this case, my web applications (in C#.net) don’t work but my console applications (in C#.net) do. And if I change the path of ODPnetonly before the path of Oracle, then my web-applications work but my console applications don't. So please tell me what is wrong with my system. Is there any problem regarding installation of 'Oracle Client' or ODPnetonly (I installed 'Oracle Client' before the ODPnetonly) Thanks and Regards, Vikas OK, I think I understand what is happening. While you ...Show All

• Visual Studio Express Editions String to number

  Is there a quick way to convert the string "2.334.654,23" to the number 2334654.23 I have tried decimal.parse but does not like the format of the string (it works with 2,334,654.23). Thanks, Antonio Just tell parse that it's OK with a leading sign by adding the: Globalization.NumberStyles.AllowLeadingSign flag to the parse method. For more flags that you can specify, check out http://msdn2.microsoft.com/en-us/library/system.globalization.numberstyles.aspx . Best regards, Johan Stenberg ...Show All

• .NET Development Calling up the "Internet Option" window.

  I have a question, is there anyway I can call the "Internet Option" window open from within my web browser I wan't my users to be able to open up there internet options from within my program... Thanks! Hi, How can i open "Internet Options" by click on the right click from internet explorer I know how to set new context menu item, but i don't know which URL to call. Thanks ...Show All

• Visual C++ VC++ IDE file output settings.

  In the C# and VB IDE you can set any file in your solution whether it be a text file or whatever to be copied to the output directory (either debug or release). In the VC++ IDE you cannot. How would I do this in the VC++ IDE IDE: Visual Studio 2005 Professional Did you read what I said about double quotes I think that double quotes is important and if you had done as I said, you would have gotten results that helped you determine the problem. Did you look a t the build log The build log is the htm file that the output window tells us about. The build log provides more information about what is happening here. VS executes "Command Line" as a command. In other words, whatever you put there will be executed as if you ty ...Show All

• .NET Development how to use where clause in data adapter

  SqlDataAdapter AdapObj = new SqlDataAdapter("Select * from Employees WHERE employeeid = 1", myConnection); hi im using the above code, but it is genarating an error, I know the way i have used the where clause is wrong, can somebody please show me how to correct the above code. thanks in advance The SQLCommand that you are creating is redundant as you are passing the command text to the DataAdapter. The constructor for the adapter will initialise a command object, assign the connection object as passed in the constructor to the command, and assign the new command obj as its select command. Yes, your right, I amended the code to this string tsql; text1.text = tsql (in the ...Show All

• Visual Studio 2008 (Pre-release) Problems with Setup (.NetFxRC1 & Orcas)

  I am really struggling to install .NetFx Rc1, Windows SDK and orcas community release. Even after installing and running the uninstall utility and installing the whole sequence twice it is not working. Visual studio will not recognise my wpf projects. Can somebody help me out here as I am really stuck and cannot code. Atul Thanks for replying. I guess I had multiple issues in the earlier install. One of which was Windows SDK install problem which I was able to solve by deleting the C:\Program Files\Reference Assemblies\Microsoft, kicking the box and reinstalling the sdk. However on installing orcas, it still complains of no documentation found! and install the documentation from wi ...Show All

• Software Development for Windows Vista Installer incompatible with Kerio Firewall

  I've noticed a consistent failure with all the WinFX / NetFX3 installers. The install will hang unless I disable Kerio Firewall before running it. It stops at this step: dd_dotnetfx3install.txt [06/25/06,23:51:07] VS Scenario: Checking if new setup is available. Url= [06/25/06,23:51:07] VS Scenario: http://go.microsoft.com/fwlink/ LinkId=65628&clcid=0x409 At which point setup.exe takes up 48% CPU (Pentium 4 Hyperthreading) and CANNOT BE KILLED. Clicking "End Process" provides no error message; running taskill from the comnand prompt provides the helpful "SUCCESS: The process with PID 2468 has been terminated." which would be great except process 2468 merrily continues along. (And the Windows Install service cannot ...Show All

• Visual C# CheckBox and CheckBoxList?

  what's the difference between CheckBox and CheckBoxList in a webform could anyone here give me a example for both many thanks is auction a same when checkboxlist is in a formview my checkboxlist is in formview now, I can't use it directly.. is any extra action should I take thanks again ...Show All