Click here to Skip to main content
15,886,362 members
Home / Discussions / ASP.NET
   

ASP.NET

 
AnswerRe: how to extrack an image from an email and save it on a disk Pin
Richard MacCutchan10-Aug-12 21:53
mveRichard MacCutchan10-Aug-12 21:53 
Questionsession variables Pin
sc steinhayse10-Aug-12 17:28
sc steinhayse10-Aug-12 17:28 
AnswerRe: session variables Pin
Shameel14-Aug-12 0:40
professionalShameel14-Aug-12 0:40 
QuestionReading data from Excel Pin
indian14310-Aug-12 7:15
indian14310-Aug-12 7:15 
AnswerRe: Reading data from Excel Pin
jkirkerx10-Aug-12 10:33
professionaljkirkerx10-Aug-12 10:33 
GeneralRe: Reading data from Excel Pin
indian14310-Aug-12 12:28
indian14310-Aug-12 12:28 
GeneralRe: Reading data from Excel Pin
jkirkerx10-Aug-12 19:12
professionaljkirkerx10-Aug-12 19:12 
Question(Input string was not in a correct format) with ExecuteReader Pin
Jassim Rahma10-Aug-12 2:33
Jassim Rahma10-Aug-12 2:33 
I am getting Input string was not in a correct format with the following code:

C#
sql_connection = new MySqlConnection(ConfigurationManager.ConnectionStrings["SQLdb"].ConnectionString);
sql_connection.Open();

sql_command = new MySqlCommand("sp_check_if_member_exist", sql_connection);
sql_command.CommandType = CommandType.StoredProcedure;
sql_command.Parameters.AddWithValue("param_member_id", MySqlDbType.Int32).Value = Convert.ToInt32(Request.QueryString["id"]);
sql_command.Parameters.AddWithValue("param_member_guid", MySqlDbType.VarChar).Value = Convert.ToString(Request.QueryString["guid"]);
sql_command.Parameters.Add("param_is_exist", MySqlDbType.Bit).Direction = ParameterDirection.Output;

sql_reader = sql_command.ExecuteReader();
sql_reader.Read();

if (sql_reader.HasRows)
{
    if (Convert.ToBoolean(sql_command.Parameters["param_is_exist"].Value) == true)
    {
        // prompt for activation;
        panelMessage.Visible = false;
        panelActivation.Visible = true;
    }
    else
    {
        panelActivation.Visible = false;
        lblMessage.Text = "Error activating your membership!";
        panelMessage.Visible = true;
        return;
    }


The error occurs on this line:

sql_reader = sql_command.ExecuteReader();


where is my mistake?
AnswerRe: (Input string was not in a correct format) with ExecuteReader Pin
WebMaster10-Aug-12 2:52
WebMaster10-Aug-12 2:52 
AnswerRe: (Input string was not in a correct format) with ExecuteReader Pin
Parthi Bun10-Aug-12 3:06
Parthi Bun10-Aug-12 3:06 
AnswerRe: (Input string was not in a correct format) with ExecuteReader Pin
StianSandberg10-Aug-12 3:26
StianSandberg10-Aug-12 3:26 
GeneralRe: (Input string was not in a correct format) with ExecuteReader Pin
Jassim Rahma10-Aug-12 4:03
Jassim Rahma10-Aug-12 4:03 
GeneralRe: (Input string was not in a correct format) with ExecuteReader Pin
Jassim Rahma11-Aug-12 9:11
Jassim Rahma11-Aug-12 9:11 
AnswerRe: (Input string was not in a correct format) with ExecuteReader Pin
Shameel14-Aug-12 0:46
professionalShameel14-Aug-12 0:46 
Questionasp.net Pin
Rajesh.paka10-Aug-12 2:08
Rajesh.paka10-Aug-12 2:08 
AnswerRe: asp.net Pin
Wes Aday10-Aug-12 4:00
professionalWes Aday10-Aug-12 4:00 
Questionstrange issue with cache application block (ENT LIB 5) Pin
Luca Dominici9-Aug-12 23:23
Luca Dominici9-Aug-12 23:23 
AnswerRe: strange issue with cache application block (ENT LIB 5) Pin
Pete O'Hanlon10-Aug-12 0:42
mvePete O'Hanlon10-Aug-12 0:42 
AnswerRe: strange issue with cache application block (ENT LIB 5) Pin
jkirkerx10-Aug-12 10:12
professionaljkirkerx10-Aug-12 10:12 
Questiondebug javascript Pin
dcof9-Aug-12 18:44
dcof9-Aug-12 18:44 
AnswerRe: debug javascript Pin
AnnieCalvert9-Aug-12 20:09
AnnieCalvert9-Aug-12 20:09 
GeneralRe: debug javascript Pin
dcof10-Aug-12 4:31
dcof10-Aug-12 4:31 
GeneralRe: debug javascript Pin
enhzflep10-Aug-12 4:59
enhzflep10-Aug-12 4:59 
Generalwindow open Pin
dcof9-Aug-12 12:16
dcof9-Aug-12 12:16 
QuestionRe: window open Pin
CodeHawkz9-Aug-12 20:57
CodeHawkz9-Aug-12 20:57 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.