Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: bigmelon
  • Content: Threads
  • Order by date
  1. bigmelon

    Fixed Header in asp.net datagrid

    I have tried the code from many different sites, such as this: http://www.codeproject.com/KB/webforms/DataGridFixedHeader.aspx Even when I put the datagrid in a div tag, the header still scrolls off the screen. Has anyone gotten this to work? Thanks in advance.
  2. bigmelon

    Grouping by DOW then HR or just by HR for the whole week

    I have a stored procedure that I use for a report on SSRS. They enter in a date range, and DOW. I have it working for all specific DOW, but I also want them to be able to chose all and haven't been able to figure this out yet. My where statement is: where DATEPART(dw,e.adm_date)LIKE @DOW...
  3. bigmelon

    Syntax Question - Not Like

    How do you say the equivalent to Not Like in a formula? The formula i want is as follows: if {Surgproc.Proc_Type} like '*rima*' and {Surgproc.Proc_Type} not like'*lima*' then "Right IMA" else "" When I put the not in there is says the statement is missing the then statement but without it i...
  4. bigmelon

    Details Section of Group Splitting Between Two Pages

    I have a 7 page report with multiple groups. The one section is splitting between 2 pages, with the group info and two records one one page, and the last record and sum information for the group on the next page. Is there anyway to force the group to stay together with using the page break...
  5. bigmelon

    Combobox in datagrid not functioning for one user

    I have a program that is installed on six different users machines, and it works exactly as I want it to for five of them. But, on one users computer, the datagrid isn't functioning properly. The first field in the datagrid is a time field and when the user hits tab it skips over the next...
  6. bigmelon

    Updating or Inserting Datagrid Row

    I want to be able to insert or update my datagrid without leaving the row. If I insert a row completely and go to the next line, it works fine. However, when I fill in 2 fields out of 5, for example, and try to update or insert without leaving the row it doesn't work. Anyone know why...
  7. bigmelon

    Using Enter key to jump from one datagrid to the next

    Does anyone know how this can be done? I have looked at the IsInputKey and PreProcessKey but haven't had any luck with either one of them. I then made a new class for the datagrid as follows: Public Class MyDataG Inherits System.Windows.Forms.DataGrid Protected Overrides Function...
  8. bigmelon

    Setting the focus to a specific cell in a datagrid

    I have the following code for the current cell changed event of my datagrid: If grdGases.CurrentCell.ColumnNumber = 10 Then If ((Val(grdGases.Item(grdGases.CurrentRowIndex, 9)) < 6 Or Val(grdGases.Item(grdGases.CurrentRowIndex, 9)) > 8)) Then MsgBox("Value...
  9. bigmelon

    Keypress Event Switching to a second datagrid

    i have a textbox and on enter it selects the correct row in the first datagrid. Then on enter I want it to jump from the first datagrid to the second. For some reason the keypress event doesn't fire the first time, but if I select the row again then it works. Any idea why the event is not...
  10. bigmelon

    Having Enter key Function as Tab Key

    Does anyone know how to have the enter key function as a tab key on forms. I know you can do it individually for each textbox and on keypress set the focus to the next textbox, but I am looking for a simple way to do it for a whole form. Also, is it possible to do this within a datagrid...
  11. bigmelon

    DTS Error

    I am moving information from one server to a new one. I have like 15 DTS statements that I use and 9 work fine and 6 of them give me an error. The error I'm getting is "There is already an object named 'Whatever' in the database. The First thing that my DTS's do is rename the table to...
  12. bigmelon

    Details section appearing twice

    I am creating a report with a bunch of subreports. Each subreport is in its own group footer. But for some reason it is showing my details information twice and wondered if anyone knew why? Thanks in advance, Jeremy
  13. bigmelon

    Update / Insert Problem with datagrid

    I have a datagrid for pharmacy charges. If the patient already has charges, then their record exists in the table so i pull it from there. However, if it doesn't exist, i populate a datagrid with all the charges listed and the units column empty so the user can go down and put in the...
  14. bigmelon

    Combining Names into one field to avoid same info

    Ok I have a stored procedure in which I am pulling information from to different servers and combining it with a series of joins. My problem is that I am trying to get the names of everyone in the operating room, but I need to combine them into one field. Right now I get all the names, but...
  15. bigmelon

    Datagrid update changes all values

    When I try to Update my datagrid, instead of just updating the affected rows, it changes all the rows to the values in the row i updated. Here is my code: DA.UpdateCommand = New SqlCommand With DA.UpdateCommand .Connection = cnn .CommandType =...
  16. bigmelon

    Tab Stop Problem

    I have a datagrid with 4 columns, units, description, id, and charge. I only want the user to be able to access the first column, units, using the tab key but can't figure out how. I am using custom datagrid table and column styles. I tried referring so my second column, cs2, in a number of...
  17. bigmelon

    Keypress Event Doesn't Work Until Second Press

    I programmed an event so that when the user press the ' it put in the current time. On the first press of the key, it just places a blank row below the one i am starting and remains null. When the key is pressed a second time, it successfully inserts the current time. Does anyone know how to...
  18. bigmelon

    Insert Command Works Initially, but not after custom column styles

    This code works for the insert: Public Class Cardio Inherits System.Windows.Forms.Form Dim DS As New DataSet Dim DA As New SqlDataAdapter Dim cnn As New SqlConnection("Server=*;Uid=*;" & _ "pwd=*;Database=*;") Private Sub Cardio_Load(ByVal sender...
  19. bigmelon

    Datagrid Update Problem

    When I try to Update my Datagrid, it takes whichever row i edit and puts those values in all datagrid columns instead of just the one. Here is my code: DA.UpdateCommand = New SqlCommand With DA.UpdateCommand .Connection = cnn .CommandType =...
  20. bigmelon

    Entering values in a datagrid

    I want to enter a "'" in a datagrid field and have that trigger to program to enter the current time. Does anyone have any ideas on how this can be done? Any idea would be greatly appreciated!

Part and Inventory Search

Back
Top