|
Try zipping it. Really, that's going to save space a lot more efficiently than anything else you might try.
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
You shoula also use the Access utility to compact the database as well. If an Access database has been used a lot it tends to have a lot of garbage in it that increases the size.
|
|
|
|
|
I need to attach xml file to email object (cdont or whatever). The main problem is i create that file programmatically and do not want to save it on server. So i have to save it from stream. I use vbscript and asp classic. Thx
vvv
|
|
|
|
|
Hi
How can i insert some values into database using stored procedure in vb.Net.
Expecting your earliest reply
Thanks
Krishna
Krishna T Nair
|
|
|
|
|
This is the sort of question that you could answer yourself in seconds if you tried google.
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
Krishna T Nair wrote: Expecting your earliest reply
Haha...
Look on google/msdn for starters and stop posting pointless questions.
|
|
|
|
|
Here is a starter for 10:
SqlCommand.CommandType[^]
Krishna T Nair wrote: Expecting your earliest reply
I wouldn't put statements like that. It implies that this must be the most important thing the reader has to do when it clearly isn't. Also, the fact that you put "expecting" puts a sort of guilt trip on the reader which is unwanted. (or that could just be me having been born into a family with some members on the extreme wing of the Free Kirk.)
My: Blog | Photos
"Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucious
|
|
|
|
|
Hello,
I have what I think is a simple task, but I have yet to find the answer. I'm trying to insert a table field into a query string from a dropdown list. I'm using MySql for a database, and if I use a control parameter, it inserts the selected value from the dropdown into the query with single quotes, like 'xxx'. MySql wants field name to be unquoted, like xxx. My query is like SELECT name, number, city FROM mytable WHERE xxx LIKE 'something';. And I can't figure out how to insert the xxx into the query without the quotes. I was wondering if any of you have ever done something like this where you entered a field name into a query string. I'm sure this is done somehow. I can't imagine not being able to do this. Any suggestion, and I mean ANY suggestion will be welcomed. How would you do it with MSsql or access?
|
|
|
|
|
SELECT name,number,city FROM mytable WHERE xxx like '%" & str & "%'"
Asif
|
|
|
|
|
Yes -as Asif says, without the quotes.
Dim sFieldName as string = cmbField.Text
Dim sSQL as string = "SELECT * FROM MyTable WHERE " & sFieldName & " = 'A Value'"
Note that you need to be wary of SQL Injection attacks etc in this case... Can the user modify the combo text?
|
|
|
|
|
Dear friends;
I am trying to cofigure Oledbdatadabter with wizard. And i am using ACCESS database.I want to use parameter in OledbDataadapter Select Command Property window.
I have simple form which has a one combobox, one datagrid and one update button. I want make select like this Select * from Banks where BankName= combobox.text but if i write Select * from Banks where BankName='CITIBANK' query is working. But i can not take parameters from combobox.
In OledbDataadapter Select Command Property window i see Parameters Property but i can not configure it.
If u can please help me about my trouble.
Thanks a lot
MAGICIANMERLIN
|
|
|
|
|
Hi, does anyone know that vb.net 2005 include the graph control or not?
|
|
|
|
|
I have a graph that needs the X axis labels to be arranged vertically. The labels are links to different pages. If I use System.Drawing's DrawString method, the link "<a href="x.aspx" >x</a>" is shown as it is instead of a link in the image. Is there any way to show the text vertically and with the links retained? Please help.
Sunita
|
|
|
|
|
I don't know really.
But I guess there are two, or may be three, options.
1) Check if the linklabel class has a predefined orientation property (I guess not ... but it's worth a check)
2) Override the linklabel onPaint method (tricky)
3) Use the drawstring, intercept the click event on the "father" object, check if it's inside your text and then launch the link.
|
|
|
|
|
Hi am looking to write a tutorial/training application that will have tranisitions between images...cross fade, pan & zoom etc. ... can't seem to find any examples on how to create these effects between images...just getting started in vb.net and looking for code examples to get up to speed.
thanks for the help!
Rick
|
|
|
|
|
You'd need to draw these yourself, manually. There's no built in support for anything like that.
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
Any pointers on where to look to get started?
Thanks for the response...
|
|
|
|
|
Read my image processing articles for info on accessing an image directly. Then create a control and write transitions that draw the first image, then progressively draw the second image over the top of it.
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
OK - I need to way to know when a class property has changed.
I have a collection of PropertyInfo and add to it thus:-
Public Class Foo
Private _PropertiesChanged As New System.Data.PropertyCollection
Private _SessionId As String
Public Property SessionId() As String
Get
Return _SessionId
End Get
Set(ByVal Value As String)
_SessionId = Value
_PropertiesChanged.Add("SessionId", Me.GetType.GetProperty("SessionId"))
End Set
End Property
End Class
But some of my classes have a great many properties ... how can I make it so that is any property is updated it adds itself to the _ChangedProperties collection without this code overhead???
'--8<------------------------
Ex Datis:
Duncan Jones
Merrion Computing Ltd
|
|
|
|
|
The beauty of properties is that you can write this code at all. There's no way for it to happen automatically, thank goodness. I'd hate to pay for that overhead every time I wrote a property.
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
Well, I was thinking of marking the properties with an attribute so only those whose dirty state I cared about set the dirty state or having the class inherit from some base that implemented the dirty property implementation....
..but you're right - it doesn't seem to be possible. I shall just have to be less lazy. 
'--8<------------------------
Ex Datis:
Duncan Jones
Merrion Computing Ltd
|
|
|
|
|
Have you considered having a single dirty flag for the class instance?
In the property set for the properties you are interested in just set that one flag.
Or do you need to know exactly which properties have changed rather than just "Something has changed on this class"?
|
|
|
|
|
I'd need to know exactly which properties have changed.
This is an extension to the code in this article[^]...currently in SQLTableInterop.SetObjectDataToTable it writes an SQL update statement for all the properties in the class...I want to restrict that to those properties that have changed.
'--8<------------------------
Ex Datis:
Duncan Jones
Merrion Computing Ltd
|
|
|
|
|
Hi,
I am trying to copy a file that is 287 characters long to a new location.
when I try the following to copy the file I get "The path is too long after being fully qualified. Make sure path is less than 260 characters."
Dim lcLongPath = "F:\287 characters long path...........txt"
Dim fi As FileInfo = New FileInfo(lcLongPath)
fi.CopyTo("G:\NewPath")
Does anyone know how to get around this limitation? Obviously some applications are capable of creating excessively long paths and file.
Thanks,
Zenly
|
|
|
|
|
Zenly wrote: Obviously some applications are capable of creating excessively long paths and file.
Are you sure about that? I always thougt(how do you spell the past tense of to think???) that it was a limitation of windows that paths can not be longer that +- 250 chars, and the filename itself also not longer than 250 chars or something. So 500 charcters in total. 
Pompiedompiedom... 
"..Commit yourself to quality from day one..it's better to do nothing at all than to do something badly.."
-- Mark McCormick
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
