C# Discussion Boards - CodeProject

_Maxxx_20-Jul-09 18:17

20-Jul-09 18:17

are you saying that the fields you dragged onto the report aren't showing at runtime?

Have you done a viewer.DataBind(); after setting the reportsource?

___________________________________________
.\\axxx
(That's an 'M')

Re: CrystalReports

CodingYoshi21-Jul-09 4:34

CodingYoshi

21-Jul-09 4:34

viewer.DataBind() is not an available method on CrystalReportViewer control. This is a desktop application, not a web application. Basically what I am trying to do is as following, for example:

I have created the layout of the form for customer orders. Each order should be on a separate page but the layout will be consistent. I grab the data using many stored procedures and then put them into one table (TableAll for example). I have also created one dataset with one table (TableDataSet for example), at design time, which has exactly the same structure as TableAll. I set the crystal report's datasource to the TableDataSet by using Database Expert (Right click the Database field). I drag the fields from the Database fields onto my report.

At run time, my app populate DataAll and I set the report's table (TableDataSet) source to DataAll as below:

OrderReport report = new OrderReport(); // Crystal report

// The first table of the report gets its data from DataAll, they have same structure
report.Database.Tables(0).SetDataSource(DataAll);

// Create the viewer
CrystalReportViewer viewer = new CrystalReportViewer();
viewer.ReportSource = report;
viewer.Visible = true;

The report however only contains the layout but no data. Why do you think?

CodingYoshi

Artificial Intelligence is no match for Human Stupidity.

what to use instead of 'var' in vs 2005 as for the projects developed in vs2005.

svt gdwl20-Jul-09 5:00

svt gdwl

20-Jul-09 5:00

when I googled I found that 'var' in .Net is used if .NETFramework3.0 is there, IS there any variant datatype in c# for using in vs2005 in similar way.

Re: what to use instead of 'var' in vs 2005 as for the projects developed in vs2005.

Mirko198020-Jul-09 5:05

Mirko1980

20-Jul-09 5:05

var in 3.5 practically means "Deduce the variable type at compile-time", so, for converting code to 2.0 you have to substitute var with the right type for all variables.

For example,

3.5

var i = 0;
var s = "Hello";

in 2.0 becomes

int i = 0;
string s = "Hello";

Re: what to use instead of 'var' in vs 2005 as for the projects developed in vs2005.

PIEBALDconsult20-Jul-09 5:57

PIEBALDconsult

20-Jul-09 5:57

Var was added for Linq.

You must be abusing var, don't. Just use the type.

Re: what to use instead of 'var' in vs 2005 as for the projects developed in vs2005.

Ennis Ray Lynch, Jr.20-Jul-09 7:25

Ennis Ray Lynch, Jr.

20-Jul-09 7:25

var is a language feature introduced in .NET so that C# can follow in the popularity of VB6.

object would be the closest charlie foxtrot counterpart available in 2.0.

Need custom software developed? I do C# development and consulting all over the United States.

A man said to the universe:
"Sir I exist!"
"However," replied the universe,
"The fact has not created in me
A sense of obligation."
--Stephen Crane

Re: what to use instead of 'var' in vs 2005 as for the projects developed in vs2005.

Luc Pattyn20-Jul-09 7:51

Luc Pattyn

20-Jul-09 7:51

Ennis Ray Lynch, Jr. wrote:
object would be the closest charlie foxtrot counterpart available in 2.0.

It will take quite a twist to make this work:

object a=1;
object b=2;
object c=a+b;

Luc Pattyn [Forum Guidelines] [My Articles]

The quality and detail of your question reflects on the effectiveness of the help you are likely to get.
Show formatted code inside PRE tags, and give clear symptoms when describing a problem.

Re: what to use instead of 'var' in vs 2005 as for the projects developed in vs2005.

Ennis Ray Lynch, Jr.20-Jul-09 8:02

Ennis Ray Lynch, Jr.

20-Jul-09 8:02

Closest counterpart does not imply identical functionality. Personally I am completely opposed to the var construct.

Re: what to use instead of 'var' in vs 2005 as for the projects developed in vs2005.

Luc Pattyn20-Jul-09 8:06

Luc Pattyn

20-Jul-09 8:06

Right. I haven't used var (nor LINQ), and I don't intend to.

Smile | :)

