Reading excel sheet issue - C# Discussion Boards

AlexB473-Jan-10 21:02

3-Jan-10 21:02

Hi all,
i use, to move a circle in a panel (in a form), a code line such as this:

Grapichs e;

for(...)
{
panel.Invalidate(new Rect(list[i-1].x,list[i-1].y,list[i-1].widht,list[i-1].height));
e.DrawEllipse(list[i].x,list[i].y,list[i].widht,list[i].height);
}

can you help me with a solution that resolve a flicker problem? Is possible to create a doublebuffer in a panel object?

Thanks.

Alex

Re: Invalidate and redraw

Jimmanuel4-Jan-10 0:54

Jimmanuel

4-Jan-10 0:54

AlexB47 wrote:
Is possible to create a doublebuffer in a panel object?

Yes. Create a class that inherits from Panel and in the constructor you can set this.DoubleBuffered to true.

Badger | [badger,badger,badger,badger...]

Re: Invalidate and redraw

AlexB474-Jan-10 1:23

AlexB47

4-Jan-10 1:23

Can you help me with example? I use a panel object with "drag and drop" from toolbar into form (I'm novice programmer in C#).
Thanks a lot!

Alex

Re: Invalidate and redraw

Jimmanuel4-Jan-10 2:59

Jimmanuel

4-Jan-10 2:59

Well, I was about to reply with an example but as usual, Luc already has one handy Smile | :)

Re: Invalidate and redraw

Luc Pattyn4-Jan-10 2:44

Luc Pattyn

4-Jan-10 2:44

Hi,

this[^] has all you need.

Smile | :)

Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles]

Merry Christmas and a Happy New Year to all.

Re: Invalidate and redraw

AlexB474-Jan-10 3:46

AlexB47

4-Jan-10 3:46

Good ... I test this solution!
Many Thanks!
Smile | :)

Alex

Re: Invalidate and redraw

Luc Pattyn4-Jan-10 4:00

Luc Pattyn

4-Jan-10 4:00

you're welcome.

Smile | :)

Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles]

Merry Christmas and a Happy New Year to all.

Reading excel sheet issue

Priya Prk3-Jan-10 20:49

Priya Prk

3-Jan-10 20:49

Dear All,

Im trying to read data from excel through Oledb.

OleDbConnection connCura = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;
                        Data Source=" + path + ";Extended Properties=Excel 8.0");
                    OleDbDataAdapter da = new OleDbDataAdapter("SELECT * FROM [Sheet1$]", conn);

The problem is that if the 'Sheet1' in the excel file had a another name instead of 'Sheet1', then im getting this error:

System.Data.OleDb.OleDbException: External table is not in the expected format. at ConfigQeKMS.ReadImportFile.ReadTheFile(String path, String extension, String scheiTeken) in C:\Documents and Settings\KaneshkaB\Desktop\30 DEC 2009\QeKms\ConfigQeKMS\ReadImportFile.cs:line 61

Can anyone tell me how to fix this?

Thanks.

Re: Reading excel sheet issue

Aman Bhullar3-Jan-10 21:03

Aman Bhullar

3-Jan-10 21:03

Check the Article if this can help you
http://www.codeproject.com/tips/50009/Loading-Excel-data-into-a-GridView.aspx[^]

Regards
Aman Bhullar
www.arlivesupport.com[^]

Re: Reading excel sheet issue

Priya Prk3-Jan-10 23:40

Priya Prk

3-Jan-10 23:40

Thanks Aman, it worked Smile | :)

Delegate

Isaac Gordon3-Jan-10 19:59

Isaac Gordon

3-Jan-10 19:59

