Click here to Skip to main content
15,887,822 members
Home / Discussions / C#
   

C#

 
GeneralRe: how to change the title bar of the form in c#.net Pin
King Julien7-Apr-09 20:30
King Julien7-Apr-09 20:30 
GeneralRe: how to change the title bar of the form in c#.net Pin
EliottA8-Apr-09 3:13
EliottA8-Apr-09 3:13 
GeneralRe: how to change the title bar of the form in c#.net Pin
Rajdeep.NET is BACK7-Apr-09 20:34
Rajdeep.NET is BACK7-Apr-09 20:34 
AnswerRe: how to change the title bar of the form in c#.net Pin
#realJSOP7-Apr-09 23:48
mve#realJSOP7-Apr-09 23:48 
QuestionRecord desktop Pin
yesu prakash7-Apr-09 18:59
yesu prakash7-Apr-09 18:59 
AnswerRe: Record desktop Pin
Christian Graus7-Apr-09 19:12
protectorChristian Graus7-Apr-09 19:12 
AnswerRe: Record desktop Pin
King Julien7-Apr-09 20:24
King Julien7-Apr-09 20:24 
QuestionCrystal Report Displaying multiple data (Each row twice) . Pin
aashish.saalvi7-Apr-09 18:03
aashish.saalvi7-Apr-09 18:03 
Hi I am generating an report by using crystal report and access database in C#. the code which i have writeen works fine, but it displays multiple records. that is if there are two records to display it displays four records i.e it displays each record twice. i have executed the queries on the page load event in an dataset & binded that dataset to crystal report str1,str2,str3,str4 are the variables declared within constructor.the code i have written is displayed below.
Thanks in advance.

private void ViewPSDClearedReport_Load(object sender, EventArgs e)
{
try
{
crystalReportViewer1.DisplayGroupTree = false;

if (str3 == "All")
{
//IF NO PURCHASE GROUP IS SELECTED
MessageBox.Show("All");

ds = new DataSet();
rpt = new PSDClearedCrystalReport();

con = new OleDbConnection("Provider=Microsoft.Jet.Oledb.4.0; Data Source=e:/Ashish/Practice/ContractSystem/ContractSystem/ContractSystemDB.mdb");
con.Open();

cmd = new OleDbCommand("select * from PSDApproval where InitialPSD='" + str4 + "' and FwdDtByPSD between '" + str1 + "' and '" + str2 + "' order by FwdDtByPSD", con);
rd = cmd.ExecuteReader();

if (rd.HasRows)
{
MessageBox.Show("Record present so reading");
while (rd.Read())
{
string pr;
pr = rd.GetString(0);
MessageBox.Show("PR==" + pr);

da = new OleDbDataAdapter("select PrNo,Description,ValueQuoted,PurchaseGrp,RcdDtEA,FwdDtPSD,Initial from InitialApproval where InitialApproval.PrNo='" + pr + "'", con);
da.Fill(ds, "InitialApproval");
da.Dispose();

da1 = new OleDbDataAdapter("select EstimatedVal,FwdDtByPSD from PSDApproval where PSDApproval.PrNo='" + pr + "'", con);
da1.Fill(ds, "PSDApproval");
da1.Dispose();
}
}
rpt.SetDataSource(ds);
crystalReportViewer1.ReportSource = rpt;
MessageBox.Show("Record Added To Report");
}
else
{

}
}
catch (Exception ex)
{
MessageBox.Show("Error " + ex);
}
finally
{
con.Close();
}
}
Questioninternet explorer control Pin
jorrod7-Apr-09 15:57
jorrod7-Apr-09 15:57 
AnswerRe: internet explorer control Pin
Christian Graus7-Apr-09 17:42
protectorChristian Graus7-Apr-09 17:42 
GeneralRe: internet explorer control Pin
jorrod8-Apr-09 1:27
jorrod8-Apr-09 1:27 
QuestionMaking video call Pin
Darken19897-Apr-09 15:34
Darken19897-Apr-09 15:34 
AnswerRe: Making video call Pin
Christian Graus7-Apr-09 17:38
protectorChristian Graus7-Apr-09 17:38 
QuestionCrystal Reports Pin
CodingYoshi7-Apr-09 11:06
CodingYoshi7-Apr-09 11:06 
AnswerRe: Crystal Reports Pin
Mycroft Holmes7-Apr-09 12:28
professionalMycroft Holmes7-Apr-09 12:28 
QuestionIn search of a good PDF viewer control for .NET WinForms Pin
gongchengshi7-Apr-09 10:04
gongchengshi7-Apr-09 10:04 
AnswerRe: In search of a good PDF viewer control for .NET WinForms Pin
Christian Graus7-Apr-09 10:45
protectorChristian Graus7-Apr-09 10:45 
QuestionButton does not generate clicked events after validating textbox in a usercontrol Pin
hmvo247-Apr-09 9:44
hmvo247-Apr-09 9:44 
QuestionRTCP Packet in .net (c# or vb.net) Pin
Saurabh90907-Apr-09 9:11
Saurabh90907-Apr-09 9:11 
QuestionLaunching and Saving an Excel file from Winform Pin
DevWithDoutbs7-Apr-09 8:43
DevWithDoutbs7-Apr-09 8:43 
AnswerRe: Launching and Saving an Excel file from Winform Pin
Rolf Jaeger15-Jun-09 17:25
Rolf Jaeger15-Jun-09 17:25 
QuestionUsing StreamWriter...... Help Guys [modified] Pin
Rajdeep.NET is BACK7-Apr-09 8:32
Rajdeep.NET is BACK7-Apr-09 8:32 
AnswerRe: Using StreamWriter...... Help Guys Pin
behzadcp7-Apr-09 8:40
professionalbehzadcp7-Apr-09 8:40 
GeneralRe: Using StreamWriter...... Help Guys Pin
Rajdeep.NET is BACK7-Apr-09 8:44
Rajdeep.NET is BACK7-Apr-09 8:44 
AnswerRe: Using StreamWriter...... Help Guys Pin
Ashfield7-Apr-09 20:55
Ashfield7-Apr-09 20:55 

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.