Click here to Skip to main content
       

ASP.NET

 
AnswerRe: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine. PinmemberProgramFOX6-Oct-12 7:00 
GeneralAccess Database Engine 2010 Redistributable is not intended PinmemberDavid Mujica8-Oct-12 2:56 
GeneralRe: Access Database Engine 2010 Redistributable is not intended Pinmembern.podbielski9-Oct-12 0:28 
AnswerRe: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine. PinmemberMurugan_vdm14-Oct-12 3:22 
QuestionRandomize Data of Groupboxes [modified] PinmemberASPnoob5-Oct-12 23:38 
AnswerRe: Randomize Data of Groupboxes PinmemberVijayChauhan1237-Oct-12 20:10 
AnswerRe: Randomize Data of Groupboxes PinmemberVijayChauhan1237-Oct-12 20:46 
Questionweird problems: nothing is happening!! Pinmemberjrahma5-Oct-12 6:50 
I have the following code and SQL:
sql_connection = new MySqlConnection(ConfigurationManager.ConnectionStrings["SQLdb"].ConnectionString);
sql_connection.Open();
sql_command = new MySqlCommand("sp_delete_channel", sql_connection);
sql_command.CommandType = CommandType.StoredProcedure;
 
sql_command.Parameters.AddWithValue("param_channel_id", channel_id).MySqlDbType = MySqlDbType.Int32;
sql_command.Parameters.AddWithValue("param_volow_member_id", Convert.ToInt32(Session["volow_member_id"])).MySqlDbType = MySqlDbType.Int32;
sql_command.Parameters.Add("param_is_channel_created", MySqlDbType.Bit).Direction = ParameterDirection.Output;
 
// execute the query;
int result_rows = sql_command.ExecuteNonQuery();
 
if (Convert.ToBoolean(sql_command.Parameters["param_is_channel_created"].Value) != true)
{ Session["is_channel_created"] = false; }
 
and this is MySQL stored procedure:
 
BEGIN
        SET param_is_channel_created = TRUE;
 
        DELETE FROM member_posts WHERE member_channel_id = param_channel_id;
        DELETE FROM member_channels WHERE member_channel_id = param_channel_id;
 
        IF NOT EXISTS (SELECT member_channel_id FROM member_channels WHERE volow_member_id = param_volow_member_id) THEN
        BEGIN
                UPDATE volow_members SET is_channel_created = FALSE;
 
                SET param_is_channel_created = FALSE;
        END;
        END IF;
END
 
but nothing is happending and I am sure all are ok because I change something in the storedprocedure and I got and error but with the above I don''t get any error and page is just reloading with the same data when I click the delete button?
 
Kindly help...
AnswerRe: weird problems: nothing is happening!! Pinmemberjkirkerx5-Oct-12 8:43 
GeneralRe: weird problems: nothing is happening!! Pinmemberjrahma5-Oct-12 9:36 
AnswerRe: weird problems: nothing is happening!! PinmemberVijayChauhan1237-Oct-12 20:15 
AnswerRe: weird problems: nothing is happening!! PinmemberSunil from Pune8-Oct-12 5:27 
GeneralRe: weird problems: nothing is happening!! Pinmemberjrahma8-Oct-12 6:52 
GeneralRe: weird problems: nothing is happening!! Pinmemberjrahma8-Oct-12 7:09 
GeneralRe: weird problems: nothing is happening!! Pinmemberjrahma8-Oct-12 7:10 
GeneralRe: weird problems: nothing is happening!! PinmemberSunil from Pune8-Oct-12 21:06 
QuestionHow to Develop asp.net application to control Time and authenticationfingerprint Device such as get user ID Pinmemberosama_hagrass5-Oct-12 3:54 
AnswerDevice PinmemberDavid Mujica5-Oct-12 6:20 
GeneralRe: Device Pinmemberosama_hagrass5-Oct-12 7:25 
GeneralRe: Device PinmemberVijayChauhan1237-Oct-12 20:19 
Questionhow to Run an URL inside a WCF webservice, the URL return a mp3/zip file Pinmemberfindprasad5-Oct-12 3:50 
Questionworking with menu control in asp.net 2.0 Pinmemberrimjhim_45-Oct-12 2:21 
AnswerRe: working with menu control in asp.net 2.0 PinmvpSandeep Mewara5-Oct-12 2:28 
AnswerRe: working with menu control in asp.net 2.0 PinmemberVijayChauhan1237-Oct-12 20:21 
QuestionMVC PinmemberJabbarJahambana4-Oct-12 22: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
Web01 | 2.8.141022.1 | Last Updated 22 Oct 2014
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid