Search results for query: *

I have a query that uses containstable for a free text search. I think I understand how it ranks in general but keep getting hung up on this one issue. If I query using the phrase "performance and management" I receive less records than if I used performance management wrapped in single quotes...

This should be easy. I have a combobox with state names. If the country is not US we don't want to require the state. The value of the state combobox is a tinyInt which the entity framework in VS 2010 converts to a byte. So I am trying to test for this like so: If statecombobox.selectedValue =...

Hi. I have a requirement to upload large pdf files from a customer and after some thought decided to see if I can upload the file in chunks to hopefully lighten the load on the server a bit. I have the below code but it's not working properly. The resulting file is way too large and when I try...

I am using ASP.NET 2.0. We are using a stored procedure w/ a pivot query that returns the names of positions and hours worked per project but depending on the dates passed into the stored procedure the same positions do not get returned - people get promoted, leaving, etc. Since the pivot query...

I have an upload control in a subdirectory under a website that is anonymous. The subdirectory has integrated auth enabled and in my web.config I configured identity impersonate = true and allowed authenticated users on this subdirectory. Need this to have authentication on it so can communicate...

I have a gridview in my web app and need to get the sum of one column. The gridview data is all bound by asp:boundfields. Not sure what the best way to do this is because I need the data in decimal format and boundfields are strings. This is my code; this all happens in the RowDataBound: Dim...

We have a database with two roles that have execute permissions on our stored procedures. From what our DBA tells us this should be enough. The roles should not need select permissions on the table as long as they have execute on the stored procedures. But when we try to run any of these stored...

Hi - I am using a matrix in sql reporting services to build a crosstab report. I set the background color in an expression on the background color property of the row. It works fine as long as the database returns a value. If one cell is null then the color is not applied to that cell...

Hi - I am using a matrix in sql reporting services to build a crosstab report. I set the background color in an expression on the background color property of the row. It works fine as long as the database returns a value. If one cell is null then the color is not applied to that cell...

I am trying to create a cross tab query with the matrix control in sql reporting services 2005. I am using the below query to populate the matrix. I want the matrix to detail task hours by position. It is working but I don't know how to keep it from repeating the columns (i.e. positions) and it...

We are developing an application in our development environment; the app is on windows 2003, iis 6, .net 2.0. In the web.config we have identity impersonate = true and in iis site is set up for integrated authentication only. We are running SQL 05 in mixed mode for authentication (SQL Server and...

This should be simple and I do have this working on another application - the only difference is that I am not setting my querystring in the ascx page which is what I am trying to do with this. Is it even possible to set a redirect that sets a querystring value in an ascx page? I have my...

Need some help with setting up authentication for .net web app. This is my first time setting up authentication in .net so I might be missing something. What I have is an app that needs two levels of permission - on the root folder domain users will have permission and in the admin folder only...

Posted this on the .net forum - thought I would try here too.

does anyone know if the MS Access property RecordsAffected can be returned to a .net web app via the OLE DB provider? I know the provider does not support output params but since this is a property I would think it would be accessible. I looked all over the web and could not find a solution. I...

Does Access support output parameters? I have a stored query that I am using in a web app - I would like to have it return the pkey of the last inserted record. It doesn't seem to like it when I specify that a param is an output query - VarName Long OUTPUT - or when I tried using @@Identity.

This should be simple - I have a gridview on my web page with a dropdown that is bound to an ObjectDataSource. The ObjectDataSource has a SelectMethod with a TypeName that points to a DAL. The function inside the DAL is asking for a parameter to pass to Access to perform the query. I used...

I am converting an access application to .net. We are keeping the date in access - I am not all that familiar with access but I am fumbling my way through it. Any way, I have a query that I am using to populate a gridview in .net. Since gridviews will not display a blank row if there are no...

I am converting an access application to .net. We are keeping the date in access - oh joy... Any way, I have a query that I am using to populate a gridview. Since gridviews will not display a blank row if there are no records I added a union to my query in access to select a blank row from the...

We have an editable gridview in an accounting app. In order to show the edit/update/cancel buttons we are using <asp:CommandField ShowEditButton="true">. We need to add an alert/message box when a user tries to put in an entry that is invalid. How do we add an alert to a CommandField? *we can...