Click here to Skip to main content
15,896,207 members

Comments by M.CHAITHANYA (Top 39 by date)

M.CHAITHANYA 2-Jun-11 2:33am View    
Hi,

I dont want to go to that high level ,as my intension is to just communicate with client programatically .How to do this?
M.CHAITHANYA 28-May-11 6:10am View    
Hi,
I am sorry ,i have mistyped tblemployee .it is actually tblstudents.. I tried the following:

select * from emp where deptno =(select deptno from
(select count(e.empno)as counts,e.deptno from emp e group by deptno) a
where a.counts=(select MAX(counts) from a) );

But i ended up with an error:invalid object name 'a'.
M.CHAITHANYA 23-May-11 6:19am View    
Hi Ramalinga Koushik,

Can you please tell me how to create a report dynamically and show it through Report Viewer to the end user.

Regards
Chaithanya M
M.CHAITHANYA 23-May-11 2:27am View    
Hi,
I have the following code :


SqlConnection cn =new SqlConnection(@"Data Source=ES-SYS-692\SQL2008;Integrated Security=SSPI;Database=mydb");
cn.Open();
DataSet ds=new DataSet();

SqlDataAdapter da=new SqlDataAdapter("select empno,ename,job from emp where sal>1250",cn);
da.Fill(ds,"empds");


ReportDataSource RDS=new ReportDataSource("empds",ds.Tables[0]);


ReportViewer RV = new ReportViewer();
RV.Visible = true;


RV.ProcessingMode=ProcessingMode.Local;
LocalReport lc=RV.LocalReport;
lc.DataSources.Add(RDS);

RV.LocalReport.Refresh();


This Code in a button click,when i click on the button..i ended up with nothing..unable to get the report(generate teh report).What has to be added to this code?
M.CHAITHANYA 23-May-11 2:09am View    
I wanted to create a ReportViewer Dynamically and do all the later on stuff..dynamically only...in Windows Forms