Search results for query: *

I have a client who is using Access to access SQL server tables. He says that whenever he opens and closes Access, the size of the .mdb file grows - perhaps doubling its size. He said he tried to repair it and that took it down to 53 meg. However the problem continues. It's gotten up to 1.5...

I ran the import wizard - saved the package but now I can't find it so I can even run it again. Do I have to make any changes to this guy in Visual Studio? I was trying to make this as simple and painless as possible.

I had to have a list control where the user could make multiple selections. My boss requires the use of data binding so that seem to leave out a listbox etc. The solution I ended up with is: I return a list of all potential items and a 1 if it already has been selected in the database, the...

Is there a way to select the results from a stored procedure so a sort order can be specified?

Can I set up a report to apply a custom logo depending on the customer generating the report? If so, how?

I have to return a recordset combining a many to one relationship so I fill one field with a list of the values in the many side of the equation. So I want to bring back something like this 'Football',1997,'punt,pass,kick' 'Basketball',2001,'15,22,18,51,55' Looping through with a...

No matter what I do - our authentication is getting lost at 20 minutes. The global configuration setting for asp.net 2.0 State Management was set to 20 minutes. I changed that to 60, but no help. I set the forms timeout attribute to "60". No help. I set the worker process shutdown in the...

I just installed Team Foundation Server on my machine and have been trying to load existing solutions which contain multiple projects. In three of the four cases, the project is the startup project. I get a message that says: The project type is not supports by this installation. This makes...

I have to work on a project with a wizard and six steps. I've never used this control before. Unfortunately they've just asked me to add validation to one of the steps. I can capture the fact there is a problem and prevent it from moving to the next step -- but my user control disappears. I...

I just got news that the dynamic sql I wrote for a search function is not acceptable. I have modified it all to use static code but I'm stuck on one last field. I have two status values which should be returned when one status value is passed. So for example 4 = Paid 7 = Confirmed. If 4 is...

I have to do some coding for another company to send automated emails. They insist that instead of using a console app that I use an asp.net web page called from an HTA. I'm not familiar with HTA's and searched fruitlessly to find out something relevant. Can someone point me in the right...

I am trying to set the visible property of an image using the Databinder.Eval. I tried returning a false or true string and a 0 and -1 numbers but I get the same error on the statement. Can I even do this. I only have picture in certain records so I hate showing the missing image icon...

I have two temp tables. One is all the records. The other is a summary of table one where I combine the quanity for similar skus. create table #tempSkus ([ID] int, ClaimID int, ProductCode varchar(50), Quantity int, InvoiceNumber varchar(100), ClaimInvoiceID int, ProductID int) create...

I have a masterpage which contain controls on it. I altered one of the controls to add a label. That label will not show up on my master page (and thus not on the pages inheriting from the master either). Is there something special I need to do to make the master page update the contents of...

I need to sweep through all the tables I have manually created and add two fields. The problem is that they both have a user defined data type with a built in default of getdate() and the function for the current user. When I add the new column I'm told the default is already set so I have to...

This is a tweener question which really deals more with the XMLDocument object than SQL Server but it was suggested I post this here (from asp.net). I borrowed some code from work that use SQLXML to create a dynamic menuing structure. It is pretty cool. Unfortunately I can't use SQLXML on my...

I borrowed some code from work that use SQLXML to create a dynamic menuing structure. It is pretty cool. Unfortunately I can't use SQLXML on my web host. I am not extremely knowledgeable about XML and the tools available. This returns some xml tags using the For XML keyword in sql The...

I am trying to publish my first asp.net 2.0 web site from my machine to the host (gate.com). The publish feature does not work (probably security issues or something) I was just going to copy the files up there. I expected to find a dll in my bin folder after I build. The only new dll's I...

I only want the page header to show on all pages after Page 1. How do I write a formula to compare the page number? Or if there is a better way to do that, I'll ears. Thanks.

I am trying to do something very simple. I have a textbox that I want to all the user to press Enter when they are finished typing to initiate a search. Neither keydown or keypress event fires when I use the enter key. The events fire for other keys so I know the handler is set up correctly...