|
jds1207 wrote: ("Provider=MySQLProv;Data Source=testship;User Id=jsimmonsassword=dway1207;")
Thanks for the username and password! (You might want to remove those from future posts.)
jds1207 wrote: Dim conn As New OleDb.OleDbCommand("", myConnString)
conn.Connection.Open()
Dim read As OleDb.OleDbDataReader = conn.ExecuteReader(CommandBehavior.CloseConnection)
You created an OleDbCommand object, but didn't give it an SQL statement to execute before you called ExecuteReader on it. The reader object won't work without it.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
Anyone know of a control similar to a picture box but with clipping and stretching capability? I need a quick fix.
Thanks.
B.J.
|
|
|
|
|
The PictureBox does do this, a little, but really, you need to draw your own bitmaps if you want full control, in your Paint handler.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
|
|
|
|
|
I searched and looked around but haven't been able to find an adaquate answer and I feel stu-pid for having to ask.
I am trying to use the ntgraph control on an access form.
I have it registered and it works fine in Excel.
I cannot seem to access it properly in Access though. Whenever I reference it as follows:
with me.ntgraph0
.plotxy (1,1,1) <--- this is not an available method
end with
I apologize for the newbie question. It is a control that I can definitely use, I'm just missing something.
Thanks
|
|
|
|
|
hey guys
i have a project that uses an ms access database as a data source.
and it uses a connection string which specifies the path of the database.
now i would like to use that feature where is copies the database to the output directory
and uses the new copy as a data source (this is available as a built in option when
i create a new data source)
but i'd like to apply this feature on my current data source.
unfortunately everything i've tried causes either my data source not to work,
or renames certain things (like adds a _1 to the name and doesn't reflect on my existing queries)
or clears off all the queries on the dataset.
does anyone know of a quick and painless method ? hopefully something i overlooked?
thanks in advance
Ericos Georgiades
|
|
|
|
|
dear sir
Actually I have some problem with some TAPI function!! It is (LineGetCountry()) tapi function.
I declared LineGetCountry() function & its struct LINECOUNTRYLIST struct & LINECOUNTRYENTRY struct within a module ………….ok
The problem of mine is how to deal with LINECOUNTRYLIST & LINECOUNTRYENTRY structs within my Visual Basic code in the form to retrieve following:
A specific country code & country name.
Note: LineGetCountry() function is returning 0 so it’s successfully invoked
But *.dwCountryCode still retuning zero
I will be very graceful if you could help me by providing me with some example explain how to get country name &country telephone code, by any chance. (visual basic if possible).
thanks
|
|
|
|
|
Let's see your code for defining the structures, the declare for the function, and how your calling ListGetCountry(). The most common problem is that something was declared with the wrong data type, especially if your trying to convert old VB6 code to VB.NET.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
I need a source code that view installed applications and run them.
Thanks.
|
|
|
|
|
Sorry, noone here jsut hands over source code for an entire project. If there is a specific area your having a problem with then great, we can help. But if your looking for someone to write everything for you, try RentACoder.com.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
I have the following code that fills a DataGrid
<small>
Dim strSQLCustomerTotals As String = "SELECT OrderID, OrderTotal, Ordered_On FROM OrderTotals WHERE CustomerID=" & intCustomerId
Dim strSQLCustomerOrders As String = "SELECT * FROM Orders WHERE CustomerID=" & intCustomerId
Dim dsCustomerTotals As New DataSet
Dim daCustomerTotals As New OleDbDataAdapter(strSQLCustomerTotals, dbConn)
Dim daCustomerOrders As New OleDbDataAdapter(strSQLCustomerOrders, dbConn)
daCustomerTotals.Fill(dsCustomerTotals, "OrderTotals")
daCustomerOrders.Fill(dsCustomerTotals, "Orders")
Dim dataRelations As New DataRelation("Orders", _
dsCustomerTotals.Tables("OrderTotals").Columns("OrderID"), _
dsCustomerTotals.Tables("Orders").Columns("OrderID"))
dsCustomerTotals.Relations.Add(dataRelations)
dgCustomerTotals.DataSource = dsCustomerTotals.Tables("OrderTotals")
</small>
The column Ordered_On in the (ms access) database is a timestamp and has the format dd/MM/yyyy HH:mm:ss.
When the DataGrid is filled it only shows dd/MM/yyyy.
How do I show the full timestamp in dd/MM/yyyy HH:mm:ss format in the DataGrid?
|
|
|
|
|
The date/time in any database doesn't have a format. It's stored as a serial number value. Only when the data is displayed in a table view in Access does it get formatted. You have to do the same thing in your code. If you've created your own columns, it's pretty easy, click[^].
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
Hi all,
which toll/add-in (like VBDOX or doxygen) do you use to comment your source code and generate the documentation for your VB2005 projects?
Thanks in advance,
Marc Soleda
... she said you are the perfect stranger she said baby let's keep it like this... Dire Straits
|
|
|
|
|
You might want to take a look at the VSdocman 3.0 addin for Visual Studio. It parses your source code and generates MSDN style documentation, that is completely customisable....
There web address is: www.helixsoft.com[^]
Regards,
Martin
|
|
|
|
|
Finally I'm using this Sandcastle GUI[^] that reaches what I was looking for.
Thanks,
Marc Soleda
... she said you are the perfect stranger she said baby let's keep it like this... Dire Straits
|
|
|
|
|
Hello,
How can i compare the pixels in an image to the pixels of an other image? (sample code pls??)
Thanks, Zaegra
--Zaegra--
|
|
|
|
|
Try openning the two files in binary mode (I think) to read them byte by byte and compare. A coworker made image format converters using this method.
What is it that you want to do if the data is/not equal?
|
|
|
|
|
Well, i want if the image is not equal then i want to add it to an imagelist. As soon as it is equal, i want to write a registery setting that sais "True".
--Zaegra--
|
|
|
|
|
Try looking up "filestream walkthrough" in your help menu. (I use VB.Net 2003) It gives an example on how to read files.... Or GOOGLE it. "filestream" is the method you'll need to work with I think.
Hope it helps.... Happy Hunting.....
Now back to my project.....
|
|
|
|
|
how to create custom controls using xaml?
|
|
|
|
|
Well, I haven't done anything in Windows Presentation Foundation yet, but this[^] is where I'd start looking.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
I have an array called marr() its initialized with no parms
and inside a for loop on vb6 i have t his syntax
count = count + 1
ReDim Preserve marr(0 to count)
marr(count) = var20
my problem is that i dont know how to write a .net 2003 version
of that marr(0 to count) i have tried lookin online but havent
found an answer... i appreciate any help... thanx in advance...
Some times I bite way more than I can chew ... thats why i always buy cheese nips to keep me munching from dusk until dawn
|
|
|
|
|
Instead of Redim Preserve you could use Array.Resize(marr, count)
Regards,
Martin
|
|
|
|
|
ReDim Preserve still exists, but you've used the old VB6 syntax. All arrays in the .NET Framework start with index 0, or 0-based, so it's unnecessary to specify it in the new dimension parameter. Just use:
ReDim Preserve marr(count)
ReDim docs on MSDN[^]
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
Please don't cross post. Choose the forum for the language you're using, and ask there.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
|
|
|
|
|
If i have the following properties enabled....
Form autosize = True
Form maxsize = True
Form minsize = True
Does this mean that my Form will goto the maxsize of the users screensize and not beyond.?
|
|
|
|