Click here to Skip to main content
       

ASP.NET

 
AnswerRe: updated data from gridview PinmemberAli Al Omairi(Abu AlHassan)24-Dec-12 4:31 
AnswerRe: updated data from gridview PinmvpSandeep Mewara25-Dec-12 19:35 
Question.net question PinmemberTarani Dutt Joshi21-Dec-12 23:53 
AnswerRe: .net question PinmvpRichard MacCutchan22-Dec-12 0:18 
AnswerRe: .net question PinmemberMaulikDusara24-Dec-12 21:38 
AnswerRe: .net question PinmvpSandeep Mewara25-Dec-12 19:33 
QuestionWebRequest Pinmembercdpsource21-Dec-12 14:16 
Questionwebpage has resulted in too many redirects PinmemberJassim Rahma21-Dec-12 9:46 
Hi,
 
Why I am getting this error when insert is successful?!!! it should redirect to ~/Channels!
 
here is my code:
 
try
{
    sql_connection = new MySqlConnection(ConfigurationManager.ConnectionStrings["SQLdb"].ConnectionString);
    sql_connection.Open();
                
    if (RouteData.Values["GUID"].ToString() == "New") sql_command = new MySqlCommand("sp_add_new_channel", sql_connection);
    else sql_command = new MySqlCommand("sp_update_channel", sql_connection);
                
    sql_command.CommandType = CommandType.StoredProcedure;
 
    if (RouteData.Values["GUID"].ToString() == "New") sql_command.Parameters.AddWithValue("param_member_id", Convert.ToInt32(Session["member_id"])).MySqlDbType = MySqlDbType.Int32; 
    else sql_command.Parameters.AddWithValue("param_channel_guid", RouteData.Values["GUID"].ToString()).MySqlDbType = MySqlDbType.VarChar;                
 
    sql_command.Parameters.AddWithValue("param_channel_name", txtChannelName.Text.Trim()).MySqlDbType = MySqlDbType.VarChar;
    sql_command.Parameters.AddWithValue("param_channel_address", txtChannelAddress.Text.Trim()).MySqlDbType = MySqlDbType.VarChar;
    sql_command.Parameters.AddWithValue("param_channel_language", Convert.ToInt32(cboLanguage.Value)).MySqlDbType = MySqlDbType.Int32;
    sql_command.Parameters.AddWithValue("param_channel_description", txtChannelDescription.Text.Trim()).MySqlDbType = MySqlDbType.VarChar;
    sql_command.Parameters.AddWithValue("param_channel_allow_comment", chkAllowComment.Checked).MySqlDbType = MySqlDbType.Bit;
    sql_command.Parameters.AddWithValue("param_channel_allow_like", chkAllowLikeIt.Checked).MySqlDbType = MySqlDbType.Bit;
    sql_command.Parameters.AddWithValue("param_channel_allow_share", chkAllowShare.Checked).MySqlDbType = MySqlDbType.Bit;
    sql_command.Parameters.AddWithValue("param_show_profile_photo", chkShowProfilePhoto.Checked).MySqlDbType = MySqlDbType.Bit;
    if (RouteData.Values["GUID"].ToString() == "New") sql_command.Parameters.Add("param_channel_guid", MySqlDbType.VarChar).Direction = ParameterDirection.Output;
    sql_command.Parameters.Add("param_is_exist", MySqlDbType.Bit).Direction = ParameterDirection.Output;                
 
    // execute the query;
    int result_rows = sql_command.ExecuteNonQuery();
 
    if (Convert.ToBoolean(sql_command.Parameters["param_is_exist"].Value) != true)
    {
        // member_id = sql_command.Parameters["param_record_identity"].Value.ToString();
        // member_guid = sql_command.Parameters["param_record_guid"].Value.ToString();
        // activation_code = sql_command.Parameters["param_activation_code"].Value.ToString();

        website_event_log.add_event_log("Membership", txtChannelName.Text.Trim(), "You have successfully signed up");
 
        Response.Redirect("~/Channels", true);
    }
    else
    {
        Session["message_title"] = "Error";
        Session["message_title_Color"] = Color.Red.ToArgb();
        Session["message_text"] = "The same channel address already exists. Please try another address.";
        Session["message_button_title"] = "Back";
        Session["message_button_url"] = Request.UrlReferrer.ToString();
 
        Response.Redirect("~/Message", false);
    }
}
catch (Exception exp)
{
    Session["message_title"] = "ERROR..";
    Session["message_text"] = String.Format("Please try again.......{0}{1}", "", exp.Message);
    Session["message_button_title"] = "Back to Sign-in";
    Session["message_button_url"] = Request.UrlReferrer.ToString();
 
    Response.Redirect("~/Message", false);
}
finally
{
    // if (sql_reader != null) sql_reader.Close();
    if (sql_connection != null)
    {
        if (sql_connection.State == ConnectionState.Open)
            sql_connection.Close();
    }
}

 
Technology News @ www.JassimRahma.com

AnswerRe: webpage has resulted in too many redirects Pinmemberjkirkerx22-Dec-12 18:50 
GeneralRe: webpage has resulted in too many redirects PinmemberJassim Rahma23-Dec-12 8:36 
GeneralRe: webpage has resulted in too many redirects Pinmemberjkirkerx23-Dec-12 8:47 
GeneralRe: webpage has resulted in too many redirects PinmemberJassim Rahma24-Dec-12 9:10 
GeneralRe: webpage has resulted in too many redirects Pinmemberjkirkerx24-Dec-12 13:05 
Questionpop up on mouse over on a image button PinmemberYasir88721-Dec-12 6:42 
AnswerRe: pop up on mouse over on a image button PinmemberAnalogNerd21-Dec-12 9:26 
GeneralRe: pop up on mouse over on a image button PinmemberYasir88721-Dec-12 17:09 
AnswerRe: pop up on mouse over on a image button Pinmembern.podbielski22-Dec-12 21:50 
AnswerRe: pop up on mouse over on a image button [modified] PinmemberCommDev23-Dec-12 14:35 
Questionasp.net PinmemberNitin Pant20-Dec-12 21:43 
AnswerRe: asp.net PinmvpRichard MacCutchan20-Dec-12 22:57 
RantRe: asp.net PinmemberRichard Deeming21-Dec-12 1:31 
GeneralRe: asp.net PinmvpRichard MacCutchan21-Dec-12 2:04 
JokeRe: asp.net Pinmembern.podbielski22-Dec-12 21:54 
AnswerRe: asp.net PinmemberJ4amieC20-Dec-12 23:26 
AnswerRe: asp.net PinmemberProgramFOX20-Dec-12 23:52 

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

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


Advertise | Privacy | Mobile
Web03 | 2.8.141022.2 | Last Updated 24 Oct 2014
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid