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:f0a0cd71-0933-4904-ab1a-0e64eb7de9c9 Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 49847 AND DataTypeId = 6) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (49847,6,'{"status":"ok","response":{"player":{"pid":49847,"title":"Adil Amin","short_name":"Adil Amin","first_name":"Adil Amin","last_name":"","middle_name":"","birthdate":"1990-12-13","birthplace":"","country":"pk","primary_team":[],"logo_url":"","playing_role":"all","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":"Pakistan"},"batting":{"t20":{"match_id":0,"inning_id":0,"matches":82,"innings":68,"notout":18,"runs":1350,"balls":1189,"highest":75,"run100":0,"run50":3,"run4":110,"run6":36,"average":"27.00","strike":"113.54","catches":28,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":120,"innings":111,"notout":28,"runs":3868,"balls":4488,"highest":140,"run100":6,"run50":28,"run4":348,"run6":71,"average":"46.60","strike":"86.18","catches":38,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":93,"innings":147,"notout":10,"runs":4688,"balls":9392,"highest":211,"run100":6,"run50":26,"run4":580,"run6":22,"average":"34.21","strike":"49.91","catches":52,"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":82,"innings":40,"balls":630,"overs":105,"runs":771,"wickets":23,"bestinning":"4\/27","bestmatch":"4\/27","econ":"7.34","average":"33.52","strike":"27.3","wicket4i":1,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":120,"innings":77,"balls":2152,"overs":358.4,"runs":1949,"wickets":27,"bestinning":"2\/14","bestmatch":"2\/14","econ":"5.43","average":"72.18","strike":"79.7","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":93,"innings":85,"balls":2446,"overs":407.4,"runs":1179,"wickets":21,"bestinning":"5\/81","bestmatch":"5\/102","econ":"2.89","average":"56.14","strike":"116.4","wicket4i":1,"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":"6f24747bea37bbd0a9ebbf0f8afe39b4","modified":"2025-07-13 08:22:52","datetime":"2025-07-13 08:22:52","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"player":{"pid":49847,"title":"Adil Amin","short_name":"Adil Amin","first_name":"Adil Amin","last_name":"","middle_name":"","birthdate":"1990-12-13","birthplace":"","country":"pk","primary_team":[],"logo_url":"","playing_role":"all","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":"Pakistan"},"batting":{"t20":{"match_id":0,"inning_id":0,"matches":82,"innings":68,"notout":18,"runs":1350,"balls":1189,"highest":75,"run100":0,"run50":3,"run4":110,"run6":36,"average":"27.00","strike":"113.54","catches":28,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":120,"innings":111,"notout":28,"runs":3868,"balls":4488,"highest":140,"run100":6,"run50":28,"run4":348,"run6":71,"average":"46.60","strike":"86.18","catches":38,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":93,"innings":147,"notout":10,"runs":4688,"balls":9392,"highest":211,"run100":6,"run50":26,"run4":580,"run6":22,"average":"34.21","strike":"49.91","catches":52,"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":82,"innings":40,"balls":630,"overs":105,"runs":771,"wickets":23,"bestinning":"4\/27","bestmatch":"4\/27","econ":"7.34","average":"33.52","strike":"27.3","wicket4i":1,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":120,"innings":77,"balls":2152,"overs":358.4,"runs":1949,"wickets":27,"bestinning":"2\/14","bestmatch":"2\/14","econ":"5.43","average":"72.18","strike":"79.7","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":93,"innings":85,"balls":2446,"overs":407.4,"runs":1179,"wickets":21,"bestinning":"5\/81","bestmatch":"5\/102","econ":"2.89","average":"56.14","strike":"116.4","wicket4i":1,"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":"6f24747bea37bbd0a9ebbf0f8afe39b4","modified":"2025-07-13 08:22:52","datetime":"2025-07-13 08:22:52","api_version":"3.0"}', Modified = GetDate() WHERE Id = 49847 AND DataTypeId = 6 END
Player profile of Adil Amin, Pakistan
<>
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) & *2/0 (1 ov)

India387/10 (119.2 ov)

 Stumps : Day 3 - England lead by 2 runs.
LIVEToday1st Youth Test

England Under-19sEngland Under-19s

India Under-19s*450/7 (87.5 ov)

 Stumps : Day 1 - India Under-19s elected to bat
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 12

South KoreaSouth Korea115/9 (20 ov)

Indonesia*44/1 (5 ov)

 Indonesia need 72 runs in 15.0 remaining overs
LIVETodayMatch 5

Belgium Jeanekens-WBelgium Jeanekens-W*41/3 (6.2 ov)

French Eiffels-W84/4 (10 ov)

 Belgium Jeanekens-W need 44 runs in 22 remaining balls
LIVETodayFinal

GibraltarGibraltar*157/8 (17 ov)

Bulgaria

 Bulgaria elected to bowl
LIVETodayMatch 4

GermanyGermany0/0 ( ov)

Belgium186/8 (10 ov)

 Innings Break : Germany need 187 runs in 10 remaining overs
LIVEToday3rd place play-off

MalawiMalawi

Germany*125/3 (10.1 ov)

 Germany elected to bat
LIVETodayMatch 12

Gauhati Town ClubGauhati Town Club

Nabajyoti Club*20/1 (3.5 ov)

 Nabajyoti Club elected to bat
LIVETodayMatch 14

Karaikal KniightsKaraikal Kniights

Yanam Royals

  Karaikal Kniights elected to bowl
LIVETodayMatch 6

Belgium Belforts-WBelgium Belforts-W

Luxembourg Mullerthals-W

 Luxembourg Mullerthals-W elected to bowl
LIVETodayMatch 5

GermanyGermany

Belgium

 Belgium elected to bat
Scheduled13 July Match 50

Surrey WomenSurrey Women

Somerset Women

 
Scheduled13 July Match 58

Worcestershire WomenWorcestershire Women

Leicestershire Women

 
Scheduled13 July Match 48

Hampshire WomenHampshire Women

Warwickshire Women

 
Scheduled13 July Match 49

Lancashire WomenLancashire Women

Durham Women

 
Scheduled13 July Match 6

GermanyGermany

Belgium

 
CricDirect Cricket News, Results and Stats
 

Adil Amin

NationalityPakistan
RoleAll Rounder
Born13 Dec 1990 (34)
Batting StyleRight Hand Bat
Bowling StyleRight Arm Off Break

Batting

Format MAT INNS NO RUNS HS AVG BF SR 100s 50s
T20I 82 68 18 1350 75 27.00 1189 113.54 - 3
List A 120 111 28 3868 140 46.60 4488 86.18 6 28
1st Class 93 147 10 4688 211 34.21 9392 49.91 6 26

Bowling

Format MAT INNS OVR RUNS WK BBI AVG ECN SR 4W 5W
T20 82 40 105 771 23 4/27 33.52 7.34 27.3 1 -
List A 120 77 358.4 1949 27 2/14 72.18 5.43 79.7 - -
1st Class 93 85 407.4 1179 21 5/81 56.14 2.89 116.4 1 1
× Close