Watch TV in online instead of cable TV or DTH

 Hi readers,
Now a days we are watching TV shows through cable TV or satellite TV such as sun direct DTH,  airtel digital TV,Tata sky etc.I seen a website streamdirect.com which is providing new way to watch our favorite TV channels. Yes thru this site we can watch TV channels in internet only so called (direct tv internet or
tv on the internet). Beauty of this trend is no hardware needed. In India 3G technology released show we can access the high speed internet in 3G enabled mobile phones. So this website offer we can watch our favorite TV channels while in the move. Consider when you are in the traveling you should miss your favorite TV channel programs such as drama,cricket,Wrestling etc. but using this technology you can see this in your mobile phone. This is the great info for us is it?. For more info Click Here!

see the list of tv channels provide this site below.

North America United States (421 Channels) Mexico (332 Channels) Canada (248 Channels) Guatemala (156 Channels) Cuba (113 Channels) Dominican Republic (89 Channels) Haiti (75 Channels) Honduras (66 Channels) El Salvador (52 Channels) Nicaragua (48 Channels) Costa Rica (32 Channels) Puerto Rico (28 Channels) Panama (23 Channels) Jamaica (21 Channels) Bahamas (18 Channels) Barbados (16 Channels) Virgin Islands (13 Channels) Bermuda (5 Channels) Greenland (3 Channels) South America Brazil (157 Channels) Colombia (139 Channels) Argentina (128 Channels) Peru (98 Channels) Venezuela (86 Channels) Chile (73 Channels) Ecuador (64 Channels) Bolivia (59 Channels) Paraguay (46 Channels) Uruguay (45 Channels) Guyana (39 Channels) Suriname (25 Channels) Falkland Islands (16 Channels)   For more info Click Here!

Europe Russia (527 Channels) Germany (511 Channels) Turkey (479 Channels) United Kingdom (436 Channels) France (411 Channels) Italy (409 Channels) Ukraine (369 Channels) Spain (332 Channels) Poland (311 Channels) Romania (298 Channels) Netherlands (284 Channels) Kazakhstan (119 Channels) Greece (101 Channels) Portugal (97 Channels) Belarus (88 Channels) Belgium (74 Channels) Czech Republic (62 Channels) Hungary (55 Channels) Sweden (32 Channels) Austria (11 Channels) Asia China (235 Channels) India (210 Channels) Indonesia (146 Channels) Pakistan (105 Channels) Bangladesh (98 Channels) Japan (75 Channels) Philippines (63 Channels) Vietnam (61 Channels) Turkey (45 Channels) Thailand (43 Channels) South Korea (17 Channels)

Africa Nigeria (279 Channels) Egypt (266 Channels) Ethiopia (251 Channels) Tanzania (179 Channels) Sudan (113 Channels) Kenya (98 Channels) Morocco (84 Channels) Algeria (76 Channels) Uganda (64 Channels) Ghana (51 Channels) Madagascar (37 Channels) Angola (21 Channels) Zimbabwe (11 Channels) Malawi (3 Channels) Australia Sydney (119 Channels) Melbourne (108 Channels) Brisbane (94 Channels) Perth (81 Channels) Adelaide (76 Channels) Gold Coast (55 Channels) Newcastle (51 Channels) Canberra (47 Channels) Wollongong (22 Channels) Sunshine Coast (13 Channels) Hobart (11 Channels) Geelong (7 Channels) Townsville (5 Channels) Ballarat (3 Channels) And so many more un-listed channels!

How much water do you need a day?

Water is an important structural component of skin cartilage, tissues and organs. For human beings, every part of the body is dependent on water. Our body comprises about 75% water: the brain has 85%, blood is 90%, muscles are 75%, kidney is 82% and bones are 22% water. The functions of our glands and organs will eventually deteriorate if they are not nourished with good, clean water.

The average adult loses about 2.5 litres water daily through perspiration, breathing and elimination. Symptoms of the body's deterioration begins to appear when the body loses 5% of its total water volume. In a healthy adult, this is seen as fatigue and general discomfort, whereas for an infant, it can be dehydrating. In an elderly person, a 5% water loss causes the body chemistry to become abnormal, especially if the percentage of electrolytes is overbalanced with sodium.One can usually see symptoms of aging, such as wrinkles, lethargy and even disorientation. Continuous water loss over time will speed up aging as well as increase risks of diseases.

