ASP.NET

Re: Milliseconds from excel

16-May-22 21:35

That Trim call suggests you're treating the data as a String. You should parse it to the correct type (TimeSpan) before passing it to SQL.

Since your data is formatted for a culture which uses the comma as the decimal separator, you will need to ensure you use the correct CultureInfo when you parse the value.

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

kjell.ek16-May-22 23:15

kjell.ek

16-May-22 23:15

Thanks for the tip

Re: Milliseconds from excel

Raj Kumar7918-Oct-22 5:12

Raj Kumar79

18-Oct-22 5:12

Format 109 is like "Jun 17 2012 2:00:29:147PM", so obviously [Start Date] is varchar already before the convert.

I suspect that that problem is that Excel thinks that this is a datetime value, and that's why the milliseconds are lost in transport. Excel is not really the best venue for strict data-typing, but rather the drivers makes some guesswork. You could try to format the column as text, but I am not sure it would help.

I never use OPENROWSET/OPENDATASOURCE to read Excel files myself. For one-offs I save the file as a CSV and import it with BCP. For imports on regular basis, I would write a client program for the task. Many people would go for a soluton with Integration Services.

ASP.NET Gridview load data

Herman<T>.Instance28-Apr-22 3:16

28-Apr-22 3:16

Hi all,

where in the lifecycle of an asp.net page do you load the data for a gridview?
In Page_Load (which runs twice and check on !IsPostback is needed), in Page_LoadComplete (runs once) or in Page_Prerender (runs once)
I see better/smoother working of the pages when loading in Page_Loadcomplete event. How are your experiences?
I use Page_Prerender to set properties of a GridView other than DataSource and DataBind.

In Word you can only store 2 bytes. That is why I use Writer.

Richard Deeming28-Apr-22 4:40

28-Apr-22 4:40

Assuming you're using ASP.NET 4.5 or later, don't use any of the above. Instead, set the SelectMethod on the control to the name of a method in your code-behind which returns the data. The control will then take care of calling the method whenever necessary.

ScottGu's Blog - Web Forms Model Binding Part 1: Selecting Data (ASP.NET vNext Series)[^]
ScottGu's Blog - Web Forms Model Binding Part 2: Filtering Data (ASP.NET vNext Series)[^]

You can also use InsertMethod, UpdateMethod, and DeleteMethod to perform basic CRUD operations on the data.

ScottGu's Blog - Web Forms Model Binding Part 3: Updating and Validation (ASP.NET 4.5 Series)[^]

And from ASP.NET 4.6 onwards, you can make the SelectMethod a Task-returning async method as well.

Cool ASP.NET Web Forms Features in 2015 – Async Model Binding - .NET Blog[^]

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

Herman<T>.Instance2-May-22 0:47

2-May-22 0:47

This is a horrible suggestion. Only tested SelectMethod.
AJAX starts yelling about Registerscripts issues
GridView can't set styling anymore via my Library (Node isues ??)
And Async leads to exception it needs a return Task (which it is).

Back to my way

In Word you can only store 2 bytes. That is why I use Writer.

Dave Kreskowiak2-May-22 2:12

Dave Kreskowiak

2-May-22 2:12

So... yeah.

Don't show the code you tried, don't ask questions, don't describe any problems with proper detail, ...

Just bash the suggestion with summary judgement because it wasn't as simple to implement as you expected.

Sure.

Asking questions is a skill
CodeProject Forum Guidelines
Google: C# How to debug code
Seriously, go read these articles.

Dave Kreskowiak

Herman<T>.Instance2-May-22 3:23

2-May-22 3:23

Been working all weekend on it. Using the SelectMethod and Creating the method in codebehind is no problem. But when everything stays yelling except loading data I am done with it. Read enough on it. Have over 11,000 users of this site of mine and I am not gonna take risks.

Besides it is really strange that the SelectMethod in a page leads to a break in an UpdateProgress control in the masterpage. If I put that in comments, it is claiming for reducible nodes.

In Word you can only store 2 bytes. That is why I use Writer.

modified 2-May-22 10:14am.

Herman<T>.Instance3-May-22 4:46

3-May-22 4:46

And now in CODE
(used the ScottGu mentioned code in the link from first reply)
Created a clean asp.net 4.7.2 webforms project.
I have an ODATA service which is read via Unchase OData library
Index.Asp has the gridview:

ASP.NET

