System.InvalidCastException: Specified cast is not valid

Hi,

I am getting this exception System.InvalidCastException: Specified cast is not valid in the following code :

if (type == "in")

{

config.AppSettings.Settings["HasMoney"].Value = "True";

long ttype = 0;

long value = 0;

int quantity = 0;

for (int i =1 ; i<=7;i++)

{

ttype = 0;

value = 0;

quantity = 0;

switch(i)

{

case 1:

ttype = 5;

break;

case 2:

ttype = 10;

break;

case 3:

ttype = 20;

break;

case 4:

ttype = 50;

break;

case 5:

ttype = 100;

break;

case 6:

ttype = 200;

break;

case 7:

ttype = 500;

break;

}

quantity = rd.GetInt32(i+7);

value = quantity * ttype;

if(quantity !=0)

I am getting this error in quantity = rd.GetInt32(i+7)

and in my database the value is of type int only. So why am i getting this error.

I already did it i will show u public void BuildTransactionXML() { string xmlString = ""; Configuration config = ConfigurationManager.OpenExeConfiguration(Application.ExecutablePath); string transactioncounter = config.AppSettings.Settings["transactioncounter"].Value; string BustaA = config.AppSettings.Settings["bagnumber"].Value; string cm18string = ConfigurationManager.ConnectionStrings["CM18String"].ConnectionString; SqlConnection con = null; try { con = new SqlConnection(cm18string); if (con.State != System.Data.ConnectionState.Open) { con.Open(); } string currency = ""; string device = ""; string result = ""; string symbol = ""; string type = ""; string type1 = ""; string file_name = ""; string user = ""; string filesaved = ""; string date = ""; string time = ""; string cassette = ""; SqlCommand cmd = new SqlCommand("SELECT [IDP],[DateTimeOperazione],[Importo],[TipoOperazione],[Banconote_E500],[Banconote_E200],[Banconote_E100],[Banconote_E50],[Banconote_E20],[Banconote_E10],[Banconote_E5],[BustaA] FROM [DataBos].[dbo].[Operazioni] join [DataBos].[dbo].[Buste] on [DataBos].[dbo].[Operazioni].SessioneRef = [DataBos].[dbo].[Buste].SessioneRef where TipoOperazione IN ('161','3', '1') and IDP > @idp", con); cmd.Parameters.Add("@idp", transactioncounter); SqlDataReader rd = cmd.ExecuteReader(); while (rd.Read()) { string filecounter = config.AppSettings.Settings["filecounter"].Value; //Till_Number = rd.GetString(19); //user = rd.GetString(1); switch (rd.GetInt32(3)) { case 161: type = "out"; type1 = "out"; break; case 1: type = "outb"; type1 = "outb"; break; case 3: type = "in"; type1 = "in"; config.AppSettings.Settings["bagnumber"].Value = rd.GetString(11); config.Save(ConfigurationSaveMode.Modified); BustaA= rd.GetString(11); break; default: type = ""; break; } cassette = BustaA; currency = "Euro"; symbol = "€"; date = rd.GetDateTime(1).ToString("M/DD/YYYY"); time = rd.GetDateTime(1).ToString(); device = config.AppSettings.Settings["MachineId"].Value; file_name = device + "_" + type1 + ".xml"; xmlString = ""; xmlString = "" + device + "" + @type1 + "" + currency + "" + symbol + "" + date + "" + time + "" + cassette + "<" + file_name + ""; file_name = device + "_" + type1 + "_" + filecounter + ".xml"; if (type == "in") { config.AppSettings.Settings["HasMoney"].Value = "True"; long ttype = 0; long value = 0; int quantity = 0; for (int i =1 ; i<=7;i++) { ttype = 0; value = 0; quantity = 0; switch(i) { case 1: ttype = 500; break; case 2: ttype = 200; break; case 3: ttype = 100; break; case 4: ttype = 50; break; case 5: ttype = 20; break; case 6: ttype = 10; break; case 7: ttype = 5; break; } quantity = rd.GetInt32(i+4); value = quantity * ttype; this is my whole code BUT I AM GETTING THIS ERROR AGAIN AND AGAIN NO CHANGE

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Gunjan Manan11y ago
I already did it i will show u public void BuildTransactionXML() { string xmlString = ""; Configuration config = ConfigurationManager.OpenExeConfiguration(Application.ExecutablePath); string transactioncounter = config.AppSettings.Settings["transactioncounter"].Value; string BustaA = config.AppSettings.Settings["bagnumber"].Value; string cm18string = ConfigurationManager.ConnectionStrings["CM18String"].ConnectionString; SqlConnection con = null; try { con = new SqlConnection(cm18string); if (con.State != System.Data.ConnectionState.Open) { con.Open(); } string currency = ""; string device = ""; string result = ""; string symbol = ""; string type = ""; string type1 = ""; string file_name = ""; string user = ""; string filesaved = ""; string date = ""; string time = ""; string cassette = ""; SqlCommand cmd = new SqlCommand("SELECT [IDP],[DateTimeOperazione],[Importo],[TipoOperazione],[Banconote_E500],[Banconote_E200],[Banconote_E100],[Banconote_E50],[Banconote_E20],[Banconote_E10],[Banconote_E5],[BustaA] FROM [DataBos].[dbo].[Operazioni] join [DataBos].[dbo].[Buste] on [DataBos].[dbo].[Operazioni].SessioneRef = [DataBos].[dbo].[Buste].SessioneRef where TipoOperazione IN ('161','3', '1') and IDP > @idp", con); cmd.Parameters.Add("@idp", transactioncounter); SqlDataReader rd = cmd.ExecuteReader(); while (rd.Read()) { string filecounter = config.AppSettings.Settings["filecounter"].Value; //Till_Number = rd.GetString(19); //user = rd.GetString(1); switch (rd.GetInt32(3)) { case 161: type = "out"; type1 = "out"; break; case 1: type = "outb"; type1 = "outb"; break; case 3: type = "in"; type1 = "in"; config.AppSettings.Settings["bagnumber"].Value = rd.GetString(11); config.Save(ConfigurationSaveMode.Modified); BustaA= rd.GetString(11); break; default: type = ""; break; } cassette = BustaA; currency = "Euro"; symbol = "€"; date = rd.GetDateTime(1).ToString("M/DD/YYYY"); time = rd.GetDateTime(1).ToString(); device = config.AppSettings.Settings["MachineId"].Value; file_name = device + "_" + type1 + ".xml"; xmlString = ""; xmlString = "" + device + "" + @type1 + "" + currency + "" + symbol + "" + date + "" + time + "" + cassette + "<" + file_name + ""; file_name = device + "_" + type1 + "_" + filecounter + ".xml"; if (type == "in") { config.AppSettings.Settings["HasMoney"].Value = "True"; long ttype = 0; long value = 0; int quantity = 0; for (int i =1 ; i<=7;i++) { ttype = 0; value = 0; quantity = 0; switch(i) { case 1: ttype = 500; break; case 2: ttype = 200; break; case 3: ttype = 100; break; case 4: ttype = 50; break; case 5: ttype = 20; break; case 6: ttype = 10; break; case 7: ttype = 5; break; } quantity = rd.GetInt32(i+4); value = quantity * ttype; this is my whole code BUT I AM GETTING THIS ERROR AGAIN AND AGAIN NO CHANGE
0
Upendra Pratap Shahi11y ago
http://forums.asp.net/t/1284232.aspx?SQL+int+to+GetInt32+to+Int32+Specified+cast+is+not+valid+
0