|
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();
}
}
|
|
|
|
|
I have made a little program that when i open the IE and puts url google.com i should go to microsoft.com for exemple in the same window, but it opens a new ie windows and goes to the site can someone help.
the code
detect new ie open
private void Form1_Load(object sender, EventArgs e)
{
shellWindows.WindowRegistered += new SHDocVw.DShellWindowsEvents_WindowRegisteredEventHandler(detect_ie);
}
private void detect_ie(int z)
{
foreach (SHDocVw.InternetExplorer ie in shellWindows)
{
ie.BeforeNavigate2 += new SHDocVw.DWebBrowserEvents2_BeforeNavigate2EventHandler(ie_BeforeNavigate2);
}
}
Detects the url open and goes to new url
void ie_BeforeNavigate2(object pDisp, ref object URL, ref object Flags, ref object TargetFrameName, ref object PostData, ref object Headers, ref bool Cancel)
{
object Flags2 = Flags;
object TargetFrameName2 = TargetFrameName;
ur=URL.ToString();
int tamanho =0;
int cont =0;
while (cont < 3)
{
tamanho = tamanho + 1;
if (ur[tamanho] == '/')
{
cont = cont + 1;
}
}
ur = ur.Substring(0, tamanho);
if (ur == "www.microsoft.com")
{
URL="www.google.com";
SHDocVw.InternetExplorer ie = new SHDocVw.InternetExplorer();
URL = "www.google.com".ToString();
ie.Navigate2(ref URL, ref Flags, ref TargetFrameName, ref PostData, ref Headers);
}
|
|
|
|
|
jorrod wrote: SHDocVw.InternetExplorer ie = new SHDocVw.InternetExplorer();
Why this ? All you need to do is embedd a web browser control, you don't need to create it.
Christian Graus
Driven to the arms of OSX by Vista.
"I am new to programming world. I have been learning c# for about past four weeks. I am quite acquainted with the fundamentals of c#. Now I have to work on a project which converts given flat files to XML using the XML serialization method" - SK64 ( but the forums have stuff like this posted every day )
|
|
|
|
|
because i don´t want my program to navigate, i want the program to run in background.
|
|
|
|
|
Hi guys, does anyone of you actually knows if there are any APIs or SDKs available that will allow me to write a C# code that will make video calls using Windows Mobile as well as a Windows application that will receive that video call. I have already set up my mobile phone as a GSM Modem with relevant AT Commands to do the trick of answer a normal phone call. Is that possible? I understand that there is a 3G-324M stack available but we are required to purchase the toolkit, are there any open source toolkit available? Or is there anyway i could walk around with SDK?
Thanks in advance
|
|
|
|
|
The only place that has video support is DirectX. But, nothing in there is going to make a call for you, all it will do is handle the video streaming
Christian Graus
Driven to the arms of OSX by Vista.
"I am new to programming world. I have been learning c# for about past four weeks. I am quite acquainted with the fundamentals of c#. Now I have to work on a project which converts given flat files to XML using the XML serialization method" - SK64 ( but the forums have stuff like this posted every day )
|
|
|
|
|
I have a C# app which passes data to create a report using Crystal Reports. There is a field in the report named Sales (for example) and in the Format Editor dialog I have set the Rounding to 0.01 and Decimal to 1.00 but it keeps rounding to the nearest dime instead of penny.
Any idea what the problem might be?
I hate Crystal Reports!!!
CodingYoshi
Visual Basic is for basic people, C# is for sharp people. Farid Tarin '07
|
|
|
|
|
Why not move your rounding back a level to C# or event to the query supporting the data. Unless of course it is a calc in the report!
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Does anyone know of a good PDF viewer control for .NET? I need to just point it to a file and have it display the PDF. The API needs to include the ability to navigate through the pages. I also need to be able to print without displaying the viewer. I am using the Adobe Reader ActiveX control right now but I don't like the bar it puts on the left side of the screen and I can't print without loading the control on a form first.
modified on Tuesday, April 7, 2009 4:11 PM
|
|
|
|
|
There are some, but they are expensive. Atalasoft has one.
Christian Graus
Driven to the arms of OSX by Vista.
"I am new to programming world. I have been learning c# for about past four weeks. I am quite acquainted with the fundamentals of c#. Now I have to work on a project which converts given flat files to XML using the XML serialization method" - SK64 ( but the forums have stuff like this posted every day )
|
|
|
|
|
I have a problem with a usercontrol that does not get focused or something after
leavning the usercontrol. Using the analogy with the document outline the setup is
as follows:
WinForm
- TableLayoutPanel (with 2 rows)
------> UserControl
----------> TextBox
----------> Button (Hello world, this just shows a hello world messagebox)
------> FlowLayoutPanel
----------> Button (OK)
----------> Button (Cancel, shows a messagebox asking whether to cancel)
Now, in the textbox_validating event i check if the text is a numeric value and if
it is not i set the e.Cancel property to true. This prevents clicking on "Hello
world"-button above. However, I've set the CausesValidation property on the
Cancel-button to false since I want the user to be able to cancel the operation
even if the Textbox doesn't contain a numeric value. Now, consider this scenario:
1. Click the "Hello world" button, a mesage box shows, nothing strange here
2. Enter "abc" in the Textbox and click the "Hello world" button, no messagebox
is shown since the TextBox doesn't contain a valid numerical value.
3. Click the Cancelbutton, a messagebox appears asking whether to cancel. Answer
No here just cancels the Cancel-messagebox.
4. Fix the error in the Textbox by entering a numerical value.
5. Click on the "Hello world" button, nothing happens!!!
Here I would expect a Hello world message box but I don't get any! I get mouse_enter, and mouse_down on the Hello world button but I don't get mouse_clicked. However, and this is weird, if I press the Cancel-button, don't need to click on it, just give it a mouse_down and then click on the Hello world button, the Hello world messagebox is shown and everything works well again. What is going on here? If I move the OK, Cancel to the usercontrol it all works well but it is not an option since the OK and Cancel belongs to a surrounding framework. Anyone experienced anything like this? Any help would be much appreciated.
Thanx, Ollie
|
|
|
|
|
I want to know about RTCP Packet in .net
how can i make RTCP packet and send it to other participent of session?
I know about RTCP packet format but I dont know how to implement it?
Thanks in advance.
Saurabh Patel
|
|
|
|
|
Hi to all.
First of all, my apologies to the moderators in case this is the wrong place to post my question.
I would like to know if it is possible to implement the following:
I have a winform that will, by clicking a button, launch a specific Excel File. The user will be able to edit it and by clicking another button, the Excel file will be saved (without any other kind of prompting from the user) and Excel will be closed.
Step1: launch Excel by clicking a button
Step2: user clicks another button on the winform and that will save the Excel file and close Excel.
Now, from what I've seen so far, I can achieve the first step. My problem seems to be in the second step. I have no idea on how I can save the work the user has done on the Excel File without having to Save first in Excel.
For instance, if my Excel File is this:
A1 cell = 1234
And after the launch I change it to this:
A1 cell = 12345
If I try to save to another file by clicking the other button on the winform that file will have:
A1 cell = 1234
How can I achieve what I want?
This is the code on the launch button:
private void button1_Click(object sender, EventArgs e)
{
System.Globalization.CultureInfo CurrentCI = System.Threading.Thread.CurrentThread.CurrentCulture;
System.Threading.Thread.CurrentThread.CurrentCulture = new System.Globalization.CultureInfo("en-US");
ApplicationClass excelApp = new ApplicationClass();
Microsoft.Office.Interop.Excel.Workbook myWorkBook = excelApp.Workbooks.Open("D:\\Teste.xls", Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value);
Microsoft.Office.Interop.Excel.Worksheet mySheet = (Microsoft.Office.Interop.Excel.Worksheet)myWorkBook.Sheets["Sheet1"];
excelApp.Visible = true;
System.Threading.Thread.CurrentThread.CurrentCulture = CurrentCI;
}
This is the code for the save button:
private void button3_Click(object sender, EventArgs e)
{
System.Globalization.CultureInfo CurrentCI = System.Threading.Thread.CurrentThread.CurrentCulture;
System.Threading.Thread.CurrentThread.CurrentCulture = new System.Globalization.CultureInfo("en-US");
Microsoft.Office.Interop.Excel.ApplicationClass excelApp = new ApplicationClass();
Microsoft.Office.Interop.Excel.Workbook myWorkBook = excelApp.Workbooks.Open("D:\\Test.xls", Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value);
Microsoft.Office.Interop.Excel.Worksheet mySheet = (Microsoft.Office.Interop.Excel.Worksheet)myWorkBook.Sheets["Sheet1"];
excelApp.Save("D:\\Test1.xls");
excelApp.Quit();
System.Threading.Thread.CurrentThread.CurrentCulture = CurrentCI;
}
I have also tried this code:
private void button3_Click(object sender, EventArgs e)
{
System.Globalization.CultureInfo CurrentCI = System.Threading.Thread.CurrentThread.CurrentCulture;
System.Threading.Thread.CurrentThread.CurrentCulture = new System.Globalization.CultureInfo("en-US");
Microsoft.Office.Interop.Excel.ApplicationClass excelApp = System.Runtime.InteropServices.Marshal.GetActiveObject("Excel.Application") as Microsoft.Office.Interop.Excel.ApplicationClass;
Microsoft.Office.Interop.Excel.Workbook myWorkBook = excelApp.Workbooks[1];
Microsoft.Office.Interop.Excel.Worksheet mySheet = (Microsoft.Office.Interop.Excel.Worksheet)myWorkBook.Sheets["Sheet1"];
Microsoft.Office.Interop.Excel.Range dataRange = (Microsoft.Office.Interop.Excel.Range)mySheet.Cells["1", "A"];
excelApp.Save("D:\\Test2.xls");
System.Threading.Thread.CurrentThread.CurrentCulture = CurrentCI;
}
However, when I try this code, I end up with this exception:
System.Runtime.InteropServices.COMException was unhandled
Message="Exception from HRESULT: 0x800A03EC"
Source="Microsoft.Office.Interop.Excel"
ErrorCode=-2146827284
StackTrace:
at Microsoft.Office.Interop.Excel.ApplicationClass.Save(Object Filename)
Is it possible, what I want to achieve? Being able to save programatically from my winform an edited Excel file? If so, what am I doing wrong?
I would apreciate if anibody could point me to the right direction.
Thanks in advance
|
|
|
|
|
It seems to me that the following changes to your code should do the trick:
1) Declare myWorkbook as a class-level variable (as opposed to placing the declaration inside the event handlers
2) Use myWorkbook.SaveAs({new xls file name}, lots of missing values..)
Hope this is still helping (2 months after you posted this questions...),
Rolf
|
|
|
|
|
I am using the following Text/StreamWriter process to write to a Text file:
{
TextWriter tr=new StreamWriter("C:/Streamfile.txt");
tr.WriteLine("This line has been written by the StreamWriter process");
tr.Close();
}
However, if I want to write to a VBScript file or a Jscript file, then what manipulation will I have to do to the above code, such that I am able to write to those script files? Please help me guys.
Thank you,
Rajdeep.NET 
modified on Tuesday, April 7, 2009 2:38 PM
|
|
|
|
|
i think you must select file encoding
utf8 or utf32
|
|
|
|
|
What? How will I select file encoding utf8 or utf32? help 
|
|
|
|
|
If I have understood you correctly, you want to generate a VBscript or Jscript file from within your C# app. All you have to do is write the contenst of the fiel exactly like you would in notepad or whatever. You would probably want to change the file extension (to .vbs for the VBScript file), but thats all, there is nothing special about it.
Bob
Ashfield Consultants Ltd
Proud to be a 2009 Code Project MVP
|
|
|
|
|
Try using this code:
private void btnSave_Click(object sender, EventArgs e)
{
FileDialog salvareFisier = new SaveFileDialog();
salvareFisier.Filter = "Text files (*.txt)|*.txt";
if (salvareFisier.ShowDialog() == DialogResult.OK)
{
FileStream fisier = new FileStream(salvareFisier.FileName, FileMode.Create, FileAccess.Write);
addText(fisier,"your _text _ here ");
addText(fisier, "\r\n");
fisier.Close();
}
else
MessageBox.Show("Data has not been saved");
}
public static void addText(FileStream f, string valoare)
{
byte[] info = UTF8Encoding.Default.GetBytes(valoare);
f.Write(info, 0, info.Length);
}
Regards,
Alex
|
|
|
|
|
hi every one
how to add control to gridcontrol with syncfusion
|
|
|
|
|
You should ask your question in the SyncFusion forums.
Religiously blogging on the intarwebs since the early 21st century: Kineti L'Tziyon
Judah Himango
|
|
|
|
|
Hola gente, como andan?...
Tengo un gran inconveniente y en ningún lado puedo encontrar la respuesta. A ver si me ayudan.
Necesito crear una búsqueda de Pacientes que se encuentran en un Datagridview. Como lo puedo hacer?. Estoy trabajando con C# en .NET.
Dejo una imagen del formulario que estoy usando para tal fin: http://img21.imageshack.us/img21/9820/buscars.png
Espero que alguien pueda ayudarme.
|
|
|
|
|
This is an English speaking site.
Christian Graus
Driven to the arms of OSX by Vista.
"I am new to programming world. I have been learning c# for about past four weeks. I am quite acquainted with the fundamentals of c#. Now I have to work on a project which converts given flat files to XML using the XML serialization method" - SK64 ( but the forums have stuff like this posted every day )
|
|
|
|
|
Hola Hola Jingalala Jingalala Twinkle twinkle little star Hola Gente mente tente lingrie! How's that  ?
|
|
|
|
|
Why you don't search for filter proeprties of Datagridview.
Check this.[^]
I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
