|
//Below is my code, I want to show employee detail on the bases of employee id.
//I use pubs database of SQL Server [Winform C#.Net]
=========================================================
<b>//Crystal Report Object
CrystalReport1 cp = new CrystalReport1();
//
private void Form2_Load(object sender, System.EventArgs e)
{
try
{
SqlConnection con = new SqlConnection("server=SK- WAQAS;uid=****;pwd=***;database=pubs");
SqlDataAdapter dsemp = new SqlDataAdapter("Select * From employee where emp_id=" + textBox1.Text.Trim(), con);
DataSet ds = new DataSet();
dsemp.Fill(ds,"employee");
cp.SetDataSource(ds);
//cp.SetParameterValue("emp_id",”AMD15433FDBT39435M”);
con.Close();
}
catch(Exception ce)
{
MessageBox.Show(ce.Message);
}
}</b>
=====================================================
Please tell where i do wrong.
|Muhamad Waqas Butt|
waqasb4all@yahoo.com
www.sktech.freewebspace.com
|
|
|
|
|
Hi all,
Is there any win32 api which can give me information about whenever a folder or file is double clicked right clicked or the folder is being expended in the windows explorer view.right click i can catch with icontextmenu and may be the expension in the explorer by the icolumnprovider(i am not sure about this) but how to catch the double click event.Is there any single api which can get the job done and is reliable.Any help will be greatly appreciated.Plz it's urgent.Thanks in advance.
|
|
|
|
|
No, there isn't. What are you trying to do accomplish with this?
|
|
|
|
|
Hi Friends
How can i generate standard Deviation graph? I have calculate mean and standard Deviation according to Array of values but How can i Plot Graph??
|
|
|
|
|
|
I am developing own library for Graph so plz give me any idea or sample code.
|
|
|
|
|
I never worked with GDI+ myself.
To get an example take a look at the source code of the library i suggested or explore the documentation of the System.Drawing namespace especially of the Graphics class.
www.troschuetz.de
|
|
|
|
|
I beleive a standard deviation graph can be done with just lines. There is a quick-and-dirty way to do this, by overriding the Paint event of a PictureBox and drawing on the pictures Graphics object. But, depending on how frequently the graph gets updated or the screen gets redrawn, you can see flicker when the pic is redrawn.
You could create a full custom control, with properties to accept an array of data, and custom drawing done in the OnPaint protected method. The actual logic for drawing the graph will completely depend on how you represent, store, and pass in the data being graphed, so I can't give you much example code there.
Just create a new Custom Control in your project, and override the OnPaint method (inherited from the System.Windows.Forms.Control class).
|
|
|
|
|
int a = 1.76543
how to i print out in such it way it'll only display 1.76?
|
|
|
|
|
If you're sure you'll always get d.dddd, you can simply multiply it by 100 (or the number of digits you want after the decimal point, cast it to an int and divide back by 100. Something like
double a = 1.76543;
int x = ((int)(a * 100)))/ 100.00;
Regards
Senthil
_____________________________
My Blog | My Articles | WinMacro
|
|
|
|
|
a.ToString("0.00") should do the job.
For some more information on formatting of numeric strings take a look at this page[^].
www.troschuetz.de
|
|
|
|
|
double a = 1.76543;
Console.WriteLine("{0:F2}", a);
|
|
|
|
|
Hi,
I have a little (very small) app that use too much memory, how can i release resources that are not in use (loaded dll's that are no more necesary for example and all type of garbage that can be disposed) whithout closing my app of course?
When i load a dll can i unload it when it's not needed and my app is in idle?
I saw in a post a few days ago (and can't find it again) an instruction to unload resources when the app is close, if some one can provide me that line of code, this is for making sure i release resources.
Thanx.
|
|
|
|
|
If you want to unload DLLs, you need to load them on a separate AppDomain. How did you conclude your app is using too much memory?
Regards
Senthil
_____________________________
My Blog | My Articles | WinMacro
|
|
|
|
|
With windows task manager (CTRL + ALT + DEL).
|
|
|
|
|
Make sure you are calling Dispose() on objects when you don't need them anymore (Controls, Pens, Brushes, Graphics, Bitmaps etc.).
You cannot unload dlls (you would need to load them in separate appdomains which would create even more overhead).
Note that Task Manager does not really show the memory usage of your app, it counts the memory used by the .NET Framework for every application, but in reality large parts of that memory are shared between multiple .NET processes.
|
|
|
|
|
Hi, you're right. Task manager does not really show the memory usage of my app. I tested it, i created a minimal app (a single and empty form) and it uses 10 MB of memory and a single and empty form does not require such amount of memory. My real app loads lots of resources, objects and dll's and it uses 15 MB, it's not a bad score at all!
I'll try Dispose() for objects that are not useful anymore and support this method, thanx for your help.
|
|
|
|
|
Heinz Suez wrote:
Hi, you're right. Task manager does not really show the memory usage of my app. I tested it, i created a minimal app (a single and empty form) and it uses 10 MB of memory and a single and empty form does not require such amount of memory. My real app loads lots of resources, objects and dll's and it uses 15 MB, it's not a bad score at all!
What it comes down to is that getting and returning memory from the system are very expensive operations. Since modern computers have alot more ram that was the case in the bad old days instead of repeatedly asking for small chunks and taking the hit from context switching with the OS every time .net asks for large chunks and holds onto the excess for a very long time unless the OS asks it to return any unused memory the app is holding onto.
|
|
|
|
|
my idea is to communicate one mobile with another mobile ,the first mobile is connected to a system ,when there is a critical event happend in the system then the system send the message to the connected mobile and this mobile is automatically redirect the message to the corresponding second mobile.Is it is possible or not .if it is possible please help me.Also expect code example.
|
|
|
|
|
Just for give you hope. I think everthing is posible in programming. But your work looks a very heavy task. Most mobiles use rs232 ports to comunicate with the pc even those usb mobiles (they use a usb to com converter chip, some of them anyway) so you could start playing with com ports. It's not too much help.
|
|
|
|
|
I was just trying to use some of the System.Net classes and im finding out that some of them are obsolete, but i've seen people all around still using them, and i havent found another class to use instead. What am i supposed to do?
|
|
|
|
|
Here[^] is a link to MSDN's available download of deprecated API members. Most of them provide alternate suggestions.
Deprecated, of course, does not mean deleted. It's a way to get people started on their migration without leaving them holding the bag. Of course, ignoring the deprecation is done at one's own risk.
Good luck.
The most exciting phrase to hear in science, the one that heralds the most discoveries, is not 'Eureka!' ('I found it!') but 'That's funny...’
|
|
|
|
|
I appreciate the link to the ".NET Framework 2.0 Beta 2 Obsolete APIs", it does say which classes and methods are obsolete, and it says also what to use instead, but what if i dont have .NET Fx 2.0, how can my code work in both versions, 1.x and 2.0.
|
|
|
|
|
Had anybody found that DataColumn.Expression sometime is valid and sometime is invalid?
If the DataTable which have a column define DataColumn.Expression binding a DataGrid which has a GridTableStyle, when your edit the grid and change the cloumn value which relation with the column has set 'Expression', the relation column MUST NOT calculate and display a new value.
If I use DataTable.New to create a new DataRow and set value to the columns(not needn't set value to the column has set 'Expression'), and then use DataTable.Row.Add to add a new row, it sometimes can calculate and display a new value. But if I change the column's name and accordingly modify Expression's value, sometimes you surprise to found that it can not work, why?
=== Game is power! ===
-- modified at 23:24 Thursday 29th September, 2005
|
|
|
|
|
Haha..., I got the answer myself.
If you write the sentence
this.dataColumn.Expression="Col1 * Col2";
after
((System.ComponentModel.ISupportInitialize)(this.dataTable)).EndInit();
then it will work right.
But if the code generate by IDE wizzard, it gererate the dataColumn code at the front part, and the sentence '(...).EndInit()' is generate at //Formxx part which must be generated at the end of mothed InitializeComponent(), so, the 'Expression' can not work.
As the said, if you want to use 'DataCloumn.Express' property, the good way is written the code yourself after InitializeComponent().
=== Game is power! ===
-- modified at 1:37 Friday 30th September, 2005
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
