Search results

It is possible on 2005. You can specify which database to use in the configuration manager for 2005, not sure on 2000 though.

Which version of reporting services are you talking about?

If you have SQL Server 2005 you can also use the reporting services that comes with that, and link to your SQL 2000 database. Yes. When you install reporting services it also installs the files required for visual studio.

The extender control does have a format property as well. Try using dd/MM/yyyy instead of the default value.

Have you tried the following? Go to your textbox in the DetailsView, edit the databindings and select short date from the format property.

When you select a date from the calendar, does it display the correct value in the textbox? Is it only when inserting into the database, it switches it to mm/dd/yyyy?

You may need to set the globalization in the web.config file, if you haven't already done so. http://msdn2.microsoft.com/en-us/library/ydkak5b9(VS.71).aspx Copy the globalization bit into your web.config, and just change the culture/uiculture to en-GB.

Seconded, tis a good book. :) Yes, the VB code is actually printed in the book. The C# code comes included on a CD.

Yep, function looks ok. But there is something trying to convert an integer to a decimal. On which line of the code does this error occur?

In your second attempt the only integer I can see is for WeekNumber. What is the data type of the returned value from your function?

You say you tested the query before, did you test it with the username parameter? If so, and it worked you should check to see what is being stored in the UserName variable. Debug through it, and find out what Me.User.Identity.Name is bringing back for the UserName variable.

Just create a new variable with the same data type as your function, then set the value of the variable to your function Weeknumber_Entire4DayWeekRule(inDate).

Thanks for all the responses. I downloaded VMWare Server yesterday, so I'll try it through this. I just need to try and create a windows server iso to install on the vm. I don't have the disks, but copied the files to the hdd before sending them back to IT ;). Trying to create a bootable...

We currently have a Win Server 2003 Tower, connected to the network. We are administrators of the tower. We can access the DNS server, but can't edit or make any changes on it. Looks like it will have to be via a VM Session then. Thanks

Hi folks, Has anyone here installed SharePoint? I work at a college doing development, and the college is going to implement SharePoint. We want to get ahead of the game and look at developing WebParts and the like, and be able to test them out. Except I'm having issues installing it on...

Try creating the stored procedure on the db server. Open SQL Server Management Studio. Open the database, and select the Programmability folder. Open Stored Procedures folder, right click and add a new procedure. It will load a template to create the procedure. Replace the following...

Wardie, can you post the code for your GridView. It would help us to see how you have it set up. Also have a look at this tutorial which checks the status of checkboxes in a gridview per row. http://www.asp.net/learn/data-access/tutorial-52-vb.aspx

Well you don't use a query as such in a BLL you point to the queries in your DAL. Have a look at the Data Access Tutotorial on BLLs. The update method populates a datatable using a query in the DAL to select all by ID, using your requirements it would be: SELECT * FROM tblHours WHERE ID =...

An alternative would be to use a BLL. You could set up your BLL with two update methods, one for updating everything in the table and a seperate one for updating just the Approved field. In your code behind when you iterate through the GridView, check if the checkbox is checked and if so...

Yes, it will continue running through your code, you need to exit out of the DetailsView_ItemInserting Sub to stop it inserting. In the if statement after setting the text for the label add: e.Cancel = true