|
Hi Guys... I need help... i am using Ms Access database, now my clients has changed and sending Ms Excel sheets .so now i want convert Ms Excel( multiful sheets), CSV files into Ms Access. can anybody help me..... and send me code if you have anybody... it'll be grateful for your help..
Sri..
|
|
|
|
|
|
Has anyone tried creating a program that implements Secure File Transfer Protocol? I have seen code for stand-alone FTP programs and several 3rd party components that allow for sFTP, but I haven't seen complete code for sFTP.
From what I have read sFTP is FTP running over a Secure SHell (SSH). I don't mind doing a bit of investigation into this, but I haven't done Network programming previously. If anyone could point me in the right direction it would be much appreciated.
I'd like to code this without using third party components so that I have complete control and accountability for the end result.
Thanks in Advance,
Paul Taylor.
|
|
|
|
|
|
Thanks for the link.
I have been particularly busy with other projects, so I haven't had a detailed look into the code. I'll have to brush up on my C# skills to figure out what's going on.
Thanks,
Paul T.
|
|
|
|
|
I have created a recordset from a data table, I have then populated a listbox with the data from the recordset using the lst.items.add() property.
What I want to do now is when a user clicks on the item in the listbox, I want to be able to retrieve the specific record from the recordset, so I can access data from other fields in that record. Is it possible to do this?
Bryn
|
|
|
|
|
I'm working with a search function with navigation bar. the simple function with searching data which able to go previous or next data. I first select the data and fill into a dataset, then use bindingmangerbase to move the position. it works fine. The result can be filtered and displayed correctly. however, as it can only display the result. I cannot go to the previous or next record of the result.
For example, If I want to go to the productID #100, it just show me the record that I select. I want to search ProductID #100 and also able to view the previous or next record of it. that is, not select this record only, but allocate the point here and able to move to next record.
anyone can help? thanks.
|
|
|
|
|
How can I bind one ComboBox to another having a 2 table dataset with a relation created? I would like to view in second Combo only these records which have equal key to the record selected in the first one.
|
|
|
|
|
hiii
i don't know what the word delegate mean but i see it in every material belong to vb.net and i don't know what it mean and where and when and why to use it
i need here in explanation what it mean thanks
ma_refay
|
|
|
|
|
Google[^]
Take a look at the first result 
You know you're a Land Rover owner when the best route from point A to point B is through the mud.
Ed
|
|
|
|
|
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
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
