Get Excell Sheets in Excell File

 public List<string> ListSheetInExcel(string filePath)
        {
         
            OleDbConnectionStringBuilder sbConnection = new OleDbConnectionStringBuilder();
            String strExtendedProperties = String.Empty;
            sbConnection.DataSource = filePath;
            if (Path.GetExtension(filePath).Equals(".xls"))//for 97-03 Excel file
            {
                sbConnection.Provider = "Microsoft.Jet.OLEDB.4.0";
                strExtendedProperties = "Excel 8.0;HDR=Yes;IMEX=1";//HDR=ColumnHeader,IMEX=InterMixed
            }
            else if (Path.GetExtension(filePath).Equals(".xlsx"))  //for 2007 Excel file
            {
                sbConnection.Provider = "Microsoft.ACE.OLEDB.12.0";
                strExtendedProperties = "Excel 12.0;HDR=Yes;IMEX=1";
            }
            sbConnection.Add("Extended Properties", strExtendedProperties);
            List<string> listSheet = new List<string>();
            using (OleDbConnection conn = new OleDbConnection(sbConnection.ToString()))
            {
                conn.Open();
                System.Data.DataTable dtSheet = conn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null);
             
                foreach (DataRow drSheet in dtSheet.Rows)
                {
                    if (drSheet["TABLE_NAME"].ToString().Contains("$"))//checks whether row contains '_xlnm#_FilterDatabase' or sheet name(i.e. sheet name always ends with $ sign)
                    {
                        listSheet.Add(drSheet["TABLE_NAME"].ToString());
                    }
                }
            }
            return listSheet;
        }

Image Compression

 Bitmap bmp1 = new Bitmap(@"c:\TestPhoto.jpeg");
            ImageCodecInfo jpgEncoder = GetEncoder(System.Drawing.Imaging.ImageFormat.Jpeg);        
            System.Drawing.Imaging.Encoder myEncoder =
            System.Drawing.Imaging.Encoder.Quality;
            EncoderParameters myEncoderParameters = new EncoderParameters(1);
            EncoderParameter myEncoderParameter = new EncoderParameter(myEncoder, 50L);
            myEncoderParameters.Param[0] = myEncoderParameter;
            bmp1.Save(@"c:\TestPhotoQualityFifty.jpeg", jpgEncoder, myEncoderParameters);
            myEncoderParameter = new EncoderParameter(myEncoder, 100L);
            myEncoderParameters.Param[0] = myEncoderParameter;
            bmp1.Save(@"c:\TestPhotoQualityHundred.jpeg", jpgEncoder, myEncoderParameters);    
            myEncoderParameter = new EncoderParameter(myEncoder,20L);
            myEncoderParameters.Param[0] = myEncoderParameter;
            bmp1.Save(@"c:\TestPhotoQualityZero.jpeg", jpgEncoder, myEncoderParameters);




 private ImageCodecInfo GetEncoder(System.Drawing.Imaging.ImageFormat format)
        {

            ImageCodecInfo[] codecs = ImageCodecInfo.GetImageDecoders();

            foreach (ImageCodecInfo codec in codecs)
            {
                if (codec.FormatID == format.Guid)
                {
                    return codec;
                }
            }
            return null;
        }

member names cannot be the same as their enclosing type C#

Example:

Public  Classs  LoginDetails
{
       public LoginDetails()
      {
               //           Constructor
      }
     
      Public Void LoginDetails(string Uname,string Pwd )
      {
           // User defined method
      }
     
 }

Note: It Gives An Error .

Your class Name is  LoginDetails so this method can't also be named LoginDetails . You will have to change the name of the LoginDetails method to something else to make this code compile.

My Sql Generate DataBase Back Up Using C#.net

void GenerateScript()
{
    string constr = "server=localhost;user=root;pwd=root;database=myDataBase;";
    string file = "C:\\MyDumpFile.sql";
    MySqlBackup mb = new MySqlBackup(constr);
    mb.ExportInfo.FileName = file;
    mb.Export();
}

Fusion Chart Flash Player Problem in ASP.Net

in fusion chart add this param code "<param name='wmode'  value='Transparent'>"

My Sql : Incorrect key file for Table

Check Database Server that you have enough disk space on it .if disks are full this error is displayed.
Now, which  folders you should look at it depends on your setup.

Linq To Objects Group bY Syntax

 FROM  selectVariable IN  dataSourceorList GROUPBY selectVariable.variable INTO RANGEVARIABLE Select new { };

Advance Happy Sankranthi

Hi Friends