I am facing some problem while reading from CSV file and updating database from the data available in csv file. My problem is that CSV files are too large having atleast 5000 rows and while updating database for each row I need to query database for atleast four times. It means I have to query the database for atleast 200,000 for a single file. This is retarding my application's processing speed and increasing load on machine as well as on database server. Please suggest me how to cope up with this problem?
You should be using DTS (Data Transformation Services) for this, it would drastically bring down the time you would be spending in importing this data. The package can contain conditions and code to suit the business logic.
I have a textbox that was firing Text_changed event when the user press Enter.but now it is not firing any more.But the handler for this event is executed when a postback occur(for example when I click a button).
Could any one tell me how to solve this problem and make it working as before(when the user press Enter)?
The TextChanged event is a server event, so it can only fire during a postback.
When you press enter, it can either be caught by the focused control (if it is a textarea, a select or a button) or by the form. If the form catches it, it will act as if the first button in the form was clicked.
if u r asking for binding the combo box then here's the code
dim con as new oledbconnection("connsctionsting")
dim ds as new dataset
dim ad as new oledbdataadapter("query",con)
Select Datagridview. Now Click on smart tag which is on top Right corner then select Option "Edit Column".Now select the column from selected column list which is of combo box type. Now Select Property Items(collection Type) and Press the associated button button.
Function MailComponent(ByVal mailTo As String, ByVal cc As String, ByVal Bcc As String, ByVal subject As String,byval bodyofMessage as string)
Dim str, body As String
str = ""
If bodyofMessage Is Nothing Then
body = bodyofMessage
If cc Is Nothing Then
cc = ""
If Bcc Is Nothing Then
Bcc = ""
If subject Is Nothing Then
subject = ""
'string builder used for concatination
Dim MsgBuilder As New System.Text.StringBuilder
MsgBuilder.Append("mailto:" & mailTo)
If Not cc.Trim = "" Then
MsgBuilder.Append("&cc=" & cc)
If Not Bcc.Trim = "" Then
MsgBuilder.Append("&bcc=" & Bcc)
If Not subject.Trim = "" Then
MsgBuilder.Append("&subject=" & subject)
If Not Body.Trim = "" Then
MsgBuilder.Append("&body=" & Body)
If Not Attachment.Trim = "" Then
MsgBuilder.Append("&Attach=" & Attachment)
Function ExecuteFile(ByVal FileName As String) As Boolean
Dim myProcess As New Process
myProcess.StartInfo.FileName = FileName
myProcess.StartInfo.UseShellExecute = True
myProcess.StartInfo.RedirectStandardOutput = False
Christian Graus - Microsoft MVP - C++ Metal Musings - Rex and my new metal blog
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )