|
i have column called receipt_no, student_id, paid_amt, Bal_amt
he paid for 4 installment, after 4th he paid fully. in database 4 rows is there. but thata student now paid. i should not select that student and the student who paid less than total i am able to select that student details. but if 3 rows or 4 rows means i am not able to select. How it can be selected. Any suggestion please reply.
i written code like below
select * from bed_fee where Bal_amt >0 and paid < 30000
but here it will select upto 3 rows but he paid like below
receipt_no stud_id paid bal total
243 815 10000 20000 30000
244 815 15000 50000 30000
245 815 3000 2000 30000
246 815 2000 0 30000
if 4 th rows is not there means i need to select that student. if 4th row is there means bal is 0 i should not select
how can i write select query here
|
|
|
|
|
First this is not SQL forum
However you can do one thing first find the students who does not paid total balance amount and select only those students. may be like
SELECT A.* FROM bed_fee AS A
WHERE EXISTS (
SELECT stud_id FROM bed_fee WHERE A.stud_id = bed_fee.stud_id
GROUP BY stud_id
HAVING SUM(total ) <> SUM(paid)
)
|
|
|
|
|
thank you for replying. Now it is working.
|
|
|
|
|
Hi,
your data is redundant so there must be several solutions; try one of these(untested):
SELECT stud_id WHERE sum(paid)<total GROUP BY stud_id ORDER BY stud_id
SELECT DISTINCT stud_id WHERE stud_id NOT IN (SELECT stud_id WHERE bal=0)
|
|
|
|
|
sr159 wrote: i have column called receipt_no, student_id, paid_amt, Bal_amt
First go back and correct your schema.
|
|
|
|
|
Hi,
Is it necessary to have .Net Framewrok installed to you power shell?
regards,
NetQuestions
|
|
|
|
|
Yes, for further information see this page[^].
It's time for a new signature.
|
|
|
|
|
hi,
I thought in the namespace System.Management, I would find classes / methods or rather some interface
that I can use to get some management information, say about IIS.
But System.Management only has attributes like 'ManagementConfigurationAttribute' which states that
the property is read-only.
So how do I get the interface to access information about IIS in a console application.
Regards,
NetQuestions
|
|
|
|
|
What kind of information are you speaking about? You can use WMI for information about IIS. See if this[^] helps.
|
|
|
|
|
Hi,
I have gridview.
I need to export the data to excel and zip it
I had used dot net zip free dll
The zip file is not having the excel.
Need help how to include the excel file in zip
the below code creates zip file
using Ionic.Zip;
using System.Text;
using System.IO;
using Ionic.Zlib;
protected void btn_Export_Click(object sender, EventArgs e)
{
HtmlForm form = new HtmlForm();
string attachment = "attachment; filename=Employee.xls";
Response.ClearContent();
Response.ContentType = "application/ms-excel";
System.IO.StringWriter stw = new System.IO.StringWriter();
HtmlTextWriter htextw = new HtmlTextWriter(stw);
form.Controls.Add(grd);
this.Controls.Add(form);
form.RenderControl(htextw);
var filesToInclude = new System.Collections.Generic.List<String>();
if (filesToInclude.Count == 0)
{
Response.Clear();
Response.BufferOutput = false;
System.Web.HttpContext c = System.Web.HttpContext.Current;
//string archiveName = String.Format("Employee.zip", DateTime.Now.ToString("yyyy-MMM-dd-HHmmss"));
string archiveName = String.Format("archive-{0}.zip", DateTime.Now.ToString("yyyy-MMM-dd-HHmmss"));
Response.ContentType = "application/zip";
Response.AddHeader("content-disposition", "filename=" + archiveName);
// ZipFile zip = new ZipFile();
using (ZipFile zip = new ZipFile())
{
//zip.AddFile("export.xls", "content");
zip.Encryption = EncryptionAlgorithm.WinZipAes256;
// filesToInclude is a string[] or List<String>
zip.AddFiles(filesToInclude, "files");
zip.Save(Response.OutputStream);
// zip.Save(archiveName);
}
Response.Close();
}
}
Thanks
S.Guhananth
|
|
|
|
|
Member 3222264 wrote: //zip.AddFile("export.xls", "content");
..why is that line commented out?
I are Troll 
|
|
|
|
|
tried
zip.Addfile("export.xls","content");
getting this error
C:\Program Files\Common Files\Microsoft Shared\DevServer\10.0\Employee.xls
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.IO.FileNotFoundException: C:\Program Files\Common Files\Microsoft Shared\DevServer\10.0\Employee.xls
|
|
|
|
|
Member 3222264 wrote: tried
That was the part that seemed to be used to add files to the zip-archive. An empty list of files will result in an empty archive.
Member 3222264 wrote: getting this error
Check if the file below exists;
C:\Program Files\Common Files\Microsoft Shared\DevServer\10.0\Employee.xls
If the file doesn't exist, then it won't be added to the archive. Make sure you call the code that creates the Excell-file before adding it to the list.
I are Troll
|
|
|
|
|
while exporting to excel how the file will be in this path
the below works fine to export it as excel
HtmlForm form = new HtmlForm();
string attachment = "attachment; filename=Employee.xls";
Response.ClearContent();
Response.AddHeader("content-disposition", attachment);
Response.ContentType = "application/ms-excel";
System.IO.StringWriter stw = new System.IO.StringWriter();
HtmlTextWriter htextw = new HtmlTextWriter(stw);
form.Controls.Add(grd);
this.Controls.Add(form);
form.RenderControl(htextw);
Response.Write(stw.ToString());
Response.End();
but i do not know why the Employee.xls is not attached to excel
Do u have sample code to zip the file and export?
|
|
|
|
|
Member 3222264 wrote: but i do not know why the Employee.xls is not attached to excel
Well, the above code doesn't generate a file on disk. And that's what the code that's doing the zipping is expecting.
Member 3222264 wrote: while exporting to excel how the file will be in this path
What data is in that streamwriter? ..and what happens if you write that data to a file?
I are Troll
|
|
|
|
|
Please read the forum guidelines and use pre tags when posting code.
I know the language. I've read a book. - _Madmatt
|
|
|
|
|
in crystal report whatever i am sending through dataset, all the columns of the database it is displaying in crystal report but only date column field is not binding. It is not getting value. but in dataset the date column has a value. Reply . Thanks in advance.
|
|
|
|
|
using mysql select query, i am sending dataset to crystal report and i am getting the result. But i want get only one row for particular ID. We are making 3 or more times transaction. So 3 rows is coming. For taking only one row, how to write formula in total field in crystal report so that it will add all those amount for that particular id and display only one row with the sum of that amount. thanks in advance.
|
|
|
|
|
Hi,
In winforms or wpf application, lets say there is one container control which adds controllers dynamically and it also adds event handlers of that child controls.
Now if I call a clear method of the parent container control, will the event handlers added be removed automatically?
If not and I dont remove them (event handlers), will it create any other issue?
Please suggest!
Thanks,
Divyesh
|
|
|
|
|
when you clear a container control, it disposes of all the contained controls; each control will be available for garbage collection, and the event members they contain will have no influence, just like any other data members. There is no need to remove handlers at all.
BTW: The same applies to a modeless form that gets closed.
|
|
|
|
|
Hi
Is there a way of installing other software such as MySQL in a setup project. If so is it also possible to execute a script to create a database?
Thanks
|
|
|
|
|
|
In C#2.0,the Codedom library how to generate the method of foreach? 
|
|
|
|
|
A foreach is actually a convenience wrapper around a loop with an enumerator. That's what you need to enumerate over. Try to create a CodeDOM for this instead:
IEnumerator e = item.GetEnumerator();
while(e.MoveNext())
{
myList.Add(ConvertToObject(item));
}
"WPF has many lovers. It's a veritable porn star!" - Josh Smith As Braveheart once said, "You can take our freedom but you'll never take our Hobnobs!" - Martin Hughes.
My blog | My articles | MoXAML PowerToys | Onyx
|
|
|
|
|
Hi,
I have an application in C# that use SQL Server 2008 R2 Express.
When i install the package i need to choose option and to install:
1. Microsoft .Net Framework 3.5 SP1.
2. Windows Installer 4.5.
3. Windows PowerShell 1.0
I have an SQL Script that will build my DB at SQL 2008 R2 Express and will add the user configuration that i want.
I want to make install package that will include the SQL 2008 R2 Express (including "Microsoft .Net Framework 3.5 SP1.",
,"Windows Installer 4.5" and "Windows PowerShell 1.0 ").
Will run the script and install my application.
I don't want to let the user to choose configuration for the DB in the installation process.
How can i do that?
Thanks,
Shai.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
