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:4900711a-2c13-4c51-a866-e659a9b1b30a Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 105696 AND DataTypeId = 6) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (105696,6,'{"status":"ok","response":{"player":{"pid":105696,"title":"Prashant Solanki","short_name":"PH Solanki","first_name":"Prashant Solanki","last_name":"","middle_name":"","birthdate":"2000-02-22","birthplace":"Mumbai, India","country":"in","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":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/PSolankii22","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"India"},"batting":{"t20":{"match_id":0,"inning_id":0,"matches":16,"innings":1,"notout":1,"runs":1,"balls":1,"highest":1,"run100":0,"run50":0,"run4":0,"run6":0,"average":"","strike":"100.00","catches":2,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":14,"innings":5,"notout":3,"runs":19,"balls":13,"highest":13,"run100":0,"run50":0,"run4":2,"run6":1,"average":"9.50","strike":"146.15","catches":3,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":4,"innings":7,"notout":4,"runs":16,"balls":45,"highest":10,"run100":0,"run50":0,"run4":2,"run6":1,"average":"5.33","strike":"35.55","catches":3,"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":16,"innings":16,"balls":337,"overs":56.1,"runs":449,"wickets":14,"bestinning":"2\/8","bestmatch":"2\/8","econ":"7.99","average":"32.07","strike":"24.0","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":14,"innings":14,"balls":703,"overs":117.1,"runs":756,"wickets":26,"bestinning":"5\/48","bestmatch":"5\/48","econ":"6.45","average":"29.07","strike":"27.0","wicket4i":1,"wicket5i":1,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":4,"innings":8,"balls":353,"overs":58.5,"runs":252,"wickets":6,"bestinning":"3\/12","bestmatch":"4\/34","econ":"4.28","average":"42.00","strike":"58.8","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":"4562bd8230de577f1ee0e15332637b67","modified":"2025-06-20 15:16:41","datetime":"2025-06-20 15:16:41","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"player":{"pid":105696,"title":"Prashant Solanki","short_name":"PH Solanki","first_name":"Prashant Solanki","last_name":"","middle_name":"","birthdate":"2000-02-22","birthplace":"Mumbai, India","country":"in","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":8,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/PSolankii22","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"India"},"batting":{"t20":{"match_id":0,"inning_id":0,"matches":16,"innings":1,"notout":1,"runs":1,"balls":1,"highest":1,"run100":0,"run50":0,"run4":0,"run6":0,"average":"","strike":"100.00","catches":2,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":14,"innings":5,"notout":3,"runs":19,"balls":13,"highest":13,"run100":0,"run50":0,"run4":2,"run6":1,"average":"9.50","strike":"146.15","catches":3,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":4,"innings":7,"notout":4,"runs":16,"balls":45,"highest":10,"run100":0,"run50":0,"run4":2,"run6":1,"average":"5.33","strike":"35.55","catches":3,"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":16,"innings":16,"balls":337,"overs":56.1,"runs":449,"wickets":14,"bestinning":"2\/8","bestmatch":"2\/8","econ":"7.99","average":"32.07","strike":"24.0","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":14,"innings":14,"balls":703,"overs":117.1,"runs":756,"wickets":26,"bestinning":"5\/48","bestmatch":"5\/48","econ":"6.45","average":"29.07","strike":"27.0","wicket4i":1,"wicket5i":1,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":4,"innings":8,"balls":353,"overs":58.5,"runs":252,"wickets":6,"bestinning":"3\/12","bestmatch":"4\/34","econ":"4.28","average":"42.00","strike":"58.8","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":"4562bd8230de577f1ee0e15332637b67","modified":"2025-06-20 15:16:41","datetime":"2025-06-20 15:16:41","api_version":"3.0"}', Modified = GetDate() WHERE Id = 105696 AND DataTypeId = 6 END
Player profile of Prashant Solanki, India
<>
LIVE06 May Match 5

Hong Kong WomenHong Kong Women

Kuwait Women

 
LIVE06 May Match 6

Thailand WomenThailand Women

United Arab Emirates Women

 
LIVEToday1st Test

Sri LankaSri Lanka485/10 (131.2 ov)

Bangladesh495/10 (153.4 ov) & *177/3 (57 ov)

 Stumps : Day 4 - Bangladesh lead by 187 runs.
LIVEToday1st Test

EnglandEngland

India*226/3 (53.5 ov)

 Day 1 - Session 3, England elected to bowl
LIVETodayMatch 11

Diamond DazzlersDiamond Dazzlers*10/1 (2 ov)

Alembic Warriors

 Rain Delay : Alembic Warriors elected to bowl
LIVETodayMatch 31

Durham WomenDurham Women101/8 (20 ov)

Essex Women*13/1 (2.5 ov)

 Essex Women need 89 runs in 17.1 remaining overs
LIVETodayEliminator

Raigad RoyalsRaigad Royals

Kolhapur Tuskers*38/1 (5 ov)

 Rain Delay : Raigad Royals elected to bowl
LIVETodayMatch 19

Lux Shyam Kolkata TigersLux Shyam Kolkata Tigers*157/7 (18.5 ov)

Shrachi Rarh Tigers

 Lux Shyam Kolkata Tigers elected to bat
LIVETodayMatch 32

Warwickshire WomenWarwickshire Women*156/5 (18.2 ov)

The Blaze

 Warwickshire Women elected to bat
LIVEToday6th T20I

ScotlandScotland*145/5 (15.2 ov)

Nepal

 Scotland elected to bat
LIVETodayMatch 17

Bhopal LeopardsBhopal Leopards

Gwalior Cheetahs*29/1 (3 ov)

 Rain Delay : Gwalior Cheetahs elected to bat
LIVETodayFinal

Anmol Kings HalarAnmol Kings Halar*117/5 (16 ov)

JMD Kutch Riders

 JMD Kutch Riders elected to bowl
LIVETodayMatch 10

BohemiansBohemians*25/1 (2.5 ov)

Prague Tigers

 Prague Tigers elected to bowl
LIVETodayFinal

Tally RangersTally Rangers

ACE KRM Panthers

 ACE KRM Panthers elected to bat
ScheduledTodayMatch 28

Chicago Steelpan PlayersChicago Steelpan Players

SAMP Army Cocrico Cavaliers

 
Scheduled20 June Match 65

NorthamptonshireNorthamptonshire

Nottinghamshire

 
Scheduled20 June Match 67

GlamorganGlamorgan

Somerset

 
Scheduled20 June Match 69

DurhamDurham

Yorkshire

 
Scheduled20 June Match 64

SurreySurrey

Middlesex

 
Scheduled20 June Match 66

GloucestershireGloucestershire

Hampshire

 
CricDirect Cricket News, Results and Stats
 

Prashant Solanki

NationalityIndia
RoleBowler
Born22 Feb 2000 (25)
Batting StyleRight Hand Bat
Bowling StyleRight Arm Leg Spin

Batting

Format MAT INNS NO RUNS HS AVG BF SR 100s 50s
T20I 16 1 1 1 1 - 1 100.00 - -
List A 14 5 3 19 13 9.50 13 146.15 - -
1st Class 4 7 4 16 10 5.33 45 35.55 - -

Bowling

Format MAT INNS OVR RUNS WK BBI AVG ECN SR 4W 5W
T20 16 16 56.1 449 14 2/8 32.07 7.99 24.0 - -
List A 14 14 117.1 756 26 5/48 29.07 6.45 27.0 1 1
1st Class 4 8 58.5 252 6 3/12 42.00 4.28 58.8 - -
× Close