Visual C# General Forum

Read XML to DataSet

Wed, 25 Nov 2009 22:04:16 Z

Hi I have a little problem.

I have a XML file which holds information for about of 100 students with little info(Name, Year). I need to read that XML file and to draw a table which will show how many students is there on each year. How can I do that?

Thank you for any help :)

Test string for \n or \t

Wed, 25 Nov 2009 20:25:32 Z

Hello I am wondering how I can test if there is a \n or a \t in a string.

string tmpString = "asdf \n asdf";

Thanks for your time.

call javascript function from C# code-behind

Wed, 25 Nov 2009 12:25:15 Z

Hi all,

in my C# code behind, page_load , I wrote the following code:

String jScript;
jScript="<script language='javascript'> function changeBgColor()" +
" { var td = document.getElementById('" + td + "'); \n";
jScript+="if (!td) throw 'td not found'; \n ";
jScript += "td.Class='calendaritemtd-Weekend'; \n";
jScript+=" } </script>";

Page.ClientScript.RegisterStartupScript(this.GetType(), "changeColor", jScript);

I also tried
   Page.RegisterStartupScript("changeColor", jScript)
   Page.RegisterClientScriptBlock("changeColor", jScript)

but none of these works.
I even tried to test the jScript string content via LabelTest.Text = jScript, but could not retrieve anything from LabelTest.Text.

could anybody help?

another question: if I want to insert Javascript in html file, but I am currently using site.Master, should I write code in site.Master, between <head> and </head>?

Thank you,

Ling

Running into another problem with FileSystemWatcher.cs?

Tue, 24 Nov 2009 21:58:32 Z

Was using this library class for my last application (and it worked) but recently been testing my last application and found out a new problem.. :(

It detects auto-created files by processes.
Is there a way to stop or another way round to prevent it from detecting auto-created files by processes?

I keep getting events firing for files created/renamed etc.. within the applicationData folders.

Some are .lnk/.tmp files. Others are images files from third party software which it doesnt use the standard AppData folder - uses its own folders which its a huge problem because if not - i can easily check whether the file resides in appData. I couldnt possibly have a list of all programs appData folders..

help.. lol

Check for Open Application

Wed, 25 Nov 2009 18:36:39 Z

Hello,

I'm working on a project that needs to verify if a win32 application is opened. If it is not opened then I will use Process.Start(appplication path) to open it.

Does anyone know what class to use to verify if an application is open or not ?

Datagridview and TabControl

Wed, 25 Nov 2009 19:11:38 Z

Hi, On my windows form, I have a tabcontrol with 5 tabs and 4 tabs has a datagridview. I have a menu strip which has a new menu. When the user click on the new menu, some text boxes in the first tab will be filled out with some data and the user will finish inputing data in other textboxes. When I execute the program, all the datagridview shows fine with the correct data. But when i click the new button, it shows the first tab with some textboxes filled out(as programmed) and my last datagridview filled out with another table data >> I don't know why here is the code snippet:

private void Form1_Load(object sender, EventArgs e)
        {
            DGVOpen.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.AllCellsExceptHeader);
            GetData("Select Ticket_Num,Request_By,Assigned_To,Problem,Solution,Date_Open, Checkbox from Main where Status = 'Open' Order By Ticket_Num");
            DGVOpen.DataSource = BS1;
            DGVClosed.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.AllCellsExceptHeader);
            BS1 = new BindingSource();
            GetData("Select Ticket_Num,Request_By,Assigned_To,Problem,Solution,Date_Closed, Checkbox from Main where Status = 'Closed' Order By Ticket_Num");
            DGVClosed.DataSource = BS1;
            DGVUser.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.AllCellsExceptHeader);
            BS1 = new BindingSource();
            GetData("Select * from Users");
            DGVUser.DataSource = BS1;
            DGVVendor.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.AllCellsExceptHeader);
            BS1 = new BindingSource();
            GetData("Select * from Vendor");
            DGVVendor.DataSource = BS1;
        }
        private void GetData(string SelectCommand)
        {
            try
            {
                oconn = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=F:\HelpDesk.mdb");
                DA = new OleDbDataAdapter(SelectCommand, oconn);
                OleDbCommandBuilder Ocommand = new OleDbCommandBuilder(DA);
                DT = new DataTable();
                DS = new DataSet();
                DT.Locale = System.Globalization.CultureInfo.InvariantCulture;
                DA.Fill(DT);
                DA.Fill(DS);
                BS1.DataSource = DT;
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }

        }

private void newTicketToolStripMenuItem_Click(object sender, EventArgs e)
        {
            if (tabControl1.SelectedTab != tbTicket)
            {
                this.tabControl1.SelectedTab = tbTicket;
                tbTicket.Show();
            }
            DisplayBlank();
            displayvendorcombobox();
            GetData("Select * from Main");
            int i = DT.Rows.Count;
            int month = DateTime.Now.Month;
            int year = DateTime.Now.Year;
            TxtTicket.Text = "AIB" + month + year + "-" + i;
            TxtStatus.Text = "Open";
        }

