Skip to main content

How to Save Retrieve Dataset in ViewState | How to retain dataset values on postback

By 

Introduction:
In my previous article I have explained about the code used to encrypt and decrypt password. In this article I am going to explain how to store and retrieve dataset values in viewstate.

Explanation:
 
Normally Dataset values are not available on the postback. To make it available on the post back we are storing it in viewstate. 
Below code explains how to store the dataset values in viewstate.
 
SqlDataAdapter sqlDataAdapter1 = new SqlDataAdapter();
DataSet ds = new DataSet();
// your code here
sqlDataAdapter1.Fill(ds);
System.IO.StringWriter sw = new System.IO.StringWriter();

// Write the DataSet to the ViewState property.
ds.WriteXml(sw);
ViewState["ds"] = sw.ToString();

Below code is used to Retrieve Dataset from View State on PostBack


if (Page.IsPostBack)
{
    System.IO.StringReader sr =
        new System.IO.StringReader((string)(ViewState["ds"]));
    ds.ReadXml(sr);
}

Do you like this article? Help us to improve. If you have any queries post it in comments.
Labels:

Comments

Post a Comment

Popular posts from this blog

Code To Convert rupees(numbers) into words using C#.Net

By
Introduction: In my previous article I have explained about how to validate emailid using javascript . In this article I am going to explain about code used to convert rupees(numbers) into words using C#.Net . Explanation: For explanation purpose I have a page. It has a textbox to input the numbers. And when you click on the convert to words button then it will convert the input numbers into words and shows it in the below label. Below is the C# code used to do this functionality. public static string NumbersToWords( int inputNumber) {     int inputNo = inputNumber;     if (inputNo == 0)         return "Zero" ;     int [] numbers = new int [4];     int first = 0;     int u, h, t;     System.Text. StringBuilder sb = new System.Text. StringBuilder ();     if (inputNo < 0)     { ...
16 comments
Read More...

Puzzles for kids - 12 Days Of Christmas

By
According to the traditional song, on the first day of Christmas (25th December), my true love sent to me: . A partridge in a pair tree On the second day of Christmas (26th December), my true love sent to me THREE presents: . Two turtle doves . A partridge in a pear tree On the third day of Christmas (27th December and so on) my true love sent to me SIX presents: . Three French hens . Two turtle doves . A partridge in a pear tree This carries on until the the twelfth day of Christmas, when my true love sends me: Twelve drummers drumming Eleven pipers piping Ten lords a-leaping Nine ladies dancing Eight maids a-milking Seven swans a-swimming Six geese a-laying Five gold rings Four calling birds Three French hens Two turtle doves A partridge in a pear tree After the twelve days of Christmas are over, how many presents has my true love sent me altogether? Our Solution: 1 + 3 + 6 + 10 + 15 + 21 + 28 + 36 + 45 + 55 + 66 + 78 = 364 presents Which is really interesting when you think ...
Post a Comment
Read More...

Asp.Net DataTable Manipulation - Add, Update,Delete & Sort DataTable in C#.Net & VB.Net

By Anonymous
In the asp.net developer's life it is very common to come across the datatable manipulation. So here i have decided to explain the datatable manipulation like adding records to datatable, editing and updating datatable records,deleting records from datatable based on the condition and finally sorting datatable based on columns.
Post a Comment
Read More...