I have another question concerning the bulk insert. I am doing a bulk insert from a text file like (delimiter is | and I have 2 columns):
1|12334
2|23232
How can I check if the user has a file like:
1|12234|2323
2|23233
I mean how to check the wrong columns numbers.
i am having a folder which contains 100 files and each file contain the columns separated by the ' |(pipeline)' and similarly that file contain data also.so i need to bulk upload this folder to the ms sqlserver2005 so that automatically these tables with data added in the database so how to do that one? tell me if any store procedure or the any asp.net program is available for that.
View 1 RepliesAs an extensibility option for my web application I would like to allow the user to add sections to it by simply making new folders and uploading files to them. So, for instance, if they created (in the webroot): /UserContent/StaticPages/First/Second/index.txt. Then in the main menu there would be a new menu point "First" with the submenu point "Second", which would lead to markdown-parsed version of index.txt. This way the user can upload any static menu points he wants (such as "About us", "Contact us", "Our Mission" etc.) Another extensibility point is that I would like them to add headers/footers to specific webpages in a similar fashion. I'm using ASP.NET MVC3, so there are pretty URLs, and it would be easy for the user to just create: /UserContent/Additions/Store/Categories/35/header.txt
And when someone opened [URL] the markdown-parsed header.txt would be prepended. This is simple for the user, and simple for me (I don't need to make sophisticated admin panels and WYSIWYG editors). However I'm worried about the performance. This scheme means that on each GET request I would need to scan the /UserContent/StaticPages folder and check for the existences of the header/footer files (several, because parent levels can have their header.txt/footer.txt as well).
I could cache the result, but then I have to manage the cache and the user will need to know that changes can take up to X minutes to display. Would this be a premature optimization? There won't be much data in those folders, so Windows will probably be able to easily cache their contents itself.
i have one multi line text box in my asp page.
while entering content to it , i want to high light the word by red underline if the spelling of word is not correct (just like in word)
i have to do it without using any button , instead while changing text.
How to use ajax for checking username from database on text change?
Also give the method for on button click
in my asp.net C# web page I have a text box and a button. the code in the button click event is
[code]...
How can I make this checking after entering the text in the textbox and pressing theenter key
Is there one simple test that a person can do that covers all options where there could be a null, or "" value. When I google, I see so many options. I see:
if txtBox1.text IsNot nothing
if txtBox1.text.toString isNot nothing
if txtBox1.text <> ""
if txtBox1.text.toString <> ""
if isNull(txtBox1)
Is there on test that can cover them all?
My Visual Studio 2005 program doesn't open CSS files properly - when I open them in VS, it opens them as a text file. It is annoying because if I do something wrong, it doesn't show up the error and I have to sift through it all to try and find out what is wrong. Plus it doesn't show up the hints for the attributes.
View 5 RepliesI have a FormView that is loaded with a records from my DB. Some of the fields may be blank or null. I am trying to check the value of some of the text boxes to verify that the user has updated the fields prior to allowing a DB update from the Edit Template.
I can not seem to get the correct syntax on the if statment to check the value of the text box....
[Code]....
I have uploaded some tab-delimited .txt files on my web site (actually run on my computer, ie localhost, for now), and now I try to retrieve the data from those files. I do this by calling a vb file containg the sub below. Everything works great, except that the sub won't recognise unicode characters. I can split the resulting string using vbnewline and vbtab, but already in the sub in question, the string doesn't understand the Swedish letters åäö, apostrophes and more.
Shared
Function getTextfile(ByVal FullPath
As
String,
Optional
ByRef ErrInfo
As
String =
"")
As
String
Dim strContents
As
String =
""
Dim objReader
As StreamReader
Try
objReader =New StreamReader(FullPath)
'UTF8Encoding?
strContents = objReader.ReadToEnd()
objReader.Close()
ErrInfo = Ex.MessageCatch Ex
As Exception
End
Try
Return strContents
End
Function
I'm now working on a application which needs some pdf files (size 200kb -1Mb) to be stored into Mysql database.
View 2 Repliesi'm using stream writer to write a text file on client machine, but everytime while i'm writing a new file it over writes the existing one..so now i need to write seperate file each time ...and also i need to create a folder dynamically for first time and save text files in that folder when everytime i use my application....
View 3 RepliesI have write small web-service that recieves query and read txt file for matching. For it I'm using StreamReader.
I'm not waiting that it will be thousands of users in hour for this service, but whats worried me - if some users at the same time will be use that service is it ok? Can text file on server side be readed at same time from some users?
What is capacity for using StreamReader or StreamWriter on server?
How can I remove the text box associated with a Browse button on my email page?The text box is redundant since I am attaching files (file upload) to my email message one at a time. Or, is there a standard function such as the Link (Attach a File) in Gmail that opens the user's hard drive directory?
View 2 RepliesHow can I allow my website visitors to create text files in ASP.NET?
View 2 RepliesI need drag and drop any textfiles into richtextbox from desktop and get filepath and icon in the rich textbox. then on double click the user can open files.
View 1 RepliesI'm developing a CMS aplication in ASP .Net using WebForms and I'm looking for a way to create new PDF files based on a template.
This feature will be used to generate contracts where some placeholders will be replaced with the customer data.
Edited: The templates will be static, the main content will never change from customer to customer, only some text in the beginning that will contain the placeholders to recive the customer data. The catch is that I must allow the owner of the application to upload new templates in PDF, with the predetermined placeholders in it to allow the replacement to occur.
I'm developing a CMS aplication in ASP .Net using WebForms and I'm looking for a way to create new PDF files based on a template.
This feature will be used to generate contracts where some placeholders will be replaced with the customer data.
What's the best approach to do that?
Edited: The templates will be static, the main content will never change from customer to customer, only some text in the beginning that will contain the placeholders to recive the customer data. The catch is that I must allow the owner of the application to upload new templates in PDF, with the predetermined placeholders in it to allow the replacement to occur.
How to restrict the fileuploader control to restrict for notepad only.
If i have choosen the file other than the notepad, it should show me an error.
How to Retrieve .text files from other website folder using webclient
View 4 RepliesI've 100's of text files in a folder and I want to display these files with details view. How can I achieve this?
View 4 RepliesI work on C# .My input file look likes :
d00 d04 WinMain
d00 d04 lpCmdLine: '/UNREGSERVER'
d00 d04 Run
d00 d04
lpCmdLine: '/UNREGSERVER'
d00 d04 nCmdShow: 10
d00 d04 leaving WinMain
[code]....
If i use the multi delimited than error shows.How to use the multi delimited.If i run the code to to load the text file given in above show the bellow error
Input array is longer than the number of columns in this table.
I have some text files I need to parse in order to display my data, and what I have now are two text files with lots of redundant data. Instead of this I would like to replace the redundant data with a number referencing the text in another text file.
View 1 RepliesLooking to build a web application which provides a platform for sending bulk SMS on reasonable rates. Whether i have to sign an agreement with GSM providers for sending SMS or is there an alternative for this? If so, how can i embed the SMS service with my application code?
View 1 RepliesI want to send and receive sms in my asp.net website.I am currently targetting users in India.I may need to send the same sms to thousands of users at the same time.How can I achieve this?
View 4 Replies