Re: Exception Line Number at runtime - C# Discussion Boards

Sun Rays17-Oct-07 22:44

17-Oct-07 22:44

I had a web site i need to show some activity ICON in Taskbar. Icon will keep displaying updated Values upon receives from different users or Database. Just like when we receiv new email in Outlook express and populate small window.

Thanks,
Sun Rays

Re: C# Web application for Taskbar icon

benjymous17-Oct-07 23:15

benjymous

17-Oct-07 23:15

That's good to know. Let us know when you have a specific problem, and we'll try to help.

--
Help me! I'm turning into a grapefruit!
Buzzwords!

Re: C# Web application for Taskbar icon

Sun Rays18-Oct-07 2:18

Sun Rays

18-Oct-07 2:18

I dont know how to do this... bcoz in window application we have notify icon control which is doing the same.
but I need for Web Application,

Thanks.

Thanks,
Sun Rays

Re: C# Web application for Taskbar icon

Bjohnson3318-Oct-07 4:23

Bjohnson33

18-Oct-07 4:23

Hi
The following will hopefully give you what you need: http://aspalliance.com/1306_How_to_Show_MessengerLike_Popups_Using_AJAX.all

Cheers
Ben

Image Processing using C#

anu91417-Oct-07 22:40

anu914

17-Oct-07 22:40

Hello,

I want to change pixel values of an image according to some data assigned for each pixel location.

I found many image processing tutorials but could not cum across with anything to change the pixel values. If someone can help me it'll be really appreciated.

Thank you

Re: Image Processing using C#

Giorgi Dalakishvili17-Oct-07 22:53

Giorgi Dalakishvili

17-Oct-07 22:53

I suggest you have a look at Image Processing articles by Christian Graus here: http://www.codeproject.com/script/articles/list_articles.asp?userid=6556

#region signature
my articles
#endregion

Exception Line Number at runtime

Michael Sterk17-Oct-07 22:32

Michael Sterk

17-Oct-07 22:32

First of all sorry for cross posting, but i need at answer in a short time. The Original Thread is here http://www.codeproject.com/script/comments/forums.asp?forumid=1650&df=2&select=2277409#xx2277409xx[^]
Is there any way to get the Line Number of an Exception at runtime. I don't want to use the pdb Files in the release version. I also tried the Stackframe Object and it also doesn't work.
I know that the Project is in the IL when it is build. But perhaps there is a way with reflection?

Any Ideas? Please help me.

Re: Exception Line Number at runtime

lmoelleb17-Oct-07 22:45

lmoelleb

17-Oct-07 22:45

So now you feel your lack of planning is a reason to annoy everyone else? We did not make any planning mistakes, so why do we have to see your post all over the place? What makes you think you have a more urgent need for the reply than everyone else posting there question in single thread? Actually, have you considered the world is not just about you?

ODBC ( read / write )

half-life17-Oct-07 22:27

half-life

17-Oct-07 22:27

HI,

i like to know how to read all of the Tables from my "DataBase.mdb" file.
i've created the ODBC Driver and it's DSN is "DataB"

know i'm doing this :

OdbcConnection dbCon = new OdbcConnection("DSN=DataB");
now i need to do this :
OdbcCommand dbcom = new OdbcCommand(SQLString,dbCon);
BUT i do not want a specific Table i want them all!!!!!

maybe i missing the point, i dont know

Help

THNKS Smile | :)

kobkob

Re: ODBC ( read / write )

J4amieC17-Oct-07 22:52

J4amieC

17-Oct-07 22:52

OdbcConnection.GetSchema[^]

---

How to get answers to your questions[^]

Re: ODBC ( read / write )

half-life17-Oct-07 23:18

half-life

17-Oct-07 23:18

it provide's me only a dataTable...

that's good for a start

but u cannot iterate (for/foreac) for all the tables
(without knowing the Tables name)

i like to run over all of it (without sending a table name to bring back)

