.NET GENES

After reading some articles on TSQL, I made some experiments on User defined functions. Actually, there are three types of UDF. First we have the Scalar functions that returns a single value of the data type referenced in the RETURNS clause of the CREATE FUNCTION statement. The returned data can be of any type except text, ntext, image, cursor, or timestamp. Next we have Inline table-valued function which returns a variable of data type table whose value is derived from a single SELECT statement. Lastly, we have multi-statement table-valued function which is slightly more complicated than the other two types of functions because it uses multiple statements to build the table that is returned to the calling statement. (Source: http://www.sqlteam.com ) For the sake of simplicity, I'll tackle the first two types of functions. 1. Scalar function example: create function ComputeSum(@FirstNum int, @SecondNum int) returns int as begin Declare @ sum int set

I started learning jquery recently. This is a simple tutorial using asp.net website to show alert message and to change background color of label control. Add a label control, an asp.net button control, and input html button. Make sure to reference the jQuery library in your asp.net website. jQuery Script: 1 2 3 4 5 6 7 8 9 10 11 $( document ).ready( function () { $( '#btnAlert' ).click( function () { alert( 'my first jquery app!' ); }); $( '#btnChangeBackColorLabel' ).click( function () { $( 'span' ).css( "background-color" , "blue" ); }); $( "span" ).click( function () { $( this ).css( "background-color" , "yellow" ); }); }); HTML CODE: 1 2 3 4 5 6 7 <div> <asp:Button ID= "btnAlert" runat= "server" Text= "Show Alert" /> <br /> Click Change Me label itself to change backgrou

I recently played with jquery to work with asp.net/asp.net ajax. 1. Perform these steps in this website: jQuery Intellisense in Visual Studio 2008 2. Download jquery-1.4.1-vsdoc.js and jquery-1.4.1.min.js from jquery website. 3. Include them in your asp.net website. 4. remove the min in jquery-1.4.1.min.js. So the new jquery library would be like this: jquery-1.4.1.js 5. Add reference to the jquery library in your javascript file. That's it...Cheers!!!

Good evening. Here's a basic example of how to call a SQL Server Stored Procedure Using LINQ And C#.NET 1. Make sure you have Northwind database in your Sql server. 2. Create a simple stored procedure to retrieve customers based on a specific country. The parameter of the stored procedure is of type varchar. 3. Create a simple asp.net website or winforms or console project. 4. Add a Linq to SQL class to your project. 5. Make sure to add the stored procedure in your linq to sql class. 6. In your asp.net website, add a button,textbox and a gridview. 7. In your button event click, add the following snippet: 1 2 3 4 5 6 7 8 protected void Bind () { string country = this .txtCity.Text.Trim(); var cr = new NorthWindDataContext(); var north = cr.CustomerByCountry(country); this .gridCustomers.DataSource = north; this .gridCustomers.DataBind(); } That's it...

When writing sql statements in your business logic layer, you often want to append % which is a literal in your query. An example would be like this: string query = "Select * from Patient where LastName like '" + "@family" + " %'" ; However, this would give you an error, since the @family parameter is inside the tick marks that makes it a literal, but the % sign should be inside the tick marks. So, the correct sql syntax would be this way: string query = "Select * from Patient where LastName like (@family + '%')" ; Source: VBForums Link

I have encountered a scenario when creating crystal reports for a specific customer. In my reports, I have four controls. 1. Comments (Text Object) and Comments (Field object )w/ top properties of 3465. 2. Recommendations (Text Object) and Recommendations (Field object ) w/ top properties of 4505. Here's what i need to do. 1 2 3 if ((recommendations field object ! = null) && (comments field object == null))) 2 : If true , set top properties of Recommendations Text 3 : object and commendations Field object to 3465. Solution in VBForums. Greg

Here's a site from a friend of mine containing series of topics on Linux and open source softwares. http://www.opensolutions101.com/

If there are instances that you failed to create maintenance plan (backup plan) in MS SQL due to the error specified above, the solution would be to reregister MSXML. Solution: http://support.microsoft.com/kb/922546

I encountered lately an error when printing a report from a deployed asp.net website. I installed correctly the printer software/drivers. The printer used was Samsung. Solution: In Control Panel (Printers and Faxes), add asp.net user account to the default printer.

http://www.asp.net/ (Main ASP.NET Website)