.NET (Core and Framework)

Nader Elshehabi3-Aug-10 21:28

Nader Elshehabi

3-Aug-10 21:28

Hello

SilverLight 4 is a good choice for you. The Out Of Browser -aka OOB- has major improvements. I did an application for Mac this way in SilverLight 3 but the experience were't rich. Two major improvements that could have saved me a lot of trouble are the elevated permissions and the printing support.

Also porting your WPF to Silverlight is a bit easy as both rely on Xaml and Silverlight is just a subset of WPF. As for the database; the typical solution is to put your database on a windows server and communicate using services. If your program is a stand alone and this is not an option you can use some of the embedded DB engine. I don't remember any now but I remember I saw a few names to use back when I made my app.

If you use LINQ and your data access isn't huge or demanding your can switch your (LINQ to SQL) to (LINQ to Xml) and store your data as an Xml file.

P.S.
Make good analysis on the OOB in SilverLight 4. There could be some features in your program not covered.

Regards

bahalana4-Aug-10 3:47

bahalana

4-Aug-10 3:47

If your program is a stand alone and this is not an option you can use some of the embedded DB engine. I don't remember any now but I remember I saw a few names to use back when I made my app.

OS X comes with SQLite "built in", perhaps this is a possibility...

Adar Wesley3-Aug-10 22:17

Adar Wesley

3-Aug-10 22:17

The mono project has a tool named Moma which is designed to help you figure out
what is missing from mono for a particular project you want to port.

Run the tool on your current implementation and you should be able to find out
what is missing from mono.

Moonlight has full support for Silverlight 2.0.

Hope this helps.

---
Adar Wesley

Jason Christian4-Aug-10 6:33

Jason Christian

4-Aug-10 6:33

Haven't done it, but the Mono site has an analysis tool that will help you figure out how much effort is needed. It basically checks the compatibility of the BCL calls with what is available in Mono.

Member 43722424-Aug-10 7:17

Member 4372242

4-Aug-10 7:17

You can consider using the following technologies on Mac:
1) Silverlight 4 as a replacement for WPF (the most closest approximation though not 100% complete)
2) SQLite as a replacement for SQL CE (Mono has good support for SQLite)
3) In this case, you will need to re-design your app to support multiple layers (DAL/BLL exposed via WCF - it is partially supported by Mono, specifically for Mac), UI layer running on Silverlight.
This is what I would do if I were in your shoes.

how to display the student who is in due - there are 4 rows, in 4th row he paid balance amt so i should not select that student and the who paid less than total i need to select that student

Chris Trelawny-Ross4-Aug-10 13:04

Chris Trelawny-Ross

4-Aug-10 13:04

Is it an option to use a VM?

You could run the app in a VM hosting Windows in 'integrated' mode (or whatever its called) and the app will appear to be running 'like a native app' (i.e. without being inside the VM's virtual desktop). I think VMWare has a Mac version; Parallels is the other major VM for the Mac.

If its politically acceptable to the client to do this, it might be much cheaper (VM license + Windows license + small amount of work) to go this route than the porting route. Of course, there are maintenace burdens once you have a VM that hosts something of importance...

sr15929-Jul-10 23:12

Re: how to display the student who is in due - there are 4 rows, in 4th row he paid balance amt so i should not select that student and the who paid less than total i need to select that student

29-Jul-10 23:12

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

Goutam Patra29-Jul-10 23:42

Goutam Patra

29-Jul-10 23:42

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) 
)

Re: how to display the student who is in due - there are 4 rows, in 4th row he paid balance amt so i should not select that student and the who paid less than total i need to select that student

sr1595-Aug-10 23:37

Re: how to display the student who is in due - there are 4 rows, in 4th row he paid balance amt so i should not select that student and the who paid less than total i need to select that student

5-Aug-10 23:37

thank you for replying. Now it is working.

Luc Pattyn29-Jul-10 23:45

Luc Pattyn

29-Jul-10 23:45

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)

Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles] Nil Volentibus Arduum

Please use <PRE> tags for code snippets, they preserve indentation, and improve readability.

Re: how to display the student who is in due - there are 4 rows, in 4th row he paid balance amt so i should not select that student and the who paid less than total i need to select that student

PIEBALDconsult1-Aug-10 8:36

PIEBALDconsult

1-Aug-10 8:36

sr159 wrote:
i have column called receipt_no, student_id, paid_amt, Bal_amt

First go back and correct your schema.

About Poweshell

NetQuestions29-Jul-10 20:22

NetQuestions

29-Jul-10 20:22

Hi,

Is it necessary to have .Net Framewrok installed to you power shell?

regards,
NetQuestions

Re: About Poweshell

Richard MacCutchan29-Jul-10 22:19

Richard MacCutchan

29-Jul-10 22:19

Yes, for further information see this page[^].

It's time for a new signature.

About WMI

NetQuestions29-Jul-10 4:03

NetQuestions

29-Jul-10 4:03

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

Re: About WMI

dan!sh 29-Jul-10 23:11

dan!sh

29-Jul-10 23:11

What kind of information are you speaking about? You can use WMI for information about IIS. See if this[^] helps.

Export to Excel in zip format

Member 322226428-Jul-10 23:01

Member 3222264

28-Jul-10 23:01

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

Eddy Vluggen28-Jul-10 23:11

Eddy Vluggen

28-Jul-10 23:11

Member 3222264 wrote:
//zip.AddFile("export.xls", "content");

..why is that line commented out? Smile | :)

I are Troll Suspicious | :suss:

Member 322226429-Jul-10 0:59

Member 3222264

29-Jul-10 0:59

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

Eddy Vluggen29-Jul-10 1:04

Eddy Vluggen

29-Jul-10 1:04

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;

txt

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 Suspicious | :suss:

Member 322226429-Jul-10 1:13

Member 3222264

29-Jul-10 1:13

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?

Eddy Vluggen29-Jul-10 1:25

Eddy Vluggen

29-Jul-10 1:25

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 Suspicious | :suss:

Not Active29-Jul-10 2:28

Not Active

29-Jul-10 2:28

Please read the forum guidelines and use pre tags when posting code.

I know the language. I've read a book. - _Madmatt

data not binding

sr15928-Jul-10 0:51

Problem in Crystal report

28-Jul-10 0:51

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.

sr15928-Jul-10 0:48