|
I even tried this simple delete but still not working. No error and records not getting deleted!!!
sql_connection = new MySqlConnection(ConfigurationManager.ConnectionStrings["SQLdb"].ConnectionString);
sql_command = new MySqlCommand("sp_delete_channel", sql_connection);
sql_command.CommandType = CommandType.StoredProcedure;
sql_connection.Open();
sql_command.Parameters.AddWithValue("param_channel_id", channel_id).MySqlDbType = MySqlDbType.Int32;
int result_row = sql_command.ExecuteNonQuery();
and SQL:
CREATE DEFINER=`root`@`localhost` PROCEDURE `sp_delete_channel`(IN param_channel_id int, IN param_volow_member_id int, OUT param_is_channel_created bit)
BEGIN
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;
ELSE SET param_is_channel_created = TRUE;
END IF;
END
|
|
|
|
|
Can you check if the SP itself works as expected by passing parameters (from ssms itself)
|
|
|
|
|
How to Develop asp.net application to control Time and authentication fingerprint Device such as get user ID from Device,enroll new user and act..
Thanks All...
|
|
|
|
|
You need to start with the manufacturer of the device. The vendor will have a programming guide or API that will allow you to communicate with the device. There is no industry standard for communicating to these devices.
|
|
|
|
|
After getting API of Device,what's the next step in programming and How can i deal with API in asp.net,because it is first time to deal with api in c# programming
THanks David...
|
|
|
|
|
There will be already developed dll's or functions, you can call them directly...
this is very interesting and very easy, once you jump into that you will feel cool.
|
|
|
|
|
HI
Is there any working solution for how to Run an URL inside a WCF webservice, the URL return a mp3/zip file.
and output of the web service also return those mp3/zip file with prompt "open/save" options in the browser.
my aim to be restrict End user not to know the actual download URL.
I am using below code, but this will not asking for prompt(open/save), i need to specify the path . it get faild if that path is not found any PC
ex: http://download.microsoft.com/download/C/9/4/C94B7FA8-E35F-4C96-8B35-7B183918298F/HDI_ITPro_MSDN_mp3_Installing_ASP_NET_and_Tools_v2.mp3
string remoteUri ="http://download.microsoft.com/download/C/9/4/C94B7FA8-E35F-4C96-8B35-7B183918298F/HDI_ITPro_MSDN_mp3_Installing_ASP_NET_and_Tools_v2.mp3";
string fileName = AppDomain.CurrentDomain.BaseDirectory +"\download\Tools_v2.mp3", myStringWebResource = null;
WebClient myWebClient2 = new WebClient();
myStringWebResource = remoteUri + fileName;
myWebClient2.DownloadFile(myStringWebResource, fileName);
|
|
|
|
|
how to bind menu from database in asp 2.0?
after this i want to display sub menu on the mouse hover in the menu items?
after this i want to display sub sub menu on the mouse hover on the sub menu items?
thanks in advance
|
|
|
|
|
|
|
How can i get value of user entered Description using jquery to use in Model.cs class
@Html.EditorFor(model => model.Description, null, "Description", null)
|
|
|
|
|
|
Hi..which software is best for recording screen videos with audio to make tutorials of programming examples...?
|
|
|
|
|
|
|
what is the use of deploying and setup of websites and when they are helpful?
pravn
|
|
|
|
|
Praveen Reddy(ganni) wrote: what is the use of deploying and setup of websites
This enables one to access the hosted website anywhere in the world using internet at any time.
|
|
|
|
|
3 types of SQL-cache dependencies exist:
a. Other cache items.
b. Files/folders.
c. Dependencies on a database query.
|
|
|
|
|
This is not a well framed question! We cannot work out what you are trying to do/ask from the post. Please elaborate and be specific.
Use the "Edit" link to edit your question and provide better information.
|
|
|
|
|
OP is a (ex-)spammer.
One of these days I'm going to think of a really clever signature.
|
|
|
|
|
Oh!
Thanks Richard for sharing the information.
|
|
|
|
|
Hi All,
I am getting "Microsoft JScript runtime error: Object doesn't support property or method" while running simple asp.net web application. I have not used any of the javascript in the application but still i am getting this error when I debug the application. Please let me know if there is any setting or anything else which i need to do to resolve this issue.
Note: I am using VS2010 and IE8.
Thanks in advance.
|
|
|
|
|
Look at the line and location where it is raising this error. If you have not used any JavaScript then probably a missing reference but some JS is getting executed and is raising the error.
Based on the error, some object is trying to use a property or method which does not exists.
|
|
|
|
|
Are you using AJAX in that?
|
|
|
|
|
guys please tell me how convert sys date 04-10-2012 to dd-MM-yyyy and who to get system datetime format
|
|
|
|