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:251d1ffc-9a03-4b39-840d-db281f686b2e Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 83397 AND DataTypeId = 6) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (83397,6,'{"status":"ok","response":{"player":{"pid":83397,"title":"Rushab Patel","short_name":"RN Patel","first_name":"Rushab Patel","last_name":"","middle_name":"","birthdate":"1993-06-29","birthplace":"","country":"ke","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","nationality":"Kenya"},"batting":{"t20i":{"match_id":0,"inning_id":0,"matches":34,"innings":32,"notout":6,"runs":586,"balls":484,"highest":63,"run100":0,"run50":1,"run4":62,"run6":12,"average":"22.53","strike":"121.07","catches":19,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20":{"match_id":0,"inning_id":0,"matches":40,"innings":37,"notout":6,"runs":643,"balls":549,"highest":63,"run100":0,"run50":1,"run4":64,"run6":15,"average":"20.74","strike":"117.12","catches":21,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":24,"innings":23,"notout":3,"runs":529,"balls":750,"highest":99,"run100":0,"run50":3,"run4":51,"run6":3,"average":"26.45","strike":"70.53","catches":9,"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":34,"innings":4,"balls":32,"overs":5.2,"runs":34,"wickets":4,"bestinning":"2\/7","bestmatch":"2\/7","econ":"6.37","average":"8.50","strike":"8.0","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20":{"match_id":0,"inning_id":0,"matches":40,"innings":5,"balls":38,"overs":6.2,"runs":45,"wickets":4,"bestinning":"2\/7","bestmatch":"2\/7","econ":"7.10","average":"11.25","strike":"9.5","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":24,"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},"t10":{"match_id":"0","inning_id":"0","matches":"0","innings":"","balls":"","overs":"0","runs":"","wickets":"","bestinning":"","bestmatch":"","econ":"","average":"","strike":"","wicket4i":"","wicket5i":"","wicket10m":""}}},"etag":"a2caa46ff233e4adff55fe348fd83403","modified":"2025-07-14 08:09:07","datetime":"2025-07-14 08:09:07","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"player":{"pid":83397,"title":"Rushab Patel","short_name":"RN Patel","first_name":"Rushab Patel","last_name":"","middle_name":"","birthdate":"1993-06-29","birthplace":"","country":"ke","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","nationality":"Kenya"},"batting":{"t20i":{"match_id":0,"inning_id":0,"matches":34,"innings":32,"notout":6,"runs":586,"balls":484,"highest":63,"run100":0,"run50":1,"run4":62,"run6":12,"average":"22.53","strike":"121.07","catches":19,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20":{"match_id":0,"inning_id":0,"matches":40,"innings":37,"notout":6,"runs":643,"balls":549,"highest":63,"run100":0,"run50":1,"run4":64,"run6":15,"average":"20.74","strike":"117.12","catches":21,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":24,"innings":23,"notout":3,"runs":529,"balls":750,"highest":99,"run100":0,"run50":3,"run4":51,"run6":3,"average":"26.45","strike":"70.53","catches":9,"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":34,"innings":4,"balls":32,"overs":5.2,"runs":34,"wickets":4,"bestinning":"2\/7","bestmatch":"2\/7","econ":"6.37","average":"8.50","strike":"8.0","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20":{"match_id":0,"inning_id":0,"matches":40,"innings":5,"balls":38,"overs":6.2,"runs":45,"wickets":4,"bestinning":"2\/7","bestmatch":"2\/7","econ":"7.10","average":"11.25","strike":"9.5","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":24,"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},"t10":{"match_id":"0","inning_id":"0","matches":"0","innings":"","balls":"","overs":"0","runs":"","wickets":"","bestinning":"","bestmatch":"","econ":"","average":"","strike":"","wicket4i":"","wicket5i":"","wicket10m":""}}},"etag":"a2caa46ff233e4adff55fe348fd83403","modified":"2025-07-14 08:09:07","datetime":"2025-07-14 08:09:07","api_version":"3.0"}', Modified = GetDate() WHERE Id = 83397 AND DataTypeId = 6 END
Player profile of Rushab Patel, Kenya
<>
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) & 192/10 (62.1 ov)

India387/10 (119.2 ov) & *58/4 (17.4 ov)

 Stumps : Day 4 - India need 135 runs to win.
LIVEToday1st Youth Test

England Under-19sEngland Under-19s*230/5 (60 ov)

India Under-19s540/10 (112.5 ov)

 Stumps : Day 2 - England Under-19s trail by 310 runs.
LIVEToday3rd Test

West IndiesWest Indies143/10 (52.1 ov)

Australia225/10 (70.3 ov) & *99/6 (29 ov)

 Stumps : Day 2 - Australia lead by 181 runs.
LIVEToday1st Unofficial Test

Australia AAustralia A*241/4 (87 ov)

Sri Lanka A272/10 (82 ov)

 Stumps : Day 2 - Australia A trail by 31 runs.
LIVETodayMatch 1

VFB GelsenkirchenVFB Gelsenkirchen188/3 (10 ov)

Koln CC*50/1 (3.1 ov)

 Koln CC need 139 runs in 41 remaining balls
LIVETodayMatch 14

Gauhati Town ClubGauhati Town Club*13/0 (1.4 ov)

Bud CC

 Bud CC elected to bowl
LIVETodayMatch 2

VFB GelsenkirchenVFB Gelsenkirchen

SC Krefeld Spartans

 SC Krefeld Spartans elected to bowl
Scheduled14 July 1st T20I

ZimbabweZimbabwe

South Africa

 
Scheduled14 July Match 3

Koln CCKoln CC

Lenkerbeck Marl

 
Scheduled14 July Match 4

SC Krefeld SpartansSC Krefeld Spartans

Grey Caps Aachen

 
Scheduled14 July Match 5

Grey Caps AachenGrey Caps Aachen

Lenkerbeck Marl

 
Scheduled14 July Match 12

Gujrat CCGujrat CC

Royal Lions CC

 
Scheduled15 July Match 15

Nabarang ClubNabarang Club

City Cricket Club

 
Scheduled15 July Match 6

SC Krefeld SpartansSC Krefeld Spartans

Lenkerbeck Marl

 
Scheduled15 July Match 16

Gauhati Town ClubGauhati Town Club

Bud CC

 
Scheduled15 July Match 16

Karaikal KniightsKaraikal Kniights

Ruby White Town legends

 
Scheduled15 July Match 7

SC Krefeld SpartansSC Krefeld Spartans

Koln CC

 
Scheduled15 July Match 8

Grey Caps AachenGrey Caps Aachen

Koln CC

 
CricDirect Cricket News, Results and Stats
 

Rushab Patel

NationalityKenya
RoleBatter
Born29 Jun 1993 (32)
Batting StyleLeft hand Bat
Bowling StyleRight Arm Medium Fast

Batting

Format MAT INNS NO RUNS HS AVG BF SR 100s 50s
T20I 34 32 6 586 63 22.53 484 121.07 - 1
T20I 40 37 6 643 63 20.74 549 117.12 - 1
List A 24 23 3 529 99 26.45 750 70.53 - 3

Bowling

Format MAT INNS OVR RUNS WK BBI AVG ECN SR 4W 5W
T20i 34 4 5.2 34 4 2/7 8.50 6.37 8.0 - -
T20 40 5 6.2 45 4 2/7 11.25 7.10 9.5 - -
List A 24 - - - - - - - - - -
× Close