|
IS it not possible to get the Site Description/site Name rather than these Numeric IDs?
-adnan
|
|
|
|
|
Hi all,
I want to retrieve objects from database by SQL. But if the matched
objects number size is huge (e.g. 1000 records), and I want to just get
40 result records for each fetch. How can I write the SQL to achieve this ?
(I don't want to write another SQL to project the first SQL results to 40 record)
Thanks
|
|
|
|
|
|
hi
i have this in the form constructor:
GraphicsPath p = new GraphicsPath();
Point[] points = { new Point(0, 0), new Point(100, 0),
new Point(150, 50), new Point(250, 50),
new Point(250, 350), new Point(0, 350) };
p.AddPolygon(points);
this.Region = new Region(p);
which creates a poligonal form.
i want to have the upper part colored, and im using the same coordinates, like:
Graphics g = e.Graphics;
Point[] points = { new Point(0, 0), new Point(100, 0),
new Point(150, 50), new Point(0, 50)};
Rectangle r = new Rectangle(points);
g.FillRectangle(new SolidBrush(Color.Aqua), r);
but the colored part doesnt match the part of the window i expect! do i have to make coordinates shift or something? i tried rectangletoscreen etc but nothing worked ...
|
|
|
|
|
Control.RectangleToScreen converts client coordinates to screen coordinates, which is not what you want.
Judging by the coordinates, it seems that you're assuming that by setting the clipping region the root coordinate is changed. It's not. A window is always defined by a rectangular area, but by setting a clipping region (or using layered Windows on Windows 2000 and above, which is what the Form.Opacity property uses) you tell the window manager not to draw in that particular region. The root coordinate is unchanged. If you were to clip a rectangle {0, 0, 10, 10} then to start a line at the corner of the clipped area you'd need to start it at {10, 10} (actually just a little past, which is why using the "F" structures like PointF and SizeF is helpful such that rounding to whole numbers of pixels usually takes into account the discrepency).
This posting is provided "AS IS" with no warranties, and confers no rights.
Software Design Engineer
Developer Division Sustained Engineering
Microsoft
[My Articles] [My Blog]
|
|
|
|
|
but my region starts from (0, 0) and i want to fill a region starting from (0, 0) too - so it does start from there, but when i give a bottom right corner of (150, 50) it does not match with the (150, 50) point i used for the region before!
and this is my problem.
i understand that the root coordinates are unchaged - thats what i count on - why does the fill go with wrong coords ?
|
|
|
|
|
You'll need to be a little more specific. If you can, please posts a couple of screenshots of what you have and (if you can muster it) what you'd like to see, as well as the contents of your OnPaint method and any methods called less frequently (preferrably, for performance) to calculate the region.
This posting is provided "AS IS" with no warranties, and confers no rights.
Software Design Engineer
Developer Division Sustained Engineering
Microsoft
[My Articles] [My Blog]
|
|
|
|
|
how about some ASCII art ? 
the initial window:
xxxxx
xxxxx
xxxxx
xxxxx
the nonrectangular window:
yyy
xxxxx
xxxxx
xxxxx
i want the yyy part colored.
and thats where the coords fail me - i get something like
yyy
yyyyx
xxxxx
xxxxx
all the code i use is in my first post
|
|
|
|
|
The ASCII art's not bad, but next time enclose each segment in <PRE></PRE> tags so that it's truly ASCII art (fixed-width).
Out of curiosity, are you drawing tabs for a custom tab control? If so, you should owner-draw tabs or at least not define the tabs themselves as controls. You can do it that way, but that's pretty heavy-weight compared to a single control (like the TabControl in the BCL) managing what's visible using components (like the TabPage in the BCL).
One problem I see is that with the second block of code where you add a colored rectangle, you're not actually adding a rectangle. You're adding another polygon. The following extents do not a rectangle make (a little Yoda speak for you):
{0,0} {100,0}
{0,50} {150,50}Try making it an actual rectangle (changing 150 to 100, I'd assume) or drawing a polygon using the Graphics object passed to you from the PaintEventArgs in your OnPaint override and see if that works.
This posting is provided "AS IS" with no warranties, and confers no rights.
Software Design Engineer
Developer Division Sustained Engineering
Microsoft
[My Articles] [My Blog]
|
|
|
|
|
hi, heath, thanx for bearing with me
no this is not a custom tab control, but a non rectangular window. the intent is for the upper poligonal(nonrectangular) part to be used as a handle to mousedrag the window by.
the first part of the code is in the contructor, and the second goes inside the OnPaint override.
im copying the code again -
in the constructor:
GraphicsPath p = new GraphicsPath();
Point[] points = { new Point(0, 0), new Point(100, 0),
new Point(150, 50), new Point(250, 50),
new Point(250, 350), new Point(0, 350) };
p.AddPolygon(points);
this.Region = new Region(p);
in the Paint override:
GraphicsPath p = new GraphicsPath();
Point[] points = { new Point(0, 0), new Point(100, 0),
new Point(150, 50), new Point(0, 50)};
p.AddPolygon(points);
g.FillPath(new SolidBrush(Color.Aqua), p);
g.DrawPath(Pens.Red, p);
if you paste this directly into a windows form application code you will see what i mean (i would have posted the entire solution if i knew how to do it here
|
|
|
|
|
You shouldn't be doing redundant calculations in your OnPaint override; you waste CPU cycles. If the GraphicsPath doesn't change, then don't keep recalculating it. OnPaint (or rather, the WM_PAINT window message) is called many, many times by the OS.
To post code, simply copy and paste the code in between <PRE></PRE> tags and escape any characters like < with <, > with >, and & with &
You also don't need VS.NET. I added csc.exe's directory (the Framework version directory) to my PATH environment variable (as well as the SDK's Bin directory) and do almost everything you'd see from me on this site using a vanilla text editor called VIM[^] and the command-line compiler.
With a VIM script, I can post this easily to this site:
using System;
using System.Drawing;
using System.Drawing.Drawing2D;
using System.Windows.Forms;
class Test : Form
{
static void Main()
{
Application.Run(new Test());
}
GraphicsPath grabHandle;
Brush pathBrush = new SolidBrush(Color.Aqua);
Pen pathPen = new Pen(Color.Red);
Test()
{
GraphicsPath p = new GraphicsPath();
Point[] points = new Point[] {
new Point(0,0),
new Point(100,0),
new Point(150,50),
new Point(250,50),
new Point(250,350),
new Point(0,350)};
p.AddPolygon(points);
this.Region = new Region(p);
grabHandle = new GraphicsPath();
points = new Point[] {
new Point(0,0),
new Point(100,0),
new Point(150,50),
new Point(0,50)};
grabHandle.AddPolygon(points);
}
protected override void OnPaint(PaintEventArgs e)
{
base.OnPaint(e);
Graphics g = e.Graphics;
g.FillPath(pathBrush, grabHandle);
g.DrawPath(pathPen, grabHandle);
}
}So far as I know, it appears to work just fine.
If you need to post a picture of what you expect, drawing something up (may I suggest the free Paint.NET[^] application from Washington University and Microsoft) and post it online. Surely you have a site somewhere where you can post a simple image. If not, you can email it to me but only as a last resort (and never continue a thread from this site personally - I get very irritated since this site contains wonderful forums). My email address you'll find in the automatic email notification message that gets sent to you when I reply to your post.
This posting is provided "AS IS" with no warranties, and confers no rights.
Software Design Engineer
Developer Division Sustained Engineering
Microsoft
[My Articles] [My Blog]
|
|
|
|
|
dont worry i would bother you for something as silly as this
i've compiled your code and i got what i have achieved already:
http://viewmoresoft.com/rez1.jpg
but my goal is
http://viewmoresoft.com/rez2.jpg
i've setup the form so it is without the title bar etc
when i do a fill of the region it fills the entire visible area, but when i want to get my poligon filled it does it not the way i want.
can you see what i am trying to achieve now ?
|
|
|
|
|
In the future, please format your links to actually be links. The format toolbar below the message window is handy, and you can always use basic HTML elements when posting.
Now that I have some idea of what you want, it's quite a easy. You didn't notice that width of the angled portion was exactly the same as the width of the Windows title bar? The window frame is the non-client portion, so when you were setting your clipping area amounts where adjusted. If you set Form.FormBorderStyle to FormBorderStyle.None you'll get what you want:
using System;
using System.Drawing;
using System.Drawing.Drawing2D;
using System.Windows.Forms;
class Test : Form
{
static void Main()
{
Application.Run(new Test());
}
GraphicsPath grabHandle;
Brush pathBrush = new SolidBrush(Color.Aqua);
Pen pathPen = new Pen(Color.Red);
Test()
{
FormBorderStyle = FormBorderStyle.None;
GraphicsPath p = new GraphicsPath();
Point[] points = new Point[] {
new Point(0,0),
new Point(100,0),
new Point(150,50),
new Point(250,50),
new Point(250,350),
new Point(0,350)};
p.AddPolygon(points);
this.Region = new Region(p);
grabHandle = new GraphicsPath();
points = new Point[] {
new Point(0,0),
new Point(100,0),
new Point(150,50),
new Point(0,50)};
grabHandle.AddPolygon(points);
Label lbl = new Label();
Controls.Add(lbl);
lbl.Location = new Point(8,58);
lbl.Size = new Size(200, lbl.Height);
lbl.Text = "Click anywhere to close";
lbl.Click += new EventHandler(Clicked);
}
void Clicked(object sender, EventArgs e)
{
Close();
}
protected override void OnClick(EventArgs e)
{
base.OnClick(e);
Close();
}
protected override void OnPaint(PaintEventArgs e)
{
base.OnPaint(e);
Graphics g = e.Graphics;
g.FillPath(pathBrush, grabHandle);
g.DrawPath(pathPen, grabHandle);
}
}You'll need to adjust your border line, though. Because of a behavior similar to - if not related - to culling some lines won't be visible. You could thicken your border a little and contract it a pixel or two (depending on the new thickness), or you'll need to adjust it manually based on the thickness.
This posting is provided "AS IS" with no warranties, and confers no rights.
Software Design Engineer
Developer Division Sustained Engineering
Microsoft
[My Articles] [My Blog]
|
|
|
|
|
this is still not it 
this is what your code and mine so far achieve. sorry, maybe i have mislead you, but in my code i do use FormBorderStyle.None, havent pointed it out, my mistake.
however what i want to achieve is this (the part in purple). do you see the difference?
i am very thankfull for your time and help.
|
|
|
|
|
It looks fine on my machine. It's only simple math, after all. You're clip is only 50 pixels down from the top and your second GraphicsPath never extends beyond that.
This is what I get on my machine (and the DPI should have nothing to do with it since you're using the same coordinate space for the clipping region and the drawing region).
This posting is provided "AS IS" with no warranties, and confers no rights.
Software Design Engineer
Developer Division Sustained Engineering
Microsoft
[My Articles] [My Blog]
|
|
|
|
|
yes, it looks very good on the picture - exactly how i want it. but to my utter dismay i cannot achieve this locally. i tried through vs.2003, then with command line csc.exe - nothing helps, and all i do is copy & paste the code you posted ... amazing .... im using .Net Framework v.1.1.4322..an idea that just came up - could you post your compiled exe file? i decided to upload mine too, here.
Change: this is insane - i run the application on another machine and it is fine there! so from the very beginning the problem was in the configuration on my machine, which is obvious now, because from the start my code was exactly as the one you posted. i guess i'll have to reinstall stuff.... thanx for your patience and support! have a very merry Christmas !
|
|
|
|
|
Good to know it's working. I just wanted to state that whether you use VS.NET or csc.exe there isn't any difference. VS.NET does not work "magic" like VS did for VB6 (the .frm files weren't the easiest to edit by hand). VS.NET uses the CodeDom to serialize code and the compilers use the same code to compile source. The VC++ compiler, on the other hand, is different between VS.NET and the Platform SDK, the latter of which doesn't have as good as optimization as the VS.NET compiler.
This posting is provided "AS IS" with no warranties, and confers no rights.
Software Design Engineer
Developer Division Sustained Engineering
Microsoft
[My Articles] [My Blog]
|
|
|
|
|
any idea why i have different results on different pc-s?
my development pc is windows 2k server, i reinstalled the os, .net framework, .net sdk, and still cant get a correct window.
no problems though on the xp i run on it for test
|
|
|
|
|
As I mentioned before, it could be your DPI (dots per inch, or PPI for pixels per inch in some other countries/regions). Check your monitor settings. Since you're using pixels for both GraphicsPaths I don't see how this would be a problem, though, so long as you have no form border.
The Framework itself is agnostic to the platform (for those classes - like most - that are supported by every Windows platform) so its settings on the machine that are affecting your Form. Without being there on your computer it's hard to say.
This posting is provided "AS IS" with no warranties, and confers no rights.
Software Design Engineer
Developer Division Sustained Engineering
Microsoft
[My Articles] [My Blog]
|
|
|
|
|
I have a question and I think it's so trivial:
how can i update the database binded to the data grid when I change or edit any record or add a new record.
I know how to retrieve data from the database and display it into the grid , but i need to update back the database with any update or addition to any record.
Thank you so much.
|
|
|
|
|
Read the DataAdapter.Update method documentation[^], which includes a lot of information about how to both fill a DataSet from a database to be bound to a DataGrid, as well as how to update the database from the changes in the DataSet using the Update method.
The DataSet class - or rather the DataTable instances that it contains - can track changes to the tables. Do not call DataSet.AcceptChanges before calling DataAdapter.Update and the database is updated appropriately as long as you've assigned your UpdateCommand, InsertCommand, and DeleteCommand properties on the derivative DataAdapter (like SqlDataAdapter) correctly.
It's also important to mention that for the InsertCommand you should also combine it with a SELECT statement (separated by semi-colons, as with most SQL expressions) so that auto-generated fields are updated to their appropriate values after inserting the records into the table in the database.
The example referenced above also includes example source. For simple SELECT statements (assigned to the required SelectCommand, you can use the appropriate command builder (like the SqlCommandBuilder) to generate the other three statements. More complex statements require that you manually construct the expression.
You can also get a lot of this for free from the designer. If you add a server reference to an RDBMS in the "Server Explorer", you can drag and drop a table, stored procedure, or view onto your Form or UserControl to create a connection and command object. You can then drag a DataAdapter derivative component from the "Data" toolbox category onto the designe and configure that programmatically. From that you can generate a typed DataSet (for faster look-ups and type safety). You can do those last two steps in reverse as well.
Dragging and dropping the right components allows you to data-bind a DataGrid through the designer with minimal code. At the are minute, the following lines (or similar, depending on your field names) are required:
sqlDataAdapter1.Fill(dataSet11);
dataGrid1.DataSource = dataSet11; The names above are what the default names may look like if you were to just accept all the default names, which isn't recommended since they are not self-descriptive which always improves code readability and decreases coding errors due to non-descript variable names.
For more information about how to do this using VS.NET, read Displaying Data Sources in Server Explorer[^] and Windows Forms Data Architecture[^] in the VS.NET product documentation. And as I always recommend, take a look at the source files to see what the VS.NET designer wrote to your source files. This includes showing all hidden files (click on the "Projects" menu, and check "Show Hidden Files") and expanding regions (collapsable regions of source code) so that you can see all the source code. Everything you do in the designer serializes to either code or some data file, so nothing should be "behind the scenes" so long as you look in the right place.
This posting is provided "AS IS" with no warranties, and confers no rights.
Software Design Engineer
Developer Division Sustained Engineering
Microsoft
[My Articles] [My Blog]
|
|
|
|
|
Hi,
I have to display some xml document text in a richtextbox. All is ok except the formatting. Is there any usercontrol or plugin to do so?? The problem on hand is the xml document is in memory, not file. Moreover, this text will be changing based on the values of some comboboxes, ect. So, I cannot write to a file.
Please help.
Cheers
CNU
|
|
|
|
|
Hallo,
I am using the TcpChannel class in .Net Remoting. Does anybody know how to add authentication (username and password), or is it only available for the HttpChannel class.
Thanks for your help,
Björn
|
|
|
|
|
U could use CallContext to send the user info to the server application everytime u call a remote object.
Check out more about this here: CallContext[^]
|
|
|
|
|
Is their a way to add new properties to windows folder using C# .Eg I need a description property for folder where in I can type in some description relevant to the folder
Umesh.b
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
