Poll or Voting Control in Asp.net ajax and C#

by daz 6/20/2010 4:48:00 AM
I have found a very nice poll or survey control from zongoTech This control will help you add a survey in your website. the name is ZTPoll, you may check it out if u are looking for a dll to make a voting in your website. I have tested this control in one of my client site on May and this client was satisfied. I give you the demo link where u can download it Voting Control in DotNet

Tags:

Asp.net, C# | Blog

Top 5 best Web hosting by price ,customers support, reviews

by daz 2/6/2010 7:54:00 PM

This is the top 5 best web hosting companies  and domain registration in February 2010. We have reviewed and selected 5 best companies from the world top hosting services combine with domaine registration. We gather the information from client that have been with those companies for over 5 years. All the hosting we reviewed are reliable , and are supporting Asp.net 3.5, MSSQL,MySQL, Apach and PHP ,Webmail. In general they have a Windows and Linux base plan.

Rank Company
1st FasoService.com 

This company offer 24h/7 suppport, base in the US they are very cheap and for each client they offer $1 to charity organisation for the world hunger eradication. Enough space for developers, private small and medium size company.FasoService.com. They are cheaper than godaddy but seems to have the same customer support level. 

  • Serving International customers.
  • Cpanel Control Panel
  • Fantastico Script Installer
  • Advance hosting at affordable rate.
  • Best support service and overall best host
  • 2nd  GoDaddy.com

     Nice customer support.

    Reseller hosting available.

     
    3rd  http://www.hostmonster.com/  Reseller hosting available.
    4th  http://www.hostgator.com/  Monthly billing cycle available @ $8.95
    5th  http://www.Dailyrazor.com/  very good on hacker and malicious software tracking

    Upload CSV in SQL Database using Linq

    by daz 10/20/2009 4:46:00 AM

     In my previous article http://davidz.afriklink.com/post/Creating-and-Deploying-a-dtsx-package-to-upload-CSVxcl-in-Database.aspx 

    I encounter a problem where the system generating csv file create some files with empty cell.As you know it is hard inserting empty data to an integer field in a database. I did not want to change my emailId that is Integer in the table to be a varchar for example.

    So my solution was to create another function that will get all the files that was rejected by the dtsx package and read them line by line

    private void ErrorCorrection(Settings setting) //setting has all my configuration meaning directories for all files

     {

     string[] files = Directory.GetFiles(setting.ErrorFolder, @"*.csv", SearchOption.TopDirectoryOnly); //Loop through all  csv files error s ones   

    for (int i = 0; i < files.Length; i++) foreach (string errorFile in _logFilesError) // Log exist

     {

    _logFilesError.Add(files[i]);

    } 

    {

    if (!File.Exists(errorFile)) continue 

    var fileInfo = new FileInfo(errorFile);

    string conn = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + fileInfo.DirectoryName + ";Extended Properties='Text;HDR=Yes;FMT=CSVDelimited'"; 

    OleDbConnection cn = new OleDbConnection(conn);

    OleDbCommand cmd = new OleDbCommand(@"SELECT * FROM [" + fileInfo.Name + "]"

    , cn); OleDbDataAdapter da = new OleDbDataAdapter(cmd);  

     

    DataTable dt = new DataTable();

     

    cn.Open(); 

    var properties = (from r in

    dt.AsEnumerable()  

    where r[3].ToString() != string.Empty && r[4].ToString() != string.Empty select r);

    foreach (var data in properties) //

    {

     TESTCSVdAO dao = new TESTCSVdAO();  

    int.Parse(data[2].ToString()), int.Parse(data[3].ToString()),

    int.Parse(data[4].ToString()));  

    ////move to archive folder csv folder

     FileInfo fi = new FileInfo(errorFile.ToString());

    string destination = setting.Archive;

    }

    }

     ###########Linq Action ##########  we can accomplish the sAME with LINQ to CSV

    string[] csvlines = File.ReadAllLines(@errorFile); 

    var query = from csvline in csvlines let data = csvline.Split(',')

     select new

     

    {

    type = data[0],dsnStatus = data[1],batchid = data[2],EmailId = data[3],

    pBatchid = data[3]};

    var result = from q in

    query where q.batchid != null || q.pBatchid != null select q;  

    foreach (var r in result)  

    TESTCSVdAO dao = new TESTCSVdAO();  

    int.Parse(r.batchid), int.Parse(r.EmailId), int.Parse(r.pBatchid)); 

     

    dao.GetSumaryCampaign(r.type, r.dsnStatus,

     

    {

    }

     

     

     

    dao.GetSumaryCampaign(data[0].ToString(), data[1].ToString(),

     

     

     

    da.Fill(dt);

    About the author

    Name of author
    DavidZ
    .Net Programmer
    E-mail me Send mail

    Calendar

    <<  August 2010  >>
    MoTuWeThFrSaSu
    2627282930311
    2345678
    9101112131415
    16171819202122
    23242526272829
    303112345

    View posts in large calendar

    Recent comments

    Authors

    Disclaimer

    The opinions expressed herein are my own personal opinions and do not represent my employer's view in anyway.

    © Copyright 2010

    Sign in