<asp:GridView runat="server" ID="GrdTest"
                AutoGenerateColumns="false" DataKeyNames="Id"
                ItemType="MarinGlobalService.Models.User"
                SelectMethod="GrdTest_GetData"
                >
                <Columns>
                    <asp:DynamicField DataField="Name" HeaderText="Name" />
                    <asp:DynamicField DataField="SurName" HeaderText="Surname"  />
                    <asp:DynamicField DataField="GivenName" HeaderText="GivenName"  />
                    <asp:TemplateField HeaderText="# of Usergroups">
                        <ItemTemplate><%# Item.UserGroup.Count %></ItemTemplate>
                    </asp:TemplateField>
                </Columns>
            </asp:GridView>

My codebehind:

namespace TestGridView
{
    public partial class Index : Page
    {

        private Default.Container container; // is for working with the OData Service

        protected void Page_Init(object sender, EventArgs e)
        {
            Uri uri = new Uri("<a href="http://localhost/api/global">http://localhost/api/global</a>");
            container = new Default.Container(uri)
            {
                Credentials = CredentialCache.DefaultNetworkCredentials,
                Timeout=3600
            };
        }
        protected void Page_LoadComplete(object sender, EventArgs e)
        {
            GrdTest.BackColor = System.Drawing.Color.LightGreen;
            GrdTest.AlternatingRowStyle.BackColor = System.Drawing.Color.LightBlue;
            GrdTest.RowStyle.BackColor = System.Drawing.Color.LightGray;
        }

        // The return type can be changed to IEnumerable, however to support
        // paging and sorting, the following parameters must be added:
        //     int maximumRows
        //     int startRowIndex
        //     out int totalRowCount
        //     string sortByExpression
        public IQueryable<User> GrdTest_GetData(int? maximumRows, int? startRowIndex)
        {
            if (maximumRows == null || startRowIndex == null)
                return container.Users;

            return container.Users.Skip(startRowIndex ?? 0).Take(maximumRows ?? 0);
        }
    }
}

This will lead to 1 gridview without paging and shows data.

Then I change my GridView to:

ASP.NET

<asp:GridView runat="server" ID="GrdTest"
                AutoGenerateColumns="false" DataKeyNames="Id"
                ItemType="MarinGlobalService.Models.User"
                SelectMethod="GrdTest_GetData"
                AllowPaging="true" PageSize="5"
                >
                <Columns>
                    <asp:DynamicField DataField="Name" HeaderText="Name" />
                    <asp:DynamicField DataField="SurName" HeaderText="Surname"  />
                    <asp:DynamicField DataField="GivenName" HeaderText="GivenName"  />
                    <asp:TemplateField HeaderText="# of Usergroups">
                        <ItemTemplate><%# Item.UserGroup.Count %></ItemTemplate>
                    </asp:TemplateField>
                </Columns>
            </asp:GridView>

And the answer is:

[ArgumentException: must be reducible node]
   System.Linq.Expressions.Expression.VisitChildren(ExpressionVisitor visitor) +97
   System.Linq.Expressions.ExpressionVisitor.VisitExtension(Expression node) +11
   System.Linq.Expressions.Expression.Accept(ExpressionVisitor visitor) +12
   System.Linq.Expressions.ExpressionVisitor.Visit(Expression node) +20
   System.Linq.Expressions.ExpressionVisitor.VisitArguments(IArgumentProvider nodes) +60
   System.Linq.Expressions.ExpressionVisitor.VisitMethodCall(MethodCallExpression node) +43
   System.Web.Util.OrderingMethodFinder.VisitMethodCall(MethodCallExpression node) +43
   System.Linq.Expressions.MethodCallExpression.Accept(ExpressionVisitor visitor) +12
   System.Linq.Expressions.ExpressionVisitor.Visit(Expression node) +20
   System.Linq.Expressions.ExpressionVisitor.VisitArguments(IArgumentProvider nodes) +60
   System.Linq.Expressions.ExpressionVisitor.VisitMethodCall(MethodCallExpression node) +43
   System.Web.Util.OrderingMethodFinder.VisitMethodCall(MethodCallExpression node) +43
   System.Linq.Expressions.MethodCallExpression.Accept(ExpressionVisitor visitor) +12
   System.Linq.Expressions.ExpressionVisitor.Visit(Expression node) +20
   System.Web.Util.OrderingMethodFinder.OrderMethodExists(Expression expression) +38
   System.Web.UI.WebControls.QueryableHelpers.IsOrderingMethodFound(IQueryable`1 queryable) +16

[TargetInvocationException: Exception has been thrown by the target of an invocation.]
   System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor) +0
   System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments) +168
   System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) +105
   System.Web.UI.WebControls.ModelDataSourceView.ProcessSelectMethodResult(DataSourceSelectArguments arguments, DataSourceSelectResultProcessingOptions selectResultProcessingOptions, ModelDataMethodResult result) +393
   System.Web.UI.WebControls.ModelDataSourceView.GetSelectMethodResult(DataSourceSelectArguments arguments) +86
   System.Web.UI.WebControls.ModelDataSourceView.ExecuteSelect(DataSourceSelectArguments arguments) +14
   System.Web.UI.DataSourceView.Select(DataSourceSelectArguments arguments, DataSourceViewSelectCallback callback) +17
   System.Web.UI.WebControls.ModelDataSourceView.Select(DataSourceSelectArguments arguments, DataSourceViewSelectCallback callback) +81
   System.Web.UI.WebControls.DataBoundControl.PerformSelect() +169
   System.Web.UI.WebControls.BaseDataBoundControl.DataBind() +71
   System.Web.UI.WebControls.GridView.DataBind() +5
   System.Web.UI.WebControls.BaseDataBoundControl.EnsureDataBound() +93
   System.Web.UI.WebControls.CompositeDataBoundControl.CreateChildControls() +72
   System.Web.UI.Control.EnsureChildControls() +116
   System.Web.UI.Control.PreRenderRecursiveInternal() +49
   System.Web.UI.Control.PreRenderRecursiveInternal() +236
   System.Web.UI.Control.PreRenderRecursiveInternal() +236
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +4719

So why does Scott Guthrie gets paging and doesn't it work for me? And what is this reducible node?

Changing the GrdTest_Getdata method to:

public IQueryable<User> GrdTest_GetData(int? maximumRows, int? startRowIndex, out int? totalRowCount, string sortByExpression)
        {
            // if (maximumRows == null || startRowIndex == null)
            var users = container.Users;
            totalRowCount = users.Count();
            return users;

<pre>
        //return container.Users.Skip(startRowIndex ?? 0).Take(maximumRows ?? 0).AsQueryable();
    }</pre>

will allow to have sortByExpression is set, but the collection does not get ordered by it.So AllowSorting will not give issues, only AllowPaging does.

In Word you can only store 2 bytes. That is why I use Writer.

modified 3-May-22 11:22am.

Richard Deeming3-May-22 5:31

3-May-22 5:31

Sorting needs to be applied before the paging.

In your first example, you've returned a page of unsorted records, and are then trying to sort them. That's the most likely cause of the error.

In your second example, you've defined the sorting parameter, so your code is responsible for sorting the data. The model binding won't try to sort the returned data again.

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

Herman<T>.Instance3-May-22 5:38

3-May-22 5:38

Even if I set in the GridView:

ASP.NET

AllowSorting="true" AllowPaging="true" PageSize="10"

Still I have

[ArgumentException: must be reducible node]
   System.Linq.Expressions.Expression.VisitChildren(ExpressionVisitor visitor) +97
   System.Linq.Expressions.ExpressionVisitor.VisitExtension(Expression node) +11
   System.Linq.Expressions.Expression.Accept(ExpressionVisitor visitor) +12
   System.Linq.Expressions.ExpressionVisitor.Visit(Expression node) +20
   System.Web.Util.OrderingMethodFinder.OrderMethodExists(Expression expression) +38
   System.Web.UI.WebControls.QueryableHelpers.IsOrderingMethodFound(IQueryable`1 queryable) +16

[TargetInvocationException: Exception has been thrown by the target of an invocation.]
   System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor) +0
   System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments) +168
   System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) +105
   System.Web.UI.WebControls.ModelDataSourceView.ProcessSelectMethodResult(DataSourceSelectArguments arguments, DataSourceSelectResultProcessingOptions selectResultProcessingOptions, ModelDataMethodResult result) +393
   System.Web.UI.WebControls.ModelDataSourceView.GetSelectMethodResult(DataSourceSelectArguments arguments) +86
   System.Web.UI.WebControls.ModelDataSourceView.ExecuteSelect(DataSourceSelectArguments arguments) +14
   System.Web.UI.DataSourceView.Select(DataSourceSelectArguments arguments, DataSourceViewSelectCallback callback) +17
   System.Web.UI.WebControls.ModelDataSourceView.Select(DataSourceSelectArguments arguments, DataSourceViewSelectCallback callback) +81
   System.Web.UI.WebControls.DataBoundControl.PerformSelect() +169
   System.Web.UI.WebControls.BaseDataBoundControl.DataBind() +71
   System.Web.UI.WebControls.GridView.DataBind() +5
   System.Web.UI.WebControls.BaseDataBoundControl.EnsureDataBound() +93
   System.Web.UI.WebControls.CompositeDataBoundControl.CreateChildControls() +72
   System.Web.UI.Control.EnsureChildControls() +116
   System.Web.UI.Control.PreRenderRecursiveInternal() +49
   System.Web.UI.Control.PreRenderRecursiveInternal() +236
   System.Web.UI.Control.PreRenderRecursiveInternal() +236
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +4719

Scott uses EF directly in his examples, I use OData service (which uses EF). Would that make the difference?
Where I work direct DB connections are not allowed. Scott says in his document that paging is done automatically and that EF is doing the right steps for you.

In Word you can only store 2 bytes. That is why I use Writer.

Richard Deeming3-May-22 5:48

3-May-22 5:48

It's almost certainly the OData service which is causing the problem.

Try turning off sorting and adding .OrderBy(x => x.Name) to see if you get the same error.

public IQueryable<User> GrdTest_GetData(int? maximumRows, int? startRowIndex)
{
    IQueryable<User> result = container.Users.OrderBy(x => x.Name);
    if (maximumRows != null && startRowIndex != null)
    {
        result = result.Skip(startRowIndex ?? 0).Take(maximumRows ?? 0);
    }
    
    return result;
}

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

Herman<T>.Instance3-May-22 7:12

3-May-22 7:12

Unfortunately the error stays....

Maybe some help: Expression.VisitChildren(ExpressionVisitor) Method (System.Linq.Expressions) | Microsoft Docs

In Word you can only store 2 bytes. That is why I use Writer.

modified 3-May-22 13:50pm.

Richard Deeming3-May-22 21:38

3-May-22 21:38

That just confirms that your OData service client doesn't support LINQ ordering.

