Re: how to reject the invalid row adding to datatable? - C# Discussion Boards

Re: how to reject the invalid row adding to datatable?

8-Jan-04 16:39

dataTable1.RowChaging += new DataRowChangeEventHandler(dataTable1_rowChaing)

private void dataTable1_RowChanging(object sender, DataRowChangeEventArgs e)
{
if ( e.Action == DataRowAction.Add )
{
if (...)
throw new ApplicationException("不合法的检查项目！");
}
}

------------
the problem is :
this dataTable is associated to a datagrid, when add a new row through the datagrid, the rowchanging event can be trigered. If the row is invalid, the exception will be throwed, and the new row cannot be added to the dataTable1.
But when should I handle this Exception? I can't catch this exception.

Heath Stewart8-Jan-04 17:15

Re: how to reject the invalid row adding to datatable?

8-Jan-04 17:15

You could create a handler for AppDomain.UnhandledException, but it might be simpler to just display an error or warning message box to the user with MessageBox.Show. With Windows XP and higher, they are now using balloons when invalid characters are typed, such as a backslash in a filename or another invalid character somewhere. You could always do something like that, too.

Basically, just don't throw the exception and instead provide feedback to the user.

-----BEGIN GEEK CODE BLOCK-----
Version: 3.21
GCS/G/MU d- s: a- C++++ UL@ P++(+++) L+(--) E--- W+++ N++ o+ K? w++++ O- M(+) V? PS-- PE Y++ PGP++ t++@ 5 X+++ R+@ tv+ b(-)>b++ DI++++ D+ G e++>+++ h---* r+++ y+++
-----END GEEK CODE BLOCK-----

wangier8-Jan-04 17:20

Re: how to reject the invalid row adding to datatable?

8-Jan-04 17:20

But if I don't throw the exception in RowChaging event, i can't prevent the new row to be added to the data table.
Or some way to do that?

Heath Stewart8-Jan-04 18:53

Re: how to reject the invalid row adding to datatable?

8-Jan-04 18:53

Sorry about that. I've been doing so much control development lately I'm too used to such events being CancelEventHandler events (or similar)!

Yes, you'll have to throw the exception so add a handler to AppDomain.UnhandledException like I mentioned before. I recommend you also create a custom exception class that derives from ApplicationException (typically used for custom exceptions to give them a common, application-based base class) that you throw from the DataTable.RowChanging event handler. This way, you can easily just catch this exception in the handler for the AppDomain.UnhandledException event and handle appropriately, which is better than throwing such a oft-used exception and trying to determine where it came from and why it was thrown.

wangier8-Jan-04 21:45

Re: how to reject the invalid row adding to datatable?

8-Jan-04 21:45

I did that. And I throw a ErrorDataRowException which inherits from Application in the data table's RowChanging event.
But when the ErrorDataRowException is thrown, the application didnot enter the method UnHandledExceptionHandler. Instead, the application still popup an window in which told me there is an unhandled exception.
why? pls help me.

[STAThread]
static void Main()
{
AppDomain currentAppDomain = AppDomain.CurrentDomain;
currentAppDomain.UnhandledException += new UnhandledExceptionEventHandler(UnHandledExceptionHandler);

FormRegisterConsole fmMain = new FormRegisterConsole();
Application.Run(fmMain);
}

