Search results for query: *

I have a fairly basic line graph which is bound to a SQLDataSource control. The graph displays perfectly, but I want the labels on the X-axis to display vertically rather than horizontally. I have used the following code to try and do this but it is having no effect: <AxisX Title="Patient...

I am trying to write a trigger in SQL Server 2000 that will update the LastModifiedOn filed in my table every time the record is updated. I have used the following code but it is producing a syntax error: CREATE TRIGGER [UpdateAssessments] ON [dbo].[Assessments] FOR UPDATE AS BEGIN UPDATE...

I am tearing my hair out over a problem with drop-down lists. I am trying to use one in my main prject but have had such problems that I have created a test page just containing a single drop-down list to see fi I can figure out the problem. Basically I have a test table with 2 fields...

I have an old VB5 app which connects to an Access database and then loops through a recordest creating an array of labels for the records. I have been asked to link to a different database which is in SQL Server 2000. The code I used to connect to the access database was as follows: Dim...

What is the easiest way to display the contents of a database record on an ASP.net page using Visual Studio 2005? The page merely needs to display the data as read-only text. In the past I have used a series of labels which were populated using a datareader. The datareader was filled using...

I have a gridview which is bound to an XMLdatasource control. Everything is working perfectly apart from the sorting functionality. I am aware that sorting is not supported by the XMLdatasource. Can anyone tell me the easiest way around this problem?

I have a web page which uses a GridView to display the contents of an XML file. The grid is bound to the XML file using an XMLDataSource control and that all works fine. The XML fle looks something like this: <FOI_Enquiries CreatedOn = "12-Aug-08"> <Enquiry EnquiryID="89"...

Looking for a bit of help regarding the scoping of session variables. I have a couple of old application developed in ColdFusion, both of which store the ID of the person logged in a session variable called session.who Every page in each of the applications then has an include fiel which...

Can anyone tell me the simplest way of refreshing a drop-down list. I have a page which talks the user through a series of steps to link a document to a particular record in my database. First they click a link which opens up an FTP window. Thet then drag and drop the required file into the...

I have a small form which is used to record recommendations against health issues for a patient. The form had 2 combo boxes on it; Recommendation and Status. Recommendation gets it values from a lookup table. The rowsource of the recommendation combo is set to the following: SELECT...

I have a flexgrid on my form which is used to display Issues and their corresponding recommendations. Issues have only one visible column which displays a description of the issue. The recommendations have 2 columns: a description column and a column stating whether is is met or unmet. When...

I have a combo box which is used to allow the to select a response source from a preset list. The sources are in a table called lkup_RepsonseSources The SQL behind the combo box rowsource is as follows: SELECT lkup_ResponseSources.ResponseSourceID, [SourceRef] & " : " & [SourceDescription]...

I have a report in my database for printing address labels which is based on a temporary table which is emptied once the report has been created. When the user clicks the control box nutton in the top right corner of the report I want to prompt the user and give them the chance to cancel the...

I am trying to set the controlsource property of one of my text boxes in code when a button is clicked. I want to set it to the returned value of a rather complex DCount function. However to start off I'm just trying to set it to a text string and I can't even manage that. I am using the...

I have a continous with a number of bound fields on it, the last of which is a checkbox. When the form is run, the user can select one or more of the records by selecting the apprpriate checkbox. When the user click the OK button some code is executed to run throughall of the rows on the form...

I have an Access 2000 format database in which I have created an unbound data entry form. On this form I have 3 date time picker controls (MSComCtl2.DTPicker.2 class) which are used to enter 3 different dates. What I want is when the form opens up for these 3 controls to be blank and only...

I have written the following piece of code which uses the WriteXML method to create an XML file: Dim strSQL As String strSQL = "SELECT * FROM ExternalJobs" Dim dsInternetVacancies As New DataSet Dim adptInternetVacancies As New SqlClient.SqlDataAdapter(strSQL, SqlConnection1)...

For some reason, when I set Allow Sorting to True in my datagrid the headers do not change to Hyperlinks. Here is the source for the datagrid: <asp:datagrid id="dgrdCurrentVacancies" runat="server" AllowSorting="True" AutoGenerateColumns="False" BorderColor="#8AB0D5" BorderWidth="2px">...

I suspect there is a very simple answer to this question but I am so confused I can't see it. I have an XML file which contains all of my Job Vacancies data. I have a dataset that is populated with all of this data usign the ReadXML method of the dataset. I can then use this dataset as a...

I have set up a small test project to investigate the use of XML files in ASP.NET pages. I have written code which quite happily creates an XML file based on the contents of a Dataset using the WriteXML method. I am now trying to populate a datagrid based on the contents of an XML file using...