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:a835de01-8f91-4b1a-801f-21d15b9f4e8d Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 45515 AND DataTypeId = 6) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (45515,6,'{"status":"ok","response":{"player":{"pid":45515,"title":"Shahan Akram-I","short_name":"Shahan Akram-I","first_name":"Shahan Akram-I","last_name":"","middle_name":"","birthdate":"1994-05-20","birthplace":"","country":"pk","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"Pakistan"},"batting":{"t20":{"match_id":0,"inning_id":0,"matches":5,"innings":5,"notout":0,"runs":94,"balls":99,"highest":22,"run100":0,"run50":0,"run4":12,"run6":2,"average":"18.80","strike":"94.94","catches":3,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":2,"innings":2,"notout":0,"runs":41,"balls":52,"highest":28,"run100":0,"run50":0,"run4":4,"run6":0,"average":"20.50","strike":"78.84","catches":0,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":7,"innings":11,"notout":0,"runs":105,"balls":291,"highest":39,"run100":0,"run50":0,"run4":16,"run6":0,"average":"9.54","strike":"36.08","catches":1,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t10":{"match_id":"0","inning_id":"0","matches":"15","innings":"13","notout":"1","runs":"166","balls":"113","highest":"30","run100":"0","run50":"0","run4":"14","run6":"8","average":"13.83","strike":"146.90","catches":"8","stumpings":"0"}},"bowling":{"t20":{"match_id":0,"inning_id":0,"matches":5,"innings":1,"balls":18,"overs":3,"runs":19,"wickets":2,"bestinning":"2\/19","bestmatch":"2\/19","econ":"6.33","average":"9.50","strike":"9.0","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":2,"innings":0,"balls":0,"overs":0,"runs":0,"wickets":0,"bestinning":"","bestmatch":"","econ":"","average":"","strike":"","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":7,"innings":2,"balls":18,"overs":3,"runs":7,"wickets":0,"bestinning":"","bestmatch":"","econ":"2.33","average":"","strike":"","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t10":{"match_id":"0","inning_id":"0","matches":"15","innings":"1","balls":"6","overs":"1","runs":"18","wickets":"0","bestinning":"","bestmatch":"","econ":"18.00","average":"","strike":"","wicket4i":"0","wicket5i":"0","wicket10m":"0"}}},"etag":"f95711f3937c6b36ee60cd965085383d","modified":"2025-06-24 17:07:26","datetime":"2025-06-24 17:07:26","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"player":{"pid":45515,"title":"Shahan Akram-I","short_name":"Shahan Akram-I","first_name":"Shahan Akram-I","last_name":"","middle_name":"","birthdate":"1994-05-20","birthplace":"","country":"pk","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"Pakistan"},"batting":{"t20":{"match_id":0,"inning_id":0,"matches":5,"innings":5,"notout":0,"runs":94,"balls":99,"highest":22,"run100":0,"run50":0,"run4":12,"run6":2,"average":"18.80","strike":"94.94","catches":3,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":2,"innings":2,"notout":0,"runs":41,"balls":52,"highest":28,"run100":0,"run50":0,"run4":4,"run6":0,"average":"20.50","strike":"78.84","catches":0,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":7,"innings":11,"notout":0,"runs":105,"balls":291,"highest":39,"run100":0,"run50":0,"run4":16,"run6":0,"average":"9.54","strike":"36.08","catches":1,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t10":{"match_id":"0","inning_id":"0","matches":"15","innings":"13","notout":"1","runs":"166","balls":"113","highest":"30","run100":"0","run50":"0","run4":"14","run6":"8","average":"13.83","strike":"146.90","catches":"8","stumpings":"0"}},"bowling":{"t20":{"match_id":0,"inning_id":0,"matches":5,"innings":1,"balls":18,"overs":3,"runs":19,"wickets":2,"bestinning":"2\/19","bestmatch":"2\/19","econ":"6.33","average":"9.50","strike":"9.0","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":2,"innings":0,"balls":0,"overs":0,"runs":0,"wickets":0,"bestinning":"","bestmatch":"","econ":"","average":"","strike":"","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":7,"innings":2,"balls":18,"overs":3,"runs":7,"wickets":0,"bestinning":"","bestmatch":"","econ":"2.33","average":"","strike":"","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t10":{"match_id":"0","inning_id":"0","matches":"15","innings":"1","balls":"6","overs":"1","runs":"18","wickets":"0","bestinning":"","bestmatch":"","econ":"18.00","average":"","strike":"","wicket4i":"0","wicket5i":"0","wicket10m":"0"}}},"etag":"f95711f3937c6b36ee60cd965085383d","modified":"2025-06-24 17:07:26","datetime":"2025-06-24 17:07:26","api_version":"3.0"}', Modified = GetDate() WHERE Id = 45515 AND DataTypeId = 6 END
Player profile of Shahan Akram-I, Pakistan
<>
LIVE06 May Match 5

Hong Kong WomenHong Kong Women

Kuwait Women

 
LIVE06 May Match 6

Thailand WomenThailand Women

United Arab Emirates Women

 
LIVEToday1st Test

EnglandEngland465/10 (100.4 ov) & *341/5 (76.5 ov)

India471/10 (113 ov) & 364/10 (96 ov)

 Day 5 - Session 3, England need 30 runs to win.
LIVEToday36th Match

DurhamDurham327/10 (106 ov)

Sussex361/10 (106.5 ov) & *111/4 (37 ov)

 Day 3 - Sussex lead by 145 runs.
LIVEToday40th Match

NottinghamshireNottinghamshire487/10 (132.4 ov)

Yorkshire*408/6 (147 ov)

 Day 3 - Yorkshire trail by 79 runs.
LIVEToday38th Match

WarwickshireWarwickshire351/10 (121.1 ov)

Somerset498/10 (133.3 ov) & *40/2 (13.5 ov)

 Day 3 - Somerset lead by 187 runs.
LIVEToday37th Match

EssexEssex296/10 (98.1 ov) & *94/3 (41 ov)

Hampshire453/10 (138.1 ov)

 Day 3 - Essex trail by 63 runs.
LIVETodayMatch 32

LancashireLancashire*481/4 (123 ov)

Kent374/10 (123.2 ov)

 Day 3 - Lancashire lead by 107 runs.
LIVEToday31st Match

GloucestershireGloucestershire187/10 (59.2 ov) & *334/3 (108.4 ov)

Derbyshire398/10 (105.5 ov)

 Day 3 - Gloucestershire lead by 123 runs.
LIVEToday30th Match

LeicestershireLeicestershire576/7d (129 ov)

Glamorgan353/10 (110.2 ov) & *107/3 (35 ov)

 Day 3 - Glamorgan trail by 116 runs.
LIVEToday29th Match

NorthamptonshireNorthamptonshire435/10 (125.2 ov)

Middlesex413/10 (101 ov) & *209/3 (55 ov)

 Day 3 - Middlesex lead by 187 runs.
LIVETodayOther OD

ECB Women Development XIECB Women Development XI353/5 (50 ov)

India Women*300/8 (45.3 ov)

 India Women need 54 runs in 27 remaining balls
LIVETodayMatch 19

Pruthvi PanthersPruthvi Panthers

Ami Super Avengers*14/0 (1.1 ov)

 Pruthvi Panthers elected to bowl
LIVETodayMatch 27

Sobisco Smashers MaldaSobisco Smashers Malda*105/6 (15.5 ov)

Rashmi Medinipur Wizards158/7 (20 ov)

 Sobisco Smashers Malda need 54 runs in 25 remaining balls
LIVETodayMatch 2

West Indies AcademyWest Indies Academy*245/5 (44.3 ov)

Sri Lanka Emerging

 Sri Lanka Emerging elected to bowl
LIVETodayFinal

Bhopal LeopardsBhopal Leopards156/10 (19.2 ov)

Chamble Ghariyals*26/4 (5.1 ov)

 Chamble Ghariyals need 131 runs in 14.5 remaining overs
LIVETodayMatch 8

Leinster LightningLeinster Lightning*48/2 (5.5 ov)

Munster Reds122/9 (20 ov)

 Leinster Lightning need 75 runs in 14.1 remaining overs
LIVETodayMatch 1

Iyanola HeritageIyanola Heritage

Amazonian Warriors91/5 (10 ov)

 Innings Break : Iyanola Heritage elected to bowl
Cancelled24 June Match 19

Irises Cricket ClubIrises Cricket Club120/4 (18 ov)

Avengers CC21/0 (2.1 ov)

 Match abandoned due to rain
CancelledTodayMatch 7

Gymkhana GladiatorsGymkhana Gladiators

SKK Rapids0/0 ( ov)

 Match abandoned due to rain
CricDirect Cricket News, Results and Stats
 

Shahan Akram-I

NationalityPakistan
Role
Born20 May 1994 (31)
Batting StyleRight Hand Bat
Bowling StyleRight Arm Fast

Batting

Format MAT INNS NO RUNS HS AVG BF SR 100s 50s
T20I 5 5 - 94 22 18.80 99 94.94 - -
List A 2 2 - 41 28 20.50 52 78.84 - -
1st Class 7 11 - 105 39 9.54 291 36.08 - -

Bowling

Format MAT INNS OVR RUNS WK BBI AVG ECN SR 4W 5W
T20 5 1 3 19 2 2/19 9.50 6.33 9.0 - -
List A 2 - - - - - - - - - -
1st Class 7 2 3 7 - - - 2.33 - - -
× Close