|
kenvil wrote:
The content made in notepad is the same as the document transferred to MS WORD, meaning both of them has exact contents, logically they were duplicates but this case was ignored by the system because they have different formats (Not Supported).
Maybe by your "logic", but there is absolutely no reason to assume that the user considers the file a duplicate.
Case in point: I have a resume, that I create with Word 2003. However I recognize that many potential employers may have an older version of Word. So I save the document in a Word 98 format on the assumption that any one can read that format. I have a third version which is saved as a simple text file because that is the format often encountered when submitting a resume through a website.
All three documents have the same "content", but they are by no means duplicates.
|
|
|
|
|
Im trying to import a CSV file into an access db using dao
The following code works well in the connection
Set tmpDB = DAO.OpenDatabase(ActiveWorkbook.Path, False, True, "Text;Database=C:/TEMP;Table=test.csv;HDR=Yes;FMT=Delimited;")
However part of the data is lost in the proccess.
I think that if I force all fields to behave as strings(varChar) I can solve this problem.
Does anyone know how to do this?
|
|
|
|
|
You might want to try adding the IMEX option to the connection string:
Text;Database=C:\TEMP;Table=test.csv;HDR=Yes;FMT=Delimiteed;IMEX=1;
You can see this[^] KB article on MSDN for more information.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
|
In that case, I have no idea what it is.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
in vb.net when we create connection string
we want dsn name in the connection string i want connection via sqlserver
please suggest me what connection string i write
notify i don't want server name and database name in the connection string.
please help me
|
|
|
|
|
I just looked at this last week. Ummmm....I think you have to use the OLEDB classes and the connection string would be something like
"Provider=MSDASQL;DSN=dsnname"
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
My Design View and Code View don't coexist together anymore.
I can create a simple, new app -- text box and command button, for example. (all other projects closed)
Double-click on the button -- the code window opens and the Design tab is at the top -- as it should.
If I close both windows and click on the app in the solution explorer, the design view opens -- as it should.
????? If I right-click and select "View Code", the code window opens, but the design view goes away, no tab, nothing. If I then double-click the app in the solution explorer, design view comes back, but the code tab disappears ?????
I use VS .NET 2003 at two different locations. It worked fine on both computers until this VS went bonkers.
I have run setup again, choosing 'repair', but the problem persists.
|
|
|
|
|
In Tools->Options->Environment->Documents, "Re-use current document window, if saved" should be unchecked.
Charlie
if(!curlies){ return; }
|
|
|
|
|
thank you -- that was the problem
|
|
|
|
|
hi
I have an database tabel that i wana to bind it to a comboBox ...
I wana load all the data in the combobox from a spicefesic field
how can i do this ?
thx
|
|
|
|
|
There are three simple ways you can do this (in VB6 anyhow).
1. Use the Data Source property of the combo box and link it to your database.
2. Use an adodc control to create a recordset of your table data and input it into the combo box.
3. Use a data environment which is connected to the database and create a temporary record set.
Do you know how to do these or would you like an example of some code using one/ all or them?
°[Halo]°
Project Basilisk
|
|
|
|
|
YES
IF U CAN GIVE ME AN EXAMPLE PLEAZE
U CAN SEND TO MY E-MAIL
YOSEF_SA@HOTMAIL.COM
THANK YOU
|
|
|
|
|
Hi,
i have a problem with executing select query which was added to dataadpter.
i have 2 select command.
' first select command
dbAdapterUsers.SelectCommand = New OleDbCommand _
("SELECT UserName FROM Users where UserName=? AND PassWord=?", dbConnGym)
dbAdapterUsers.SelectCommand.Parameters.Add("UserName", OleDbType.VarChar, 15, "UserName")
dbAdapterUsers.SelectCommand.Parameters.Add("PassWord", OleDbType.VarChar, 15, "PassWord")
' second select command
dbAdapterUsers.SelectCommand = New OleDbCommand _
("SELECT * FROM Users ", dbConnGym)
'filling the datatable
dbAdapterUsers.Fill(dsGYMObj.Users)
2 question:
1) if i change the order between the queries , i get error " parameter ?_1 has no default value." -- why its ok if i the order is as above
2)i execute login function - and i have a feeling that it execute the first query and not the one with the parameters.
login Public Shared Function Login(ByVal username As String, ByVal pass As String) As Boolean
dsGYMObj.Users.Clear()
dbAdapterUsers.SelectCommand.Parameters.Add("@UserName", OleDbType.VarChar, 15, "UserName").Value = username
dbAdapterUsers.SelectCommand.Parameters.Add("@PassWord", OleDbType.VarChar, 15, "PassWord").Value = pass
dbAdapterUsers.Fill(dsGYMObj.Users)
If Not dsGYMObj.Users Is Nothing Then
If dsGYMObj.Users.Rows.Count > 0 Then
Return True
Else
Return False
End If
End If
End Function
thanks
nir.
|
|
|
|
|
Hello There
I am using ListView Control (detail view) having 6 Columns Maximum ( depending on user can de-select the column from view options) So what I need is that the last column should have the width which is equal to the remaining width of the list control. So that the color assigned to that row should be displyed on the whole row.
I have seen this type of code in Codeproject. But Unfortunately I am unable to search that now . If any one has URL for this or has any other solution would be highly appreciated
|
|
|
|
|
You need to set the Width property of the last ColumnHeader to -2.
-Atul, Sky Software http://www.ssware.com
Shell MegaPack For ActiveX & .Net - Windows Explorer Like Shell UI Controls
|
|
|
|
|
Does anyone know how to get the windows explorer file context menu with all its entries (winzip for zip files, open with etc).
I have seen it implemented in file browsers but I have no idea how it is done. There is a C++ implementation of it here at the code project but I dont understand it , has anyone done this in VB.Net or have any ideas how I would go about doing it myself ?
Any advice would be appreciated.
|
|
|
|
|
You need to work with IContextMenu and IContextMenu2 shell API interfaces. Using the shell interfaces in VB.Net can be complicated, but you can see if the declarations for the interfaces are available on www.pinvoke.net
-Atul, Sky Software http://www.ssware.com
Shell MegaPack For ActiveX & .Net - Windows Explorer Like Shell UI Controls
|
|
|
|
|
Thankyou for the link and info. It seems I have a lot to learn.
After looking into it a bit I think I may just end up creating standard context menus and implementing my own features.(The extra work will allow me greater control and make the app more usefull in the long run)
BTW the site in your sig came up while I was searching this topic,It was the last site I was on before posting here, kinda wierd you were the first reply.
Thanks
|
|
|
|
|
Hi all,
I have an object of excel,application class in my application. but when i quit my application, the object remain in my memory inspite of the fact that i am using excel=nothing.
i dont understand y is it heapening.
an suggestions please
its urgent
|
|
|
|
|
I don't usually do Office automation, so I don't know if this is going to work or not. But, did you try to find/call a Quit or Exit method on your Excel Application object?
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
yes i did, but its not working
any other clue
|
|
|
|
|
Hi all,
I am using datagrid for my application and i have requirement to check all chack boxes in the grid. It doing well, but for this purpose my page is to be postbaked as my code is written in code behind and i canot understand how can i implement the code performing the same functionality in javascript. here's my code.
Protected Sub CheckAll(ByVal sender As Object, ByVal e As EventArgs)
If CType(sender, CheckBox).Checked Then
For Each i As DataGridItem In dg1.Items
CType(i.FindControl("chkTemplateWO"), CheckBox).Checked = True
Next
Else
For Each i As DataGridItem In dg1.Items
CType(i.FindControl("chkTemplateWO"), CheckBox).Checked = False
Next
End If
End Sub
and then from html i m calling
<asp:checkbox id="chkTemplateHeader" runat="server" oncheckedchanged="CheckAll" autopostback="True"
runat="server">
any advice on how can i do the same thing without going to server.
|
|
|
|
|
I am doing my vb.net programmer training in podicherry.
plz give me coding for treeview
I am Mani I work in pondicherry
|
|
|
|
|