ASP.NET

Crystal Reports ...and Pdf Generation

12-Jul-07 3:08

*grin* I know just what you mean, especially when it comes to CSS.

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 )

dhulipudi12-Jul-07 0:19

dhulipudi

12-Jul-07 0:19

Hello Everyone,

Can any one suggest me to get the data from database using datasets.
after that we need to generate the crystal report into PDF format..

Right now i am using vs.net 2005 we need get the data from database located in app_data in 2005 database...

so kindly suggest me how to approach this and give me step by step process...

Many Thanks
Vijay D'Oh! | :doh:

string operation

Tauseef A12-Jul-07 0:18

Tauseef A

12-Jul-07 0:18

hi guys

i am having a small problem as i am new to dot net ,,

i have a query "select * from table abc where filedabc in ? "

i am using oledbconnection

here is my string which i am passing as a parameter to my command object

like

string dept
Dept="'ITS',"
Dept = Dept & "'MECH',"
Dept = Left(Dept, Len(Dept) - 1)

dim par as new oledbparameter("name",Dept)

com.parameters.add(par)

but it doest not give me any result
command is executed withour exception

why ?
thanks in advance

hello

N a v a n e e t h12-Jul-07 0:32

N a v a n e e t h

12-Jul-07 0:32

Which is the method you are using to execute query ?

My Website | Ask smart questions

Tauseef A12-Jul-07 0:34

Tauseef A

12-Jul-07 0:34

Dim dr As OleDbDataReader = com.ExecuteReader()

hello

Christian Graus12-Jul-07 1:59

12-Jul-07 1:59

ghumman63 wrote:
Dept="'ITS',"
Dept = Dept & "'MECH',"
Dept = Left(Dept, Len(Dept) - 1)

Why on earth are you doing all of this ?

In any case, your SQL looks completely wrong to me. The word 'table' is not needed, it's an error. I can't even work out what the tail end of the query is supposed to be doing.

It looks to me like you're making it up as you go, are you also new to SQL ? Either way, if you get an exception, tell us what it is, otherwise you leave us having to guess. My guess is, it's telling you the SQL is wrong, which it is. Try putting the SQL into the query analyser first, if it doesn't run in SQL Server, or access, or whatever, it won't run when C# tries to execute 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 )

Tauseef A12-Jul-07 2:03

Tauseef A

12-Jul-07 2:03

my dear

it is

select * from tableabc where filedabc in ? "

here the space was a mistake ,, not in sql Smile | :)

)

there is no exception ,, it simply doest not get any row from the oracle server, though there
are about to 20,000
records

Smile | :)

thanks in advance

hello

Christian Graus12-Jul-07 2:56

12-Jul-07 2:56

I am surprised there is no error message, unless Oracle is different to SQL Server, or the parameter wrapping does some string mashing for you. You're passing something like

'parm1', 'parm2'

to the parameter. The correct SQL would be

select * from tableabc where filedabc in ('parm1', 'parm2')

if you take the string you're passing through and put it into the Oracle client tools, do you get any results ?

I take it your code is a simplified example, because you are in fact building a dynamic list of strings for the parameter ? Perhaps you need to post the actual code ? Or you need to at least look at the actual parameter being generated, in the debugger.

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 )

wildcard charcters

$h@ma!|@11-Jul-07 23:59

$h@ma!|@

11-Jul-07 23:59

wild card characters are used to match strings as
select * from table where name LIKE '%brown%';
but doesnt supports matching of dates,number
what will we do if we want approximate matching of dates and numbers??

$h@ma!|@

Re: wildcard charcters

Christian Graus12-Jul-07 1:56

dropdownlist + asp.net 2.0

12-Jul-07 1:56

You do a select like

select * from table where created > DATEADD(month, -1, @date) and created < DATEADD(month, 1, @date)

this searches for a date within a month on either side of the date provided.

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 )

ritu432111-Jul-07 23:39

ritu4321

11-Jul-07 23:39

i have a dropdownlist .I press control button and select two values hwo to get this two values ?

Imran Khan Pathan11-Jul-07 23:45

11-Jul-07 23:45

which two values?

best regard
Pathan

GOD HELP THOSE WHO HELP THEMSELVES

ritu432111-Jul-07 23:56

ritu4321

11-Jul-07 23:56

the two options which we had selected by pressing the control button of the listbox .

_AK_12-Jul-07 0:00

_AK_

12-Jul-07 0:00

You can loop through the items and then get the selected one from that.

Apurva Kaushal

Imran Khan Pathan12-Jul-07 0:07

12-Jul-07 0:07

what r u exectly doing here?

U have one dropdownlist, one listbox and one control button.Right?

and u want to get selected two values of listbox on click of control button.

so what about dropdownlist?

please explain clearly

Best Regard
Pathan

GOD HELP THOSE WHO HELP THEMSELVES

ritu432112-Jul-07 0:16

ritu4321

12-Jul-07 0:16

sorry for the misunderstanding which i generated .i have only one listbox control which selects more than two values by pressing contorl button. I want to have the selected values.

String drpDownVal = ((ListBox)Repeater1.Items[i].FindControl("item2")).SelectedValue.ToString();
thanks

N a v a n e e t h12-Jul-07 0:30

N a v a n e e t h

12-Jul-07 0:30

for(int i=0;i<=ListBox1.Items.Count-1;i++)
{
     if ( ListBox1.Items[i].Selected )
	Response.Write(ListBox1.Items[i].Text);
}

My Website | Ask smart questions

Imran Khan Pathan12-Jul-07 0:33

how to add user control to tool box

12-Jul-07 0:33

ListBox listbox=(ListBox)Repeater1.Items[i].FindControl("item2");
ArrayList arr=new ArrayList();
for(int i=0;i<listbox.Items.Count-1;i++)
{
if(listbox.Items[i].Selected)
arr.Add(listbox1.Items[i].Text)
}

U will get array of selected items text

Best Regard

Pathan

GOD HELP THOSE WHO HELP THEMSELVES

Vikram.....11-Jul-07 23:34

Vikram.....

11-Jul-07 23:34

Hey

i am new to asp.net.

I just made a small user control now i want to see it on a toolbox provided with visual Studio 2005 how can i do it...

Thank You
Vikram

Re: how to add user control to tool box

Imran Khan Pathan11-Jul-07 23:38