C# Discussion Boards - CodeProject

scandysmyle9-Jun-07 1:47

9-Jun-07 1:47

how do i add new entries to my database from a form.
am using visual C#.Net 2005 proffesional
i have my connection working but i can't add new entries.
Please help me out!!!!!!!

scandysmyle

Re: Visual C# database?

Colin Angus Mackay9-Jun-07 3:02

Colin Angus Mackay

9-Jun-07 3:02

Create a SqlCommand object and give it an INSERT command. However, you may be better to buy a book on ADO.NET

Upcoming events:
* Glasgow: Mock Objects, SQL Server CLR Integration, Reporting Services, db4o, Dependency Injection with Spring ...
* Reading: Developer Day 5

Never write for other people. Write for yourself, because you have a passion for it. -- Marc Clifton

My website

Re: Visual C# database?

scandysmyle18-Jun-07 10:09

scandysmyle

18-Jun-07 10:09

thanks Bro!! I have a book on C# databases which i picked for $49.99. I just couldn't get it right with oledb.
thanks anyway!!! i appreciate your concern

Re: Visual C# database?

Muammar©9-Jun-07 3:22

Muammar©

9-Jun-07 3:22

Try this article.

Smile: A curve that can set a lot of things straight!
(\ /)
(O.o)
(><)

Re: Visual C# database?

Paul Conrad9-Jun-07 4:55

Paul Conrad

9-Jun-07 4:55

Muammar© wrote:
Try this article.

That's a pretty alright article. I don't know why people voted it down. It is a quick and easy read.

"The clue train passed his station without stopping." - John Simmons / outlaw programmer

Re: Visual C# database?

Muammar©9-Jun-07 6:45

Muammar©

9-Jun-07 6:45

Thank you Paul, You're right, I cant understand what people need sometimes, a few months ago, I had to delete a good article from the purgatory just because the article title wasn't a good choice!.. It was a basic game and it took me so long to prepare, while a very stupid 5 minute article was marked as the most popular article in the cp someday!!

Smile: A curve that can set a lot of things straight!
(\ /)
(O.o)
(><)

Re: Visual C# database?

Paul Conrad9-Jun-07 11:01

Paul Conrad

9-Jun-07 11:01

Muammar© wrote:
I had to delete a good article from the purgatory just because the article title wasn't a good choice!

Rewrite it and give it another shot. It seems that success/failure of articles lean towards the demand for articles in the given topic area.

"The clue train passed his station without stopping." - John Simmons / outlaw programmer

Re: Visual C# database?

Muammar©9-Jun-07 21:49

Muammar©

9-Jun-07 21:49

Thank you Paul, I will, and send you its link Smile | :)

Smile: A curve that can set a lot of things straight!
(\ /)
(O.o)
(><)

Re: Visual C# database?

scandysmyle18-Jun-07 10:16

scandysmyle

18-Jun-07 10:16

thanks man. I got it.!!!
I will make it up to you when you need me!!!

How to consume the web service if only WSDL file is exposed.

AmarjeetSinghMatharu8-Jun-07 23:43

AmarjeetSinghMatharu

8-Jun-07 23:43

Hi All,

I have only the WSDL file given to me.
My requirement is to consume this webservice programmatically through C# code.

Please guide me or show me the relevant link where I can get the knowledge.

Thanks and Regards.
Amarjeet.

Point in Polygon?

Don Rolando8-Jun-07 23:35

Don Rolando

8-Jun-07 23:35

Is there any PointInPolygon function in C#, or more generally in .NET?

I guess this free shapened button uses something I am searching for [Shapes and Regions], but it's using an assembly, so I cannot look how it's actually done. Wink | ;)

There are intersection tests and stuff for rectangles and circles... but the Polygon class is only available for .NET 3.0
I would require it on .NET 2 and .NET CF 2

Does anyone have source, so I have not to do polygon triangulation and to test per triangle?

Or can I use the PtInRegion method from good old GDI somehow, as I would do in VC? Wink | ;)

thanks in advance,
Roland

Re: Point in Polygon?

Christian Graus8-Jun-07 23:46

Christian Graus

8-Jun-07 23:46

You can definately use p/invoke to call any windows API you like.

I don't know of any libraries tho.

Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

Re: Point in Polygon?

