Click here to Skip to main content
11,630,144 members (80,573 online)
   

ASP.NET

 
AnswerRe: gridview rowupdating in ascx file Pin
Sarvesh Kushwaha8-Oct-12 5:23
memberSarvesh Kushwaha8-Oct-12 5:23 
Question'System.Web.HttpUnhandledException' Error Pin
rattlesnake3167-Oct-12 17:55
memberrattlesnake3167-Oct-12 17:55 
AnswerRe: 'System.Web.HttpUnhandledException' Error Pin
Eddy Vluggen8-Oct-12 0:50
memberEddy Vluggen8-Oct-12 0:50 
AnswerRe: 'System.Web.HttpUnhandledException' Error Pin
Joshua Omundson9-Oct-12 6:50
memberJoshua Omundson9-Oct-12 6:50 
QuestionIntegrate SharpWebMail in existing project Pin
Soni19856-Oct-12 8:44
memberSoni19856-Oct-12 8:44 
QuestionThe 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine. Pin
Ali Al Omairi(Abu AlHassan)6-Oct-12 5:38
memberAli Al Omairi(Abu AlHassan)6-Oct-12 5:38 
AnswerRe: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine. Pin
ProgramFOX6-Oct-12 7:00
memberProgramFOX6-Oct-12 7:00 
GeneralAccess Database Engine 2010 Redistributable is not intended Pin
David Mujica8-Oct-12 2:56
memberDavid Mujica8-Oct-12 2:56 
GeneralRe: Access Database Engine 2010 Redistributable is not intended Pin
n.podbielski9-Oct-12 0:28
membern.podbielski9-Oct-12 0:28 
AnswerRe: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine. Pin
Murugan_vdm14-Oct-12 3:22
memberMurugan_vdm14-Oct-12 3:22 
QuestionRandomize Data of Groupboxes Pin
ASPnoob5-Oct-12 23:38
memberASPnoob5-Oct-12 23:38 
AnswerRe: Randomize Data of Groupboxes Pin
VijayChauhan1237-Oct-12 20:10
memberVijayChauhan1237-Oct-12 20:10 
AnswerRe: Randomize Data of Groupboxes Pin
VijayChauhan1237-Oct-12 20:46
memberVijayChauhan1237-Oct-12 20:46 
Questionweird problems: nothing is happening!! Pin
jrahma5-Oct-12 6:50
memberjrahma5-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!! Pin
jkirkerx5-Oct-12 8:43
memberjkirkerx5-Oct-12 8:43 
GeneralRe: weird problems: nothing is happening!! Pin
jrahma5-Oct-12 9:36
memberjrahma5-Oct-12 9:36 
AnswerRe: weird problems: nothing is happening!! Pin
VijayChauhan1237-Oct-12 20:15
memberVijayChauhan1237-Oct-12 20:15 
AnswerRe: weird problems: nothing is happening!! Pin
Sunil from Pune8-Oct-12 5:27
memberSunil from Pune8-Oct-12 5:27 
GeneralRe: weird problems: nothing is happening!! Pin
jrahma8-Oct-12 6:52
memberjrahma8-Oct-12 6:52 
GeneralRe: weird problems: nothing is happening!! Pin
jrahma8-Oct-12 7:09
memberjrahma8-Oct-12 7:09 
GeneralRe: weird problems: nothing is happening!! Pin
jrahma8-Oct-12 7:10
memberjrahma8-Oct-12 7:10 
GeneralRe: weird problems: nothing is happening!! Pin
Sunil from Pune8-Oct-12 21:06
memberSunil from Pune8-Oct-12 21:06 
QuestionHow to Develop asp.net application to control Time and authenticationfingerprint Device such as get user ID Pin
osama_hagrass5-Oct-12 3:54
memberosama_hagrass5-Oct-12 3:54 
AnswerDevice Pin
David Mujica5-Oct-12 6:20
memberDavid Mujica5-Oct-12 6:20 
GeneralRe: Device Pin
osama_hagrass5-Oct-12 7:25
memberosama_hagrass5-Oct-12 7:25 
GeneralRe: Device Pin
VijayChauhan1237-Oct-12 20:19
memberVijayChauhan1237-Oct-12 20:19 
Questionhow to Run an URL inside a WCF webservice, the URL return a mp3/zip file Pin
findprasad5-Oct-12 3:50
memberfindprasad5-Oct-12 3:50 
Questionworking with menu control in asp.net 2.0 Pin
rimjhim_45-Oct-12 2:21
memberrimjhim_45-Oct-12 2:21 
AnswerRe: working with menu control in asp.net 2.0 Pin
Sandeep Mewara5-Oct-12 2:28
mvpSandeep Mewara5-Oct-12 2:28 
AnswerRe: working with menu control in asp.net 2.0 Pin
VijayChauhan1237-Oct-12 20:21
memberVijayChauhan1237-Oct-12 20:21 
QuestionMVC Pin
JabbarJahambana4-Oct-12 22:52
memberJabbarJahambana4-Oct-12 22:52 
AnswerRe: MVC Pin
Sandeep Mewara5-Oct-12 2:47
mvpSandeep Mewara5-Oct-12 2:47 
QuestionRecording Screen Work Pin
Pawan Mehra4-Oct-12 22:46
memberPawan Mehra4-Oct-12 22:46 
AnswerRe: Recording Screen Work Pin
Sandeep Mewara5-Oct-12 2:30
mvpSandeep Mewara5-Oct-12 2:30 
AnswerCamtasia Studio Pin
David Mujica5-Oct-12 3:15
memberDavid Mujica5-Oct-12 3:15 
GeneralSetUp Projects Pin
Praveen Reddy(ganni)4-Oct-12 21:04
memberPraveen Reddy(ganni)4-Oct-12 21:04 
AnswerRe: SetUp Projects Pin
Sandeep Mewara5-Oct-12 2:32
mvpSandeep Mewara5-Oct-12 2:32 
QuestionSQL Cache Dependency in ASP.NET Pin
hiredotnet4-Oct-12 20:54
memberhiredotnet4-Oct-12 20:54 
AnswerRe: SQL Cache Dependency in ASP.NET Pin
Sandeep Mewara5-Oct-12 2:38
mvpSandeep Mewara5-Oct-12 2:38 
GeneralRe: SQL Cache Dependency in ASP.NET Pin
Richard MacCutchan5-Oct-12 2:48
mvpRichard MacCutchan5-Oct-12 2:48 
GeneralRe: SQL Cache Dependency in ASP.NET Pin
Sandeep Mewara5-Oct-12 2:51
mvpSandeep Mewara5-Oct-12 2:51 
QuestionMicrosoft JScript runtime error: Object doesn't support property or method while running simple asp.net web application Pin
Nitin K4-Oct-12 20:35
memberNitin K4-Oct-12 20:35 
AnswerRe: Microsoft JScript runtime error: Object doesn't support property or method while running simple asp.net web application Pin
Sandeep Mewara4-Oct-12 20:49
mvpSandeep Mewara4-Oct-12 20:49 
AnswerRe: Microsoft JScript runtime error: Object doesn't support property or method while running simple asp.net web application Pin
VijayChauhan1237-Oct-12 20:42
memberVijayChauhan1237-Oct-12 20:42 
QuestionDate & Time in ASP.net Pin
bsshowriraju00014-Oct-12 3:27
memberbsshowriraju00014-Oct-12 3:27 
AnswerRe: Date & Time in ASP.net Pin
Wes Aday4-Oct-12 5:30
memberWes Aday4-Oct-12 5:30 
AnswerRe: Date & Time in ASP.net Pin
jkirkerx4-Oct-12 10:06
memberjkirkerx4-Oct-12 10:06 
AnswerRe: Date & Time in ASP.net Pin
Aysha Patel4-Oct-12 21:09
memberAysha Patel4-Oct-12 21:09 
AnswerRe: Date & Time in ASP.net Pin
KiranKumar Roy14-Oct-12 2:37
memberKiranKumar Roy14-Oct-12 2:37 
QuestionWCF Hosting Pin
prakashpp4-Oct-12 0:58
memberprakashpp4-Oct-12 0:58 

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.150723.1 | Last Updated 27 Jul 2015
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid