C# Discussion Boards - CodeProject

Re: sql to mysql

N a v a n e e t h10-Jul-08 22:33

N a v a n e e t h

10-Jul-08 22:33

Migrating from SQL server to MySQL, right ? Try this[^] tool

All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia

How to use google | Ask smart questions

Re: sql to mysql

yiren_shao10-Jul-08 22:51

yiren_shao

10-Jul-08 22:51

Re: sql to mysql<b<>&>

Re: sql to mysql

scottgp11-Jul-08 2:55

scottgp

11-Jul-08 2:55

ali_reza_zareian wrote:
how can i change my sql database to mysql database.Is it possible ?

By removing the " " from "my sql"? Laugh | :laugh:

Transparency in compact framework

Subasish_CodeProject10-Jul-08 20:48

Subasish_CodeProject

10-Jul-08 20:48

Hi

This is regarding getting tranparency effect for controls in .net compact framewok(3.5).

I want to have few icons diplayed in the form of tiles with their caption below. For the icons image, I am using png files. These icons I am rendering on a transparent panel which is on top of a form. Now I am getting the transparent effect but the border of the png files is not coming as smooth. Some white color border is getting displayed which makes the image look a bit jagged.

I would be highly obliged to you for any help from your side. For any clarifications please revert.

Thanks and regards
Subasish

Re: Transparency in compact framework

N a v a n e e t h10-Jul-08 22:34

N a v a n e e t h

10-Jul-08 22:34

Subasish M wrote:
but the border of the png files is not coming as smooth

I believe some good image editors like Photoshop, Paint.NET can remove this and make the image transparent.

All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia

How to use google | Ask smart questions

Re: Transparency in compact framework

Subasish_CodeProject14-Jul-08 2:57

Subasish_CodeProject

14-Jul-08 2:57

No the same image is looking fine in other applications

Re: Transparency in compact framework

netJP12L11-Jul-08 5:54

netJP12L

11-Jul-08 5:54

I wanna do the transparency panel can you show me how u achieved it thanks

Re: Transparency in compact framework

Subasish_CodeProject14-Jul-08 2:44

Subasish_CodeProject

14-Jul-08 2:44

using System;
using System.Linq;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Drawing.Imaging;
using System.Reflection;

namespace TransparentSmartDevice
{
public partial class TransparentPanel : ScrollableControl, IControlBackground
{
Bitmap background;

public TransparentPanel()
{
background = new Bitmap(
Assembly.GetExecutingAssembly().GetManifestResourceStream(
"TransparentSmartDevice.Test(240 X 374).JPG"));
}

protected override void OnPaint(PaintEventArgs e)
{
//e.Graphics.DrawImage(background, ClientRectangle,new Rectangle(0,0,background.Width,background.Height),GraphicsUnit.Pixel);
e.Graphics.DrawImage(background,0,0);// ClientRectangle, new Rectangle(0, 0, background.Width, background.Height), GraphicsUnit.Pixel);
}

public Image BackgroundImage
{
get { return background; }
}
}
}

using System;
using System.Linq;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;

namespace TransparentSmartDevice
{
public partial class TransparentPanelBase : ScrollableControl
{
protected bool HasBackground = false;

protected override void OnPaintBackground(PaintEventArgs e)
{
IControlBackground form = Parent as IControlBackground;
if (form == null)
{
base.OnPaintBackground(e);
return;
}
else
{
HasBackground = true;
}

e.Graphics.DrawImage(
form.BackgroundImage,
0,
0,
Bounds,
GraphicsUnit.Pixel);
}

protected override void OnTextChanged(EventArgs e)
{
base.OnTextChanged(e);
Invalidate();
}

protected override void OnParentChanged(EventArgs e)
{
base.OnParentChanged(e);
Invalidate();
}
}

}

Re: Transparency in compact framework

netmonster18-Aug-08 17:51

netmonster

18-Aug-08 17:51

How can I create a transparent label on top on the panel?

date picker in web application

SSN10-Jul-08 20:32

SSN

10-Jul-08 20:32

As datepicker control cannot be used in asp.net I wish to use a textbox instead of a calender , but the problem is I want the date to be entered by the clients in the "dd-MMM-yyyy" format. How do I do it?
Any body can help me out of this?

waiting for a quick reply.
Thanks

Re: date picker in web application

J a a n s10-Jul-08 21:39

J a a n s

10-Jul-08 21:39

Using javascript you can do this. Check the entered input is in the required format (by regular expression or so..). Alert the user if it is not.

You can go for a javascript calendar control. That will be helpful for the end user.

*jaans

strange name2ee output

George_George10-Jul-08 20:19

George_George

10-Jul-08 20:19

Hello everyone,

