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:e70ca2cf-eb24-4ca7-8858-057dbcb48263 Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 90474 AND DataTypeId = 6) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (90474,6,'{"status":"ok","response":{"player":{"pid":90474,"title":"Prerak Mankad","short_name":"PN Mankad","first_name":"Prerak Mankad","last_name":"","middle_name":"","birthdate":"1994-04-23","birthplace":"Sirohi, Saurashtra","country":"in","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":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/prerakmankad\/","debut_data":"","thumb_url":"","nationality":"India"},"batting":{"t20":{"match_id":0,"inning_id":0,"matches":55,"innings":50,"notout":10,"runs":1192,"balls":829,"highest":72,"run100":0,"run50":9,"run4":122,"run6":43,"average":"29.80","strike":"143.78","catches":27,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":60,"innings":53,"notout":6,"runs":1667,"balls":1648,"highest":174,"run100":4,"run50":7,"run4":181,"run6":38,"average":"35.46","strike":"101.15","catches":30,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":62,"innings":99,"notout":12,"runs":2771,"balls":4554,"highest":173,"run100":3,"run50":17,"run4":338,"run6":12,"average":"31.85","strike":"60.84","catches":70,"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":{"t20":{"match_id":0,"inning_id":0,"matches":55,"innings":41,"balls":621,"overs":103.3,"runs":881,"wickets":30,"bestinning":"4\/48","bestmatch":"4\/48","econ":"8.51","average":"29.36","strike":"20.7","wicket4i":1,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":60,"innings":50,"balls":1714,"overs":285.4,"runs":1260,"wickets":48,"bestinning":"4\/32","bestmatch":"4\/32","econ":"4.41","average":"26.25","strike":"35.7","wicket4i":2,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":62,"innings":82,"balls":4570,"overs":761.4,"runs":2083,"wickets":54,"bestinning":"3\/13","bestmatch":"5\/83","econ":"2.73","average":"38.57","strike":"84.6","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":"1aeb19b3a51ba705de99e57668a5982a","modified":"2025-06-13 17:23:45","datetime":"2025-06-13 17:23:45","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"player":{"pid":90474,"title":"Prerak Mankad","short_name":"PN Mankad","first_name":"Prerak Mankad","last_name":"","middle_name":"","birthdate":"1994-04-23","birthplace":"Sirohi, Saurashtra","country":"in","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":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/prerakmankad\/","debut_data":"","thumb_url":"","nationality":"India"},"batting":{"t20":{"match_id":0,"inning_id":0,"matches":55,"innings":50,"notout":10,"runs":1192,"balls":829,"highest":72,"run100":0,"run50":9,"run4":122,"run6":43,"average":"29.80","strike":"143.78","catches":27,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":60,"innings":53,"notout":6,"runs":1667,"balls":1648,"highest":174,"run100":4,"run50":7,"run4":181,"run6":38,"average":"35.46","strike":"101.15","catches":30,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":62,"innings":99,"notout":12,"runs":2771,"balls":4554,"highest":173,"run100":3,"run50":17,"run4":338,"run6":12,"average":"31.85","strike":"60.84","catches":70,"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":{"t20":{"match_id":0,"inning_id":0,"matches":55,"innings":41,"balls":621,"overs":103.3,"runs":881,"wickets":30,"bestinning":"4\/48","bestmatch":"4\/48","econ":"8.51","average":"29.36","strike":"20.7","wicket4i":1,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":60,"innings":50,"balls":1714,"overs":285.4,"runs":1260,"wickets":48,"bestinning":"4\/32","bestmatch":"4\/32","econ":"4.41","average":"26.25","strike":"35.7","wicket4i":2,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":62,"innings":82,"balls":4570,"overs":761.4,"runs":2083,"wickets":54,"bestinning":"3\/13","bestmatch":"5\/83","econ":"2.73","average":"38.57","strike":"84.6","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":"1aeb19b3a51ba705de99e57668a5982a","modified":"2025-06-13 17:23:45","datetime":"2025-06-13 17:23:45","api_version":"3.0"}', Modified = GetDate() WHERE Id = 90474 AND DataTypeId = 6 END
Player profile of Prerak Mankad, India
<>
LIVE06 May Match 5

Hong Kong WomenHong Kong Women

Kuwait Women

 
LIVE06 May Match 6

Thailand WomenThailand Women

United Arab Emirates Women

 
LIVETodayFinal

South AfricaSouth Africa138/10 (57.1 ov) & *213/2 (56 ov)

Australia212/10 (56.4 ov) & 207/10 (65 ov)

 Stumps : Day 3 - South Africa need 69 runs to win.
LIVETodayMatch 9

IDream Tiruppur TamizhansIDream Tiruppur Tamizhans177/8 (20 ov)

Salem Spartans*148/6 (18.1 ov)

 Salem Spartans need 30 runs in 11 remaining balls
LIVETodayMatch 3

Bundelkhand BullsBundelkhand Bulls

Rewa Jaguars*15/0 (1 ov)

 Bundelkhand Bulls elected to bowl
LIVETodayMatch 11

Zalwad StrikersZalwad Strikers*154/4 (19.1 ov)

Anmol Kings Halar153/5 (20 ov)

 Match completed
LIVEToday2nd Semi-Final

Pagariya StrikersPagariya Strikers*63/5 (12 ov)

Orange Tigers132/10 (19.2 ov)

 Pagariya Strikers need 70 runs in 48 remaining balls
LIVETodayMatch 1

YSSCYSSC186/9 (20 ov)

Phoenix Cricketers*61/4 (8.5 ov)

 Phoenix Cricketers need 126 runs in 11.1 remaining overs
LIVETodayFinal

Old BrentwoodsOld Brentwoods*95/6 (7.4 ov)

Sharks Cricket Academy180/3 (10 ov)

 Old Brentwoods need 86 runs in 14 remaining balls
LIVETodayMatch 9

Soca KingsSoca Kings*0/2 (0.2 ov)

Leatherback Strikers75/3 (10 ov)

 Soca Kings need 76 runs in 58 remaining balls
LIVETodayMatch 48

WorcestershireWorcestershire*81/5 (11 ov)

Lancashire

 Worcestershire elected to bat
LIVETodayMatch 45

NorthamptonshireNorthamptonshire

Durham

 
LIVETodayMatch 46

NottinghamshireNottinghamshire

Derbyshire

 
LIVETodayMatch 49

YorkshireYorkshire

Warwickshire

 
LIVETodayMatch 21

Durham WomenDurham Women

The Blaze

 
LIVETodayMatch 22

Somerset WomenSomerset Women

Lancashire Women

 
CancelledTodayMatch 2

Jabalpur LionsJabalpur Lions

Bhopal Leopards130/6 (16.0 ov)

 Match Abandoned
CancelledTodayMatch 16

Ratnagiri JetsRatnagiri Jets

Kolhapur Tuskers

 Match Abandoned
ScheduledTodayMatch 43

GloucestershireGloucestershire

Somerset

 
ScheduledTodayMatch 44

HampshireHampshire

Middlesex

 
CricDirect Cricket News, Results and Stats
 

Prerak Mankad

NationalityIndia
RoleBatter
Born23 Apr 1994 (31)
Batting StyleRight Hand Bat
Bowling StyleRight Arm Medium

Batting

Format MAT INNS NO RUNS HS AVG BF SR 100s 50s
T20I 55 50 10 1192 72 29.80 829 143.78 - 9
List A 60 53 6 1667 174 35.46 1648 101.15 4 7
1st Class 62 99 12 2771 173 31.85 4554 60.84 3 17

Bowling

Format MAT INNS OVR RUNS WK BBI AVG ECN SR 4W 5W
T20 55 41 103.3 881 30 4/48 29.36 8.51 20.7 1 -
List A 60 50 285.4 1260 48 4/32 26.25 4.41 35.7 2 -
1st Class 62 82 761.4 2083 54 3/13 38.57 2.73 84.6 - -
× Close