User Profile

Collapse

Profile Sidebar

Collapse
somacore
somacore
Last Activity: Oct 22 '10, 01:13 PM
Joined: Apr 2 '08
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts

  • somacore
    replied to MS Access Query help - "Spidering" an item
    Thank you FishVal, and Chip for your very helpful suggestions. I'll look into both of these and get back if I need more advice. Thanks so much!
    See more | Go to post

    Leave a comment:


  • somacore
    replied to MS Access Query help - "Spidering" an item
    The reason for this is that each ticket represents a complete fix to a certain production problem. If Ticket #3 were moved without the WB10 component, things would break. The reason for this data is to get a complete picture of all the code necessary for a move once it's cleared for production....
    See more | Go to post

    Leave a comment:


  • somacore
    started a topic MS Access Query help - "Spidering" an item

    MS Access Query help - "Spidering" an item

    For my application I need to be able to compare items in a database and output how they're all related. For example:

    Ticket #1 Programs:
    AA39
    FR08
    AA05

    Ticket #2 Programs:
    AA39
    FR08
    VS01

    Ticket #3 Programs:
    VS01
    WB10

    Ticket #4 Programs:
    AA01

    Now let's say someone wants to do a "spider" (that's what we...
    See more | Go to post

  • I'm not getting an error. The command proceeds as normal, like it's actually updating, then the page does the postback and everything is the same.

    I've added some code to debug it...

    Code:
    protected void FormView1_ItemUpdating(object sender, FormViewUpdateEventArgs e)
        {
            object comments = e.OldValues["comments"];
            object newcomment = e.NewValues["comments"];
        }
    ...
    See more | Go to post

    Leave a comment:


  • somacore
    started a topic Visual C# Webform - FormView Update Not Working
    in .NET

    Visual C# Webform - FormView Update Not Working

    I have a C# webform which uses a formview to insert, update, and delete records selected from a gridview into an Access database. The insert and delete functions work fine, the update does not.
    • The formview has 'id' as a DataKeyName.
    • The update works if done from the Query Builder and I enter the values manually
    • I don't have anything in the codebehind for the update event.


    UpdateCommand:
    Code:
    UpdateCommand=
    ...
    See more | Go to post

  • Wow, that worked like a champ.

    Thanks!
    See more | Go to post

    Leave a comment:


  • somacore
    started a topic c# Webform - Button.Visible=false; behaving oddly.
    in .NET

    c# Webform - Button.Visible=false; behaving oddly.

    I have a webform in C#. This form has both a gridview and a formview. The formview displays the details of the selected gridview index. No problem there.

    On the formview is a button. When this button is clicked it sends an email to the DBAs asking for a database request to be run. This works as well.

    However I would like to idiot proof this webform. I would like to restrict DBA requests to only the sql that is in Code...
    See more | Go to post

  • somacore
    replied to SQL Update Trigger Question
    Thank you, that seemed to fix the issue.

    I wonder why the parser didn't catch that? I was having a non sql moment apparently.
    See more | Go to post

    Leave a comment:


  • somacore
    started a topic SQL Update Trigger Question

    SQL Update Trigger Question

    Hello all,

    I am trying to implement a trigger on a Microsoft SQL Server 2000 database. I have created the trigger, and it works mostly like it should, however I have a slight problem I can't seem to get around.

    We use two fields for this trigger. Both fields are 3 digit numbers (varchar(3) in the database, I have no control over that). The second field is used to store the value of the first field only if the first...
    See more | Go to post

  • It does, but I'm not really seeing a way to implement what you're describing. My combobox has all my texts that I want - they're hardcoded in there. I don't see a way to associate each item with an index?

    I'll look into this. Thanks for the reply....
    See more | Go to post

    Leave a comment:


  • Bump? I can't find anything like this on Google.
    See more | Go to post

    Leave a comment:


  • SelectedText yields the same result.

    When it freezes up like that, I can still access the combobox menu and pick whatever i want, but i can't tab or click out of it. The only other menus I can access are the file and help (the only ones I have), and at that point I have to click file > exit to close the app....
    See more | Go to post

    Leave a comment:


  • I have not tried that, but I will.




    Actually, I don't have any events fire for that combobox. I do, for some other comboboxes on the same form, but not that one....
    See more | Go to post

    Leave a comment:


  • somacore
    started a topic C# Winform - Updating Combobox hangs application.
    in .NET

    C# Winform - Updating Combobox hangs application.

    I have a winform with a combobox. This combobox's text is set to a value from the database (in this case, a number). In my code I take the number and convert it to the proper text, returning the value as the selecteditem for the combobox. This part works.

    However, if I try to UPDATE the value in the combobox at runtime, I am able to select the new value, but after that I cannot do anything. I am unable to select any other element...
    See more | Go to post

  • somacore
    replied to C# Winform Application Case Switch Problem
    in .NET
    The combobox datasource is a datatable, it's the field for the resolution code for that ticket. The textfield has been set to to the value in the datatable for that ticket, like 1, 2, 3, etc. The value field is blank. That's why I figured I could do combobox55.text etc...

    I don't quite understand your case statement example. Could you elaborate?...
    See more | Go to post

    Leave a comment:


  • somacore
    replied to C# Winform Application Case Switch Problem
    in .NET
    Making headway using this solution. Changed my code to:

    this.comboBox12 .SelectedValue = Resolution;

    gives me the error:

    "The input string is not in the correct format."

    The Database value it's pulling is an INT, but I want to put a string in the box. Is this possible?...
    See more | Go to post

    Leave a comment:


  • somacore
    started a topic C# Winform Application Case Switch Problem
    in .NET

    C# Winform Application Case Switch Problem

    Hi, I have some code, below, that takes input from a combobox and is supposed to parse it and display it. However, it doesn't work. I can't figure out why.

    The combobox is the one for the resolution code, which specifies how the ticket was closed.

    The code compiles fine, but the box persists with the number instead of the actual code. Thoughts?

    if (comboBox12.Tex t != "")
    ...
    See more | Go to post

  • This is the code I'm using to trigger the combobox update.

    Code:
    private void comboBox55_SelectedIndexChanged(object sender, EventArgs e)
            {
                this.hD__Site_Name_DataTableAdapter.FillBySite(this.dataSet2.HD__Site_Name_Data, comboBox55.Text);
                this.hD__Requestor_ProfileTableAdapter.FillByPerson(this.dataSet2.HD__Requestor_Profile, comboBox55.Text);
            }
    Combobox55...
    See more | Go to post
    Last edited by somacore; Apr 4 '08, 03:08 PM. Reason: Add Information

    Leave a comment:


  • Sorry, this is a winform app....
    See more | Go to post

    Leave a comment:


  • C# Combobox SelectedIndexChanged - Combobox clears the selection?

    Quick question,

    Is there a way to preserve the value in my combobox when it fires a SelectedIndexCh anged event?

    Right now I have 4 comboboxes all linked together with an SQL query:

    Site
    City
    Manager name
    Phone number

    When I choose the Site name, the event fires and populates the other three boxes, but clears out the Site name box. Why is that?
    See more | Go to post
No activity results to display
Show More
Working...