.net scanner

Default Sort for GridView using ObjectDataSource

noreply@blogger.com (Avinash Tumulu) — Mon, 01 Apr 2013 08:37:00 +0000

You can set the default sorting for the grid by setting default column and sort expression as below in page load event.

  protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                gridViewName.Sort("Name", SortDirection.Ascending);
            }
        }

Attaching Email Messages in WebMail or OWA

noreply@blogger.com (Avinash Tumulu) — Sun, 24 Mar 2013 18:14:00 +0000

While you are logged in to webmail, right click on the message the you would like to attach. (For Mac users, hold down ctrl and click on the message.)

Select "Forward as Attachment"

The new message window opens and you should see the message you selected listed in the attached field.

Fun with inner join

noreply@blogger.com (Avinash Tumulu) — Wed, 24 Feb 2010 18:04:00 +0000

You know any alternative of INNER JOIN??

Here is it....

Table Structure:

Employee Table
LastName	DepartmentID
Rafferty	31
Jones	33
Steinberg	33
Robinson	34
Smith	34
Jasper	NULL

Department Table
DepartmentID	DepartmentName
31	Sales
33	Engineering
34	Clerical
35	Marketing

ORIGINAL ONE:

SELECT Employee.lastName, Employee.DepartmentID, Department.DepartmentName

FROM Employee INNER JOIN Department

ON Employee.DepartmentID = Department.DepartmentID;

ALTERNATIVE ONE:

SELECT Employee.lastName, DepartmentID, Department.DepartmentName

FROM Employee INNER JOIN Department

USING(DepartmentID);

Happy Coding :)

Date Formating in GridView

noreply@blogger.com (Avinash Tumulu) — Wed, 10 Feb 2010 17:54:00 +0000

<asp:BoundField DataField="MyDate"  DataFormatString="{0:d}" HeaderText="DaDate"  />

Format Pattern	Name	Example
`d`	Short date format	8/27/1989
`D`	Long date format	Sunday, August 27, 1989
`t`	Short time format	3:32 PM
`T`	Long time format	3:32:00 PM
`f`	Full date/time format (short time)	Sunday, August 27, 1989 3:32 PM
`f`	Full date/time format (long time)	Sunday, August 27, 1989 3:32:00 PM
`g`	General date/time format (short time)	8/27/1989 3:32 PM
`G`	General date/time format (long time)	8/27/1989 3:32:00 PM
`m` or `M`	Month day format	August 27
`r` or `R`	RFC 1123 format	Sun, 27 Aug 1989 8:32:00 GMT
`s`	Sortable date/time format	1989-08-27T15:32:00
`u`	Universable sortable date/time format	1989-08-27 15:32:00z
`U`	Universable sortable date/time format	Sunday, August 27, 1989 11:32:00 PM
`y` or `Y`	Year month format	August, 1989

--
Avinash
+91-9916513673
avicool08@gmail.com

Sent from Bengaluru, Karnataka, India

Color CODE

noreply@blogger.com (Avinash Tumulu) — Wed, 04 Nov 2009 10:09:00 +0000

Color Hex-Code with Name
http://www.keller.com/html-quickref/4a.html

Color: color Name, color code - RGB, Hex, access
http://cloford.com/resources/colours/500col.htm

One more here:
http://www.tayloredmktg.com/rgb/

Here is one more interesting one:(change and see it live)
http://www.drpeterjones.com/colorcalc/

Change the "R+" - Reg , "G+"- Green, "B+"- Blue to see the colour in background.

Happy Coding.... :)

Insert data to table from another table

noreply@blogger.com (Avinash Tumulu) — Tue, 13 Oct 2009 06:09:00 +0000

Here is the example, how you can transfer data from one table to another;
(asumming, tables have been created and structures are same)

SET IDENTITY_INSERT [DB1].[dbo].TableName ON

insert into [DB1].[dbo].TableName select * from [DB2].[dbo].TableName

SET IDENTITY_INSERT [DB1].[dbo].TableName OFF

