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:d0cc831b-ff05-43b2-88ba-ea9c91335fbb Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 57899 AND DataTypeId = 6) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (57899,6,'{"status":"ok","response":{"player":{"pid":57899,"title":"Arran Brindle","short_name":"A Brindle","first_name":"Arran Brindle","last_name":"","middle_name":"","birthdate":"1981-11-23","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"England"},"batting":{"test":{"match_id":0,"inning_id":0,"matches":11,"innings":20,"notout":2,"runs":551,"balls":0,"highest":101,"run100":1,"run50":3,"run4":0,"run6":0,"average":"30.61","strike":"","catches":5,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"odi":{"match_id":0,"inning_id":0,"matches":88,"innings":84,"notout":15,"runs":1928,"balls":0,"highest":107,"run100":1,"run50":11,"run4":0,"run6":0,"average":"27.94","strike":"","catches":40,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20i":{"match_id":0,"inning_id":0,"matches":35,"innings":28,"notout":12,"runs":373,"balls":368,"highest":42,"run100":0,"run50":0,"run4":25,"run6":1,"average":"23.31","strike":"101.35","catches":13,"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":{"test":{"match_id":0,"inning_id":0,"matches":11,"innings":4,"balls":78,"overs":13,"runs":69,"wickets":0,"bestinning":"","bestmatch":"","econ":"5.30","average":"","strike":"","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"odi":{"match_id":0,"inning_id":0,"matches":88,"innings":31,"balls":1032,"overs":172,"runs":776,"wickets":35,"bestinning":"3\/0","bestmatch":"3\/0","econ":"4.51","average":"22.17","strike":"29.4","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20i":{"match_id":0,"inning_id":0,"matches":35,"innings":24,"balls":453,"overs":75.3,"runs":384,"wickets":22,"bestinning":"3\/11","bestmatch":"3\/11","econ":"5.08","average":"17.45","strike":"20.5","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":"f1f2d7cb4e1eb20eb23a6b640dc44c54","modified":"2025-06-05 12:07:06","datetime":"2025-06-05 12:07:06","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"player":{"pid":57899,"title":"Arran Brindle","short_name":"A Brindle","first_name":"Arran Brindle","last_name":"","middle_name":"","birthdate":"1981-11-23","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"England"},"batting":{"test":{"match_id":0,"inning_id":0,"matches":11,"innings":20,"notout":2,"runs":551,"balls":0,"highest":101,"run100":1,"run50":3,"run4":0,"run6":0,"average":"30.61","strike":"","catches":5,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"odi":{"match_id":0,"inning_id":0,"matches":88,"innings":84,"notout":15,"runs":1928,"balls":0,"highest":107,"run100":1,"run50":11,"run4":0,"run6":0,"average":"27.94","strike":"","catches":40,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20i":{"match_id":0,"inning_id":0,"matches":35,"innings":28,"notout":12,"runs":373,"balls":368,"highest":42,"run100":0,"run50":0,"run4":25,"run6":1,"average":"23.31","strike":"101.35","catches":13,"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":{"test":{"match_id":0,"inning_id":0,"matches":11,"innings":4,"balls":78,"overs":13,"runs":69,"wickets":0,"bestinning":"","bestmatch":"","econ":"5.30","average":"","strike":"","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"odi":{"match_id":0,"inning_id":0,"matches":88,"innings":31,"balls":1032,"overs":172,"runs":776,"wickets":35,"bestinning":"3\/0","bestmatch":"3\/0","econ":"4.51","average":"22.17","strike":"29.4","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20i":{"match_id":0,"inning_id":0,"matches":35,"innings":24,"balls":453,"overs":75.3,"runs":384,"wickets":22,"bestinning":"3\/11","bestmatch":"3\/11","econ":"5.08","average":"17.45","strike":"20.5","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":"f1f2d7cb4e1eb20eb23a6b640dc44c54","modified":"2025-06-05 12:07:06","datetime":"2025-06-05 12:07:06","api_version":"3.0"}', Modified = GetDate() WHERE Id = 57899 AND DataTypeId = 6 END
Player profile of Arran Brindle, England
<>
LIVE06 May Match 5

Hong Kong WomenHong Kong Women

Kuwait Women

 
LIVE06 May Match 6

Thailand WomenThailand Women

United Arab Emirates Women

 
LIVETodayPratice Match

South AfricaSouth Africa313/7d (79 ov)

Zimbabwe*48/1 (11 ov)

 Match Start Delay : Day 3 - Zimbabwe trail by 265 runs.
LIVETodayMatch 2

Raigad RoyalsRaigad Royals190/6 (20 ov)

Satara Warriors*131/5 (16.4 ov)

 Satara Warriors need 60 runs in 20 remaining balls
LIVETodayMatch 6

Namo Bandra BlastersNamo Bandra Blasters*70/5 (11.1 ov)

Eagle Thane Strikers205/6 (20 ov)

 Namo Bandra Blasters need 136 runs in 53 remaining balls
LIVETodayMatch 1

Pagariya StrikersPagariya Strikers*87/4 (11 ov)

Nagpur Titans122/8 (20 ov)

 Pagariya Strikers need 36 runs in 54 remaining balls
LIVETodayMatch 11

Rwanda WomenRwanda Women*34/1 (9 ov)

Malawi Women

 Malawi Women elected to bowl
LIVETodayMatch 12

Nigeria WomenNigeria Women

Tanzania Women*23/1 (4.2 ov)

 Tanzania Women elected to bat
LIVETodayMatch 7

SOBO Mumbai FalconsSOBO Mumbai Falcons

North Mumbai Panthers*1/1 (1 ov)

 SOBO Mumbai Falcons elected to bowl
Cancelled05 June Match 5

Hong Kong WomenHong Kong Women

Philippines Women

 Match Abandoned
CancelledTodayMatch 16

Sharks Cricket AcademySharks Cricket Academy

Mighty Tigers

 Match abondoned due to rain
CancelledTodayMatch 17

RainhamRainham

Mighty Tigers0/0 ( ov)

 Match abandoned due to rain
ScheduledTodayMatch 18

Sharks Cricket AcademySharks Cricket Academy

Rainham

 
ScheduledTodayMatch 10

Surrey WomenSurrey Women

Hampshire Women

 
Scheduled05 June Match 2

Ratnagiri Jets WomenRatnagiri Jets Women

Raigad Royals Women

 
Scheduled05 June Match 1

Dindigul DragonsDindigul Dragons

Lyca Kovai Kings

 
Scheduled05 June Match 8

Triumph Knights MNETriumph Knights MNE

Mumbai South Central Maratha Royals

 
Scheduled05 June Match 19

Sharks Cricket AcademySharks Cricket Academy

Hornchurch

 
Scheduled05 June Match 10

AnguillaAnguilla

Nevis

 
Scheduled05 June Match 19

MEC Study GroupMEC Study Group

Thunder Cats

 
CricDirect Cricket News, Results and Stats
 

Arran Brindle

NationalityEngland
RoleBatter
Born23 Nov 1981 (43)
Batting StyleRight Hand Bat
Bowling StyleRight Arm Medium

Batting

Format MAT INNS NO RUNS HS AVG BF SR 100s 50s
Test 11 20 2 551 101 30.61 - - 1 3
ODI 88 84 15 1928 107 27.94 - - 1 11
T20I 35 28 12 373 42 23.31 368 101.35 - -

Bowling

Format MAT INNS OVR RUNS WK BBI AVG ECN SR 4W 5W
Test 11 4 13 69 - - - 5.30 - - -
ODI 88 31 172 776 35 3/0 22.17 4.51 29.4 - -
T20i 35 24 75.3 384 22 3/11 17.45 5.08 20.5 - -
× Close