|
This is why I don't like IE trying to be clever.
Nail on the head, thanks very much
Mark
|
|
|
|
|
i download the source file of "ImportExportCSV_src" from codeproject and run this coding to import my excel to sql server. its working fine. but the thing is, i have a description column and user will enter more than 2000 characters. when i m importing, only 255 characters are uploading to the database (i declared in database as nvarchar and length 3000). whats the problem? how to resolve it? - KARAN
coding :
DataColumnCollection tableColumns = dsCSV.Tables[0].Columns;
DataRowCollection tableRows = dsCSV.Tables[0].Rows;
OpenConnection();
foreach (DataRow row in tableRows)
{
primary_key = row.ItemArray[1].ToString();
string sqlinsert = "INSERT INTO " + strTableName + "(";
string sqlvalues = "VALUES (";
object[] rowItems = row.ItemArray;
int ctrColumn = 0;
foreach (DataColumn dc in tableColumns)
{
if (ctrColumn < tableColumns.Count)
sqlinsert += "[" + dc.ColumnName.ToString() + "]" + ",";
if (ctrColumn < tableColumns.Count)
sqlvalues += "'" + rowItems[ctrColumn].ToString().Replace("'", "''") + "',";
ctrColumn++;
}
sqlinsert = sqlinsert + sqlvalues;
cmd = new SqlCommand(sqlinsert, conn);
try
{
rowscreated += cmd.ExecuteNonQuery();
strreturn = rowscreated.ToString();
}
catch (SqlException ae)
{
textbox1.Text=ae.ToString();
}
cmd.Dispose();
}
CloseConnection();
the thing is, when i check the row value (row.ItemArray) it can hold only 255 characters. so i cant upload the full 2000 characters. how to proceed this? help me ! - KARAN
|
|
|
|
|
I m using javascript in my project for certain actions ,...
now i dont want to show my javascript to all....
hoe can i hide js file?
Amit Metkar
3i-infotech, Mumbai.
|
|
|
|
|
You can link to it in your page instead of putting script in your page, but if the file is not available to an end user, then they can't use it. So, you cann't hide 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 )
|
|
|
|
|
even if u give the path instead of putting js code in the aspx page, when u save the page that .js file also get saved in the disk.
i dont want even this.
Thanks For the Reply.
Amit Metkar
3i-infotech, Mumbai.
|
|
|
|
|
Well, as I said, you are screwed. Welcome to web development. If you don't give the user your js code, they can't run it. You can't protected it. You can obsfucate it, but that's about it, people can still reuse it.
Why did I get a 1 vote for helping you ?
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 )
|
|
|
|
|
Thanks budy, but u told me what i knew already.
I just wanted to know, any method to hide those things like by encrypting them.
Amit Metkar
3i-infotech, Mumbai.
|
|
|
|
|
Fine - well, would you be better off if I didn't confirm that it can't be done ?
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 didn't mean that way.....
Thanks for the Help....
Amit Metkar
3i-infotech, Mumbai.
|
|
|
|
|
|
Well, if you're happy to force your users to accept an ActiveX control, and you're willing to assume they will do it ( I never accept ActiveX controls from an unknown site ). I would never use it, but if it solves your problem, I am glad.
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 )
|
|
|
|
|
Amit Metkar
3i-infotech, Mumbai.
|
|
|
|
|
you can save the file in js format but in the irregular format ( e.g all the code in one line or use spam code ) ( google do this in the "map" service )
|
|
|
|
|
most sites has forms that contains an image that user must read and enter its contents as string to confirm that this form is filled in humanly.
I have my own ideas to apply this issu.
But I would like to know if there is any standard mechanism
any article, sample code
If none, I will be glad to send my own ideas in an article to CP
Mohammed Gouda
foreach(Minute m in MyLife)
myExperience++;
|
|
|
|
|
It's called CAPTCHA. If you google that, you'll find what exists on the subject. There are many libraries, nothign standard AFAIK
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 )
|
|
|
|
|
Christian Graus wrote: It's called CAPTCHA
Thanks
Christian Graus wrote: Please read this if you don't understand the answer I've given you
I read it once before, and all I was asking for is a key to google it.
Mohammed Gouda
foreach(Minute m in MyLife)
myExperience++;
|
|
|
|
|
Mohammed Gouda wrote: I read it once before, and all I was asking for is a key to google it.
That is my sig, it appears on all my replies. It was not in any way aimed at you.
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 )
|
|
|
|
|
The technology which you are talking about is called Captcha. CAPTCHA stands for Completely Automated Public Turing test to tell Computers and Humans Apart. There is already an excellent article on making and using a Captcha control right here on codeproject. check it out here:http://www.codeproject.com/KB/custom-controls/CaptchaControl.aspx[^]
|
|
|
|
|
Hi
I am using asp.net RSS toolkit
It works fine on local machine but fails on server
Does any1 know what port rss feed goes through?
cheers!
|
|
|
|
|
By default it should be port 80 until Server is configured to run HTTP connections from a different port.
Best Regards,
Sam Xavier
www.componentone.com
|
|
|
|
|
Hi
I am working in Asp.Net. I need to create an xml empty file dynamically without using
add new item. Using code can i create an xml file in the application. I hope to reply for
my question.
Thanks
Guvera
Every Successful Person Have A Painful Story
|
|
|
|
|
It's just text, create it however you like. You can use the DOM ( XmlDocument ), the Xml streaming classes, or even a stringbuilder or just a static string
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 )
|
|
|
|
|
Hello all,
I am developing a application in which user a is taking a survey.Survey contain a number of question. Number of question are not fixed.I am displaying 10 question on each page and on last page or survey i need to display summery of all question and answer that user has selected.Because i don't know number of question a survey has contain where should i redirect to user when he click on next link. A survey may also contain 5 question then in that case next page should be summery or it also contain 50 question so in that case after 5 page 6th page should be summery page. So anybody can tell me how should resolve the problem?
I can't use paging to data list because on last page i need to show finish link, which is not displayed on first pages. Starting pages of survey contain Next and Previous link and last page contain Previous and Finish link
Thanks
Rahul
People Laugh on me Because i am Different but i Laugh on them
Because they all are same.
|
|
|
|
|
Is someone else doing the same, or have I answered this 4 times now ?
Yes, you CAN use the same page over and over. You just need to work out if you're showing the last page of questions and show your finish link accordingly.
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 have posted this question first time.
Can you tell me how can i use the same page again and again?
any link, reference or some information?
When user click on previous link then he must see previous page question and radio button list option selected if he select some option.
People Laugh on me Because i am Different but i Laugh on them
Because they all are same.
|
|
|
|