Above 3 lines:
1. Disable Identity.
2. Dump data from table.
3. Enable Identity again.

Hope you like it.

Testing WebService remotly.

noreply@blogger.com (Avinash Tumulu) — Sat, 29 Aug 2009 10:00:00 +0000

This post helps to solve the poblem, how to test webservice remotly.

If this attribute is not configured in Web.config file, you will not able to access the webservice remotely.

jQuery

noreply@blogger.com (Avinash Tumulu) — Mon, 06 Jul 2009 11:00:00 +0000

jQuery is a fast and concise JavaScript Library that simplifies HTML document traversing, event handling, animating, and Ajax interactions for rapid web development. jQuery is designed to change the way that you write JavaScript.

you can download latest version of jQuery: http://jquery.com/

Download jQuery presentation:

jQuery-PPT

jQuery-PPTX

Download the Sample Demo Code:

Demo

Have Fun :)

Visual Studio Tips-1

noreply@blogger.com (Avinash Tumulu) — Mon, 06 Jul 2009 06:26:00 +0000

Here are some useful tips, which will help you a lot while working with VS.

· Cycle the Clip Board:

o Copy few text one by one, then to cycle the clip board(copied items), press Ctrl+Shift+V

· Browse with different browsers:

o By default VS will use Internet Explorer as default browser, well you can change the default settings or can browse a particular page with different browser.

· Open Visual Studio from Run Command:

o Run > type “devenv” without quotes > press “ok”

o When you open the VS, mark that, before opening VS, a small splash screen will come, and if you don’t want to see that screen(which can faster opening VS), you can do that doing a small addition in the above command:

§ Type “devenv /nosplash” instead of “devenv”.

Happy coding :)

Open SQL server with one click

noreply@blogger.com (Avinash Tumulu) — Fri, 03 Jul 2009 08:50:00 +0000

Before reading this post, tell me how your opening SQL server, I mean how many steps its taking… just count… may be from 3-4 clicks… and for opening object explored 2 more .. And opening new query window for a particular database 2 more…

Now I will tell how you can open SQL server (with object explorer, new query window with selected DB) in one lick.

You know how to open it normal way, i mean from Run command, it is “sqlwb”(for sql server 2005) and “ssms”(for sql server 2008).

Open Run command, type:

sqlwb -S ServerName -d DataBaseName -U UserName -p Password

e.g:

sqlwb -S TestServer -d dummyDatabse -U Username_test -p myDummyPassword

To get help for these commands and more type “sqlwb /?” in run command.(“ssms /?” for 2008 sql server).

Happy coding…!!!

Select Query ... group by Date

noreply@blogger.com (Avinash Tumulu) — Wed, 01 Jul 2009 10:36:00 +0000

Most of the time we use, GROUP BY, in our sql queries, sometimes it may require to write a query Group By Date.

In this case, if the date field is DateTime in your table column, it won’t give correct data because it contains Date + Time, the time part makes difference, so we have to ignore the time part when writing query for group by with Date column.

What what what…????

Relax and see the example below you will understand clearly…

I have a table:

CREATE TABLE [dbo].[Table_1](

[name] [nchar](10) NULL,

[date] [datetime] NULL,

[add] [nchar](10) NULL

)

Note: date may be 2009-02-02 00:00:00.000 or 2009-02-02 08:20:10.000

Now compare both results below:

=======================================================

select date,[name],[add] from Table_1 group by date,[name],[add]

date name add

----------------------- ---------- ----------

2009-02-02 00:00:00.000 a 111

2009-02-02 00:00:40.000 ccc 333

2009-02-02 00:01:00.000 bb 222

2009-02-02 00:07:00.000 aa 66

2009-02-02 01:00:00.000 aaa 77

2009-02-03 00:00:40.000 ddd 444

2009-02-03 00:00:40.000 eee 555

(7 row(s) affected)

=======================================================

select

DATEADD(dd, 0, DATEDIFF(dd, 0, date)) date,

[name],

[add]

from

Table_1

group by

DATEADD(dd, 0, DATEDIFF(dd, 0, date)),

[name],

