Asp.Net & SQL Help

Validation of viewstate MAC failed error

noreply@blogger.com (ashapatel) — Mon, 06 Jul 2009 05:49:00 +0000

when the following preconditions are true:

1. You aren't using a web farm.
2. It appears when using built-in databound controls such as GridView, DetailsView or FormView which utilize “DataKeyNames”.
3. It appears if you have a large page which loads slowly for any reason.

If following preconditions are true and you click a postbacking control/link and the page hasn't loaded completely in client browser, you might get the "Validation of ViewState MAC failed" exception.

When this happens, if you just try setting the page property "EnableViewStateMac" to false, it does not solve the problem, it just changes the error message in same navigation behavior:

The state information is invalid for
this page and might be corrupted.

Root Cause

This exception appears because Controls using DataKeyNames require Viewstate to be encrypted. When Viewstate is encrypted (Default mode, Auto, is to encrypt if controls require that, otherwise not), Page adds field just before closing of the < form > tag. But this hidden field might not have been rendered to the browser with long-running pages, and if you make a postback before it does, the browser initiates postback without this field (in form post collection). End result is that if this field is omitted on postback, the page doesn't know that Viewstate is encrypted and causes the aforementioned Exception. I.E. page expects to be fully-loaded before you make a postback.

And by the way similar problem is with event validation since __EVENTVALIDATION field is also rendered on the end of the form. This is a security feature that ensures that postback actions only come from events allowed and created by the server to help prevent spoofed postbacks. This feature is implemented by having controls register valid events when they render (as in, during their actual Render() methods). The end result is that at the bottom of your rendered tag, you'll see something like this: . When a postback occurs, ASP.NET uses the values stored in this hidden field to ensure that the button you clicked invokes a valid event. If it's not valid, you get the exception above.

The problem happens specifically when you postback before the EventValidation field has been rendered. If EventValidation is enabled (which it is, by default), but ASP.net doesn't see the hidden field when you postback, you also get the exception. If you submit a form before it has been entirely rendered, then chances are the EventValidation field has not yet been rendered, and thus ASP.NET cannot validate your click.

Workarounds

1. Set enableEventValidation to false and viewStateEncryptionMode to Never as follows:

This has the unwanted side-effect of disabling validation and encryption. On some sites, this may be ok to do, but it isn't a best practice, especially in publicly facing sites.

2. Another way around the problem is to mark the form as disabled and then enable it in script once the load is complete:
function enableForm() {
document.getElementById("form").disabled = false;
}

window.onLoad = enableForm();

Or you can disable the individual form elements and enable them once everything is loaded:

function disableElements(elements) {
for (var i = elements.length - 1; i >= 0; i--) {
var elmt = elements[i];

if (!elmt.disabled) {
elmt.disabled = true;
}
else {
elmt._wasDisabled = true;
}
}
}

function disableFormElements() {
disableElements(_form.getElementsByTagName("INPUT"));
disableElements(_form.getElementsByTagName("SELECT"));
disableElements(_form.getElementsByTagName("TEXTAREA"));
disableElements(_form.getElementsByTagName("BUTTON"));
disableElements(_form.getElementsByTagName("A"));
}

function enableElements(elements) {
for (var i = elements.length - 1; i >= 0; i--) {
var elmt = elements[i];
if (!elmt._wasDisabled) {
elmt.disabled = false;
}
else {
elmt._wasDisabled = null;
}
}
}

function enableFormElements() {
enableElements(_form.getElementsByTagName("INPUT"));
enableElements(_form.getElementsByTagName("SELECT"));
enableElements(_form.getElementsByTagName("TEXTAREA"));
enableElements(_form.getElementsByTagName("BUTTON"));
enableElements(_form.getElementsByTagName("A"));
}

Make sure that the variable _form is set to the ASP.net form on the page. Then just call enableFormElements() and disableFormElements().

3. The last way to workaround this problem is to override the Render Event of the page to place the hidden fields for Encrypted Viewstate and Event validation on the top of the form. This will ensure that these things get written out before anything that can submit the form:

