Re: Server Clustering - MS SQL server - C# Discussion Boards

Pocket PC programming in C#

14-Aug-03 10:05

lvOfficeNote.Items[0].Selected = true

is how you would do it

I'm not an expert yet, but I play one at work. Yeah and here too.

Strat61314-Aug-03 6:42

Strat613

14-Aug-03 6:42

I recently wrote a pocket PC version of the game Simon. so far it is coming along nicely, but i still havent incorporated sound into the game! it would be nice to have 4 distinct tones that will play when each of the four colored buttons lights up. i am not sure how to do messagebeeps or any other sounds in C#. also, i dont even know if they will port to the pocket PC properly... any thoughts?!

-613 "Code Poet"

"Real programmers don't work from 9 to 5. If any real programmers are around at 9am it's because they were up all night."

Re: Pocket PC programming in C#

Ista16-Aug-03 16:24

Re: Pocket PC programming in C#

16-Aug-03 16:24

Strat613 wrote:
"Real programmers don't work from 9 to 5. If any real programmers are around at 9am it's because they were up all night."

Uhh yeah unless they have a family then they get 2 hours sleep

I'm not an expert yet, but I play one at work. Yeah and here too.

Burt Harris16-Aug-03 16:40

Burt Harris

16-Aug-03 16:40

I think you'll have to use P-invoke for sounds. The following code should get you started. I think it will port to PocketPC, but it may take a little work:

using System;
using System.Runtime.InteropServices;

namespace ConsoleApplication1
{
    class Class1
    {
        [ DllImport( "WinMM.dll" ) ]
        private extern static void PlaySound( 
            string soundName,
            int     hModule,
            int     dwFlags );

        private const int SND_FILENAME = 0x20000; /* name is file name */

        [STAThread]
        static void Main(string[] args)
        {
            PlaySound( "C:\\Windows\\Media\\ChatKick.wav", 0, SND_FILENAME );
        }
    }
}

Burt Harris

Re: Pocket PC programming in C#

Strat61318-Aug-03 8:44

Strat613

18-Aug-03 8:44

Thanks! i will definitely play around with that and see what i can do... unfortunately it may be awhile now, "real actual work" just became top priority again :oP

i will post it if i make progess!

thanks again,

Rob

-613

"Real programmers don't work from 9 to 5. If any real programmers are around at 9am it's because they were up all night."

Server Clustering - MS SQL server

devvvy14-Aug-03 5:33

14-Aug-03 5:33

