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

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

How to play a Sound in Android Java Eclipse

Published on: 8:37 AM 0

MediaPlayer class can be used to control playback of audio/video files and streams.

 keep the intro.mp3 file in raw folder in res

 MediaPlayer mp = MediaPlayer.create(getApplicationContext(), R.raw.intro);
    mp.start();

mp.pause();// To pause / Stop music

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