Don Rolando9-Jun-07 0:15

Don Rolando

9-Jun-07 0:15

Invoking native API from C#? Mhm, I guess that's too much for my current c# skills. Especially since I would need a representation for the CRegion equivalent in C# so the api can work with it. Sounds not more easy than the triangulation approach, does it?

Besides, why can't the Compact Framework simply offer the GraphicsPath class, so I could construct my polygon as Region? Grrr.... can I trick somehow with RegionData!? I guess not. Frown | :(

Thanks so far anyhow!

Re: Point in Polygon?

AikinX9-Jun-07 0:20

AikinX

9-Jun-07 0:20

It is easy to get the answer for a Region:

<br />
            Region r = new Region(new Rectangle(0, 0, 100, 100));<br />
            Point p = new Point(99,10);<br />
           bool b =  r.IsVisible(p);<br />

If you region is not simple one you have to use GraphicsPath to build the region:

<br />
   GraphicsPath path = new GraphicsPath();<br />
    path.AddRectangle(new Rectangle(0, 4, 2, 5));<br />
    path.AddEllipse (new Rectangle(4, 2, 7, 10));<br />
    //......<br />
    Region region = new Region(path);<br />
    path.Dispose();<br />

Re: Point in Polygon?

Don Rolando9-Jun-07 0:28

Don Rolando

9-Jun-07 0:28

As I wrote in my first post, and 5 minutes before yours: I must also work with compact framework, and there is no graphicspath available. Frown | :(

But thanks anyhow! Smile | :)

glitches in my generic printengine class!

giddy_guitarist8-Jun-07 22:14

giddy_guitarist

8-Jun-07 22:14

hi ,

After reading a few articles , i made this printEngine class that
derives from PrintDocument. The print engine takes any class that
exposes the IPrintableDocument interface. This interface defines a
method that supplies a PrintablePage to the exposing class which
should fill the page with classes that expose IPrintableSection.

Its not very complicated but it does have a few flaws. Like although it
_can_ handle pagination , it does'nt do it very well. The class that exposes IPrintableDocument has to return true/false depending on whether it need to add another page! Also , the TableRowSection does'nt work very well. Obviously , i have to make a whole table class because there needs to be column sizes added. The TableRowSection draws cells according to its own cell text sizes. To make a whole Table class i need to have the graphics class to calculate the sizes of largest text and the whole table. Should i have the PrintablePage send a graphics to the Table class?

Also Could someone please check the code and tell me if the design is ok?

I should mention that i'm a self taught newbie!

Heres the code:
http://gidsfiles.googlepages.com/PrintingCore.cs
http://gidsfiles.googlepages.com/PrintableSections.cs
http://gidsfiles.googlepages.com/PrintTest.cs

This is how the print engine is used with the printTest class:

PrintEngine pDoc = new PrintEngine();<br />
pDoc.PrintableDocument = new PrintTest();<br />
PrintDialog prt = new PrintDialog();<br />
prt.Document = pDoc;<br />
prt.ShowDialog();<br />
PrintPreviewDialog prev = new PrintPreviewDialog();<br />
prev.Document = pDoc;<br />
prev.ShowDialog();<br />
<br />

Thanks so much

Gideon

Re: glitches in my generic printengine class!

Robert Rohde9-Jun-07 0:14

Robert Rohde

9-Jun-07 0:14

Hi,

Hard to say what to change without having more detailed requirements. It would be interesting to know if you need to print one large table spread over several tables.
First of all you will by sure need one PrintableSection for a whole table. Like you already noticed you will need this to calculate proper widths for all the table entries. I also think this makes it easier and provides better variability than trying to make one section for each row. Surely ot needs the Graphics to determine its size, but you already have the GetSize function which should be sufficient also for the TableSection.
Personally I would change the IPrintableDocument.SetPage call to something like PrintablePage[] GetPages(Graphics g, Rectangle pageBounds). This way IPrintableDocument implementations can straight away return any number of pages with its own page break logic. As you already have a return value in the AddSection function the IPrintableDocument would even have an easy hint when it needs to create a new page. With the array of pages your PrintEngine could than easily print page by page until done.

Robert

Re: glitches in my generic printengine class!

giddy_guitarist11-Jun-07 4:50

