Re: how to add data into database from a datatable in a C# project? - C# Discussion Boards

Cut a piece of image

Sasuko30-Mar-06 21:34

Sasuko

30-Mar-06 21:34

How can i define a rectangle area of an image where i want to delete all the pixel just as a rubber does in Photoshop?

Re: Cut a piece of image

J4amieC30-Mar-06 21:44

J4amieC

30-Mar-06 21:44

You just draw a rectangle over the top of the image with the background colour! There's no magic "Eraser" tool in GDI like there is in, say, photoshop.

Convert hexadecimal to Color and viceversa

Sasuko30-Mar-06 21:33

Sasuko

30-Mar-06 21:33

HOW?

Re: Convert hexadecimal to Color and viceversa

Vasudevan Deepak Kumar30-Mar-06 21:49

Vasudevan Deepak Kumar

30-Mar-06 21:49

System.Drawing.ColorConverter

Vasudevan Deepak Kumar
Personal Web: http://www.lavanyadeepak.tk/
I Blog At:
http://www.dotnetjunkies.com/weblog/deepak/
http://deepakvasudevan.blogspot.com/
http://deepak.blogdrive.com/

How do I read .pdf files

pirogramci30-Mar-06 20:52

pirogramci

30-Mar-06 20:52

Hello everybody,

How can I read/write a .pdf file?
After I read two .pdf files I want to write them on a one file.
Thanks.

Re: How do I read .pdf files

Vasudevan Deepak Kumar30-Mar-06 21:06

Vasudevan Deepak Kumar

30-Mar-06 21:06

http://itextsharp.sourceforge.net/[^]

Vasudevan Deepak Kumar
Personal Web: http://www.lavanyadeepak.tk/
I Blog At:
http://www.dotnetjunkies.com/weblog/deepak/
http://deepakvasudevan.blogspot.com/
http://deepak.blogdrive.com/

how to add data into database from a datatable in a C# project?

meenakshi_joshi0930-Mar-06 20:20

meenakshi_joshi09

30-Mar-06 20:20

Hello,

I am working on a c# project. I have a datagrid in which I have genereted a datatable with datarows and datacolumns at run time. Now I want to insert data from that datatable into a MySql database. How can I do the same.

With Regards
Meenakshi

Re: how to add data into database from a datatable in a C# project?

sathish s30-Mar-06 20:43

sathish s

30-Mar-06 20:43

few links
http://dev.mysql.com/doc/refman/5.0/en/connector-net-architecture-commandbuilder.html
http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=1288&lngWId=10
http://www.vbmysql.com/articles/vb_mysql_tutorials/vb_mysql_tutorial-part6.html#sample1

Database is not updating

Sunny H30-Mar-06 19:49

Sunny H

30-Mar-06 19:49

i have created a stroedprocedure(to store data in database) in sql client database. the code is executing fine but when the database is opend the data is not stored i dont know why ????? i am using visual studio 2005

sunny

Re: Database is not updating

suresh pandu30-Mar-06 20:24

suresh pandu

30-Mar-06 20:24

hi check if there is problem in datatype conversions.if not show the code along with stored procedure

Always on top button

Mridang Agarwalla30-Mar-06 19:30

Mridang Agarwalla

30-Mar-06 19:30

How can I add an Always On Top Button to the titlebar of a form just beside the minimize button?

Re: Always on top button

leppie30-Mar-06 19:37

leppie

30-Mar-06 19:37

I suggest you stick to fixing one problem at a time, you are asking so many random questions, I doubt you are even attempting to find the answers yourself...

And just to be nice. There is an article somewhere on CP that shows you how to do this (was long ago, I cant recall name of it).

xacc.ide-0.1.3.2

Advanced options > Refresh the dataset

erdsah8830-Mar-06 19:15

erdsah88

30-Mar-06 19:15

I am trying to use objectdatasource control binded to a dataset in VS 2005.

I have clicked the Refresh dataset option and in the designer.cs generated code it generates below statement.

how do I retreive the autoincrement coloumn of _ENTITYID from the objectdatasource ?

Also when I run this SQL statement it gives me the last entered row to the table which is cool but

, I could not find it the @_ENTITYID in select parameters and insert parameters while debugging the objectdatasource control.

What should I do ?

____________

