Visual Basic

MS Access db Run SQL Query to get result in textbox

10-Jul-07 17:11

Private Sub Button1_Click(ByVal sender As System.Object, _
ByVal e As System.EventArgs) _
Handles Button1.Click
ListView1.BeginUpdate
For i As Integer = 0 To ListView1.Items.Count - 1
ListView1.Items(i).Checked = True
Next
ListView1.EndUpdate
End Sub

-- modified at 23:19 Tuesday 10th July, 2007

VB.NET for web

Bosko197810-Jul-07 15:54

Bosko1978

10-Jul-07 15:54

Okay... I'm sure there's a name for it, and that it can be done, but I don't know how. I have a windowsform app made in VB.NET 2005. It's essentially a custom Windows Media Player. I would like to be able to make it so I can embed my app into a web page like youtube does with theirs. I don't want to use existing media player (yes I know you can do that) but my own. Can anyone help?

Thanks

Re: VB.NET for web

Paul Conrad29-Jul-07 6:10

Paul Conrad

29-Jul-07 6:10

If you have your custom form as a class library, then you should be able to. Have you got this problem working?

"Any sort of work in VB6 is bound to provide several WTF moments." - Christian Graus

Re: VB.NET for web

Bosko197829-Jul-07 11:51

Bosko1978

29-Jul-07 11:51

Not yet... I'm not sure where to start. I guess making it a class library is a start... that's easy enough, then what?

svh198510-Jul-07 11:32

Re: MS Access db Run SQL Query to get result in textbox

10-Jul-07 11:32

I have a project with an ms access data source.

but how do i run an sql query an put the result in a textbox?

Im currentlty using:

Code Snippet

TextBox1.Text = AppdataDataSet.Tables("tblSettings").Rows(0).Item(1)

but i cant search my db in that way like i can with an sql query

thx!

George B Gilbert10-Jul-07 11:52

Saving Data from datagrid in vb.net 2005

10-Jul-07 11:52

Take a look at this article.

VB.NET Class Library: Access Table Interface

The Access Table Interface class gives you the ability to query your database with either a default or any SQL statement. The results of the SQL queries are exposed in a datatable property.

bluesperrow10-Jul-07 7:55

bluesperrow

10-Jul-07 7:55

How can i save data from datagrid(after papulating ) without using for loop in vb.net 2005

Re: Saving Data from datagrid in vb.net 2005

Dave Kreskowiak10-Jul-07 9:01

Dave Kreskowiak

10-Jul-07 9:01

You can't. The DataGrid just displays the data and lets you edit it. The data should be stored in a DataSet or DataTable, both of which expose methods for you to save the data to an XML file.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007

Re: Saving Data from datagrid in vb.net 2005

George B Gilbert10-Jul-07 12:30

ListView add and group items

10-Jul-07 12:30

It depends on how you are populating the datagrid. If populating is done by adding items directly to the datagrid, the only way to save changes made in the datagrid is by looping through all of those items.

If, on the other hand, you are using a datatable as the data source for the datagrid, it is possible to save changes enmass without using a loop. For example, the Access Table Interface class extracts data from an Access database and exposes the extracted data in a datatable property. If that datatable property is set as the data source for the datagrid, all edits done in the datagrid will also be posted to the data source. The edited data can be posted back to the database with one call to the Access Table Interface's UseCommandBuilder method.

svh198510-Jul-07 5:52

10-Jul-07 5:52

How do i add items and group them in a ListView?

Im using this to add a new item:
ListView1.Items.Add("ITEM1", 0)

And this for making a Group:
ListView1.Groups.Add(0, "Group1")

But how do I make "ITEM1" part of the group "Group1"

THX

George B Gilbert10-Jul-07 6:14

10-Jul-07 6:14

Looks like this article may have what you are looking for:

ListView Grouping XP Style

svh198510-Jul-07 6:18

10-Jul-07 6:18

thanks for your reply i downloaded the project it is in c# so im not sure if i understand it all, but i give it a try

George B Gilbert10-Jul-07 6:38

10-Jul-07 6:38

Why not use the XPListView user control "as is" in your project? Just add the user control to your project and use it instead of the standard listview control. The XPListView control has two properties that makes grouping automatic ... AutoGroupMode and AutoGroupColumn.

svh198510-Jul-07 6:52

10-Jul-07 6:52

again thx for your reply.

my project is build in vb.net 2005 and if i build the xplistview in vs.net 2005 i get lots of errors witch i don't know how to solve becouse i have no knowledge of c#

is it impossible to group items in the listview at runtime?

TwoFaced10-Jul-07 10:44

TwoFaced

10-Jul-07 10:44

Yup, here is a simple example.

Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
    ' Add a column to the listview
    ListView1.Columns.Add("Name")

    ' Create two groups
    ListView1.Groups.Add("Group1", "Group1")
    ListView1.Groups.Add("Group2", "Group2")

    ' Add two items and assign them to the desired group
    ListView1.Items.Add("Test Group1").Group = ListView1.Groups("Group1")
    ListView1.Items.Add("Test Group2").Group = ListView1.Groups("Group2")

    ' Add another item differently and give it a group
    ListView1.Items.Add(New ListViewItem("Test Group1 again", ListView1.Groups("Group1")))

    ListView1.View = View.Details

    ' Basically you need to know that the groups collection is where you
    ' add groups to the listview

    ' I've showed two different ways you can add an item and assign it to a group
    ' This should give you an idea how to work with groups
End Sub

svh198510-Jul-07 11:12

10-Jul-07 11:12

thanks it works perfect!

svh198512-Jul-07 10:45

12-Jul-07 10:45

Do you also know how to sort the items by the group name?

now when i add a group it will show the groups in the order ive added them
thanks!

George B Gilbert10-Jul-07 11:44

10-Jul-07 11:44

That's interesting. I downloaded and then opened the XPListView solution in VS 2005 and the project was successfully converted from 2003 to 2005. Then I built the user control using VS 2005. There were no errors either in the conversion or the build. I added the re-built XPListView DLL to the VS 2005 Toolbox and then pasted the XPListView control onto a form in a test project. It works great and I now have the extended listview available for all of my projects.

svh198510-Jul-07 11:48

10-Jul-07 11:48

can you email me your (converted) project? and the dll?

i dont understand why i got so many errors, i cant even open the form designer becouse of all the errors.

ive removed the AT for spam reasons.
svanheest gmail.com

thanks!!

George B Gilbert10-Jul-07 12:14

Access a query on my computer

10-Jul-07 12:14

Just letting you know that I emailed the converted XPListView DLL via an off-board email. If you don't receive it, let me know and I'll set up a download location.

Cory Kimble10-Jul-07 4:28

Cory Kimble

10-Jul-07 4:28

Is there a way to run a query that is already saved on my computer and access the results without using datasets? I want to run the query, and display them in a listbox, if possible.

Re: Access a query on my computer

Christian Graus10-Jul-07 5:04

Christian Graus

10-Jul-07 5:04

Sure, you can use a data reader to read them one line at a time, but getting a dataset and making it the data source of your listbox is easier, I would think.

Christian Graus - Microsoft MVP - C++

"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

Getting text from MS Word

reegan4110-Jul-07 4:23

reegan41

10-Jul-07 4:23

Is it possible to get the text from a Word document (using the Word object library in VB6) and store that text into a string variable? If so, how do you do it?

Re: Getting text from MS Word

George B Gilbert10-Jul-07 12:43