Clear Textboxes of a Parent Control

 public void ClearTextBoxes(Control ctr)
        {
            foreach (Control ctrl in ctr.Controls)
            {
                if (ctrl is TextBox)
                {
                    TextBox t = ctrl as TextBox;

                    if (t != null)
                    {
                        t.Text = String.Empty;
                    }
                }
                else
                {
                    if (ctrl.Controls.Count > 0)
                    {
                        ClearTextBoxes(ctrl);
                    }
                }
            }
        }

Call Parent Page Function in User Control

Some times we need to Call a Parent Page Function in User Control .
It Can Easily done using Reflection .

 this.Page.GetType().InvokeMember("MethodName", System.Reflection.BindingFlags.InvokeMethod, null, this.Page, null);

Just give Name of your Parent Page Function at the Place of MethodName.

Use Eval Function in Visible Property

We can also come to a situation where we need to Hide a button inside Gridview,DataList or Reapeter on certain condition .
For that you may follow below steps :

1. Find Button control in RowDataBound or RowCreate event 
2. Check Condition to Hide Button 
3. Then Set Visible property of that button

But you can do this on your aspx page itself only.
Using Following Code.


<asp:Button ID="btnDelete" runat="server"  Text="Delete"                                                             Visible='<%#Convert.ToInt32(Eval("StudentId")) != 0 %>' />

Data Binding Microsoft Chart Control

Overview

When you add a new visualization in your application, the very first thing you do, is bind it to the data. Microsoft Chart control allows many different ways of populating data in the chart and it is important to understand the differences between them and being able to choose the best approach. I put together all the possible data binding options and the scenarios when they should be used.

Data Sources

Before jumping into the binding methods I want to quickly list all the supportable data sources which can be used in chart binding methods. Keep in mind that not all methods accept all source types.

• SqlCommand
• OleDbCommand
• SqlDataAdapter
• OleDbDataAdapter
• DataView
• DataSet
• DataReader
• List
• Array
• IList
• IListSource
• IEnumerable

Data Point X and Y values

When you bind chart you create series and series data points. Each data point in the series should have it's Y value set and in addition to the Y value you can also bind or set other data point properties:

• X Value - Defines location of the data point along X axis. If not specified, data point index in the series will be used.
• Additional Y Values - Chart types like Bubble or Stock require multiple Y values. You can also bind additional Y values in the regular chart types, if you want to use those values for labels or tooltips.
• Category - When you displaying categories on the X axis, they are stored in the AxisLabel property of the data point. All data binding methods will automatically detect the type of the data and you should not worry about it.
• Other Properties - Some of the binding methods allow you to set additional properties like data point labels, tooltips and others.

Binding Options Overview

This table lists data binding techniques, starting from the most basic methods proceeding to more advanced.

Chart.DataBindTable	Simple binding for X and Y values. Automatic series creation, based on the number of columns in the data source.	No multiple Y values per series. All series have same X value, or it is not set. No binding for extended chart properties like tooltips.
Chart.DataSource and Chart.DataBind	Can be used at design-time. Supports multiple Y values.	No binding for extended chart properties like tooltips.
Points.DataBind(X)Y	Supports multiple data sources, including separate data source for X and Y values. Supports multiple Y values. Provides more flexibility than methods above	No binding for extended chart properties like tooltips.
Points.DataBind	Same as the above, plus: Supports binding for extended chart properties like tooltips.	Does not support different data sources for X and Y values of a series.
Chart.DataBindCrossTab	Automatically creates series for each unique value in specified column used to group the data.	Only single level grouping is supported.

Binding Options Details

Chart.DataBindTable method

The Chart.DataBindTable method is the simplest way to bind chart to a table with several columns. New series will be automatically created for each of the columns and you can optionally use one column for the X value for all series.
Example
Imagine you have a data source containing these columns: Prod A, Prod B, Prod C, Prod D, Prod E, Other and SalesName, you can easily create chart below with a single line of code:

Chart1.DataBindTable(myReader, "SalesName");

Chart1.DataBindTable(myReader, "SalesName");

 

Chart.DataSource property

Chart DataSource property is the only way to bind chart at design-time. In addition to specifying the DataSource property you also need to create series and set their YValueMembers and optionally XValueMember properties. Multiple Y values can be bound if you specify comma separated list of members in the YValueMembers property.
Chart will automatically bind itself to specified data source and members just before rendering. You can force chart to bind at any moment by calling Chart.DataBind() method.

// Set chart data source
chart1.DataSource = myCommand;

// Set series members names for the X and Y values
chart1.Series["Series 1"].XValueMember = "Name";
chart1.Series["Series 1"].YValueMembers = "Sales";

// Data bind to the selected data source
chart1.DataBind();

// Set chart data source
chart1.DataSource = myCommand;