If your body is not sufficiently hydrated, the cells will draw water from your bloodstream, which will make your heart work harder. At the same time, the kidneys cannot purify blood effectively. When this happens, some of the kidney's workload is passed on to the liver and other organs, which may cause them to be severely stressed. Additionally, you may develop a number of minor health conditions such as constipation, dry and itchy skin, acne, nosebleeds, urinary tract infection, coughs, sneezing, sinus pressure, and headaches.                                                  
So, how much water is enough for you? The minimum amount of water you need depends on your body weight. A more accurate calculation, is to drink an ounce of water for every two pounds of body weight.                              
Do you want to know How much amount of water you need to drink per day? Click Here.

Stored Procedures Optimization Tips

Use stored procedures instead of heavy-duty queries.
This can reduce network traffic, because your client will send to server only stored procedure name (perhaps with some parameters) instead of large heavy-duty queries text. Stored procedures can be used to enhance security and conceal underlying data objects also. For example, you can give the users permission to execute the stored procedure to work with the restricted set of the columns and data.

*****

Include the SET NOCOUNT ON statement into your stored procedures to stop the message indicating the number of rows affected by a Transact-SQL statement.
This can reduce network traffic, because your client will not receive the message indicating the number of rows affected by a Transact-SQL statement.

*****

Call stored procedure using its fully qualified name.
The complete name of an object consists of four identifiers: the server name, database name, owner name, and object name. An object name that specifies all four parts is known as a fully qualified name. Using fully qualified names eliminates any confusion about which stored procedure you want to run and can boost performance because SQL Server has a better chance to reuse the stored procedures execution plans if they were executed using fully qualified names.

*****

Consider returning the integer value as an RETURN statement instead of an integer value as part of a recordset.
The RETURN statement exits unconditionally from a stored procedure, so the statements following RETURN are not executed. Though the RETURN statement is generally used for error checking, you can use this statement to return an integer value for any other reason. Using RETURN statement can boost performance because SQL Server will not create a recordset.

*****

Don't use the prefix "sp_" in the stored procedure name if you need to create a stored procedure to run in a database other than the master database.
The prefix "sp_" is used in the system stored procedures names. Microsoft does not recommend to use the prefix "sp_" in the user-created stored procedure name, because SQL Server always looks for a stored procedure beginning with "sp_" in the following order: the master database, the stored procedure based on the fully qualified name provided, the stored procedure using dbo as the owner, if one is not specified. So, when you have the stored procedure with the prefix "sp_" in the database other than master, the master database is always checked first, and if the user-created stored procedure has the same name as a system stored procedure, the user-created stored procedure will never be executed.

*****

Use the sp_executesql stored procedure instead of the EXECUTE statement.
The sp_executesql stored procedure supports parameters. So, using the sp_executesql stored procedure instead of the EXECUTE statement improve readability of your code when there are many parameters are used. When you use the sp_executesql stored procedure to executes a Transact-SQL statements that will be reused many times, the SQL Server query optimizer will reuse the execution plan it generates for the first execution when the change in parameter values to the statement is the only variation.

*****

Use sp_executesql stored procedure instead of temporary stored procedures.
Microsoft recommends to use the temporary stored procedures when connecting to earlier versions of SQL Server that do not support the reuse of execution plans. Applications connecting to SQL Server 7.0 or SQL Server 2000 should use the sp_executesql system stored procedure instead of temporary stored procedures to have a better chance to reuse the execution plans.

*****

If you have a very large stored procedure, try to break down this stored procedure into several sub-procedures, and call them from a controlling stored procedure.
The stored procedure will be recompiled when any structural changes were made to a table or view referenced by the stored procedure (for example, ALTER TABLE statement), or when a large number of INSERTS, UPDATES or DELETES are made to a table referenced by a stored procedure. So, if you break down a very large stored procedure into several sub-procedures, you get chance that only a single sub-procedure will be recompiled, but other sub-procedures will not.

*****

Try to avoid using temporary tables inside your stored procedure.
Using temporary tables inside stored procedure reduces the chance to reuse the execution plan.

*****

Try to avoid using DDL (Data Definition Language) statements inside your stored procedure.
Using DDL statements inside stored procedure reduces the chance to reuse the execution plan.

*****

Add the WITH RECOMPILE option to the CREATE PROCEDURE statement if you know that your query will vary each time it is run from the stored procedure.
The WITH RECOMPILE option prevents reusing the stored procedure execution plan, so SQL Server does not cache a plan for this procedure and the procedure is recompiled at run time. Using the WITH RECOMPILE option can boost performance if your query will vary each time it is run from the stored procedure because in this case the wrong execution plan will not be used.

*****

Use SQL Server Profiler to determine which stored procedures has been recompiled too often.
To check the stored procedure has been recompiled, run SQL Server Profiler and choose to trace the event in the "Stored Procedures" category called "SP:Recompile". You can also trace the event "SP:StmtStarting" to see at what point in the procedure it is being recompiled. When you identify these stored procedures, you can take some correction actions to reduce or eliminate the excessive recompilations.

*****

Ask a Tech Support Specialist Online

We have partnered with JustAnswer so that you can get an answer ASAP.

Type your question here

Striping HTML tags thro User defined Function

Hi all,
Here I will give you a interesting user defined function which is strip the HTML tag, means if you give the input as html document then the function return plain text. Here I am using some of the SQL string functions here. See the code below:-
  create function Strip_Html( @Input nvarchar(max))returns nvarchar(160)as
beginselect @Input=replace(@Input,'\r','')select @Input=replace(@Input,'\n','')select @Input=replace(@Input,'\t','')while(patindex('%<%',@Input)!=0)beginselect @Input=replace(@Input,substring(@Input,patindex('%<%',@Input),patindex('%>%',@Input)-patindex('%<%',@Input)+1),'')endif len(@input)>160 select @Input=(substring(@Input,1,160))return (@input)end
PATINDEX:
Returns the starting position of the first occurrence of a pattern in a specified expression, or zeros if the pattern is not found, on all valid text and character data types.
SUBSTRING:
 Returns part of a character, binary, text, or image expression.
       Syntax: SUBSTRING (value_expression ,start_expression ,length_expression )
REPLACE:
Replaces all occurrences of a specified string value with another string value.
       Syntax:REPLACE (string_expression,string_pattern,string_replacement)
LEN:
Returns the number of characters of the specified string expression, excluding trailing blanks.
I think it may be useful to you.
bye.

Ask a Tech Support Specialist Online

We have partnered with JustAnswer so that you can get an answer ASAP.

Type your question here

What is SQL injection?

SQL injection is an attack in which malicious code is inserted into strings that are later passed to an instance of SQL Server for parsing and execution.

The following line of code illustrates this vulnerability:

statement = "SELECT * FROM users WHERE name = '" + userName + "';"

This SQL code is designed to pull up the records of the specified username from its table of users. However, if the "userName" variable is crafted in a specific way by a malicious user, the SQL statement may do more than the code author intended. For example, setting the "userName" variable as

' or '1'='1

Or using comments to even block the rest of the query:

' or '1'='1';/*'

renders this SQL statement by the parent language:

SELECT * FROM users WHERE name = '' OR '1'='1';

If this code were to be used in an authentication procedure then this example could be used to force the selection of a valid username because the evaluation of '1'='1' is always true.

The following value of "userName" in the statement below would cause the deletion of the "users" table as well as the selection of all data from the "userinfo" table (in essence revealing the information of every user), using an API that allows multiple statements:

a';DROP TABLE users; SELECT * FROM userinfo WHERE 't' = 't

This input renders the final SQL statement as follows:

SELECT * FROM users WHERE name = 'a';DROP TABLE users; SELECT * FROM userinfo WHERE 't' = 't';

Preventing SQL injection

To protect against SQL injection, user input must not directly be embedded in SQL statements. Instead,

• parameterized statements must be used (preferred)
• user input must be carefully escaped or filtered.
• Use Linq to SQL classes

Ask a Tech Support Specialist Online

We have partnered with JustAnswer so that you can get an answer ASAP.

Type your question here

Step By Step Guide to implement Linq to Sql class

I realized the benefits of Linq to Sql Classes while developing this forum. This is the dot net frameworks 3.5's powerful feature. I want to tell you little bit about the advantages of linq to sql classes.

• SQL Injection Proof.
• Intellisense
• Compile check when database changes
• Faster development
• Auto-generated domain objects that are usable small projects

STEP 1:

1. Open Visual Studio 2008 File-->New-->ASP.NET WEBApplication.
2. Give name as "Forum_Linq to SQL".
3. Goto Solution Explorer and right click on "Forum_Linq to SQL".
4. Ensure your project target framework as Dotnet Farmework 3.5, cause L2S works only on 3.5 framework. For this right click the "Forum_Ling to SQL" Goto Properties change Target Framework as 3.5.

Now In Solution Explorer Right click on Forum_Ling to SQL choose Add-->New Item. below mentioned  window will come. In that choose Linq to Sql classes and clcik Add button.

Now connect your Database in server explorer and drag and drop the tables to DataClasses1.dbml file. It will automatically converted into a class. See the image below.

 

