Re: Input string was not in a correct format - ASP.NET Discussion Boards

First Prev Next

Re: Perpetual Pop Up associated with application, not page

toltec777-Aug-12 11:02

toltec77

7-Aug-12 11:02

Thanks for the feedback jkirkerx, although, I have tried this method, but, as I said, when I browse to other pages in the application, or actually even when refreshing the same page, I appear to lose the parent/child relationship between the opener and the imageBrowser. When the opening page has been refreshed, the imageBrowser object is null again. I need to know if I can somehow keep this objects value after multiple postbacks, not just to the same page, but across multiple pages within the application.

As I said "continue browsing through the applications various pages" I had assumed that this would discount modal windows (which I had used, but the client wants to be able to browse other pages whilst keeping the help page open).

Also, closing the application means logging out/closing the session. They could just close the window they are using, but not sure if I can log them out properly that way, that would just end their session, but I wouldn't be doing it.

Hope this clears it up a bit.

Re: Perpetual Pop Up associated with application, not page

jkirkerx7-Aug-12 12:33

jkirkerx

7-Aug-12 12:33

Of course your going to lose the connection to the popup window. That's how it suppose to work by default.

You have to understand, that it's not a windows program, each page in a website is completely independent of each other, and have no relationship, nor to they share data.

In the DOM, the DOM is only valid for the page that created it, when you load a new page, a new DOM is created, breaking all ties to the old DOM.

Like I asked, what is an application?, a control, a page, or and entire website.

I don't know how to extend a DOM across multiple pages, and don't think it's possible. It's sounds like your design exceeds the limitation of a web page.

[EDIT]
this is an explanation of how the DOM works, it's limitations, and various DOM objects that you can access

Also, your post has nothing to do with asp.net, it's a client side javascript issue.

[Document Object Model^]

modified 7-Aug-12 18:51pm.

Re: Perpetual Pop Up associated with application, not page

toltec777-Aug-12 12:49

toltec77

7-Aug-12 12:49

Thanks jkirkerx, I was thinking that was how it worked, but the client is very adamant. I was wondering if there was documentation from Microsoft (the application/website is specifically for ie 7 and above only) that verifies this, as my word apparently is not good enough for the client, they need verification that it is unachievable, and I have not been able to locate any.

"or and entire website."

As I said "continue browsing through the applications various pages", I thought this would clear it up? Sorry, but perhaps I am wording it incorrectly? The 'application' is an entire website (although, it consists of only a few pages)

Thanks, and sorry if I was unclear.

Re: Perpetual Pop Up associated with application, not page

jkirkerx7-Aug-12 13:33

jkirkerx

7-Aug-12 13:33

Not at the moment, there's not much on the subject that actually states that. It is assumed that the anonomy of a web page is a single page request from the server in which the browser parses the elements to create a DOM from the body element.

http://www.cornae.com/articles/anatomy-of-a-web-document[^]

Make a post in the Javascript discussion, and perhaps you'll get an answer in a day or so,

Make sure your very very clear in your description, or you will be laughed at, and not taken seriously.

There are work arounds, such as creating 1 superpage, in which the content updates from a web service, and the user never leaves the 1 superpage. But that will takes about 10K lines of Javascript or Jquery and tons of back end server side work.

New Idea

jkirkerx8-Aug-12 7:56

jkirkerx

8-Aug-12 7:56

I was thinking last night,

This was posted in the JavaScript Discussion

[obfuscated malware^]

It's a piece of malware that was injected into the OP's website. It's quite clever, It uses a hidden iframe that is positioned in the upper left corner of the browser, off the page where it can't be seen, and calls a web page from another server to do something, perhaps ease drop, or download something evil. These guys are quite genius at this stuff.

Anyone correct me if I'm wrong on this

I think a hidden iframe like that can be used to host the master JavaScript, that can communicate with a popup, and the main frame at the same time. Each time the main page changes, it can reestablish a communication link with the hidden iframe.

http://mentaljetsam.wordpress.com/2010/03/15/communicating-between-iframes-and-windows-in-javascript/[^]

I hope I don't any flack for promoting the use of this. But it would be pretty cool once it was working. Might want to use the bytes as well so you don't give up the trade secret as to how you did it.

