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.
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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
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...
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...
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 =...
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...
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...
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...
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 =...
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!
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.