System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'StatusId'. Invalid column name 'ErrorLog'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Etoz.ConnectData.DataAccess.ExecuteQuery(String query) in c:\inetpub\wwwroot\cricdirect.com\api\v6\App_Code\db\data_access.cs:line 117 ClientConnectionId:d9e04bbb-56e6-4456-8850-0d1677400ce0 Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 114563 AND DataTypeId = 6) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (114563,6,'{"status":"ok","response":{"player":{"pid":114563,"title":"Dylan Leicher","short_name":"D Leicher","first_name":"Dylan Leicher","last_name":"","middle_name":"","birthdate":"2004-05-03","birthplace":"","country":"na","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","nationality":"Namibia"},"batting":{"odi":{"match_id":0,"inning_id":0,"matches":3,"innings":2,"notout":0,"runs":52,"balls":55,"highest":32,"run100":0,"run50":0,"run4":4,"run6":2,"average":"26.00","strike":"94.54","catches":1,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20i":{"match_id":0,"inning_id":0,"matches":13,"innings":9,"notout":4,"runs":95,"balls":109,"highest":42,"run100":0,"run50":0,"run4":2,"run6":4,"average":"19.00","strike":"87.15","catches":1,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20":{"match_id":0,"inning_id":0,"matches":16,"innings":10,"notout":4,"runs":98,"balls":116,"highest":42,"run100":0,"run50":0,"run4":2,"run6":4,"average":"16.33","strike":"84.48","catches":1,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":6,"innings":5,"notout":0,"runs":109,"balls":151,"highest":46,"run100":0,"run50":0,"run4":5,"run6":2,"average":"21.80","strike":"72.18","catches":1,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t10":{"match_id":"0","inning_id":"0","matches":"","innings":"","notout":"","runs":"","balls":"","highest":"","run100":"","run50":"","run4":"","run6":"","average":"","strike":"","catches":"","stumpings":""}},"bowling":{"odi":{"match_id":0,"inning_id":0,"matches":3,"innings":2,"balls":60,"overs":10,"runs":68,"wickets":1,"bestinning":"1\/55","bestmatch":"1\/55","econ":"6.80","average":"68.00","strike":"60.0","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20i":{"match_id":0,"inning_id":0,"matches":13,"innings":7,"balls":72,"overs":12,"runs":116,"wickets":3,"bestinning":"1\/4","bestmatch":"1\/4","econ":"9.66","average":"38.66","strike":"24.0","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20":{"match_id":0,"inning_id":0,"matches":16,"innings":9,"balls":96,"overs":16,"runs":139,"wickets":4,"bestinning":"1\/4","bestmatch":"1\/4","econ":"8.68","average":"34.75","strike":"24.0","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":6,"innings":4,"balls":108,"overs":18,"runs":124,"wickets":1,"bestinning":"1\/55","bestmatch":"1\/55","econ":"6.88","average":"124.00","strike":"108.0","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t10":{"match_id":"0","inning_id":"0","matches":"0","innings":"","balls":"","overs":"0","runs":"","wickets":"","bestinning":"","bestmatch":"","econ":"","average":"","strike":"","wicket4i":"","wicket5i":"","wicket10m":""}}},"etag":"f836bac5e71c9353dcd2d3dd3e164d22","modified":"2025-07-27 12:42:16","datetime":"2025-07-27 12:42:16","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"player":{"pid":114563,"title":"Dylan Leicher","short_name":"D Leicher","first_name":"Dylan Leicher","last_name":"","middle_name":"","birthdate":"2004-05-03","birthplace":"","country":"na","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","nationality":"Namibia"},"batting":{"odi":{"match_id":0,"inning_id":0,"matches":3,"innings":2,"notout":0,"runs":52,"balls":55,"highest":32,"run100":0,"run50":0,"run4":4,"run6":2,"average":"26.00","strike":"94.54","catches":1,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20i":{"match_id":0,"inning_id":0,"matches":13,"innings":9,"notout":4,"runs":95,"balls":109,"highest":42,"run100":0,"run50":0,"run4":2,"run6":4,"average":"19.00","strike":"87.15","catches":1,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20":{"match_id":0,"inning_id":0,"matches":16,"innings":10,"notout":4,"runs":98,"balls":116,"highest":42,"run100":0,"run50":0,"run4":2,"run6":4,"average":"16.33","strike":"84.48","catches":1,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":6,"innings":5,"notout":0,"runs":109,"balls":151,"highest":46,"run100":0,"run50":0,"run4":5,"run6":2,"average":"21.80","strike":"72.18","catches":1,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t10":{"match_id":"0","inning_id":"0","matches":"","innings":"","notout":"","runs":"","balls":"","highest":"","run100":"","run50":"","run4":"","run6":"","average":"","strike":"","catches":"","stumpings":""}},"bowling":{"odi":{"match_id":0,"inning_id":0,"matches":3,"innings":2,"balls":60,"overs":10,"runs":68,"wickets":1,"bestinning":"1\/55","bestmatch":"1\/55","econ":"6.80","average":"68.00","strike":"60.0","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20i":{"match_id":0,"inning_id":0,"matches":13,"innings":7,"balls":72,"overs":12,"runs":116,"wickets":3,"bestinning":"1\/4","bestmatch":"1\/4","econ":"9.66","average":"38.66","strike":"24.0","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20":{"match_id":0,"inning_id":0,"matches":16,"innings":9,"balls":96,"overs":16,"runs":139,"wickets":4,"bestinning":"1\/4","bestmatch":"1\/4","econ":"8.68","average":"34.75","strike":"24.0","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":6,"innings":4,"balls":108,"overs":18,"runs":124,"wickets":1,"bestinning":"1\/55","bestmatch":"1\/55","econ":"6.88","average":"124.00","strike":"108.0","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t10":{"match_id":"0","inning_id":"0","matches":"0","innings":"","balls":"","overs":"0","runs":"","wickets":"","bestinning":"","bestmatch":"","econ":"","average":"","strike":"","wicket4i":"","wicket5i":"","wicket10m":""}}},"etag":"f836bac5e71c9353dcd2d3dd3e164d22","modified":"2025-07-27 12:42:16","datetime":"2025-07-27 12:42:16","api_version":"3.0"}', Modified = GetDate() WHERE Id = 114563 AND DataTypeId = 6 END
Player profile of Dylan Leicher, Namibia
<>
LIVE06 May Match 5

Hong Kong WomenHong Kong Women

Kuwait Women

 
LIVE06 May Match 6

Thailand WomenThailand Women

United Arab Emirates Women

 
LIVEToday4th Test

EnglandEngland669/10 (157.1 ov)

India358/10 (114.1 ov) & *223/4 (89 ov)

 Day 5 - Session 2, India trail by 88 runs.
LIVETodayMatch 18

United Arab EmiratesUnited Arab Emirates*2/0 (0.4 ov)

Uganda170/7 (20 ov)

 United Arab Emirates need 169 runs in 19.2 remaining overs
LIVETodayFinal

BahrainBahrain*189/3 (20 ov)

Malawi

 Malawi elected to bowl
LIVETodayMatch 6

Guwahati GiantsGuwahati Giants82/1 (6 ov)

City Cricket Club55/2 (6 ov)

 Guwahati Giants won by 27 runs
LIVEToday1st Semi-Final

The Blaze WomenThe Blaze Women

Warwickshire Women*140/6 (17 ov)

 Warwickshire Women elected to bat
LIVETodayMatch 12

South Africa ChampionsSouth Africa Champions*224/2 (17 ov)

Australia Champions

 South Africa Champions elected to bat
LIVETodayQualifier 2

HuddingeHuddinge156/6 (10 ov)

Rising Phoenix0/0 ( ov)

 Match completed
CancelledTodayFinal

AustriaAustria182/3 (16 ov)

Romania

 Match abandoned due to rain
CancelledTodayMatch 5

Navarang ClubNavarang Club0/0 ( ov)

City Cricket Club58/1 (6 ov)

 Match abandoned due to rain
ScheduledTodayFinal

Villianur Mohit KingsVillianur Mohit Kings

Mahe Megalo Strikers

 
Scheduled27 July Match 2

West Indies Women Under-19sWest Indies Women Under-19s

United States of America Women Under-19s

 
Scheduled27 July Final

Alby Zalmi CFAlby Zalmi CF

TBA

 
Scheduled27 July Match 13

India ChampionsIndia Champions

England Champions

 
Scheduled27 July Match 29

Chennai Kings CAChennai Kings CA

Tally Rangers

 
Scheduled28 July 1st Semi-Final

Maxx Cricket ClubMaxx Cricket Club

Sky Warriors Cricket

 
Scheduled28 July 2nd Semi-Final

MR KB PutrajayaMR KB Putrajaya

Fatemi Resources Cricket Club

 
Scheduled28 July Match 1

Gauhati Town ClubGauhati Town Club

Bud CC

 
CricDirect Cricket News, Results and Stats
 

Dylan Leicher

NationalityNamibia
RoleAll Rounder
Born03 May 2004 (21)
Batting StyleRight Hand Bat
Bowling StyleRight Arm Medium

Batting

Format MAT INNS NO RUNS HS AVG BF SR 100s 50s
ODI 3 2 - 52 32 26.00 55 94.54 - -
T20I 13 9 4 95 42 19.00 109 87.15 - -
T20I 16 10 4 98 42 16.33 116 84.48 - -
List A 6 5 - 109 46 21.80 151 72.18 - -

Bowling

Format MAT INNS OVR RUNS WK BBI AVG ECN SR 4W 5W
ODI 3 2 10 68 1 1/55 68.00 6.80 60.0 - -
T20i 13 7 12 116 3 1/4 38.66 9.66 24.0 - -
T20 16 9 16 139 4 1/4 34.75 8.68 24.0 - -
List A 6 4 18 124 1 1/55 124.00 6.88 108.0 - -
× Close