ASP.NET MVC Framework, LinqToSql and ExtJS

[LiXin]

I'd share an example of a grid and a pop-up form for add/edit/delete data. The code provided works with ExtJS + ASP.NET MVC Framework + LinqToSql. SQL Server 2005 Northwind database was used.The .zip is attached.

The link to download the complete project:

http://latticesoft.com/forums/files/

[olimpia]

Very good, thanks for example.

[barmat.ali]

nice to see that !!!

thanks for the post , it's very nice,

Thanks a lot !

[alibaba69]

Hi!

Thanks for the code. Would it be possible if you post the whole project? This is, with the directory structure and so on.

Thanks.

[franklt69]

One more please post the whole project to study it.

regards
Frank

[LiXin]

You can create ASP.NET MVC project using Visual Studio 2008 which will create directories and codes for you. Then simply copy ExtJS library to 'Content' directory as well as attached code to appropriate directories (Controllers/Models/Views).

Very busy recently, will post the whole project if you still request for it.

[barmat.ali]

will post the whole project if you still request for it.


Yes we still request for it :):):);)

[itsayr]

Thank you for your good example..

[LChengIn]

Thank you very much！

[olimpia]

1

[lvgunst]

Could you please post the complete project? Thanks!

[LiXin]

[QUOTE=olimpia;266718]1

[LiXin]

For those ask for the complete project, here you go (VS 2008). I am not an ExtJS neither ASP.MVC/Linq expert, so your feedback and critics are appreciated.

http://latticesoft.com/forums/files/

[alibaba69]

Can you please provide the complete link for these?


..\Product Line\Templates\Application\ExtJS-ASPNET-MVC-LINQ directory.


Thanks!

[LiXin]

Can you please provide the complete link for these?
Thanks!

You need download and install the LatticeFramework Studio, then you shall find the templates at ../Product Line/Templates directory at your local computer.

Here is the link for LatticeFramework Studio:
http://www.latticesoft.com/downloads/latticeframeworkstudio.msi

ASP.NET + ExtJS view (aspx web form), LinqToSql models and DataContext, ASP.NET MVC controllers can be generated from your SQL Server database using LatticeFramework Studio.

[alibaba69]

Thanks LiXin :)

Now a very stupid question. Where should I put those files to start using the template with visual studio?

I've tried on here: C:\Program Files (x86)\Microsoft Visual Studio 9.0\Common7\IDE\NewFileItems

But it doesn't work.

Also I tried here: C:\Program Files (x86)\Microsoft Visual Studio 9.0\Common7\IDE\ProjectTemplates\CSharp\Web\1033

Thanks!

[lvgunst]

You should place them in %My Documents%\Visual Studio 2008\Projects

[LiXin]

Thanks LiXin :)

Now a very stupid question. Where should I put those files to start using the template with visual studio?

I've tried on here: C:\Program Files (x86)\Microsoft Visual Studio 9.0\Common7\IDE\NewFileItems

But it doesn't work.

Also I tried here: C:\Program Files (x86)\Microsoft Visual Studio 9.0\Common7\IDE\ProjectTemplates\CSharp\Web\1033

Thanks!

Those xslt templates come with LatticeFramework Studio are not for Visual Studio, the templates are used by latticeFramework Studio generating the code from your databases as the following steps:

1. Connect to your database using LatticeFramework Studio.
2. Right click the database node to generate the code.

Internally LatticeFramework Studio will convert your database metadata into XML as we call it XEML (Entity Markup Language), and then those xslt templates will be load and translate the XML metadata into source code, for example, ExtJS javascript code.

Any source code can be generated from the database metadata, you only need write your own templates.

[olimpia]

LatticeFramework Studio works with SQL Server 2008 Express, please let me know if you run into any problems.

You can find templates for ASP.NET(web forms) with ExtJS at ..\Product Line\Templates\Application\ExtJS-ASPNET-MVC-LINQ directory, looking for ASPNET-ExtJS-View.xslt and ASPNET-ExtJS-View-CodeBehind.xslt, and then set extension as .aspx and aspx.cs when you generate the code using above templates.

I made a generation of code using a bank Sql Server 2008 without any problems occur.
I will try to change the template MVC for WebForm. After sending here.

[gpangrango]

thanks for the share....it's nice

[moulivedula]

Dear Admin/LiXin,
I am unable to download the files. I am getting the following error.

File Galleries Temporarily Disabled

The site administrator has temporarily disabled the file galleries.

can you please help me on this.

Thanks a ton in advance for your tutorials

Mouli.

[LiXin]

Please leave your email here; I will send you the file.

[moulivedula]

Hi LiXin,
Thank you very much for quick reply. Please email me the code to moulivedula@yahoo.com

Regards,
Mouli.

[gilcachaca]

Please, can you send to me? Thank's
gilcachaca@gmail.com

[mjvdg]

can' you please send me the files also

[grishtspa]

Here is, in my opinion, the most interesting part:
PHP Code and SQL server:

//If first time key in date run statement
if(first == 0){
++first;//Track if is the first record key in
items[i] = new Item(itemNumber, itemDesc, sellPrice, quantity);
}
//Else continue key in record
else{
entries = items[0].getEntries();//Get number of entries entered
for(j=0; j<entries; ++j){

duplicate = items[j].equals(itemNumber, itemDesc, sellPrice, quantity);//Check for duplication of entries

if(duplicate == true) {
Print.duplicateError();
--i;
--looping;
break;
}
}
if(duplicate == false)//else save record
items[entries] = new Item(itemNumber, itemDesc, sellPrice, quantity);
}

[LiXin]

mjvdg, would you mind leave your email here, so I send you the file?

grishtspa, the file only included C# code for asp.net mvc, I don't think any php code include in the file.

[lostistn]

here is my Email address, lostistn@hotmail.com
could you send me the whole project?
thanks in advance!

[ostenieverson]

Please, can you send to me?
ostenieverson@gmail.com
Thank

[Apakekdah]

Thx for the sample, first time using ExtJs..
btw, where is full source project ? i can't download it :(

[JLINS]

mjvdg, would you mind leave your email here, so I send you the file?

grishtspa, the file only included C# code for asp.net mvc, I don't think any php code include in the file.

here is my Email address, jlmeneses1@hotmail.com (lostistn@hotmail.com)
could you send me the whole project?
thanks!

[Apakekdah]

can you send it to me too..
here's my email. gwdonkboi@gmail.com

Thx in advance..

[cycad007]

Hi LiXin -

I'm also trying to learn ExtJS. Could you please send me a copy of your project so I could learn from it?

My email is: cycad007@yahoo.com

Many thanks!
James

[send2rpk]

could you please send me a copy of your project i.e linqtosql with gridfiltering.

my email is send2rpk@yahoo.co.in

[hoang2140]

Can you send me the example? I'm new to Extjs and want to learn from this example.
My email is: hoanglm.bmt@gmail.com.
Thank you so much!

[rkchak]

Can you send me the example project too?
I'm new to Extjs and ASP.net.
My email is: rkchak@gmail.com (hoanglm.bmt@gmail.com).

Thanks!

[archana25]

I also want this code..

can anyone Please Send me whole Project....

Archana Mistry
Sr. Programmer
Kintudesigns.com