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:9bcbbe78-976f-4467-ba65-73a1c1ea2d31 Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 55453 AND DataTypeId = 6) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (55453,6,'{"status":"ok","response":{"player":{"pid":55453,"title":"Derval Green","short_name":"DGreen","first_name":"Derval Green","last_name":"","middle_name":"","birthdate":"1988-12-04","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"West Indies"},"batting":{"t20":{"match_id":0,"inning_id":0,"matches":4,"innings":4,"notout":2,"runs":42,"balls":45,"highest":17,"run100":0,"run50":0,"run4":3,"run6":1,"average":"21.00","strike":"93.33","catches":0,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":24,"innings":20,"notout":3,"runs":158,"balls":273,"highest":32,"run100":0,"run50":0,"run4":8,"run6":2,"average":"9.29","strike":"57.87","catches":6,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":42,"innings":75,"notout":9,"runs":1337,"balls":2246,"highest":86,"run100":0,"run50":5,"run4":156,"run6":29,"average":"20.25","strike":"59.52","catches":18,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t10":{"match_id":"0","inning_id":"0","matches":"8","innings":"7","notout":"1","runs":"76","balls":"51","highest":"37","run100":"0","run50":"0","run4":"3","run6":"6","average":"12.67","strike":"149.02","catches":"4","stumpings":"0"}},"bowling":{"t20":{"match_id":0,"inning_id":0,"matches":4,"innings":4,"balls":72,"overs":12,"runs":126,"wickets":3,"bestinning":"2\/23","bestmatch":"2\/23","econ":"10.50","average":"42.00","strike":"24.0","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":24,"innings":24,"balls":1031,"overs":171.5,"runs":960,"wickets":23,"bestinning":"4\/44","bestmatch":"4\/44","econ":"5.58","average":"41.73","strike":"44.8","wicket4i":1,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":42,"innings":77,"balls":5570,"overs":928.2,"runs":2893,"wickets":113,"bestinning":"5\/30","bestmatch":"9\/160","econ":"3.11","average":"25.60","strike":"49.2","wicket4i":4,"wicket5i":3,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t10":{"match_id":"0","inning_id":"0","matches":"8","innings":"7","balls":"78","overs":"13","runs":"125","wickets":"2","bestinning":"1\/9","bestmatch":"1\/9","econ":"9.62","average":"62.50","strike":"39.00","wicket4i":"0","wicket5i":"0","wicket10m":"0"}}},"etag":"f95c112d644e04eafd830cb1179cc862","modified":"2025-06-08 10:20:14","datetime":"2025-06-08 10:20:14","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"player":{"pid":55453,"title":"Derval Green","short_name":"DGreen","first_name":"Derval Green","last_name":"","middle_name":"","birthdate":"1988-12-04","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"West Indies"},"batting":{"t20":{"match_id":0,"inning_id":0,"matches":4,"innings":4,"notout":2,"runs":42,"balls":45,"highest":17,"run100":0,"run50":0,"run4":3,"run6":1,"average":"21.00","strike":"93.33","catches":0,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":24,"innings":20,"notout":3,"runs":158,"balls":273,"highest":32,"run100":0,"run50":0,"run4":8,"run6":2,"average":"9.29","strike":"57.87","catches":6,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":42,"innings":75,"notout":9,"runs":1337,"balls":2246,"highest":86,"run100":0,"run50":5,"run4":156,"run6":29,"average":"20.25","strike":"59.52","catches":18,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t10":{"match_id":"0","inning_id":"0","matches":"8","innings":"7","notout":"1","runs":"76","balls":"51","highest":"37","run100":"0","run50":"0","run4":"3","run6":"6","average":"12.67","strike":"149.02","catches":"4","stumpings":"0"}},"bowling":{"t20":{"match_id":0,"inning_id":0,"matches":4,"innings":4,"balls":72,"overs":12,"runs":126,"wickets":3,"bestinning":"2\/23","bestmatch":"2\/23","econ":"10.50","average":"42.00","strike":"24.0","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":24,"innings":24,"balls":1031,"overs":171.5,"runs":960,"wickets":23,"bestinning":"4\/44","bestmatch":"4\/44","econ":"5.58","average":"41.73","strike":"44.8","wicket4i":1,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":42,"innings":77,"balls":5570,"overs":928.2,"runs":2893,"wickets":113,"bestinning":"5\/30","bestmatch":"9\/160","econ":"3.11","average":"25.60","strike":"49.2","wicket4i":4,"wicket5i":3,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t10":{"match_id":"0","inning_id":"0","matches":"8","innings":"7","balls":"78","overs":"13","runs":"125","wickets":"2","bestinning":"1\/9","bestmatch":"1\/9","econ":"9.62","average":"62.50","strike":"39.00","wicket4i":"0","wicket5i":"0","wicket10m":"0"}}},"etag":"f95c112d644e04eafd830cb1179cc862","modified":"2025-06-08 10:20:14","datetime":"2025-06-08 10:20:14","api_version":"3.0"}', Modified = GetDate() WHERE Id = 55453 AND DataTypeId = 6 END
Player profile of Derval Green, West Indies
<>
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*215/3 (49.2 ov)

India A348/10 (89.3 ov)

 Day 3 - Session 1, England Lions trail by 133 runs.
LIVETodayMatch 21

Malawi WomenMalawi Women53/10 (18 ov)

Uganda Women103/6 (20 ov)

 Uganda Women won by 50 runs
LIVETodayMatch 1

CzechiaCzechia113/10 (18.4 ov)

Austria*14/0 (2 ov)

 Austria need 100 runs in 18.0 remaining overs
LIVETodayMatch 6

Ratnagiri Jets WomenRatnagiri Jets Women

Pune Warriors Women151/8 (20 ov)

 Innings Break : Ratnagiri Jets Women elected to bowl
LIVETodayMatch 18

Eagle Thane StrikersEagle Thane Strikers

Arcs Andheri*102/1 (13.4 ov)

 Arcs Andheri elected to bat
LIVETodayMatch 6

Orange TigersOrange Tigers

Nagpur Titans*85/3 (11.3 ov)

 Orange Tigers elected to bowl
LIVETodayMatch 2

JMD Kutch RidersJMD Kutch Riders*64/4 (8.2 ov)

Zalwad Strikers

 JMD Kutch Riders elected to bat
LIVETodayMatch 5

Scorchers WomenScorchers Women

Dragons Women*26/2 (2.3 ov)

 Scorchers Women elected to bowl
LIVETodayMatch 4

Siechem Madurai PanthersSiechem Madurai Panthers*54/1 (7 ov)

Salem Spartans

 Salem Spartans elected to bowl
LIVETodayMatch 77

ScotlandScotland*16/1 (3.4 ov)

Nepal

 Scotland elected to bat
ScheduledTodayMatch 16

Warwickshire WomenWarwickshire Women

Lancashire Women

 
Scheduled08 June Match 23

Nigeria WomenNigeria Women

Sierra Leone Women

 
Scheduled08 June Match 24

Rwanda WomenRwanda Women

Zimbabwe HPC Women

 
Scheduled08 June Match 33

LancashireLancashire

Northamptonshire

 
Scheduled08 June Match 19

North Mumbai PanthersNorth Mumbai Panthers

Triumph Knights MNE

 
Scheduled08 June Match 2

CzechiaCzechia

Norway

 
Scheduled08 June Match 35

EssexEssex

Middlesex

 
Scheduled08 June Match 17

Surrey WomenSurrey Women

Durham Women

 
CricDirect Cricket News, Results and Stats
 

Derval Green

NationalityWest Indies
RoleBowler
Born04 Dec 1988 (36)
Batting StyleRight Hand Bat
Bowling StyleRight Arm Medium Fast

Batting

Format MAT INNS NO RUNS HS AVG BF SR 100s 50s
T20I 4 4 2 42 17 21.00 45 93.33 - -
List A 24 20 3 158 32 9.29 273 57.87 - -
1st Class 42 75 9 1337 86 20.25 2246 59.52 - 5

Bowling

Format MAT INNS OVR RUNS WK BBI AVG ECN SR 4W 5W
T20 4 4 12 126 3 2/23 42.00 10.50 24.0 - -
List A 24 24 171.5 960 23 4/44 41.73 5.58 44.8 1 -
1st Class 42 77 928.2 2893 113 5/30 25.60 3.11 49.2 4 3
× Close