Re: reading data from exxcel - C# Discussion Boards

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/

Re: need to understand => string[]

Abhijit Jana17-Oct-07 21:38

Abhijit Jana

17-Oct-07 21:38

is it a database ??? Confused | :confused:

if yes, then it very simple !!!! Cool | :cool:

just read the database table and in while reading the content of table u can easily rint with message box

create connection
open connection
reader=execute query
while(reader!=null)
messagebox(reader[i].value)

Hope this will help u? any doubt always welcome !!!! Rose | [Rose]

Happy Programming
-----
Abhijit

toolstripdropdown

topksharma198217-Oct-07 21:00

topksharma1982

17-Oct-07 21:00

hi all,
I m striving from couple of days to implement a list in my project similer to the Undo list in Visual Studio and MS Outlook.I m not able to do it yet.
So , please if anyone knows how to do it and have ever done it , please tell me.
I will be so thankfull of u .
Thanx.

Praveen Sharma

Re: toolstripdropdown

benjymous17-Oct-07 23:17

benjymous

17-Oct-07 23:17

A very quick google search finds an example on MSDN:

http://msdn2.microsoft.com/en-us/library/system.windows.forms.toolstripdropdown.opening.aspx[^]

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

Help Required in Assembly

kc_krishnan17-Oct-07 20:59

kc_krishnan

17-Oct-07 20:59

Hi all ,
We are creating an application in which we need to load an XML file , located in a seperate folder named "Resources" , where this folder is exist in the solution file.Following is the code snippet, in which im trying to load the xml file in the Stream object:

Ln1 Assembly assembly = Assembly.GetExecutingAssembly();
Ln2 string resourceName = String.Concat(typeof(WebForm1).Namespace,".Resources.","Features.xml");
Ln3 Stream objStream = typeof(WebForm1).Assembly.GetManifestResourceStream(resourceName );
Ln4 StreamReader objStreamReader = new StreamReader(objStream);
Ln5 XmlTextReader xtr = new XmlTextReader(objStreamReader);
Ln6 return xtr;

Here the string resourceName we are getting is "Utility_XML.Resources.Features.xml"
where
Utility_XML -->Name space
Resources --> Folder
After LineNo3 the value populated in the 'objStream' is "Undefined Value". so struck up in this stage. I really appreciate if some one could guide me to fix this issue.Thanks in advance!

Best Regards,
Krishna Chandran

re:internet dialer

RameshwerE17-Oct-07 20:42

RameshwerE

17-Oct-07 20:42

Could any body please help how to develope an internet diler application in.net nd what are the requirements to run this dialer on Win9x ,XP nd windows server systems.Through this i have to display total MBs consumed and receving nd sending bytes info.I am completely new to this work.

Any help will be greatly appreciated.

Thanks

Re: re:internet dialer

Abhijit Jana17-Oct-07 20:52

Abhijit Jana

17-Oct-07 20:52

I Think you have to use WinInet internetdial APIs. for that .

Please check out this link , this will help you Smile | :)

http://www.thescripts.com/forum/thread578562.html[^]

Happy Programming
-----
Abhijit

Re: re:internet dialer

RameshwerE17-Oct-07 21:26

RameshwerE

17-Oct-07 21:26

thank you abhijit for ur earliest response.I will go thorugh it.

Re: re:internet dialer

Abhijit Jana17-Oct-07 21:32

Abhijit Jana

17-Oct-07 21:32

thanks, and if u will get any another solu~n let me know Smile | :)

Happy Programming
-----
Abhijit

Use property or field

Maddie from Dartford17-Oct-07 20:32

Maddie from Dartford

17-Oct-07 20:32

Hello,
I am having one private field which is encapsulated in public property.
As i can modify the field using the variable itself with in the class and through property outside the class.

Here the question is how should i modify the field....????
1)Through the property always, within the class or outside the class.
OR
2)Field within the class and use property outside the class.

I am agree with the 1st point because it increase the developers readabilty and easy to maintain.

Other side is the performance.. If i directly modify the variable, i am reducing one call which might give better efficiency.

So what is the better way???

Re: Use property or field

half-life17-Oct-07 20:57

half-life

17-Oct-07 20:57

What if u have million and million of code

at run time when u want to set/get value from inside u'll pass THRU the Property
(why go THRU a baypass) where u can go directly.

inside the class use the private field THUS escaping the :
get { return myVale };
this is a code line u escape in run time

the return itslef has it's own code like (go to the value ....)

Smile | :)

kobkob

Re: Use property or field

Guffa17-Oct-07 22:05

Guffa

17-Oct-07 22:05

If you want to access the internal value, use the variable. If you want to access the value as it would be accessed outside the class, use the property.

gajesh wrote:
If i directly modify the variable, i am reducing one call which might give better efficiency.

If the code for the property is simple, it will be inlined where you use it, and optimised down to just accessing the internal variable. So in most cases there is no difference in performance between using the property and using the variable.

---
"Anything that is in the world when you're born is normal and ordinary and is just a natural part of the way the world works. Anything that's invented between when you're fifteen and thirty-five is new and exciting and revolutionary and you can probably get a career in it. Anything invented after you're thirty-five is against the natural order of things."
-- Douglas Adams

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