Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
CODE PROJECT For Those Who Code
  • Home
  • Articles
  • FAQ
Community
R

Ragonastick

@Ragonastick
About
Posts
10
Topics
5
Shares
0
Groups
0
Followers
0
Following
0

Posts

Recent Best Controversial

  • Open new outlook windows with body of email dynamically filled [modified]
    R Ragonastick

    Found it out Here it is for anyone else that wants to know.

    Dim msgs As New MailMessage

                        msgs.To = SupervisorEmailGet()
                        msgs.From = "Payroll@server.ca"
                        msgs.Subject = NameTextBox.Text & " Hours for " & Session("date")
    
                        msgs.BodyFormat = MailFormat.Text
                        msgs.Body = "Employee: " & NameTextBox.Text & ControlChars.NewLine & "Department: " & DepartmentDropDownList.SelectedItem.Text & \_
                    ControlChars.NewLine & "Supervisor: " & SupervisorDropDownList.SelectedItem.Text & \_
                    ControlChars.NewLine & "The supervisor of " & NameTextBox.Text & " has viewed their time sheet." & \_
                    " You can view the employees hours at the website shown: http://ServerHostName/TimeSheet/NewTimeSheet.aspx?ID=" & intNewId
    
                        SmtpMail.SmtpServer = "ServerHostName.smtpname.ca"  
    
                        SmtpMail.Send(msgs)
                        msgs = Nothing
    

    ServerHostName = the name of the server hosting the website. smtpname = The smtp of the server. i.e. smtp.BELLNET.ca

    ASP.NET database sysadmin tutorial question

  • Open new outlook windows with body of email dynamically filled [modified]
    R Ragonastick

    Hi guys I am currently working on a web application where people can fill out information in a timesheet, and then it will store that information on a database, and then send a link to it to payroll by email. This is the current code that I have

    Dim msgs As New MailMessage

                        msgs.To = SupervisorEmailGet()
                        msgs.From = "Payroll@server.ca"
                        msgs.Subject = NameTextBox.Text & " Hours for " & Session("date")
    
                        msgs.BodyFormat = MailFormat.Text
                        msgs.Body = "Employee: " & NameTextBox.Text & ControlChars.NewLine & "Department: " & DepartmentDropDownList.SelectedItem.Text & \_
                    ControlChars.NewLine & "Supervisor: " & SupervisorDropDownList.SelectedItem.Text & \_
                    ControlChars.NewLine & "The supervisor of " & NameTextBox.Text & " has viewed their time sheet." & \_
                    " You can view the employees hours at the website shown: http://ServerHostName/TimeSheet/NewTimeSheet.aspx?ID=" & intNewId
    
                        SmtpMail.SmtpServer = "smtp.bellnet.ca"
    
                        SmtpMail.Send(msgs)
                        msgs = Nothing
    

    it works but the person I am working on it for wants the web app to open up their Microsoft Outlook 2007 with a new mail window(like a mailto:), but wants the information filled in dynamically through the program. The reason why they want to have a mail window is just because outlook runs locally, or if the person filling out the timesheet needs to change the body of the email. If anyone knows how to do that I would be happy or if you know how to get the code up top to run locally I would be more than satisfied with that.

    modified on Wednesday, May 27, 2009 4:03 PM

    ASP.NET database sysadmin tutorial question

  • ControlChars in a RequiredFieldValidator
    R Ragonastick

    I just found out how to do it.. apparently you can add some html code inside the error message text, and then within the style of that I was able to change the indenting of the paragraph tag. Here is a sample of my code.

    			<asp:requiredfieldvalidator id="RequiredFieldValidator1" style="Z-INDEX: 200; LEFT: 272px; BACKGROUND-IMAGE: url(file:///J:\\TimeSheet\\WebApplication1\\textbox.png); POSITION: absolute; TOP: 136px; p{text-indent: 20px}"
    			runat="server" Width="360px" Height="112px" BorderColor="Transparent" BackColor="Transparent" ErrorMessage="<br/><p><b>Invalid Name</b></P><p>You must input you full name.</p>"
    			ControlToValidate="NameTextBox" Display="Static"></asp:requiredfieldvalidator>
    
    ASP.NET

  • ControlChars in a RequiredFieldValidator
    R Ragonastick

    I am trying to create my own validator call out. I have a textbox, and when a person forgets to write something in it a RequiredFieldValidator will appear. The RequiredFieldValidator has a background image, and I am trying to get the text into a specific position on the image but it turns out that I am unable to use controlchars within the .text or .errormessage of the RequiredFieldValidator. If anyone does not have an Idea how to do this I will just add text to the image in photoshop but I was not looking on doing this with 50 images.

    ASP.NET

  • TextChange Event on a collection of textboxes [modified]
    R Ragonastick

    I have a collection of 50 textboxes. I was wounding if it is possible to run a TextChange Event on a collection of textboxes instead having to add each event handler in individually. The code behind is VB

    modified on Tuesday, March 24, 2009 12:02 PM

    ASP.NET

  • Using URL to link to a page, and load from a database using values in the URL
    R Ragonastick

    Thanks

    ASP.NET csharp database tutorial asp-net

  • Using URL to link to a page, and load from a database using values in the URL
    R Ragonastick

    Hi guys Before You read this I just wanted to inform you I am using Visual Studio 2003, VB.Net as the codebehind, and running asp.net 1.1 I am currently developing an asp.net webpage where a user can input data, and then it will save that data to a Microsoft SQL Server database. The table in this database that I am saving has an ID field which I use as the primary key. The next bit of information is when the data has been inputted, and submitted it will send an email to a person which would need to view the data. This email that I want to send is a link to the data which was inputted by the user. I was wondering if it is possible to send a link to someone with the ID field of the inputted data in the URL of the link, and then have that person be able to open the link and retrieve data from the database. Example www.MyHours.com\timesheet\ will load up a blank timesheet for the user(Lets say his name is John) to fill out. John fills out the data, and that row in the database which has an ID of 1235, Next an email is sent out to the person(lets call this person Mary) , and she needs to view the timesheet. The URL that is sent to here www.MyHours.com\timesheet\id=1235, Then Todd fills out the data, and a new row in the database is created with an ID of 1236, and another link is sent to Mary With the url www.MyHours.com\timesheet\id=1236 which she can then click on, and view the data Todd had inputted. If anyone knows how to do this or can just point me in the write direction on how to do this it would be greatly appreciated.

    ASP.NET csharp database tutorial asp-net

  • ASP.Net 1.1, VB.Net 2003 and SQL Server 2005
    R Ragonastick

    Thanks man I think you are correct. I am looking around but I think the guy that was working on this project before I started working on it did not write it down or leave any information on the password he left. Looks like I may have to reinstall, and back up the files.

    ASP.NET database csharp php asp-net

  • ASP.Net 1.1, VB.Net 2003 and SQL Server 2005
    R Ragonastick

    Odd the webconfig code did not show lets post that again

    <configuration>
    <appSettings>
    <add key ="DBConString" value="Uid=JWilson;pwd=;server=MCF1500\SQLEXPRESS;database=MCF_Staff" />
    </appSettings>
    <system.web>

    ASP.NET database csharp php asp-net

  • ASP.Net 1.1, VB.Net 2003 and SQL Server 2005
    R Ragonastick

    Hi I am new to programming with ASP.Net and I am looking for some information. I currently have a database locally on my machine, and I am trying to connect and read one of the tables through the VB. I have gone to many website, and tried a couple of things but I get up to a point and its still crashing when I go to open it. One thing you will notice is that I do not have a password on my database because there is not one on my machine. This is the code I have in my page load

    Dim oConn As New System.Data.SqlClient.SqlConnection
    Dim oCom As System.Data.SqlClient.SqlCommand
    Dim oDr As System.Data.SqlClient.SqlDataReader
    Dim sSQL As String

        sSQL = "SELECT \* FROM AdminTypes"
        oConn = New System.Data.SqlClient.SqlConnection("server=MCF1500\\SQLEXPRESS;uid=JWilson;pwd=;database=MCF\_Staff;Trusted\_Connection=yes")
        oConn.Open()   'Crashes HERE
    
        oCom = New System.Data.SqlClient.SqlCommand(sSQL, oConn)
    
        oDr = oCom.ExecuteReader()
    
        Do While oDr.Read()
            ' Show database data
        Loop
        oConn.Close()
    

    And I have this code in my WEB.config File

    I was wondering if anyone could help me out with his. If so it would be much appreciated. If not then I am switching over to PHP for this project because I understand it better.

    ASP.NET database csharp php asp-net
  • Login

  • Don't have an account? Register

  • Login or register to search.
  • First post
    Last post
0
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups