I see no line numbers when viewing errors in browser Using VS 2003 VB.net View the project in a browser and there is a error, I do not see the line numbers and line of code causing the error. I do have the line numbers visible in the code behind and HTML. I use to get the line numbers when testing and getting errors. Need help trying to get the line numbers back and the code line: below is an example of all I get now: Cast from string "" to type 'Date' is not valid. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.InvalidCastException: Cast from string "" to type 'Date' is not valid. Source Error: An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. Stack Trace: [InvalidCastException: Cast from string "" to type 'Date' is not valid.] Microsoft.VisualBasic.CompilerServices.DateType.FromString(String Value, CultureInfo culture) Microsoft.VisualBasic.CompilerServices.DateType.FromString(String Value) COMS.FieldReports.grdFieldReport_Update(Object sender, DataGridCommandEventArgs e) System.Web.UI.WebControls.DataGrid.OnUpdateCommand(DataGridCommandEventArgs e) System.Web.UI.WebControls.DataGrid.OnBubbleEvent(Object source, EventArgs e) System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) System.Web.UI.WebControls.DataGridItem.OnBubbleEvent(Object source, EventArgs e) System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) System.Web.UI.WebControls.LinkButton.OnCommand(CommandEventArgs e) System.Web.UI.WebControls.LinkButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) System.Web.UI.Page.ProcessRequestMain()

VS 2003, sql server I get the following error: DataBinder.Eval: 'System.Data.DataRowView' does not contain a property with the name LastDate. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Web.HttpException: DataBinder.Eval: 'System.Data.DataRowView' does not contain a property with the name LastDate. Source Error: Line 73: <%# DataBinder.Eval(Container.DataItem,"LastDate","{0:MM/dd/yyyy}") %> My view is as follows: CREATE VIEW dbo.vFieldReport AS SELECT dbo.Borrower.BName, dbo.FieldReports.CIF, dbo.FieldReports.FRID, dbo.FieldReports.LastDate, dbo.FieldReports.DueDate, dbo.FieldReports.Overide, dbo.FieldReports.NewDueDate, dbo.FieldReports.Freq, dbo.FieldReports.DepthLevel, dbo.FieldReports.OrderDate, dbo.FieldReports.comments, dbo.FieldReports.RiskRating, dbo.FieldReports.UCSClass, dbo.Loans.LoanNo FROM dbo.Borrower INNER JOIN dbo.FieldReports ON dbo.Borrower.CIF = dbo.FieldReports.CIF CROSS JOIN dbo.Loans My FieldReports Table is as follows: Column Name Data Type Length Allow Nulls LastDate dateTime 8 Yes Here is the whole error code: Server Error in '/COMS' Application. -------------------------------------------------------------------------------- DataBinder.Eval: 'System.Data.DataRowView' does not contain a property with the name LastDate. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Web.HttpException: DataBinder.Eval: 'System.Data.DataRowView' does not contain a property with the name LastDate. Source Error: Line 71: Line 72: Line 73: <%# DataBinder.Eval(Container.DataItem,"LastDate","{0:MM/dd/yyyy}") %> Line 74: Line 75: Source File: c:\inetpub\wwwroot\COMS\FieldReport.aspx Line: 73 Stack Trace: [HttpException (0x80004005): DataBinder.Eval: 'System.Data.DataRowView' does not contain a property with the name LastDate.] System.Web.UI.DataBinder.GetPropertyValue(Obj

In my VS2003 project I send mail and it sends 7-8 times every time I send it? I have the following code in my global.asax code, The problem is the receiver gets 7-8 copies every time i SEND IT? Public Class Global Inherits System.Web.HttpApplication #Region " Component Designer Generated Code " Public Sub New() MyBase.New() 'This call is required by the Component Designer. InitializeComponent() 'Add any initialization after the InitializeComponent() call End Sub 'Required by the Component Designer Private components As System.ComponentModel.IContainer Private Sub InitializeComponent() components = New System.ComponentModel.Container() End Sub #End Region Sub Application_Start(ByVal sender As Object, ByVal e As EventArgs) ' Fires when the application is started '1. Create a connection Dim myConnection As New SqlConnection(ConfigurationSettings.AppSettings("connectionString")) myConnection.Open() '2. Create the command object, for the query Const strSQL As String = "Select LastUpdated, ProductId from products " Dim objCmd As New SqlCommand(strSQL, myConnection) Dim objDR As SqlDataReader Dim att objDR = objCmd.ExecuteReader() While (objDR.Read) If (Not (objDR("LastUpdated") Is DBNull.Value)) Then If (Date.Compare(objDR("LastUpdated"), Today.Date) = 0) Then Dim newMail As New MailMessage newMail.From = "zzzxyz@msn.com" '' this is the From Address newMail.To = "bill@msn.com" '' this is TO Address 'newMail.Cc = "ken@dtyinc.net" '' this is TO Address newMail.Subject = "Change in Product Rate" newMail.Body = " Dear Ken, " & "Please review attached document for product ID: " & objDR("ProductID") & "Thank you," & "Kenn()" att = New MailAttachment("C:\Inetpub\wwwroot\GrocerToGo\Product_Changed.doc") newMail.Attachments.Add(att) newMail.Fields.Add("http://schemas.microsoft.com/cdo/configuration/smtpauthenticate", "1") newMail.Fields.Add("http://schemas.microsoft.com/cdo/configuration/sendusername", "bill@dtyinc.net") newMail.Fields.Add("

