|
Hi All,
I have developed a windows application,have a listview in one form...
Given below is the code to bind the listview :-
Dim sqlCmd As SqlCommand = New SqlCommand("Select Query")
Dim myData As SqlDataReader
Dim lvhHelper As ListViewData = New ListViewData()
Try
If _con.State = ConnectionState.Open Then
_con.Close()
End If
_con.Open()
sqlCmd.Connection = _con
myData = sqlCmd.ExecuteReader
lvhHelper.FillListView(LstItems, myData)
_con.Close()
And below is the FillListView Class file
Dim lvwColumn As ColumnHeader
Dim itmListItem As ListViewItem
Dim strTest As String
Dim shtCntr As Short
MyListView.Clear()
For shtCntr = 0 To myData.FieldCount() - 1
lvwColumn = New ColumnHeader()
lvwColumn.Text = myData.GetName(shtCntr)
lvwColumn.Width = "100"
MyListView.Columns.Add(lvwColumn)
Next
'lvwColumn = Nothing
Do While myData.Read
itmListItem = New ListViewItem()
strTest = IIf(myData.IsDBNull(0), "", myData.GetValue(0).ToString)
itmListItem.Text = strTest
For shtCntr = 1 To myData.FieldCount() - 1
If myData.IsDBNull(shtCntr) Then
itmListItem.SubItems.Add("")
Else
itmListItem.SubItems.Add(myData.GetValue(shtCntr).ToString)
End If
Next shtCntr
MyListView.Items.Add(itmListItem)
Loop
by using this codes listview is getting binded very slowly and will be blank hile loading...
is there anything wrong i did in this code?..
any otherway to bind the listview using datareader?..
Thanks in Advance..
|
|
|
|
|
Hi mates,
How would you make a datagridview in multiline column with checkbox and its name. In access its very easy you just put the checkbox with in details but in vb.net. How will i do that? To make it clear. click here[^]>
Another thing, in access when i enter a data in details it will automatically save to my worktable every column. Can i do that in vb.net?
As i know, in vb.net. you will loop the entire grid then save to worktable.
Thanks
C# コードMicrosoft End User
2000-2008
「「「「「「「「「「「「「「「「「「「「「「「「「「「「
The best things in life are free
」」」」」」」」」」」」」」」」」」」」」」」」」」」」
|
|
|
|
|
このフォーラムはしゃぶられます。
C# コードMicrosoft End User
2000-2008
「「「「「「「「「「「「「「「「「「「「「「「「「「「「
The best things in life are free
」」」」」」」」」」」」」」」」」」」」」」」」」」」」
|
|
|
|
|
From Google translate:
This forum will suck.
Wow. You didn't even wait 24 hours and you're already bitching that noone helps you. Did you stop to think that the people who saw your post didn't know the answer, so they post a reply? Order that regulars around here weren't available to even see your question?
We answer questions when our time allows, not when you demand an answer.
|
|
|
|
|
sorry for being stupid sometimes. apologize.
C# コードMicrosoft End User
2000-2008
「「「「「「「「「「「「「「「「「「「「「「「「「「「「
The best things in life are free
」」」」」」」」」」」」」」」」」」」」」」」」」」」」
|
|
|
|
|
Hey guys, I've been having a hard time trying to figure out why I keep getting this error.
Here is the code:
Private Sub SendEmail(ByVal sender As Object, ByVal e As EventArgs) Handles Button2.Click
Email.To.Add(Settings.txtTo.Text)
Email.From = New MailAddress(Settings.txtFrom.Text)
Email.Body = "Email Body"
Email.Subject = "Email Subject"
SMTPServer.Host = Settings.txtSMTPServer.Text
SMTPServer.Credentials = Authentication
SMTPServer.Send(Email)
End Sub
The error I get is: The parameter 'addresses' cannot be an empty string. Parameter name: addresses
And it's pointing to the Email.To.Add() section.
I thought the code would be pretty simple since I have text boxes in another form and I have linked to them before.
Thanks in advance for the help,
|
|
|
|
|
Sounds like the "txtTo" box is empty. Set a breakpoint on that line and see what Settings.txtTo.Text is set to.
|
|
|
|
|
I thought the same thing but the txtTo box is not empty.
How can I set a break point? I'm new to this whole scene so a little guidance would be greatly appreciated.
|
|
|
|
|
Put your cursor on that line, right-click, Breakpoint, Insert Breakpoint... You probably have a hotkey set to it... I believe F9 is the default. Then, when you run, it'll stop there so you can see what's going on.
|
|
|
|
|
When I run the program with the break point in it just highlights that line of code in yellow.
It doesn't show me what the value of that field is though.
|
|
|
|
|
when the row is yellow
Select whatever you want to see the value of then right click on your selection, click on quick watch and it will show you the value.
F9 = set breakpoint
F10 = step over 1 line
F11 = step into the line (for example when your calling a method on that line you will go to the first line of that method)
F5 = resume normal run
|
|
|
|
|
Ok, so I set the breakpoint for the txtTo line and when I right click it and hit QuickWatch it shows this.
txtTo-Name txtTo is not declared.
But in the Settings form where txtTo is at, I don't see any errors.
Thanks,
|
|
|
|
|
Is txtTo declared as Public or Private?
|
|
|
|
|
In the Properties section of the txtTo text box the Modifiers is set to Public.
I'm sorry if this isn't the answer you're looking for. I'm still learning, slowly.
|
|
|
|
|
Ok, let's see... When you break on that line, does Settings have a value? When you mouseover it when stopped there, does it show that it's set to a form?
|
|
|
|
|
When I break at that point and mouse over it, nothing happens.
When I mouse over "Email.From" it outlines it and says, "Email.From Nothing".
So does this just mean that it's not pointing to the settings (or now since I changed it to Prefs) form to find those particular text boxes?
|
|
|
|
|
Email.From will show up as Nothing, because you're stopping before you try to set it. Settings, however, should already be set.
Is "Settings" the name of a form class, or the name of a variable? If you've come from VB6, then you're probably used to them being the same thing... But that's one of the most important things you have to UNLEARN when moving to a real language...
If "Settings" is the name of your form class (Like at the top of the file, it says Public Class Settings Inherits Form ), then that's your problem right there. If this code is inside the Settings form, you can just use Me instead of Settings . If it's in another form, you have to do a little more work.
|
|
|
|
|
This is in Visual Basic 2008.
I'm trying to pull the text data from a form called Settings thats in this program but is it's own form.
It's called "Public Class Settings"
It only has text boxes to remember specific application settings. Like background image, email information, etc.
I have a list form called List. It's called "Public Class List".
This has checkboxes that the user can select and generate a list. When the user selects SendEmail button, it is hopefully going to email the list to them. Using the email credentials setup in the Settings form.
|
|
|
|
|
Ok, there's your problem... You can't access Settings , because Settings is the name of the class, not the name of the actual instance of that class.
What code are you using to display the Settings form?
|
|
|
|
|
I just made the settings form in Visual Basic 2008.
Just made 3 textboxes: txtSMTPServer, txtFrom, txtTo
They are all set to string[]array.
So you think that if i made these same 3 text boxes in my list form then it would work properly?
I can give it a shot.
|
|
|
|
|
You're really going to need to learn a little about object-oriented programming, otherwise you're not going to understand how this works, and you'll be back here tomorrow with a similar problem.
Where's the code that actually displays the Settings form?
|
|
|
|
|
Try changing the name of the form from "Settings" to something else. "Settings" is a common name used for various classes, some of them exposed as static, that could be screwing with your code.
Also, do not use text data directly from textboxs without validating it first.
When the breakpoint is hit, the yellow line shows you which statement is going to be executed next. If you hover the mouse over a variable name, it'll show you what the current value of that variable is.
|
|
|
|
|
Ok so I changed it from Settings to Prefs. Still no luck.
I'm starting to get discouraged because like you said when I hover the mouse over I see the variables. SMTPServer.Credentials shows nothing, SMTPServer.Host shows nothing as well. When I hover over the Email.To.Add it doesn't show anything at all, doesn't even outline the variable like the other ones do.
Also, when I go in and just change all the variables to the actual values I'm able to get past the lines. All the way down to SMTPServer.Send(Email) but it says "failure to send."
Is there a better or easier way to write this code?
As for validating the text boxes do you just mean running an if statement to make sure there is an actual value in them?
Thanks,
|
|
|
|
|
If everything says their are empty, I'm will to bet that you instantiated a second copy of your Settings (Prefs) form and are using the empty values from that, nor the one the user sees.
|
|
|
|
|
I haven't read the entire thread, but yet I am going to offer a wild guess:
did you instantiate your Settings Form more than once?
i.e. do you have more than one new Settings in all of your code?
if so, you are seeing and interacting with one, but your code is reading empty boxes from the other!
|
|
|
|