Visual Basic

Private Sub LoadSuppliers()<br />
        <br />
        m_CommandSupplier = New SqlCommand<br />
        m_CommandSupplier.CommandText = "Select SupplierId, SupplierName from Suppliers"<br />
        <br />
        Try<br />
            m_DaSupplier = New SqlDataAdapter<br />
            m_DaSupplier.SelectCommand = m_CommandSupplier<br />
<br />
            // connection has already been created in seprate Sub-Routine            m_DaSupplier.SelectCommand.Connection = m_ConnectionSupplier<br />
<br />
            m_DsSupplier = New DataSet()<br />
            m_DaSupplier.Fill(m_DsSupplier)<br />
<br />
        Catch ex As Exception<br />
<br />
            MsgBox(ex.ToString, MsgBoxStyle.Critical, " Get Suppliers")<br />
<br />
        End Try<br />
<br />
        m_DsSupplier.Tables(0).TableName = "Suppliers"<br />
<br />
1 - it's DisplayMember to the field that's supplying the Text the user gets to see in the Combo and set the ValueMember property to the field that's supplying the ID's for those text items.<br />
<br />
2 - create a new Binding object and add it to the DataBindings property of the ComboBox<br />
<br />
Both these task are accomplished in the following code, SupplierNAme is set as Display MEmber , while the SupplierID is set a value member.<br />
<br />
        With SupplierIDComboBox<br />
            .DataSource = mDsSupplier.Tables("Suppliers")<br />
            .DisplayMember = "SupplierName"<br />
            .ValueMember = "SupplierId"<br />
            .DataBindings.Clear()<br />
            .DataBindings.Add("SelectedValue", PurchaseOrderDetailsDataSet.PurchaseOrders, "SupplierId")<br />
<br />
        End With<br />
<br />
<br />
    End Sub

Now when i run the program, the value for PurchaseOrder and PurchaseOrderDetails tables in both Details and datagrid goes fine.

But when i click 'MOVE NEXT RECORD' button from BINDING NAVIGATOR. All the values in Textboxes and DATAGRIDVIEW changes accurately. But the values in comboboxes like SUPPLIER ID does not change. and it stick to the value that was loaded with FIRST RECORD. What should i do?

funakawa wrote:

how can i hide the Start Button in Vista using VB.NET2005??

funakawa wrote:

Please give me a code!!!!

String.Format(Driver={SQL Native Client};Server={0};Database={1};Uid={2};Pwd={3}, txtServerName.Text, txtDatabaseName.Text, txtUserName.Text, txtPassword.Text) <br />

Dim pt as point
dim hdMousDown as Boolean

    Private Sub SetPoint()
        If hdMousedown = True Then hdMousedown = False Else hdMousedown = True
        pt = Me.PointToClient(Control.MousePosition)
    End Sub

    Private Sub Form1_MouseDown(ByVal sender As System.Object, ByVal e As System.Windows.Forms.MouseEventArgs) Handles Form1.MouseDown
        SetPoint()
    End Sub

    Private Sub Form1_MouseUp(ByVal sender As Object, ByVal e As System.Windows.Forms.MouseEventArgs) Handles Form1.MouseUp
        SetPoint()
    End Sub

    Private Sub Form1_MouseMove(ByVal sender As Object, ByVal e As System.Windows.Forms.MouseEventArgs) Handles Form1.MouseMove
        If hdMousedown = True Then
            Me.Location = New Point(Control.MousePosition.X - pt.X, Control.MousePosition.Y - pt.Y)
        End If
    End Sub

TemplateField tf = new TemplateField ();        <br />
        TemplateBuilder dBdr = new TemplateBuilder ();<br />
        dBdr.AppendLiteralString ("<select name="\"ctl00$DefaultContent$GridView1$ctl09$DropDownList1\"" id="\"ctl00_DefaultContent_GridView1_ctl09_DropDownList1\"">");<br />
        dBdr.AppendLiteralString ("</select>");<br />
        tf.ItemTemplate = dBdr; <br />
        <br />
        GridView1.Columns.Add (tf);

<br />
TemplateField tf = new TemplateField ();  <br />
tf.ItemTemplate = LoadControl("mycontrols.ascx"); <br />
 GridView1.Columns.Add (tf);