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

Published on: 4:27 AM 1

  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();



Here dt is the DataTable Holds data.
And StudentListResponse object list is created.

Read More

Android Studio - Rendering Problems The following classes could not be instantiated: - android.support.v7.internal.widget.ActionBarOverlayLayout

Published on: 3:23 AM 0

Fix res/values/styles.xml  :

<style name="AppTheme" parent="Base.Theme.AppCompat.Light.DarkActionBar"/>

Detailed explanation as requested: Theme.AppCompat.Light.DarkActionBar is a subclass of the superclass Base anyway.

Read More

Android studio Error occurred during initialization of VM Could not reserve enough space for object heap Error: Could not create the Java Virtual Machine. Error: A fatal exception has occurred. Program will exit.

Published on: 2:46 AM 0

 Android studio Error occurred during initialization of VM Could not reserve enough space for object heap Error: Could not create the Java Virtual Machine. Error: A fatal exception has occurred. Program will exit.

 

For Android Studio 1.3 : (Method 1)

Step 1 : Open gradle.properties file in your Android Studio project.

Step 2 : Add this line at the end of the file

org.gradle.jvmargs=-XX\:MaxHeapSize\=256m -Xmx256m

Above methods seems to work but if in case it won't then do this (Method 2)

Step 1 : Start Android studio and close any open project (File > Close Project).

Step 2 : On Welcome window, Go to Configure > Settings.

Step 3 : Go to Build, Execution, Deployment > Compiler

Step 4 : Change Build process heap size (Mbytes) to 1024 and Additional build process to VM Options to -Xmx512m.

Step 5 : Close or Restart Android Studio.

Read More

Full screen Overlay using CSS only- CSS Only Modal Popup

Published on: 11:11 PM 0

Full screen Overlay Effects 

When you search for a solution for fullscreen overlay, most website provide solutions using JavaScript or jQuery. The following solution is using only CSS and not using any JavaScript of jQuery. Here we are going to create a pop-up window that overlays an existing html page and disabling all links and bringing into focus on the pop up window.






 Sometimes you need your entire browser window with a black tint in the background and make a popup at the center of the screen. Normally this technique is used for displaying a login window without moving from existing page or displaying a video, when a user clicks on a link or button in a web page.



Add this to your Page

 <style>
        .button {
            width: 150px;
            padding: 10px;
            background-color: #2d57f8;
            box-shadow: -8px 8px 10px 3px rgba(0,0,0,0.2);
            font-weight: bold;
            text-decoration: none;
        }

        #cover {
            position: fixed;
            top: 0;
            left: 0;
            background: rgba(0,0,0,0.6);
            z-index: 5;
            width: 100%;
            height: 100%;
            display: none;
        }

        #popupScreen {
            height: 380px;
            width: 340px;
            margin: 0 auto;
            position: relative;
            z-index: 10;
            display: none;
            background: url(login.png) no-repeat;
            border: 5px solid #cccccc;
            border-radius: 10px;
            background-color:rgb(245,245,245);
        }

            #popupScreen:target, #popupScreen:target + #cover {
                display: block;
                opacity: 2;
            }

        .cancel {
            display: block;
            position: absolute;
            top: 3px;
            right: 2px;
            background: rgb(245,245,245);
            color: black;
            height: 30px;
            width: 35px;
            font-size: 30px;
            text-decoration: none;
            text-align: center;
            font-weight: bold;
        }
    </style>

HTML Code

place anywhere 

  <div align="center"><a href="#popupScreen" class="button">Click here for Dialog</a> </div>
                    <div id="popupScreen">
                        <a href="#" class="cancel">&times;</a>

                   
                        <h2>Hi there</h2>
                    </div>
                    <div id="cover"></div>

Click here for Dialog

×

Hi there

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

Get language and country from a browser in ASP.NET

Published on: 8:36 AM 0

Resolve the culture

Splitted the functionality up into two methods. The first one resolves the CultureInfo based on the browsers language.

public static CultureInfo ResolveCulture()

{

  string[] languages = HttpContext.Current.Request.UserLanguages;

  if (languages == null || languages.Length == 0)

    return null;

  try

  {

    string language = languages[0].ToLowerInvariant().Trim();

    return CultureInfo.CreateSpecificCulture(language);

  }

  catch (ArgumentException)

  {

    return null;

  }

}

Resolve the country

The next method uses the ResolveCulture()method above to create a RegionInfo object. The RegionInfo contains all the country information needed such as ISO code, EnglishName, NativeName and DisplayName.

public static RegionInfo ResolveCountry()

{

  CultureInfo culture = ResolveCulture();

  if (culture != null)

    return new RegionInfo(culture.LCID);

  return null;

}

Read More

How to convert DateTime to Date VarChar

Published on: 10:16 AM 0

This line of code do the job

CONVERT(varchar(10), [MyDateTimecolumn], 20)

eg: select PKID,CONVERT(varchar(10), createdDate, 20) from tempTable

Read More

Best way to check if a Data Table has a null (SQL) value in it

Published on: 10:04 AM 0

Hostgator Offers

 Check Whole table

If you want to check if a null value exists in the table you can use this method:

public static bool HasNull(this DataTable table)
{
    foreach (DataColumn column in table.Columns)
    {
        if (table.Rows.OfType<DataRow>().Any(r => r.IsNull(column)))
            return true;
    }

    return false;
}

and use 

table.HasNull(); 

 where ever you need

 Checking Specific column

Compare the value of the column to the DBNull.Value value to filter and manage null values in whatever way you see fit.

foreach(DataRow row in table.Rows)
{
    object value = row["ColumnName"];
    if (value == DBNull.Value)
        // do something
    else
        // do something else
}

Check More About DBNull Class

Read More

Get 25% Off on HostGator Hosting Coupon Code

Published on: 11:38 PM 0

Since started in 2002, Hostgator has been providing World Class web hosting services to its clients in more than 200 countries. Hostgator has been offering world-class solutions around shared hosting, reseller hosting, VPS hosting and dedicated servers to individuals and professionals. Each web hosting solution from Hostgator comes with 24×7 support, 45 money back guarantee and unlimited bandwidth and disk space. 700,000 plus domain owners trust Hostgator web hosting solutions.

Get 25% Off on HostGator Hosting Coupon Code

Read More

Read HTML File C# ASP Stream Reader

Published on: 4:17 AM 0

string file = Server.MapPath ("abc.html");
StreamReader sr;
FileInfo fi = new FileInfo(file);
if(File.Exists(file))
{
     sr = File.OpenText(file);
     input += sr.ReadToEnd();
     sr.Close();
}
 

Another Method 

 

string[] lines = File.ReadAllLines("path/to/my/file.html");
foreach(string line in lines)
{
    Response.Write(line);
}

 

Read More