Now we will see how to retrive data from this forum_user class. For this first we will create the object for the datacontext. Datacontext means it point to the dbml file which is created by us. In this project the datacontext name as "Dataclasses1DataContext". See the code below

 using System;
using System.Collections.Generic; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using System.Linq; namespace Forum_Linq_to_SQL {
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
GridView gv = new GridView();
DataClasses1DataContext obj = new DataClasses1DataContext();
var user = (from c in obj.Forum_Users select c).ToList();
gv.DataSource = gv;
gv.DataBind();
}
}
}

How to  Insert the new record into the Forum_user class?

DataClasses1DataContext obj = new DataClasses1DataContext();
Forum_User user = new Forum_User();
user.UserId = "xxxxx";
user.Pwd = "xxxx";
obj.Forum_Users.InsertOnSubmit(user);
obj.SubmitChanges();
How to  Edit the record into the Forum_user class?
DataClasses1DataContext obj = new DataClasses1DataContext();
var user = (from c in obj.Forum_Users where c.UserId=="xxxxx" select c).First();
user.Pwd = "zzzz";
obj.SubmitChanges();
How to Delete the record into the Forum_user class?
DataClasses1DataContext obj = new DataClasses1DataContext();
var user = (from c in obj.Forum_Users where c.UserId == "xxxxx" select c).Single();
obj.Forum_Users.DeleteOnSubmit(user);
obj.SubmitChanges();

How to Join two tables?
DataClasses1DataContext obj = new DataClasses1DataContext();
var user = (from c in obj.Forum_Users join s in obj.Forum_UsersTwo on s.UserId equals c.UserId select new {c.UserId,s.username}).First();

Ask a Tech Support Specialist Online

We have partnered with JustAnswer so that you can get an answer ASAP.

Type your question here

Dynamic Combobox in asp.net

I provide you very simple example.This is just for your reference only. You can recreate that code based on your requirement. Look at the aspx code here I was used the asp:UpdatePanel  for reload the page without referesh.
<form id="form1" runat="server">
<div>
<asp:ScriptManager ID="ScriptManager1" runat="server">
asp:ScriptManager>
<asp:UpdatePanel ID="UpdatePanel1" runat="server">
<ContentTemplate>
ContentTemplate>
asp:UpdatePanel>
div>
form>

now look at the code behind in c#
using System;
using System.Collections;
using System.Collections.Generic;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
namespace DynamicCombo
{
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
DropDownList drplist2 = new DropDownList();
int count = 0;
ArrayList arraylist = new ArrayList();
drplist2 = new DropDownList();
drplist2.ID = "drplist2" + Convert.ToString(count);
drplist2.AutoPostBack = true;
drplist2.Attributes.Add("runat", "server");
drplist2.Items.Add("Fruits");
drplist2.Items.Add("Drinks");
UpdatePanel1.ContentTemplateContainer.Controls.Add(drplist2);
drplist2.SelectedIndexChanged += new EventHandler(drplist1_SelectedIndexChanged);
arraylist.Add(drplist2);
Session["arraylist"] = arraylist;
Session["count"] = count;
}
else
{
ArrayList arraylist = (ArrayList)Session["arraylist"];
for (int i = 0; i
{
DropDownList dd=(DropDownList) arraylist[i];
dd.ID = "drplist2" + Convert.ToString(i);
//dd.AutoPostBack = true;
//dd.Attributes.Add("runat", "server");
// dd.Items.Add("Mango");
//dd.Items.Add("Apple");
UpdatePanel1.ContentTemplateContainer.Controls.Add(dd);
//arraylist.Add(drplist2[i]);
dd.SelectedIndexChanged += new EventHandler(drplist1_SelectedIndexChanged);
}
}
}
protected void drplist1_SelectedIndexChanged(object sender, EventArgs e)
{
DropDownList drplist2 = new DropDownList();
ArrayList arraylist = (ArrayList)Session["arraylist"];
int count = (int)Session["count"];
count++;
drplist2.ID = "drplist2" + Convert.ToString(count);
drplist2.AutoPostBack = true;
drplist2.Attributes.Add("runat", "server");
drplist2.Items.Add("Mango");
drplist2.Items.Add("Apple");
UpdatePanel1.ContentTemplateContainer.Controls.Add(drplist2);
drplist2.SelectedIndexChanged += new EventHandler(drplist1_SelectedIndexChanged);
arraylist.Add(drplist2);
Session["arraylist"] = arraylist;
Session["count"] = count;
}
}
}

Ask a Tech Support Specialist Online

We have partnered with JustAnswer so that you can get an answer ASAP.

Type your question here