Luc Pattyn [Forum Guidelines] [My Articles]

The quality and detail of your question reflects on the effectiveness of the help you are likely to get.
Show formatted code inside PRE tags, and give clear symptoms when describing a problem.

Re: what to use instead of 'var' in vs 2005 as for the projects developed in vs2005.

PIEBALDconsult20-Jul-09 8:43

PIEBALDconsult

20-Jul-09 8:43

I guess that makes three of us.

Re: what to use instead of 'var' in vs 2005 as for the projects developed in vs2005.

Ian Shlasko20-Jul-09 10:23

Ian Shlasko

20-Jul-09 10:23

I like "var", but you have to know where to use it... Used properly, it makes the code nicer to read... Used improperly, you're hammering nails into the heads of whoever has to maintain your code later on.

Good:

// You know exactly what type customerMap is, because it's right there.
var customerMap = new Dictionary<string, List<CustomerBusinessObject>>();

Bad:

// You have to dig into another function to figure out what type it is
var customerMap = mapGenerator.GetCustomerMap();

(Yes, it's a bad example, because Dictionary<string, ...>> should be defined as a class for readability, but you get the point)

Re: what to use instead of 'var' in vs 2005 as for the projects developed in vs2005.

PIEBALDconsult20-Jul-09 10:53

PIEBALDconsult

20-Jul-09 10:53

No, it is only to be used when you can't know the type; it's not to be used simply as a crutch for lazy programmers.

Re: what to use instead of 'var' in vs 2005 as for the projects developed in vs2005.

Ian Shlasko20-Jul-09 11:23

Ian Shlasko

20-Jul-09 11:23

Laziness has nothing to do with it. I know it was originally designed for linq queries (For which I usually do a ToArray() and strongly type it), but it can also make more readable code by getting rid of some of the redundancy.

Sure, I could type a long type definition twice, or copy-paste it, but it looks a lot cleaner if you only specify the type once.

Re: what to use instead of 'var' in vs 2005 as for the projects developed in vs2005.

PIEBALDconsult20-Jul-09 12:03

PIEBALDconsult

20-Jul-09 12:03

Even though you may not be lazy, many are.

Re: what to use instead of 'var' in vs 2005 as for the projects developed in vs2005.

S. Senthil Kumar20-Jul-09 19:28

S. Senthil Kumar

20-Jul-09 19:28

PIEBALDconsult wrote:
it is only to be used when you can't know the type;

Not trying to start an argument here, just curious. Would you say all dynamic languages are hard to read and are only for lazy programmers?

Python, which many people proclaim as the language easiest to read and understand, doesn't let you specify types for variables. There is no keyword equivalent to var even.

Also, I'd think var is useful when you don't care about the actual type, only that it has certain methods or properties.

var result = CalculateSomething();
result.DoX();

The code expresses the intent that it doesn't care what type result is, as long as there is a DoX method on it (without which it won't compile, of course). In a way, it's almost like result is a generic or template parameter.

What do you think?

Regards
Senthil
_____________________________
My Home Page |My Blog | My Articles | My Flickr | WinMacro

Re: what to use instead of 'var' in vs 2005 as for the projects developed in vs2005.

PIEBALDconsult20-Jul-09 19:32

PIEBALDconsult

20-Jul-09 19:32

I don't know Python, and I guess I don't want to.

C# 4.0 has dynamic, but I've only seen a small demo of it, so I really can't say. I expect it will be abused as well.

Re: what to use instead of 'var' in vs 2005 as for the projects developed in vs2005.

N a v a n e e t h20-Jul-09 15:35

N a v a n e e t h

20-Jul-09 15:35

Luc Pattyn wrote:
Right. I haven't used var

Me too. But, I use the auto(equivalent for var introduced in C++0x) keyword extensively in C++ and it makes the code more readable.

Smile | :)

Navaneeth