[add]

date name add

----------------------- ---------- ----------

2009-02-02 00:00:00.000 a 111

2009-02-02 00:00:00.000 aa 66

2009-02-02 00:00:00.000 aaa 77

2009-02-02 00:00:00.000 bb 222

2009-02-02 00:00:00.000 ccc 333

2009-02-03 00:00:00.000 ddd 444

2009-02-03 00:00:00.000 eee 555

(7 row(s) affected)

=======================================================

Look at First column of both restult,in second result all time are set to 00:00:00:000

Observ the first and second column, First result, even though dates are same, they appears to be different, and solution/fix is in second result…

Hope it helps you some where… some time…

Happy coding !!! J

Subject empty alert Message in Outlook express!!!

noreply@blogger.com (Avinash Tumulu) — Thu, 25 Jun 2009 07:16:00 +0000

Subject line is a very important part of an email. Most people prioritize the emails based on the subject line. Unfortunately, most people don’t add a proper subject line to their email. It becomes even worse when they miss the subject line. Here is an outlook macro which will alert you when you try to send an email without a subject line. Here are the steps to implement the macro:

a. Open outlook and press Alt + F11. This will open the Visual Basic Editor

b. Add the following code

N.B.:Check the left side pan (This Outlook session) and dropdowns in Main window ( Application and Item Send ) are choosen...

Private Sub Application_ItemSend(ByVal Item As Object, ByVal Cancel As Boolean)

Dim strSubject As String

strSubject = Item.Subject

If Len(strSubject) = 0 Then

Prompt$ = "Subject is Empty. Are you sure you want to send the Mail?"

If MsgBox(Prompt$, vbYesNo + vbQuestion + vbMsgBoxSetForeground, " Subject") = vbNo Then

Cancel = True

End If

End Sub

c. Save and Close the editor. Next time when you send an email without a subject line, the following alert message will be shown.

This is very useful for me… hope for you too….

Thank you.

"Go to Defination" is disabled in visual studio

noreply@blogger.com (Avinash Tumulu) — Wed, 17 Jun 2009 05:17:00 +0000

Today When I was working with Visual Studio, "Go to Defination" didn't work, infact its disabled.

I just search in Google, got the solution, here is it for you:

For ASP.NET solutions

1. close your solution.
2. delete hidden .sou file in folder where your solution's .sln file exists.
3. open your solution.
4. rebuild your solution.

Thats it, problem solved!!!

Happy programming :)

Get Client system IP address

noreply@blogger.com (Avinash Tumulu) — Sat, 13 Jun 2009 06:28:00 +0000

client IP address:

HttpContext.Current.Request.UserHostAddress

List all controls in page...

noreply@blogger.com (Avinash Tumulu) — Sat, 13 Jun 2009 06:07:00 +0000

Sometimes we want to know, the controls present in a .aspx page.... Here is the code to get all control's names...

