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:500881f9-79f4-404a-a420-941702daf738 Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 59038 AND DataTypeId = 6) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (59038,6,'{"status":"ok","response":{"player":{"pid":59038,"title":"Rangaraj Suthesh","short_name":"R Suthesh","first_name":"Rangaraj Suthesh","last_name":"","middle_name":"","birthdate":"1987-04-08","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"Left Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"India"},"batting":{"t20":{"match_id":0,"inning_id":0,"matches":2,"innings":1,"notout":1,"runs":17,"balls":8,"highest":17,"run100":0,"run50":0,"run4":3,"run6":0,"average":"","strike":"212.50","catches":1,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":10,"innings":3,"notout":1,"runs":11,"balls":10,"highest":10,"run100":0,"run50":0,"run4":0,"run6":1,"average":"5.50","strike":"110.00","catches":0,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":3,"innings":3,"notout":1,"runs":5,"balls":21,"highest":4,"run100":0,"run50":0,"run4":1,"run6":0,"average":"2.50","strike":"23.80","catches":0,"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":2,"innings":2,"balls":46,"overs":7.4,"runs":47,"wickets":3,"bestinning":"2\/22","bestmatch":"2\/22","econ":"6.13","average":"15.66","strike":"15.3","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":10,"innings":10,"balls":510,"overs":85,"runs":448,"wickets":21,"bestinning":"3\/25","bestmatch":"3\/25","econ":"5.27","average":"21.33","strike":"24.2","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":3,"innings":3,"balls":414,"overs":69,"runs":223,"wickets":3,"bestinning":"2\/78","bestmatch":"2\/78","econ":"3.23","average":"74.33","strike":"138.0","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":"10e91c6218dbfbb9e2da4ed12642babc","modified":"2025-05-30 18:26:54","datetime":"2025-05-30 18:26:54","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"player":{"pid":59038,"title":"Rangaraj Suthesh","short_name":"R Suthesh","first_name":"Rangaraj Suthesh","last_name":"","middle_name":"","birthdate":"1987-04-08","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"Left Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"India"},"batting":{"t20":{"match_id":0,"inning_id":0,"matches":2,"innings":1,"notout":1,"runs":17,"balls":8,"highest":17,"run100":0,"run50":0,"run4":3,"run6":0,"average":"","strike":"212.50","catches":1,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":10,"innings":3,"notout":1,"runs":11,"balls":10,"highest":10,"run100":0,"run50":0,"run4":0,"run6":1,"average":"5.50","strike":"110.00","catches":0,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":3,"innings":3,"notout":1,"runs":5,"balls":21,"highest":4,"run100":0,"run50":0,"run4":1,"run6":0,"average":"2.50","strike":"23.80","catches":0,"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":2,"innings":2,"balls":46,"overs":7.4,"runs":47,"wickets":3,"bestinning":"2\/22","bestmatch":"2\/22","econ":"6.13","average":"15.66","strike":"15.3","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":10,"innings":10,"balls":510,"overs":85,"runs":448,"wickets":21,"bestinning":"3\/25","bestmatch":"3\/25","econ":"5.27","average":"21.33","strike":"24.2","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":3,"innings":3,"balls":414,"overs":69,"runs":223,"wickets":3,"bestinning":"2\/78","bestmatch":"2\/78","econ":"3.23","average":"74.33","strike":"138.0","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":"10e91c6218dbfbb9e2da4ed12642babc","modified":"2025-05-30 18:26:54","datetime":"2025-05-30 18:26:54","api_version":"3.0"}', Modified = GetDate() WHERE Id = 59038 AND DataTypeId = 6 END
Player profile of Rangaraj Suthesh, India
<>
LIVE06 May Match 5

Hong Kong WomenHong Kong Women

Kuwait Women

 
LIVE06 May Match 6

Thailand WomenThailand Women

United Arab Emirates Women

 
LIVEToday1st Unofficial Test

England LionsEngland Lions

India A*409/3 (90 ov)

 Stumps : Day 1 - England Lions elected to bowl
LIVEToday1st ODI

England WomenEngland Women345/6 (50 ov)

West Indies Women*192/7 (38.4 ov)

 West Indies Women need 154 runs in 11.2 remaining overs
LIVETodayMatch 18

ACE KRM PanthersACE KRM Panthers*128/5 (12.5 ov)

Ai Octopus Challagers133/9 (20 ov)

 ACE KRM Panthers need 6 runs in 43 remaining balls
LIVETodayMatch 3

BelgiumBelgium162/10 (19.2 ov)

Portugal*96/2 (11 ov)

 Portugal need 67 runs in 54 remaining balls
LIVETodayMatch 5

LeicestershireLeicestershire

Derbyshire*94/5 (13.4 ov)

 Leicestershire elected to bowl
LIVETodayMatch 6

NottinghamshireNottinghamshire

Warwickshire*135/3 (12.3 ov)

 Nottinghamshire elected to bowl
LIVETodayMatch 7

SomersetSomerset

Surrey*104/3 (14.1 ov)

 Somerset elected to bowl
LIVETodayMatch 8

YorkshireYorkshire

Northamptonshire*147/2 (14 ov)

 Yorkshire elected to bowl
LIVETodayMatch 3

GloucestershireGloucestershire

Kent*57/0 (6.3 ov)

 Gloucestershire elected to bowl
LIVETodayMatch 4

HampshireHampshire*68/0 (6 ov)

Essex

 Essex elected to bowl
LIVETodayMatch 42

Emirates BluesEmirates Blues*41/4 (5 ov)

Emirates Red

 Emirates Red elected to bowl
Cancelled30 May Match 29

DCA WayanadDCA Wayanad

Combined Districts

 Match Abandoned
Cancelled30 May Match 21

Royal EaglesRoyal Eagles

Cluj

 Match cancelled
Cancelled30 May Match 30

DCA KollamDCA Kollam

Ernakulam

 Match Abandoned
Cancelled30 May Match 22

United Cricket ClubUnited Cricket Club

Cluj

 Match cancelled
CancelledTodayMatch 23

Bucharest GladiatorsBucharest Gladiators

Royal Eagles

 Match cancelled
CancelledTodayMatch 24

Royal EaglesRoyal Eagles

Cluj

 Match cancelled
CancelledTodayMatch 25

Phoenix StrikersPhoenix Strikers

Bucharest Gladiators

 Match cancelled
CricDirect Cricket News, Results and Stats
 

Rangaraj Suthesh

NationalityIndia
RoleBowler
Born08 Apr 1987 (38)
Batting StyleLeft hand Bat
Bowling StyleLeft Arm Medium

Batting

Format MAT INNS NO RUNS HS AVG BF SR 100s 50s
T20I 2 1 1 17 17 - 8 212.50 - -
List A 10 3 1 11 10 5.50 10 110.00 - -
1st Class 3 3 1 5 4 2.50 21 23.80 - -

Bowling

Format MAT INNS OVR RUNS WK BBI AVG ECN SR 4W 5W
T20 2 2 7.4 47 3 2/22 15.66 6.13 15.3 - -
List A 10 10 85 448 21 3/25 21.33 5.27 24.2 - -
1st Class 3 3 69 223 3 2/78 74.33 3.23 138.0 - -
× Close