You searched for the word(s): userid:290802

More Search Options

RSS Available

• Re: Listbox - not binding the entire answer set.

  Thanks Pete, I not sure I follow: are you suggesting I use the HasRows and then replace the bind logic below for the While reader.Read() logic? If objDR2.HasRows Then objDR2.Read() Me.lstCurrent.Items.Clear() Me.lstCurrent.DataValueField = "SalesTeam" Me.lstCurrent.DataTextField = "SalesTeam" Me.lstCurrent.DataSource = objDR2 Me.lstCurrent.DataBind() objDR2.Close() End If

  Posted to Data Presentation Controls (Forum) by StrangerMike on 12/4/2009

• Re: Checkboxlist - change the color of the text for those that are checked?

  Thanks Budugu, Worked great. Thanks to all others reply as well.

  Posted to Web Forms (Forum) by StrangerMike on 12/3/2009

• Listbox - not binding the entire answer set.

  Below is the code I use to bind a query result to a listbox. The strange thing is, no matter what parameter I use, the first row of the returned select does not get listed in the listbox. Can you tell me what I am doing wrong? Dim NewOracleConnection As New OracleConnection() NewOracleConnection.ConnectionString = ConfigurationManager.ConnectionStrings("MyOracleConnection").ConnectionString Dim sqlQuery As String sqlQuery = "Select SalesTeam from zuserteams where usernumber = "

  Posted to Data Presentation Controls (Forum) by StrangerMike on 12/3/2009

• Re: How to sync a listbox with a checkboxlist

  Thanks Yousef_Jadallah, The code worked. I just added CheckBoxItem.Selected = True

  Posted to Web Forms (Forum) by StrangerMike on 12/2/2009

• Checkboxlist - change the color of the text for those that are checked?

  Below is code that will take the values in a list box and then 'check' the same values in a checkboxlist. This code works, but is it possible to also change the forecolor of the checked item? thanks For Each CheckBoxItem As ListItem In lstTeams.Items For Each ListBoxItem As ListItem In lstCurrent.Items If ListBoxItem.Value = CheckBoxItem.Value Then CheckBoxItem.Selected = True Exit For End If Next Next

  Posted to Web Forms (Forum) by StrangerMike on 12/2/2009

• Re: How to sync a listbox with a checkboxlist

  Thanks Yousef_Jadallah, I suppose you wouldn't have a VB equivalent ?

  Posted to Web Forms (Forum) by StrangerMike on 12/1/2009

• How to sync a listbox with a checkboxlist

  Hello, I have a list of items in a listbox (the items represent Teams that are assigned to an individual). I have a checkboxlist that lists all the available Teams. How can I take the values in the listbox and check the corresponding matching values in the checkboxlist? Thanks!

  Posted to Web Forms (Forum) by StrangerMike on 11/25/2009

• Understanding SQL Server 2005

  Hello, I am in the process of watching the SQL SERVER 2005 videos. I just installed Sql Server 2005 Developer on a test PC here at work, because I want to try and create a database and then connect to it via another computer where I will build the .net application. I have several questions that I hope you can help me with. 1) I once took a beginners class on SQL Server 2000....there was an object called Enterprise Manager. And if I remember correctly it was there where we could build a database and

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by StrangerMike on 10/15/2009

• Re: Understanding SQL Server 2005

  Excellent, thanks very much. (Soon I won't have to disguise my oracle queries (which you always nab me), to get SQL server answers!)

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by StrangerMike on 10/15/2009

• Re: Using Case in a sql query.

  Thanks for all your suggestions. I have tried them to no avail (all though your suggestions might work in a different senario), but I see a problem with the way the query is written. The problem I think is with the As Revenue . There is a field in one of the tables called Revenue . Whenever I use a sum over....it appears to be summing over this field in the table. If I try renaming my As MyRev, for example it won't allow me to use the Sum Over. I will repost with something a little different

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by StrangerMike on 10/8/2009