private void ListControlCollections()
{
ArrayList controlList = new ArrayList();
AddControls(Page.Controls, controlList);
foreach (string str in controlList)
{
Response.Write(str + "
");
}
Response.Write("Total Controls:" + controlList.Count);
}

private void AddControls(ControlCollection page, ArrayList controlList)
{
foreach (Control c in page)
{
if (c.ID != null)
{
controlList.Add(c.ID);
}

if (c.HasControls())
{
AddControls(c.Controls, controlList);
}

}

}

noreply@blogger.com (Avinash Tumulu) — Fri, 12 Jun 2009 09:56:00 +0000

Did you know... how to insert quotes values automatically while typing the attrib values?

Today, May 30, 2009, 5 hours ago | WebDevTools

It's a nice time saver if you would like the HTML editor to automatically add quotes for the attribute values while you are typing.

To set this option select Tools->Options. Check Show all settings. From the left pane select Text Editor -> HTML -> Format and check the insert attribute value quotes when typing checkbox.

Now as soon as you hit "=" for the attrib value, editor will insert a pair of quotes and show the intellisense for the values accepted.

Select a value from the intellisense and press enter/tab. Cursor would jump out of the pair of quotes (you will have to hit the arrow key after entering the attrib value, if it doesn't show up a list of values).

Source:

http://blogs.msdn.com/webdevelopertips/archive/2009/05/29/tip-66-did-you-know-how-to-insert-quotes-values-automatically-while-typing-the-attrib-values.aspx

SQL Server - IDENTITY - How to change/reset the IDENTITY values?

noreply@blogger.com (Avinash Tumulu) — Fri, 12 Jun 2009 09:37:00 +0000

SQL Server - IDENTITY - How to change/reset the IDENTITY values?

In the previous post, we saw that the IDENTITY values can go out of sequence in several cases. Some times, you might decide to delete all rows from a table, and start filling fresh data. At this time, you might prefer to reset the IDENTITY value to start a new sequence.

Run the following script to create a sample table.

IF OBJECT_ID('Employees','U') IS NOT NULL
   DROP TABLE Employees
 
CREATE TABLE Employees (EmpID INT IDENTITY, Name VARCHAR(20))
GO

INSERT INTO Employees (Name) SELECT 'Jacob'
INSERT INTO Employees (Name) SELECT 'Steve'

SELECT * FROM Employees
/*
EmpID       Name
----------- --------------------
1           Jacob
2           Steve
*/

Let us now delete all rows from this table and insert a new row.

DELETE FROM Employees
INSERT INTO Employees (Name) SELECT 'Jacob'
SELECT * FROM Employees
/*
EmpID       Name
----------- --------------------
3           Jacob
*/

As we figured earlier, the IDENTITY value started with 3, not with 1. Let us now see how we can reset the IDENTITY value back to 1.

TRUNCATE TABLE resets IDENTITY values

When you truncate a table, the IDENTITY value will be RESET. Here is an example:

TRUNCATE TABLE Employees
INSERT INTO Employees (Name) SELECT 'Jacob'
SELECT * FROM Employees
/*
EmpID       Name
----------- --------------------
1           Jacob
*/

Note that the new IDENTITY value started from 1.

DBCC CHECKIDENT

You can use DBCC CHECKIDENT to reset the IDENTITY seed. Before we run the example, let us rebuild the table again.

IF OBJECT_ID('Employees','U') IS NOT NULL
   DROP TABLE Employees
 
CREATE TABLE Employees (EmpID INT IDENTITY, Name VARCHAR(20))
GO

INSERT INTO Employees (Name) SELECT 'Jacob'
INSERT INTO Employees (Name) SELECT 'Steve'

SELECT * FROM Employees
/*
EmpID       Name
----------- --------------------
1           Jacob
2           Steve
*/

Now, let us try DBCC CHECKIDENT

DELETE FROM Employees
DBCC CHECKIDENT('Employees',RESEED, 0)
INSERT INTO Employees (Name) SELECT 'Jacob'
SELECT * FROM Employees
/*
EmpID       Name
----------- --------------------
1           Jacob
*/

It is also possible to change the NEXT identity value to a value of your choice. The following example changes the current identity value to be 99, so that the next value generated will be 100.

DBCC CHECKIDENT('Employees',RESEED, 99)
INSERT INTO Employees (Name) SELECT 'Bob'
SELECT * FROM Employees
/*
EmpID       Name
----------- --------------------
1           Jacob
100         Bob
*/

Source:

http://beyondrelational.com/blogs/jacob/archive/2009/01/30/sql-server-identity-how-to-change-reset-the-identity-values.aspx

Finding Control properties within the Gridview

noreply@blogger.com (Avinash Tumulu) — Thu, 19 Mar 2009 06:29:00 +0000

protected void MyGridView_OnRowDataBound(object sender, GridViewRowEventArgs e)

{ if (e.Row.RowType == DataControlRowType.DataRow)

{

DropDownList ddlMyList = (DropDownList)e.Row.FindControl("ddlMyList");
// Do some logic to populate my ddlMyList with data
ddlMyList.SelectedValue = DataBinder.Eval(e.Row.DataItem, "ID").ToString();
}

}