protected override void Render(System.Web.UI.HtmlTextWriter writer)
{
System.IO.StringWriter stringWriter =
new System.IO.StringWriter();
HtmlTextWriter htmlWriter = new HtmlTextWriter(stringWriter);
base.Render(htmlWriter);
string html = stringWriter.ToString();
string[] aspnet_formelems = new string[5];
aspnet_formelems[0] = "__EVENTTARGET";
aspnet_formelems[1] = "__EVENTARGUMENT";
aspnet_formelems[2] = "__VIEWSTATE";
aspnet_formelems[3] = "__EVENTVALIDATION";
aspnet_formelems[4] = "__VIEWSTATEENCRYPTED";
foreach (string elem in aspnet_formelems)
{
//Response.Write("input type=""hidden"" name=""" & abc.ToString & """")
int StartPoint = html.IndexOf("= 0)
{
//does __VIEWSTATE exist?
int EndPoint = html.IndexOf("/>", StartPoint) + 2;
string ViewStateInput = html.Substring(StartPoint,
EndPoint - StartPoint);
html = html.Remove(StartPoint, EndPoint - StartPoint);
int FormStart = html.IndexOf("< form "); int="" endform = "html. IndexOf("">", FormStart ) + 1;
if (EndForm >= 0)
html = html.Insert( EndForm , ViewStateInput);
}
}

writer.Write(html);
}

< / form");>< / form>

About Visual Studio 2008

noreply@blogger.com (ashapatel) — Fri, 03 Jul 2009 06:16:00 +0000

Microsoft Visual Studio is an Integrated Development Environment (IDE) from Microsoft. It can be used to develop console and graphical user interface applications along with Windows Forms applications, web sites, web applications, and web services in both native codetogether with managed code for all platforms supported by Microsoft Windows, Windows Mobile, Windows CE, .NET Framework, .NET Compact Framework and Microsoft Silverlight.

Visual Studio includes a code editor supporting IntelliSense as well as code refactoring. The integrated debugger works both as a source-level debugger and a machine-level debugger. Other built-in tools include a forms designer for building GUI applications, web designer, classdesigner, and database schema designer. It allows plug-ins to be added that enhance the functionality at almost every level - including adding support for source control systems (likeSubversion and Visual SourceSafe) to adding new toolsets like editors and visual designers fordomain-specific languages or toolsets for other aspects of the software development lifecycle(like the Team Foundation Server client: Team Explorer).

Visual Studio supports languages by means of language services, which allow anyprogramming language to be supported (to varying degrees) by the code editor and debugger, provided a language-specific service has been authored. Built-in languages include C/C++ (viaVisual C++), VB.NET (via Visual Basic .NET), and C# (via Visual C#). Support for other languages such as F#, M, Python, and Ruby among others has been made available via language services which are to be installed separately. It also supports XML/XSLT,HTML/XHTML, JavaScript and CSS. Language-specific versions of Visual Studio also exist which provide more limited language services to the user. These individual packages are called Microsoft Visual Basic, Visual J#, Visual C#, and Visual C++.

Microsoft provides "Express" editions of its Visual Studio 2008 components Visual Basic, Visual C#, Visual C++, and Visual Web Developer at no cost. Visual Studio 2008 and 2005 Professional Editions, along with language-specific versions (Visual Basic, C++, C#, J#) of Visual Studio 2005 are available for free to students as downloads via Microsoft's DreamSpark program. Visual Studio 2010 is currently in beta testing and can be downloaded by the general public at no cost.

Get All Dates Of Year Which are Sunday

noreply@blogger.com (ashapatel) — Tue, 23 Jun 2009 09:44:00 +0000

ArrayList allSundays = getAllWeekDates(DateTime.Now.Year);
for (int i = 0; i < allSundays.Count; i++)
{
Response.Write(allSundays[i]+" ");
}

public ArrayList getAllWeekDates(int Year)
{
ArrayList strDates=new ArrayList();
for (int month = 1; month <= 12; month++) { DateTime dt = new DateTime(Year, month, 1); int firstSundayOfMonth = (int)dt.DayOfWeek; if (firstSundayOfMonth != 0) { dt = dt.AddDays((6 - firstSundayOfMonth) + 1); } while (dt.Month == month) { strDates.Add(dt.ToString("dd/MMM/yyyy")); dt = dt.AddDays(7); } } return strDates; }

Get Day Neame Between Start Date and End Date

noreply@blogger.com (ashapatel) — Tue, 23 Jun 2009 08:56:00 +0000