In my Global asax file aDo I need the code below newmail.fields.add and why do I need them? The first one works but it puts my password in the code. I am using IIS smtp mail and VS 2003 Also noted below, I have an outlook email account (the first one below password and name changed ) and a msn.com email account The outlook email account works but the msn account does not? newMail.Fields.Add("http://schemas.microsoft.com/cdo/configuration/smtpauthenticate", "1") 'newMail.Fields.Add("http://schemas.microsoft.com/cdo/configuration/sendusername", "kenn@dtyinc.net") 'newMail.Fields.Add("http://schemas.microsoft.com/cdo/configuration/sendpassword", "Password") 'SmtpMail.SmtpServer = "mailserver" SmtpMail.SmtpServer = "" newMail.Fields.Add("http://schemas.microsoft.com/cdo/configuration/smtpauthenticate", "1") 'newMail.Fields.Add("http://schemas.microsoft.com/cdo/configuration/sendusername", "kenn@msn.com") 'newMail.Fields.Add("http://schemas.microsoft.com/cdo/configuration/sendpassword", "welcome") 'SmtpMail.SmtpServer = "mailserver" SmtpMail.SmtpServer = ""

Sorry: To further clarify My database table name is borrower and two of the fields are BName and TaxID, I am trying to select a particular borrower (BName) with a taxid OF 767, lets say in this case THE BORROWER IS Bill Jones I declared the following variables: Dim strName As String Dim parameterBName As SqlParameter = New SqlParameter("@BName", SqlDbType.VarChar, 50) parameterBName.Value = strName myCommand.Parameters.Add(parameterBName) Dim strTaxID As String Dim ParameterTaxID As SqlParameter = New SqlParameter("@TaxID", SqlDbType.VarChar, 15) ParameterTaxID.Value = strTaxID myCommand.Parameters.Add(ParameterTaxID) I inserted the folowing command: Dim strSql As String = "select BName from Borrower where TaxID= @333-00-1492 " I get error: Must declare the variable '@333'.

In Code Behind, What is proper select statement syntax to retrieve the @BName field from a table? Using Visual Studio 2003 SQL Server DB I created the following parameter: Dim strName As String Dim parameterBName As SqlParameter = New SqlParameter("@BName", SqlDbType.VarChar, 50) parameterBName.Value = strName myCommand.Parameters.Add(parameterBName) I tried the following but get error: Dim strSql As String = "select @BName from Borrower where BName= DOROTHY V FOWLER " error is: Line 1: Incorrect syntax near 'V'. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.SqlClient.SqlException: Line 1: Incorrect syntax near 'V'. Source Error: Line 59: Line 60: Line 61: myCommand.ExecuteNonQuery() 'Execute the query

How do I incorporate a VS project word document using VS tools for office into an existing VS project? I have completed a tutorial at: http://aspnet.4guysfromrolla.com/articles/071002-1.2.aspx This tutorial called "Grocer To Go", creates project that allows you to update fields in a database I have created another visual studio project that created a word document with bookmarked fields. The bookmarked fields will be where I want the updates to be entered.Is there a way that this document can be incorporated into my "Grocer To Go" project the bookmarks be populated with the updtaed data? I have googled and cannot find any references to help me accomplish this task.

It is a word document that is being populated. I was just wondering how they figure out how many charactres are in the document. It is a template document

VB.net I am trying to learn how to write a document and saw this code below: How do they figure out the number of characters? Number of characters with spaces? WriteLine("326") WriteLine("382")

What does the @ do in the following statement? Is this used to pick the particular DB field associated with the row in the update statement? Dim strSQL As String = _ "UPDATE [Products] SET [ProductName] = @ProdName, " & _ "[UnitPrice] = @UnitPrice, [ProductDescription] = @ProdDesc, [LastUpdated] = @LastUpdated " & _ "WHERE [ProductID] = @ProductID"

I am using visual studio.net, vb.net sql server msde I am sending an email asking a question with a Y/N answer Is it possible to button click Y/N in an email and change a db field Is it possible to click a button in an email and have that change a field in a database? Example: I want to send an email to a customer and ask them if they are over the age of 30 Y/N? Can the Y/N value be returned in an email and automatically change the db field to Y or N?

How to create a document template and add ddb data using visual studio tools for office I am using visual studio 2003 installed vsto TOOLS FOR OFFICE MSDE Windows Xp VSTO 2003 NorthWind database: customers table: CompanyName ContactName orders: OrderDate ShippedDate I am trying to learn how to use tools for office using the northwind database. I am trying to populate NorthWind db data on to an existing word document template that can be saved then re-used : I cannot find any tutorial that shows how to perform this. MSDN does not show this msdn showes how to Example: (where there are ______ I want to have a database field auto-populate) _________ (Northwind db field: CompanyName) Dear Mr. _______ (Northwind db field = ContactName) Todays Date:_______ Your order has been received as of: _________(Northwind db field = orderDate) Thankyou for your order Blah blah blah blah blah blah Blah blah blah blah blah blah Blah blah blah blah blah blah Blah blah blah blah blah blah Blah blah blah blah blah blah Blah blah blah blah blah blah Blah blah blah blah blah blah Blah blah blah blah blah blah Your order has been shipped on _______(Northwind db field: shippedDate) sincerly, Bud Light Year