Before I start my managed code program (C#), when I execute name2ee command, there is no output, but after the program starts, there is expected output. Any ideas?

(here are the output 2 times and my source code)

0:000> !name2ee *!TestDebugManaged1.Program

0:004> !name2ee *!TestDebugManaged1.Program
Module: 0000064278854000 (mscorlib.dll)
--------------------------------------
Module: 0000064280012e20 (TestDebugManaged1.exe)
Token: 0x0000000002000002
MethodTable: 0000064280013580
EEClass: 00000642801421c0
Name: TestDebugManaged1.Program

namespace TestDebugManaged1
{
    class Program
    {
        public void foo()
        {
            int a = 100;
            while (true)
            {
                Thread.Sleep(10000);
                a++;
            }
        }
        
        static void Main(string[] args)
        {
            Program instance = new Program();
            instance.foo();
            return;
        }
    }
}

thanks in advance,
George

Re: strange name2ee output

Vimalsoft(Pty) Ltd11-Jul-08 6:58

Vimalsoft(Pty) Ltd

11-Jul-08 6:58

what Exactly do you want to return, because your return Statement does not return anything. tell us in Detail

why did you declare

int a = 100;

and if you want to return "a" then you should write a statement

return a;

Hope ths help

Vuyiswa Maseko,

Sorrow is Better than Laughter, it may Sadden your Face, but It sharpens your Understanding

VB.NET/SQL7/2000/2005
http://vuyiswamb.007ihost.com
http://Ecadre.007ihost.com
vuyiswam@tshwane.gov.za

Re: strange name2ee output

George_George13-Jul-08 0:07

George_George

13-Jul-08 0:07

Thanks Vuyiswa,

My expected output is like,

Module: 0000064280012e20 (TestDebugManaged1.exe)
Token: 0x0000000002000002
MethodTable: 0000064280013580
EEClass: 00000642801421c0
Name: TestDebugManaged1.Program

My question is,

why before I press g, and using the same command 0:000> !name2ee *!TestDebugManaged1.Program, there is no output?

regards,
George

DataReader memory size???

Raheem MA10-Jul-08 20:00

Raheem MA

10-Jul-08 20:00

Hi Friendz...

is there any memory size limit for DataReader in .Net? means can it hold any number of records ? (Above 1crore records)

Any idea?

Thanks in Advance
Smile | :)

Shah_tech

Re: DataReader memory size???

half-life10-Jul-08 22:35

half-life

10-Jul-08 22:35

here is an example of Odbc Data reader

u read each row at a time until the value of Reaq() is false - no more rows to read

u can not read all rows at once

OdbcDataReader Reader;
while (Reader.Read())
{
object[] dataArray = { };
Reader.GetValues(dataArray);
}

u can use : dataSet to hold data and use datadaptor to fill the dataset
this method is more handy where u assign an SQL stat. to the adaptor and by using the Fill
method u read all rows to the datatable inside the data set

Smile | :)

Have Fun
Never forget it

Re: DataReader memory size???

N a v a n e e t h10-Jul-08 22:37

N a v a n e e t h

10-Jul-08 22:37

DataReader won't hold the rows. It's a connection oriented design and it reads row by row. So if you are reading 1 crore rows, connection has to be open for until it finishes.

All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia

How to use google | Ask smart questions

Exception of type 'System.OutOfMemoryException' was thrown"

Raheem MA10-Jul-08 19:45

Raheem MA

10-Jul-08 19:45

Hi All,

I'm using SQLBulkCopy class in .net 2.0
I'm passing SQLDataReader object to SQLBulkCopy's WriteToServer () method.

Actually, source query returns around 1crore records. while running this exe I'm getting System.OutOfMemoryException exception.

any ideas to handle this exception?

Thanks in Advance Smile | :)

Shah_tech

Re: Exception of type 'System.OutOfMemoryException' was thrown" [modified]

killabyte10-Jul-08 20:06

killabyte

10-Jul-08 20:06

According to wiki a "crore" is 10million in India or 500000 in Iran(you learn something everyday Cool | :cool:

), since you are from india i will assume it is 10 million.

10 million records is a huge amount of data, you should fragment this process to deal with a far smaller chunk at a time or buy more RAM.

modified on Friday, July 11, 2008 2:18 AM

how many microsoft products installed

Mogaambo10-Jul-08 19:18

Mogaambo

10-Jul-08 19:18

How can i check in a system how many only microsoft products are installed

regards

Re: how many microsoft products installed

Paul Conrad10-Jul-08 20:32

Paul Conrad

10-Jul-08 20:32

You might want to look around on MSDN or traverse through the registry (my late night, quick thought Big Grin | :-D

)...

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

"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon

Re: how many microsoft products installed

Thomas Stockwell11-Jul-08 4:01

Thomas Stockwell

11-Jul-08 4:01

Well, count all programs from Microsoft you know you installed: office, vstudio,expression studio, etc. Then count every single sub program of the OS.

Regards,
Thomas Stockwell

Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning.

Visit my homepage Oracle Studios

Discounted or Free Software for Students:
DreamSpark - downloads.channel8.msdn.com
MSDN Academic Alliance - www.msdnaa.com

Retrieving the updated table from datagridview

Praveen Raghuvanshi10-Jul-08 19:03

Praveen Raghuvanshi

10-Jul-08 19:03

Hi,

I am getting some data from a database and populating it to a DataTable.
This Datatable is assigned as a DataSource to a DataGridView. This table gets displayed on the datagridview.

After that, i am adding a combobox column to DataGridView and filling the cells under that combobox with item selected.

I want to retreive the whole updated DataGridView along with the new column and values in the cell into a Datable object.

I am able to assign datagridview columns to a newly created datatable object and unable to do same for the datagridview rows.

Thanks in advance.
Praveen

CD burning using IMAPI

Darmi10-Jul-08 18:21

Darmi

10-Jul-08 18:21

Currently am using IMAPI for CD burning. I can perform multisession writes to CD. The problem comes when i add a folder with the same name that already exists in the CD. Suppose am having a folder named Test containing 1.docx in the CD. Now am trying to add anothe folder named Test with another doc file named 2.docx. I want the file 2.docx to be added under the earlier created folder containing document 1.docx. Is dat possible? Can anyone provide a sample code for that

Re: CD burning using IMAPI

Vimalsoft(Pty) Ltd11-Jul-08 7:09

Vimalsoft(Pty) Ltd

11-Jul-08 7:09

no man why would you do such a thing.remmber what is inide does not matter.the folder name should have different names

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