Sunday, June 10, 2018

Using Nhibernate in SharePoint 2010

Running Nhibernate on Sharepoint is not an easy task it might take 1 or 2 days to do it, in this tutorial I will try this task easy by providing a step by step guide starting from how to download NHibernate to how to configure it on sharepoint

You can download the latest Nhibernate version from: http://sourceforge.net/projects/nhibernate/
In my tutorial I am assuming that you know what’s NHibernate and how to use it, if it’s the first time to hear about NHibernate please read the following tutorial first: http://blogs.hibernatingrhinos.com/nhibernate/archive/2008/04/01/your-first-nhibernate-based-application.aspx

HBM & CS Classes Generators

There are many ways to generate HBM and CS classes
1) MYGeneration Templates: I do not recommend these templates because most of them are not updated to NHibernate newer versions and it’s not easy to change in its templates
Download link: http://www.mygenerationsoftware.com 
2) Smart Code Studio: it’s a better way to generate the hbm files and CS classes, I’ve modified in its template to be more standard and simple, you can download my template from this link.
(if you are not using Smart Code Studio you can watch a video on how to use it from this link http://www.kontac.net/site/SmartCode/tabid/55/Default.aspx )
Download link: http://www.kontac.net/site/SmartCode/Download/tabid/64/Default.aspx

Using NHibernate in your sharepoint project:

Create a new class library project in your solution called ABC.Domain and generate the hbm files and cs classes then place into it.

Make sure that all hbm classes are compiled as Embedded resources


Create another class library project called ABC.BL to use the Domain project and to be used by the share point project, don’t forget to add both classes to GAC using gacutil command.

Extract the Nhibernate folder and make sure to add reference to the following DLLs + Adding reference to your Domain project
Remotion.Data.Linq.dll
NHibernate.dll
Nhibernate.ByteCode.Linfu.dll
NHibernate.ByteCode.Castle.dll
log4net.dll
LinFu.DynamicProxy.dll
Iesi.Collections.dll
Castle.DynamicProxy2.dll
Castle.Core.dll
Antlr3.Runtime.dll



After adding the references to your project make sure to install them to GAC by executing the following commands on Visual Studio Command Prompt
gacutil -i "\Remotion.Data.Linq.dll"
gacutil -i "\NHibernate.dll"
gacutil -i "\Nhibernate.ByteCode.Linfu.dll"
gacutil -i "\NHibernate.ByteCode.Castle.dll"
gacutil -i "\log4net.dll"
gacutil -i "\LinFu.DynamicProxy.dll"
gacutil -i "\Iesi.Collections.dll"
gacutil -i "\Castle.DynamicProxy2.dll"
gacutil -i "\Castle.Core.dll"
gacutil -i "\Antlr3.Runtime.dll"
gacutil -i "\ABC.Domain\Bin\Debug\ABC.Domain.dll"

Configure your Web.config & hibernate.cfg.xml

Prepare you hibernate.cfg.xml and place it inot your website bin folder (eg. C:\inetpub\wwwroot\wss\VirtualDirectories\80\bin)

Now All references and configurations are ready, but if you tried to deploy your solution you will get a run time error “Could not load file or assembly 'xyz' or one of its dependencies”, Now you will just need to add qualifyAssembly tags to your web.config (eg C:\inetpub\wwwroot\wss\VirtualDirectories\80\ ) to allow Nhibernate to load assemblies form GAC and not to expect it in the bin folder.

To use Nhibernate inside your sharepoint project you can refer to this tutorial http://www.codegod.de/WebAppCodeGod/nhibernate-tutorial-1---and-aspnet-AID25.aspx 


source :  http://hazemtorab.blogspot.com/2010/08/using-nhibernate-in-sharepoint-2010.html 

Thursday, January 4, 2018

Query Strings in ASP.Net

QueryString is a collection of characters input to a computer or web browser. A Query String is helpful when we want to transfer a value from one page to another. When we need to pass content between the HTML pages or aspx Web Forms in the context of ASP.NET, a Query String is very easy to use and the Query String follows a separating character, usually a Question Mark (?). It is basically used for identifying data appearing after this separating symbol. A Query String Collection is used to retrieve the variable values in the HTTP query string. If we want to transfer a large amount of data then we can't use the Request.QueryString. Query Strings are also generated by form submission or can be used by a user typing a query into the address bar of the browsers. Query Strings are contained in request headers. A Query String collection is a parsed version of the QUERY_STRING variable in the Server Variables collection. It enable us to retrieve the QUERY_STRING variable by name. When we use parameters with Request.QueryString, the server parses the parameters sent to the request and returns the effective or specified data.
Syntax of Query String
Request.QueryString(variable)[(index).count].
Step 1
Start Visual Studio.
 
Figure 1: Start Visual Studio 
Step 2
Now for creating a website, click on the file, go to new and click on the website.
 
Figure 2: Create Website
Step 3
Now we add the two web forms to the website.
Add Webform 
Figure 3: Add Web form 
Step 4
 
We design the web form as in the following:
 
Figure 4: Design form
Step 5
After designing the web form, we need to write the following code in the button click.

  1. protected void Button1_Click(object sender, EventArgs e)   
  2. {  
  3.     Response.Redirect("default2.aspx ?firstname=" + TextBox1.Text + "&lastname=" + TextBox2.Text);  
  4. }  
 Step 6
In the second web form we take the one lable for displaying the values of the first page. For receiving the value from the first page we write the following code on the page_load of the second page.
  1. protected void Page_Load(object sender, EventArgs e)   
  2. {  
  3.     string firstname = Request.QueryString["firstname"];  
  4.     string lastname = Request.QueryString["lastname"];  
  5.     Label1.Text = "welcome" + firstname + " " + lastname;  
  6. }  
 Step 7
Now we need to execute the website by using the F5 key. After execution we give the input in the textboxes like this:
Execute
Figure 5: Execute Web Form
Figure 6: Input in the Textboxes
Step 8
After giving the values, we click on the Submit button then the following window will appear.
Figure 7: Final Window
Summary
In this article, I explained how to use Query Strings in ASP.NET, now you can easily do these operations in your projects for transferring a value of one page to another page.
I hope this article will be helpful for the beginners if they want to transfer data from one page to the another.
------------------------------------------------------------------------------------------------------------------------------------
source: http://www.c-sharpcorner.com/UploadFile/ca2535/query-string-in-Asp-Net/ 

HOW TO RECOVER THE SQL DATABASE FROM SUSPECT MODE (Or) HOW TO BRING BACK THE SUSPECTED DATABASE TO THE NORMAL MODE When you logi...