Question about Cisco Computers & Internet
DataSet ds = new DataSet();
selectCommand = new OleDbCommand();
connectionString = ''Provider=Microsoft.JET.OLEDB.4.0;'';
string Str_ColNames = objImportDB.get_importcol_sequence(Int_FeedId, '''');
Str_SelectText = ''SELECT '' + Str_ColNames + '' FROM [Sheet1$]'';
connectionString = connectionString + ''Data Source='' + fld_path + '';'';
ExtendedProperties = @''Extended Properties=''''Excel 8.0;IMEX=1;HDR=YES;'''''';
connectionString = connectionString + ExtendedProperties;
selectCommand.Connection = new OleDbConnection(connectionString);
selectCommand.CommandType = CommandType.Text;
selectCommand.CommandText = Str_SelectText;
selectCommand.Connection.Open(); // fails here reporting UnSpecified Error
But this code works fine if we do not use WebService
Save hours of searching online or wasting money on unnecessary repairs by talking to a 6YA Expert who can help you resolve this issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
Here's a link to this great service
Posted on Jan 02, 2017
I see 2 problems with your code.
1) Each time you call cmdnext_Click, you're reopening the database. Each time you do that, you start at the beginning of the file. You need to have the database opened once, somewhere else in your program. Be sure that the record set is visible from this sub.
2) In order to use the "Next" function, you need a loop like this
'test for no records
IF REC.BOF and REC.EOF then
msgbox "No Records Found"
IF NOT REC.EOF then
(display your fields)
Again, this will only work if your database is opened outside of the cmdNext_Click routine.
Posted on Jul 16, 2008
SOURCE: Use vb.net and access
Public Class SaveImage
Shared Sub main()
Dim o As System.IO.FileStream
Dim r As StreamReader
Dim gifFile As String
Console.Write("Enter a Valid .Gif file path")
gifFile = Console.ReadLine
If Dir(gifFile) = "" Then
Console.Write("Invalid File Path")
o = New FileStream(gifFile, FileMode.Open, FileAccess.Read, FileShare.Read)
r = New StreamReader(o)
Dim FileByteArray(o.Length - 1) As Byte
o.Read(FileByteArray, 0, o.Length)
Dim Con As New _ System.Data.OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.3.51;Persist Security Info=False;Data
Dim Sql As String = "INSERT INTO images (Pic,FileSize) VALUES (?,?)"
Dim Cmd As New System.Data.OleDb.OleDbCommand(Sql, Con)
Cmd.Parameters.Add("@Pic", System.Data.OleDb.OleDbType.Binary, o.Length).Value = FileByteArray
Cmd.Parameters.Add("@FileSize", System.Data.OleDb.OleDbType.VarChar, 100).Value = o.Length
Catch ex As Exception
Posted on Jul 17, 2008
SOURCE: I had to restore my
I can't help you get this current problem solved.
However I can help you prevent it in the future.
Get a whopping BIG outside hard-drive for your backups.
Then you have ALL your back-up files on one continuous disk, instead of several.
You need a program that automatically backs-up only the files you have pre-selected, as an actual file and not an "Image".
Back-up such as Desktop, My Documents, Email, Favorites etc.
With "image" files you can not retrieve or copy and paste individual files from the archives, such as when you have accidentally deleted a good file on the computer.
Posted on Dec 16, 2008
Tips for a great answer:
Oct 03, 2011 | Nokia 1110i Cellular Phone
May 20, 2010 | StompSoft BackUp My PC 2005 (05004) for PC
Jan 25, 2010 | The PHP Group PHP
Dec 21, 2009 | Datel Action Replay for Nintendo DS
Sep 04, 2009 | Microsoft Computers & Internet
Sep 03, 2009 | Microsoft Visual Basic 6.0 for PC
Nov 10, 2008 | Microsoft Office Standard for PC
Jul 08, 2008 | Microsoft Computers & Internet
42 people viewed this question
Usually answered in minutes!