.NET GENES

In your row command event, add a code like this: int selected_index = Convert.ToInt32(e.CommandArgument);

Given you have a field called customer_salary which is of type money in sql server, to cast and use it in your c# programs, you cast it to decimal. decimal Price = Convert.ToDecimal(reader.GetValue(1));

I've been playing around asp.net mvc just recently, i was really shocked and somewhat struggling with this new framework since i was used to the traditional N-Tier development with asp.net. As I developed simple examples, asp.net mvc is somewhat similar to n-tier development. As such, each layers have been separated to enable designers and coders to work independently with each layer. I have some books in my arsenal but i haven't read them yet.LOL Basically, I'm still a newbie with this stuff. One tip that i read was choosing between asp.net webforms and asp.net mvc. This will provide insights on other developers as well. Choosing between ASP.NET MVC and ASP.NET Webforms Source: ASP.NET MVC 1.0 Quickly In general, choosing between ASP.NET MVC and ASP.NET can be based on the following five criteria: 1. Are you considering test-driven development (TDD)? TDD enables you to write tests for an application first, after which the application logic is developed. An ASP.NET Webfor...

Here is a script to calculate an age of a person using TSQL using Convert(). SELECT FirstName, LastName , CONVERT (Int, DATEDIFF( day , BirthDate, GETDATE())/365.25) As Age FROM EmployeesDTR Source: TSQL Reference

Working with login control in asp.net provides convenient way to apply secured user API with less programming. Since login control is part of .net framework,such classes are provided such as membership, forms authentication and etc.. One weird error i encountered is that, it does not redirect to my index page once login has been successful. I implemented my own validation function to check if a user exists in the database. If the method returns true, redirect to index page. See code below. But the fact is, it does not redirect. if (CheckUserInMyDB(Login1.UserName, Login1.Password)) { e.Authenticated = true ; Login1.Visible = false ; Response.Redirect( "Index.aspx" ); } else { e.Authenticated = false ; } So the solution i found in forums.asp.net was to transfer the Response.Redirect to Logged in method of the login control.

Here's a snippet to insert a parameter array in .NET: ' add a class ex. Patient Public Class Patient Public name As String Public code As Integer End Class ' create a delegate Delegate Function myConn() As String 'function to return connstring Private Function connectionstring() As String Dim conn As String = "your_connection_string here" Return conn End Function '--Main Sub ' execute insert array Dim objCon As myConn objCon = New myConn( AddressOf connectionstring) Dim str As String = objCon.Invoke() Dim connection As New SqlConnection(str) Try Dim patients As New List( Of Patient) For i As Integer = 0 To max_count_variable Dim patient As New Patient() ...