DateTime StartDate = new DateTime();
DateTime EndDate = new DateTime();
StartDate = Convert.ToDateTime("06-23-2009");
EndDate = Convert.ToDateTime("06-9-2009");
int day = EndDate.Subtract(StartDate).Days;

for (int i = 0; i <= day; i++)
{
DateTime newdate = Convert.ToDateTime(StartDate.AddDays(i).ToShortDateString());
string newday = newdate.DayOfWeek.ToString();
Response.Write(newdate+"="+ newday );
}

Grouping Sets - In SQL Server 2008

noreply@blogger.com (ashapatel) — Fri, 17 Apr 2009 11:13:00 +0000

The grouping sets feature allows the developer to group data selected

in the same select statement into different groups.

The grouping sets intended to provide a powerful grouping tool in a

single SQL Statement by different fields having the same selection

number of fields. This feature is especially useful in the case of

collecting summary data using different criteria.

Steps :

Follow the easy steps below to create your environment and work area.

1. Open Microsoft SQL Server Management Studio.

2. Right click the database DbWork and choose query window.

3. Use the listing below to create a customer address table that

would contain all the orders by a specific customer id.

Listing 1 - T-SQL to create the order table

CREATE TABLE [dbo].[TblCustomerAddress](
[CustomerId] [int] NOT NULL,
[CustomerContinent] [varchar](50) NOT NULL,
[CustomerCountry] [varchar](50) NOT NULL,
[CustomerCity] [varchar](50) NOT NULL,
CONSTRAINT [PK_TblCustomerAddress] PRIMARY KEY CLUSTERED
(
[CustomerId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY

= OFF,
ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

4. Use the following listing below in order to insert some records

in the order tables.

Listing 2 - T-SQL to insert data into the customer address table using

the row constructor method

Insert into TblCustomerAddress (CustomerId, CustomerContinent,

CustomerCountry,
CustomerCity)
Values (1,'America','USA','Florida'),
(2,'America','USA','Kansas'),
(3,'Asia','Lebanon','Florida'),
(4,'Asia','KSA','Riyad'),
(5,'Europe','France','Paris'),
(6,'Europe','Greate Britan','Paris')

5. Suppose your manager came in and said, "I want a count of our

customer addresses according to a count by continent, a count by

country, a count by city and a total count." In order to do this

before, you would have had to write a list of 4 queries as listed in

the example below.

Listing 3

--Count the customer by Continent
Select CustomerContinent, COUNT(*) From TblCustomerAddress
Group By CustomerContinent

--Count the customer by Country
Select CustomerCountry, COUNT(*) From TblCustomerAddress
Group By CustomerCountry

--Count the customer by City
Select CustomerCity, COUNT(*) From TblCustomerAddress
group By CustomerCity

-- Count All Customers
Select COUNT(*) From TblCustomer

6. How to solve the problem? SQL Server
2008 provided the grouping sets to do this. The grouping sets feature

allows having different grouping in the same SQL Statement
. The listing below shows the statement.

Listing 4

SELECT CustomerCity, CustomerCountry, CustomerContinent, Count(*) AS

Count
FROM TblCustomerAddress
GROUP BY GROUPING SETS (
(CustomerCity),
(CustomerCountry),
(CustomerContinent),
()
)
ORDER BY CustomerCity, CustomerCountry, CustomerContinent

7. This statement would return all results combined and ordered. The

first grouping is done by customer city, the second is by customer

country, the third one is by customer continent, while the last one is

for the total of the table. So there is no grouping by a field done

here.

Table-Value Parameter in Storedprocedure - SQL SERVER -2008

noreply@blogger.com (ashapatel) — Fri, 17 Apr 2009 10:21:00 +0000

Pass multiple rows of a table as a parameter to a stored procedure.

Create a Table variable type in MSSQL and use it in the same way you

use an integer data type. You can pass this variable to any stored

procedure and use its contents or even update its contents and return

it back.

How we use?:

1. Open Microsoft SQL Server Management Studio.

2. Right click the database DbWork and choose query window.

3. Use the listing below to create an employee table as well as

employee skill table.

Listing 1 - T-SQL to create the employee table as well as employee

skills table

Create Table TblEmployee
(EmployeeId int primary key,
EmployeeName varchar(50))

Create Table TblEmpSkills
(EmployeeId int,
EmployeeSkill varchar(50),
AcquiredSince date)

4. Use the following listing below in order to insert some records

in the employee table.

Listing 2 - T-SQL to insert data into the employee table using the row

constructor method

Insert Into TblEmployee (EmployeeId, EmployeeName)
Values (1,'Asha Patel'),
(2,'Kamal Chaurasia'),
(3,'Tushar Jadhav'),
(4,'Kiran Patel')

5. The idea now is that each employee can have multiples skills

attached to him. We are going to implement the solution using table-

value parameter.

6. We first need to create the table-value parameter. Listing 3

shows the creation of the SkillTable variable.

Listing 3 - T-SQL to create the SkillTable variable

Create Type SkillTable as Table
(EmployeeId int, EmployeeSkill varchar(50))

7. Now, we declare a variable of type SkillTable and fill it with

data. Check Listing 4.

Listing 4 - T-SQL to create declare a variable of SkillTable and fill

Data

Declare @EmpSkills as SkillTable
Insert Into @EmpSkills (EmployeeId, EmployeeSkill)
Values (1,'.NET'),
(1,'SQL'),
(2,'All'),
(3,'Sales')

8. Now, it is time to create a stored procedure that would use the

EmpSkills as a passed variable. Listing 5 shows the use of this

variable to bulk insert the skills using the variable. Please note the

read only attribute next to the variable name prohibits the stored

procedure from modifying the content of the table-value parameter.

Listing 5 - T-SQL Shows the complete usage of the data type table value

CREATE PROCEDURE AssociateSkills
@SkillList SkillTable READONLY
AS
INSERT INTO TblEmpSkills (EmployeeID, EmployeeSkill, AcquiredSince)
SELECT EmployeeId, EmployeeSkill, GETDATE() FROM @SkillList;

Declare @EmpSkills as SkillTable

Insert Into @EmpSkills (EmployeeId, EmployeeSkill)
Values (1,'.NET'),
(1,'SQL'),
(2,'VB'),
(3,'Dot Net')
Execute AssociateSkills @EmpSkills

The table value parameter would solve the problem of sending multiple row values and will also, to a certain extent, replace the temporary table because they can be sent between stored procedures.

UNIQUEIDENTIFIER vs.TIMESTAMP

noreply@blogger.com (ashapatel) — Wed, 15 Apr 2009 10:57:00 +0000

In SQL Server, UNIQUEIDENTIFIER and TIMESTAMP are data type.

* * Size : Size of TIMESTAMP is 8 bytes - Size of UNIQUEIDENTIFIER is 16 bytes
* Value : TIMESTAMP is not based on system date or time - UNIQUEIDENTIFIER value is based on the computer's MAC addresses and system date time.
* Purpose :
TIMESTAMP - To track the operation in tables on the database level
UNIQUEIDENTIFIER -To unique value assigned to a row (maybe as primary key).
It remains unique in any system in the world

TIMESTAMP

noreply@blogger.com (ashapatel) — Wed, 15 Apr 2009 10:46:00 +0000

TIMESTAMP contains binary format string to denote a version of a row in table. so it is also called ROWVERSION.

A timestamp is a sequence of characters, denoting the date and/or time at which a certain event occurred.

Create Table:
CREATE TABLE TestTable(RowID INT IDENTITY(1,1) NOT NULL,
TIMESTAMP, [SmallDateTime] SMALLDATETIME,
[DateTime] DATETIME)

Table can have only one TIMESTAMP column. We can have either of a TIMESTAMP or ROWVERSION column type in table, but not both

Benefit of TIMESTAMP in multi-user access on TABLE.

Row-versioning can be used to examine the changes in table. It can also help to manage the synchronization in multiuse access.
If two user work on same table at the same time.
both A and B checks if the already read TIMESTAMP value still matches the TIMESTAMP value of the same row in the table, then they can go for update. If the TIMESTAMP value differs then it means another user has already modified that row, so it requires reading that table.

we do not need to update a timestamp column value manually

Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool.

noreply@blogger.com (ashapatel) — Wed, 15 Apr 2009 10:01:00 +0000

Opening a database connection is a resource intensive and time consuming operation. Connection pooling increases the performance of Web applications by reusing active database connections instead of creating a new connection with every request. Connection pool manager maintains a pool of open database connections. When a new connection requests come in, the pool manager checks if the pool contains any unused connections and returns one if available. If all connections currently in the pool are busy and the maximum pool size has not been reached, the new connection is created and added to the pool. When the pool reaches its maximum size all new connection requests are being queued up until a connection in the pool becomes available or the connection attempt times out.

Connection pooling behavior is controlled by the connection string parameters. The following are four parameters that control most of the connection pooling behavior:

Connect Timeout - controls the wait period in seconds when a new connection is requested, if this timeout expires, an exception will be thrown. Default is 15 seconds.
Max Pool Size - specifies the maximum size of your connection pool. Default is 100. Most Web sites do not use more than 40 connections under the heaviest load but it depends on how long your database operations take to complete.
Min Pool Size - initial number of connections that will be added to the pool upon its creation. Default is zero; however, you may chose to set this to a small number such as 5 if your application needs consistent response times even after it was idle for hours. In this case the first user requests won't have to wait for those database connections to establish.
Pooling - controls if your connection pooling on or off. Default as you may've guessed is true. Read on to see when you may use Pooling=false setting.

For Solve this Problem, set connect timeout period,pooling and max pool size in Sql Connection string in web.config file.

Like

< add key="connstring" value="Server=NILSON1;UID=sa;PWD=;database=final_database;Connect Timeout=90000; pooling='true'; Max Pool Size=70000 " / >

SQL Connection String OR Access Connection String OR How to Get Database Connection String

noreply@blogger.com (ashapatel) — Wed, 15 Apr 2009 07:20:00 +0000

When Your Are confuse in database connection string.

use this simple way.

1.first create one text file.
2.rename with conn. txt
3.now change the extension. Extention name is .udl
4. now your file name is conn.udl
5. Open the conn.udl file
6. u will show data link property
7. select provider name in provider tab(for Sql Server database , select "Microsoft OLE DB Provider for SQL Server")
8. then click on connection tab
9. select database source name,enter user name,password and database name
10. Click on text connection. if you get succeed message.
11. open conn.udl file in text or notepage. You will get connection string
like "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=BusinessCoupon;Data Source=NILSON1"

Mail Alert Process Or Set Scheduler in SQL Database

noreply@blogger.com (ashapatel) — Wed, 01 Apr 2009 09:27:00 +0000

Mail Alert Process in SQL Server Database
This Process called Scheduler.
when you want to set scheduler in database which checks specific time automatically and send mail to those users whose criteria are match,set Job Functionality in Management tools in SQL server 2000

Steps are Here....

First, open sql server 2000. open Management tools.then open jobs. create new jobs.

there are 4 tabs.
1) General:
- Give name like (beforeads)
- category(uncategorized(local))
- owner(NILSON1\Nilson)
- description(anything)

2) step:
-> new
->Generel:
- step name like(stepads)
- Type like (Activexscript)
- Database like (classified)
- command like(vbscript codding (shaow dailymail.atxt))
3) schedule:
- name like(scheduleads)
- and also set time

