|
Dave Kreskowiak wrote: VS2003
And they still haven't fixed it
Well for me it hasn't been such a big problem more like an irritation, I just have to remember to have code displayed when running a project and all is well then .
|
|
|
|
|
I started with a base form designed the labels print, cancel etc two grids that do the same thing on alot of the forms.
I am using Visual Studio 2008 3.5
I am unsure what you mean by override the text property in the parent form, is that something I can do in the designer or do I need to modify the generated code...
I was getting an error in opening the design of the form but resolved that by checking to see if I was in design mode before letting some of my routines run from the load.
Although I have fix the errors that I was getting in the designer now I am not getting errors when I add to the child form new controls they just disappear.
Humble Programmer
|
|
|
|
|
programmer_vb.net_c++ wrote: I am unsure what you mean by override the text property in the parent form, is that something I can do in the designer or do I need to modify the generated code...
In the parent form:
Public Overrides Property Text() As String
Get
Return MyBase.Text 'change this
End Get
Set(ByVal value As String)
MyBase.Text = value 'change this
End Set
End Property
If you do that (and change the lines indicate) you override the text property.
programmer_vb.net_c++ wrote: Although I have fix the errors that I was getting in the designer now I am not getting errors when I add to the child form new controls they just disappear.
This is really weird behavior, never had that happen to me.
I would take the following steps in finding out what happens:
-Close all open windows (code/design windows)
-Clean solution
-Rebuild solution
-restart VS
--> test if it works now
if not:
-create new project
-import parent form
--> test if it works now
if not:
-create new project
-create (simple) parent form (start with a blank one, and then add the controls you want/need)
--> test if it works now
If it works on the last step, my guess would be you have a reference doing something strange. I know its far fetched but I had some very weird behavior with a previous (very bad) component we used.
Let me know if you find a solution or not, in the mean while I'll go tru my early notes and see if I didn't have something similar in the past.
|
|
|
|
|
I am using
If DateSelectionRadioButton.Checked Then
transactionDataView.RowFilter = String.Format("TranDate >= '{0}' AND TranDate < '{1}'", FromDateDateTimePicker.Value, ToDateDateTimePicker.Value.Add(New TimeSpan(23, 59, 59)))
End If
to set a rowfilter to a dataview via two datetimepickers. However, if TranDate is the same for both the start and end date dates no rows are displayed.
How can I correct this please?
|
|
|
|
|
If the dates are the same, your expression cannot ever evaluate to True.
TransDate >= someDate AND TransData < sameDate
will always evaluate to False if the dates are the same. Shouldn't the second expression be "<="??
|
|
|
|
|
Consider an integer-scenario and you'll see why this happens;
TranInt >= 1 AND TranInt < 1
That will evaluate to 'false', won't it? There are multiple solutions, with the easiest being this;
TranInt >= 1 AND TranInt <= 1
Alternatively you could add one day to the "until"-date, or add the time of day;
TranDate >= dd/MM/yyyy 00:00 and TranData < dd/MM/yyyy 23:59
Enjoy
I are troll
|
|
|
|
|
In my posting you will see that I had tried using
ToDateDateTimePicker.Value.Add(New TimeSpan(23, 59, 59)
in my code. I have also tried the
TranDate >= AND TranDate <=
technique without success
|
|
|
|
|
In that case, debugging starts
If DateSelectionRadioButton.Checked Then
Dim startDate As DateTime = FromDateDateTimePicker.Value;
Dim endDate As DateTime = ToDateDateTimePicker.Value;
Dim myRowFilter As String = String.Format _
("TranDate >= '{0}' AND TranDate <= '{1}'", startDate, endDate);
transactionDataView.RowFilter = myRowFilter;
End If
Can you verify that you get records when myRowFilter is empty? And please copy the myRowFilter-string here?
I are troll
|
|
|
|
|
I found that the answer was to use the formatting function of the String.Format to ensure the start date was <date> 00:00:00 and the end date was <date> 23:59:59.
Many thanks to all of those who offered advice.
|
|
|
|
|
Hello,
I have developed the project. Now i need to generate the report and print it. Now i m using data grid view for report. Is the datagrid view good for report. If it is not good then which one is good for report. also i have to print that report. if grid view is good then tell me how to print that grid view. Please reply as soon as possible.
Thanks & Regards,
Mohamed Safi Samsudeen
|
|
|
|
|
You must stop saying words like "PLease reply as soon as Possible"
We dont work for you.
Another thing is that before you post something in a Forum you must first make a reaserch yourself and if you cant find anything on google then youi can come and ask, remember we will go to google and see if its real that you did not find any results.
see what google showed me
http://www.google.co.za/search?hl=en&q=Printing+in+a+Gridview&meta=[^]
Do not do this again
Vuyiswa Maseko,
Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers."
C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.tiyaneProperties.co.za
vuyiswa@its.co.za
www.ITS.co.za
|
|
|
|
|
It totally depends. If you need more formatted output then you can use reporting tools like Crystal Reports, Reporting Services, ActiveReports, etc.
DatagridView printing [^] [^]
|
|
|
|
|
I have Collections.Generic.List of objects so:
Date Reference NetAmount TaxAmount PaidAmount
01/01/2009 0000209 100.00 0.00 100.00
01/03/2009 0000212 120.00 0.00 120.00
01/01/2009 0000209 120.00 0.00 120.00
01/05/2009 0000221 105.00 0.00 105.00
I want to create another Collections.Generic.List but with the items grouped on the Reference field and fields NetAmount, TaxAmount and PaidAmount summed to give:
Date Reference NetAmount TaxAmount PaidAmount
01/01/2009 0000209 220.00 0.00 220.00
01/03/2009 0000212 120.00 0.00 120.00
01/05/2009 0000221 105.00 0.00 105.00
Can I do this with LINQ or some other way please?
(As there may be another way of doing this, other than LINQ, I ddin't post this is the LINQ section of the forum. Apologies if it is misposted)
|
|
|
|
|
|
Is there a .Net function which will create a new instance of an object with all of the object's data but not just copy the reference to the original object? What I need to do is copy an object and alter the data in the copied object without altering the original object.
I have read about the MemberwiseClone() function, but the objects I wish to copy (user defined objects) don't seem to support this method.
Any help is appreciated.
|
|
|
|
|
Nevermind, think I have found the answer by implementing the ICloneable interface. However, if anyone has any other ideas then great, let me have em!
|
|
|
|
|
Different ways fo cloning[^]
Every approach has their advantage/disadvantage. Take your pick
Edit: Fixed the link
modified on Wednesday, February 18, 2009 9:41 AM
|
|
|
|
|
OK, thanks for your reply. But unfortunately that page isn't loading for me. Do I need to register before I can view it?
I do actually have a solution now in place using serialization which seems to work well. Not sure yet of any implications of using this method but I'm sure I will soon find out!
|
|
|
|
|
the class has to cooperate, e.g. by providing a kind of copy constructor, a Clone() method, etc.
You do not really need to declare inheritance from or implementation of ICloneable for that, but once you have a Clone() method, you can as well make it known to the world.
Luc Pattyn [Forum Guidelines] [My Articles]
- before you ask a question here, search CodeProject, then Google
- the quality and detail of your question reflects on the effectiveness of the help you are likely to get
- use the code block button (PRE tags) to preserve formatting when showing multi-line code snippets
|
|
|
|
|
i m a starter to vb.net ..... i m using access database...... wenever i try to update databse using sql commands............ either it doesnt get updated..........smtymes it does on sm values.......or it enter 0 in database fields...
??????whether i use oledb parameters or direct values ......situation remains same??
|
|
|
|
|
Could you please post the code that you're using to perform the update?
Just a remark from a grumpy old programmer; try and write "real" sentences, with full words (no abbrvs.) and limit the number of dots. It makes your text more readable, which causes it to get read more, which in turn leads to more answers.
..and that's what you want after all, answers
I are troll
|
|
|
|
|
Well my friend below is right.We will never know what is the Problem until you show us the code you have written.
Vuyiswa Maseko,
Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers."
C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.tiyaneProperties.co.za
vuyiswa@its.co.za
www.ITS.co.za
|
|
|
|
|
am i writing update statement wrong.when i take values direct from textboxes i write:
Dim cmd1 As New OleDbCommand("update table2 set grade= ' " & TextBox1.Text & " ' and stream= ' " & TextBox2.Text & " 'where name = ' " & TextBox3.Text & " ' ", con)
con.Open()
cmd1.ExecuteNonQuery()
con.Close()
cmd1.executenonquery returns 1 bt grade remains same in database while stream is reset to 0?????
shud i use oledb parameters,,,,,,tel me hw???
|
|
|
|
|
You must start using Parameters. Your Code is untidy
try something like this
Public int Update_Data(String Grade,String Stream ,String Name )
{
con =new OleDbCommand(strcon);
cmd1 = new OleDbCommand();
cmd1.CommandText = "Update table2 set grade=? And Stream = ? where Name = ?";
cmd1.Connection = con;
cmd1.Parameters.Add("@Grade",SqlDbType.NVarChar, 63).Value = Grade;
cmd1.Parameters.Add("@Stream ",SqlDbType.NVarChar, 63).Value = Stream ;
cmd1.Parameters.Add("@Name ",SqlDbType.NVarChar, 63).Value = Name ;
int Results = 0;
try
{
Con.Open();
Results = cmd1.ExecuteNonQuery();
}
catch(SqlException)
{
throw;
}
finally
{
if (con != null)
{
con.Close();
}
}
return Results ;
}
Try this , it might not be Perfect but now if there a Problem its easy to track.
Note that i wrote it here , so dont paste in VS and expect it to work, am just giving you an idea
Hope it help
Vuyiswa Maseko,
Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers."
C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.tiyaneProperties.co.za
vuyiswa@its.co.za
www.ITS.co.za
modified on Tuesday, February 24, 2009 7:13 AM
|
|
|
|
|
but u didnt tell me where to take the values from????......
i m using acess database......
Try
Dim i As Integer
Dim a10, a11, a12 As OleDbParameter
Dim cmd1 As New OleDbCommand("update table1 set stream= @a11,grade=@12 where stdid =@10", con)
a10 = cmd1.Parameters.Add("@a10", OleDbType.Integer, 32)
a10.Value = TextBox4.Text
a11 = cmd1.Parameters.Add("@a11", OleDbType.VarChar, 255)
a11.Value = TextBox5.Text
a12 = cmd1.Parameters.Add("@a12", OleDbType.VarChar, 255)
a12.Value = TextBox6.Text
con.Open()
i = cmd1.ExecuteNonQuery()
con.Close()
Label1.Text = i
Catch ex As Exception
Label1.Text = ex.Message.ToString()
End Try
if i put direct values ie stdid = 1 (which z the primary key)den only it gets updated
and strange updation. stream instead of taking value frm textbox5 takes value from textbox4???
and its nt givin ane exception???
|
|
|
|