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:3959349b-611b-4ea5-aa97-b09911920051 Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 68851 AND DataTypeId = 6) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (68851,6,'{"status":"ok","response":{"player":{"pid":68851,"title":"Pradeep Kumara","short_name":"P Kumara","first_name":"Pradeep Kumara","last_name":"","middle_name":"","birthdate":"1980-07-09","birthplace":"","country":"lk","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","nationality":"Sri Lanka"},"batting":{"t20i":{"match_id":0,"inning_id":0,"matches":7,"innings":0,"notout":0,"runs":0,"balls":0,"highest":0,"run100":0,"run50":0,"run4":0,"run6":0,"average":"","strike":"","catches":3,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20":{"match_id":0,"inning_id":0,"matches":4,"innings":4,"notout":1,"runs":26,"balls":35,"highest":15,"run100":0,"run50":0,"run4":0,"run6":0,"average":"8.66","strike":"74.28","catches":0,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":33,"innings":28,"notout":7,"runs":279,"balls":0,"highest":29,"run100":0,"run50":0,"run4":0,"run6":0,"average":"13.28","strike":"","catches":9,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":13,"innings":23,"notout":4,"runs":244,"balls":0,"highest":31,"run100":0,"run50":0,"run4":0,"run6":0,"average":"12.84","strike":"","catches":7,"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":{"t20i":{"match_id":0,"inning_id":0,"matches":7,"innings":7,"balls":156,"overs":26,"runs":208,"wickets":5,"bestinning":"2\/26","bestmatch":"2\/26","econ":"8.00","average":"41.60","strike":"31.2","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20":{"match_id":0,"inning_id":0,"matches":4,"innings":3,"balls":60,"overs":10,"runs":84,"wickets":3,"bestinning":"1\/21","bestmatch":"1\/21","econ":"8.40","average":"28.00","strike":"20.00","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":33,"innings":0,"balls":459,"overs":76.3,"runs":368,"wickets":11,"bestinning":"2\/15","bestmatch":"2\/15","econ":"4.81","average":"33.45","strike":"41.70","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":13,"innings":0,"balls":699,"overs":116.3,"runs":476,"wickets":15,"bestinning":"5\/95","bestmatch":"","econ":"4.08","average":"31.73","strike":"46.6","wicket4i":0,"wicket5i":1,"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":"1918a9d30e9eff13458b5a0478bc3687","modified":"2025-07-13 14:19:10","datetime":"2025-07-13 14:19:10","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"player":{"pid":68851,"title":"Pradeep Kumara","short_name":"P Kumara","first_name":"Pradeep Kumara","last_name":"","middle_name":"","birthdate":"1980-07-09","birthplace":"","country":"lk","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","nationality":"Sri Lanka"},"batting":{"t20i":{"match_id":0,"inning_id":0,"matches":7,"innings":0,"notout":0,"runs":0,"balls":0,"highest":0,"run100":0,"run50":0,"run4":0,"run6":0,"average":"","strike":"","catches":3,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20":{"match_id":0,"inning_id":0,"matches":4,"innings":4,"notout":1,"runs":26,"balls":35,"highest":15,"run100":0,"run50":0,"run4":0,"run6":0,"average":"8.66","strike":"74.28","catches":0,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":33,"innings":28,"notout":7,"runs":279,"balls":0,"highest":29,"run100":0,"run50":0,"run4":0,"run6":0,"average":"13.28","strike":"","catches":9,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":13,"innings":23,"notout":4,"runs":244,"balls":0,"highest":31,"run100":0,"run50":0,"run4":0,"run6":0,"average":"12.84","strike":"","catches":7,"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":{"t20i":{"match_id":0,"inning_id":0,"matches":7,"innings":7,"balls":156,"overs":26,"runs":208,"wickets":5,"bestinning":"2\/26","bestmatch":"2\/26","econ":"8.00","average":"41.60","strike":"31.2","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20":{"match_id":0,"inning_id":0,"matches":4,"innings":3,"balls":60,"overs":10,"runs":84,"wickets":3,"bestinning":"1\/21","bestmatch":"1\/21","econ":"8.40","average":"28.00","strike":"20.00","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":33,"innings":0,"balls":459,"overs":76.3,"runs":368,"wickets":11,"bestinning":"2\/15","bestmatch":"2\/15","econ":"4.81","average":"33.45","strike":"41.70","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":13,"innings":0,"balls":699,"overs":116.3,"runs":476,"wickets":15,"bestinning":"5\/95","bestmatch":"","econ":"4.08","average":"31.73","strike":"46.6","wicket4i":0,"wicket5i":1,"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":"1918a9d30e9eff13458b5a0478bc3687","modified":"2025-07-13 14:19:10","datetime":"2025-07-13 14:19:10","api_version":"3.0"}', Modified = GetDate() WHERE Id = 68851 AND DataTypeId = 6 END
Player profile of Pradeep Kumara, Sri Lanka
<>
LIVE06 May Match 5

Hong Kong WomenHong Kong Women

Kuwait Women

 
LIVE06 May Match 6

Thailand WomenThailand Women

United Arab Emirates Women

 
LIVEToday3rd Test

EnglandEngland387/10 (112.3 ov) & *161/5 (45.3 ov)

India387/10 (119.2 ov)

 Day 4 - Session 2, England lead by 161 runs.
LIVEToday1st Youth Test

England Under-19sEngland Under-19s*85/2 (20 ov)

India Under-19s540/10 (112.5 ov)

 Day 2 - England Under-19s trail by 455 runs.
LIVEToday3rd Test

West IndiesWest Indies*16/1 (9 ov)

Australia225/10 (70.3 ov)

 Stumps : Day 1 - West Indies trail by 209 runs.
LIVEToday1st Unofficial Test

Australia AAustralia A

Sri Lanka A272/10 (82 ov)

 Stumps : Day 1 - Australia A elected to bowl
LIVETodayMatch 15

Villianur Mohit KingsVillianur Mohit Kings216/6 (20 ov)

Ossudu Accord Warriors

 Innings Break : Villianur Mohit Kings elected to bat
LIVETodayMatch 47

Essex WomenEssex Women

The Blaze Women*138/7 (19 ov)

 The Blaze Women elected to bat
LIVETodayMatch 7

GermanyGermany

Belgium*125/1 (6 ov)

 Germany elected to bowl
LIVETodayMatch 106

WorcestershireWorcestershire

Leicestershire*79/4 (11 ov)

 Leicestershire elected to bat
LIVEToday2nd T20I

Sri LankaSri Lanka

Bangladesh*74/2 (10.5 ov)

 Sri Lanka elected to bowl
LIVETodayMatch 105

YorkshireYorkshire*17/3 (4 ov)

Derbyshire

 Derbyshire elected to bowl
LIVETodayMatch 108

LancashireLancashire

Durham*32/1 (4 ov)

 Durham elected to bat
LIVETodayMatch 110

HampshireHampshire

Sussex*31/0 (4 ov)

 Sussex elected to bat
LIVETodayMatch 111

GlamorganGlamorgan

Gloucestershire*30/2 (4.1 ov)

 Gloucestershire elected to bat
LIVETodayMatch 112

WarwickshireWarwickshire

Northamptonshire*52/0 (3.5 ov)

 Northamptonshire elected to bat
LIVETodayMatch 5

Hobart HurricanesHobart Hurricanes

Rangpur Riders*24/1 (3.4 ov)

 Hobart Hurricanes elected to bowl
ScheduledTodayMatch 107

SurreySurrey

Somerset

 
ScheduledTodayFinal

French Eiffels-WFrench Eiffels-W

Luxembourg Mullerthals-W

 
ScheduledTodayMatch 109

KentKent

Middlesex

 
CricDirect Cricket News, Results and Stats
 

Pradeep Kumara

NationalitySri Lanka
RoleBatter
Born09 Jul 1980 (45)
Batting StyleRight Hand Bat
Bowling StyleRight Arm Off Break

Batting

Format MAT INNS NO RUNS HS AVG BF SR 100s 50s
T20I 7 - - - - - - - - -
T20I 4 4 1 26 15 8.66 35 74.28 - -
List A 33 28 7 279 29 13.28 - - - -
1st Class 13 23 4 244 31 12.84 - - - -

Bowling

Format MAT INNS OVR RUNS WK BBI AVG ECN SR 4W 5W
T20i 7 7 26 208 5 2/26 41.60 8.00 31.2 - -
T20 4 3 10 84 3 1/21 28.00 8.40 20.00 - -
List A 33 - 76.3 368 11 2/15 33.45 4.81 41.70 - -
1st Class 13 - 116.3 476 15 5/95 31.73 4.08 46.6 - 1
× Close