Email will not send my visual studio 2003 project 1. I am using MSDE, IIS, Visual studio 2003, 1.1 netframework, I have mail Outlook and msn homail, 2. these are installed on windows xp 3. Can I send email if I only have msde and not a regular server? 4. The project works except the sending of the email 5. I thought I have coded below correctly, but I do not receive emails Sub Application_Start(ByVal sender As Object, ByVal e As EventArgs) ' Fires when the application is started '1. Create a connection Dim myConnection As New SqlConnection(ConfigurationSettings.AppSettings("connectionString")) myConnection.Open() '2. Create the command object, for the query Const strSQL As String = "Select LastUpdated, ProductId from products " Dim objCmd As New SqlCommand(strSQL, myConnection) Dim objDR As SqlDataReader Dim att objDR = objCmd.ExecuteReader() While (objDR.Read) If (Not (objDR("LastUpdated") Is DBNull.Value)) Then If (Date.Compare(objDR("LastUpdated"), Today.Date) = 0) Then Dim newMail As New MailMessage newMail.From = "from@from.com" '' this is the From Address newMail.To = "kenn_rosie@msn.com" '' this is TO Address 'newMail.Cc = "hadeedian@hotmail.com" '' this is TO Address newMail.Subject = "Change in Product Rate" newMail.Body = " Dear Ken, " & "Please review attached email for product ID: " & objDR("ProductID") & "Thank you," & "Kenn()" att = New MailAttachment("C:\Inetpub\wwwroot\GrocerToGo\Product_Changed.doc") newMail.Attachments.Add(att) newMail.Fields.Add("http://schemas.microsoft.com/cdo/configuration/smtpauthenticate", "1") newMail.Fields.Add("http://schemas.microsoft.com/cdo/configuration/sendusername", "username") newMail.Fields.Add("http://schemas.microsoft.com/cdo/configuration/sendpassword", "password") SmtpMail.SmtpServer = "mailserver" SmtpMail.Send(newMail) End If End If End While myConnection.Close() 'Close the connection End Sub

hmm, so How do I get it to work to send out email without restarting IIS, That seems strange? If I want the email to go out daily, do I need to have a trigger or something to restart IIS all the time?

Not quite sure what that means.... example, in my code I updated a db field that was placed in a word document, then I have the sub application_start send it email. I did that earlier today but have not received the email back yet, so I was wondering if I have to write code that causes the sub application_start to start?

I have built the following code in my global.asax code My question is how and when does the Sub application_start know when to start? What must I do to trigger it to start and send an email? Sub Application_Start(ByVal sender As Object, ByVal e As EventArgs) ' Fires when the application is started Dim myConnection As New SqlConnection(ConfigurationSettings.AppSettings("connectionString")) myConnection.Open() '2. Create the command object, for the query Const strSQL As String = "Select LastUpdated, ProductId from products " Dim objCmd As New SqlCommand(strSQL, myConnection) Dim objDR As SqlDataReader objDR = objCmd.ExecuteReader() While (objDR.Read) 'look the code is looking for DATETIME .. but it found NULL values 'need this code to keep from getting errors if a null is found 'we need to put some check for nulls If (Not (objDR("LastUpdated") Is DBNull.Value)) Then If (Date.Compare(objDR("LastUpdated"), Today.Date) = 0) Then Dim newMail As New MailMessage newMail.From = "from@from.com" '' this is the From Address newMail.To = "kenn_rosie@msn.com" '' this is TO Address newMail.Subject = "Change in Product Rate" newMail.Body = " Dear Ken, " & _ "Please review attached email for product ID: " & objDR("ProductID") & _ "Thank you," & _ "Kenn()" End If End If End While myConnection.Close() 'Close the connection End Sub

Thanks, I found it, I expanded mscorlib and there it was

I was trying to drill down to it in visual studio but It does not drill down very far in system.io for visual studio. Unless I am doing something wrong?

I am new at vb.net and would like to know What object is streamwriter located under? Is it a function or sub routine? VS 2003: I have a project with the folowing in code behind: Dim sw As StreamWriter I thought maybe I could drill down in the objects and find it. I assume that is under System.IO? I did an Ctrl ALT J in visual studio to look at the classes and I cannot drill down to streamWriter? Where can I find where streamwriter is located?

How can I auto-populate two MS Word document fields (customer name) and (address) From the Northwind database Example: MS Word Document: New customer Information This is to inform you Mr. _________(customer name) has a new address of _______ (address) Here is my scenario: User logs in to web page and updates a record for the customer’s new address, which will be stored in the customers table of the Northwind database. User wants to print the above word document: New Customer Information which will contain the updated data I have visual studio 2003, and Visual studio tools for office