Hi Experts
I am Working Win Form in .NET 2005(C#).
i am making user control that have only one progress bar and label show the %age of progress bar.Now i am creating a window Form on that i use This user
control.when suppose i start for loop from 1 to 1000 then progress bar also running according to my for loop in user control.

main problem is that when loop is running in the form that i have used this control then how to send the value to progress so that it increase the progress bar value.

Dinesh Sharma.

Re: Delegate

Abhinav S3-Jan-10 20:36

Abhinav S

3-Jan-10 20:36

A similar question has already been answered before. Try here[^].

There are only 10 types of people in this world — those who understand binary, and those who don't.

C# textbox not working in vc++

Anu_Bala3-Jan-10 19:23

Anu_Bala

3-Jan-10 19:23

Hi,
Im using textbox in C# and i use this as C# dll in VC++.
But i cannot enter any value in that textbox.
Do i want to use any events for entering data..Pls help me?

Anu

Re: C# textbox not working in vc++

Richard MacCutchan3-Jan-10 22:20

Richard MacCutchan

3-Jan-10 22:20

You have asked a similar question twice already. Please post your question once only.

Re: C# textbox not working in vc++

Priya Prk3-Jan-10 23:48

Priya Prk

3-Jan-10 23:48

is the textbox not readonly? or enabled= false ?

Graphs in Report Sharp-Shooter

nagendrathecoder3-Jan-10 19:16

nagendrathecoder

3-Jan-10 19:16

Hi All,
I am using Report Sharp-Shooter of PerpetuumSoft for reporting in my project.
I want to insert graph/chart in my reports.

Can anybody tell me or provide some link to me on how to add graph/charts in Report Sharp-Shooter.

I have searched on google but i am mostly getting the links of purchase or free download of software.

Thanks,
Nagendra.

Re: Graphs in Report Sharp-Shooter

Ashfield3-Jan-10 21:34

Ashfield

3-Jan-10 21:34

Your best bet is to contact the vendor, they are more likely to know

Bob
Ashfield Consultants Ltd
Proud to be a Code Project MVP

GetModuleHandle always returning zero.

tapas19793-Jan-10 19:07

tapas1979

3-Jan-10 19:07

I'm trying to get the module handle of the loaded dll in order to pass it to SetWindowsHookEx() function. [Bascially I'm using the windows hook approach to inject the dll in another process]. However, GetModuleHandle always returns 0. What could be the issue? Here is the code:

            [DllImport("kernel32.dll", CharSet = CharSet.Auto)]
            public static extern IntPtr GetModuleHandle(string lpModuleName);

            [DllImport("user32.dll", SetLastError = true)]
            static extern IntPtr SetWindowsHookEx(HookType hookType, HookProc lpfn, IntPtr hMod, uint dwThreadId);

            IntPtr moduleHandle = GetModuleHandle("HookInjectDll");
// I tried giving full dll path, the .dll file extension, but nothing works. ModuleHandle returned is always zero. I also verified Assembly.GetExecutingAssembly() that the current dll path is correct.

                  int lastError = Marshal.GetLastWin32Error(); // This returns 0 i.e. success.

                  hookPtr = SetWindowsHookEx(HookType.WH_CALLWNDPROC, (HookProc)MyHookProc,
                        moduleHandle,
                        GetWindowThreadProcessId(targetProcessHandle, IntPtr.Zero));

Any help on this issue?

Thanks

Re: GetModuleHandle always returning zero.

Luc Pattyn4-Jan-10 2:49

Luc Pattyn

4-Jan-10 2:49

tapas1979 wrote:
This returns 0 i.e. success.

Nope. Your GetModuleHandle prototype is missing SetLastError = true

Smile | :)

Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles]

Merry Christmas and a Happy New Year to all.

Re: GetModuleHandle always returning zero.

Member 42162068-Feb-10 10:12

Member 4216206

8-Feb-10 10:12

Marshal.GetHINSTANCE(typeof(MyClass).Module)

reporting issue

mjawadkhatri3-Jan-10 18:32

mjawadkhatri

3-Jan-10 18:32

I have a crystal report that displays records from a database.Each record has a number field "QTY". I want to display sum of each record in a page
suppose i purchase product 3 times in different dates

product qty
monitor 30
monitor 40
monitor 30

i want to display like this

product qty

moniter 100

thanks in advance.

Re: reporting issue

Priya Prk3-Jan-10 23:41

Priya Prk

3-Jan-10 23:41

You can do this using the designer in your crystal report file.

Get tables and columns from existing sql server backup file

VENKAT SEERLA3-Jan-10 17:17

VENKAT SEERLA

3-Jan-10 17:17

Hi all,

how to get tables and columns from existing sql server backup file without connect to SQL Server?
Is it possible to get table names and column names form raw file like *.bak ?

Please help me.............

Thanks
Venkat

Re: Get tables and columns from existing sql server backup file

Priya Prk3-Jan-10 23:46

Priya Prk

3-Jan-10 23:46

I don't how to select without connecting Smile | :)

bud to get column names from a table use:

SELECT COLUMN_NAME AS Databasekolommen FROM INFORMATION_SCHEMA.COLUMNS WHERE (TABLE_NAME = 'tablename') ORDER BY ORDINAL_POSITION

and to get table names:

SELECT [TABLE_NAME]
FROM WorkDB.INFORMATION_SCHEMA.TABLES

hope it helps

Re: Get tables and columns from existing sql server backup file

VENKAT SEERLA5-Jan-10 20:20

VENKAT SEERLA

5-Jan-10 20:20

is it possible to get table names and columns without using SQLServer?
that means can i get table names and columns from raw file(*.bak)?

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