giddy_guitarist

11-Jun-07 4:50

hi,

thanks so much for replying. Somehow, i did'nt get a notification when you replied , so i figured that this , like the other copies i've posted over serveral forums had'nt been.

I only saw your reply today. I made a whole lot of changes in the code. I made a table class that just creates TableRow sections. Like rightly said , i need the tables , but just for the calculations. So table figures sizes and creates Rows , the Rows ghtexpose IPrintableSection so they are added into the page. I gace the page the Bounds because i thought it was more correct , since bounds would belong to the page. But , yes , it does make sense returning a number of pages. Right now , i have to loop in IPrintableDocument.Print().

There still is a problem though. The rows dont print on the right Y line. They either overlap or a consecutive rows top is just after the previous rows bottom , and this varies acco rding to the font and size.

Could you please just check it one more time??

Here's the source(updated):
http://gidsfiles.googlepages.com/PrintingCore.cs[^]
http://gidsfiles.googlepages.com/PrintableSections.cs[^]
http://gidsfiles.googlepages.com/PrintTest.cs[^]

Thanks so much!!

Gideon

Re: glitches in my generic printengine class!

Robert Rohde11-Jun-07 10:06

Robert Rohde

11-Jun-07 10:06

Hi,

hard to say why your positioning isn't correct by just looking at the code. Next time you should pack a sample project which can be debugged.
Only thing I noticed is that you calculate the row height for each row seperately only looking at the first cell. For me this sounds like a possible source for the error. I would determine one height which should be used by all rows and is the maximum height of all contained strings. This could be done in your table class while it calculates the column widths.

Robert

Nested DataGrid

Muammar©

8-Jun-07 20:51

Hi everyone,
Any idea how to include a sub-table under a table in a DataGrid control??
Many thanks guys Rose | [Rose]

Smile: A curve that can set a lot of things straight!
(\ /)
(O.o)
(><)

Re: Nested DataGrid

danish_ara11-Jun-07 0:56

danish_ara

11-Jun-07 0:56

use Janus Grid ... checkout this site.. www.janusys.com

xml datagrid

Mohammad Daba'an8-Jun-07 20:47

Mohammad Daba'an

8-Jun-07 20:47

hi, i have datagrid filled from xml document, i want to make update, delete, add on the xml document through the datagrid, for example for the edit there will be a hyperlink located on the cloumn will direct me to another windows form and i will have the row data in controls on that windows form and i will make the edit from there, please i need a sample code for an urgent project

Thanks alot
Hamody

Re: xml datagrid

M. J. Jaya Chitra8-Jun-07 22:42

M. J. Jaya Chitra

8-Jun-07 22:42

I tried the following code in my windows form which has a datagrid and i place it in the double click event of the datagridview

Form2 f = new Form2();
f.val = dataGridView1.Rows[dataGridView1.CurrentCellAddress.Y].Cells[0].Value.ToString();
f.Show();

where val is a public variable declared in form2, i an haveing the first field as the primary key field so i referred it as cells[0].

and in the load event i placed the val to the textbox, now we got the key then using this value you can populate the form fields with the values from the xml file know.

I am not sure about your expectation.

Best Regards,
M. J. Jaya Chitra

Re: xml datagrid [modified]

Mohammad Daba'an9-Jun-07 0:16

Mohammad Daba'an

9-Jun-07 0:16

thnx,

I did n some way else, but noww, do u know whow to delete from xml file,

i deleted but i want to remove the node after deletion, for example if we have the following:

<city>
<name>Inida</City>
<time>5:55</time>
</city>
<city>
<name>Jordan</City>
<time>5:55</time>
</city>

and if i want to remove the city where name = India, i want to make it as:

<city>
<name>Jordan</City>
<time>5:55</time>
</city>

not as:

<city>
</city>
<city>
<name>Jordan</City>
<time>5:55</time>
</city>

thanks for helping me Wink | ;-)

-- modified at 3:21 Monday 11th June, 2007

Thanks alot
Hamody

Re: xml datagrid

M. J. Jaya Chitra10-Jun-07 16:53

M. J. Jaya Chitra

10-Jun-07 16:53

Have you find the solution and can you post me the code how you have tried to populate and delete it

Best Regards,
M. J. Jaya Chitra

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.