kobkob

Re: ODBC ( read / write )

J4amieC18-Oct-07 0:07

J4amieC

18-Oct-07 0:07

kobibi wrote:
but u cannot iterate (for/foreac) for all the tables
(without knowing the Tables name)

Of course you can! Just use dataTable.Rows.Count and a for loop.

---

How to get answers to your questions[^]

Re: ODBC ( read / write )

Abhijit Jana17-Oct-07 22:55

Abhijit Jana

17-Oct-07 22:55

This is the Query which will list out will the table name from a mdb file
Cool | :cool:

SELECT Name
FROM MSysObjects
WHERE Type In (1) AND Left([Name],4)<>"MSYS";

How will u do it? D'Oh! | :doh:

Step 1: connect with database
step 2: use datareader with that select comand
step 3 : while(reader())
{
string tablename=(reader[0])

now use another command text
string str= select * from + tablename
db.commandtext=str;

}

Hope this will solve ur problem !!!!

Happy Programming
-----
Abhijit

Re: ODBC ( read / write )

half-life17-Oct-07 23:14

half-life

17-Oct-07 23:14

i got till here and got confused :

OdbcConnection dbCon = new OdbcConnection("DSN=myDataBase");
dbCon.Open();
string sSql = "SELECT Name FROM MSysObjects WHERE Type In (1)
AND Left([Name],4)<>MSYS";
OdbcCommand dbcom = new OdbcCommand(sSql, dbCon);
OdbcDataReader dbRdr = dbcom.ExecuteReader();

is that O.K?

now what? Smile | :)

THANKS A LOT Smile | :)

kobkob

Re: ODBC ( read / write )

Abhijit Jana17-Oct-07 23:21

Abhijit Jana

17-Oct-07 23:21

kobibi wrote:
OdbcConnection dbCon = new OdbcConnection("DSN=myDataBase");
dbCon.Open();
string sSql = "SELECT Name FROM MSysObjects WHERE Type In (1)
AND Left([Name],4)<>MSYS";
OdbcCommand dbcom = new OdbcCommand(sSql, dbCon);
OdbcDataReader dbRdr = dbcom.ExecuteReader();

while(drRdr.read())
{
string newcmd= select * from + drRdr[0] ' one by one table
OdbcCommand dbcom2 = new OdbcCommand(newcmd, dbCon);
'now u can use in your won way
}

Happy Programming
-----
Abhijit

Re: ODBC ( read / write )

half-life17-Oct-07 23:47

half-life

17-Oct-07 23:47

Look at that Error :

no read permission on 'MSysObjects'.
Because -
OdbcDataReader dbRdr = dbcom.ExecuteReader();

What.....

Smile | :)

kobkob

Re: ODBC ( read / write )

Abhijit Jana17-Oct-07 23:59

Abhijit Jana

17-Oct-07 23:59

hi, i am not present here to solve your line by line problem. and may be no one !!!!! Laugh | :laugh:

I have already infrom you how to read table name, try to execute the same code from Access Query , it will work !!!! Sniff | :^)

So at least try to do something your self !!!!!! Hmmm | :|

Try to learn ADO.NET D'Oh! | :doh:

Happy Programming
-----
Abhijit

reading data from exxcel

ramyanaidu17-Oct-07 21:47

ramyanaidu

17-Oct-07 21:47

I have run the program given below but iam not getting the values from excel can anyone help me out in this plz

