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:3ce56aa7-5715-452d-80d7-d1d693f9cca7 Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 121538 AND DataTypeId = 6) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (121538,6,'{"status":"ok","response":{"player":{"pid":121538,"title":"Samay Shrivastava","short_name":"S Shrivastava","first_name":"Samay Shrivastava","last_name":"","middle_name":"","birthdate":"1991-03-13","birthplace":"","country":"om","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/samayshrivastav13\/","debut_data":"","thumb_url":"","nationality":"Oman"},"batting":{"odi":{"match_id":0,"inning_id":0,"matches":10,"innings":4,"notout":2,"runs":16,"balls":40,"highest":7,"run100":0,"run50":0,"run4":2,"run6":0,"average":"8.00","strike":"40.00","catches":4,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20i":{"match_id":0,"inning_id":0,"matches":15,"innings":4,"notout":3,"runs":36,"balls":35,"highest":22,"run100":0,"run50":0,"run4":2,"run6":1,"average":"36.00","strike":"102.85","catches":1,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20":{"match_id":0,"inning_id":0,"matches":18,"innings":5,"notout":4,"runs":38,"balls":38,"highest":22,"run100":0,"run50":0,"run4":2,"run6":1,"average":"38.00","strike":"100.00","catches":2,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":13,"innings":7,"notout":2,"runs":28,"balls":67,"highest":9,"run100":0,"run50":0,"run4":2,"run6":0,"average":"5.60","strike":"41.79","catches":5,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t10":{"match_id":"0","inning_id":"0","matches":"12","innings":"4","notout":"3","runs":"14","balls":"20","highest":"7","run100":"0","run50":"0","run4":"1","run6":"0","average":"14.00","strike":"70.00","catches":"3","stumpings":"0"}},"bowling":{"odi":{"match_id":0,"inning_id":0,"matches":10,"innings":10,"balls":444,"overs":74,"runs":376,"wickets":23,"bestinning":"4\/25","bestmatch":"4\/25","econ":"5.08","average":"16.34","strike":"19.3","wicket4i":2,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20i":{"match_id":0,"inning_id":0,"matches":15,"innings":15,"balls":252,"overs":42,"runs":316,"wickets":15,"bestinning":"5\/18","bestmatch":"5\/18","econ":"7.52","average":"21.06","strike":"16.8","wicket4i":0,"wicket5i":1,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20":{"match_id":0,"inning_id":0,"matches":18,"innings":18,"balls":294,"overs":49,"runs":370,"wickets":16,"bestinning":"5\/18","bestmatch":"5\/18","econ":"7.55","average":"23.12","strike":"18.3","wicket4i":0,"wicket5i":1,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":13,"innings":13,"balls":564,"overs":94,"runs":481,"wickets":27,"bestinning":"4\/25","bestmatch":"4\/25","econ":"5.11","average":"17.81","strike":"20.8","wicket4i":2,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t10":{"match_id":"0","inning_id":"0","matches":"12","innings":"12","balls":"144","overs":"24","runs":"196","wickets":"16","bestinning":"3\/6","bestmatch":"3\/6","econ":"8.17","average":"12.25","strike":"9.00","wicket4i":"0","wicket5i":"0","wicket10m":"0"}}},"etag":"d3171a23983080cefee7b075df3194e6","modified":"2025-06-21 17:15:03","datetime":"2025-06-21 17:15:03","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"player":{"pid":121538,"title":"Samay Shrivastava","short_name":"S Shrivastava","first_name":"Samay Shrivastava","last_name":"","middle_name":"","birthdate":"1991-03-13","birthplace":"","country":"om","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/samayshrivastav13\/","debut_data":"","thumb_url":"","nationality":"Oman"},"batting":{"odi":{"match_id":0,"inning_id":0,"matches":10,"innings":4,"notout":2,"runs":16,"balls":40,"highest":7,"run100":0,"run50":0,"run4":2,"run6":0,"average":"8.00","strike":"40.00","catches":4,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20i":{"match_id":0,"inning_id":0,"matches":15,"innings":4,"notout":3,"runs":36,"balls":35,"highest":22,"run100":0,"run50":0,"run4":2,"run6":1,"average":"36.00","strike":"102.85","catches":1,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20":{"match_id":0,"inning_id":0,"matches":18,"innings":5,"notout":4,"runs":38,"balls":38,"highest":22,"run100":0,"run50":0,"run4":2,"run6":1,"average":"38.00","strike":"100.00","catches":2,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":13,"innings":7,"notout":2,"runs":28,"balls":67,"highest":9,"run100":0,"run50":0,"run4":2,"run6":0,"average":"5.60","strike":"41.79","catches":5,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t10":{"match_id":"0","inning_id":"0","matches":"12","innings":"4","notout":"3","runs":"14","balls":"20","highest":"7","run100":"0","run50":"0","run4":"1","run6":"0","average":"14.00","strike":"70.00","catches":"3","stumpings":"0"}},"bowling":{"odi":{"match_id":0,"inning_id":0,"matches":10,"innings":10,"balls":444,"overs":74,"runs":376,"wickets":23,"bestinning":"4\/25","bestmatch":"4\/25","econ":"5.08","average":"16.34","strike":"19.3","wicket4i":2,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20i":{"match_id":0,"inning_id":0,"matches":15,"innings":15,"balls":252,"overs":42,"runs":316,"wickets":15,"bestinning":"5\/18","bestmatch":"5\/18","econ":"7.52","average":"21.06","strike":"16.8","wicket4i":0,"wicket5i":1,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20":{"match_id":0,"inning_id":0,"matches":18,"innings":18,"balls":294,"overs":49,"runs":370,"wickets":16,"bestinning":"5\/18","bestmatch":"5\/18","econ":"7.55","average":"23.12","strike":"18.3","wicket4i":0,"wicket5i":1,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":13,"innings":13,"balls":564,"overs":94,"runs":481,"wickets":27,"bestinning":"4\/25","bestmatch":"4\/25","econ":"5.11","average":"17.81","strike":"20.8","wicket4i":2,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t10":{"match_id":"0","inning_id":"0","matches":"12","innings":"12","balls":"144","overs":"24","runs":"196","wickets":"16","bestinning":"3\/6","bestmatch":"3\/6","econ":"8.17","average":"12.25","strike":"9.00","wicket4i":"0","wicket5i":"0","wicket10m":"0"}}},"etag":"d3171a23983080cefee7b075df3194e6","modified":"2025-06-21 17:15:03","datetime":"2025-06-21 17:15:03","api_version":"3.0"}', Modified = GetDate() WHERE Id = 121538 AND DataTypeId = 6 END
Player profile of Samay Shrivastava, Oman
<>
LIVE06 May Match 5

Hong Kong WomenHong Kong Women

Kuwait Women

 
LIVE06 May Match 6

Thailand WomenThailand Women

United Arab Emirates Women

 
LIVEToday1st Test

EnglandEngland*147/2 (36.4 ov)

India471/10 (113 ov)

 Day 2 - Session 3, England trail by 324 runs.
LIVETodayMatch 13

Alembic WarriorsAlembic Warriors*30/3 (3.3 ov)

A4 Power Strikers124/4 (10 ov)

 Alembic Warriors need 95 runs in 39 remaining balls
LIVETodayQualifier 2

Puneri BappaPuneri Bappa*82/7 (16 ov)

Raigad Royals133/9 (20 ov)

 Puneri Bappa need 52 runs in 24 remaining balls
LIVETodayMatch 1

West Indies AcademyWest Indies Academy237/10 (46.2 ov)

Sri Lanka Emerging*0/0 ( ov)

 Innings Break : Sri Lanka Emerging need 238 runs in 50 remaining overs
LIVETodayMatch 18

Lyca Kovai KingsLyca Kovai Kings165/6 (20 ov)

Nellai Royal Kings*93/8 (15.5 ov)

 Nellai Royal Kings need 73 runs in 25 remaining balls
LIVETodayMatch 19

Rewa JaguarsRewa Jaguars226/8 (20 ov)

Indore Pink Panthers*104/4 (9.5 ov)

 Indore Pink Panthers need 123 runs in 10.1 remaining overs
LIVETodayMatch 31

Bess Motors Blue DevilsBess Motors Blue Devils

SAMP Army Cocrico Cavaliers*60/3 (7.4 ov)

 Bess Motors Blue Devils elected to bowl
CancelledTodayMatch 12

Diamond DazzlersDiamond Dazzlers121/8 (20 ov)

Pruthvi Panthers

 Match Abandoned
ScheduledTodayMatch 9

Thunder Cats-BThunder Cats-B

Lexus

 
Scheduled21 June Match 32

Chicago Steelpan PlayersChicago Steelpan Players

Soca Kings

 
Scheduled21 June Match 10

Cayman IslandsCayman Islands

Bermuda

 
Scheduled22 June Match 11

MI New YorkMI New York

Washington Freedom

 
Scheduled22 June Match 15

Irises Cricket ClubIrises Cricket Club

Yuksom Capitals

 
Scheduled22 June Match 21

Adamas Howrah Warriors WomensAdamas Howrah Warriors Womens

Servotech Siliguri Strikers Womens

 
Scheduled22 June Eliminator

Brno CCBrno CC

Bohemians

 
Scheduled22 June Match 16

Black Eagle SAPBlack Eagle SAP

Avengers CC

 
Scheduled22 June Match 22

Murshidabad KingsMurshidabad Kings

Rashmi Medinipur Wizards

 
Scheduled22 June Match 3

Bhopal Wolves WomenBhopal Wolves Women

Bundelkhand Bulls Women

 
CricDirect Cricket News, Results and Stats
 

Samay Shrivastava

NationalityOman
RoleBowler
Born13 Mar 1991 (34)
Batting StyleRight Hand Bat
Bowling StyleRight Arm Leg Spin

Batting

Format MAT INNS NO RUNS HS AVG BF SR 100s 50s
ODI 10 4 2 16 7 8.00 40 40.00 - -
T20I 15 4 3 36 22 36.00 35 102.85 - -
T20I 18 5 4 38 22 38.00 38 100.00 - -
List A 13 7 2 28 9 5.60 67 41.79 - -

Bowling

Format MAT INNS OVR RUNS WK BBI AVG ECN SR 4W 5W
ODI 10 10 74 376 23 4/25 16.34 5.08 19.3 2 -
T20i 15 15 42 316 15 5/18 21.06 7.52 16.8 - 1
T20 18 18 49 370 16 5/18 23.12 7.55 18.3 - 1
List A 13 13 94 481 27 4/25 17.81 5.11 20.8 2 -
× Close