If u need more help...put your questions...i will reply u...

Does Not Allow Remote Connection For SQL Server

noreply@blogger.com (ashapatel) — Sat, 28 Mar 2009 09:05:00 +0000

when we can't access our sql on another computer which is Connect in Network then Check Permition of Remote connection access.

Allow Remote Connection Using below Path

Start ->ProgramFiles ->Sql Server 2005 -> Configuration Tools -> SQL Server Surface Area Configuration -->Surface Area Configuration For Services and Connections -> MSSQLSERVER -> Database Engine ->Remote Connection

- and then Give permition on Local and Remote Connection and Using TCP/IP Only

- IIS installed after visual studio 2005 not working - IIS installation after visual 2005 install

noreply@blogger.com (ashapatel) — Wed, 25 Mar 2009 06:38:00 +0000

Hello Friends,

after visual 2005 installation, if u have not installed IIS First and U have install Visual 2005 first. then IIS not working perfect.

U have face this problem?

No worry...try below process.

First run command prompt using

start menu -> Run -> write cmd -> Enter

Then write below link in your command prompt

C:\windows\Microsoft.NET\Framework\v2.0.50727\aspnet_regiis.exe -i

Then Enter.

Server Error in '/' Application - Validation of viewstate MAC failed error OR how to solve Mac Failed Error