// Set series members names for the X and Y values
chart1.Series["Series 1"].XValueMember = "Name";
chart1.Series["Series 1"].YValueMembers = "Sales";

// Data bind to the selected data source
chart1.DataBind();

 

DataBindCrossTab

The Chart.DataBindCrossTab is different compared to all other binding methods, in that it allows for the grouping of unique values in a column. Each unique value in the specified grouped column results in the creation of a data series. In addition, extended data point properties other than X and Y values can be bound.
These other properties are bound using the otherFields parameter using this syntax:

PointProperty=Field[{Format}] [,PointProperty= Field[{Format}]].

A list of these properties are as follows: AxisLabel, Tooltip, Label,  LegendText,  LegendTooltipand CustomPropertyName (the name of a custom property). For more information on possible formats see the Formatting Types topic in the MSDN library.
Example
In the sample below we have a table that has the sales and commissions of sales people for three years. We group by the "Name" column, thereby creating one data series per sales person. The X values are bound to the "Year" column, the Y values are bound to the "Sales" column, the Label property of the resulting data points (one per record) is bound to the "Commissions" column, and the LegendText property is bound to the "Name" column.

// Group by "Name" column, bind X values to "Year", Y values to "Sales",

// and Label property to "Commissions.

chart1.DataBindCrossTab(myReader, "Name", "Year", "Sales", "Label=Commissions");

// Group by "Name" column, bind X values to "Year", Y values to "Sales",
// and Label property to "Commissions.
chart1.DataBindCrossTab(myReader, "Name", "Year", "Sales", "Label=Commissions");

 

Points.DataBind

This method allows for data point properties other than X and Y values to be bound to data columns. For example, you want to set data point label to a value in one of the data source columns. These other properties are bound using the otherFields parameter using this syntax:

PointProperty=FieldName[{Format}][,PointProperty= FieldName[{Format}]]

A list of these properties includes: AxisLabel, Tooltip, Label,  LegendText,  LegendTooltip andCustomPropertyName (the name of a custom property).
This method does not allow you to specify separate data sources for the X and Y values of a series (for this functionality use the DataBind(X)Y methods described in the section above).
Example
Code below demonstrates how to bind X and Y values of the series to columns "Name" and "Sales" respectively. The Label and Tooltip properties of the resulting data points are also bound to the "Commissions" and "Year" column.

Chart1.Series["Series1"].Points.DataBind(
myReader, "Name", "Sales", "Tooltip=Year, Label=Commissions{C2}");
myReader, "Name", "Sales", "Tooltip=Year, Label=Commissions{C2}");

 

Points.DataBind[X]Y

The DataBindXY method allows for the binding of X and Y values of a series, while DataBindY binds Y values only. When binding X and Y values using DataBindXY the same or different data sources may be used.
Some data sources support multiple values (e.g. data sources that have columns of data). For example, OleDbDataReader may have access to more than one column of data. If the column to be used is not specified, then the first available column will be used. To use a column other than the first one just specify the column name in the method call.
Note that when specifying the column names to be bound to the Y values a comma can be embedded as part of a column name by specifying a double comma.
Example
Code below demonstrates how to bind series points to the array of doubles.

// Initialize an array of doubles.

double [] array = { 2.8, 4.4, 6.5, 8.3, 3.6, 5.6, 7.3, 9.2, 1.0};

// Bind the double array to the Y axis points of the data series.

Chart1.Series["Series1"].Points.DataBindY(array);

// Initialize an array of doubles.
double [] array = { 2.8, 4.4, 6.5, 8.3, 3.6, 5.6, 7.3, 9.2, 1.0};

// Bind the double array to the Y axis points of the data series.
Chart1.Series["Series1"].Points.DataBindY(array);

'Manual' series population

In case you need to perform some custom actions while binding and none of the above methods works, you can always 'manually' bind chart by iterating through the data source and add data points to the series as needed. This approach is also very useful when series data is calculated using some formula.
Example

// Resolve the address to the Access database

string fileNameString = this.MapPath(".");

fileNameString += "..\\..\\..\\data\\chartdata.mdb";

// Initialize a connection string

string myConnectionString = "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source=" + fileNameString;

// Define the database query

string mySelectQuery="SELECT * FROM SALESCOUNTS;";

// Create a database connection object using the connection string

OleDbConnection myConnection = newOleDbConnection(myConnectionString);

// Create a database command on the connection using query

OleDbCommand myCommand = new OleDbCommand(mySelectQuery, myConnection);

// Open the connection

myCommand.Connection.Open();

// Initializes a new instance of the OleDbDataAdapter class

OleDbDataAdapter myDataAdapter = new OleDbDataAdapter();

myDataAdapter.SelectCommand = myCommand;

// Initializes a new instance of the DataSet class

DataSet myDataSet = new DataSet();

