Shiran's Blog

We know if we have manually binds the data then, we can access the checkbox or what ever the control by it's id.
as follows

CheckBox ck = (CheckBox)GridView1.Rows[e.NewEditIndex].Cells[8].FindControl("yourCheckBoxControl");

What if you auto bided the data to a gridview,

CheckBox ck = (CheckBox)GridView1.Rows[e.NewEditIndex].Cells[8].Controls[0];

The following code snippent shows how to set the selected item of a
DropdownList

DropDownList1.ClearSelection();
ListItem li = DropDownList1.Items.FindByValue("20"); 
DropDownList1.Items.FindByText(li.Text).Selected = true;

I have seen many beginners are struggling to set the selected value  dynamically,
Hope this is very helpful.

This issue is a common one who starts working on Crystal Reports with Dataset (.Net)

Ill show a sample code snippet where you can generate this issue.

                 ReportDocument report = new ReportDocument();    

                 BAgent bAgent = new BAgent();
                 DataSet dsStatus = new DataSet();
                 dsStatus = bAgent.GetStatus();

                 string reportPath = Server.MapPath("/Agent/Reports/GetStatusRpt.rpt");  
                 report.Load(reportPath);

                 report.SetDataSource(dsStatus);// this is the line cause for this issue
                CrystalReportViewer1.ReportSource = report;  
                 CrystalReportViewer1.DataBind();  
                 CrystalReportViewer1.RefreshReport(); 

Here is the solution, use the datset table instead of the dataset

                 ReportDocument report = new ReportDocument();    

                 BAgent bAgent = new BAgent();
                 DataSet dsStatus = new DataSet();
                 dsStatus = bAgent.GetStatus();

                 string reportPath = Server.MapPath("/Agent/Reports/GetStatusRpt.rpt");  
                 report.Load(reportPath);

                 report.SetDataSource(dsStatus.Tables[0]); 
                 CrystalReportViewer1.ReportSource = report;  
                 CrystalReportViewer1.DataBind();  
                 CrystalReportViewer1.RefreshReport(); 

Hope you got rid from this issue. Enjoy coding.

Again I faced an issue, as usual before .net version 2.0 I set a column's visibility property of a gridview to false.
If you are a developer by now you know why I did that. I know you guessed it. I just wanted to use that column's value
in one of my calculations, and didn't want to show it to the user.

Grid is working fine it hides the column I wanted to hide, I am happy!., Suddenly I realized that I don't get the value from
the hidden (visibility= false) column's cell value in the following method.

 protected void grd_SelectedIndexChanged(object sender, EventArgs e)
 {
      GridViewRow row = grd.SelectedRow;
      string aValue = row.Cells[8].Text; //this is the column I set false visibility
 }

I was looking my coding deeply I am sure this is correct 100%, then what has gone wrong?

With 2.0 and above versions on .Net when you set a column of a gridview to visibility false


it doesn't  bind the data to this hidden column. You must be really disappointed hearing this


news, even I did. Wait you don't have to worry so long.

Don't set your column's property visibility to false in the design view. If you do so it will

call before the databind. When there is no column databing is not take place and ignores this hidden column.


Obvious we  don't get data (you are lucky only you didn't get the data, worse case this might throw an error)

Trick to overcome this issue,

RowCreated event of a GridView takes place after the data binding, so we can do something like following

code snippet.

 protected void grd_RowCreated(object sender, GridViewRowEventArgs e)
{
       e.Row.Cells[8].Visible = false;
 }

This hides the column, still you can access the cell value,

 protected void grd_SelectedIndexChanged(object sender, EventArgs e)
 {
      GridViewRow row = grd.SelectedRow;
      string aValue = row.Cells[8].Text; //I get the cell value, I am happy!
}

Enjoy working on Gridview control,

Most of the developers use repeater control, in case where they have to show the totals of a list  instead gridview control.
This is not that difficult to show the totals on the gridview itself on footer template. I will show the steps how to do this in this post.

