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

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

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

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

Datetime format Issue String was not recognized as a valid DateTime C# ASP .Net

Published on: 9:03 AM 0

If this issue happens after the website is uploaded to server and no problem at your local computer, the cause of error is the date format difference of your system and your server

Mostly the error happens for month

consider a date "29/09/2014 20:20:00"

Usually this error occurs at Convert.ToDateTime(DateTimeInStringFormat);

My local computer consider '29' as day and my server consider '29' as a month.

ie. at my local server date format is 'dd/MM/yyyy HH:mm:ss'

and at server it is 'MM/dd/yyyy HH:mm:ss'

There is lot of working solutions i found in a search. I am listing few of them

Sol Using Parse Exact

DateTime dt = DateTime.ParseExact(dr["dateCreated"].ToString().Trim(), 

 "M/d/yyyy h:mm:ss tt", CultureInfo.InvariantCulture);

//dr["dateCreated"] returns  date from database

Sol Using TryParse

DateTime date4;
string dateString = @"20/05/2012";
bool result = DateTime.TryParse(dateString,out date4); 

the parsing fails, but it will not throw error, rather it returns  

false indicating that the parsing failed.

Sol Using appropriate culture (I got this working)

string dateString = @"20/05/2012";
DateTime date2 = Convert.ToDateTime(dateString,
 System.Globalization.CultureInfo.GetCultureInfo("hi-IN").DateTimeFormat);

 

Read More

Setting up connection string in ASP.NET to SQL SERVER WEB.config Global

Published on: 8:48 AM 0

In Web.config under <configuration> Tag

<connectionStrings>
    <add name="ConnStringDb1" connectionString="Data Source=localhost;Initial Catalog=YourDataBaseName;Integrated Security=True;" providerName="System.Data.SqlClient" />
  </connectionStrings>

in C# code usage

  SqlCommand command;
        public static string connectionstring = ConfigurationManager.ConnectionStrings["ConnStringDb1"].ToString();
        SqlConnection conn = new SqlConnection(connectionstring); 

Dont Forget to add "using System.Configuration;"

Read More

C# Load Image from URL ASP

Published on: 8:18 AM 0

Loading an image from a URL in C# is possible without much code. Downloading images off the internet can be done directly to memory without having to save them as a file. The image in memory can be written to disk later if necessary.



 The Logic Behind   is to wrap the raw data as a Stream. The System.IO namespace in C# has a useful class called MemoryStream. The MemoryStream C# class can be loaded with raw data that will be read like any other "file" stream, except the bytes are in memory.

byte[] imageData = DownloadData(Url); //Url is image link
MemoryStream stream = new MemoryStream(imageData);
Image img = Image.FromStream(stream);
stream.Close();

 string saveImagePath = System.Web.HttpContext.Current.Server.MapPath("../media/full/")  + "image.jpg"; 

 img.Save(saveImagePath, System.Drawing.Imaging.ImageFormat.Jpeg);

Read More