exec sp_executesql N'INSERT INTO [LEAD] ([_ENTITYOWNER], [_ENTITYUSER], [_ENTITYMODIFYDATE], [_ENTITYCREATEDATE], [_ENTITYSTATUS], [_NAME], [_ISACTIVE], [_STATE], [_DESCRIPTION], [_CATEGORY], [_SECURITYCODE], [FIRSTNAME], [LASTNAME], [PREFIX], [COMPANYNAME], [INDUSTRY], [TITLE], [ANNUALREVENUE], [NUMBEROFEMPLOYEES], [RATING], [STATUS], [SOURCE], [HOMETEL], [FAXTEL], [MOBILETEL], , [NONSOLICITATIONINDICATOR], [COUNTRYNAME], [CITYNAME], [POSTALCODE], [STREETNAME], [DISTRICTNAME]) VALUES (@_ENTITYOWNER, @_ENTITYUSER, @_ENTITYMODIFYDATE, @_ENTITYCREATEDATE, @_ENTITYSTATUS, @_NAME, @_ISACTIVE, @_STATE, @_DESCRIPTION, @_CATEGORY, @_SECURITYCODE, @FIRSTNAME, @LASTNAME, @PREFIX, @COMPANYNAME, @INDUSTRY, @TITLE, @ANNUALREVENUE, @NUMBEROFEMPLOYEES, @RATING, @STATUS, @SOURCE, @HOMETEL, @FAXTEL, @MOBILETEL, @EMAIL, @NONSOLICITATIONINDICATOR, @COUNTRYNAME, @CITYNAME, @POSTALCODE, @STREETNAME, @DISTRICTNAME);

SELECT _ENTITYID, _ENTITYOWNER, _ENTITYUSER, _ENTITYMODIFYDATE, _ENTITYCREATEDATE, _ENTITYSTATUS, _NAME, _ISACTIVE, _STATE, _DESCRIPTION, _CATEGORY, _SECURITYCODE, FIRSTNAME, LASTNAME, PREFIX, COMPANYNAME, INDUSTRY, TITLE, ANNUALREVENUE, NUMBEROFEMPLOYEES, RATING, STATUS, SOURCE, HOMETEL, FAXTEL, MOBILETEL, EMAIL, NONSOLICITATIONINDICATOR, COUNTRYNAME, CITYNAME, POSTALCODE, STREETNAME, DISTRICTNAME FROM LEAD WHERE (_ENTITYID = SCOPE_IDENTITY())', N'@_ENTITYOWNER nvarchar(4000),@_ENTITYUSER nvarchar(4000),@_ENTITYMODIFYDATE datetime,@_ENTITYCREATEDATE datetime,@_ENTITYSTATUS int,@_NAME nvarchar(4000),@_ISACTIVE bit,@_STATE nvarchar(4000),@_DESCRIPTION nvarchar(4000),@_CATEGORY nvarchar(4000),@_SECURITYCODE int,@FIRSTNAME nvarchar(4000),@LASTNAME nvarchar(4000),@PREFIX nvarchar(4000),@COMPANYNAME nvarchar(4000),@INDUSTRY nvarchar(4000),@TITLE nvarchar(4000),@ANNUALREVENUE nvarchar(4000),@NUMBEROFEMPLOYEES nvarchar(4000),@RATING nvarchar(4000),@STATUS nvarchar(4000),@SOURCE nvarchar(4000),@HOMETEL nvarchar(4000),@FAXTEL nvarchar(4000),@MOBILETEL nvarchar(4000),@EMAIL nvarchar(4000),@NONSOLICITATIONINDICATOR nvarchar(4000),@COUNTRYNAME nvarchar(4000),@CITYNAME nvarchar(4000),@POSTALCODE nvarchar(4000),@STREETNAME nvarchar(4000),@DISTRICTNAME nvarchar(4000)', @_ENTITYOWNER = NULL, @_ENTITYUSER = NULL, @_ENTITYMODIFYDATE = NULL, @_ENTITYCREATEDATE = NULL, @_ENTITYSTATUS = NULL, @_NAME = NULL, @_ISACTIVE = NULL, @_STATE = NULL, @_DESCRIPTION = NULL, @_CATEGORY = NULL, @_SECURITYCODE = NULL, @FIRSTNAME = NULL, @LASTNAME = NULL, @PREFIX = NULL, @COMPANYNAME = NULL, @INDUSTRY = NULL, @TITLE = NULL, @ANNUALREVENUE = NULL, @NUMBEROFEMPLOYEES = NULL, @RATING = NULL, @STATUS = NULL, @SOURCE = NULL, @HOMETEL = NULL, @FAXTEL = NULL, @MOBILETEL = NULL, @EMAIL = NULL, @NONSOLICITATIONINDICATOR = NULL, @COUNTRYNAME = NULL, @CITYNAME = NULL, @POSTALCODE = NULL, @STREETNAME = NULL, @DISTRICTNAME = NULL

Smile | :)

Scrolling Progressbar

Mridang Agarwalla30-Mar-06 18:27

Mridang Agarwalla

30-Mar-06 18:27

I have an application that does some work in the background so I need to show the user some kinda 'processing animation'. How do I make a progressbar that has 5 bars that scrolling left and right throughtout the entire width of the progressbar? This way I can show the user that my app is still working. Any other animation sequences you might know of.

