|
the problem is that,that whenever i use navigation buttons(which i built using currency manager)..the radio button that i checked earlier during the save stage
dont show up,, rather the default button always appeared checked(which i selected during design))))please help....
how to bind radio buttons wid currency manager
here is the full code of the page that i m designing n coding
Imports System.Windows.Forms.Form
Imports System.Data
Imports System.Data.SqlClient
Imports System.Data.SqlClient.SqlCommand
Public Class vendor
Inherits System.Windows.Forms.Form
Dim objsqlconn As SqlConnection
Dim objsqlcmd As SqlCommand
Dim ds As DataSet
Dim adp As SqlDataAdapter
Dim dv As DataView
Dim objcurrencymanager As CurrencyManager
Private Sub fill()
ds = New DataSet
objsqlconn = New SqlConnection("Data Source=.\SQLEXPRESS;AttachDbFilename=C:\Documents and Settings\Administrator.WINXP_PRO_CORP.002\Desktop\WindowsApplication1\WindowsApplication1\Database1.mdf;Integrated Security=True;User Instance=True")
adp = New SqlDataAdapter("select * from vendordetails", objsqlconn)
adp.Fill(ds, "vendordetail")
dv = New DataView(ds.Tables("vendordetail"))
objcurrencymanager = CType(Me.BindingContext(dv), CurrencyManager)
End Sub
Private Sub bind()
TextBox1.DataBindings.Clear()
TextBox2.DataBindings.Clear()
TextBox3.DataBindings.Clear()
TextBox6.DataBindings.Clear()
TextBox7.DataBindings.Clear()
TextBox5.DataBindings.Clear()
TextBox4.DataBindings.Clear()
'Add new binding
TextBox1.DataBindings.Add("text", dv, "venname")
TextBox2.DataBindings.Add("text", dv, "id_vendor")
TextBox3.DataBindings.Add("text", dv, "phone")
TextBox6.DataBindings.Add("text", dv, "address")
TextBox7.DataBindings.Add("text", dv, "productname")
TextBox5.DataBindings.Add("text", dv, "product_id")
TextBox4.DataBindings.Add("text", dv, "totnoofpurch")
'display a status bar
StatusStrip1.Text = "Ready"
End Sub
Private Sub Form3_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Call fill()
Call bind()
End Sub
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
'objsqlconn = New SqlConnection("Data Source=.\SQLEXPRESS;AttachDbFilename=C:\Documents and Settings\Administrator.WINXP_PRO_CORP.002\Desktop\WindowsApplication1\WindowsApplication1\Database1.mdf;Integrated Security=True;User Instance=True")
objsqlcmd = New SqlCommand
objsqlcmd.Connection = objsqlconn
objsqlcmd.CommandText = "insert into vendordetails(venname,id_vendor,phone,address,purchasetype,productname,product_id,totnoofpurch) values(@venname,@id_vendor,@phone,@address,@purchasetype,@productname,@product_id,@totnoofpurch)"
objsqlcmd.CommandType = Data.CommandType.Text
If TextBox1.TextLength = 0 Or TextBox2.TextLength = 0 Or TextBox3.TextLength = 0 Or TextBox4.TextLength = 0 Or TextBox5.TextLength = 0 Or TextBox6.TextLength = 0 Or TextBox7.TextLength = 0 Then
MsgBox("you have not completed the form")
Else
objsqlcmd.Parameters.AddWithValue("@venname", TextBox1.Text)
objsqlcmd.Parameters.AddWithValue("@id_vendor", TextBox2.Text)
objsqlcmd.Parameters.AddWithValue("@phone", TextBox3.Text)
objsqlcmd.Parameters.AddWithValue("@address", TextBox6.Text)
{{{{{{{{{{{{{{{{{{{{{{{{{{{{{{{{{{{{{{{{{{{{{{{{{{{{{{{{{{{{{{
Dim b As String
Select Case True
Case Is = RadioButton1.Checked
b = RadioButton1.Text
Case Is = RadioButton2.Checked
b = RadioButton2.Text
End Select
objsqlcmd.Parameters.AddWithValue("@purchasetype", b)
}}}}}}}}}}}}}}}}}}}}}}}}}}}}}}}}}}}}}}}}}}}}}}}}}}}}}}}}}}}
objsqlcmd.Parameters.AddWithValue("@productname", TextBox7.Text)
objsqlcmd.Parameters.AddWithValue("@product_id", TextBox5.Text)
objsqlcmd.Parameters.AddWithValue("@totnoofpurch", TextBox4.Text)
objsqlconn.Open()
Dim m As Integer = objsqlcmd.ExecuteNonQuery()
MsgBox(m & "no. of row inserted")
objsqlconn.Close()
End If
If TextBox1.Text = "" Then
TextBox1.Focus()
ElseIf TextBox2.Text = "" Then
TextBox2.Focus()
ElseIf TextBox3.Text = "" Then
TextBox3.Focus()
ElseIf TextBox4.Text = "" Then
TextBox4.Focus()
ElseIf TextBox5.Text = "" Then
TextBox5.Focus()
ElseIf TextBox6.Text = "" Then
TextBox6.Focus()
ElseIf TextBox7.Text = "" Then
TextBox7.Focus()
End If
End Sub
Private Sub Button6_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button6.Click
objcurrencymanager.Position = 0
End Sub
Private Sub Button3_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button3.Click
objcurrencymanager.Position = objcurrencymanager.Count - 1
End Sub
Private Sub Button5_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button5.Click
objcurrencymanager.Position -= 1
End Sub
Private Sub Button4_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button4.Click
objcurrencymanager.Position += 1
End Sub
Private Sub Button7_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button7.Click
TextBox1.Text = ""
TextBox2.Text = ""
TextBox3.Text = ""
TextBox4.Text = ""
TextBox5.Text = ""
TextBox6.Text = ""
TextBox7.Text = ""
TextBox1.Focus()
End Sub
Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
End Sub
Private Sub Button8_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button8.Click
End Sub
End Class
|
|
|
|
|
|
I have a combo box with the system fonts in it, how do I get it to show a font when I start typing, ie typing ar will bring up Arial, tim will bring up Times New Roman etc
|
|
|
|
|
heres a snippet from a prog a wrote in vb6
Public Declare Function SendMessage Lib "user32" Alias "SendMessageA" (ByVal hwnd As Long, ByVal wMsg As Long, ByVal wParam As Long, lParam As Any) As Long
Public Const CB_ERR = (-1)
Public Const CB_FINDSTRING = &H14C
Private Sub Combo1_Keypress(Keyascii As Integer)
Dim CB As Long
Dim Findstring As String
If Keyascii <32 Or Keyascii > 127 Then Exit Sub
If Combo1.Sellength = 0 Then
Findstring = Combo1.Text & Chr$(Keyascii)
Else
Findstring = Left$(Combo1.Text, Combo1.Selstart) & Chr$(Keyascii)
End If
CB = Sendmessage(Combo1.hwnd, CB_FINDSTRING, -1, Byval Findstring)
If CB <> CB_ERR Then
Combo1.Listindex = CB
Combo1.Selstart = Len(Findstring)
Combo1.Sellength = Len(Combo1.Text) - Combo1.Selstart
End If
Keyascii = 0
End Sub
|
|
|
|
|
Cheers Stig will give it a go.
|
|
|
|
|
hello everyone
i have two images of a single finger , stored in byte arrays.
is there anyway i can compare them relatively..i mean is there something that can giv me the relative similarity or difference between the two byte arrays?
|
|
|
|
|
This will only happen if you either write the code to do the comparison or find a 3rd party library that does what you want. There is nothing in the .NET Framework that will do this for you.
Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007
|
|
|
|
|
Hello everyone:
I have a quick question about rich text box controls in visual basic. I basically want to change the colour of the text in one of these controls, but I can't see another way to do it then use the "Select" command. This basically highlights text and then you can make whichever changes you want. The problem is of course that this has all sorts of unpredictable behaviors which can't be foreseen, and of course, its outright sloppy. The problem is I see no other way to edit the internal data easily! What's the standard correct way to do this sort of thing?
Regards,
James
Did I post well? Rate it! Did I post badly? Rate that too!
|
|
|
|
|
Are you trying to change the color of all the text? or just a certain piece?
|
|
|
|
|
What you have now is about the only method you've got. ...Unless you want to start parsing the RTF string and inserting the formatting codes yourself.
Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007
|
|
|
|
|
Ah, that's too bad. Yeah, I only want to edit parts of it. Using the select method has such unpredicatable side effects, its a shame there is no provided control to get around that.
Thanks guys,
James
Did I post well? Rate it! Did I post badly? Rate that too!
|
|
|
|
|
It's a simple implementation of a RichTextBox control. It's not meant to be something like Word. If you wanted more complex functionality, it would require a more complex implementation, like a 3rd party control or something you write yourself.
Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007
|
|
|
|
|
When I open the web page "http://finance.yahoo.com/q/os?s=qqqq&m=2007-04" and view the source in
Internet Explorer with Notepad, the text I am looking for looks like
class="yfnc_h" align="right">11.67<
but when I use
RichTextBox1.Text = Inet1.OpenURL("http://finance.yahoo.com/q/os?s=qqqq&m=2007-04")
it looks like
class="yfnc_h" align="right">11.67<
in the RichTextBox.
What happened to the
|
|
|
|
|
What happened to the what? those two lines of text look the same to me.
|
|
|
|
|
And what is Inet1 defined as? What class?
Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007
|
|
|
|
|
Inet1 is an Internet Transfer Control.
Basically, I am loading the webpage into a richtextbox with
RichTextBox1.Text = Inet1.OpenURL("http://finance.yahoo.com/q/os?s=qqqq&m=2007-04")
But a search for "yfs_l10_" will find nothing.
However, if you use View Source in Internet Explorer, "yfs_l10_" will be found.
I don't understand if the text is getting altered by the Internet Transfer Control or the RichTextBox.
Thanks for you help,
Huling
|
|
|
|
|
Dave, I now see your confusion which is really the basis of my question.
When I cut and pasted some of the text from Notepad into my post it was automatically changed and the text is missing from my post.
This is the same thing that is happening in my program.
So is there a way to turn off the formatting in the richtextbox and make the text appear as it does in Notepad.
I have tried most of the property settings with no success.
Thanks,
Huling
|
|
|
|
|
No, there isn't. Some of the RTB formatting codes look like something out of HTML. If you want to see all of the HTML, you'd have to use a TextBox to do it. The TextBox doesn't support any kind of formatting so there won't be a problem with it trying to interpret the data (Text) of the document.
Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007
|
|
|
|
|
Dave,
Thanks for your replys.
I tried a TextBox and that did not work either. I think it's the Inet control that is reformatting the text.
I did get it working with the API call URLDownloadToFile which apparently saves the raw text a file. I then reload to the RichTextBox for searching and all the text is there.
Thanks again,
Huling
|
|
|
|
|
Hi all,
I use a DropDownList control.When I want to select one row of this,it's not select and the item that it's index is zero selected which means that SelectedIndexChanged event dose not work well.
I set the AutoPostBack property to true but it dosen't work well.
Can you help me?
Thanks in advance
|
|
|
|
|
hi dear friends ,
I need a full project Documentation(sample) .Or how can i prepare a documentation for a project ,what are all the information that a doc should contain ,please help me
Thanks and regards
D.Paranthaman
hi,this is from D.paranthaman india
|
|
|
|
|
First index
Then what are the software u have used...,
Then s/w configuration..,
Whjats the need of that project...,
Then screen shot with some what explanation...,
Then future analysis...,
The bibliography..
Then finally conclusion...
Magi
|
|
|
|
|
I'm working with menus at the moment, and I'm reading in the contents of an XML file to create the menu.
The number of rows in the DataView I am iterating through is around 190. Adding all these rows to a menu is simple enough, but 190 items on a menu doesn't look good.
So, I'd like to break the 190 items into submenus - perhaps 20-ish items on a menu. The bottom option will be "More", and another 20 or so is presented, again with the bottom item "More", and so it continues until all 190 have been accomodated.
A snippet of what I've got so far is:
' Sort the DataView by Country<br />
dv.Sort = "Country"<br />
<br />
For Each dvRow In dv<br />
view_coun_tsmi.DropDownItems.Add(dvRow("Country"))<br />
Next
What I think I need is something like:
Dim counter As Integer<br />
Dim view_coun_tsmi_more As New ToolStripMenuItem<br />
<br />
For Each dvRow In dv<br />
If counter < 21 Then<br />
view_coun_tsmi.DropDownItems.Add(dvRow("Country"))<br />
End If<br />
If counter = 21 Then<br />
view_coun_tsmi_more = New ToolStripMenuItem("More ....")<br />
view_coun_tsmi.DropDownItems.Add(view_coun_tsmi_more)<br />
view_coun_tsmi_more.DropDownItems.Add .... some more options<br />
End If<br />
counter += 1<br />
Next
But this, I think, is a horrible way of doing it.
Is there a better way?
|
|
|
|
|
What about cascading menus?
item1
item2->item1
item2
item3
item4
He was a snowflake, like other "unique" snowflakes, falling down, getting stepped on, and pushed aside to disappear.
|
|
|
|
|
Hi how to print the crystal report......,
with out using that crystalreportviewer toolbar.........
Magi
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
