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:3ce56aa7-5715-452d-80d7-d1d693f9cca7 Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 93142 AND DataTypeId = 6) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (93142,6,'{"status":"ok","response":{"player":{"pid":93142,"title":"Joshua Bishop","short_name":"J Bishop","first_name":"Joshua Bishop","last_name":"","middle_name":"","birthdate":"2000-05-30","birthplace":"Barbados","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/Jbishop45_","instagram_profile":"https:\/\/www.instagram.com\/joshuabishopii\/","debut_data":"","thumb_url":"","nationality":"West Indies"},"batting":{"t20":{"match_id":0,"inning_id":0,"matches":16,"innings":8,"notout":6,"runs":66,"balls":47,"highest":18,"run100":0,"run50":0,"run4":4,"run6":5,"average":"33.00","strike":"140.42","catches":5,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":46,"innings":38,"notout":8,"runs":300,"balls":434,"highest":37,"run100":0,"run50":0,"run4":18,"run6":11,"average":"10.00","strike":"69.12","catches":14,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":20,"innings":33,"notout":5,"runs":848,"balls":921,"highest":102,"run100":2,"run50":3,"run4":112,"run6":25,"average":"30.28","strike":"92.07","catches":8,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t10":{"match_id":"0","inning_id":"0","matches":"29","innings":"15","notout":"6","runs":"121","balls":"73","highest":"20","run100":"0","run50":"0","run4":"5","run6":"10","average":"13.44","strike":"165.75","catches":"9","stumpings":"0"}},"bowling":{"t20":{"match_id":0,"inning_id":0,"matches":16,"innings":16,"balls":281,"overs":46.5,"runs":360,"wickets":12,"bestinning":"3\/20","bestmatch":"3\/20","econ":"7.68","average":"30.00","strike":"23.4","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":46,"innings":45,"balls":2395,"overs":399.1,"runs":1564,"wickets":69,"bestinning":"5\/35","bestmatch":"5\/35","econ":"3.91","average":"22.66","strike":"34.7","wicket4i":4,"wicket5i":1,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":20,"innings":37,"balls":4533,"overs":755.3,"runs":2171,"wickets":94,"bestinning":"7\/85","bestmatch":"10\/174","econ":"2.87","average":"23.09","strike":"48.2","wicket4i":7,"wicket5i":4,"wicket10m":2,"hattrick":0,"expensive_over_runs":0},"t10":{"match_id":"0","inning_id":"0","matches":"29","innings":"26","balls":"270","overs":"45","runs":"399","wickets":"18","bestinning":"3\/3","bestmatch":"3\/3","econ":"8.87","average":"22.17","strike":"15.00","wicket4i":"0","wicket5i":"0","wicket10m":"0"}}},"etag":"ace78add4c35d4e92f5f86b76306fec0","modified":"2025-06-21 17:14:55","datetime":"2025-06-21 17:14:55","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"player":{"pid":93142,"title":"Joshua Bishop","short_name":"J Bishop","first_name":"Joshua Bishop","last_name":"","middle_name":"","birthdate":"2000-05-30","birthplace":"Barbados","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/Jbishop45_","instagram_profile":"https:\/\/www.instagram.com\/joshuabishopii\/","debut_data":"","thumb_url":"","nationality":"West Indies"},"batting":{"t20":{"match_id":0,"inning_id":0,"matches":16,"innings":8,"notout":6,"runs":66,"balls":47,"highest":18,"run100":0,"run50":0,"run4":4,"run6":5,"average":"33.00","strike":"140.42","catches":5,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":46,"innings":38,"notout":8,"runs":300,"balls":434,"highest":37,"run100":0,"run50":0,"run4":18,"run6":11,"average":"10.00","strike":"69.12","catches":14,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":20,"innings":33,"notout":5,"runs":848,"balls":921,"highest":102,"run100":2,"run50":3,"run4":112,"run6":25,"average":"30.28","strike":"92.07","catches":8,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t10":{"match_id":"0","inning_id":"0","matches":"29","innings":"15","notout":"6","runs":"121","balls":"73","highest":"20","run100":"0","run50":"0","run4":"5","run6":"10","average":"13.44","strike":"165.75","catches":"9","stumpings":"0"}},"bowling":{"t20":{"match_id":0,"inning_id":0,"matches":16,"innings":16,"balls":281,"overs":46.5,"runs":360,"wickets":12,"bestinning":"3\/20","bestmatch":"3\/20","econ":"7.68","average":"30.00","strike":"23.4","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":46,"innings":45,"balls":2395,"overs":399.1,"runs":1564,"wickets":69,"bestinning":"5\/35","bestmatch":"5\/35","econ":"3.91","average":"22.66","strike":"34.7","wicket4i":4,"wicket5i":1,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":20,"innings":37,"balls":4533,"overs":755.3,"runs":2171,"wickets":94,"bestinning":"7\/85","bestmatch":"10\/174","econ":"2.87","average":"23.09","strike":"48.2","wicket4i":7,"wicket5i":4,"wicket10m":2,"hattrick":0,"expensive_over_runs":0},"t10":{"match_id":"0","inning_id":"0","matches":"29","innings":"26","balls":"270","overs":"45","runs":"399","wickets":"18","bestinning":"3\/3","bestmatch":"3\/3","econ":"8.87","average":"22.17","strike":"15.00","wicket4i":"0","wicket5i":"0","wicket10m":"0"}}},"etag":"ace78add4c35d4e92f5f86b76306fec0","modified":"2025-06-21 17:14:55","datetime":"2025-06-21 17:14:55","api_version":"3.0"}', Modified = GetDate() WHERE Id = 93142 AND DataTypeId = 6 END
Player profile of Joshua Bishop, West Indies
<>
LIVE06 May Match 5

Hong Kong WomenHong Kong Women

Kuwait Women

 
LIVE06 May Match 6

Thailand WomenThailand Women

United Arab Emirates Women

 
LIVEToday1st Test

EnglandEngland*147/2 (36.4 ov)

India471/10 (113 ov)

 Day 2 - Session 3, England trail by 324 runs.
LIVETodayMatch 13

Alembic WarriorsAlembic Warriors*30/3 (3.3 ov)

A4 Power Strikers124/4 (10 ov)

 Alembic Warriors need 95 runs in 39 remaining balls
LIVETodayQualifier 2

Puneri BappaPuneri Bappa*82/7 (16 ov)

Raigad Royals133/9 (20 ov)

 Puneri Bappa need 52 runs in 24 remaining balls
LIVETodayMatch 1

West Indies AcademyWest Indies Academy237/10 (46.2 ov)

Sri Lanka Emerging*0/0 ( ov)

 Innings Break : Sri Lanka Emerging need 238 runs in 50 remaining overs
LIVETodayMatch 18

Lyca Kovai KingsLyca Kovai Kings165/6 (20 ov)

Nellai Royal Kings*93/8 (15.5 ov)

 Nellai Royal Kings need 73 runs in 25 remaining balls
LIVETodayMatch 19

Rewa JaguarsRewa Jaguars226/8 (20 ov)

Indore Pink Panthers*104/4 (9.5 ov)

 Indore Pink Panthers need 123 runs in 10.1 remaining overs
LIVETodayMatch 31

Bess Motors Blue DevilsBess Motors Blue Devils

SAMP Army Cocrico Cavaliers*60/3 (7.4 ov)

 Bess Motors Blue Devils elected to bowl
CancelledTodayMatch 12

Diamond DazzlersDiamond Dazzlers121/8 (20 ov)

Pruthvi Panthers

 Match Abandoned
ScheduledTodayMatch 9

Thunder Cats-BThunder Cats-B

Lexus

 
Scheduled21 June Match 32

Chicago Steelpan PlayersChicago Steelpan Players

Soca Kings

 
Scheduled21 June Match 10

Cayman IslandsCayman Islands

Bermuda

 
Scheduled22 June Match 11

MI New YorkMI New York

Washington Freedom

 
Scheduled22 June Match 15

Irises Cricket ClubIrises Cricket Club

Yuksom Capitals

 
Scheduled22 June Match 21

Adamas Howrah Warriors WomensAdamas Howrah Warriors Womens

Servotech Siliguri Strikers Womens

 
Scheduled22 June Eliminator

Brno CCBrno CC

Bohemians

 
Scheduled22 June Match 16

Black Eagle SAPBlack Eagle SAP

Avengers CC

 
Scheduled22 June Match 22

Murshidabad KingsMurshidabad Kings

Rashmi Medinipur Wizards

 
Scheduled22 June Match 3

Bhopal Wolves WomenBhopal Wolves Women

Bundelkhand Bulls Women

 
CricDirect Cricket News, Results and Stats
 

Joshua Bishop

NationalityWest Indies
RoleAll Rounder
Born30 May 2000 (25)
Batting StyleRight Hand Bat
Bowling StyleLeft Arm Orthodox

Batting

Format MAT INNS NO RUNS HS AVG BF SR 100s 50s
T20I 16 8 6 66 18 33.00 47 140.42 - -
List A 46 38 8 300 37 10.00 434 69.12 - -
1st Class 20 33 5 848 102 30.28 921 92.07 2 3

Bowling

Format MAT INNS OVR RUNS WK BBI AVG ECN SR 4W 5W
T20 16 16 46.5 360 12 3/20 30.00 7.68 23.4 - -
List A 46 45 399.1 1564 69 5/35 22.66 3.91 34.7 4 1
1st Class 20 37 755.3 2171 94 7/85 23.09 2.87 48.2 7 4
× Close