Enumerating USB device with multiple logical units

Wed, 25 Nov 2009 21:51:16 Z

Hi,

I have a USB device that has 2 logical units.
USBSTOR\DISK&VEN_XXXX&PROD_YYYY&REV_0100\0123456789990&0 (Drive A:)

USBSTOR\DISK&VEN_XXXX&PROD_YYYY&REV_0100\0123456789990&1 (Drive B:)

I used SetupDiEnumDeviceInterfaces() func and I get just one:USBSTOR\DISK&VEN_XXXX&PROD_YYYY&REV_0100\0123456789990

I guess this is understandable since there is only one physical device. However, is there a function that I can use to get both the drive letters?

I used the DEVINTERFACE_VOLUME GUID for the SetupDiEnumDeviceInterfaces() function.

System.Configuration.Install does not exist, why?

Wed, 25 Nov 2009 19:52:47 Z

Hi,
I am trying to install a Windows Service and I have followed the guide on http://msdn.microsoft.com/en-us/library/system.serviceprocess.serviceinstaller.aspx .
But my compiler cannot find the class System.Configuration.Install.
The only class under System.Configuration is "Assemblies". Where is the "Install" class?

Challenging RichTextBox Sizing problem.

Wed, 25 Nov 2009 20:45:03 Z

I have a challenging RIchTextBox Sizing problem.

The problem is as follows:

You are given a string of arbitrary length.

The RichTextBox must size it's width so that the string is not broken into another line (no scroll bars on the richtextbox).
(example: By nature of the RTB itself if a string is of width = 600 but the RTB is only width = 100 then scroll bars will appear and the string will be broken in several lines).

If the string is longer than some MaxWidth (Lets make MaxWidth = 800), then the string must be broken into two lines at length 800 and then the richtextbox must increase it's height so that it can show the string without the scroll bars.

