|
Hi all,
I am developing a small application in VB.NET 2003 that loads just over a 1000 contacts from MS Access and loads them into a datagrid. (That works pretty good, I can even add/edit/delete contacts ok)
I just want it to add the option of importing contacts in a couple of different ways, first one been from MS Excel.
I have no issues loading the excel file to the application, the following is just the two main lines of code where I load the excel file (obviously there is some extra code, I just don't think is relevant at this stage...)
oledbConnExcel.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & strFilePath & ";Extended Properties=Excel 8.0;"
dt = oledbConnExcel.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, New Object() {Nothing, Nothing, Nothing, "TABLE"})
After I am done loading the spreadsheet to a datagrid in a separate form, I make sure that connections and other objects that are no longer required for excel are removed;
oledbConnExcel.Close()
oledbConnExcel = Nothing
After all this my MS Access connection no longer works (even those connection that where ok prior of loading the Excel file)
The following are some of the references for Access connection;
If IsNothing(oledbConn) Then
oledbConn = New OleDb.OleDbConnection
Else
oledbConn.Dispose()
oledbConn = New OleDb.OleDbConnection
End If
oledbConn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data source= " & DBLConnPath & ";User Id=admin;Password=;"
As you can see, even though I use a different object all together I go and recreate the object and the connection every time.
If I don't use the Excel import function, I can dispose, create, etc... as many times as I want to the MS Access database.
I read a lot of forums, and they recommend checking the MDAC (which I did although I didn't have to as for the above sample)
What gives...?
Thanks in advance.
Alain
|
|
|
|
|
In my project i have a requirement of storing Text and Image in Access Database through VB.NET. And Access it back.
And most important thing is the Data (Text + Images + Tables + etc..) Should be displayed in Crystal Report..
One more thing the data has to be in 1 Column. I cannot divide the data.
Can any one plz help....
-- modified at 10:20 Wednesday 23rd August, 2006
Jats
|
|
|
|
|
Hi
I try to use the great looking GoogleTalkForm Component from here:
http://www.codeproject.com/cs/miscctrl/GoogleTalkWindowsForm.asp
I making a standart Windows Project and set a Reference to the "StyledForms" Dll
It works fine to do an instance of the googletalkwindow and show it, but how can i get the
look of this component at designtime to my standart form?
Sorry im not familiar with using extern components :=(
Thx for help
|
|
|
|
|
You need to ask this question in the forum for the component you downloaded.
If the question is that it's not showing in the designer, the VS2005 designer is a lot pickier than 2003, it won't show components that work fine, a lot of the time.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
|
|
|
|
|
i have populated a data grid with like this
dim QryFrames As String = "SELECT F.ProductId, F.BrandName, F.Collection, F.Temple, F.Bridge, F.Eye, F.FrameName, F.Color, F.Meterial, F.FrameType,F.FrameShape, F.RimType, F.LenseColor, F.Gender,F.QtyInHand,F.ReorderLevel FROM Frames AS F INNER JOIN Stock AS S ON F.ProductId = S.ProductId and F.GrnNo=S.GrnNo"
ds = classes_obj.getRecord(QryFrames)
dgAddReorder.DataSource = ds.Tables(0)
here getRecord function return dataset for passes qry string.
this works on index change event of combo box.
my problem is user change combo box selected item this return (populate data grid) different order.that mean not in same order.
eg. say i want to get ReorderLevel for last column of data grid.so i place it as last item of Qry.but different times it get different location.(but first time ok. i think this because of cashing or something of dataset.)
i want to get this same position every time.
regards.
amila pradeep
|
|
|
|
|
hello friends
i want to use 'where like' statment to access date/time data type.
For ex.
Data type of my column is date/time , and values are like--
11:01:25
11:01:35
.
.
.
11:15:25
and i want to fire aquery which search records starting with "11:01"
plz help me out
thanks in advance
Born To Code
|
|
|
|
|
You put it in a string:
strSQL = "SELECT * FROM Table-Name WHERE Column-Name like '%initial%';"
When you want to use the query, you use the string variable in the code calling the database.
---
b { font-weight: normal; }
|
|
|
|
|
Please don't just delete replace your question with a new one. The thread gets rather confusing.
Also, try to write a subject that is not useless.
Anyway...
Don't use "like" on a date field. Calculate the starting time and ending time of the interval that you want, and use that in the query.
Example:
select this, that from sometable where somefield >= '11:01' and somefield < '11:02'
---
b { font-weight: normal; }
|
|
|
|
|
Hello,
Can anyone plz help me in building an application in VB.Net which works like a Telephone answering machine and also has a feature of caller ID. I have read the TAPI document in the MSDN but i m unable to understand it fully.
|
|
|
|
|
Your question is too broad. At this point, the only way anyone can help you is by writing it for you. Which bits do you understand ? Which bits don't you understand ? Have you written any code yet ?
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
|
|
|
|
|
I need to call a function, that resides in an unmanaged DLL, from VB.NET code that runs on a WINCE 4.2 device (.NET CF 2.0 SP1).
I followed msdn papers on pinvoke and marshalling but it keeps firing MissingMethodException.
I dumpbinned the dll, finding "1A2 machine (SH3)" into the headers (i'm using arm device). I've also found that the function "T4Init" appears as exported.
I tried to use alias "T4Init" and alias "#133" (number of the function) but no way.
I tried to use relative (the dll resides in the executable directory on the device) and absolute path but no way.
I cannot access dll source code, only compiled dll.
Here's the function prototype as in dll documentation:
int T4Init(LPCTSTR Port)
Here's the code:
Public Module DEMO
...
Declare Function T4Init Lib "T4CE.dll" (ByVal ComPort As String) As Integer
...
Public Sub Main()
Dim ErrString As Integer
ErrString = T4Init("COM" & CStr(i) & ":")
End Sub
End Module
Please help!
|
|
|
|
|
The problem was that another application installed T4CE.dll in \Windows folder.
It seems that having two copies of the same dll in system and local folder leads to conflicts:
http://wiki.opennetcf.org/ow.asp?CompactFrameworkFAQ%2FPInvokeMissingMethodException
|
|
|
|
|
Have any of you used the report viewer in any of your own application ? Or is it only for the teacher starter kit ( vb express edition)
ihe
|
|
|
|
|
I have this error when i run my function...
i wonder did i use my method wrongly.. pls help.
Runtime error:
Command text was not set for the command object.
HEre my coding :
Set cn = New adodb.Connection
cn.ConnectionString = "provider=microsoft.jet.oledb.4.0;data source= db1.mdb"
cn.Open constr ' constr is a connection string
sqlsql = "delete from [DO] where no = " & dono.Text
cn.Execute strsql, adExecuteNoRecords
|
|
|
|
|
You put the query in the variable sqlsql, then you try to use the variable strsql.
You should use Option Explicit, so that you can't create variables by mistake like this.
---
b { font-weight: normal; }
|
|
|
|
|
I looked straight through that piece of VB nastiness when I read it before, it's not something that would have occured to me as possible ( for the language to magically create undeclared variables )
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
|
|
|
|
|
VB is very "nice", and automatically declares any variables that you use, unless you use Option Explicit to tell it not to.
Using Option Explicit is one of the things that turns VB from a toy to something that you can use just like if it was a real programming language. 
---
b { font-weight: normal; }
|
|
|
|
|
I have RTF format data(Text and Images) in a Access database tabel( Datatype of the Tabel field is Memo) which i need to display in Crystal Report. When i am doing so i am able to see the Text but not the Images. I had changed the TextFormat Property of the field in Crystal Report to RTF.
What else should i have to do for the reqirement...
Can anyone Help...
Any Links or Articles which might help....
Jats
|
|
|
|
|
How to draw a organisation chart in Crystal Reports of VB.NET 2005. Or is there any free software/Active X available for the creating organisation chart.
Regards
Riyaz Zujer Patanwala
I.T.Programmer
Al Jaber Energy Services
P.O.Box 47467
Abu Dhabi
U.A.E.
|
|
|
|
|
hi
i m having dll file that can be used to send sms from pc but the problem is that i m using pocketpc that is connected to usb port and script i m having using com port. how we solve this problem. Is there any script available that is used to send sms using usb port
if it is please tell me
Thanks,
Nitu
-- modified at 1:11 Wednesday 23rd August, 2006
|
|
|
|
|
I was trying to use a hand icon cursor which i have the image i put it as a picture and call it when mousemove
-- Here my coding:
Private Sub Image1_MouseMove(Button As Integer, Shift As Integer, X As Single, Y As Single)
Image1.MouseIcon = Picture1.MouseIcon
End Sub
I wonder is there easy where to do it? i found in the properties :mouse pointer and mouse icon but i not sure how to use them, dont really have then hand cursor.
I'm using VB6 .
|
|
|
|
|
Cursors.Hand is what you want. What are Image1 and Picture1 ?
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
|
|
|
|
|
the image and picture is the item i want when i move my mouse to there and the cursor will change to a hand. is VB6 the properties have that function?? i dont really seen it...
how do i manually code it ?
|
|
|
|
|
Oh, this is VB6 ? Then I have no idea.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
|
|
|
|
|
I can't really understand what your talking about. But, it seems liek you want to change the mouse cursor when it is over your images?? I think you're looking for the MousePointer property, not MouseIcon.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