// Adds rows in the DataSet

myDataAdapter.Fill(myDataSet, "Query");

foreach(DataRow row in myDataSet.Tables["Query"].Rows)

{

// For each Row add a new series

string seriesName = row["SalesRep"].ToString();

Chart1.Series.Add(seriesName);

Chart1.Series[seriesName].ChartType = SeriesChartType.Line;

Chart1.Series[seriesName].BorderWidth = 2;

for(int colIndex = 1; colIndex < myDataSet.Tables["Query"].Columns.Count; colIndex++)

{

// For each column (column 1 and onward) add the value as a point

string columnName = myDataSet.Tables["Query"].Columns[colIndex].ColumnName;

int YVal = (int) row[columnName];

Chart1.Series[seriesName].Points.AddXY(columnName, YVal);

}

}

DataGrid.DataSource = myDataSet;

DataGrid.DataBind();

// Closes the connection to the data source. This is the preferred

// method of closing any open connection.

myCommand.Connection.Close();

// Resolve the address to the Access database
string fileNameString = this.MapPath(".");
fileNameString += "..\\..\\..\\data\\chartdata.mdb";

// Initialize a connection string
string myConnectionString = "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source=" + fileNameString;

// Define the database query
string mySelectQuery="SELECT * FROM SALESCOUNTS;";

// Create a database connection object using the connection string
OleDbConnection myConnection = newOleDbConnection(myConnectionString);

// Create a database command on the connection using query
OleDbCommand myCommand = new OleDbCommand(mySelectQuery, myConnection);

// Open the connection
myCommand.Connection.Open();

// Initializes a new instance of the OleDbDataAdapter class
OleDbDataAdapter myDataAdapter = new OleDbDataAdapter();
myDataAdapter.SelectCommand = myCommand;

// Initializes a new instance of the DataSet class
DataSet myDataSet = new DataSet();

// Adds rows in the DataSet
myDataAdapter.Fill(myDataSet, "Query");

foreach(DataRow row in myDataSet.Tables["Query"].Rows)
{
   // For each Row add a new series
   string seriesName = row["SalesRep"].ToString();
   Chart1.Series.Add(seriesName);
   Chart1.Series[seriesName].ChartType = SeriesChartType.Line;
   Chart1.Series[seriesName].BorderWidth = 2;

   for(int colIndex = 1; colIndex < myDataSet.Tables["Query"].Columns.Count; colIndex++)
   {
      // For each column (column 1 and onward) add the value as a point
      string columnName = myDataSet.Tables["Query"].Columns[colIndex].ColumnName;
      int YVal = (int) row[columnName];

      Chart1.Series[seriesName].Points.AddXY(columnName, YVal);
   }
}

DataGrid.DataSource = myDataSet;
DataGrid.DataBind();

// Closes the connection to the data source. This is the preferred
// method of closing any open connection.
myCommand.Connection.Close();

Other useful things to know

Here are couple things that you should know about when binding chart:

• Empty Points - Understand what empty points are and how you can use them. Right now the best source of the information is Chart Sample Environment but I will blog about it later.
• AlignDataPointsByAxisLabel - If you are using a stacked chart type with categorical X axis this helper method can be very useful. Find more information in the documentation and Chart Sample Environment.

Reference :

http://blogs.msdn.com/b/alexgor/archive/2009/02/21/data-binding-ms-chart-control.aspx

how to copy rows from one dataset to another in asp.net c#

DataSets in ASP.NET are usually read-only. Data has an affinity with its parent DataSet. This means that it is difficult to copy a row from one DataSet to another. The source of your data should normally be altered toaccommodate copying data. This is not always feasible though. In my situation, I needed to filter specific products from the originating DataSet. Unfortunately, I enountered many errors such as: "This row already belongs to another table".

Using the following code you can easily filter rows from one DataSet to another. I have bolded the areas you should pay attention to. ds1.Clone() replicates ONLY the structure of the DataSet. This is important if you were to just create a new DataTable and try to add new rows. ASP.NET would produce an error stating that the DataSet does not contain the same number of rows as the source. My first reaction was to use ds1.Tables[0].Rows.Add(), however, this did not work because of an error (e.g. the row already belongs to another DataSet).     


DataSet ds = new DataSet();
        DataSet dsCopy = new DataSet();
        if (ds.Tables[0].Rows.Count > 0)
        {
            foreach (DataRow dr in ds.Tables[0].Rows)
            {
                dsCopy.Tables[0].ImportRow(dr);
            }
        }

Set Text for a Textbox with TextMode is Password

If You a Textbox with property TextMode="Password" ,
if you try to Assign a Value to It .
txtPassword.Text = "Sometext" ;
No Text will Appear in Text box .

Correct way to Assign :
txtPassword.Attributes.Add("value", "Sometext") ;