Input string was not in a correct format

Jassim Rahma6-Aug-12 11:17

Jassim Rahma

6-Aug-12 11:17

Hi,

Why I am getting the following error:

Input string was not in a correct format.

here is my code:

sql_connection = new MySqlConnection(ConfigurationManager.ConnectionStrings["SQLdb"].ConnectionString);
sql_connection.Open();
sql_command = new MySqlCommand("sp_add_new_volow_member", sql_connection);
sql_command.CommandType = CommandType.StoredProcedure;
sql_command.CommandTimeout = 300;
 
sql_command.Parameters.AddWithValue("param_full_name", txtSignupFullName.Text.Trim()).MySqlDbType = MySqlDbType.VarChar;
sql_command.Parameters.AddWithValue("param_email_address", txtSignupEmailAddress.Text.Trim()).MySqlDbType = MySqlDbType.VarChar;
sql_command.Parameters.AddWithValue("param_login_password", txtSignupPassword.Text.Trim()).MySqlDbType = MySqlDbType.VarChar;
 
sql_command.Parameters.AddWithValue("param_record_identity", MySqlDbType.Int32).Direction = ParameterDirection.Output;
sql_command.Parameters.AddWithValue("param_record_guid", MySqlDbType.VarChar).Direction = ParameterDirection.Output;
sql_command.Parameters.AddWithValue("param_is_exist", MySqlDbType.Bit).Direction = ParameterDirection.Output;
 
// execute the query;
int result_rows = sql_command.ExecuteNonQuery();

and this is my SQL:

SQL

CREATE DEFINER=`root`@`localhost` PROCEDURE `sp_add_new_volow_member`(IN param_full_name varchar(255), IN param_email_address varchar(255), IN param_login_password varchar(255), OUT param_record_identity int, OUT param_record_guid varchar(255), OUT param_is_exist bit)
BEGIN
    SET param_is_exist  = FALSE;

    INSERT INTO volow_members (volow_member_full_name, volow_member_email, volow_member_password) VALUES (param_full_name, param_email_address, param_login_password);

    SET param_record_identity = LAST_INSERT_ID();
    SET param_record_guid = 'abc';
END

Re: Input string was not in a correct format

jkirkerx6-Aug-12 12:57

jkirkerx

6-Aug-12 12:57

Did you ever bother to check your sql char arrays, and feed them in manually to your database using a management tool, to make sure they work first.

Then test your connection by just selecting records, to make sure your connector works

jrahma wrote:
DEFINER=`root`@`localhost`

you have too many quotes

jrahma wrote:
sql_connection = new MySqlConnection(ConfigurationManager.ConnectionStrings["SQLdb"].ConnectionString);
sql_connection.Open();

Usually you program your parameters before you open the connection

Your code looks strange to me, and your use of parameters does not look well formatted. The parameters are individual objects, that you add to the SQLCommand, once you build your parameters, you open the database, execute, and close it.

Dim strConnString As String = GetSQLConnString()
Dim objConn As New SqlConnection(strConnString)

Dim strSQL As String = "DELETE FROM ProductInfo WHERE ProductID=@ProductID"
Dim objCmd As New SqlCommand(strSQL, objConn)

Dim paramProductID As SqlParameter
paramProductID = New SqlParameter("@ProductID", SqlDbType.Int)
paramProductID.Value = ProductID
objCmd.Parameters.Add(paramProductID)

Try
    'Delete the record in the database
    objConn.Open()
    objCmd.ExecuteNonQuery()
    objConn.Close()
    Success = True

Catch ex As Exception
    Success = False

End Try

objCmd = Nothing
objConn = Nothing

Re: Input string was not in a correct format

Shameel6-Aug-12 23:43

Shameel

6-Aug-12 23:43

I suspect that the problem is with the 3 lines lines starting with:

sql_command.Parameters.AddWithValue("param_record_identity", MySqlDbType.Int32)

AddWithValue expects you to provide the actual values to the parameters instead of the data types (as in the preceeding 2 lines).

asp.net popup window

rachel_m6-Aug-12 6:50

rachel_m

6-Aug-12 6:50

