Search results for query: *

I've been asked to create a database where a stipluation is that a table entry can have 0,1,2,3 documents associated with it - these documents are unique to each entry - I modelled it but I wondered what designs others have used / would use in this instance. Any advice much appreciated

I've inherited a DTS package that populates a table with close to 1 million rows. The table has a clustered index and several non-clustered indexes. The DTS package issues a truncate table comand and then data is copied into the table with a SELECT. Should I then re-index or as the data is...

I'm migrating DTS packages that copy data from Oracle to a Sql server. I've installed the Oracle 10 G client on the server and I'm using the Microsoft Ole DB for Oracle provider to connect to an oralce database - the package runs but only selects part of the data and excludes data of type...

I'm migrating DTS packages that copy data from Oracle to Sql server using the Microsoft Ole DB for Oracle provider - the package then only selects part of the data with data of type varchar2 missing - on the other server the package runs completely - has anyone else experienced this before? Any...

I want to extract data from an Oracle database using DTS / Microsoft OLE DB Provider For Oracle - what oracle related software do I need to install on the server hosting the instance of SQL Server?

forgive my lack of knowledge but is there a web-based system available for monitoring SQL Server instances and the server they are installed on? If yes could you point me in the right direction

I'm a IIS novie - I'm trying to configure a web server to hosts multiple dev sites I really want to set things up so eg http://devserver/devsite1 http://devserver/devsite2 I must be doing something fundamentally wrong as the only way I can get individual sites working is to access them using...

I've been given the task of sorting out a dev server - the live version of the database and the dev version are very different how would anyone recommend updating the dev version so everything (roles table designs etc) is identical to the live server - I was going to fully back the live server...

I've been given the task of sorting out a dev server - the live version of the database and the dev version are very different how would anyone recommend updating the dev version so everything (roles table designs etc) is identical to the ive server - I was going to fully back the live server up...

I've just taken my 70-315 exam and passed (962/1000) - for the benefit of anyone taking the exam I used the following strategy which worked for me. Buy the MCAD 70-315 Textbook by Kalani - it's a monster (~1300 pages) but well worth it. I worked through 90% of the examples in the book and read...

I recently had a request for editing data in a datagrid - the customer required the <EditTemplate> of the datagrid to contain a RadioButtonList set with data from a database. I'd used texbox's a number of times in then <EditTemplate> of datagrids but never a radiobuttonlist - the following...

I'm pretty new to OO and was wondering is it best to handle exceptions within an object and provide feedback to the user or let the exception be handled in code or throw a new exception containing a custom message: eg In the example below I handle the exception in the object and set a bool to...

I have a required for users who have been authenticated using forms authentication to be able to upload files from their desktop - I can set a folder to use the aspnet account but I want the user to be able to upload any files from their desktop or other drives. Any help much appreciated.

Does anyone know a good code example to help me do this including writing the schema. Any help much appreciated.

Does anyone know of a free / cheap CMS developed in .NET preferably C# that is easy to brand and deploy. Any help much appreciated.

I'm using a page with several panels - I instantiate an object and using Page.DataBind(); in the subroutine in the codebehind and <%# Object.Value %> in the apsx page - so far so good. I then change the value in the object and use the same approach as above Page.DataBind(); in the subroutine in...

Is it possible to select a row from a datagrid after clicking a PushButton in a buttoncolumn? Any help much appreciated.

The method below returns a ListBox, it works as I can iterate through the items and the correct items are returned. However the web control is not populated. Any help much appreciated. //declaration protected System.Web.UI.WebControls.ListBox forwardOptions; //assign listbox to return from...

The method returns a ListBox as I can iterate through the items and the correct items are returned. However the web control is not populated. Any help much appreciated. //assign listbox to return from method ListItem forwardOption = SetForwardOptions(currentRoleId); foreach(ListItem li in...

Can anyone point me to a resource that explains how to re-sue web forms - the reason I'm asking is that in the web app I'm working on several forms are duplicated and I assume their exists a mechanism for re-using / building forms on the fly in .NET and would like to be pointed to any resources...