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:173ec333-fb93-4cec-bc0c-fb2cbc58f807 Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 53835 AND DataTypeId = 6) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (53835,6,'{"status":"ok","response":{"player":{"pid":53835,"title":"Rajat Paliwal","short_name":"RS Paliwal","first_name":"Rajat Paliwal","last_name":"","middle_name":"","birthdate":"1991-12-24","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/paliwal_rajat\/","debut_data":"","bowling_type":"Spin","thumb_url":"","nationality":"India"},"batting":{"t20":{"match_id":0,"inning_id":0,"matches":66,"innings":63,"notout":9,"runs":1231,"balls":1036,"highest":64,"run100":0,"run50":2,"run4":115,"run6":11,"average":"22.79","strike":"118.82","catches":30,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":84,"innings":79,"notout":13,"runs":3017,"balls":3701,"highest":112,"run100":3,"run50":26,"run4":256,"run6":15,"average":"45.71","strike":"81.51","catches":45,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":100,"innings":160,"notout":13,"runs":6659,"balls":12804,"highest":203,"run100":20,"run50":28,"run4":789,"run6":20,"average":"45.29","strike":"52.00","catches":96,"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":66,"innings":14,"balls":186,"overs":31,"runs":227,"wickets":8,"bestinning":"2\/9","bestmatch":"2\/9","econ":"7.32","average":"28.37","strike":"23.2","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":84,"innings":31,"balls":541,"overs":90.1,"runs":457,"wickets":13,"bestinning":"3\/21","bestmatch":"3\/21","econ":"5.06","average":"35.15","strike":"41.6","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":100,"innings":59,"balls":1739,"overs":289.5,"runs":885,"wickets":26,"bestinning":"4\/22","bestmatch":"4\/33","econ":"3.05","average":"34.03","strike":"66.8","wicket4i":1,"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":"cbe57ed4d610f49244623e8eebd02acd","modified":"2025-07-26 14:33:21","datetime":"2025-07-26 14:33:21","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"player":{"pid":53835,"title":"Rajat Paliwal","short_name":"RS Paliwal","first_name":"Rajat Paliwal","last_name":"","middle_name":"","birthdate":"1991-12-24","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/paliwal_rajat\/","debut_data":"","bowling_type":"Spin","thumb_url":"","nationality":"India"},"batting":{"t20":{"match_id":0,"inning_id":0,"matches":66,"innings":63,"notout":9,"runs":1231,"balls":1036,"highest":64,"run100":0,"run50":2,"run4":115,"run6":11,"average":"22.79","strike":"118.82","catches":30,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":84,"innings":79,"notout":13,"runs":3017,"balls":3701,"highest":112,"run100":3,"run50":26,"run4":256,"run6":15,"average":"45.71","strike":"81.51","catches":45,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":100,"innings":160,"notout":13,"runs":6659,"balls":12804,"highest":203,"run100":20,"run50":28,"run4":789,"run6":20,"average":"45.29","strike":"52.00","catches":96,"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":66,"innings":14,"balls":186,"overs":31,"runs":227,"wickets":8,"bestinning":"2\/9","bestmatch":"2\/9","econ":"7.32","average":"28.37","strike":"23.2","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":84,"innings":31,"balls":541,"overs":90.1,"runs":457,"wickets":13,"bestinning":"3\/21","bestmatch":"3\/21","econ":"5.06","average":"35.15","strike":"41.6","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":100,"innings":59,"balls":1739,"overs":289.5,"runs":885,"wickets":26,"bestinning":"4\/22","bestmatch":"4\/33","econ":"3.05","average":"34.03","strike":"66.8","wicket4i":1,"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":"cbe57ed4d610f49244623e8eebd02acd","modified":"2025-07-26 14:33:21","datetime":"2025-07-26 14:33:21","api_version":"3.0"}', Modified = GetDate() WHERE Id = 53835 AND DataTypeId = 6 END
Player profile of Rajat Paliwal, India
<>
LIVE06 May Match 5

Hong Kong WomenHong Kong Women

Kuwait Women

 
LIVE06 May Match 6

Thailand WomenThailand Women

United Arab Emirates Women

 
LIVEToday4th Test

EnglandEngland669/10 (157.1 ov)

India358/10 (114.1 ov) & *81/2 (26.1 ov)

 Day 4 - Session 2, India trail by 230 runs.
LIVEToday1st ODI

Ireland WomenIreland Women288/9 (50 ov)

Zimbabwe Women*56/3 (14.1 ov)

 Zimbabwe Women need 233 runs in 35.5 remaining overs
LIVETodayFinal

New ZealandNew Zealand180/5 (20 ov)

South Africa177/6 (20 ov)

 New Zealand won by 3 runs
LIVETodayMatch 10

India ChampionsIndia Champions203/4 (20 ov)

Australia Champions*156/5 (16.2 ov)

 Australia Champions need 48 runs in 22 remaining balls
LIVETodayMatch 12

RwandaRwanda157/5 (20 ov)

Malawi*90/1 (13.5 ov)

 Malawi need 68 runs in 37 remaining balls
LIVETodayFinal

Rwanda WomenRwanda Women135/7 (20 ov)

Sierra Leone Women*61/8 (12.3 ov)

 Sierra Leone Women need 75 runs in 45 remaining balls
LIVETodayMatch 6

AustriaAustria245/7 (20 ov)

Luxembourg

 Innings Break : Austria elected to bat
LIVEToday2nd Semi-Final

Yorkshire WomenYorkshire Women

Glamorgan Women*66/0 (9 ov)

 Glamorgan Women elected to bat
LIVETodayMatch 1

West Indies Women Under-19sWest Indies Women Under-19s

United States of America Women Under-19s*25/4 (6 ov)

 West Indies Women Under-19s elected to bowl
LIVETodayMatch 20

Alby Zalmi CFAlby Zalmi CF

Rising Phoenix

 Rising Phoenix won the toss and elected to bat
ScheduledTodayMatch 11

Pakistan ChampionsPakistan Champions

West Indies Champions

 
Scheduled26 July Match 28

Gujrat CCGujrat CC

Super Lanka

 
Scheduled26 July 4th T20I

West IndiesWest Indies

Australia

 
Scheduled27 July Match 9

Fatemi Resources Cricket ClubFatemi Resources Cricket Club

Maxx Cricket Club

 
Scheduled27 July Match 10

JB KingsJB Kings

MB Malik

 
Scheduled27 July Match 1

Gauhati Town ClubGauhati Town Club

91 Yard Club

 
Scheduled27 July Match 11

Utkal Cricket ClubUtkal Cricket Club

Kl Gladiators

 
Scheduled27 July Match 2

Guwahati GiantsGuwahati Giants

Navarang Club

 
CricDirect Cricket News, Results and Stats
 

Rajat Paliwal

NationalityIndia
RoleBatter
Born24 Dec 1991 (33)
Batting StyleRight Hand Bat
Bowling StyleRight Arm Off Break

Batting

Format MAT INNS NO RUNS HS AVG BF SR 100s 50s
T20I 66 63 9 1231 64 22.79 1036 118.82 - 2
List A 84 79 13 3017 112 45.71 3701 81.51 3 26
1st Class 100 160 13 6659 203 45.29 12804 52.00 20 28

Bowling

Format MAT INNS OVR RUNS WK BBI AVG ECN SR 4W 5W
T20 66 14 31 227 8 2/9 28.37 7.32 23.2 - -
List A 84 31 90.1 457 13 3/21 35.15 5.06 41.6 - -
1st Class 100 59 289.5 885 26 4/22 34.03 3.05 66.8 1 -
× Close