private static void UnHandledExceptionHandler(object sender, UnhandledExceptionEventArgs args)
{
Exception e = (Exception) args.ExceptionObject;
if (e.GetType() == typeof(Health.ApplicationLibrary.RIS.Register.ErrorDataRowException))
{
MessageBox.Show(e.Message, "data updating", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
MessageBox.Show("出现未处理错误： " + e.Message, "未处理错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}

Heath Stewart9-Jan-04 3:50

Re: how to reject the invalid row adding to datatable?

9-Jan-04 3:50

Try Application.ThreadException then. I use the same thing in our program I designed at work but couldn't remember which event I was using. It's been a long time since I wrote that section of the container application.

Also, just a helpful tip: try the is keyword instead of obj.GetType() == typeof(SomeClass). It results in fewer IL instructions (better performance) and, IMO, is a little easier to read:

public static void Main(string[] args)
{
  Application.ThreadException +=
    new ThreadExceptionEventHandler(UnhandledException);
  Application.Run(new FormRegisterConsole());
}
 
private static void UnhandledException(object sender,
  ThreadExceptionEventArgs e)
{
  if (e.Exception is ErrorDataRowException)
  {
    //...
  }
  else
  {
    //...
  }
}

wangier11-Jan-04 18:24

how to prevent changing columns' width in datagrid?

11-Jan-04 18:24

It's OK, Thanks lot! ^|^

wangier8-Jan-04 16:38

Re: how to prevent changing columns' width in datagrid?

8-Jan-04 16:38

how to prevent changing columns' width in datagrid?

Heath Stewart8-Jan-04 17:12

Re: how to prevent changing columns' width in datagrid?

8-Jan-04 17:12

You could derive from DataGridColumnStyle (or one of the derivative classes to avoid extra work) and override the Width property so that the set accessor does nothing. You'll have to have an internal property or a param in the constructor so you can set the initial width, though, which you can do by setting base.Width. This works in a quick test but still allows the user to drag the splitters (just doesn't actually change the width).

Upon inspection, the members you'd need to override are both private and are not virtual, nor do they use anything relevent that is overridable.

About the only thing I can think of is to override WndProc and handle mouse messages over the column header (which you can get the bounds of through various properties), not passing those to the base.WndProc.

wangier8-Jan-04 20:51

Re: how to prevent changing columns' width in datagrid?

8-Jan-04 20:51

thanks!

Guillermo Rivero8-Jan-04 19:04

Guillermo Rivero

8-Jan-04 19:04

Take a look at www.syncfusion.com[^] and go to FAQ.

Free your mind...

Question about GUI techniques... Interesting, I promise.

madjeux8-Jan-04 15:01

madjeux

8-Jan-04 15:01

Hey, So I have some questions about technique when it comes to .net desktop development. My goal first off, is to be able to create an object on the desktop of my application and be able to pick it up and move it with the mouse. I'm convinced I could do this pretty easily using a Panel/Canvas object with a transparent background, however, I want for my objects to be non-rectangular. More precisely, polynomials of any fashion.

In Java, I used to just create an object that extended the Polygon class, and then assigned a MouseListener to it, check to see if the mouse being clicked was inside the polygon and wallah! C# and Java being so similar I would have expected this to be as well, however it does not seem so.

To elaborate, let me give an example. If anyone is experienced with diagram applications, like Visio, when you grab a line connecting two objects, you can draw it and manipulate it in almost any way you want. This can't possibly be a rectangular object. How is this done?

I'm curious about the technique used because it's something that seems a little less straight forward. However, I may be wrong. Please advise!

Re: Question about GUI techniques... Interesting, I promise.

Christian Graus8-Jan-04 15:29

Christian Graus

8-Jan-04 15:29

madjeux wrote:
C# and Java being so similar I would have expected this to be as well, however it does not seem so.

Just because the language syntax are similar does not mean they come with the same libraries. I'm not sure if it's possible to create a polygon and check if a point is inside it using GDI+, but it's a commonly solved problem, not so hard to do, plenty of info on the web.

madjeux wrote:
If anyone is experienced with diagram applications, like Visio, when you grab a line connecting two objects, you can draw it and manipulate it in almost any way you want. This can't possibly be a rectangular object. How is this done?

Figuring out if a point is on a specific line is very basic trig, even easier than the polygon problem. The best way to do this sort of stuff is to build a rectangle from the outermost points of the shape, quickly check if your point is inside it, and only then do the more complex test. I suggest that different objects all derive from a base class which defines abstract methods for drawing, for checking for hits, and so on. C# being too gay for multiple inheritance, you may want to derive from something else to get some other desired behaviour and define an interface for this stuff.

Christian

I have drunk the cool-aid and found it wan and bitter. - Chris Maunder

Re: Question about GUI techniques... Interesting, I promise.

madjeux9-Jan-04 14:34

madjeux

9-Jan-04 14:34

Ok, I gotcha. What I'm still fuzzy on is how to actually implement this in a wise way. For example, here's my code (which doesn't completely work yet).

using System;
using System.Windows.Forms;

namespace Test
{
	public class Pipe : Control
	{
		public Pipe(){	
			   
		}

		protected override void OnMouseDown(MouseEventArgs e)
		{
			MessageBox.Show("a mouse was clicked and my object knows it");
			base.OnMouseDown(e);
		}
	}
}

How do I add this to a form so that when a mouse is pressed, it distributes the event to my control? I was using "this.Controls.Add(new Pipe())" in initializeComponent, but it doesn't seem to work. Can someone please explain if what I am doing is retarded? Keep in mind, I am going to be adding to this class, but I just want to understand how I can have my components know when they are being clicked on. Thanks!

how to create Componet of my favourite Pict in the ToolBox

meetweb8-Jan-04 14:11

meetweb

8-Jan-04 14:11

I Create The Componet myself,
i want to create my favourite Pict in the ToolBox
i search the information about it, but is show me example
below this.

// C#
// Specifies the bitmap associated with the Button type.
[ToolboxBitmap(typeof(Button)]
class MyControl : UserControl
// Specifies a bitmap file.
[ToolboxBitmap(@"C:\myImage.bmp")]
class MyControl : UserControl
[ToolboxBitmap(typeof(Button), @"C:\myimage.bmp")]
class MyControl : UserControl

how can i change the the absolute address' Picture

it means the picture include in my compont prject
in my class it like
[ToolboxBitmap(typeof(Button), @"myimage.bmp")]
class MyControl : UserControl
but how can i do

meetweb

Re: how to create Componet of my favourite Pict in the ToolBox

Heath Stewart8-Jan-04 16:50

Crystal Reports and Sql Server 2000

8-Jan-04 16:50

When you use just a Type (the first constructor in your snippet), an image is used that has the same namespace and name as your class, but with a .bmp extension. I.e., if your class is Example.Class, then the image to be used is Example.Class.bmp. This image must be an embedded resource.

The second constructor is the name of an embedded resource, so you must include any namespace and the name of the file, like Example.Class.bmp.

The third constructor uses the namespace of the Type you pass in the first parameter and adds the name that you pass with the third constructor. If the class is Example.Class and you pass "Toolbox.bmp" as the name, then the image used is Example.Toolbox.bmp.

In all three cases, the image must be an emdedded resource, not a file on the computer. So, add a bitmap to your project, right-click and select Properties, then change the build type to "Embedded Resource".

You can find more details about this in the documentation for the ToolboxBitmapAttribute class in the .NET Framework SDK.

FIX Gateway Server

Kingvest8-Jan-04 12:53

Kingvest

8-Jan-04 12:53

Has anyody experience in working with FIX? I'd need some help with understanding some general concepts.

Please let me know if anybody can help me with this

obelisk298-Jan-04 12:34

obelisk29

8-Jan-04 12:34

I have created a report using crystal reports but everytime I run it I have to type in the sql password for the database Is there any way I can save this information in the application?
TIA

------------------

Oh My goodness

Heath Stewart8-Jan-04 12:46

8-Jan-04 12:46

You can keep the password in the connection string:

Provider=...; User ID=user; Password=pwd; ...

This isn't very secure, but then again nothing you can store in the assembly isn't because anyone can use ildasm.exe or a similar tool to see what you have in the application.

If you're using SQL Server, perhaps a better way is to use integrated authentication, or SSPI, by excluding the User ID and Password params of the connection string and instead using Integrated Security=SSPI. This will use the credentials of the current (or impersonated) user to attach to SQL Server. The server must be configured to support mixed mode authentication, though (both SQL Server and Integrated Windows authentication).

The best practice is to not store secret information in your app because it's never secret. If you aren't using SQL Server and want you connection to be more secure, rely on either the user specifying the connection string in your application (perhaps as an option) or use ODBC.NET and let them configure their own DSN.

So, as long as this connection string is used for the DB connection for the CR report, you shouldn't have to worry about a password prompt.

obelisk298-Jan-04 13:01

obelisk29

8-Jan-04 13:01

But where is the connection string located within crystal reports?

------------------

I'm naked under my clothes...

Heath Stewart8-Jan-04 13:11

8-Jan-04 13:11

It's not in Crystal Reports, but required to get the data source. If you're using the CR designer, it may not give you this change and instead store it as part of the report definition. Instead, make this a two step process and bind your report to a DataSet, which you can get using a DataAdapter or something. This makes your reports a little more durable so you don't have to worry about recompiling just to change the connection string or anything like that.

To set the data source on the report, use ReportDocument.SetDataSource. When designing, there's an option to design the report bound to a strongly-typed DataSet.