[Problem][Solved] How to convert CSV to XML in CLAD Genius Bulk Import

Another problem encounter, yet solved :)

Orite well first of all,
"what is CLAD Genius?"
to make things short, CLAD genius is an auto posting software to begin marketing! which you can use this piece of software to place your ads on Craigslist, Backpage, or Ebay Classifieds.

[The problem]
Someone asked me how to Convert a CSV data to XML which it uses CLAD Genuis xml tamplate?

-[CSV data content]
columnA,columnB,columnC,columnD
mike,where,we,foxtrot,
alpha,bravo,charlie,delta

-[Clad genius XML tamplate]

Eg:

  
    {{COLUMN A}}
    
    {{COLUMN B}}
    bpap$allowReplies='No';bpap$showJoinedDate='False';bpap$showAdLinks='No'
    
    
    <div style="width:650px;margin:0 auto;"> <div style="float:left;width:188px;clear:left;margin-top:20px;"> <a href="{{COLUMN E}}"><img src="http://s19.postimage.org/gdbcs6ttv/tickets_On_Sale_Stub.png" border="0" alt="{{COLUMN A}} Tickets For Sale Online" /></a> </div> <div style="float:right;width:447px;margin-left:15px;"> <br><br> <h1 style="text-align:center;"><b><a href="{{COLUMN E}}" style="color:#CC3300;text-decoration:none;">Buy {{COLUMN A}} tickets online</a></b></h1> <span> <a href="{{COLUMN E}}" title="Find and Purchase {{COLUMN A}} Tickets Online At http://ticketogre.com">{{COLUMN A}} tickets</a> are currently the #1 selling events this 2012. This high demanding event, {{COLUMN A}} will absolutly be sold out early. www.TicketOgre.com has one of the largest supply {{COLUMN A}} available. If you are hunting for {{COLUMN A}} seating charts/maps, last minute {{COLUMN A}} ticket savings, {{COLUMN A}} discounts, sold out {{COLUMN A}} seats, or {{COLUMN A}} 2012 and 2013 schedule, check www.TicketOgre.com for all your event needs. </span> <h2 style="color:#CC3300;text-align:center;">{{COLUMN A}} tickets are selling quick, act now</h2> <div style="padding:15px;"> <a href="{{COLUMN E}}"><img src="http://s19.postimage.org/yop56uw77/buy_Now_Button_Green.png" border="0" alt="Where To Buy {{COLUMN A}} Tickets Online" width=400 /></a> </div> </div> </div> <p><font size="1" color="aliceblue">$randomtext{88}</font></p><div style="clear:both;"></div>

    0001-01-01 00:00:00
    0001-01-01 00:00:00
    
      
        
          
        
        
          
        
      
      
      
    
  

After some writing program, i manage to generate the CSV data into the specific place in the XML tamplate. :) and here it is:

*The program :)

Want the source code? just PM me! :)

30saat[at]gmail[dot]com

[Problems][Solved] How to count rows in datagrid in vb.net

Hello guys,

i've just encounter some problems during my programming in vb.net or visual basic dot net :)

the problem occurs when i wanted to count rows in a "datagrid" remember, its "DATAGRID" not "datagridVIEW" :)

a lot of website resolve the issues by just stating that use this "Datagridview.rowcount". Believe me, in datagrid, you only have "datagrid.visibleRowCount only! which just count rows that visible to you/datagrid. the hidden rows arn't counted!

so, how to count rows in datagrid?

1. create a integer variable to hold the row count data

dim rowcount as integer

2. next, type:

rowcount = DataGrid1.BindingContext(DataGrid1.DataSource,DataGrid1.DataMember).Count.ToString

(*where DataGrid1 is your datagrid name)

and viola! you've done it! :)

Hope this helps!