Skip to main content

Posts

Showing posts with the label C# Classes

C Sharp User Define SQL Database Class

This is the simple user define SQL Database Class. It is useful to avoid redundancy of the code. Database Class In C# using System; using System.Data; using System.Data.SqlClient; using System.Configuration; public class _Database { public SqlConnection con; public SqlCommand com = null; public SqlDataReader dr = null; public SqlDataAdapter da = null; public DataSet ds = null; public String glQuery = ""; public String glnonQuery = ""; public const int EXECUTE_NONE_QUERY = 1; public const int EXECUTE_QUERY = 2; public const int DATA_ADAPTER = 3; // connection for data list paging public SqlConnection globalcon = new SqlConnection("server=**;uid=**;pwd=***;Database=**"); public _Database() { } public void Query(String SqlQuery) { this.glQuery = this.Get_DataBasePrefix(SqlQuery); } private String Get_DataBasePrefix(String str) { return str.Replace("#__", "GD_").ToString(); } public void ConnectDB() { try { con = new SqlConnection(); con.Co

Convert Image Into Jpeg Using C sharp.

This example is useful to upload image of any format and Convert into JPEG or JPG Using C-Sharp. using System.IO; using System.Drawing; using System.Drawing.Imaging; using System.Reflection; using System.Drawing.Drawing2D; public class _Library { public string w; public string h; public _Library() { } /* for uploading Image */ public String UploadFile(FileUpload Fileobject,String Path) { String FileName = ""; String[] getformat; String imgformat1 = "", imgformat2 = ""; if (Fileobject.HasFile) { FileName = DateTime.Now.Day.ToString() + DateTime.Now.Month.ToString() + DateTime.Now.Year.ToString() + DateTime.Now.Hour.ToString() + DateTime.Now.Minute.ToString() + DateTime.Now.Second.ToString() + "_" + Fileobject.FileName.Replace(' ','-').ToLower(); Fileobject.SaveAs(@"" + Path + "" + FileName); getformat =FileName.ToString().Split('.'); imgformat1 = getformat[0].ToString(); imgformat2 = getformat[1].ToStrin