In a C# 2010 form application, I want to change an existing display from being a textbox, to being a popup new window where the user can enter data. Basically there is not enough room for a user to enter a large volume of notes.

Thus can you tell me how a user can click on an existing textbox, and a new window will showup for the user to enter the data. The user will click a save button, the data will be updated in the database potnetially and the user will return to the original window.

I would like to see this using ajax and non ajax code.

Re: asp.net popup window

jkirkerx6-Aug-12 7:28

jkirkerx

6-Aug-12 7:28

I always wanted to try grow ui, tryed it once, but no luck, but your suppose to be able to grow the textbox larger, and shrink it back

[Grow UI^]

Re: asp.net popup window

Deflinek8-Aug-12 22:28

Deflinek

8-Aug-12 22:28

Please take a look at jQuery UI, especially the dialog component:
http://jqueryui.com/demos/dialog/#modal-form[^]

Using or not ajax is different story as it will only affect whenever whole page will reload or not after user click save.

--
"My software never has bugs. It just develops random features."

Re: asp.net popup window

Vijay Selvaraj27-Aug-12 0:20

Vijay Selvaraj

27-Aug-12 0:20

you can use Div COntrol the div control u setup height and width call div using JQuery Method

Optimize emails on mobile devices through Exact Target

Agentdufffr5-Aug-12 20:53

Agentdufffr

5-Aug-12 20:53

how to optimize emails on mobile devices using the Exact Target api..
Plz let me knw if there exists any api in exact target for the above?

End User Facebook Login

sankar07Ind5-Aug-12 20:03

sankar07Ind

5-Aug-12 20:03

Using Facebook Login how to login my website.

Sankar.R

why connection attempt failed?

Jassim Rahma5-Aug-12 12:03

Jassim Rahma

5-Aug-12 12:03

I am getting the following error:

A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond

I am only trying a simple INSERT procedure running on localhost MySQL on my local laptop?

Any possible reason?

Re: why connection attempt failed?

Jassim Rahma5-Aug-12 12:08

Jassim Rahma

5-Aug-12 12:08

here is my ConnectionString:

XML

<add name="SQLdb" connectionString="SERVER=127.0.0.1;Port=3306;DATABASE=myDB; UID=root; PASSWORD=abc123;Connect Timeout=300;" providerName="MySql.Data.MySqlClient"/>

Re: why connection attempt failed?

Wes Aday5-Aug-12 15:52

Wes Aday

5-Aug-12 15:52

Do you have a firewall installed?

Why is common sense not common?
Never argue with an idiot. They will drag you down to their level where they are an expert.
Sometimes it takes a lot of work to be lazy
Please stand in front of my pistol, smile and wait for the flash - JSOP 2012

Re: why connection attempt failed?

Jassim Rahma6-Aug-12 8:33

Jassim Rahma

6-Aug-12 8:33

I did but now I am getting this:

Input string was not in a correct format.

here is my code:

sql_connection = new MySqlConnection(ConfigurationManager.ConnectionStrings["SQLdb"].ConnectionString);
sql_connection.Open();
sql_command = new MySqlCommand("sp_add_new_volow_member", sql_connection);
sql_command.CommandType = CommandType.StoredProcedure;
sql_command.CommandTimeout = 300;

sql_command.Parameters.AddWithValue("param_full_name", txtSignupFullName.Text.Trim()).MySqlDbType = MySqlDbType.VarChar;
sql_command.Parameters.AddWithValue("param_email_address", txtSignupEmailAddress.Text.Trim()).MySqlDbType = MySqlDbType.VarChar;
sql_command.Parameters.AddWithValue("param_login_password", txtSignupPassword.Text.Trim()).MySqlDbType = MySqlDbType.VarChar;

sql_command.Parameters.AddWithValue("param_record_identity", MySqlDbType.Int32).Direction = ParameterDirection.Output;
sql_command.Parameters.AddWithValue("param_record_guid", MySqlDbType.VarChar).Direction = ParameterDirection.Output;
sql_command.Parameters.AddWithValue("param_is_exist", MySqlDbType.Bit).Direction = ParameterDirection.Output;

// execute the query;
int result_rows = sql_command.ExecuteNonQuery();