noreply@blogger.com (ashapatel) — Sat, 24 Jan 2009 06:29:00 +0000

This error occured when server can't read fast view state value

//use this tag in web config file in < system.web >

< system.web >

< enableeventvalidation="false">

viewstateencryptionmode="Never" >

< / system.web >

Get return value in asp.net From SQL server

noreply@blogger.com (ashapatel) — Tue, 06 Jan 2009 11:28:00 +0000

step1 : create stored procedure

CREATE PROCEDURE dyntable (@ptable varchar(50),@new_var int Output )

BEGIN

Select @new_var=count(*) from admin_master

return @new_var

END

step 2: Retrive in asp.net

public void CreatefieldListTable(string strtablename)

{

string intconfirm = "";

SqlConnection conn = new SqlConnection(objconn.GetConnection());

SqlCommand cmdInsert = new SqlCommand("dyntable", conn);

cmdInsert.CommandType = CommandType.StoredProcedure;

cmdInsert.Parameters.AddWithValue("@ptable", strtablename);

SqlParameter var =new SqlParameter("@new_var",SqlDbType.Int);

var.Direction = ParameterDirection.Output;

cmdInsert.Parameters.Add(var);

conn.Open();

SqlDataReader dtread;

cmdInsert.ExecuteNonQuery();

string str = Convert.ToString(cmdInsert.Parameters["@new_var"].Value);

conn.Close();

}

