error while trying to insert the data - ASP.NET Discussion Boards

Yeah, these folks all ask the wrong question, that's the core problem

Christian Graus

Please read this if you don't understand the answer I've given you

"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )

Offcourse ..It is a bit of difficult code...than just javascript code
...but We need that code..Can anyone help us?

try putting this in your code

<Script Language="javascript" runat="server">

javascript:window.history.forward(1);

</Script>

That is close to useless.

Christian Graus

Please read this if you don't understand the answer I've given you

"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )

How come?

*sigh* It's really very trivial. You CANNOT stop the back button. You CAN make every page check if a session variable is set, and if not, redirect to your login page. I use a base class for this.

Christian Graus

Please read this if you don't understand the answer I've given you

"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )

Hi,

Instead of doing a redirect to next page
do a javascript location.href='next_page'

$herin Iranimose

In the database , i have a varchar type field , it's length is 8000.
i am adding one parameter from the code behind.It's type is string and the length is 5645.
After the execution of insert query in the database , it gives the error

Implicit conversion from data type ntext to varchar is not allowed. Use the CONVERT function to run this query.

If you have an apple & I have an apple and we exchange our apples, then each of us will still have only one apple but if you have an idea & I have an idea and we exchange our ideas, then each of us will have two ideas!

Check that the parameter is

parametername.Parameters.Add(new SqlParameter("@fieldname", SqlDbType.VarChar));
parametername.Parameters["@fieldname"].Value = textbox.Text;

not

parametername.Parameters.Add(new SqlParameter("@fieldname", SqlDbType.Text));
parametername.Parameters["@fieldname"].Value = textbox.NText;

i am using dbtype , and varchar is not available in dbtype.

If you have an apple & I have an apple and we exchange our apples, then each of us will still have only one apple but if you have an idea & I have an idea and we exchange our ideas, then each of us will have two ideas!

try Varnumeric

On my vb.net page has following controls
for example:

Label1

dropdowncontrol1

dropdowncontrol2

link1

i am using flyout on link1 click

<cc1:flyout id="Flyout1" runat="server" attachto="link1">

content..

<cc1:flyout>

so whenever flyout is opened , it will display content of flyout as well as from background dropdowncontrol1 and dropdowncontrol2 also seen in that opened flyout.

So How can i disply only flyout content not that dropdownlist controls?

Well, it's clear to me now that your flyout is a third party user control. Doesn't that mean you should ask the vendor ?

Some controls just appear behind drop boxes. That's because of how they are written. I'm not sure of the details, but if your control shows up that way, you need to find another.

Christian Graus

Please read this if you don't understand the answer I've given you

"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )

I answered his question below and then he deleted the opening post!! Mad | :mad:

You're right, I noticed that. I dunno why he deleted it, and then reposted, but at least he finally posted some code ( he previously posted in the C# forum before I pointed him here ).

Christian Graus

Please read this if you don't understand the answer I've given you

"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )

sorry , but i didn't understand properly,

So if u know answer then please send me again

I gave you a good answer, did you understand it ?

Christian Graus

Please read this if you don't understand the answer I've given you

"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )

He actually cross-posted.

Does it matter what I write here? Someone just has to say something about it.

The dropdown box as implemented by M$FT in all their wisdom will always appear "in front' of any true HTML controls. The simplest and best way of blocking it is to place an Iframe in front of it. See this article: http://www.codeproject.com/KB/HTML/dropdown_div.aspx

Jon
Smith & Wesson: The original point and click interface

thanks , My problem is solved

Hello all,
In my sql query in am retrieving some question based on their question id.
question id is nothing but a primary key field in table.I am sending a comma separated question id to sql query as string.
if shows me following error.

Syntax error converting the varchar value '39,40,1,4,35,41,52,54,55,56' to a column of data type int.

my sql query is as follow<br />
select ques.catid,ques.question,ques.qid,ques.subcatid,sub.subcategory from ada_question ques,ata_subcat sub where<br mode=" hold=" /">        ques.subcatid=sub.subcatid and ques.catid=1 and ques.status=1 and ques.qid in (@qid) order by sub.subcatid,ques.qid asc<br />

where @qid contain=all question id(1,2,3).I am sending this question id as string to my function because we cannot separate integer by ","(comma) so i pass it as string and it gives me error.
i have taken

string str=1,2,3,4,5,6

and pass the value to function. where question id is primary key in my table (int)

People Laugh on me Because i am Different but i Laugh on them
Because they all are same.

You didn't know we have a SQL forum ?

Christian Graus

Please read this if you don't understand the answer I've given you

"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )

What control can I use to upload an mp3 or a video on a site. How can I do that with the standard file upload control since it is not allowing me to upload media files.

Thanks

you can use file upload control.
Which problem you are facing while uploading media file?

People Laugh on me Because i am Different but i Laugh on them
Because they all are same.

When i select a media file from the fileupload and press any button on the page the internet explorer loads an error the explorer cannot load the page