Drag and drop a Gridview on your .aspx and bind the data.

eg: 

grd.DataSource = ds;
grd.DataBind();

on above code snippet grd is the my Gridview name and ds is my dataset. (you can use any datasource as your convenience)

Set the ShowFooter property to True of the GridView, this will show the footer on the Gridview.

Write the RowDataBound  event as follows, you can change the way you want. (in the following scenario I have not showed the declaration of chkAmount and transCharge 
decimal type variables, these two are class level varibles)

        protected void grd_RowDataBound(object sender, GridViewRowEventArgs e)
        {
          
            if (e.Row.RowType == DataControlRowType.DataRow)
            {                
                chkAmount += Convert.ToDecimal(DataBinder.Eval(e.Row.DataItem,  "ChkAmount"));
                transCharge += Convert.ToDecimal(DataBinder.Eval(e.Row.DataItem, "TransCharge"));
            }
            else if (e.Row.RowType == DataControlRowType.Footer) // this is the footer identification
            {
                e.Row.Cells[4].Text = "Totals:";
                // display totals on cells (in my case I have selected last 3 columns)
                e.Row.Cells[6].Text = chkAmount.ToString("N2");               
                e.Row.Cells[5].Text = transCharge.ToString("N2");
                
            }           
        }      

Hope this is really easier when it comes to show totals on Gridview footer area . Please refer the following image which is the output of my above coding effort.

Instead sending an email we can configure the web.config to drop the mail in a local folder.
This is a good feature when it come to testing email on your application while developing.

Just add the following on the web.config

   1:     <system.net>

   2:       <mailSettings>

   3:         <smtp deliveryMethod="SpecifiedPickupDirectory">

   4:        <specifiedPickupDirectory pickupDirectoryLocation="C:\testmails\"/>

   5:         </smtp>            

   6:       </mailSettings>       

   7:      </system.net>

Following code will drop an email in your folder

   1: var smtpClient = new SmtpClient();

   2: var message = new MailMessage("from@from.com", "to@to.com");

   3: message.Subject = "This is the mail subject";            

   4: message.Body = "this is the mailm body";

   5: smtpClient.Send(message);         

Double click on the file in your C:\testmails\ folder it will open up on outlook
as an email.

Do not need to do any setting on ISS, instead just move in an HTMl file named
App_Offline.htm . This will stop responding to any web request but as the response
this file passes until you remove it from the root or rename it.

I got this error when I try to install Dotnetnuke 05.04.02 on my computer on Wndows 7 and IIS7. There was no proper solution for this on the web, but I just change the application pool identity to NetworkService and application worked as expected.

Steps :
Go to IIS and select Application Pools.
Select the DNN web pool on right hand pane.
On Actions press Set Application Pool Default link.
Change the Identity under Process Model to NetworkService

I had an issue when calling web service through AJAX from 3rd party URL.
Here is the solution

http://developer.yahoo.com/javascript/howto-proxy.html

As I use JQuery these days, I just though how I can use JQuery on my blog.
I tried to do this and found It’s very easy to use it with blogger. Just a few steps
make this possible. You might be wondering where you can place the JQuery file in
blogger. Google has host these file on the following path “http://ajax.googleapis.com/ajax/libs/jquery/”. Just have to select the version you prefer to use.

Just see the following steps.

Step 1:
Add the following code between header tags of your blog’s HTML.

<head>
<script src='http://ajax.googleapis.com/ajax/libs/jquery/1.4/jquery.min.js' type='text/javascript'/>
</head>

Example:

Step 2:
Add the functions in between header tags as follows,

<head>
<script src='http://ajax.googleapis.com/ajax/libs/jquery/1.4/jquery.min.js' type='text/javascript'/>

<script type="text/javascript">
    function MouseOn() {
        $(document).ready(function() {
        $("img").toggleClass("newClass");         
            //$("#testPara").append("Shiran the greatest" + count );

        });
    }
