Search results for query: *

I have a report that used to connect to a table, now it connects to a stored proc that returns the same fields. Problem is that the fields on the report still get their values from the table, but I want to them to get their values from the stored proc. Is there some easy way to keep my report...

I'm using Crystal 10. I have a stored procedure I wrote that exists in an MS SQL 2000 database. From the Crystal development environment, I open the Database Expert window so that I can select the Stored Procedure I want to base the report on. When I try to select my stored proc (by moving it...

CHALLENGE: I need to create some kind of process that grabs data from a MySQL database and puts it into a MS SQL 2005 database. One database lives on a Linux server and the other lives on a Windows server. The only way the two databases can connect to each other is through the internet. The...

Is it possible to have a grid on a web page that behaves like a spreadsheet in the sense that you can quickly type in numbers and press enter to move to the next row? Thanks for any information...

I'm relatively new to ASP.NET. I am using VS 2005 to develop my website. I'm trying to figure out how to change the settings in my .SLN file using the VS interface. I cannot seem to find any corresponding menus or dialogs that affect the parameters in this file. EG: VirtualPath, PhysicalPath...

I'm looking for materials that cover what is taught in Oracle University's class entitled Common Foundation 8.11. This is a 1-day class. I can't imagine that it covers that much and it seems the same stuff could easily be absorbed from a document or small book. I am brand new to JDE...

I'm running an ASP.NET application that is designed to copy a file from my workstation to a shared folder on our network. When I run the website from my local instance of IIS, the file copy actually works. (I have Anonymous Access turned OFF and Windows Integrated Security turned ON. IIS is...

I'm working on a simple webpage (ASP.NET) with some simple security requirements. One of the things the webpage needs to do is copy a file from the user's workstation to a shared folder on the network. When I run in dev mode (where the website is running on a local instace of IIS on my...

I have a GridView control on a web page that I bind to a DataSet. I want to right-align the data in the columns that contain numeric data. I would think that this should be as simple as setting a property on a column, but apparently Microsoft wants to keep this a secret, so I am wasting a whole...

I wrote some code to sort my DataTable. Please refer to the code below: // ------------------------------------------- // dsData is a DataSet containing a DataTable called "Table" that is loaded with unsorted data. // I want the data in this DataTable to be sorted by PayeeName. DataView...

here's my code, which is designed to generate an error: -- ================================================= DECLARE @ErrNum INT DECLARE @Msg INT SET @Msg = 'TEXT' SET @ErrNum = @@ERROR IF @ErrNum <> 0 PRINT 'An error occurred and is being handled gracefully.' ELSE PRINT 'No errors...

I have a web page that calls a web service that calls a stored procedure. I want to elegantly handle any errors that might occur in the stored procedure so that the user has some feedback. Can someone recommend a good way to pass error messages all the way from the stored procedure back up to...

If the password changes for the owner of a DTS package or SQL Job, how will this affect the DTS Package or Job, if at all? I can see how it would a DTS Package called from a command-line script, where a user name and password are provided - which is the method I use to call a DTS Pkg from a SQL...

I'm a newbie to security, alerts, notifications... I need to be notified when certain users login to my database. I have changed the Audit Level to "All" so that SQL keeps a log of when someone logs in. Can I somehow assign alerts to these login events? Or is there a way to query the SQL Server...

When changing the audit level on a SQL 2000 Server, from None to All, (on the Security tab under SQL Server properties) does the server need to be restarted before the change will take effect?

Is there something like an IsAlpha() function in .NET. This function would return true if the character that is passed to it is in the alphabet (a, b, c, d, e, etc.)

Does anyone know if there is any real difference between the following? USER USER_NAME() CURRENT_USER SESSION_USER If I execute the following code in Query Analyzer, I get the same value for each statement: PRINT USER PRINT USER_NAME() PRINT CURRENT_USER PRINT SESSION_USER Why so many ways...

I've been asked to delete some users from my new client's live production database - user that they perceive are no longer needed. SQL Server admin is not my strength. What precautions should I take? I don't want to inadvertently disable some process because the user that owns it no longer...

I want to implement an "Undo" feature on a DataGridView control. This control is not connected to data source. I am simply loading data from a text file "manually" and allowing the user to edit and save the file. Does the DataGridView control have any built in support for Undo, or will I have...

I need to execute some code when the user presses the ENTER key on a DataGridView control. However, it seems that the ENTER key is preprocessed by the control, and is not passed on to the KeyDown event. Anyone know how to interupt this pre-processing, so that the ENTER key can be handled? I...