Search:
Type: Posts; User: StacyOW
Search:
Search took 0.04 seconds.
-
I have a report that has one subreport attached to it, but will eventually have two more. It runs fine but the subreport data is not displaying the way I need.
My equipment is the on the main...
-
It doesn't surprise me I am between two different approaches.
I'm not sure I'm understanding the difference between a parameter and variable.
I'm trying to follow your instructions to fix...
-
I thought it would work after I took out the last Select, but alas it is now returning the 0 before the 3411. This is how I am executing the proc and getting the return value. Do I need to do...
-
Ahhh light bulb! I was assuming since I assigned it after the first query that it would only use that value.
Thanks techgnome - that was driving me nuts.
Stacy
-
Thanks techgnome for your reply.
My sproc does eventually return my @CompID of 3411, but my question is where is it getting the first returned value of 4050 because that is what it is putting in...
-
I'm using SQL2008 R2. I am executing the following query from VS2010.
USE [MT]
GO
/****** Object: StoredProcedure [dbo].[POToSparts] Script Date: 01/19/2016 15:12:16 ******/
SET ANSI_NULLS...
-
Yes wes4dbt the value is the " / /". So my slashes that are still showing in the field when I remove the numeric values of the date is definitely causing my problem,but I am at a loss as to how to...
-
Tried it and now I'm back to the original error. I can't believe this is so difficult. :confused:
Thanks for trying to help west4dtb. I appreciate it!
Stacy
-
I have no idea wes4dbt. I get the error when I try to remove the date and leave the field. When I try to debug I get a No Source Available - There is no source code available for the current...
-
Well I tried that and now I get a new error when I try to remove the date from the cell.
Here are the properties of my cell.
'InvoiceDate
'
Me.InvoiceDate.DataPropertyName =...
-
In the defaultcellstyle I see a NullValue to which I tried entering NULL and I still have the same error.
The problem seems to be the slashes in the mask. It thinks there is data in the cell...
-
Would I use the CellFormatting, CellEndEdit, CellLeave, DataEventError or cellparsing event to map this? Need a little more guidance.
Stacy
-
I have a winforms app with SQL for the database.
I have added a masked textbox to my datagridview using 00/00/0000 as the mask. When I try to remove the date from the cell I get the following...
-
Just found the culprit. This is the line causing all my problems.
If String.IsNullOrEmpty(CStr(Me.ItemsDataGridView.Rows(e.RowIndex).Cells("ComponentNum").FormattedValue)) = True Then
It is on...
-
I am having a problem trying to remove a value from a datagridview cell. I get the following error when I try to take out the number and leave the field. The field in question is a datatype...
-
Thanks Shaggy Hiker for your response. I was having trouble with the strArr(27) working and thought I was doing something wrong. I must have typed something wrong for it was only returning the 2.
...
-
I'm reading in one line from the comma delimited file and splitting it into an array (about 46 items).
Is there a way to only return the 27th array item (243718) to a textbox? Not sure if this...
-
Edit 1:
:confused::confused: Have you ever tried a DateTimePicker with Format = Short? It accomdates the keyboard quite nicely.[/QUOTE]
OK just tried the DateTimePicker with the Format =...
-
Thanks TnTinMN that was the problem. I was using the "d" and it was formatting to 8/19/2014 instead of 08/19/2014.
My users prefer the maskedTextBoxes because they don't like to move their hands...
-
One more thing TnTinMN, my database is storing the date as 2014-08-19 but the mtb TextBox on my winforms app shows it as 81/92/014. Is there something I need to change for it to keep the first 0...
-
Thanks .paul. It worked. Very cool how that works.
I'm assuming I could do something similar for my DataGridView MaskedTextBox Columns?
Thanks again,
Stacy
-
Thanks for your reply TnTinMN. I haven't done anything like this in vb.net. Still pretty much a newbie. I have added the class to my project and it doesn't work. Do I need to do anything else? ...
-
Tried it with the ##/##/#### and it still doesn't work.
Isn't there a way to clear out the data in a Masked TextBox without locking up the whole program? What if I was using the Masked TextBox...
-
Thank you very much! That solved my problem.
-Stacy
-
I have a winforms app with Sql server 2008 r2. I am trying to get a count of rows in a datatable using getchanges, but it is returning Null and I can't figure out how to handle the NULL so it...
-
Thanks TnTinMN. I'll give it a try.
Stacy
-
I'm not sure I completely understand what you're saying, but I think I've kinda done that with the exception of setting the value property of the DTP from the current item.
I placed a databound...
-
jmcilhinney I appreciate your reply.
Would it be possible to do something probably not very proper and kinda sneaky like putting a textbox on top of a DateTimePicker. Then have the textbox bound...
-
What is the procedure for handling a databound DateTimePicker that might have Null values in table?
I'm about ready to pull my hair out. I've found some different suggestions but they aren't...
-
I can't use the dateTimePicker it doesn't handle Nulls. My dateTimePicker needs to be DataBound. I'm going to have to try to make the MaskedTextBox work.
How does everyone else handle this...
-
I'm just trying to deal with the Null values right now. It seems that DTP doesn't handle those. My DTP field won't always have a date in it. I don't want it showing today's date automatically.
...
-
I am using CR for VS2010 with a winforms app and SQL 2008 R2.
I have a two column report that has a textbox with multiple fields (Con1Name Con1HmPhone Con1WkPhone Con2Name Con2HmPhone Con2WkPhone)...
-
I originally had DataTimePicker but it wasn't loading the dates from my dataTable properly even though it was bound and it would default to today's date even if the table was NULL. I've never used...
-
I don't have any code. I placed the maskedTextBox on my form and clicked on the smart tag to set the mask. That's it.
It fills the dataTable on form load. If the user tries to take the date out...
-
I have a winforms app with SQL 2008 R2.
I have a maskedTextBox with a mask of 00/00/0000 for a date. The problem is if the user tries to take out a date in that field and then tab to the next...
-
Thank you si_the_geek - that solved my problem. I thought I had to tell it I wanted it to use tab.
Thanks,
Stacy
-
I have the following code which exports a SQL 2008 r2 table to a text file, which works great, except it is putting a tab at the beginning of every
row it exports.
Is something in my code...
-
I have a winforms app with SQL 2008. I have a form with a parent table in textboxes and a child in a datagridview. If the users enters a value in the "ActualReading" field in my datagridview and...
-
Is there a way to figure out which field in which table in my DataSet the program thinks has changed?
If I can figure out which field it thinks has changed then I can figure out how it is getting...
-
I don't need a copy sounds like your way would work I've just never done that. I just need to update only the changed records.
There is a primary key on that datatable - itemID when I check in my...
|
Click Here to Expand Forum to Full Width
|