|
how can we use SQL IMPORT DATA TOOL in vb.net that can retrieve data from text file and insert in a sql table
|
|
|
|
|
hi every member,
pls help me by posting code in vb.net
i wanted to enter date in textbox and that textox must be masked and how to retrive date in masked textbox from datebase please give me code for it
i am very much in need of it i have surfed every site but couldn't found it useful
give me coding any from you sir
my e_mail id u_rock100@rediffmail.com
umesh
|
|
|
|
|
how do we use the "import data" tool of sqlin vb.net which transforms data from textfile to a tables in sql ?
|
|
|
|
|
An unhandled exception has occurred in your application.
If you click continue, the application will ignore this error and attempt to continue.
If you click Quit the application will be shut down immediately.
See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.
************** Exception Text **************
System.ArgumentException: Column 'AnswerContent' does not belong to table Answer.
at System.Data.DataRow.CheckColumn(DataColumn column)
at System.Data.DataRowView.GetColumnValue(DataColumn column)
at System.Data.DataColumnPropertyDescriptor.GetValue(Object component)
at System.Windows.Forms.DataGridColumnStyle.GetColumnValueAtRow(CurrencyManager source, Int32 rowNum)
at System.Windows.Forms.DataGridTextBoxColumn.Edit(CurrencyManager source, Int32 rowNum, Rectangle bounds, Boolean readOnly, String instantText, Boolean cellIsVisible)
at System.Windows.Forms.DataGrid.Edit(String instantText)
at System.Windows.Forms.DataGrid.Edit()
at System.Windows.Forms.DataGrid.OnEnter(EventArgs e)
at System.Windows.Forms.Control.NotifyEnter()
at System.Windows.Forms.ContainerControl.UpdateFocusedControl()
************** Loaded Assemblies **************
mscorlib
Assembly Version: 1.0.5000.0
Win32 Version: 1.1.4322.573
CodeBase: file:///c:/windows/microsoft.net/framework/v1.1.4322/mscorlib.dll
----------------------------------------
Application
Assembly Version: 1.0.2349.36037
Win32 Version: 1.0.2349.36037
CodeBase: file:///D:/Project/HiddenMan/HiddenMan/Application/bin/Application.exe
----------------------------------------
System.Windows.Forms
Assembly Version: 1.0.5000.0
Win32 Version: 1.1.4322.573
CodeBase: file:///c:/windows/assembly/gac/system.windows.forms/1.0.5000.0__b77a5c561934e089/system.windows.forms.dll
----------------------------------------
System
Assembly Version: 1.0.5000.0
Win32 Version: 1.1.4322.573
CodeBase: file:///c:/windows/assembly/gac/system/1.0.5000.0__b77a5c561934e089/system.dll
----------------------------------------
System.Drawing
Assembly Version: 1.0.5000.0
Win32 Version: 1.1.4322.573
CodeBase: file:///c:/windows/assembly/gac/system.drawing/1.0.5000.0__b03f5f7f11d50a3a/system.drawing.dll
----------------------------------------
System.Xml
Assembly Version: 1.0.5000.0
Win32 Version: 1.1.4322.573
CodeBase: file:///c:/windows/assembly/gac/system.xml/1.0.5000.0__b77a5c561934e089/system.xml.dll
----------------------------------------
Microsoft.VisualBasic
Assembly Version: 7.0.5000.0
Win32 Version: 7.10.3052.4
CodeBase: file:///c:/windows/assembly/gac/microsoft.visualbasic/7.0.5000.0__b03f5f7f11d50a3a/microsoft.visualbasic.dll
----------------------------------------
ClassLibrary
Assembly Version: 1.0.2349.36037
Win32 Version: 1.0.2349.36037
CodeBase: file:///D:/Project/HiddenMan/HiddenMan/Application/bin/ClassLibrary.DLL
----------------------------------------
System.Data
Assembly Version: 1.0.5000.0
Win32 Version: 1.1.4322.573
CodeBase: file:///c:/windows/assembly/gac/system.data/1.0.5000.0__b77a5c561934e089/system.data.dll
----------------------------------------
************** JIT Debugging **************
To enable just in time (JIT) debugging, the config file for this
application or machine (machine.config) must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.
For example:
<configuration>
<system.windows.forms jitdebugging="true">
When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the machine
rather than being handled by this dialog.
Lam
|
|
|
|
|
|
It's good if someone asking for help mentions what he/she wants others to help on.
You should read the first line of Exception Text.
|
|
|
|
|
hi everybody
iam working in project in which the textfiles are continously changed ,or some data, is added to it by another application and i have to filter the textfiles and save it to another file and i have to process 56 files at a time and if all are processed continouslty cpu usage comes to 100% so i need to do something so that only the modified data which has addded to the file since last filteration done by my application so how can i do so can anyone guide me to do so thanks original text file format is like 20062511.095525,34444,566,7 and i have to filter it as 11/25/2006,95525,34444,34444,34444,34444,5666,7
pls guide me thanks
sourabh
|
|
|
|
|
Seems like a convoluted way of doing things to me. If you have the opportunity to redesign it so that the data is stored in a database of some sort rather than text files then you'll have a much more robust solution.
The only way you can detect that a file's contents have actually changed is to read it. The way you can tell if a file has been touched (i.e. written, modified or created) is to inspect the file's creation date or modified date in the file system. At the very least you'll then be able to detect and read only the changed files and not all 56.
As an advanced topic you can also be advised of a file's change of status by some system events, but this is I think beyond the scope of this forum. There are articles on The Code Project that discuss this issue if you wish to pursue it.
...Steve
1. quod erat demonstrandum
2. "Give a man a fish and you've fed him for a day. Teach him how to fish and you've fed him for life." I read that somewhere once 
|
|
|
|
|
I'm using the new report object in .net 2.0. I created a report but when the report runs it displays records I do not want to see. I would like to have a form displayed before running the report that allows the user to define what records they want to see on the report. I think I want to use parameters in my query I'm not sure how to set all this up. Any help on this would be much appreciated!
|
|
|
|
|
I have a somewhat complicated problem. I have a project that when it deploys actually has two exe's. One is used as a shell program, it uses an xml file to determine and call the most updated version of the sub program. It then removes any outdated sub programs to clean up the file structure. The issue that I'm running into is that after installing with a windows deployment project and then updating the program (through code already written in the sub program) the shortcuts that were created during the setup/install process no longer work. It throws an error because for some reason it is trying to find the .msi file that it used to install the program. The shortcuts point to the shell program, which doesn't change at all during an update. If I use windows explorer and just click directly on the shell program, it works fine. And creating a NEW shortcut to the exact same shell program works just fine too. So maybe since the file structure around it changed it thinks it's damaged and it's trying to run the setup to fix itself????? I was hoping this would come down to a setting in the setup project that I need to change, but I'm having trouble finding help on it. Does anyone have any ideas how to make this work so my users will not have to delete and then recreate their shortcuts?
|
|
|
|
|
Hey guys,
Anyone know how to extact the font name from a a font file be it Truetype, Open type or Type 1.
|
|
|
|
|
I want to know how you made a activation code in visual basic 2005
just like with autocad and photoshop activation module thats activate the product
I need it only i cann't find it anyware pleas help me
|
|
|
|
|
Hi Guys
I need a favor again to somebody who had experience with printing report procedure, I have a simple program with a crystal report as the report generate,however when I want to printing out the report I have to running a program which connected to crystal report and click the printer icon on that crystal report preview to printing out my report.
Could you please to tell me the way to printing out my report directly without preview it ?, if you can please tell me the command and show me the complete procedure that I have to follow.
If this command not need a crystal report as the report generate please tell me what kind a program should I use for the main report generator.
Many thank for you
Best regards
ICE
|
|
|
|
|
I haven't done it before, but I will in the near future so I've been looking around for similar information. I think to print without using the print preview all you need to do is set the PrinterOption properties of your crystal reports ReportDocument object. Then call the PrintToPrinter method of the ReportDocument object. (This is what I've gotten from Visual Studio 2005) I know this doesn't answer all of your questions, but maybe it can help get you started.
|
|
|
|
|
Hi Mr.Kschuler
Thank you very much for your reply, well I think I can consider to use your way, but if you don't mind please send me your sample program command for this matter.
Thank's
ICE
|
|
|
|
|
This bit of code seemed to work for me. (I use a PrintDialog control to allow the user to select which printer they want. And again, I am assuming you use Visual Studio 2005.)
Select Case PrintDialog1.ShowDialog
Case Windows.Forms.DialogResult.OK
ProductionWorksheet1.PrintOptions.PrinterName = PrintDialog1.PrinterSettings.PrinterName
ProductionWorksheet1.PrintToPrinter(1, False, 1, 1)
End Select
-- modified at 9:05 Thursday 8th June, 2006
ProductionWorksheet1 is the name of my ReportDocument object which is found in the toolbox under the Crystal Reports section.
|
|
|
|
|
Hi
you can use the printOut command of the report.
i.e.
on the click event of the print button....
CrystalReport1.printOut false
the parameter false is used to diable user prompt. the other parameters are self explaining.
(Note: I am using crsytal reports 9 and VB.6)
Bye
|
|
|
|
|
VB.net / sql
myrow = DS.Tables("psrec").Rows(0) '1 record - 24 fields
Dim myIntArray(24) As Integer
For i = 0 To 23
myIntArray(i) = myrow(i)
Next
Array.Sort(myIntArray)
maxunits = myIntArray(24)
wat leaves me stumped is that since the array starts from 0, it should end at 23. However, the maxvalue can be found at myIntArray(24). when i print the array using the code,
For i = 0 To 23
Console.WriteLine(myIntArray(i))
Next
I always get 0 for myIntArray(0) for every record and the actual values are displayed from myIntArray(1). Therefore, one value is missed since the array prints till myIntArray(23). The last value is at myIntArray(24).
Can you explain this to me...
With Best Regards,
Mayur
|
|
|
|
|
Since you have
Dim myIntArray(24) As Integer<br />
For i = 0 To 23<br />
myIntArray(i) = myrow(i)<br />
Next
you never set the last value in the array, value myIntArray(24)
That is the value which is missed?
However, I would think the array should end at myIntArray(23)
how vital enterprise application are for proactive organizations leveraging collective synergy to think outside the box and formulate their key objectives into a win-win game plan with a quality-driven approach that focuses on empowering key players to drive-up their core competencies and increase expectations with an all-around initiative to drive up the bottom-line. But of course, that's all a "high level" overview of things
--thedailywtf 3/21/06
|
|
|
|
|
mayhem_rules wrote: Dim myIntArray(24) As Integer
This is an array of 25 items. To declare an array of 24 items you use:
Dim myIntArray(23) As Integer
The number you supply when declaring an array is not the number of items, but the highest index to be used.
I think that there are quite some VB programmers out there who constantly declares arrays that contain one too many items and never realise it, becase it seldom causes any errors.
---
b { font-weight: normal; }
|
|
|
|
|
Thnk u very much...
With Best Regards,
Mayur
|
|
|
|
|
Hi 2 all
Please tell me the complete procedure to create a report using Crystal Reports in VB.NET.
Thanx in advance for helping me out...
Regards,
Arfan Qadir
|
|
|
|
|
try this: http://msdn2.microsoft.com/en-us/library/ms227594.aspx
Faris Madi
Nothing Comes Easy (N.C.E.)
|
|
|
|
|
It's in C# but the idea is the same.
ReportDocument doc = (ReportDocument)crystalReportViewer.ReportSource;
doc.PrintOptions.PrinterName = "Your Printer Name";
doc.PrintToPrinter(1, false, 0, 0);
|
|
|
|
|
I want to use unicode in my application. I am using Microsoft Forms 2.0 controls. With the help of that I am able to display the unicode in textbox control but typing is shows all "?".
Can anybody help me in that?
Padma Gahlot
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
