Conevert Datatable to Object Array C# ASP.Net / ASP MVC

Published on: 4:32 AM 0

We need to convert the Datatable dt to Array of objects StudentListResponse



 DataTable dt = new DataTable();
 SqlDataAdapter da = new SqlDataAdapter(command);
 da.Fill(dt);

            var list = dt.AsEnumerable()
.Skip(1)
.Select(dr =>
        new StudentListResponse
        {
            id = dr["PKStudentID"].ToString(),
            name = dr["StudentName"].ToString(),
            profile_pic = dr["PhotoURL"].ToString()
        }
        ).ToList();



            StudentListResponse[] students = list.ToArray();

Its very simple as explained in the previous post to convert Datatable to Object list. Just convert the list to Array as highlighted above.

Read More

Prepare web.config for HTML5 and CSS3 HTTP Error 404.3 - Not Found

Published on: 8:43 AM 0

HTTP Error 404.3 - Not Found
The page you are requesting cannot be served because of the extension configuration. If the page is a script, add a handler. If the file should be downloaded, add a MIME map.
The problem is that the IIS doesn’t know how to serve these new files unless we tell it how. This can be easily done in the web.config’s <system.webServer> section by adding the following snippet:

<staticContent>
    <mimeMap fileExtension=".mp4" mimeType="video/mp4" />
    <mimeMap fileExtension=".m4v" mimeType="video/m4v" />
    <mimeMap fileExtension=".ogg" mimeType="video/ogg" />
    <mimeMap fileExtension=".ogv" mimeType="video/ogg" />
    <mimeMap fileExtension=".webm" mimeType="video/webm" />

    <mimeMap fileExtension=".oga" mimeType="audio/ogg" />
    <mimeMap fileExtension=".spx" mimeType="audio/ogg" />

    <mimeMap fileExtension=".svg" mimeType="image/svg+xml" />
    <mimeMap fileExtension=".svgz" mimeType="image/svg+xml" />

    <remove fileExtension=".eot" />
    <mimeMap fileExtension=".eot" mimeType="application/vnd.ms-fontobject" />
    <mimeMap fileExtension=".otf" mimeType="font/otf" />
    <mimeMap fileExtension=".woff" mimeType="font/x-woff" />
</staticContent>

The above snippet incl

udes support for most video, audio and font file types used by HTML5 and CSS3.

Read More