Hi Experts,

This is my program. I am using some private variable to hold the values. Then I am using them through out the program. I want to know is it the right way to do or I should keep them in the session variable and use them. I am curious to know that when many people access the same web page are these variables going to create problem or change the values.  I am using ASP.net and VB.net.

Thanks in advance.


Partial Class EditCustomerOrder
    Inherits System.Web.UI.Page
    Private Shared Calling_Form As String
    Private Shared CustomerID As Integer
    Private Shared LocationID As Integer
    Private Shared MenuOrderDate As DateTime
   
    Protected Sub Page_Load(sender As Object, e As EventArgs) Handles Me.Load
        If Not IsPostBack Then
            Calling_Form = Request.QueryString("Calling_Form")
       
            If Session("EditCustOrder_Calling_Form") Is Nothing = False Then
                Calling_Form = Session("EditCustOrder_Calling_Form")
            Else
                Calling_Form = Request.QueryString("Calling_Form")
            End If

            If Session("EditCustOrder_MenuOrderDate") Is Nothing = False Then
                MenuOrderDate = Session("EditCustOrder_MenuOrderDate")
            Else
                MenuOrderDate = Request.QueryString("MenuDate")
            End If

I am using lotus notes to send email in .net application using c#. I am able to send mails from this application while i run this in my local host. But the thing is when host the application in local IIS server i am not able to send mails.
 I am getting the following error.
Notes error: Notes shared login failed with this ID file.
Please tell me why i am getting this error after hosting the application.

OK, so I developed a program that has a green progress bar that turns purple when filling...however when you RDS into a Server 2012 Server it is Gray and fills with Green?

Why?

Thanks,
Mark

Hi

Is it possible to call a function (in eg Module1) in an Excel cell?

I need to copy a table from the main Access database and insert it into another database that is located in a different folder. I am programming in VB.Net. Below is the code I am trying. It gives me an error message at the "cmd.ExecuteNonQuery()" statement.

The error says:  {"Query input must contain at least one table or query."}. I have a database at the external folder location called AssetDatabase.accdb into which I want the table copied. What am I doing in correctly? Is the syntax wrong?

cmd = New OleDbCommand("Select * INTO  [tblAssetData-" & CompanyName & "] IN C:\Users\rkvjr\Documents\Backup\AssetDatabase.accdb FROM tblAssetData", objcon.con)
cmd.ExecuteNonQuery()
 

Select all Open in new window

Is there a way to programmatically convert a text file to an excel spreadsheet?

Hi,

I have a form form1 with a datagrid. But i call a second form form2 to made a query, to return only some records. I need to return a datatable to form1 and automatically fill a datagrid.
What is the best way to return a datatable from form2 to form1.

best regards

I cannot seem to get FedEx Tracking API to work at all.

I reviewed the API and have been trying to get the examples to run.  However when I try todo this I get a lot of errors.  I am trying to build a simple Package Tracking page but the FedEx API is not documented in a way that I can use.

Any help would be great!  

When using the FedEx example code when i run the application i get this error.

An unhandled exception of type 'System.InvalidOperationException' occurred in System.Xml.dll

Additional information: Unable to generate a temporary class (result=1).

error CS0029: Cannot implicitly convert type 'TrackWebServiceClient.TrackServiceWebReference.NotificationEventType' to 'TrackWebServiceClient.TrackServiceWebReference.NotificationEventType[]'

Hey I am really struggling with this one. I can use a comma delimited file with no problem in my vb.net application I am building. But when I try to use a tab delimited file all I get is one column. The comma delimited worked. The rest did not. Can anyone tell me what I am doing wrong????

