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

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

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

How to set read write permission to directory in C#.NET

Published on: 12:31 AM 0

While working with files and directory we need read write permission on files and folders, this can be done by manually giving access permission to directory as well as programmatically.

private static void SetPermissions(string dirPath)

{

    DirectoryInfo info = new DirectoryInfo(dirPath);

    WindowsIdentity self = System.Security.Principal.WindowsIdentity.GetCurrent();

    DirectorySecurity ds = info.GetAccessControl();

    ds.AddAccessRule(new FileSystemAccessRule(self.Name,

    FileSystemRights.FullControl,

    InheritanceFlags.ObjectInherit |

    InheritanceFlags.ContainerInherit,

    PropagationFlags.None,

    AccessControlType.Allow));

    info.SetAccessControl(ds);

}




 read-only on access on file

FileInfo myFile = new FileInfo(files.FullName);

myFile.IsReadOnly = false;

  File with Read Write permission

FileStream F = new FileStream("test.dat", FileMode.OpenOrCreate, FileAccess.ReadWrite);

Read More

Convert Image to Base64 String and Base64 String to Image C#

Published on: 7:44 AM 0

Image to Base64 String

public string ImageToBase64(Image image, 
  System.Drawing.Imaging.ImageFormat format)
{
  using (MemoryStream ms = new MemoryStream())
  {
    // Convert Image to byte[]
    image.Save(ms, format);
    byte[] imageBytes = ms.ToArray();

    // Convert byte[] to Base64 String
    string base64String = Convert.ToBase64String(imageBytes);
    return base64String;
  }
}

Base64 String to Image

 

public Image Base64ToImage(string base64String)
{
  // Convert Base64 String to byte[]
  byte[] imageBytes = Convert.FromBase64String(base64String);
  MemoryStream ms = new MemoryStream(imageBytes, 0, 
    imageBytes.Length);

  // Convert byte[] to Image
  ms.Write(imageBytes, 0, imageBytes.Length);
  Image image = Image.FromStream(ms, true);
  return image;
}

 

 

Read More