C# Discussion Boards - CodeProject

Re: Crystal Report Problem !!!

24-Nov-07 4:32

Hi all ,
Using c# windows forms.

I have got 2 forms ; First is Main Form . Second is Report Form.

In my First Form , i have got a DataGridview Object.Im sorting selecting from db and send it to datagridview.It shows my Records. And a Button named "Report It.". Everything is OK.

In my second form , i have got a Crystral Report viewer obj.

Problem is ;

When i click "Report It" button thats in MY First Form.I want get the values from Datagridview obj. than send it to Crystal Report Obj thats in the MY Second Form and SHOW IT.!!!

its so simple isnt it ?

But i cant it. trying to do it from 2-3 weeks. Cry | :((

Paul Conrad24-Nov-07 4:45

Paul Conrad

24-Nov-07 4:45

tr_thorn wrote:
its so simple isnt it ?

Yes, it is. Read the following article: http://www.codeproject.com/dotnet/passingvaluesbetweenforms.asp[^]

You should be able to pass the datagridview object using the methods the author talks about.

"Any sort of work in VB6 is bound to provide several WTF moments." - Christian Graus

Re: Crystal Report Problem !!!

tr_thorn25-Nov-07 7:35

Re: Crystal Report Problem !!!

25-Nov-07 7:35

this isnt what i want Smile | :)

.. Iam a newbie programmer Smile | :)

i want example please.

Paul Conrad25-Nov-07 7:49

Paul Conrad

25-Nov-07 7:49

tr_thorn wrote:
this isnt what i want

Then what is? The article shows how to pass values from one form to another. You can extend this by passing the whole object from one form to the next using the same principles that Colin talks about.

tr_thorn wrote:
Iam a newbie programmer

I am not being harsh, but it sounds like you've bit off more than you can chew at this point.

You could always make the datagridview object be public and just grab it from the second form.

"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon

Syntax error (SQL query)

drawmylyfe24-Nov-07 4:26

drawmylyfe

24-Nov-07 4:26

hi all,
im now doing the 'SearchEvent' using asp.net & C# on visualstudio2005,
where the user will search the event by selecting from the 3 dropdown boxes:
dropdownDay, dropdownMonth and dropdownYear.

It's suppose to query the 'start_date' from the ms access.
eg. 10-Mar-2004

im trying to write the query on it, but i kept getting the error when i run.

query:
string query = "SELECT code, description, start_date, start_time, venue FROM Event WHERE start_date = '" + dropdownDay.SelectedIndex.ToString() + " + ' - ' + " + dropdownMonth.SelectedIndex.ToString() + " + ' - ' + " + dropdownYear.SelectedIndex.ToString() + "' +";

Error message that appeared in visualstudio2005:
Syntax error (missing operator) in query expression 'start_date LIKE '%10 + ' - ' + 3 + ' - ' + 8%' +'.

i would appreciate some help on this line of code.
thanks! =D

Smile | :)

Re: Syntax error (SQL query)

Xmen Real 24-Nov-07 4:30

Re: problem displaying gridview

24-Nov-07 4:30

your query is looking wrong
try this one

string query = "SELECT code, description, start_date, start_time, venue FROM Event WHERE start_date = '" + dropdownDay.SelectedIndex.ToString() + "' - '" + dropdownMonth.SelectedIndex.ToString() + "' - '" + dropdownYear.SelectedIndex.ToString() + "'";

Becoming Programmer...

drawmylyfe24-Nov-07 5:40

drawmylyfe

24-Nov-07 5:40

thanks for the fast reply. Smile | :)

there isn't any error now, but i encounter some problems displaying my result in the gridview table.

when i run it, it doesn't displays any table/data at all, unlike my previous 'search by description' which is able to display out.

OleDbConnection conn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source =" + Server.MapPath("myFile..mdb") + ";");
            conn.Open();
            string query = "SELECT code, description, start_date, start_time, venue FROM Event WHERE start_date = '" + dropdownDay.SelectedIndex.ToString() + "' - '" + dropdownMonth.SelectedIndex.ToString() + "' - '" + dropdownYear.SelectedIndex.ToString() + "'"; 
            
            OleDbDataAdapter comm = new OleDbDataAdapter(query, conn);
            DataSet ds = new DataSet();
            comm.Fill(ds);
            GridView1.DataSource = ds;
            GridView1.DataBind();

@__@ could you kindly guide me on this part?
thanks alot..

Blush | :O

Read SQL Connection From a text file

tr_thorn24-Nov-07 1:58

24-Nov-07 1:58

How can i read sqlconnection string from a text file.

pmarfleet24-Nov-07 2:06

pmarfleet

24-Nov-07 2:06

tr_thorn wrote:
How can i read sqlconnection string from a text file.

Why would you want to do that? You would typically store connection strings in the ConnectionStrings section of your app.config/web.config.

If you must read it from a text file, use the ReadAllText[^] method.

Paul Marfleet

"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush

Xmen Real 24-Nov-07 2:36

24-Nov-07 2:36

use System.IO.File.ReadAllText or System.IO.File.ReadAllLines

hope it will help

Becoming Programmer...

tr_thorn24-Nov-07 2:51

24-Nov-07 2:51

can anyone gimme an example?

i m using windows forms c#.

Xmen Real 24-Nov-07 2:57

24-Nov-07 2:57

SqlConnection dataConnection = new SqlConnection();
string connection = File.ReadAllText(filepath);
dataConnection.ConnectionString=connection;

hope it will help

Becoming Programmer...

tr_thorn24-Nov-07 3:28

Disable Just-in-time debugger

24-Nov-07 3:28

thank ya.

DataGrid

mehrdadov24-Nov-07 1:23

mehrdadov

24-Nov-07 1:23

I have a DataGrid Object and I've binded a data set to it. It works correctly but I want to change caption on column header but those is always name of field in database please help me to change it thanks.

Agh

Re: DataGrid

cofaone25-Nov-07 3:14

cofaone

25-Nov-07 3:14

May be you can change the sql used for binding...
for example,you could change "select id from user" into "select id as '<%=what you want%>' from user "...
I am not sure you get my meaning for my bad english. Smile | :)

My home:http://hi.baidu.com/dotnetcampus

mehrdadc4824-Nov-07 1:15

mehrdadc48

24-Nov-07 1:15

hi,
I want to run a delphi application, but Just-in-time debugger of VS 2005 shows and don't permit to run it.
how can I temporarily disable it?

Best wishes

Re: Disable Just-in-time debugger

Vasudevan Deepak Kumar24-Nov-07 2:32

Vasudevan Deepak Kumar

24-Nov-07 2:32

Check out this

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=274145&SiteID=1[^]

Vasudevan Deepak Kumar
Personal Homepage
Tech Gossips

A pessimist sees only the dark side of the clouds, and mopes; a philosopher sees both sides, and shrugs; an optimist doesn't see the clouds at all - he's walking on them. --Leonard Louis Levinson

Re: Disable Just-in-time debugger

W. Kevin Hazzard24-Nov-07 9:59

W. Kevin Hazzard

24-Nov-07 9:59

Google for the AeDebug registry key.

Kevin
Kevin Hazzard's Brain Spigot

setting page setup dialog

Xmen Real 24-Nov-07 0:57