Hi, can anyone tell me anything about clustering? I will need to implement:
1. MS SQL Server clustering (I think I need to configure "virtual node"? I have no idea how to do the implementation. I heard it's also tricky to get server certificate installed in cluster scenario.
2. C#/ASP.NET --> COM+ (Okay, I think I can do COM+ distributed transaction, but not sure how to configure load balancing)

I need some "step-by-step" articles that actually get to the point fast. Any recommendation? Thanks!

norm

Ista14-Aug-03 6:45

14-Aug-03 6:45

first of all clustering is an admin thing go to an sql werver site. Unless you are referring to something different "Sql Server Clustering" can be founf in SQL Books Online at the msdn site msdn But I think your talking about something different.

load balancing is done with a load balancing server, you would also want to monitor loads by openeing up performance monitor, com+ mmc and watch the loads, .net has some tools inside the tools menu from the start menu.

If I were you I would go buy a book

Goes over the inner workings of com+ from a c perspective and ends with .NET. Is very useful and explains a lot about load balancing

I'm not an expert yet, but I play one at work. Yeah and here too.

devvvy15-Aug-03 20:07

15-Aug-03 20:07

sounds like you need to read a book just to do clustering and load balancing.

no, don;t think there's much information in regards to SQL server BOL.

norm

Ista16-Aug-03 3:14

16-Aug-03 3:14

http://www.dell.com/downloads/us/pedge/SQLClustering_Final.doc
http://www.nordu.org/NordU2001/tutorials/monday.html
http://www.webfluent.com/SQLlinks.htm

heres some links for you to try

But I know Books on line has about 15 or 20 pages because I had to set it up last year. Its not easy to find though. Anyways I included several links for you. The last one has links. I would try microsoft newsgroups and sql server. They can help you more since DBA's are on there

But for load balancing if your programming it I would buy a book. Serioously because thats a whole topic in itself and has so many factors that if you just read a few aricles you'll do a poor job on the application.

nick

I'm not an expert yet, but I play one at work. Yeah and here too.

devvvy16-Aug-03 3:57

16-Aug-03 3:57

sounds like a lot of work, but thanks, will see how i can manage to read all that.

norm

Ista16-Aug-03 16:25

16-Aug-03 16:25

its the life of an expert, sorry. And yes that implies if you must do everything then the equation equals no life

I'm not an expert yet, but I play one at work. Yeah and here too.

devvvy16-Aug-03 16:52

DataGrid & Large Integers

16-Aug-03 16:52

yes, one need to scarfice a lot to earn the know-how. sweet and sour

norm

Member 7681714-Aug-03 4:11

Member 76817

14-Aug-03 4:11

Hey everyone,

Here's the prob: I am importing a set of data from a CSV file using the Microsoft Text Reader into a dataset, and later into a datagrid for previewing the data, the problem is that there is a column that contains very large numbers, 16 digits long. When I view the data in the datagrid, or when I export it back into CSV, the numbers get mangled into, say 6.00034+E. Since I don't perform any mathematical calculations on these numbers, I could just change the data type to text in the dataset but apparently that is not possible? So I found the BoundColumn.DataFormatString in the System.Web.UI.WebControls namespace but my program is a windows app. Any pointers would be extremely appreciated.

Thanks!

-Abraham

Re: DataGrid & Large Integers

Ista14-Aug-03 6:47

Re: DataGrid & Large Integers

14-Aug-03 6:47

why not do the transformation in the stored procedures. That would be simple

SELECT MyNumber = STR(Column1)

I'm not an expert yet, but I play one at work. Yeah and here too.

Member 7681714-Aug-03 7:59

Member 76817

14-Aug-03 7:59

Thanks for your reply, Ista.

I tried that, but let's say I bring in the number 6000645657564980, and it gets garbled as 600064+E in the datagrid if I then convert it back to string,
whether in SQL or C#, it gives me back 6000640000000000. Any suggestions?

Re: DataGrid & Large Integers

Ista14-Aug-03 8:36

Re: Null reference problem

14-Aug-03 8:36

specify the column as a DataGridTextBoxColumn()

I'm not an expert yet, but I play one at work. Yeah and here too.

Null reference problem

vaslui14-Aug-03 3:56

vaslui

14-Aug-03 3:56

Did you have the same problem as I do now ? I call a member function of an object that must return an object, the member function works well it creates the object to be returned and even it returns the object but the caller does not receive anything. The strange part is that at debug time the caller actually receive the object, but when build and run the project everinthing goes wrong and I have the upper problem Cry | :((

pls help me

I'll show you some piece of code and I can show you more if necessary:

private void btnOk_Click(object sender, System.EventArgs e)<br />
{<br />
   if(txtUserName.Text.Equals(String.Empty))<br />
   {<br />
     MessageBox.Show("pls insert the username !!!");<br />
     return;<br />
   }<br />
   if(txtPassword.Text.Equals(String.Empty))<br />
   {<br />
     MessageBox.Show("pls insert a password !!!");<br />
     return;<br />
   }<br />
<br />
   if (componenta != null)<br />
   {<br />
     medic = componenta.MedicLogin(txtUserName.Text,txtPassword.Text);<br />
     if(medic != null)<br />
     {<br />
       lblData.Text = medic.FirstName;		<br />
     }<br />
     else<br />
     {<br />
       MessageBox.Show("medic null");<br />
       return;<br />
     }<br />
   }<br />
   else<br />
   {<br />
     MessageBox.Show("componeta nula");<br />
   }<br />
}

I must say also that in a console application the previous problem does not apear.

Frank Olorin Rizzi14-Aug-03 6:15

Frank Olorin Rizzi

14-Aug-03 6:15

I'm not sure if this is the routine that calls (and receives -in some cases- the null reference back) or if it is the one that is called (and sends back the null reference in some cases).

In either case, which line is the one where you find the null reference?

Since you mention that this problem doesn't appear in a console application...
...what is different in the trouble case vs the non-trouble one?
[I see a btnOK_Click name there, which seems to hint that this is part of a Win App project, with GUI and buttons and all that... maybe the case of a console application is much more simple, and the difference might be in some included library...]

F.O.R.

write XML CDATA

devvvy13-Aug-03 22:34

adding color to a form's title

13-Aug-03 22:34

Guys, can you do something like this?

CCustomObj obj = new CCustomObj();

XmlTextWriter wr = new XmlTextWriter("outputXml.xml", null);
wr.Formatting = Formatting.Indented;

wr.WriteStartDocument();

wr.WriteStartElement("GraphicCollection");
wr.WriteAttributeString("objID", "12345");
wr.WriteCData(obj); //Can you write the binary memory map/layout of the object with C#? And restore it later on? I know WriteCData(String) does not accept "byte". Any alternative?

wr.WriteEndElement();
wr.WriteEndDocument();

wr.Flush();

wr.Close();

Thanks

norm

Member 50926213-Aug-03 22:03

Member 509262

13-Aug-03 22:03

if i have a form and it has a title of 'Test Application' and i want to change it to 'Test Application - UNREGISTERED' and have the UNREGISTERED in red, is this possible?

thanks,
Rob Tomson

--
There are 10 kinds of people. Those who understand binary and those who don't.

interesting find but why?

Member 50926213-Aug-03 21:01

Member 509262

13-Aug-03 21:01

i have a background image on my form and i wanted to put a transparent label on it. however, i noticed that a label cannot have it's backcolor changed to 'transparent'. so i created a groupbox and placed a label in it. i then changed to backcolor of the groupbox to 'transparent' and the label's backcolor is now transparent! what the heck? is this a 'feature' of the groupbox or is there some other way of making a label transparent that i don't know about?

Rob

--
There are 10 kinds of people. Those who understand binary and those who don't.

Re: interesting find but why?

Member 50926213-Aug-03 21:21

Member 509262

13-Aug-03 21:21

*UPDATE*

i believe i've come across a bug. try these steps:
create a groupbox on a form and set the backcolor to 'transparent'.....works great

now change the backcolor back to 'control', change the flatstyle to 'system', then try to set the backcolor to 'transparent'.....error 'Invalid property value.' okay, so it won't let you have a transparent background while the flatstyle is set to system.

so change the flatstyle back to 'normal' and change the backcolor to 'transparent'. then change the flatstyle to 'system'.....works!? but it's really buggy, the display in the groupbox fails to update and when the program is run the background of the groupbox is weirded out.

i'm NOT using csharp 2003 so i don't know if they've fixed this in the new version or not. did they? why can the backcolor not be transparent if the flatstyle is set to 'system'?

Rob Tomson

--
There are 10 kinds of people. Those who understand binary and those who don't.

Re: interesting find but why?

James T. Johnson14-Aug-03 7:48

James T. Johnson

14-Aug-03 7:48

Rob Tomson wrote:
why can the backcolor not be transparent if the flatstyle is set to 'system'?

When you set the FlatStyle property to System you are telling the Framework to always let the OS do the drawing for that control. To my knowledge either none or not all of the .NET enabled OSes support the Transparent style which would require the Framework to emulate your choice but that goes against telling the framework to let the OS draw the control.

James

"My words but a whisper -- your deafness a SHOUT.
I may make you feel but I can't make you think." - Thick as a Brick, Jethro Tull 1972

Re: interesting find but why?

Ista16-Aug-03 16:27