Re: XML Serialisation on Circular Dependency - C# Discussion Boards

Re: Cannot connect into SQL Server using C#

Eddy Vluggen23-Apr-09 7:18

23-Apr-09 7:18

Do you want:
* SQL Server (Serves lots of people at once)
* SQL CE (Embedded database)
* MySQL (...) ?

The SQLConnection is used for SQL Server, not MySQL. SQL Server might be installed by the VS2008 setup, MySQL is a separate download.

Downloads be here[^], tutorials on SQL Server are here[^].

I are troll Smile | :)

Re: Cannot connect into SQL Server using C#

Gindi Bar Yahav23-Apr-09 7:28

Gindi Bar Yahav

23-Apr-09 7:28

thanks you very moch for your help, what i am looking for is a software database so i dont really i need very big database, but ill try to work with SQL server to learn it... the last qustion if you can help me is if you know where i can find database hosting

Gindi Bar Yahav - Web & Software defeloper.

Re: Cannot connect into SQL Server using C#

Eddy Vluggen23-Apr-09 8:47

Eddy Vluggen

23-Apr-09 8:47

Gindi Bar Yahav wrote:
where i can find database hosting

I'd like to recommend ASP Spider[^]. It's the ideal place to try out new ASP.NET/SQL projects, since it is free.

I are troll Smile | :)

Re: Cannot connect into SQL Server using C#

SayreCC23-Apr-09 15:41

SayreCC

23-Apr-09 15:41

Hi, add another \ to every \ you have in the connectionstring.

Hope this one can help

Thanks

Re: Cannot connect into SQL Server using C#

Gindi Bar Yahav23-Apr-09 22:56

Gindi Bar Yahav

23-Apr-09 22:56

i have tried it before, it dosent do any change, becuse i added @ before the connection string.

Gindi Bar Yahav - Web & Software defeloper.

XML Serialisation on Circular Dependency

EnlilCox23-Apr-09 6:19

EnlilCox

23-Apr-09 6:19

Hi
Say I have 3 classes Book, Page and Chapter. A Book has many Pages, a Page has many chapters.

I wrote it so that Page has a reference back to Book and Chapter has a reference back to Page which I found really useful because I could pass around Page but still get access to the Book object and find out how many other pages there are (as an example).

Of course, this creates a circular dependency which, now that I need to, I can't serialise this with XML.

What should I have done ? Have another object that maintained references to all these objects ? Passed both Book, Page & Chapter around rather than just Chapter ?

If anyone can shed a little light I would be very pleased.

Thanks

Re: XML Serialisation on Circular Dependency

Le centriste23-Apr-09 9:10

Le centriste

23-Apr-09 9:10

For serialization, you could decorate the back references properties or public members with the [XmlIgnore] attribute, but that would not solve the deserialization problem.

I suggest you review your design. Could you post the code for your classes, I may be able to give you some pointers.

Re: XML Serialisation on Circular Dependency

EnlilCox23-Apr-09 22:13

EnlilCox

23-Apr-09 22:13

Hi, Thanks for replying.
I tried the XmlIgnore route but then realised that there is no AfterSerialisation on XML Serialisation which mean that it wasn't what I wanted.

With classes like this

<br />
    public class Book<br />
    {<br />
        public List<page> Pages { get; set; }<br />
        public string Title { get; set; }<br />
    }<br />
    public class Page<br />
    {<br />
        public Book ParentBook {get;set}<br />
        public List<chapter> Chapters { get; set; }<br />
        public int PageNo { get; set; }<br />
        public Page(Book parent)<br />
        {<br />
            ParentBook = parent;<br />
        }<br />
    }<br />
    public class Chapter<br />
    {<br />
        public Page ParentPage { get; set; }<br />
        public string Heading { get; set; }<br />
        public string Content { get; set; }<br />
        public Chapter (Page parent)<br />
        {<br />
            ParentPage = parent;<br />
        }<br />
    }<br />
</chapter></page>

I can do something like this

<br />
Book b = new Book() { Title = "My Book" };<br />
Page p = new Page(b) { PageNo = 1 };<br />
Chapter c = new Chapter(p) { Heading = "Introduction" };<br />
<br />
RenderChapterNavigation(c);<br />
<br />
private static void RenderChapterNavigation(Chapter c)<br />
{<br />
  if (c.ParentPage.Chapters.Count == 0)<br />
  {<br />
    RenderNoChaptersLink();<br />
  }else{<br />
    RenderChapters(c);<br />
  }<br />
}<br />

(this is not the exact code, but you can see how I can references the other chapters after having just passed in a Chapter object).

Re: XML Serialisation on Circular Dependency

Le centriste24-Apr-09 2:30

Le centriste

24-Apr-09 2:30

What kind of XML structure are you expecting?

Re: XML Serialisation on Circular Dependency

EnlilCox26-Apr-09 23:07

EnlilCox

26-Apr-09 23:07

Hi
I have no preference on the structure but what I wanted was to to have the backward-links from Page to Section and Page to Book reestablished automatically when I deserialised it.

Thanks for your replies

Unit Testing

mark_w_23-Apr-09 5:09

mark_w_

23-Apr-09 5:09

I have a number of test that each submit an object to a Queue (that is declared statically in my Unit test Class) The queue automatically processes each item until there is non left and then fires an event allProcessed.

The problem, is that for each unit test all i test is that it was added to the queue correctally, and i need to let the queue finish processing and at the moment it is getting cut off becasue all the tests finish before the queue processed.

Is there any way to make the test run wait until the allProcessed is fired?

Thanks

