Search results

  1. F

    basic error sql

    Can you run the query in Query Analyzer?
  2. F

    Addnew with combx and txtbx sync'd

    Sounds like this exercise is not a good exercise on how to learn programming. Thanks for this last post. It clears up the issue significantly. When I first wanted to do this, I thought, "Hey, why not use a combobox instead of previous/next buttons". Then, I ran into trouble with addnew. Funny...
  3. F

    Addnew with combx and txtbx sync'd

    Check this out: I added a textbox for the CompanyKey. Then, I use the CompanyKey combobox for selecting. When I click add, I use the CompanyKey textbox. Now, everything works. Course, I still gotta figure out how to use the combobox for both selecting and adding, and delete the redundant...
  4. F

    Addnew with combx and txtbx sync'd

    Thanks for trying. :)
  5. F

    Addnew with combx and txtbx sync'd

    I'm using VB.Net 2003. Are you? I can't open any designer windows, only code. If you tell me the name of the combo box I can look at the code itself. oops, it's called companyIDcombobox, nevermind.
  6. F

    Addnew with combx and txtbx sync'd

    I'm having trouble opening it, but I'm working on it. It says the project file is missing the "VisualStudioProject". I did make the CompanyKey unique as there can only be one company such as "PA". Is this incorrect programming? Here is my data scheme: Key Name PA Pacific Co AA Atlantic...
  7. F

    Addnew with combx and txtbx sync'd

    I added your line and it clears now. I click on the Add button but it doesn't save anything (this is the entire code). Funny, I must be missing something, I click on the button, it clears it, and then I type in stuff, but, I don't do anything to "save" what I just entered. Should I clear the...
  8. F

    Addnew with combx and txtbx sync'd

    It's a drop-down list. I has just these bindings: Combobox Datasource is set to Company table, Displaymember is set to CompanyKey, ValueMember is set to CompanyKey. I want to be able to clear everything, enter in a new record, and then refresh. This would mean I have to enter in a company key...
  9. F

    Addnew with combx and txtbx sync'd

    I display records using a combox and textbox. I want to clear both when I call addnew(), and then I can enter in a new record into the combox field and the textbox field. But, it only clears my textbox, it does not clear my combobox. Am I doing this right? Combobox Datasource is set to...
  10. F

    Manually programming a datagrid

    Nevermind. I fixed it. Here is my solution for any readers who need this thread. Compare this code to the first posts' code: ---------------------------------------------------------------------- SqlCommandSelect.Connection = SqlConn SqlCommandSelect.CommandText = "SELECT * FROM COMPANY"...
  11. F

    Manually programming a datagrid

    I want to manually program a datagrid as an exercise in teaching myself how to update, insert, and delete to a dataset and db. Is this a bad thing to do? Anyway, I wanted to ask a question. When you create a data adapter with the wizard it creates the sql statements for you. When I created a...
  12. F

    Bindingmanager before Valuemember?

    If I move the valuemember line above this line, I see the error. bmbCompany = Me.BindingContext(dsDataSet, "Company")
  13. F

    Date in dataset, change format, place in txtbx

    Can you tell me how this is done? I don't know if I should even do it this way. I am pulling data from the database into my dataset. The dates have the minutes, etc. still attached. I want to display a mm-ddm-yyyy on the screen. I thought of using an alias like this in the SQL...
  14. F

    Bindingmanager before Valuemember?

    Here's a quirk. Why does this happen? If I do this: ------------------------------------------------------------ cboCompanyKey.DataSource = dsDataSet.Tables("COMPANY") cboCompanyKey.DisplayMember = "CompanyKey" txtbxCompanyName.DataBindings.Add("text", dsDataSet, "Company.CompanyName")...
  15. F

    Combobox relies on previous combobox

    Thanks for the info! I have 2005 at home so I'm gonnna try it. We're still using 2003 here at work. Thanks again!
  16. F

    Combobox relies on previous combobox

    I have to clear the dataset table in the selectedindexchanged. But, if it doesn't initially exist, it bombs out on me when I try to clear it. Therefore, I do this check: ------------- If Not dsDataSet.Tables("PLAN") Is Nothing Then dsDataSet.Tables("PLAN").Clear() End If -------------...
  17. F

    Combobox relies on previous combobox

    OK, now I see each value as I select it. Thanks! ---------- companySQLParam.Value = cboCompanyKey.Text MsgBox(companySQLParam.Value) ---------- Now I have to figure out how to clear out the Plan combobox in my code so that it doesn't keep adding values on. I use this code to see how many rows...
  18. F

    Combobox relies on previous combobox

    Let me try
  19. F

    Combobox relies on previous combobox

    I put it in the frmLoad and I can messagebox it and see the text "PlanKey". Then, in the selectedindex I messagebox it and see "PlanKey". Is this what I'm supposed to see? ---oh wait, in selectedindexchanged, I have it listed down below. See my code I posted previously.
  20. F

    Combobox relies on previous combobox

    I think it's blank, if I do this: companySQLParam.Value = cboCompanyKey.Text I get an empty msgbox eventhough a value is displayed in the combobox. I feel like I'm missing something obvious.
Top Bottom