I'm not familiar with the library you're using. Does it provide some other method to sort the results?

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

Herman<T>.Instance3-May-22 22:03

Send Email using Classic ASP

3-May-22 22:03

The Unchase OData client (UOC) creates the connection between the client (WebForm) and the OData service (over IIS). In IIS OData controllers send the data over the HTTPGet when requested. The UOC uses linq to translate the linq query to OData HTTP request.

The Reference.cs created by the UOC shows even the connections between tables in the DB over ODATA. What I now suspect is that the controller in the IIS does:

return db.Users.Where(x => !x.IsDeleted)

It is not using Include("UserGroups") to fill these nodes with data.
The linq query translates to requerst Uri:
http://localhost/api/global/Users?$orderby=Id

In Word you can only store 2 bytes. That is why I use Writer.

modified 4-May-22 4:23am.

Ram Teckchandani11-Apr-22 17:28

Ram Teckchandani

11-Apr-22 17:28

I am getting the error below
Microsoft VBScript compilation error '800a0408'

Invalid character

/AspClassic/mail.asp, line 24

objMail.Configuration.Fields.Item("http://schemas.microsoft.com/cdo/configuration/sendusername") = teckchandanirp@gmail.com

my code is as below, what am I doing wrong

<%@LANGUAGE="VBSCRIPT"%>

<%
'Step 1: create an object of CDO.Message
dim objMail
Set objMail = Server.CreateObject("CDO.Message")

'Step 2: set the smtp server, user name and password for authentication
dim smtpServer, yourEmail, yourPassword
smtpServer = "smtp.gmail.com"
yourEmail = "teckchandanirp@gmail.com" 'replace with a valid gmail account
yourPassword = "32233223" 'replace with a valid password for the gmail account set in yourEmail

'Step 4: set the email address to which email will be sent
sendEmailTo = "teckchandanirp@gmail.com"

'Step 5: set the configuration properties of objMail object
objMail.Configuration.Fields.Item("http://schemas.microsoft.com/cdo/configuration/sendusing") = 2
objMail.Configuration.Fields.Item("http://schemas.microsoft.com/cdo/configuration/smtpserver") = smtp.gmail.com
objMail.Configuration.Fields.Item("http://schemas.microsoft.com/cdo/configuration/smtpauthenticate") = 1
objMail.Configuration.Fields.Item("http://schemas.microsoft.com/cdo/configuration/smtpserverport") = 465
objMail.Configuration.Fields.Item("http://schemas.microsoft.com/cdo/configuration/smtpusessl") = true
objMail.Configuration.Fields.Item("http://schemas.microsoft.com/cdo/configuration/sendusername") = teckchandanirp@gmail.com
objMail.Configuration.Fields.Item("http://schemas.microsoft.com/cdo/configuration/sendpassword") = 32233223
objMail.Configuration.Fields.Item("http://schemas.microsoft.com/cdo/configuration/smtpconnectiontimeout") = 60

