Device - ASP.NET Discussion Boards

First Prev Next

Re: weird problems: nothing is happening!!

Rockstar_7-Oct-12 20:15

Rockstar_

7-Oct-12 20:15

May be your gridview data is not refreshing because of the dataset , please check, and Is this deleted from the database?

Re: weird problems: nothing is happening!!

Sunil_Nikam8-Oct-12 5:27

Sunil_Nikam

8-Oct-12 5:27

Please check the value of "int result_rows" also at first glance it seems that "IF NOT EXISTS" part wont be executed atall returning always "param_is_channel_created = TRUE"

Re: weird problems: nothing is happening!!

Jassim Rahma8-Oct-12 6:52

Jassim Rahma

8-Oct-12 6:52

there is datagrid VijayChauhan123

Sunil: the DELETE is before the IF NOT EXIST so it should have been invoked.

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!