C# Discussion Boards - CodeProject

Re: Cannot connect into SQL Server using C#

Eddy Vluggen23-Apr-09 6:49

23-Apr-09 6:49

.sdf files are SQL CE databases, not SQL Server. You have created an "embedded" database. The database that you wanted (SQL Server) has the file-extension ".mdf".

What did you use to create the database?

I are troll Smile | :)

Re: Cannot connect into SQL Server using C#

Gindi Bar Yahav23-Apr-09 6:58

Gindi Bar Yahav

23-Apr-09 6:58

thanks for the replay, umm i didnt know that this is not a SQL Server... i open new Console APP (to check this, acualy i am building a program to my website in WIN but now i need to learn it first.. i done it before with MYSQL but...)
so~, i clicked on Add new item (in the sulution explorer) and them local database connection.
umm... and them i saw the database in the database explorer and i could edit tables, add tables etc...

if its not mysql, can you explin me where i can find the way to connect to that type of sql server?

Gindi Bar Yahav - Web & Software defeloper.

Re: Cannot connect into SQL Server using C#

Eddy Vluggen23-Apr-09 7:18

Eddy Vluggen

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.

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