how to Run an URL inside a WCF webservice, the URL return a mp3/zip file - ASP.NET Discussion Boards

First Prev Next

Re: weird problems: nothing is happening!!

Jassim Rahma8-Oct-12 7:09

Jassim Rahma

8-Oct-12 7:09

I even tried this simple delete but still not working:

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:

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

Re: weird problems: nothing is happening!!

Jassim Rahma8-Oct-12 7:10

Jassim Rahma

8-Oct-12 7:10

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:

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

Re: weird problems: nothing is happening!!

Sunil_Nikam8-Oct-12 21:06

Sunil_Nikam

8-Oct-12 21:06

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 authenticationfingerprint Device such as get user ID

osama_hagrass5-Oct-12 3:54

osama_hagrass

5-Oct-12 3:54

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...

Device

David Mujica5-Oct-12 6:20

David Mujica

5-Oct-12 6:20

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.

Re: Device

osama_hagrass5-Oct-12 7:25

osama_hagrass

5-Oct-12 7:25

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...

Re: Device

Rockstar_7-Oct-12 20:19

Rockstar_

7-Oct-12 20:19

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.

how to Run an URL inside a WCF webservice, the URL return a mp3/zip file

findprasad5-Oct-12 3:50

findprasad

5-Oct-12 3:50

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);

working with menu control in asp.net 2.0

rimjhim_45-Oct-12 2:21

rimjhim_4

5-Oct-12 2:21

CSS

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

Re: working with menu control in asp.net 2.0

Sandeep Mewara5-Oct-12 2:28

Sandeep Mewara

5-Oct-12 2:28

Here have a look at the following material to show menu from database and have a display of sub menu on hover:
MSDN: ASP.NET Menu Control Overview[^]
Menu and Sub Menu Using JavaScript[^]
Show popup menu anywhere in the screen[^]
Dynamic Menu control in ASP.NET using jQuery[^]

Couple of questions related to menu answered:
How to menu control dynamically with child menu controls[^]
Menu in Asp.net[^]

Pick one that you are looking for, try out and post specific issue if faced.

Sandeep Mewara
Microsoft ASP.NET MVP

[My latest Article]: Server side Delimiters in ASP.NET[^]

Re: working with menu control in asp.net 2.0

Rockstar_7-Oct-12 20:21

Rockstar_

7-Oct-12 20:21

Once you go through the below link...

http://aspalliance.com/822_Building_a_Database_Driven_Hierarchical_Menu_using_ASPNET_20[^]

MVC

JabbarJahambana4-Oct-12 22:52

JabbarJahambana

4-Oct-12 22:52

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)

Re: MVC

Sandeep Mewara5-Oct-12 2:47

Sandeep Mewara

5-Oct-12 2:47

You would need a defined editor with ID defined.

Following will help you understand usage of jQuery with MVC: ASP.NET MVC3 Razor With jQuery For Beginners[^]

Sandeep Mewara
Microsoft ASP.NET MVP

[My latest Article]: Server side Delimiters in ASP.NET[^]

Recording Screen Work

Pawan Mehra4-Oct-12 22:46

Pawan Mehra

4-Oct-12 22:46

Hi..which software is best for recording screen videos with audio to make tutorials of programming examples...?

Re: Recording Screen Work

Sandeep Mewara5-Oct-12 2:30

Sandeep Mewara

5-Oct-12 2:30

Posting the question in the following forum would be more appropriate and everyone can suggest: http://www.codeproject.com/Forums/1627782/Free-Tools.aspx[^]

May be CamStudio but not sure. Others can suggest.

Sandeep Mewara
Microsoft ASP.NET MVP

[My latest Article]: Server side Delimiters in ASP.NET[^]

Camtasia Studio

David Mujica5-Oct-12 3:15

David Mujica

5-Oct-12 3:15

I've played with this a bit and plan on purchasing it this year ...

http://www.techsmith.com/camtasia.html[^]

SetUp Projects

Praveen Reddy(ganni)4-Oct-12 21:04

Praveen Reddy(ganni)

4-Oct-12 21:04

what is the use of deploying and setup of websites and when they are helpful?

pravn

Re: SetUp Projects

Sandeep Mewara5-Oct-12 2:32

Sandeep Mewara

5-Oct-12 2:32

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.

Sandeep Mewara
Microsoft ASP.NET MVP

[My latest Article]: Server side Delimiters in ASP.NET[^]

SQL Cache Dependency in ASP.NET

hiredotnet4-Oct-12 20:54

hiredotnet

4-Oct-12 20:54

3 types of SQL-cache dependencies exist:

a. Other cache items.
b. Files/folders.
c. Dependencies on a database query.

Custom and high Qualified ASP.Net Web Development Services

Re: SQL Cache Dependency in ASP.NET

Sandeep Mewara5-Oct-12 2:38

Sandeep Mewara

5-Oct-12 2:38

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.

Sandeep Mewara
Microsoft ASP.NET MVP

[My latest Article]: Server side Delimiters in ASP.NET[^]

Re: SQL Cache Dependency in ASP.NET

Richard MacCutchan5-Oct-12 2:48

Richard MacCutchan

5-Oct-12 2:48

OP is a (ex-)spammer.

One of these days I'm going to think of a really clever signature.

Re: SQL Cache Dependency in ASP.NET

Sandeep Mewara5-Oct-12 2:51

Sandeep Mewara

5-Oct-12 2:51

Oh!

Thanks Richard for sharing the information. Thumbs Up | :thumbsup:

Sandeep Mewara
Microsoft ASP.NET MVP

[My latest Article]: Server side Delimiters in ASP.NET[^]

Microsoft JScript runtime error: Object doesn't support property or method while running simple asp.net web application

Nitin K4-Oct-12 20:35

Nitin K

4-Oct-12 20:35

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.

Re: Microsoft JScript runtime error: Object doesn't support property or method while running simple asp.net web application

Sandeep Mewara4-Oct-12 20:49

Sandeep Mewara

4-Oct-12 20:49

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.

Sandeep Mewara
Microsoft ASP.NET MVP

[My latest Article]: Server side Delimiters in ASP.NET[^]

Re: Microsoft JScript runtime error: Object doesn't support property or method while running simple asp.net web application

Rockstar_7-Oct-12 20:42

Rockstar_

7-Oct-12 20:42

Are you using AJAX in that?

Last Visit: 31-Dec-99 18:00 Last Update: 7-May-24 12:37

Refresh

ᐊ Prev 1...445 446 447 448449450 451 452 453 454 Next ᐅ

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