Delete all User stored procedure from SQL Server

noreply@blogger.com (ashapatel) — Mon, 05 Jan 2009 07:01:00 +0000

hello friends.... if u want to try this code then first take bakup your database.becauze all user stored procedures will be deleted after this query.

step 1: for check your all stored procedure name. run in query analyzer

SELECT name FROM sys.objects where type_desc ='SQL_STORED_PROCEDURE'

step 2: if step 1 is correct then run below code in query analyzer

Declare @sql Varchar(500)

Declare @get_table varchar(100)

DECLARE s_gettable CURSOR FOR SELECT name FROM sys.objects where type_desc ='SQL_STORED_PROCEDURE'

OPEN s_gettable

FETCH NEXT FROM s_gettable INTO @get_table

WHILE @@FETCH_STATUS = 0

BEGIN

Set @sql='drop procedure dbo.'+@get_table

exec(@sql)

END

FETCH NEXT FROM s_gettable INTO @get_table

END

CLOSE s_gettable

DEALLOCATE s_gettable

How to use different Server Variables

noreply@blogger.com (ashapatel) — Tue, 30 Dec 2008 10:00:00 +0000

: the page the visitor came from.

Request.ServerVariables("HTTP_REFERER")
: get a visitors IP address

Request.ServerVariables("REMOTE_ADDR")
:Find host name of client

Request.ServerVariables("REMOTE_HOST")

: Find server domain name

Request.ServerVariables("SERVER_NAME")

: returns the software running on the server

Request.ServerVariables("SERVER_SOFTWARE")%

:Display the virtual path to the script or application being executed

Request.ServerVariables("SCRIPT_NAME")

:Display users browser and opertaing system

Request.ServerVariables("HTTP_USER_AGENT")

how to send a mail message from a Web Forms page

noreply@blogger.com (ashapatel) — Tue, 30 Dec 2008 09:46:00 +0000

step 1: Import System.Web.Mail Namespace in Html Code

step 2 : add below code in script tag using script language C#

void Page_Load()
{
if (!IsPostBack)
{
txtTo.Text="john@contoso.com";
txtFrom.Text="marsha@contoso.com";
txtCc.Text="fred@contoso.com";
txtBcc.Text="wilma@contoso.com";
txtSubject.Text="Hello";
txtBody.Text="This is a test message.";
txtAttach.Text=@"C:\Documents and Settings\All Users\Documents\My Pictures\Sample Pictures\Sunset.jpg,"
+ @"C:\Documents and Settings\All Users\Documents\My Pictures\Sample Pictures\Winter.jpg";
txtBodyEncoding.Text = Encoding.ASCII.EncodingName;
txtBodyFormat.Text="HTML";
txtPriority.Text="Normal";
txtUrlContentBase.Text="http://www.contoso.com/images";
txtUrlContentLocation.Text="http://www.contoso.com/images";
// Name of relay mail server in your domain.
txtMailServer.Text="smarthost";
}
}