using System;
using Excel;
namespace TestExcel
{
///

/// Summary description for ExcelApplication.
///

class ExcelApplication
{
///

/// The main entry point for the application.
///

[STAThread]
static void Main(string[] args)
{

string Path = @"D:\book1.xls";
// initialize the Excel Application class
Excel.ApplicationClass app = new ApplicationClass();
// create the workbook object by opening the excel file.
Excel.Workbook workBook = app.Workbooks.Open(Path, 0, true, 5, "", "", true, Excel.XlPlatform.xlWindows,
"\t", false, false, 0, true, 1, 0);

// get the active worksheet using sheet name or active sheet
Excel.Worksheet workSheet = (Excel.Worksheet)workBook.ActiveSheet;

string[] name =
{"SPACE_REF","LOCAL_SPACE_NAME","SPACE_AREA","SPACE_USE","CAT_CODE","SUB_CAT_CODE","SCHOOL_USE",
"NIA","EXCLUDED_%","SUFFICIENCY_SPACE_TYPE","SUFFICIENCY_STAUS_CODE","CEILING_HEIGHT","CEILING_TYPE",
"FLOOR_TYPE","CLN_SPEC","CLN_BY","FLOOR_REF","BUILDING_REF","SHARED_SPACE","SHARED_REF","SI_SKETCH_NO",
"UPRN","LMS%"};
int l;
l = name.Length;
for (int a =1; a

Re: reading data from exxcel

Jimmanuel18-Oct-07 1:52

Jimmanuel

18-Oct-07 1:52

I'm not an expert at the Excel stuff but two things that stick out at me are

a) inside the while loop workSheet.Cells is being indexed with 1,1 for every iteration of the loop instead of i and j
b) also inside the loop the call to console.writeline is printing spaces, the string should be "{0}"

maybe that'll help . . .

export report

k.philip17-Oct-07 21:24

k.philip

17-Oct-07 21:24

hi all
How do i export a report (sql server reporting services) to the following formats using c# ??
o MS-Excel
o HTML
o MS-Word
o PDF
o CSV
o XML
o RTF
(anyone of the above would also be welcome);P
plss help!
thanks!

Re: export report

Christian Graus17-Oct-07 21:36

Christian Graus

17-Oct-07 21:36

Office - use the office toolkit
PDF - buy a toolkit
CSV/XML/RTF - write the code to do it.

Christian Graus - Microsoft MVP - C++

"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

Re: export report

k.philip17-Oct-07 21:42

k.philip

17-Oct-07 21:42

Christian Graus wrote:
Office - use the office toolkit
PDF - buy a toolkit
CSV/XML/RTF - write the code to do it.

Looks like i wasnt very clear earlier
well i cant use any third party tools here , have to use c# strictly Poke tongue | ;-P

or i have to do everything programmatically

Re: export report

Malcolm Smart18-Oct-07 2:58

Malcolm Smart

18-Oct-07 2:58

k.philip wrote:
have to use c# strictly
or i have to do everything programmatically

Isn't that the same thing? If you can only use C# then you can only do it programatically. For the office stuff, you can use the PIA, and make interop calls. It gives you a Word or Excel namespace, but you would still have to write the content programatically.

"More functions should disregard input values and just return 12. It would make life easier." - comment posted on WTF

"This time yesterday, I still had 24 hours to meet the deadline I've just missed today."

need to understand => string[]

M Riaz Bashir17-Oct-07 21:22

M Riaz Bashir

17-Oct-07 21:22

Hi,

I have one table belonged with one column like :

Items
-----
LION
CAT
DOG
HORSE
ELEPHANT
MOUSE
TIGER
ETC

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

Kindly teach me how to collect them and how to show them with message box?

Thank you in advance
(Riaz)

Re: need to understand => string[]

il_masacratore17-Oct-07 21:35

il_masacratore

17-Oct-07 21:35

I supose you have a datatable... I believe that only way to collect all column data is doing a loop for all rows and getting column value...

//Example<br />
private string[] GetAllColumnValues(DataTable dt)<br />
{<br />
List<string> aValues = new List<string>;<br />
foreach(DataRow oRow in dt.Rows)<br />
{<br />
    aValues.Add(oRow["colName or index"].toString());<br />
}<br />
return aValues.toArray();<br />
}<br />

Visit my blog at http://dotnetforeveryone.blogspot.com/

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