Click here to Skip to main content
16,005,316 members
Home / Discussions / C#
   

C#

 
AnswerRe: how to add function to Explorer's context menu Pin
Heath Stewart19-Apr-04 8:57
protectorHeath Stewart19-Apr-04 8:57 
GeneralControl Arrays Pin
SanShou19-Apr-04 7:09
SanShou19-Apr-04 7:09 
GeneralRe: Control Arrays Pin
Heath Stewart19-Apr-04 8:50
protectorHeath Stewart19-Apr-04 8:50 
GeneralOpenfiledialog Pin
Appelz19-Apr-04 4:52
Appelz19-Apr-04 4:52 
GeneralRe: Openfiledialog Pin
Jon G19-Apr-04 4:54
Jon G19-Apr-04 4:54 
GeneralRe: Openfiledialog Pin
Heath Stewart19-Apr-04 5:06
protectorHeath Stewart19-Apr-04 5:06 
GeneralRe: Openfiledialog Pin
Heath Stewart19-Apr-04 5:05
protectorHeath Stewart19-Apr-04 5:05 
GeneralNeed help with crystal reports in C# Pin
AAQ19-Apr-04 4:51
AAQ19-Apr-04 4:51 
dear all,
i am using crystal reports for vs.net 2002, infact i want to set my report datasource as dataset. i am using AddCommand to reterive required fields. problem is that when i set report data source as dataset it shows all those reocrds on report that are retrived by AddCommand not by my
here is my code

private DataSet myDs()
{
SqlConnection nwindConn = new SqlConnection("DataSource=localhost;Integrated Security=SSPI;Initial Catalog=testDB");
SqlCommand selectCMD = new SqlCommand("testPorcedure",nwindConn);
selectCMD.CommandType = CommandType.StoredProcedure;
selectCMD.CommandTimeout = 30;
SqlDataAdapter custDA = new SqlDataAdapter();
custDA.SelectCommand = selectCMD;
nwindConn.Open();
custDA.Fill(custDS);
nwindConn.Close();
return custDS;
}

override protected void OnInit(EventArgs e)
{
InitializeComponent();
base.OnInit(e);
this.ConnectionString();
CrystalReport1 oReport = new CrystalReport1();
oReport.SetDataSource(this.myDs());//dataset that is filled by my sp
crTableLogonInfos = new TableLogOnInfos();
crTableLogonInfo = new TableLogOnInfo();
crConnectionInfo = new ConnectionInfo();
crConnectionInfo.ServerName = server;
crConnectionInfo.DatabaseName = database;
crConnectionInfo.UserID = user_id;
crConnectionInfo.Password = password;
crTableLogonInfo.ConnectionInfo = crConnectionInfo;
crTableLogonInfo.TableName = "Command";
crTableLogonInfos.Add(crTableLogonInfo);
CrystalReportViewer1.LogOnInfo = crTableLogonInfos;

CrystalReportViewer1.ReportSource = oReport;
CrystalReportViewer1.DataBind();
}
any body kindly help me i realy stuck
thanks in advance

GeneralRe: Need help with crystal reports in C# Pin
Heath Stewart19-Apr-04 5:09
protectorHeath Stewart19-Apr-04 5:09 
GeneralRe: Need help with crystal reports in C# Pin
AAQ19-Apr-04 19:51
AAQ19-Apr-04 19:51 
GeneralRe: Need help with crystal reports in C# Pin
Heath Stewart20-Apr-04 3:29
protectorHeath Stewart20-Apr-04 3:29 
GeneralC# CF image processing Pin
icem4n19-Apr-04 4:36
icem4n19-Apr-04 4:36 
GeneralRe: C# CF image processing Pin
Heath Stewart19-Apr-04 4:40
protectorHeath Stewart19-Apr-04 4:40 
GeneralRe: C# CF image processing Pin
Christian Graus19-Apr-04 11:47
protectorChristian Graus19-Apr-04 11:47 
GeneralRe: C# CF image processing Pin
icem4n19-Apr-04 17:18
icem4n19-Apr-04 17:18 
GeneralRe: C# CF image processing Pin
Christian Graus19-Apr-04 17:26
protectorChristian Graus19-Apr-04 17:26 
GeneralRe: C# CF image processing Pin
icem4n23-Apr-04 17:11
icem4n23-Apr-04 17:11 
GeneralAI programming using C#.Net Pin
sreejith ss nair19-Apr-04 4:09
sreejith ss nair19-Apr-04 4:09 
GeneralRe: AI programming using C#.Net Pin
Heath Stewart19-Apr-04 4:43
protectorHeath Stewart19-Apr-04 4:43 
GeneralRe: AI programming using C#.Net Pin
Tom Larsen19-Apr-04 6:36
Tom Larsen19-Apr-04 6:36 
GeneralRe: AI programming using C#.Net Pin
leppie19-Apr-04 9:43
leppie19-Apr-04 9:43 
GeneralRe: AI programming using C#.Net Pin
HAHAHA_NEXT19-Apr-04 11:42
HAHAHA_NEXT19-Apr-04 11:42 
GeneralRe: AI programming using C#.Net Pin
Mikko Puonti19-Apr-04 12:44
Mikko Puonti19-Apr-04 12:44 
GeneralAI programming using C#.Net Pin
Anonymous19-Apr-04 4:08
Anonymous19-Apr-04 4:08 
GeneralDirectory Picker Pin
bertcox19-Apr-04 3:38
bertcox19-Apr-04 3:38 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

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