Microsoft Technologies, ASP.NET & SQL SERVER Tips with Rajat Jaiswal

Month: September 2010

Hello Friends,
Today I am sharing vb.net code generator. Its interface is simple same as our stored procedure code generator. (**Important I am using Microsoft Application block for Data Access Layer**)
You need to give user credential as shown in below fig.
Once the credential is successful you will get below screen.

Just select the table for which you want to generate code. Now if you want dataset as entity then just check the use dataset checkbox.
Then press Generate button.

It will generate y our windows form, Business manager class, Data Access layer class.
Just copy and paste in your project it will work fine with some minor changes.
You can download the code from below linkDownload code
Enjoy coding!!
Thanks & Regards
Rajat Jaiswal

Dear All,
I hope you have great time. Sometimes it happens that you have lot of work load and you have to deliver within time limits on the same time you have to make your coding consistency. If I think about me then I can say I am not going to compromise at least my coding style while the work load is high. So I just got idea to write some useful programs or tools which help me in finishing work as fast as possible.
So I created different utilities which generate following things
1) SQL Server Stored Procedure Generator
2) Dot net Code Generator (Three tire architecture using typed Dataset)
3) Dot net Code Generator ( Three tire architecture using Entity class)
4) PHP Code generator

In future I am interested in WCF & WPF & Silverlight code generator according to my coding style.
In this post I am giving SQL server Stored Procedure Code. It is basically a web application and you have to setup this web application and it will work as per your need.
Here is some screenshots take a look

Dear all,
For Indian its great news that you can now create web site in your native language like Hindi, Marathi, Punjabi, Urdu, Tamil etc.
Kudos to Microsoft for introducing “Microsoft Indic Language” with help of this we can easily create web site in any language without doing much efforts.
So here we go with the sample and things to remember with simple step

Remember here: I am using hindi here that’s why i used hindi.js you can use your own choice.Step 2:- Add new attribute with each input control which is “MicrosoftILITWebAttach” as shown in below.
< asp:TextBox ID=”txtPost” runat=”server” MicrosoftILITWebAttach=”true” ></asp:TextBox>

Step 3:- If you want to store this value in database the just remember all the field which contain string data type should be “NVARCHAR”
Otherwise your searching will not work and all the data will be change to question mark instead of actual data.

Step 4:- for searching in database hindi text or text which you insert you have to use following syntax