(example: if string is of length 1000 and the hieght of the string is 13 then the string will be broken up: one line will be 800 width and another line will be 400 width the total hieght of the new RTB is now 13*2 = 26.

To further complicate things (and this is what makes the problem difficult) this string can have an arbitrary amount of \t or \n tags in it.

To summarize these conditions:

The RTB can make NO predictions on the contents of the string it's going to accept to it's .text property (must allow for all legal strings).

The RTB must have no scroll bars.
The RTB must never be more wide than MaxWidth (800);
The RTB must not be un-neccessarily tall. (there should not be blank RTB space under the last line).

To get started I have this code:

RichTextBox messageLabel = new RichTextBox();
string str = messageForm.MessageLabel.Text;

Size strSize = TextRenderer.MeasureText(str, messageForm.MessageLabel.Font);
            
messageLabel.Width = strSize.Width

messageLabel.SelectionAlignment = HorizontalAlignment.Center;
            
int numberOfTextLines;

// if string has no \n or \t
if (messageForm.MessageLabel.Width > BusinessRule.MaxWidth)
{
        // if string is too long break up into lines of MAX width
        messageForm.MessageLabel.Width = BusinessRule.MaxWidth;
                
        numberOfTextLines = messageForm.MessageLabel.GetLineFromCharIndex(messageForm.MessageLabel.Text.Length) + 1;
                
         messageForm.MessageLabel.Height = numberOfTextLines * strSize.Height;
}
else
{
         numberOfTextLines = messageForm.MessageLabel.Lines.Length;
          messageForm.MessageLabel.Height = strSize.Height;
}
            messageForm.MessageLabel.BackColor = Color.Red;
           
if (numberOfTextLines > 1)
{
       messageForm.MessageLabel.SelectionAlignment = HorizontalAlignment.Left;
}

This code actually works for all instances except for when I pass it the string:

"contactClass: Postal Code is invalid.\n But the invalid is not valid. \n\n Nor Should it ever be that way, yes?"

Problem with local variable (collection)

Wed, 25 Nov 2009 19:55:07 Z

For my test application I am doing now a collection of books, and I already did a filter.

But when I want to do a collection, and use the variable, the is no variable. You can see from the drop down manu that there is no "filter" name, as I named the collection. Why is that so?

Problem with .xsd file - refresh

Wed, 25 Nov 2009 20:02:59 Z

hi
i build C# program that connect to access database.
i have .xsd file that connect to database - and through this .xsd i connect to crystal-report.
this all work excellent.
now, i added 2 query in the database - and the problen that i can't see them in the .xsd file

whay ?

Does Application.Exit() Affect Form_Closing() Events

Tue, 24 Nov 2009 18:05:54 Z

When the user chooses to close the application I call Application.Exit(). Within my Form_Closing code I then have the following statement to update my db with the values that have changed in the DataGridView that I present to the user. For some reason though, unless I have at least one row selected, these changes will not be updated. Why is this?

questions about purpose/functionality ManualResetEvents in my socket code.

Wed, 25 Nov 2009 15:31:23 Z

Evaluating JUST the ManualResetEvents, as I am only beginning to understand them:
1. ConnectDone.Reset()   - the doors are closed, (non-signaled) but what does that mean? Which door is closed? Some connect thread?
2. ConnectDone.WaitOne() - the connect process commences.
3. ConnectDone.Set()         - the door is open now. Does that mean THE thread used for the connect process is available again. Was this a thread taken from some threadpool temporarily?
4 sendDone.Set()        -   the door is open.

What I see in my code is I have no sendDone.Reset() nor do I have sendDone.WaitOne()
Also, I have absolutely no ManualResetEvent variables/flags/signals in my code anywhere for Receive() and ReceiveCallBack();
As you can see, I don't know what I'm doing (but I do want to learn !!) Thank you for any help. greg

        private static ManualResetEvent connectDone = new ManualResetEvent(false); //??

        private static ManualResetEvent receiveDone = new ManualResetEvent(false); //??

        private static ManualResetEvent sendDone = new ManualResetEvent(false);    //??



        public static void BeginConnect(string host, int port)

        {

            connectDone.Reset();

            connectDone.WaitOne();

        }

        

        public static void ConnectCallback(IAsyncResult ar)

        {

            connectDone.Set();

        }



        private static void SendCallback(IAsyncResult ar)

        {

            sendDone.Set();

        }



        private static void ReceiveCallback(IAsyncResult ar)

        {
}

How do I Late Bind Reference DLL

Fri, 10 Jul 2009 15:23:54 Z

I am Referencing the Microsoft.Office.Interop.Outlook dll, but I only use it in certain situations. If they do not have Outlook, it is not a problem for my program (because I will not use Outlook to do anything), but the app will not run because this dll is not installed. I can't install the Office PIA because Office is not installed. So how do I use the Outlook Interop in a "late binding" type of scheme where I would only call it if I knew Outlook was installed?

Dir list box...

Wed, 25 Nov 2009 18:04:43 Z

Hello every body, i have a dir list box in my form and i give it as path a network path, when i run the form it lists me the contents of the path correctly. i want to know if i can hide from dir list box the base path or if i can rename it, i don't want to see \\server\share i want to see the work "base path" for example !

Creating a Shortcut using WshShellClass in C#

Wed, 25 Nov 2009 18:41:06 Z

Hopefully this is a very simple solution..

I am trying to create a function that generates a shortcut to the desktop, and it works.. However.. the path I am trying to use causes the shortcut creator to throw an exception..

			WshShellClass wshShell = new WshShellClass();
			IWshRuntimeLibrary.IWshShortcut shortcut;
			shortcut = (IWshRuntimeLibrary.IWshShortcut)wshShell.CreateShortcut(@Environment.GetEnvironmentVariable("USERPROFILE") + "\\Desktop\\QPS_Punch_Clock.lnk");
			shortcut.TargetPath = "C:\\Program Files\\Internet Explorer\\iexplore.exe -k "+Properties.Settings.Default.URL;
			shortcut.Save();

The error I am getting is very generic: Value does not fall within the expected range.

The TargetPath is the culprit, I am unsure how to proceed. I am trying to generate shortcuts that open IE and Kiosk mode.. with whatever URL was specified. If I remove the Properties.Settings.Default.URL concatenation from the Target Path.. the shortcut is created but is a broken link.. because it is set to

"C:\Program Files\Internet Explorer\iexplore.exe -k "

I can also make a working shortcut using only the URL Property, but it obviously is not opening in kiosk mode..

Does anyone have any ideas?

Thanks!

Is C# and WPF a good choice?

Sun, 22 Nov 2009 10:56:27 Z

Dear forum members,

I'm working on an accounting software, which I was planing to do using C#. Now that I see there is WPF that I can use instead of WinForms, I would like to ask you a couple of questions.

For an account software, which I would like to have it looking good, with dynamic graphs and "easy on eyes" with light animations (like apps on iphone, transitions etc), is C# .NET WPF a good choice? What would be your recommendations?
And how can I skin the window completely? Like, iTunes working on a Windows machine. The window and the title bar is custom, but buttons for quitting the application or minimizing it still the Windows one. How can I do this with VS and C# with WPF?
Once the project is complete, can I deploy it to work on a web browser? Is it possible? Because I read some stuff like this.
what is it that I can do with C# and WPF that can't be done with Silverlight?

Also, dear members, do you have any favorite resource which teaches animation and design side of WPF?

Thank you very much.

drawing cross hair +C#

Tue, 24 Nov 2009 04:10:58 Z

i'm trying to draw crosshairs that follow the mouse around the screen. The following code works. but not quite, it draws a new crosshair for every mouse move, but doesn't remove the old one, so i end up with a screen full of vertical and horizontal lines.

how do i remove the last lines drawn on every mouse move?

public void MyMouseMove( Object sender, MouseEventArgs e )
{

Pen blackPen = new Pen(Color.FromArgb(128,0,0,255), 1); // Pen blackPen = new Pen(Color.FromArgb(0,0,0,255), 1);
Graphics g = SelectionRectangle.ActiveForm.CreateGraphics();
// Create coordinates of points that define line.
float formLeft = this.Left;
float formTop = this.Top ;
float formRight = this.Right ;
float formBottom = this.Bottom ;
mouseX = e.X ;
mouseY = e.Y ;
// Draw line to screen.
g.DrawLine(blackPen,0,mouseY,mouseX,mouseY );
g.DrawLine(blackPen, mouseX, 0, mouseX,mouseY);
g.DrawLine(blackPen, formRight, mouseY, mouseX, mouseY);
g.DrawLine(blackPen, mouseX, formBottom,mouseX, mouseY);

algates

C# Syntax Coloring

Tue, 24 Nov 2009 18:43:00 Z

Ok, I've been working on a working syntax coloring code that works with a richTextBox, but I can't get it quite right. The code I have is just slightly buggy, and I cant figure out how to fix it for the life of me.

I figured since the people are are experts that I could get some help. Here is the code I am using.

//This part goes right after Form1_Load
[DllImport("user32.dll")]
public static extern bool LockWindowUpdate(IntPtr hWndLock);
public Regex keyWords1 = new Regex("int|double|float|string|bool|true|false|define");
public Regex keyWords2 = new Regex("if|then|else|elseif|function|end|begin");

//This part goes into "richTextBox1_TextChanged"
int selected = richTextBox1.SelectionStart;
            try {
                LockWindowUpdate(richTextBox1.Handle);
            foreach (Match keyWordMatch in keyWords1.Matches(richTextBox1.Text.ToLower()))
            {                
                richTextBox1.Select(keyWordMatch.Index, keyWordMatch.Length);
                richTextBox1.SelectionColor = Color.Blue;
                richTextBox1.SelectionStart = selected;
                richTextBox1.SelectionColor = Color.Black;
            }
            foreach (Match keyWordMatch in keyWords2.Matches(richTextBox1.Text.ToLower()))
            {
                richTextBox1.Select(keyWordMatch.Index, keyWordMatch.Length);
                richTextBox1.SelectionColor = Color.Orange;
                richTextBox1.SelectionStart = selected;
                richTextBox1.SelectionColor = Color.Black;
            }
}
            finally { LockWindowUpdate(IntPtr.Zero); }
            richTextBox1.Select(selected, 0);
            richTextBox1.SelectionStart = selected;

Thank you for any help.

Stored procedures and dependence

Wed, 25 Nov 2009 14:33:51 Z

I am doing pretty well with 3-tier architecture, but there is one thing that I can not figurated it out. How to write a procedure, what will depend on a selected item (in my case in a listBox).

I can not write directly like WHERE Author.Name = '" + listBox1.SelectedItem + "' - like I was doing that before.

Now it`s needed a bit different approach, becuase I am not doing directls with the database.

In Data Access Layer I call a stored procedure which looks like:

ALTER PROCEDURE GetBooksSelectedAuthor
@name varchar = null
AS 
if @name is not null
BEGIN
SELECT Books.Title FROM Books, Authors
WHERE Authors.IDAuthor = Books.IDAuthorFK 
AND Author.Name = @name
END

How can I define that @name is bound to selected Item in listBox1?

Extreme refreshes from ProgressChanged event is making Readout labels unreadable.

Sat, 21 Nov 2009 00:01:16 Z

I've got a backgroundworker thread running a comparison between two tables in a database. As each record of each table is compared I fire off a worker.ReportProgress containing a custom object with my return values. The problem I'm having is that the actual comparison is so fast that it causes the UI thread to refresh so much that the label text never has a chance to finish it's redaw, subsequently causing them to all become unreadable.

my progresschanged event:

<br/>
		private
 void
 bgwExecuteCompare_ProgressChanged(object
 sender, ProgressChangedEventArgs e)<br/>
		{<br/>
			pbProgress.Value = e.ProgressPercentage;<br/>
			CompTracker tmpTracker = (CompTracker)e.UserState;<br/>
			<br/>
			lblReportDB.Text = tmpTracker.CurDB;<br/>
			lblReportTBL1.Text = tmpTracker.TBL1;<br/>
			lblReportTBL2.Text = tmpTracker.TBL2;<br/>
			lblReportRecCount1.Text = Convert.ToString(tmpTracker.TotalTBL1Records);<br/>
			lblReportRecCount2.Text = Convert.ToString(tmpTracker.TotalTBL2Records);<br/>
			lblReportCurrentRec.Text = Convert.ToString(tmpTracker.CurRec) + " of "
 + <br/>
									   Convert.ToString(tmpTracker.TotalTBL1Records + tmpTracker.TotalTBL2Records);<br/>
		}<br/>

During runtime, all i see is the UI thread constantly refreshing to the point of uselessness. Have tried using the suspend/resume layout tricks to no avail. There's no DataSource property for labels as there are for textboxes. Was wondering if anyone had any idea's as to how to stop the continual refreshes, or of a way to simply update the label text without triggering the redraw (which is i think what is causing all the refreshes). The progress bar seems to update correctly, it flashes with varying degree's of 'filledness' during the process, but since it's so fast (on my test data) it's hard to tell if it's actually counting right. I've also tried using the CLR debugger but being as this is multithreaded when i put breakpoints in, it freezes the UI thread as well, so I can't see the updates as they come through. I do however see all the correct inputs coming through from the UserState pass, so I know the info is getting through it just seems like it doesn't have enough time to redraw the control before the next update is sent and it's forced to redraw again.

How to launch a MSAccess1007 distrbutable .accdr file.

Sat, 21 Nov 2009 03:46:53 Z

I am trying to launch a MSAccess1007 distrbutable .accdr file. in a C# form VS2008 with the code below.
But get a message: "Could not load file or assembly. The assembly was expected to contain an assembly manifest."
What is the right way to launch a .accdr file from a C# windows form application?

System.

AppDomain newDomain = System.AppDomain.CreateDomain("NewApplicationDomain");

// Load and execute an assembly:

newDomain.ExecuteAssembly(

"C:\\Program Files\\CALLMaster\\Data\\CMODLoadPhone.accdr");

// Unload the application domain:

System.

AppDomain.Unload(newDomain);

Thanks
Morris

NullReferenceException on SqlDataAdapter.Fill(DataSet)

Wed, 25 Nov 2009 16:19:33 Z

Hi!

I'm keep getting a NullReferenceException at line: DA.Fill(DS).

I tried with SqlCommand.ExecuteReader() but it fails too.

My select is a really simple one: "SELECT * FROM TestTable" which gives at least 10 result in an sql query. So the select is OK.

SqlConnection is OK too, because I can Open() it.

Facts:

-------

This code is working fine on Windows Mobile 6.0 (device), but fails on Windows CE 5.0 (device)!

I'm pretty sure, that I'm using correct version of SqlClient.dll.

There was a problem in the database. The default collation was unsupported (so it thrown PlatformNotSupportedException), but I changed it to Latin1_General_CI_AI.

I'm not using separate threads in my application.

I'm developing the application in VS 2008, C#, .NET CF 3.5 with MSSQL database.

Begin code

...

Connect(); // Open the connection

DataSet DS = new DataSet();

SqlDataAdapter DA = new SqlDataAdapter(Command, SQLConnection);

DA.Fill(DS); // ERROR

return DS.Tables;

...

End code

So my question is:

---------------------

What am I doing wrong?

Thanks in advice!

--------------------

Attila Adorjan

SelectionChanged event - triggered before action completes

Wed, 25 Nov 2009 17:06:49 Z

I don't know if I am using the wrong event. I want to know when my user selects a row in my griddataview. So, I am using the selectionchanged event. Seems logical. However, the event is also triggered when the grid is created and when the grid is cleared. That would be fine, but the problem is....

When I call the clear method of the griddataview, it triggers the selectionchanged event before the grid is cleared.
So my check:

if (gridBudgetSummaries.RowCount == 0)
{
   return;
}

returns false. Windows tells me there are rows when I just called clear. Obviosuly this causes exceptions when I try to use the corresponding data.
This seems rather buggy to me. Woudln't be the first time I cried out "It's MS's fault" and have been wrong though. Perhaps someone could explain this to me. How can I avoid this situation without doing something hacky like implementing a "I am clearing right now" flag.

Am I using the wrong event?

small problem in Using System.Diagnostics.Process.Start to execute MySql.exe

Tue, 24 Nov 2009 04:51:43 Z

Hi i have been creating windows forms application to create a dump of remote mysql database and than using the same dump to restore my local database.

I was successfully able to create a dump of remote mysql database using following method. I the code below i show both the mysql command and the C# process.start command to do the same thing. This was successful

Command in mysql command prompt:
D:\Program Files\wamp\bin\mysql\mysql5.0.51b\bin>mysqldump --opt -h 65.13.19.54 -u root -proot --skip-lock-tables --databases posapplication>test.sql

Method statement in Process.Start:
Process compiler = new Process();
compiler.StartInfo.FileName = @"D:\Program Files\wamp\bin\mysql\mysql5.0.51b\bin\mysqldump.exe";
compiler.StartInfo.Arguments = "--opt -h 65.13.19.54 -u root -proot --skip-lock-tables --databases posapplication -r test.sql";
compiler.StartInfo.UseShellExecute = false;
compiler.StartInfo.RedirectStandardOutput = true;
compiler.StartInfo.CreateNoWindow = true;
compiler.Start();
Console.WriteLine(compiler.StandardOutput.ReadToEnd());
compiler.WaitForExit();
MessageBox.Show("Backup created successfully.");

Note: guys above code work absolutely fine

The problem is here: When i try to restore my local database from the dump file generated by above code. It just doesn't happen. Now this time instead of usgin mysqldump.exe i used mysql.exe which needs to be invoked to restore the database. In the code below i show both mysq command and C# Process.Start command. The Mysql command works just fine but my C# code won't do anything.

Mysql Command:
D:\Program Files\wamp\bin\mysql\mysql5.0.51b\bin>mysql -h localhost -u root -proot posapplication < test.sql

Method statement in Process.Start:
Process compiler = new Process();
compiler.StartInfo.FileName = @"D:\Program Files\wamp\bin\mysql\mysql5.0.51b\bin\mysql.exe";
compiler.StartInfo.Arguments = @"-r -h localhost -u root -proot posapplication < D:\Program Files\wamp\bin\mysql\mysql5.0.51b\bin\test.sql ";
compiler.StartInfo.UseShellExecute = false;
compiler.StartInfo.RedirectStandardInput = true;
compiler.StartInfo.RedirectStandardOutput = true;
compiler.StartInfo.CreateNoWindow = true;
compiler.Start();
compiler.StandardInput.Write("root");
Console.WriteLine(compiler.StandardOutput.ReadToEnd());
compiler.WaitForExit();
MessageBox.Show("Database restored successfully.");

Now i see that the code to generate the dump actually works fine but using the same process if i try to restore my local database it just doesn't work. Of course above code in mysql works just fine and ok. But i need to do this on click of button in windows forms. I can also do this by executing the bat file, which i already tried and was successful. But i want to restore the local db by using the way i dumped the remote mysql db as shown above.

In the code to restore the db please note guys, i think i am wrong in passing the dump file to mysql command. see, there is a difference in way the dump file is given in mysqlcommand and in C# method. while passing the file in mysqldump it works fine, but i think during restore the passing of file parameter is wrong. Please guys take a look.

This should be a simple problem for you guys
Please help.

Thanks

C# Inheritance - initialize child with parent

Wed, 25 Nov 2009 01:10:51 Z

Coming from C++ I could use a chid class' copy constructor and pass it a parent class as an argument. I got an error when attempting to do this in C#.
How do I initialize my derived class with a base class object? (assuming I can implement what the derived members would be set to)

Here is what I tried and got my error

class Parent
{
   public int m_data;

   public Parent()
   {
      m_data = 0;
   }

   public Parent(Parent rhs)
   {
      m_data = rhs.m_data
   }
}

class Child : Parent
{
   public int m_other;

   public Child() : base()
   {
      m_other = 0;
   }

   public Child(Child rhs) : base(rhs)
   {
      m_other = rhs.m_other;
   }
}

//....
Parent foo = new Parent();
Child bar = new Child(foo);   // <---Error

Adding properties at runtime to an object

Mon, 23 Nov 2009 15:03:57 Z

I need to add properties to an existing object at runtime. Our project has a MemberInfo object that has some standard properties(such as FirstName, LastName, etc...). Our clients can go in and add Custom Fields in the database, we would like to be able to display a list of the members with the Custom Fields(and their values) in a grid. We bind a list of objects to the grid and each property with a custom attribute will be displayed.

Namespace: Company.Net.Library.Member
Assembly: Company.Net.Library.Member.dll
The stored procedure returns an xml blob like the following:
(normal stuff like FirstName get read in the normal way)
<CustomFields>
<CustomField Name="HairColor">Brown</CustomField>
<CustomField Name="ShoeSize">9</CustomField>
(there could be additional child nodes)
</CustomFields>

In the class I read from the datareader and convert to a dictionary with the key being the property name(example:HairColor or ShoesSize) and the Value being the innertext(example Brown or 9) That part seems to be working ok. But what I need to do is add properties to the existing object.

membersList is a List<MemberInfo>
HasCustomFields is a boolean the will tell if there are custom fields(not all customers have custom fields)
CustomFields is property of type Dictionary<string, string> that contains the above mentioned key, value pair. All the added properties can be strings
ObjectFieldAttribute is a custom attribute we defined(inherits from Attribute), the constructor takes three boolean.

What I have so far:
if (membersList.Count > 0)
{
    if (membersList[0].HasCustomFields)
    {
        #region add property to class

        AppDomain domain = Thread.GetDomain();
        AssemblyName name = new AssemblyName();
        name.Name = "MemberInfo";

        AssemblyBuilder assBuilder = domain.DefineDynamicAssembly(name, AssemblyBuilderAccess.RunAndSave);
        ModuleBuilder modBuilder = assBuilder.DefineDynamicModule(name.Name, name.Name + ".dll");

        // just for testing
        int origCount = typeof(MemberInfo).GetProperties().Length;

        #region add each property one at a time

        foreach (KeyValuePair<string, string> entry in membersList[0].CustomFields)
        {
            try
            {
                TypeBuilder typeBuilder = modBuilder.DefineType(entry.Key, TypeAttributes.Public);
                FieldBuilder fieldBuilder = typeBuilder.DefineField(entry.Key, typeof(string), FieldAttributes.Private);
                PropertyBuilder propBuilder = typeBuilder.DefineProperty(entry.Key, PropertyAttributes.None, typeof(string), null);

                // Create the custom attribute ObjectFieldAttribute
                Type[] ctorParams = new Type[] { typeof(bool), typeof(bool), typeof(bool) };
                ConstructorInfo constructor = typeof(ObjectFieldAttribute).GetConstructor(ctorParams);
                CustomAttributeBuilder custAttBuilder = new CustomAttributeBuilder(constructor, new object[] { true, true, true });

                //fieldBuilder.SetValue(info, entry.Value);
                propBuilder.SetCustomAttribute(custAttBuilder);

                MethodAttributes getSetAttr = MethodAttributes.Public | MethodAttributes.SpecialName | MethodAttributes.HideBySig;

                // create the get method of the property
                MethodBuilder getMethodBuilder = typeBuilder.DefineMethod("get_" + entry.Key, getSetAttr, typeof(string), Type.EmptyTypes);

                ILGenerator getILgen = getMethodBuilder.GetILGenerator();
                getILgen.Emit(OpCodes.Ldarg_0);
                getILgen.Emit(OpCodes.Stfld, fieldBuilder);
                getILgen.Emit(OpCodes.Ret);

                propBuilder.SetGetMethod(getMethodBuilder);

                // create the set method of the property
                MethodBuilder setMethodBuilder = typeBuilder.DefineMethod("set_" + entry.Key, getSetAttr, null, new Type[] { typeof(string) });

                ILGenerator setILgen = setMethodBuilder.GetILGenerator();
                setILgen.Emit(OpCodes.Ldarg_0);
                setILgen.Emit(OpCodes.Ldarg_1);
                setILgen.Emit(OpCodes.Stfld, fieldBuilder);
                setILgen.Emit(OpCodes.Ret);

                propBuilder.SetGetMethod(setMethodBuilder);

                Type generated = typeBuilder.CreateType();

                PropertyInfo[] properties = generated.GetProperties();
            }
            catch (Exception ex)
            {

            }
        }

        // just for testing
        int newCount = typeof(MemberInfo).GetProperties().Length;

        // erroring out for some reason
        //assBuilder.Save(name.Name + ".dll");

        #endregion

        #endregion

        #region Add values to the new properties

        for (int i = 0; i < membersList.Count; i++)
        {
            MemberInfo info = membersList[i];
            if (info.HasCustomFields)
            {
                foreach (KeyValuePair<string, string> entry in info.CustomFields)
                {
                    // populate each new field with data
                }
            }
        }

        #endregion
    }
}

How to take variable from other class by Value?

Tue, 24 Nov 2009 14:33:55 Z

Hi,
I am beginner in this job and i want a little help about this problem.
I want to take variable from other class by value.
I have getters and setters of that variable but from the other class that constructor returns null.

 public
  string
 user;

 public
  string
 userGetSet {get
 {return
 user;}set
{user= value;}}

 private
 void
 txtLogirajSe_Click(object
 sender, EventArgs e) {

 if
 (txtKorisnik.Text != ""
 && txtSifra.Text != ""
) {

 var
 query= from
 x in
 db.TKorisnicis where
 txtSifra.Text == x.sifra && txtKorisnik.Text == x.korisnik select
 x.korisnik;

 string
 localUser= ""
;

 foreach
 (var
 y in
 queryDaliPostoiTojUser) {

 localUser= y;

 }              

            this
.userGetSet = localUser;

 if
 (localUser!= ""
 && localUser!= null
)
                    this
.Close();

 ///
when im typing here messagebox.show(userGetSet);the result is ok 

            }    }



//and when i want to view that value from other form<br/>

  private
 void
 menuStrip1_ItemClicked(object
 sender, ToolStripItemClickedEventArgs e)        {

 Form1 ff = new
 Form1();

 MessageBox.Show(ff.userGetSet);

        }// this returns null

Instantiating an object that implements IUIAutomation interface

Wed, 25 Nov 2009 12:09:09 Z

The following MSDN link shows how to instantiate an object that implements the IUIAutomation interface, in C++

http://msdn.microsoft.com/en-us/library/ee671202(VS.85).aspx

This native COM API can also be used with managed code (as it is quicker than the managed API) but how do I instantiate an object that implements IUIAutomation in managed code?

Any help greatly appreciated for a relative newcomer.

Melanie

I should add that I have added a reference to use standard Com interop and can access the interface but I'm not sure how to instantiate.

Static constructor usage

Wed, 25 Nov 2009 10:29:48 Z

I was reading about static constructor in msdn. it states that

A typical use of static constructors is when the class is using a log file and the constructor is used to write entries to this file.
Static constructors are also useful when creating wrapper classes for unmanaged code, when the constructor can call the LoadLibrary method

Can anyone elaborate above 2 points with suitable examples

I've already installed VSTS 2008 but i need install VS2K3 EA, is this possible?

Sun, 22 Nov 2009 04:42:05 Z

Hi friend,

I've tried find a place to put this thread but couldnt find an up-to-date thread for VS installations....however....

I've already installed VSTS2008 but i need to install VS2K3 Enterprise Architect (i used to have to in my system). The reason i want install is that i want to install visio but only visio that i could find is the one that came with VS2K3 EA, so i have install a minimal files of VS2K3 EA to install visio for EA...

is it possible to install VS2K3 EA while having VSTS2008 in the system?

thanks

Find if Timer exists on the Form

Wed, 25 Nov 2009 12:14:35 Z

hi everyone,

How could I know if the form has a timer defined or not? (not runtime design)

Suppose the timer name is "timer1". I tried this way, but not working:

Control[] seq = Controls.Find("timer1", true);
if (seq.Count() == 0)
MessageBox.Show("not found");
else
MessageBox.Show("found");

Can anyone help me with this? Any ideas will be really appreciated.

Regards,

DataBind between two user controls

Tue, 04 Aug 2009 14:36:15 Z

Is it possible to DataBind a CheckBox's Checked property on one user control to a panel's Enabled property on a different user control (not in WPF). Does anyone have a small example of something like this? Thanks.

tab delimiter in csv (StringBuilder)

Wed, 25 Nov 2009 11:43:02 Z

I've been trying to create a tab delimited csv file from a string builder.

I create a string builder.

I convert it to byte array.
byte[] bytes = System.Text.Encoding.Default.GetBytes(streamBuilder.ToString());

Later on, byte[] bytes is used to create a .csv file.

The problem is that the tabs are not read correctly. Instead of having every delimited value in it's own cell, I get this (in one cell):
Redni broj□Datum valute□Datum obrade

If I change the Encoding to UTF8
byte[] bytes = System.Text.Encoding.UTF8.GetBytes(streamBuilder.ToString());
tabs work correctly but I don't see the language specific letters (defualt encoding is Central European).

Any ideas how to solve this problem?

How to close an application opened by Activator.CreateInstance

Wed, 18 Nov 2009 21:32:04 Z

Hi there,
I am implementing a Womdows Form application which creates an object by calling Activator.CreateInstance. But the apppication referred by the object is not closed when the main application exits. I tried to call ReleaseComObject inside the FormClosingEventHandler but in vain.

My question is: how to programmatically close the application opened by Activator.CreateInstance? Thanks a lot!

C# and JavaScript variables

Wed, 25 Nov 2009 15:44:09 Z

Hello,
I have created a control that is using the Google Map API to display points to a map. It all works but the key to register the Google API can change so I would like to somehow put it in the web.config. It currently is set in the ascx page like this:

<script src="http://maps.google.com/maps?file=api&amp;v=2&amp;sensor=false
                 &amp;key=ABQIAAAAwevTcGKnP0RB8m8l-cwNgRQiwzL55ux5xs4VDD3WrzjBHisBGERXaGLCLd2E0vXsg7cJ2h-Bx52pXw" type="text/javascript">
    </script>

Can anyone show me how to do that, if it is possible.

Thanks

log question?

Tue, 24 Nov 2009 18:29:52 Z

What is difference between these two codes?

if( log.IsDebugEnabled) { log.Debug( "exiting method1" ); }

log.Debug("exiting method1");

creativity..

volatile long

Tue, 24 Nov 2009 15:58:26 Z

I have just tried to use

static volatile long _myVar;

in in my C# code and it doesn't compile.

Having a look at the MSDN documentation this is absolutely correct.

Do you know why this is not possible?

Thanks

DataGridView - Put the data in

Tue, 24 Nov 2009 22:57:57 Z

I am unclear on how to insert the data into my datagridview object.
I have a class that contains all the data to put in a row, and some extra.

1) I see there is a DataGridRow object that I can add, but that data grid row wants an array of "objects". Not sure if writing some long convoluted code to get an array of objects from my class is needed.

2) I know there is data binding where you just "bind" it to an object such as my class, but my class isn't 1 for 1 with what goes in rows and I've only seen an exampe of this using a dataset or an array, but not a custom class.

3) What other options are there?

I imagine there is some kind of [][]= or something?

Here is the block of interest

            reader = command.ExecuteReader();

            while (reader.Read())
            {
               BudgetSummary budgetSummary = new BudgetSummary();

               budgetSummary.m_scenarioID        = scenarioID;
               budgetSummary.m_accountID         = (reader["A"] == DBNull.Value) ? 0  : Convert.ToInt32(reader["A"]);
               budgetSummary.m_accountDesc       = (reader["B"] == DBNull.Value) ? "" : reader["B"].ToString();
               budgetSummary.m_accountNum        = (reader["C"] == DBNull.Value) ? "" : reader["C"].ToString();
               budgetSummary.m_currentBudget     = (reader["D"] == DBNull.Value) ? 0  : Convert.ToInt32(reader["D"]);
               budgetSummary.m_currentActual     = (reader["E"] == DBNull.Value) ? 0  : Convert.ToInt32(reader["E"]);
               budgetSummary.m_currentForecast   = (reader["F"] == DBNull.Value) ? 0  : Convert.ToInt32(reader["F"]);
               budgetSummary.m_suggestedBudget   = (reader["G"] == DBNull.Value) ? 0  : Convert.ToInt32(reader["G"]);
               budgetSummary.m_nextYearBudget    = (reader["H"] == DBNull.Value) ? 0  : Convert.ToInt32(reader["H"]);

               budgetSummaries.Add(budgetSummary);

               DataGridViewRow row =  new DataGridViewRow();
               row.SetValues(.....);
               gridByYear.Rows.Add(row);
            }

Create DataGridViews From Multiple Result Sets

Wed, 25 Nov 2009 15:45:51 Z

Hi,
I have a SQL Stored Procedure that returns multiple result sets.

How do I create a DataGridView for each result set?

Thanks.