Re: Scrolling Progressbar

Mridang Agarwalla30-Mar-06 20:23

Mridang Agarwalla

30-Mar-06 20:23

Got It![^]

Re: Scrolling Progressbar

Nicholas Butler31-Mar-06 22:01

Nicholas Butler

31-Mar-06 22:01

Hi
You might like to use my progress bar: BusyBar[^].

Set Bounce to true.

----------------------------
Be excellent to each other Smile | :)

EasiReports[^] My free reporting component for WinForms.

how to place custom controls on top of the other controls

Oskars30-Mar-06 16:55

Oskars

30-Mar-06 16:55

Ok I`ll try to explain my problem Smile | :)

. ComboBox, places his choice list on top of the other controls, including other panels and so on. The question is - how can I make other custom control maded by myself wich is added to some panel [mPanel.Controls.Add(MyControl);] - to show up on top of the other controls and other panels (like ComboBox choice list), but without separate it from [mPanel.Controls]. Can control actually act like ComboBox list on top of other controls?

Re: how to place custom controls on top of the other controls

George L. Jackson30-Mar-06 17:25

George L. Jackson

30-Mar-06 17:25

I believe a ComboBox is rendered by the IE browser as a "window" control (as in a Windows Forms' control). Thus, the ComboBox will always appear over everything else. I don't know of any attractive solutions, however.

Re: how to place custom controls on top of the other controls

Oskars30-Mar-06 17:44

Oskars

30-Mar-06 17:44

Actually I am talking about C# windows form. I have a grid in one panel, other grid in other panel. One of the columns contains comboboxes, ComboBox list, of course appears over the second grid, I want my custom control wich contains some textboxes and other crap show up in similar way. Way I am using - is separate form without close and minimize buttons, but it is not Control added to grid cell, it is separate windows form and it is not good solution, because it shows up in a taskbar and acts like form, but I want to attach it to the grid cell as a normal control Frown | :(

Re: how to place custom controls on top of the other controls

microsoc30-Mar-06 20:33

microsoc

30-Mar-06 20:33

hi Oskars! Smile | :)

you can put you custom control on a floating window. this window will be on top of all window, just like the list of the combobox.

try to look at this[^] to have an idea how to make a floating window.

hope that helps! Smile | :)

microsoc

C# Equivalent of "chunk_split"

emran83430-Mar-06 15:48

emran834

30-Mar-06 15:48

Hello,
I am trying to convert this following PHP code to C# for Windows Application, (Not ASP.NET). My intention is to post file attachment to remote server by doing this. I know how to convert base64 in C#, but I dont know which Method of C# do this chunk_split. Can anyone please help !

string chunk_split ( string body [, int chunklen [, string end]] )
This functoin can be used to split a string into smaller chunks which is useful for e.g. converting base64_encode() output to match RFC 2045 semantics. It inserts end (defaults to "\r\n") every chunklen characters (defaults to 76). It returns the new string leaving the original string untouched.

Re: C# Equivalent of "chunk_split"

leppie30-Mar-06 19:20

leppie

30-Mar-06 19:20

emran834 wrote:
string chunk_split ( string body [, int chunklen [, string end]] )
This functoin can be used to split a string into smaller chunks which is useful for e.g. converting base64_encode() output to match RFC 2045 semantics. It inserts end (defaults to "\r\n") every chunklen characters (defaults to 76). It returns the new string leaving the original string untouched.

What is the problem? From the description its pretty clear what it does, so just implement the same in C#. One way is to use a StringBuilder and inject '\r\n' at every 76 char interval.

xacc.ide-0.1.3.2

Re: C# Equivalent of "chunk_split"

emran8345-Apr-06 8:42

emran834

5-Apr-06 8:42

Hi,
thanks for your reply. As I am new in C#, would you please show me the snippet for doing this. !!

Thanks and regards
Emran

Re: C# Equivalent of "chunk_split"

Vasudevan Deepak Kumar30-Mar-06 20:37

Vasudevan Deepak Kumar

30-Mar-06 20:37

Did you check out this?

http://www.codeproject.com/cs/webservices/DimeBufferedUpload.asp[^]

Vasudevan Deepak Kumar
Personal Web: http://www.lavanyadeepak.tk/
I Blog At:
http://www.dotnetjunkies.com/weblog/deepak/
http://deepakvasudevan.blogspot.com/
http://deepak.blogdrive.com/

Minimizing a Windows Form to the taskbar programmatically?

LongRange.Shooter30-Mar-06 15:06

LongRange.Shooter

30-Mar-06 15:06

I have a windows form application. When the user clicks the pause button, I want to programmatically minimize the window. Does anyone have the snippet for doing this in the 2.0 Framework?

Thanks

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