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...

ok - must have had some value somewhere else tried setting the value to nothing and it worked this time....that's what i get for working on a friday afternoon!

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 =...

oh duh - that does make sense. i have not found any free controls that does what i need it to so really need to figure this one out. i think i am close with the code above but when the app gets to the ReadEntityBody the initialBytes variable looks too large in the beginning. Not sure how or why...

ok - haven't seen many that were free but didn't do an extensive search either. From what I have read, even if you use IHttpModule IIS still loads the request in memory before it hands it off to .net to do whatever. There is no direct way to have .NET just save the file to the hard disk unless...

Hi Mark. Thanks for the advice. We suggested splitting the files to the client but they didn't like that option. I did see that there are some third party options out there - not sure if they will shell out the $ for them but will keep it in mind. I read that no matter what .net will always...

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...

Thanks for the tip Jason. I hadn't thought of doing it that way (obviously). That worked just fine.

how do i return the column names w/ the result set? usually i tell it what columns i am expecting... while dr.read() Dim object As New object object = New object(dr("ColumnName1"), dr("ColumnName2"), etc.))

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...

Hi RiverGuy, Thanks for the offer. I spoke with our DBA and we are working through the issue. I originally thought that all of our stored procedures contained dynamic sql but only a few actually do. What I was thinking was dynamic SQL and what it really was are two different things. I am still...

Thanks - did some more searching online. It is all the dynamic SQL we are using in our stored procedures. Almost all of our sp contain some dynamic SQL. I just read a good description of it. I have included the link in case it helps someone else some day. Thanks...

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...

=IIF(NOT(SUM(Fields!Hours.Value) Is Nothing, Sum(Fields!Hours.Value), "0") Just to clarify what the report is actually reporting on - the report displays positions along with hours spent on a given project. The agency column is just to determine the color coding per request of management.

I think we are talking about the same thing - A single row will be one color (i.e. blue, yellow or white) but what it's doing is turning every single row one color, (i.e. all rows in the report appear blue). IsNull does not work with this query because there are no nulls being returned from...

That works - just one problem. Since I am using the value of a column to determine the color, the value of the textbox does not change per value of the column. It uses the first value it receives from the dataset then my whole matrix displays in one color. I have tried writing a function and...

Tried this out - not sure if this is working quite the way I expected or I am doing it wrong. This is what I did - Opened the rdl. Right clicked on the details cell added column, made column invisible. Set value of new column to function that returns color then set the row to the value of the...

Pretty much - a whole entire row will be yellow, blue or white. I tried to find the global color property but didn't see it. Where would that be?