Dim Delimiter As String = ""
        If Me.cbDelimiter.Text = "," Then
            CSVConn.ConnectionString = ("Provider=Microsoft.Jet.OleDb.4.0; Data Source = " + Path.GetDirectoryName(FileName) + "; Extended Properties = ""Text;HDR=YES;FMT=Delimited""")
        End If
        If Me.cbDelimiter.Text = "|" Then
            CSVConn.ConnectionString = ("Provider=Microsoft.Jet.OleDb.4.0; Data Source = " + Path.GetDirectoryName(FileName) + "; Extended Properties=""text;HDR=YES;FMT=Delimited(|OrdersTAB.txtOrdersTAB.txt)""")
            ' Delimiter = "FMT=Delimited(|)"
        End If
        If Me.cbDelimiter.Text = "Tab" Then
            '= "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\MyDir;Extended Properties='text;HDR=YES;FMT=CSVDelimited;'; "
            'CSVConn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Path.GetDirectoryName(FileName) + ";Extended Properties='text;HDR=YES;FMT=Delimited;'; "
            'CSVConn.ConnectionString = ("Provider=Microsoft.Jet.OleDb.4.0; Data Source = " + Path.GetDirectoryName(FileName) + "; Extended Properties=""text;HDR=YES;FMT=TabDelimited""")
            '  Delimiter = "FMT=TabDelimited"
           …

I had this question after viewing VB .Net - web browser control.  Automate clicking on and manipulating popup windows after downloading .exe file.

Basically, I am trying to do almost the same thing but I don't want to wait for the "Choose File to Upload" window to load. Instead, I'd like to:

1) Wait till the window becomes available
2) Automatically hide the window and send it back once it becomes available by intercepting the opening of that window
3) Set the file location to the file upload window in the background
4) Once set, click the "Open" button (like how it is being done now)

Could someone please provide some code on this scenario as I really need to get this working.

Cheers.

I have a problem serialializing xml

I do not get all 3 values of 'liggingen' back in the object. I only get the first value. I tried to make a list, but no success.
What is the error in the user defined object?

This is part of the user defined object

Public Class MatenEnLigging
        Public Liggingen As Liggingen
        Public Inhoud As Integer
        Public Oppervlakte As Integer
End Class

Public Class Liggingen
        Public Ligging As String
End Class

And this is part of the XML
<MatenEnLigging>
	<Liggingen>
        	<Ligging>aan bosrand</Ligging>
            	<Ligging>aan rustige weg</Ligging>
	        <Ligging>beschutte ligging</Ligging>
         </Liggingen>
	 <Inhoud>519</Inhoud>
	<Oppervlakte>150</Inhoud>
</MatenEnLigging>

Select all Open in new window

Hi,

How can I set a variable in JavaScript on an ASPX page but also have the contents available in the VB.NET code behind? This is for an ASP.NET 4 and VB.NET

I can set the variable in the JavaScript but it's not available in the code behind.

I can set it something like this:

 function SetUserName() {
            var myvar = document.getElementById('<%= TextBox1.ClientID %>').value
            '<%Session("LastName") = "' + myvar + '" %>';
            alert('<%=Session("LastName") %>');
        }

Select all Open in new window

But when I try to get it from the code behind using like an Intermediate window I get like:

Session("LastName")  I like "' + myvar + '"

The alert is above in the javascript is showing the right thing. But that setting it apparently only happening on the ClientSide. How do/can I get it to happen on the client side but also on the server side or can I? Is this where Ajax come into play?

If so, how would something like that be done?

Any information would be greatly appreciated.

I am doing CSV upload on Asp.net and its taking more than 1 hour to upload, So I has set sessiontimeout as 2 hour, I have set time out in below places:
1) In web.config :<sessionState timeout="120"></sessionState>
2) In web.config: <httpRuntime maxRequestLength="1048576" executionTimeout="7200" />
3) In .aspx page :     <asp:ScriptManager ID="scrpt1" runat="server" AsyncPostBackTimeout="7200">
                            </asp:ScriptManager>
4) In IIS: Application Pool have sesstion timeout as 120min
5) In IIS: In Website Advance setting set session timeout as 120 min.

   Still my page get blank after 1 hour and If i try to refresh then it shows Session Timeout, However my CSV Upload continue to work on database and it completes all upload in database in 2hour but Page get expired. Please help asap.

   FYI I am using IIS 7 on Windows server 2008 machine.

Regards,
Sudhanshu