Hello, I am trying to bind a specific column to a specific control. The problem is that when the combo box control appears blank when I try to bind a column to this control, but if I bind the column to a text box, then it displays the correct value of that column. pbndtemp = New Binding("Text", ds, "schedule_detail.Expr1") Me.cboTrainingProgress.DataBindings.Add(pbndtemp) pbndtemp = New Binding("Text", ds, "schedule_detail.Expr1") Me.txtProgress.DataBindings.Add(pbndtemp) Do I need to evaluate or validate the combo box binding? If so, how do I do that? Thanks, Jay Feng Screwed... the art of moving to a new place because the old place is just too messy and not worth the effort to clean.

Hello, Is there a way to select a row from a table based on a minimum? Or what is the correct syntax? This query returns two rows when I only need a row with the min column... :( select min(col1ID), col2ID, col3 from tbl where col2ID = 'xxxx' group by col2ID, col3 Thanks, jay

Hello, Please advise on how I might be able to make this sproc work... declare @TrainerID int select TrainerID, LastName, FirstName, City, State, Country, r.code, l.description, p.Code from trainers as t inner join Regions as r on t.region = r.regionid inner join Languages as l on t.Language1 = l.LangID --and t.Language2 = l.LangID --and t.Language3 = l.LangID inner join products as p on t.product1 = p.ProductID --on t.product2 = p.ProductID --on t.product3 = p.ProductID --on t.product4 = p.ProductID where TrainerID = @TrainerID The situation is that I have designed in the Trainers (t) table multiple columns of Languages and Products with properties as Int which stores values based on their respective LanguageID and ProductID from the Languages and Products (definition) table. The dilemma is on the result, I would like to see the actual codes and not the ID key of each of the multiple columns coming from the definition tables. Thanks Jay Feng Screwed - the art of moving to a new place because the old place is just too messy to clean.

Sorry, my mistake. I was thinking of the combobox.

Hello, Can anyone give me a sample code on how I could use the @@Error or any OUTPUT @param I have defined to fire off a msgbox based on its value? Basically, when an insert or update happens, I'd like the user to know whether it was successful or it failed. thx a lot

You will need to instantiate a DataGridTableStyle. DataGridTableStyle supports properties such column width, name....

Apparently, I read recently that .NET does not support multiple columns in a listbox. :( I was trying to accomplish the same thing when I read about the this.

Hello, I have several forms where the country drop down is required. Instead of calling to load the country in each form, can someone show me a quick way of just calling it as a class from any form in order for the country code to not be redundant. Thanks prog newbie.

Try this... dim conn = new sqlconnection(connstring) dim cmd = new sqlcommand cmd.connection = conn cmd.commandtype = command.text cmd.commandtext = "SELECT ...." dim da = new sqldataadapter da.selectcommand = cmd dim ds = new dataset da.fill(ds, "tblname") dg.datasource = ds.tables(0) Feng Screwed, the art of moving to a new place because it would just be too much to clean the old place

Go to componentgo.com. There you will find Calendar controls for sale. For around $200, you can get daily, weekly, monthly and resource controls along with the source code which is written in C#.

Hello all, How do I supplement the code below so that when a subitem is null from the database, the field in the listview is populated with a string; such as "n/a"? There will be occasions when a field(s) corresponding to a subitem(s) might be null. ///////////////////// Public Sub FillListView() Dim fieldCtr As Short Dim rdlv As SqlDataReader rdlv = sqlCmd.ExecuteReader Do While rdlv.Read lvItems = New ListViewItem lvItems.Text = Trim(rdlv(0)) For fieldCtr = 1 To rdlv.FieldCount() - 1 If rdlv.IsDBNull(fieldCtr) Then lvitems.SubItems.Add("") Else lvitems.SubItems.Add(rdlv.GetString(1)) lvitems.SubItems.Add(rdlv.GetString(2)) lvitems.SubItems.Add(rdlv.GetString(3)) lvitems.SubItems.Add(rdlv.GetString(4)) lvitems.SubItems.Add(rdlv.GetString(5)) lvitems.SubItems.Add(rdlv.GetString(6)) lvitems.SubItems.Add(rdlv.GetDateTime(7)) 'lvItems.SubItems.Add(rdlv.GetDateTime(8)) End If Next fieldCtr Me.lvSearchProperty.Items.Add(lvItems) Loop Me.btnSubmit.Enabled = False End Sub //////////////// Thanks a bunch, Jaydeanster Ben, is that you?

Hello all, Two part question: A. What am I doing wrong with the code below to generate the error on the Subject line above? B. Is binding the best option (such as the one I have below) of displaying a specific record on a form? ////////////////////// Private sqlConn As SqlConnection Private SqlDataAdapter1 As SqlDataAdapter Private sqlCmd As SqlCommand Private DataSet11 As DataSet Private Sub frmPropertyDetailTest_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Dim pintProperty As Short Dim pbndtemp As Binding sqlConn = New SqlConnection("Server=server;Database=db;User ID=us;Password=pw;Trusted_Connection=False") sqlCmd = New SqlCommand sqlCmd.Connection = sqlConn sqlCmd.CommandType = CommandType.Text sqlCmd.CommandText = "SELECT dbo.property.* FROM dbo.property" sqlConn.Open() SqlDataAdapter1 = New SqlDataAdapter SqlDataAdapter1.SelectCommand = sqlCmd DataSet11 = New DataSet pintProperty = Me.SqlDataAdapter1.Fill(DataSet11) pbndtemp = New Binding("Text", DataSet11, "property.PropertyID") Me.txtPropertyID.DataBindings.Add(pbndtemp) pbndtemp = New Binding("Text", DataSet11, "property.PropertyName") Me.txtPropertyName.DataBindings.Add(pbndtemp) pbndtemp = New Binding("Text", DataSet11, "property.Address1") Me.txtAddress1.DataBindings.Add(pbndtemp) pbndtemp = New Binding("Text", DataSet11, "property.Address2") Me.txtAddress2.DataBindings.Add(pbndtemp) pbndtemp = New Binding("Text", DataSet11, "property.City") Me.txtCity.DataBindings.Add(pbndtemp) pbndtemp = New Binding("Text", DataSet11, "property.State") Me.txtState.DataBindings.Add(pbndtemp) pbndtemp = New Binding("Text", DataSet11, "property.Postal") Me.txtZip.DataBindings.Add(pbndtemp) pbndtemp = New Binding("Text", DataSet11, "property.Country") Me.txtCountry.DataBindings.Add(pbndtemp) pbndtemp = New Binding("Text", DataSet11, "property.Business") Me.txtBusinessNumber.DataBindings.Add(pbndtemp) pbndtemp = New Binding("Text", DataSet11, "property.Fax") Me.txtFaxNumber.DataBindings.Add(pbndtemp) pbndtemp = New Binding("Text", DataSet11, "property.Support") Me.txtSupportNumber.DataBindings.Add(pbndtemp) pbndtemp = New Binding("Text", DataSet11, "proper

Can someone help, I'm having a brain fart (new to vb.net)? Have a form with multiple radio buttons. When a user selects a radio button, then clicks submit, a form based on the selection will open. What is the simplest 'select case' code to do this? Thanks :)

Urgent - HELP!!!!!!!!!!!!!! How do I populate three (3) different listboxes in a single form - programmatically (vb.net)? I really do not want to use the visual tools. The items of the listboxes are coming from the database. I can connect to the database and can query the database to the specific tables, but my dilemma is that I can't seem to populate the listboxes. Do I need to instantiate three different sqladapters and datasets after I connect to the database? Afterwards, how do I map or bind the results to the specific controls. Please provide a simple code. Thanks. Jay (Lost in Self-strangulation)