</script>
</head>

Example :

Step 3: (Optional)
If there are any CSS involved embed them also in between header tags as follows

<head>
<script src='http://ajax.googleapis.com/ajax/libs/jquery/1.4/jquery.min.js' type='text/javascript'/>

<script type="text/javascript">
    function ChangeCSS() {
        $(document).ready(function() {
             //here this will toggle CSS classes on an event
         $("img").toggleClass("newClass");       
          
        });
    }

<style type="text/css">
.toggler {width: 100px; height: 200px;}

.newClass {width: 500px; height: 866px;}
</style>

</script>
</head>

Need to call the above ChangeCSS() JS function where this need to be done.

Example:
this maight be in post or a HTML/JavaScript gadget

<img class="toggler" src="http://1.bp.blogspot.com/_8fX3E/S-L0RblzI/AAAADtQ/nB8kJYc/s200/108_f0.jpg" onmouseover="ChangeCSS()"/>

Give your visitors a shock.

I just started to do some JQuery on one of my VS projects. I found that we can have intellisense on VS2008. To make this available I had to do some installations and follow few steps to get intellisense on VS2008, I hope these would helpful you as well in projects.

Step 1:
Install VS 2008 SP1, you can get it here

Step2:
Install VS 2008 Patch KB958502, you can get it here

Step3:
Download JQuery js file and JQuery vsdoc.js, both these should be one version
Eg: jquery-1.4.1-vsdoc.js and jquery-1.4.1.js (version may be differ on the version you have downloaded).
Put both files in the same place in your project.

now you are ready to use. You will get intellisense and auto complete features on VS2009

This is a nice little statement which reduces our coding and minimises prone to errors.
There are many situations we have to Dispose the object we created. Example

string connString = "Data Source=localhost;Integrated Security=SSPI;Initial Catalog=MyDB;";

SqlConnection myConnect = new SqlConnection(connString);            
SqlCommand cmd = myConnect.CreateCommand();
cmd.CommandText = "SELECT * FROM MyTable";

myConnect.Open();

SqlDataReader dr = cmd.ExecuteReader();

while (dr.Read())
{
    Console.WriteLine("{0}\t{1}", dr.GetString(0), dr.GetString(1));
}

dr.Dispose();
myConnect.Close();
myConnect.Dispose();

using (SqlConnection myConnect = new SqlConnection(connString))
{
    SqlCommand cmd = myConnect.CreateCommand();
    cmd.CommandText = "SELECT * FROM MyTable";

    myConnect.Open();

    using (SqlDataReader dr = cmd.ExecuteReader())
    {

        while (dr.Read())
        {
            Console.WriteLine("{0}\t{1}", dr.GetString(0), dr.GetString(1));
        }
    }
}

Instead of having all connection string detail on web.config file , we can create a new configuration
whatEvernName.config eg(connectionString.config) and have all connection string details in this new .config file.

Please go through the code below to understand this.

web.config
<connectionStrings configSource="connectionString.config" />

connectionString.config
<connectionStrings> 
<clear /> 
<add name="myConnection" connectionString="myConnectionString" providerName="System.Data.SqlClient" /> </connectionStrings>

This is really nice feature when you have a lot of tags in your web.config file,
as it increases the readability. There is another cool feature which is very useful for
developers when it’s come to development or rather I would say debug the code.
Most of the times we have our connection string in one file and there is a high chance to forget
to change live connection string properties to test environment properties, I have made such a mistake and had to restore a latest database backup, but luckily there was not any data lost.

This cool feature avoids taking place such a bad mistake. Try this it’s is really nice and you do not have to keep on changing your web.config’s conection string values. As in above code snippet you can have two config files as connectionString.debug.config and connectionString.releaase.config

VS IDE will take the valuse depending on what you have selected, debug or release. Isn’t it cool.
Enjoy…