Re: Unit Testing - WORKED IT OUT

mark_w_23-Apr-09 5:15

mark_w_

23-Apr-09 5:15

Just checked in

public static void MyClassCleanup()
{
if(QueueLength!=0)
{
Thread.Sleep(1000);
}

}

Deploying custom fonts at Client Place

ramz_g23-Apr-09 3:24

ramz_g

23-Apr-09 3:24

Hi,

I've developed an application that uses a few font styles that might not be present in all machines... How can I embed these fonts when I deploy my application at the Client's system, assuming that his system does not have those fonts installed... Please suggest...

Thanks in Advance,
ramz_g

Re: Deploying custom fonts at Client Place

Eddy Vluggen23-Apr-09 3:45

Eddy Vluggen

23-Apr-09 3:45

See Microsofts' knowledgebase[^] Smile | :)

I are troll Smile | :)

Re: Deploying custom fonts at Client Place

ramz_g23-Apr-09 5:01

ramz_g

23-Apr-09 5:01

Hi Eddy,
Thanks for the reply... But I think you misunderstood my question... Suppose my client's system does not have a font style named "xyz" which I used in my application. I asked how to embed the font in my application and deploy the application on my client's system so that he sees the same font styles that I used while developing the application.

Re: Deploying custom fonts at Client Place

Eddy Vluggen23-Apr-09 5:04

Eddy Vluggen

23-Apr-09 5:04

You'll have to put the font in the font-directory, that's it. If 'xyz' is installed there, your application can use it without problems. I doubt that it can be used when it's merely an embedded resource. I might be mistaken off course, perhaps one of the other readers has a better idea or option that you may try Smile | :)

--edit--
I was mistaken! Big Grin | :-D

I are troll Smile | :)

Re: Deploying custom fonts at Client Place

Luc Pattyn23-Apr-09 5:12

Luc Pattyn

23-Apr-09 5:12

Hi,

have a look at the PrivateFontCollection Class.

Smile | :)

Luc Pattyn [Forum Guidelines] [My Articles]

Avoiding unwanted divs (as in "articles needing approval") with the help of this FireFox add-in

Re: Deploying custom fonts at Client Place

Paddy Boyd23-Apr-09 6:34

Paddy Boyd

23-Apr-09 6:34

You do need to be careful here, as if they don't have the fonts installed, they might not then have licenses to use them. You don't want to be distributing copyright material now...

Re: Deploying custom fonts at Client Place

ramz_g23-Apr-09 7:53

ramz_g

23-Apr-09 7:53

Hi All,
Thanks a lot for the suggestions...

Thanks,
ramz_g

C# and Outlook

thehacker21323-Apr-09 2:53

thehacker213

23-Apr-09 2:53

Hello,

i had build a selfdefinied form in Outlook. This is named by "IPM.Note.Pizza" and is located in the Mailbox. Now I want open outlook with C# (Microsoft.Office.Interop.Outlook) and set the value of the Combobox (CB_Pizza). I know how its look like by a normal mail, but how is the way by selfdefined forms?

Thank you Smile | :)

Christoph Herzinger

[Message Deleted]

DJ24523-Apr-09 2:21

DJ245

23-Apr-09 2:21

[Message Deleted]

Re: Create GanttChart

musefan23-Apr-09 2:45

musefan

23-Apr-09 2:45

well I think you are going to have to pay someone to do it as you don't seem to have the ability to try/do for yourself

Why is it so urgent? Are you getting paid to do this?

Life goes very fast. Tomorrow, today is already yesterday.

Re: Create GanttChart

paas23-Apr-09 3:12

paas

23-Apr-09 3:12

Search the articles on this site for Gantt Chart and you will find enough to get you well on your way.

And please avoid using the word "urgent" in any future messages.

Re: Create GanttChart

Christian Graus23-Apr-09 10:23

Christian Graus

23-Apr-09 10:23

Sounds like you took a rentacoder job and then realised you have no idea how to do it. Contact the client, tell them you are a liar.

Christian Graus

Driven to the arms of OSX by Vista.

"I am new to programming world. I have been learning c# for about past four weeks. I am quite acquainted with the fundamentals of c#. Now I have to work on a project which converts given flat files to XML using the XML serialization method" - SK64 ( but the forums have stuff like this posted every day )

HttpPostedFileBase and locking...

daviiie23-Apr-09 2:17

daviiie

23-Apr-09 2:17

Hi all,

Ok this is the problem. I am using the microsoft MVC web framework to build a web app. I have a method that uploads files to the server by retriving the HttpPostedFileBase files from the HttpFileCollectionBase in the Request. I then invoke the HttpPostedFileBase method SaveAs(path) to save those files to the filesystem.

I have just implemented a Remove method that takes the filename and path, ensures the existence of the file by calling File.Exists() then attempting to call File.Delete() to remove the said file. The problem is when I have just uploaded this file, when I go then to delete it right away I get a

"The process cannot access the file 'C:\....\file.jpg' because it is being used by another process."

Now I suspect that that HttpPostedFileBase method SaveAs() has locked that file and not released it. But I am not 100% sure. My only other suspision is that the actual page view method goes and does a:

DirectoryInfo info = new DirectoryInfo(imagesPath.ToString());
FileInfo[] files = info.GetFiles();

In order to retrieve all the files located in that directory. One of the two of these is locking that file. I am more inclined to believe its the SaveAs() method as the remove works intermittently and if it were the page view I'd expect it not to work ever.

Does anyone know anything about this, I have been googling away like mad trying to find out how to get HttpPostedFileBase to release the file its just saved with no avail.

Cheers.

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