void btnSubmit_Click(Object sender, EventArgs e)
{
string sTo, sFrom, sSubject, sBody;
string sAttach, sCc, sBcc, sBodyEncoding;
string sBodyFormat, sMailServer, sPriority;
string sUrlContentBase, sUrlContentLocation;
int iLoop1;

sTo = txtTo.Text.Trim();
sFrom = txtFrom.Text.Trim();
sSubject = txtSubject.Text.Trim();
sBody = txtBody.Text.Trim();
sAttach = txtAttach.Text.Trim();
sCc = txtCc.Text.Trim();
sBcc = txtBcc.Text.Trim();
sBodyFormat = txtBodyFormat.Text.Trim();
sBodyEncoding = txtBodyEncoding.Text.Trim();
sPriority = txtPriority.Text.Trim();
sUrlContentBase = txtUrlContentBase.Text.Trim();
sUrlContentLocation = txtUrlContentLocation.Text.Trim();
sMailServer = txtMailServer.Text.Trim();

MailMessage MyMail = new MailMessage();
MyMail.From = sFrom;
MyMail.To = sTo;
MyMail.Subject = sSubject;
MyMail.Body = sBody;
MyMail.Cc = sCc;
MyMail.Bcc = sBcc;
MyMail.UrlContentBase = sUrlContentBase;
MyMail.UrlContentLocation = sUrlContentLocation;

if (txtBodyEncoding.Text == Encoding.UTF7.EncodingName)
MyMail.BodyEncoding = Encoding.UTF7;
else if (txtBodyEncoding.Text == Encoding.UTF8.EncodingName)
MyMail.BodyEncoding = Encoding.UTF8;
else
MyMail.BodyEncoding = Encoding.ASCII;

switch (sBodyFormat.ToUpper())
{
case "HTML":
MyMail.BodyFormat = MailFormat.Html;
break;
default:
MyMail.BodyFormat = MailFormat.Text;
break;
}

switch (sPriority.ToUpper())
{
case "HIGH":
MyMail.Priority = MailPriority.High;
break;
case "LOW":
MyMail.Priority = MailPriority.Low;
break;
default:
MyMail.Priority = MailPriority.Normal;
break;
}

// Build an IList of mail attachments.
if (sAttach != "")
{
char[] delim = new char[] {','};
foreach (string sSubstr in sAttach.Split(delim))
{
MailAttachment MyAttachment = new MailAttachment(sSubstr);
MyMail.Attachments.Add(MyAttachment);
}
}

SmtpMail.SmtpServer = sMailServer;
SmtpMail.Send(MyMail);
lblMsg1.Text="C# Message sent to " + MyMail.To;
}

void btnClear_Click(Object sender, EventArgs e)
{
lblMsg1.Text="";
txtTo.Text="";
txtFrom.Text="";
txtSubject.Text="";
txtBody.Text="";
txtAttach.Text="";
txtBcc.Text="";
txtCc.Text="";
txtBodyEncoding.Text="";
txtBodyFormat.Text="";
txtPriority.Text="";
txtUrlContentBase.Text="";
txtUrlContentLocation.Text="";
txtMailServer.Text="";
btnSubmit.Text="Submit";
}

Get stored procedure list from Server Using cursor

noreply@blogger.com (ashapatel) — Tue, 23 Dec 2008 09:50:00 +0000

SELECT name FROM sys.objects where type_desc ='SQL_STORED_PROCEDURE'

How to get return value from SQl query thru Dot Net

noreply@blogger.com (ashapatel) — Tue, 23 Dec 2008 09:29:00 +0000

first create the "dyntable " procedure

CREATE PROCEDURE dyntable (@new_var int Output )

BEGIN

Select @new_var=count(*) from admin_master

return @new_var

END

Get return value in Asp.Net

string intconfirm = "";

SqlConnection conn = new SqlConnection(objconn.GetConnection());

SqlCommand cmdInsert = new SqlCommand("dyntable", conn);

cmdInsert.CommandType = CommandType.StoredProcedure;

SqlParameter var =new SqlParameter("@new_var",SqlDbType.Int);

var.Direction = ParameterDirection.Output;

cmdInsert.Parameters.Add(var);

conn.Open();

SqlDataReader dtread;

cmdInsert.ExecuteNonQuery();

string str = Convert.ToString(cmdInsert.Parameters["@new_var"].Value);

conn.Close();