'Step 6: update the configuration after setting all the required items
objMail.Configuration.Fields.Update

'Step 7: prepare your email like set subject, body, from, to etc.
objMail.From = teckchandanirp@gmail.com
objMail.To = teckchandanirp@gmail.com

objMail.Subject="Application Form Registration Details"
objMail.htmlBody = "This is test message"

'Step 8: send the email
objMail.Send

Re: Send Email using Classic ASP

Richard MacCutchan11-Apr-22 22:00

Richard MacCutchan

11-Apr-22 22:00

objMail.Configuration.Fields.Item("http://schemas.microsoft.com/cdo/configuration/sendusername") = teckchandanirp@gmail.com

You need to put double quote characters around string constants, thus:

objMail.Configuration.Fields.Item("http://schemas.microsoft.com/cdo/configuration/sendusername") = "teckchandanirp@gmail.com"

MVC 5 Prevent Users From Going Back After Logging In or Out Using Identity Framework

Steven Petersen3-Apr-22 9:11

Steven Petersen

3-Apr-22 9:11

I am building an app using MVC 5 and I ran into a common issue that has been asked over and over but I can't seem to find the right answer using .NET Identity. Once the user logs in, they should not be able to go back to the login page and the same is true when they log out they should not be able to go back to a restricted page.

The problem that I'm having is that if a user does not enter the correct password and the server catches the error then I successfully login I am able to go back to the login page. If I login on the first try it works like it should. How can I correct this problem?

The other problem that I'm having is when the user logs out, Is there any way without using javascript to not allow the user to access the restricted pages by using the back button?

I have included

filters.Add(new System.Web.Mvc.AuthorizeAttribute());

My controller looks like this:

[AllowAnonymous]
    [OutputCache(NoStore = true, Location = OutputCacheLocation.None)]
    public ActionResult Login(string returnUrl)
    {
        if (User.Identity.IsAuthenticated)
        {
            return RedirectToAction("Dashboard", "App");
        }
        ViewBag.ReturnUrl = returnUrl;
        return View();
    }

    //
    // POST: /Account/Login
    [HttpPost]
    [AllowAnonymous]
    [ValidateAntiForgeryToken]
    public async Task<ActionResult> Login(LoginViewModel model, string returnUrl)
    {
        if (!ModelState.IsValid)
        {
            return View(model);
        }

        // Require the user to have a confirmed email before they can log on.
        var user = await UserManager.FindByNameAsync(model.Email);
        if (user != null)
        {
            if (!await UserManager.IsEmailConfirmedAsync(user.Id))
            {
                string callbackUrl = await SendEmailConfirmationTokenAsync(user.Id, "Confirm your account-Resend");
                ViewBag.errorMessage = "You must have a confirmed email to log on.";
                return View("Error");
            }
        }

        // This doesn't count login failures towards account lockout
        // To enable password failures to trigger account lockout, change to shouldLockout: true
        var result = await SignInManager.PasswordSignInAsync(model.Email, model.Password, model.RememberMe, shouldLockout: false);
        switch (result)
        {
            case SignInStatus.Success:
                return RedirectToAction("Dashboard","App");
            case SignInStatus.LockedOut:
                return View("Lockout");
            case SignInStatus.RequiresVerification:
                return RedirectToAction("SendCode", new { ReturnUrl = returnUrl, RememberMe = model.RememberMe });
            case SignInStatus.Failure:
            default:
                ModelState.AddModelError("", "Invalid login attempt.");
                return View(model);
        }
    }

My Logout Controller is:

// POST: /Account/LogOff
    [HttpPost]
    [ValidateAntiForgeryToken]
    public ActionResult LogOff()
    {
        AuthenticationManager.SignOut(DefaultAuthenticationTypes.ApplicationCookie);
        return RedirectToAction("Index", "Home");
    }

I didn't add anything special to my view. How do I prevent the logged in user from going back to the login page which they can do if they have an error. and how can I prevent the user from going back after logout and seeing a restricted page. What I really want to know is if there is any way to do this with Identity?

I know the issue is caching in the browser that allows the user to go back. I've cleared the cache when I logout, I used the

[OutputCache(NoStore = true, Location = OutputCacheLocation.None)]

I do not want to disable cashing for the whole app (performance issues) and I do not want to use javascript (since it can be disabled by the user). Is there any other way to do it?

I know this question has been asked a million times but I haven't really found a definitive answer that works on all browsers.

Re: MVC 5 Prevent Users From Going Back After Logging In or Out Using Identity Framework

Richard Deeming3-Apr-22 21:24