How to use google | Ask smart questions

scan using Twain in c#.net

balu1234520-Jul-09 4:09

balu12345

20-Jul-09 4:09

Hi all,

Please help me with your ideas
From c#.net application how to perform scan operation using twain protocol?

thanks

Re: scan using Twain in c#.net

DaveyM6920-Jul-09 4:17

DaveyM69

20-Jul-09 4:17

The first result[^] of a google search[^], finds one on this very site. I'm sure many of the other 257000 results may prove fruitful too.

Dave
BTW, in software, hope and pray is not a viable strategy. (Luc Pattyn)
Visual Basic is not used by normal people so we're not covering it here. (Uncyclopedia)
Why are you using VB6? Do you hate yourself? (Christian Graus)

Re: scan using Twain in c#.net

DaveyM6920-Jul-09 4:31

DaveyM69

20-Jul-09 4:31

this C header[^] file may prove useful.

Re: scan using Twain in c#.net

Luc Pattyn20-Jul-09 4:50

Luc Pattyn

20-Jul-09 4:50

My C# compiler most strongly objects D'Oh! | :doh:

Luc Pattyn [Forum Guidelines] [My Articles]

The quality and detail of your question reflects on the effectiveness of the help you are likely to get.
Show formatted code inside PRE tags, and give clear symptoms when describing a problem.

Re: scan using Twain in c#.net

DaveyM6920-Jul-09 5:18

DaveyM69

20-Jul-09 5:18

I know the feeling - I've still got a little more work to do on my MIDI wrapper, and most of the implementation has come from studying the relevant C header file rather than relying on stuff on PInvoke.net (which can be useful, but occaisionally just plain wrong) etc. It made my brain hurt - lots, which is why it's not finished yet!

read a excel and show it in datagrid c#

Bird3720-Jul-09 4:07

Bird37

20-Jul-09 4:07

Hi,
i can read a excel File but i can´t populate it on a datagrid. Can somebody help me?
That´s my code:
private void button1_Click(object sender, EventArgs e)
{
this.openFileDialog1.FileName = "*.xls";

if (this.openFileDialog1.ShowDialog() == DialogResult.OK)
{
ApplicationClass xlApplication = new ApplicationClass();
Workbook xlWorkbook = null;

Worksheet xlWorksheet = null;

Range xlRange = null;

xlApplication.Visible = false;
xlApplication.ScreenUpdating = false;
xlApplication.DisplayAlerts = false;

string workbook = this.openFileDialog1.FileName;
xlWorkbook = xlApplication.Workbooks.Open(openFileDialog1.FileName, 0, true, 5, "", "", true, XlPlatform.xlWindows, "\t", false, false, 0, true, 0, false);

xlWorksheet = (Worksheet)xlWorkbook.Worksheets[1];

}
}

Now, how can i report this excel in my datagrid?

Thanks

Re: read a excel and show it in datagrid c#

Adam R Harris20-Jul-09 5:53

Adam R Harris

20-Jul-09 5:53

Well you are on the right track.

What you have to do now is loop through the worksheet and populate a DataTable.
This can be a real pain in the ass if you don't know the "Schema" of the Worksheet.

If you know the last cell and column that data is in you can just loop through it and add new rows to the DataTable. If you don't know the last cell and column, this is where it's a pain in the ass, you have to look for them.

Once you have the data in a DataTable, just set the DataSource of your grid to the DataTable.

You can find a little bit more info on how to properly read excel here[^].

JUST REMEMBER when working with excel you actually have to loop through each open workbook / sheet and close them, pass the parameters for saving, to actually kill excel otherwise it just sits in the background taking up precious resources.

If at first you don't succeed ... post it on The Code Project and Pray.

Re: read a excel and show it in datagrid c#

Wendelldh21-Jul-09 3:52

Wendelldh

21-Jul-09 3:52

You can also use SpecialCells[Excel.XlCellType.xlCellTypeLastCell] to get the last cell.
This returns a crll which will have the last row and last column.
I beleive it just finds the last one with data.

I believe it is a member of the worksheet class.

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