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:5972dd4b-4df7-4401-998b-bfa84f94b0f7 Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 97659 AND DataTypeId = 6) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (97659,6,'{"status":"ok","response":{"player":{"pid":97659,"title":"Jan Balt","short_name":"JN Balt","first_name":"Jan Balt","last_name":"","middle_name":"","birthdate":"2003-11-09","birthplace":"","country":"na","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"Namibia"},"batting":{"odi":{"match_id":0,"inning_id":0,"matches":2,"innings":2,"notout":1,"runs":35,"balls":59,"highest":35,"run100":0,"run50":0,"run4":4,"run6":0,"average":"35.00","strike":"59.32","catches":0,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20i":{"match_id":0,"inning_id":0,"matches":5,"innings":4,"notout":1,"runs":43,"balls":54,"highest":22,"run100":0,"run50":0,"run4":1,"run6":0,"average":"14.33","strike":"79.62","catches":2,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20":{"match_id":0,"inning_id":0,"matches":8,"innings":7,"notout":1,"runs":58,"balls":95,"highest":22,"run100":0,"run50":0,"run4":1,"run6":1,"average":"9.66","strike":"61.05","catches":4,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":2,"innings":2,"notout":1,"runs":35,"balls":59,"highest":35,"run100":0,"run50":0,"run4":4,"run6":0,"average":"35.00","strike":"59.32","catches":0,"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":2,"innings":2,"balls":24,"overs":4,"runs":23,"wickets":0,"bestinning":"","bestmatch":"","econ":"5.75","average":"","strike":"","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20i":{"match_id":0,"inning_id":0,"matches":5,"innings":4,"balls":56,"overs":9.2,"runs":54,"wickets":2,"bestinning":"1\/11","bestmatch":"1\/11","econ":"5.78","average":"27.00","strike":"28.0","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20":{"match_id":0,"inning_id":0,"matches":8,"innings":4,"balls":56,"overs":9.2,"runs":54,"wickets":2,"bestinning":"1\/11","bestmatch":"1\/11","econ":"5.78","average":"27.00","strike":"28.0","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":2,"innings":2,"balls":24,"overs":4,"runs":23,"wickets":0,"bestinning":"","bestmatch":"","econ":"5.75","average":"","strike":"","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":"36616071c4ec3e0c54efd0902b470592","modified":"2025-06-07 17:41:25","datetime":"2025-06-07 17:41:25","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"player":{"pid":97659,"title":"Jan Balt","short_name":"JN Balt","first_name":"Jan Balt","last_name":"","middle_name":"","birthdate":"2003-11-09","birthplace":"","country":"na","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"Namibia"},"batting":{"odi":{"match_id":0,"inning_id":0,"matches":2,"innings":2,"notout":1,"runs":35,"balls":59,"highest":35,"run100":0,"run50":0,"run4":4,"run6":0,"average":"35.00","strike":"59.32","catches":0,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20i":{"match_id":0,"inning_id":0,"matches":5,"innings":4,"notout":1,"runs":43,"balls":54,"highest":22,"run100":0,"run50":0,"run4":1,"run6":0,"average":"14.33","strike":"79.62","catches":2,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20":{"match_id":0,"inning_id":0,"matches":8,"innings":7,"notout":1,"runs":58,"balls":95,"highest":22,"run100":0,"run50":0,"run4":1,"run6":1,"average":"9.66","strike":"61.05","catches":4,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":2,"innings":2,"notout":1,"runs":35,"balls":59,"highest":35,"run100":0,"run50":0,"run4":4,"run6":0,"average":"35.00","strike":"59.32","catches":0,"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":2,"innings":2,"balls":24,"overs":4,"runs":23,"wickets":0,"bestinning":"","bestmatch":"","econ":"5.75","average":"","strike":"","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20i":{"match_id":0,"inning_id":0,"matches":5,"innings":4,"balls":56,"overs":9.2,"runs":54,"wickets":2,"bestinning":"1\/11","bestmatch":"1\/11","econ":"5.78","average":"27.00","strike":"28.0","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20":{"match_id":0,"inning_id":0,"matches":8,"innings":4,"balls":56,"overs":9.2,"runs":54,"wickets":2,"bestinning":"1\/11","bestmatch":"1\/11","econ":"5.78","average":"27.00","strike":"28.0","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":2,"innings":2,"balls":24,"overs":4,"runs":23,"wickets":0,"bestinning":"","bestmatch":"","econ":"5.75","average":"","strike":"","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":"36616071c4ec3e0c54efd0902b470592","modified":"2025-06-07 17:41:25","datetime":"2025-06-07 17:41:25","api_version":"3.0"}', Modified = GetDate() WHERE Id = 97659 AND DataTypeId = 6 END
Player profile of Jan Balt, Namibia
<>
LIVE06 May Match 5

Hong Kong WomenHong Kong Women

Kuwait Women

 
LIVE06 May Match 6

Thailand WomenThailand Women

United Arab Emirates Women

 
LIVEToday2nd Unofficial Test

England LionsEngland Lions*192/3 (46 ov)

India A348/10 (89.3 ov)

 Stumps : Day 2 - England Lions trail by 156 runs.
LIVETodayMatch 6

Raigad RoyalsRaigad Royals103/10 (13.1 ov)

Puneri Bappa202/4 (20 ov)

 Puneri Bappa won by 99 runs
LIVETodayMatch 16

SOBO Mumbai FalconsSOBO Mumbai Falcons*95/6 (10.3 ov)

Eagle Thane Strikers151/8 (20 ov)

 SOBO Mumbai Falcons need 57 runs in 57 remaining balls
LIVETodayMatch 5

Pagariya StrikersPagariya Strikers*172/5 (18.2 ov)

Bharat Rangers169/9 (20 ov)

 Match completed
LIVETodayMatch 13

NevisNevis*65/4 (7.5 ov)

St Kitts115/10 (20 ov)

 Nevis need 51 runs in 12.1 remaining overs
LIVETodayMatch 5

Upminster-WUpminster-W*0/0 ( ov)

Gunnersbury-W

 Match Start Delay : Gunnersbury-W elected to bowl
LIVETodayMatch 24

Tally RangersTally Rangers*23/0 (2 ov)

Cochin Hurricanes

 Tally Rangers elected to bat
LIVETodayMatch 30

NottinghamshireNottinghamshire

Worcestershire

 Nottinghamshire elected to bowl
Cancelled07 June Match 13

Triumph Knights MNETriumph Knights MNE*20/1 (3 ov)

Namo Bandra Blasters192/7 (20 ov)

 Match abandoned
CancelledTodayMatch 1

Upminster-WUpminster-W0/0 ( ov)

Hutton-W66/0 (6 ov)

 Match abandoned due to rain
CancelledTodayMatch 4

Nagpur TitansNagpur Titans

NECO Master Blaster

 Match Abandoned
CancelledTodayMatch 1

Netherlands WomenNetherlands Women

United States of America Women

 Match abandoned due to rain
CancelledTodayMatch 15

The BlazeThe Blaze

Somerset Women0/0 ( ov)

 Match Abandoned
Scheduled07 June Match 14

Combined IslandsCombined Islands

Anguilla

 
Scheduled07 June Match 15

Virgin IslandsVirgin Islands

Antigua and Barbuda

 
Scheduled08 June 3rd Place Play-off

China WomenChina Women

Philippines Women

 
Scheduled08 June Match 5

Solapur Smashers WomenSolapur Smashers Women

Raigad Royals Women

 
Scheduled08 June Match 17

Mumbai South Central Maratha RoyalsMumbai South Central Maratha Royals

Namo Bandra Blasters

 
CricDirect Cricket News, Results and Stats
 

Jan Balt

NationalityNamibia
RoleAll Rounder
Born09 Nov 2003 (21)
Batting StyleLeft hand Bat
Bowling StyleRight Arm Off Break

Batting

Format MAT INNS NO RUNS HS AVG BF SR 100s 50s
ODI 2 2 1 35 35 35.00 59 59.32 - -
T20I 5 4 1 43 22 14.33 54 79.62 - -
T20I 8 7 1 58 22 9.66 95 61.05 - -
List A 2 2 1 35 35 35.00 59 59.32 - -

Bowling

Format MAT INNS OVR RUNS WK BBI AVG ECN SR 4W 5W
ODI 2 2 4 23 - - - 5.75 - - -
T20i 5 4 9.2 54 2 1/11 27.00 5.78 28.0 - -
T20 8 4 9.2 54 2 1/11 27.00 5.78 28.0 - -
List A 2 2 4 23 - - - 5.75 - - -
× Close