- Upvotes Received
- 2
- Posts with Upvotes
- 2
- Upvoting Members
- 1
- Downvotes Received
- 0
- Posts with Downvotes
- 0
- Downvoting Members
- 0
30 Posted Topics
Hello, I need a little help with trigger, I have been doing database development for a long time now but this is my first go around at a trigger. It is not working, can someone please look at this and let me know what I am doing wrong: ALTER TRIGGER … | |
I am having some trouble. I have a Telerik editor where I display I file that is housed in my application. I need to save the changes back to the file. But some things also get saved to back to the database. My save button currently does save back to … | |
I am trying to write an MVC application. I am rather new to MVC and I am taking the project over from someone else whom started writing it. This is what I am trying to do. I have some html documents that are located within my application. When a user … | |
I have this method that gets me groups from AD: [CODE]public ArrayList GetUserGroups(string sUserName) { ArrayList myItems = new ArrayList(); UserPrincipal oUserPrincipal = GetUser(sUserName); PrincipalSearchResult<Principal> oPrincipalSearchResult = oUserPrincipal.GetGroups(); foreach (Principal oResult in oPrincipalSearchResult) { myItems.Add(oResult.Name); } return myItems; }[/CODE] But when I go to use it: [CODE]protected void AuthenticateAndLoadUserProfile() { … | |
I have a problem and I am not sure why this is happening. I have a Detailsview that users will be filling out. I have several dropdownlists and all of them work as they should accept the one with the ID of typeOfEmployee. When that is selected the value does … | |
Re: Here's the code I tried to use, but obviously you can't update two table in one insert statement because my code doesn't work: [code]Private Sub btnSaveToDB_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSaveToDB.Click Dim connection As SqlClient.SqlConnection = getConnection() Dim insertStatement As String _ = "INSERT Operations, Operation_Dates" … | |
I have this code I need to write. In my database I have some child jobs that belong to parent job. I need to stop the parent job if all child jobs are stopped, I have this code but it is not working and I am not sure why. I … | |
Ok, I hope I can explain this so that everybody understands. I have a database where a column has special characters in the fields. I need to remove these characters before printing them to a file. I have the following code: [CODE]public string RemoveSpecialChars(string[] args) { string[] chars = new … | |
I need some help. I have a website where people can create a class or event with times and places for the class or event. Once this instance is created they are supplied a link for people to sign up and a passcode for them to use to modify the … | |
I have two different views in my ASP.Net application. I have a list view and a calendar view. I am trying to get the link to perform differently under certain circumstances. If the the class is full the link should be disabled and read class full. If there are available … | |
OK, here's my last problem for this project I am working on. This may seem very simple to most of you, but I cannot figure it out. I have a simple confirmation page that reads something like: You have successfully created your event, the link for people to signup for … | |
My code is not wroking to send out an email. I have 3 conditions that need to be met. managerEmailAddress and emailSentToManager only appear in the DB once. completeDate is in another table and it can appear several times. So basically if all items are complete and an email has … | |
I have a stored procedure where I need to insert from some other tables when those items do not exist in the original table. Here’s the stored procedure that I wrote. [CODE] ALTER PROCEDURE [dbo].[sp_CreateRequestedItems] AS BEGIN INSERT INTO dbo.RequestItems ([request], [applicationProfile]) --select from requests and profiles table into requestitems … | |
I need some help. I have a detailsview and it has several different fields in it. The fields I am having a problem with it the dropdownlist. I have two dropdownlist, one that is dependent on the other. That works fine. But now when I try to insert the selected … | |
I need help and I am not sure if this is even the right forum. I am new to n-tier programming. So I have developed a DAL using datasets, a BLL that is probably not very robust because I really do not know 100% what I am doing, and I … | |
I need help. I have a gridview that updates certain fields. Once those fields are updated a button is clicked and an email needs to be sent to different areas depending on certain conditions but only if there is an email address for that row. There could be only 2 … | |
I have a SQL query where I need to pull email addresses if there is one associated with that row in my table. Depending on how many email addresses are returned could be 1 all the way up to 5 I need to send an email to each of those … | |
Alright after working on a login page and completing it, the requirements for my project have changed. I am no longer using FormsAuthentication to see if someone is logged in. Instead I am putting a passcode as the query. If the passcode exists then I let them continue to the … | |
I have a dropdown that is bound to a database. Depending on the value that is selected information shows in a gridview below. Also depending on the selected value if a user clicks on a link they get redirected to another page. That is all working except when the page … | |
I have a detailsview where some items are bound to a database and other items are not. I have two textboxes with a calendar on each. One lets the user pick the start date and the other lets the user pick the end date. I also have to dropdown boxes, … | |
Hello, I have a detailsview control on my page with a template field for the date. I wanted a pop up calendar control to populate the date so I added that: [CODE]<asp:DetailsView ID="addEventDetailView" runat="server" Height="50px" Width="503px" DataSourceID="eventDataSource" AutoGenerateRows="False" DataKeyNames="eventAuid" DefaultMode="Insert" CellPadding="4" ForeColor="#333333" GridLines="None" OnItemInserting="addEventDetailView_ItemInserting" OnPageIndexChanging="addEventDetailView_PageIndexChanging" OnItemInserted="addEventDetailView_ItemInserted"> <FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" … | |
I have a gridview control where the last control is a hyperlink that allows someone to select that link and sign up for a class: [CODE]<asp:GridView ID="GridView1" runat="server" DataSourceID="SqlDataSource1" AutoGenerateColumns="False" OnSelectedIndexChanged="GridView1_SelectedIndexChanged" CellPadding="4" ForeColor="#333333" GridLines="None"> <RowStyle BackColor="#EFF3FB" /> <Columns> <asp:BoundField DataField="eventAuid" HeaderText="eventAuid" ReadOnly="True" SortExpression="eventAuid" InsertVisible="False" Visible="False" /> <asp:BoundField DataField="eventOccurrencesAuid" HeaderText="eventOccurrencesAuid" SortExpression="eventOccurrencesAuid" … | |
Hi...Someone please help. I have a web site that is based on information in a database. It is used to sign people up for events or classes. So an event is created, a link is provided with the query string for that event, then people can view the different times … | |
I need help. I have a SQL Server database that will store information for events that will be taking place. The sql database looks like (see attached). I am fairly new to programming so I need a lot of help, please. I need a web page that will allow a … | |
Hi, I have a question please I am using a DetailView to Insert into a SQL Server database. I then want to get the last identity id and use it at the end of url to redirect it to another page. I've done a lot of research and I think … | |
I need some help. I am currently creating an event caledar. First there is a web page that a person would input information for an event there were holding with the dates and times. This information would be stored in a SQL Server database. Then a link is given to … | |
Hello, I have a website that does calculations. I have a textbox that shows the results. I also have a button, and when I click this button I want it to add the results from the textbox into the array. I then have another button and I want to print … | |
Hello, I am used to VB.Net, and I recently starting using ASP.Net 2.0 with VB.Net. What I do not understand is how to keep my variables. Everytime the page goes back to the server I lose information. It gets lost. I've looked everywhere and read a lot of information and … | |
I have been using VB.Net for a little while now, but I just started needing to write code to put information in a SQL Server database. I have two tables that I need to add information into. I know that I have to use an Insert statement, maybe I need … | |
I am writing a program where I need to capitalize the first letter of each word in a text file. Example of information in the text file would be: this is the first line this is the second line this is the third line I have written a code that … ![]() |
The End.