Vijay Negi

Print Only Grid View in ASP.net

2017-09-11T03:54:00.000-07:00

ASP.net How to Print Only GridView

<div id="gridviewDiv">

   <asp:GridView ID="gridViewToPrint" runat="server"

                  DataSourceID="SqlDataSource1">

     <Columns>

    <asp:BoundField DataField="CategoryID"

                    HeaderText="CategoryID"/>

    <asp:BoundField DataField="CategoryName"

                    HeaderText="CategoryName"/>

    </Columns>

    </asp:GridView>

   </div>

   <asp:Button ID="btnPrint" runat="server"

               Text="Print GridView Data"/>

protected void Page_Load(object sender, EventArgs e)
    {
        string printScript =
        @"function PrintGridView()
         {
            var gridInsideDiv = document.getElementById('gridviewDiv');
            var printWindow = window.open('gridview.htm','PrintWindow','letf=0,top=0,width=150,height=300,toolbar=1,scrollbars=1,status=1');
            printWindow.document.write(gridInsideDiv.innerHTML);
            printWindow.document.close();
            printWindow.focus();
            printWindow.print();
            printWindow.close();}";
        this.ClientScript.RegisterStartupScript(Page.GetType(), "PrintGridView", printScript.ToString(), true);
        btnPrint.Attributes.Add("onclick", "PrintGridView();");       
    }

Basic of MVC in ASP.net

2017-09-11T03:53:00.001-07:00

Few Basic Things For Starting Up With ASP.NET MVC

Developing a Web Application by Using ASP.NET MVC 2
■ Structure an ASP.NET MVC application.
■ Create custom routes.
■ Create controllers and actions.
■ Create and customize views.

First Part(UNDERSTANDING BLOG:What is MVC)

DIFFRENCES With ASP.NET
MVC, you write the model, create the views, and code the controllers; thus you have finer
control over how each request is handled and each response is rendered. With ASP.NET MVC,
there is less “hidden” from you (and thus less work done automatically for you).

ASP.net:
ASP.NET application basic architecture , in
which requests are handled by ASP.NET: it calls your page; it executes your events in order;
those events affect the response; and ASP.NET ultimately returns the response.

MVC
MVC application has a different architecture, page processing model, conventions,
and project structure than an ASP.NET web form site.

MVC Components:
These components should be familiar to you as a web developer. A controller is a class; the
model is either made up of custom classes or generated classes that use the Entity Framework
or LINQ to SQL; and the views are ASPX webpages. The following list provides a more detailed
definition of these components:
Controller often called the connection between the model and the view.

Life Cycle of MVC

1.You add routes to this collection inside the Global.asax file’s
RegisterRoutes method (which is called by Application_Start).

2.These routes are added to the
table when your application starts.

3The request is then mapped to a route, and
RouteData and RequestContext objects are created to represent the route and the request, respectively.

4.Processing of the RequestContext object is then passed to classes in the System.Web.Mvc
namespace.

5.The MvcRouteHandler class handles the routing to your MVC controller class. It
creates an instance of MvcHandler to actually call the controller and run its Execute method.

6.Your controller then uses ControllerActionInvoker to determine which action to run based
on the request.

7.Your action method accepts the user input and prepares a response

ROUTES
You add routes to this collection inside the Global.asax file’s
RegisterRoutes method (which is called by Application_Start).You must know both way
1.by direct RouteTable class
2.RegisterRoutes method

Understanding Routing Basics

Your website can respond to both ASP.NET and ASP.NET MVC requests. If no route is found
for a request, the request passes to ASP.NET for processing.

ASP.Net Website/.NET 4.0
(add a Global.asax file)

<%@ Application Language="C#" %>
<%@ Import Namespace="System.Web.Routing" %>
<script runat="server">

    void Application_Start(object sender, EventArgs e)
    {

        RouteTable.Routes.MapPageRoute("Department", "Department/CITY/{DeptName}", "~/DepartmentwiseEmployees.aspx");
      RouteTable.Routes.MapPageRoute("Department1",        "Dex/{student_name}", "~/Default3.aspx");

    }

</script>

MVC Project/.NET4.0
(you will find a file global.asax with this code)

using System.Web.Mvc;
using System.Web.Routing;

namespace MvcApplication1
{

    public class MvcApplication : System.Web.HttpApplication
    {
        public static void RegisterRoutes(RouteCollection routes)
        {
            routes.IgnoreRoute("{resource}.axd/{*pathInfo}");

            routes.MapRoute("Default", // Route name
                "{controller}/{action}/{id}", // URL with parameters
                new { controller = "Home", action = "Index", id = UrlParameter.Optional } // Parameter defaults
            );

        }

        protected void Application_Start()
        {
            AreaRegistration.RegisterAllAreas();

            RegisterRoutes(RouteTable.Routes);
        }
    }
}

//RegisterAllAreas() call to ensure that the area mapping is carried out.
--------------------------------------------------------------------------------------------------------------------

Either write in RegisterRoutes Method as Above or directly Type RouteTable.Routes.MapPageRoute

Defining Application Areas
AREA
(just give you logical ready made structure of folder if you want more folder to hold Controller,Views and model)

You can use the default project structure for most websites without having any problems.
However, there are some sites that are very large; keeping all the models, views, and controllers
in this single folder set can be difficult to manage. For such cases, you can define
different MVC project areas in your application.
An area in ASP.NET MVC is a subset of the project structure based on a logical grouping.
Each area contains area-specific models, views, and controllers. The root of the site contains
the sitewide models, views, and controllers. This type of partitioning can make it easier to
manage your application files.
You create an area in ASP.NET MVC by right-clicking the project and choosing Add | Area.
You give each area a name and Visual Studio generates a separate set of folders for storing
the MVC files in your area.

Explanations With Screenshots

You Must Go Through This At A Glance
Quick Check
1. What is the ASP.NET MVC convention for naming controller classes?
2. What is the ASP.NET MVC convention for storing views?
3. What is the ASP.NET MVC convention for naming views?

Quick Check Answers
1. You name your controller classes after entities in your model and add the
Controller suffix, as in EntityController.
2. A view should be stored in a folder with the same name as the controller (minus
the suffix), as in Entity.
3. A view should be named after the action method in the controller, such as
Index.aspx or Create.aspx.

Didn't Undersand?Ok!

1)GLOBAL.ASAX File

2.PROJECT FILES SCREENSHOT #1

3.PROJECT FILES SCREENSHOT #2

4.CONTROLLER CLASS

5.NAMING DEPENDENCIES OF ALL (you can not name anything to Controller and call it with any function name with any name of view, there are some patterns and way to follow)

1. You name your controller classes after entities in your model and add the Controller suffix, as in EntityController.

2. A view should be stored in a folder with the same name as the controller (minus the suffix), as in Entity.

3. A view should be named after the action method in the controller, such as Index.aspx or Create.aspx.

SQL Server Is Too Busy...

2017-09-11T03:51:00.003-07:00

SQL Server Is Too Busy...
Quick Tips and tricks to tackle with performance

What?

Today I will guide to resolve the “server too busy” error in asp.net.

Why?

There are few no of reasons to occur this error. By the word itself, we can under this error is occurred when server unable to handle the requests and go busy out while trying to do so.following could be the response which could be the reason of slow down the server.

1. QUERY RESPONSE: The database query may take long time to respond.
2. IIS RESPONSE: No of free threads not enough to IIS to handle the request
3. MEMORY RESPONSE:In your code has memory leaks
4. LOOP RESPONSE: In your code have infinite loops.
5. VISITOR RESPONSE: Server does not have capabilities to handle huge no of visitors.

Solution?

•    If first one is reason for this error, then you may to review your query using SqlProfiler and fix the query to response quickly.
•    If your code has memory leaks or infinite loops, then you have to review your code and have to fix.
•    The second is most important on for this error. But we can fix this case easily with webconfig file.
When you are take look your web config file, there is a tag call httpRuntime like following normally.

<httpRuntime executionTimeout="3600" maxRequestLength="4096" />

More details about httpRuntime here
To resolve this error with web config, we have to override the following attributes in config.

1.    executionTimeout
2.    maxRequestLength
3.    minFreeThreads
4.    minLocalRequestFreeThreads

executionTimeout

Specifies the maximum number of seconds that a request is allowed to execute before being automatically shut down by ASP.NET.
This time-out applies only if the debug attribute in the compilation element is False. If the debug attribute is True, to help avoiding application shut-down while you are debugging, do not set this time-out to a large value. The default is 110 seconds.

maxRequestLength

Specifies the limit for the input stream buffering threshold, in KB. This limit can be used to prevent denial of service attacks that are caused, for example, by users posting large files to the server. The default is 4096 KB

minFreeThreads

Specifies the minimum number of free threads to allow execution of new requests. ASP.NET keeps the specified number of threads free for requests that require additional threads to complete processing. The default is 8.

minLocalRequestFreeThreads

Specifies the minimum number of free threads that ASP.NET keeps available to allow execution of new local requests. The specified number of threads is reserved for requests that are coming from the local host, in case some requests issue child requests to the local host during processing. This helps to prevent a possible deadlock with recursive reentry into the Web server. The default is 4.

(API definition from MSDN)
Now we have to override values for above attributes. Once override web config file will look followings,

<httpRuntime enableVersionHeader="false" executionTimeout="72000" maxRequestLength="4096" minFreeThreads="72" minLocalRequestFreeThreads="88" useFullyQualifiedRedirectUrl="false" />

Just override your production web configuration file with above modfied file. Now see your server to able to handle more request than earlier.But your web server does not enough memory or CPU, then you have to upgrade that to support to handle to more request.

Conclusion

In tips I have given solutions to “server too busy” error in asp.net.i hope this is help to you all.

Find Control Under RowCommand

2017-09-11T03:45:00.002-07:00

Find Control Under RowCommand

protected void GridViewtemp_RowCommand(object sender, GridViewCommandEventArgs e)
    {
        if (e.CommandName == "AddSchedule")
        {
                pnlschedule.Visible = true;
                lblscheduleforItem.Text = e.CommandArgument.ToString();

                GridViewRow row = (GridViewRow)(((ImageButton)e.CommandSource).NamingContainer);
                Label lblDate = (Label)row.Cells[0].FindControl("lblName");
                string teamName = lblDate.Text;
                int rowindex = row.RowIndex;
                lblscheduleforItemName.Text = ((Label)GridViewtemp.Rows[rowindex].FindControl("lblName")).Text;

        }
    }

SQL Transaction In C#,ASP.Net

2017-09-11T03:45:00.000-07:00

Transaction In C#,ASP.Net

SqlTransaction transaction;
con.Open();
transaction = con.BeginTransaction();
try
{
for (int i = 0; i < dtTemp.Rows.Count; i++)
{
SqlCommand cmd = new SqlCommand("insert command....", con,transaction);
cmd.ExecuteNonQuery();
}
transaction.Commit();
}

catch (Exception Error)
{


}




In above Part the only thing you have to care about is 


SqlTransaction transaction;
con.Open();
transaction = con.BeginTransaction();
try
{

  SqlCommand cmd = new SqlCommand("insert command....", con,transaction);
  cmd.ExecuteNonQuery();

  transaction.Commit(); //whenever you call commit it means now finaly

                        //all execution will take place else rollback to catch

catch

 transaction.Rollback();

What is Async & Await in C# .net?

2016-08-26T08:08:00.003-07:00

What is Async & Await in C# .net?

If you are familiar with normal ASP.net C# code then this would be easy for you to understand.
just see the below code I'll explain it later (don't go with long red arrow)

In above its a simple asp.net web page code behind where someone click the Button1_Click,and then a callprocess() function get called.after this function we add "Program finish" text in a ListBox1.and increment value of a variable val to 10.

Now how do you think the code need to behave.

STEP 1>STEP 2>STEP3

WHAT you assume normally

1.int val=0 set in top and declared in last of the button click so val>=10 must fail. right?

2.Listbox add item "Program finish" in last but before it, callprocess() method comes which adding a item "Long Process finish" .so ListBox1 must have LongProcessFinsh in top and Programfinish after that .right?

BUT what realy happens?

Let me tell you everything happen exactly opposite of it.

STEP3(as callprocess() is async other code could not wait for it which has await attach to it)>STEP1>STEP2

In callprocess function the condition "if(val>-0" have value 10 in it already.and ProgramFinish is already added in Listbox1 before LongProcessFinish.

Its because we declare await inside a function (await always do a task(your async kind of task))await LongProcess();

and when you added it you must declare that function with async.

public async void CallProcess()
CallProcess();//this is detected as async with calling himself await
this.ListBox1.Items.Add("Program finish");//they executed without wait
val += 10; //they execute without wait

so what basicaly async/await/Task doing

Async:keyword to declare yes this is a async method

Await:this code will execute but telling other code part dont wait for me I am coming from behind.

Task:like void,we perform here our task which return type is

Void: Means nothing to return

Task: It will perform one operation, a little similar to void but the difference is there.

Task<T>: Will return a task with a T type parameter. (I hope you are familiar with the concept of T)

Deploy Website In IIS (Asp.net)

2016-06-13T02:45:00.003-07:00

Deploy Asp.net Website In IIS Local

1.keep your project in a folder (eg. D://MyProj/Proj1)

2.go to run

3.type inetmgr

4.on server(LEFT SIDE PANEL) go to sites>default websites

5.right click on default website and add application

6.give any alias(name for ur project)

7.asp.net application poll must be .net framework 4.0

8.in physical path enter path where your project reside.(eg. D://MyProj/Proj1)

9.'default document' is used to set start_page in case user do not provide any page in url (eg. index.html/defalt.aspx)

10.now go on ur website showing in IIS,right click,manage site and browse.

Below are the solutions for few error which often comes out.

1)HTTP Error 403.14 - Forbidden - The Web server is configured to not list the contents of this directory

DO 1: Enable the Directory Browsing feature in IIS (Recommended)

1. Start IIS Manager. To do this, click Start, click Run, type inetmgr.exe, and then click OK.

2. In IIS Manager, expand server name, expand Web sites, and then click the website that you want to modify.

3. In the Features view, double-click Directory Browsing.

4. In the Actions pane, click Enable.

If that does not work for, you might be having different problem than just a Directory listing issue. So follow the below step,

ELSE DO 2: Add a default document

To resolve this problem, follow these steps:

• Start IIS Manager. To do this, click Start, click Run, type inetmgr.exe, and then click OK.

• In IIS Manager, expand server name, expand Web sites, and then click the website that you want to modify.

• In the Features view, double-click Default Document.

• In the Actions pane, click Enable.

• In the File Name box, type the name of the default document, and then click OK.

ELSE DO 3: Enable the Directory Browsing feature in IIS Express

Note This method is for the web developers who experience the issue when they use IIS Express.

Follow these steps:

• Open a command prompt, and then go to the IIS Express folder on your computer. For example, go to the following folder in a command prompt: C:\Program Files\IIS Express

• Type the following command, and then press Enter:

appcmd set config /section:directoryBrowse /enabled:true

2)ASP.Net IIS7: The page you are requesting cannot be served because of the extension configuration. If the page is a script, add a handler. If the file should be downloaded, add a MIME map.

CD C:\Windows\Microsoft.NET\Framework64\v4.0.30319\aspnet_regiis -i

Run above command in cmd (RUN AS ADMINISTRATOR)

which will activate asp.net 4.0 like below

3)Website not accessible from other computer in network

1. Open Windows Firewall with Advanced Security ( or run wf.msc)

2. Open Inbound Rules and find World Wide Web Services (HTTP Traffic-In)

3. Right Click on World Wide Web Services (HTTP Traffic-In) and Enable Rule

Creating download link to a file on a file server

2016-05-31T00:18:00.003-07:00

For .Net Developer This Might Help You For Creating
download link to a file on a file server

string strURL;
strURL = Path.Combine(AppDomain.CurrentDomain.BaseDirectory, "AllFiles\Log\") + "SaleLogFile.log";//name of the file you are picking

WebClient req = new WebClient();
HttpResponse response = HttpContext.Current.Response;
response.Clear();
response.ClearContent();
response.ClearHeaders();
response.Buffer = true;
response.AddHeader("Content-Disposition", "attachment;filename='SaleLogFile.log'");//change downloaded file name
byte[] data = req.DownloadData(strURL);
response.BinaryWrite(data);
response.End();

Convert Dataset To EXCEL or NOTEPAD

2014-10-14T04:16:00.003-07:00

Convert Dataset to EXCEL

using System.Xml.Schema;
using System.Xml;
using System.IO;
using Excel = Microsoft.Office.Interop.Excel;

private void button_Clicked(object sender, EventArgs e)
        {
            ExportToExcel();
        }
        public DataTable ExportToExcel()
        {
            string sql = null;
            string data = null;
            int i = 0;
            int j = 0;

            Excel.Application xlApp;
            Excel.Workbook xlWorkBook;
            Excel.Worksheet xlWorkSheet;
            object misValue = System.Reflection.Missing.Value;

            xlApp = new Excel.ApplicationClass();
            xlWorkBook = xlApp.Workbooks.Add(misValue);
            xlWorkSheet = (Excel.Worksheet)xlWorkBook.Worksheets.get_Item(1);

                             DataSet ds = new DataSet();

             //fill your dataset with any data

                for (i = 0; i <= ds.Tables[0].Rows.Count - 1; i++)
                {
                    for (j = 0; j <= ds.Tables[0].Columns.Count - 1; j++)
                    {
                        data = ds.Tables[0].Rows[i].ItemArray[j].ToString();
                        xlWorkSheet.Cells[i + 1, j + 1] = data;
                    }
                }

                xlWorkBook.SaveAs(@"D:\ESIReports.xls", Excel.XlFileFormat.xlWorkbookNormal, misValue, misValue, misValue, misValue, Excel.XlSaveAsAccessMode.xlExclusive, misValue, misValue, misValue, misValue, misValue);


                 xlWorkBook.Close(true, misValue, misValue);
                xlApp.Quit();

                //NOTE PAD file or .CSV FILE CREATION
                CSVNotepad(any);
                MessageBox.Show("Excel file created , you can find the file ESIReport.xls");
                return table;

            }
        }

Convert Dataset to NOTEPAD

private void button_Clicked(object sender, EventArgs e)
        {
            CSVNotepad(DataTableObj)
        }

public void CSVNotepad(DataTable dsa)
        {
            DataTable sourceTable = new DataTable();
            sourceTable = dsa;

            using (StreamWriter writer = new StreamWriter(@"D:\ESIReports.txt"))//.txt or .csv
            {
                Rfc4180Writer.WriteDataTable(sourceTable, writer, true);
            }
        }

//REQUIRED CLASS FILE FOR NOTEPAD EXECUTION
    public static class Rfc4180Writer
    {
        public static void WriteDataTable(DataTable sourceTable, TextWriter writer, bool includeHeaders)
        {
            //if (includeHeaders)
            //{
            //    List<string> headerValues = new List<string>();
            //    foreach (DataColumn column in sourceTable.Columns)
            //    {
            //        headerValues.Add(QuoteValue(column.ColumnName));
            //    }

            //    writer.WriteLine(String.Join(",", headerValues.ToArray()));
            //}

            string[] items = null;
            foreach (DataRow row in sourceTable.Rows)
            {
                items = row.ItemArray.Select(o => QuoteValue(o.ToString())).ToArray();
                writer.WriteLine(String.Join(",", items));
            }

            writer.Flush();
        }

        private static string QuoteValue(string value)
        {
            return String.Concat("\"", value.Replace("\"", "\"\""), "\"");
        }
    }

Could not find a part of the path 'C:\Program Files\Microsoft Visual Studio 9.0\Common7\IDE\

2014-08-12T03:57:00.003-07:00

How to get rid from the error "Could not find a part of the path 'C:\Program Files\Microsoft Visual Studio 9.0\Common7\IDE\"?

this error is usually coz for .net server a path in a form of string is not enough you have to specify thats you are accessing it from your own server ,you have to tell server that "YES!its a directory of my own server" by implementing Server.MapPath() method.

Lets see how it goes....as i want one of my directory to be removed i am using below code

----------------------------------------------------------------------------------------------------------------

string path="Reports/NK/MyDirectory";//path as a string

Directory.Delete(path, true);//wrong way hence shows error

Directory.Delete(Server.MapPath(path), true);//right way as he know its a directory in your own server

---------------------------------------------------------------------------------------------------------------

let me know if you still find any issue.

M S Access Date Between Query Not Giving Desired Result

2014-07-07T05:50:00.001-07:00

Actualy what I will do here is just show you

Examples of using dates as criteria in Access queries

If I was not wrong you were facing problem in Access Database Query of Between or ><
for Dates

Actualy it is not as same as SQL to get record from by just putting between keyword...

MS Access must be filterd from format('<urdate'>,'dd/mm/yyyy')

but lets first focus what you are facing /what wrong you were doing...

WRONG METHODS
SELECT Purchase_Date, Purchase_Billno
FROM Purchase_Item
where format('Purchase_Date,'dd/mm/yyyy')> '02/01/2014'
and format('Purchase_Date,'dd/mm/yyyy')<'22/12/2014'

or

SELECT Purchase_Date, Purchase_Billno
FROM Purchase_Item
where format('Purchase_Date,'dd/mm/yyyy')> #02/01/2014#
and format('Purchase_Date,'dd/mm/yyyy')<#22/12/2014#

RIGHT WAY
Lets See How Its Works..

SELECT Purchase_Date, Purchase_Billno
FROM Purchase_Item
where Purchase_Date> format('02/01/2014','dd/mm/yyyy')
and Purchase_Date< format('22/12/2014','dd/mm/yyyy')

This will show you the exact match of your desired result,
So Hows that solution :)

String First And Last Character by Substring in C#

2014-07-06T03:42:00.001-07:00

Let say you have a string and you want its first or last character like first 2 or last 4 how could you do that?

here is sample for that

string mystring = "122014";

        mystring = mystring.Substring(mystring.Length - 4);
        Response.Write(mystring.ToString());

//output:2014

mystring = "122014";
        string sub = mystring.Remove(mystring.Length - 4);
        Response.Write("<br>");
        Response.Write(sub.ToString());

//output: 12

Add / Change Rdlc at Runtime

2013-06-12T00:36:00.000-07:00

Add / Change Rdlc at Runtime

reportViewer1.LocalReport.EnableExternalImages = true;
reportViewer1.LocalReport.ReportEmbeddedResource = "ChequePrint.Report.Report1.rdlc";
this.DataTable1TableAdapter.Fill(this.ChecqueDetail.DataTable1);
this.reportViewer1.RefreshReport();

As you'll see in
reportViewer1.LocalReport.ReportEmbeddedResource = "ChequePrint.Report.Report1.rdlc";

ChequePrint.Report.Report1.rdlc is just a text of rdlc file path,and i got it from,

on report viewer click on top right side small button (step 1) and view the report list f

Working With DateTime In SQL and C#

2013-02-10T22:38:00.001-08:00

Date Time Format In C# and SQL

In ASP.net C#

compare two date like TextBoxToDate and TextBoxToDate

DateTime org = DateTime.ParseExact(TextBoxToDate .Text,"dd/MM/yyyy",null);
DateTime enter = DateTime.ParseExact(TextBoxToDate.Text, "dd/MM/yyyy", null);

if(enter.Date<org.Date)
        {
//do what you wish
        }

Selection In GridView With CheckBoxes

2013-02-04T04:59:00.002-08:00

CheckBoxes Wise Selection In GridView in just 3 steps

1)In ASPX side
your grid view must contain DataKeyNames
and checkbox under templatefield

<asp:GridView ID="GridViewtemp" runat="server"   DataKeyNames="Person_Id">

2)Now you have above grid where so many rows are avail and each row has a checkbox in it(as we placed a checkbox in templatefield's item template)

now when user click on these checkboxes and make out his selection we will provide him further a button 'btnselect' which will again bind a grid and show you only those selected row which were checked previously.

3)So On that btnselect_click event

In C# On Button Click

protected void btnselect_Click(object sender, EventArgs e)
     {



             for (int i = 0; i < GridViewtemp.Rows.Count; i++)
             {
                 if (((CheckBox)GridViewtemp.Rows[i].FindControl("chkSONo")).Checked == true)
                 {
                     soid = ((Label)GridViewtemp.Rows[i].FindControl("lblPersonid")).Text;

                     if (value == "")
                     {
                         value = soid;
                     }
                     else
                     {
                         value = value + "," + soid;
                     }

                 }
             }
             BindItemGrid(soid);


     }
     public void BindItemGrid(string Key)
     {
         query = " select * from tb_Stamping where   [Person_Id] in (" + value + ")";
         SqlDataAdapter adp = new SqlDataAdapter(query, con);
         DataSet ds = new DataSet();
         adp.Fill(ds);
         gvselectcontent.DataSource = ds;
         gvselectcontent.DataBind();

     }

Gradient Text Effect or Button CSS Sample

2013-01-22T05:06:00.002-08:00

Gradient Texture In Button or Text

If u guys are looking stuff like you want to gradient effect to a text or button .
then below is the simple code without much bugs.

<style>
h1 {
font-size: 72px;
background: -webkit-linear-gradient(#eee, #333);
-webkit-background-clip: text;
-webkit-text-fill-color: transparent;
}
.clr {
font-size: 72px;
background: -webkit-linear-gradient(#eee, #333);
-webkit-background-clip:button;
-webkit-text-fill-color: transparent;
}

.clrtwist {
font-size: 72px;
background: -webkit-linear-gradient(#333,#eee );
-webkit-background-clip:button;
-webkit-text-fill-color: transparent;
}</style>

<h1>vijay negi and the gradient!</h1>
<input id="Button1" class="clr" type="button" value="button" />
<input id="Button2" class="clrtwist" type="button" value="button" />

below one is the output

SQL Transaction In C#,ASP.Net

2013-01-14T05:16:00.000-08:00

Transaction In C#,ASP.Net

SqlTransaction transaction;
con.Open();
transaction = con.BeginTransaction();
try
{
for (int i = 0; i < dtTemp.Rows.Count; i++)
{
SqlCommand cmd = new SqlCommand("insert command....", con,transaction);
cmd.ExecuteNonQuery();
}
transaction.Commit();
}

catch (Exception Error)
{


}

In above Part the only thing you have to care about is

SqlTransaction transaction;
con.Open();
transaction = con.BeginTransaction();
try {

SqlCommand cmd = new SqlCommand("insert command....", con,transaction);
cmd.ExecuteNonQuery();
transaction.Commit(); //whenever you call commit it means now finaly
//all execution will take place else rollback to catch
}
catch
{
transaction.Rollback();
}

Autocomplete Extender AJAX

2012-12-27T02:00:00.001-08:00

Alternate use of AutoComplete Extender AJAX

For searching what we basically need is name and id behind it.
so for that we must have a
searcher :textbox(txtSearch)
id holder when search complete:hiddenfield(hfCustomerId)

Htmil Source Side


<script type = "text/javascript">

                      function ClientItemSelected(sender, e) {

                          $get("<%=hfCustomerId.ClientID %>").value = e.get_value();

                      }

    </script> 

Search by Client: 

                <asp:HiddenField ID="hfCustomerId" runat="server" />

                <asp:TextBox ID="txtSearch" runat="server" Width="200"></asp:TextBox>

                <asp:AutoCompleteExtender ID="AutoCompleteExtender2" runat="server" 

                    BehaviorID="AutoCompleteEx" CompletionInterval="100" 

                    CompletionListCssClass="completionList" 

                    CompletionListHighlightedItemCssClass="itemHighlighted" 

                    CompletionListItemCssClass="listItem" CompletionSetCount="20"  OnClientItemSelected="ClientItemSelected"

                    DelimiterCharacters=";, :" EnableCaching="true" MinimumPrefixLength="1" 

                    ServiceMethod="GetClientList" ShowOnlyCurrentWordInCompletionListItem="true" 

                    TargetControlID="txtSearch" UseContextKey="True">

                </asp:AutoCompleteExtender>

Code Behind

Web Method to process autocomplete with textbox

Instead this (used for singal value)




SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["ALPHAconnString"]);

        SqlCommand cmd = new SqlCommand("SELECT distinct [Company_Name],Client_id FROM Client where Company_Name like '" + prefixText + "%' ", con); 

        if (con.State == ConnectionState.Closed)

            con.Open();

        cmd.CommandType = CommandType.Text;

        SqlDataReader dr = cmd.ExecuteReader();

       



        while (dr.HasRows)

        {

            while (dr.Read())

            {

                string item = AjaxControlToolkit.AutoCompleteExtender.CreateAutoCompleteItem(dr["Company_Name"].ToString(), dr["Client_id"].ToString());

                items.Add(item);



                //items.Add(dr.GetValue(0).ToString());



            }

            dr.NextResult();

        }

        return items.ToArray();

Use this(to hold two value)



SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["ALPHAconnString"]);

       
 SqlCommand cmd = new SqlCommand("SELECT distinct 
[Company_Name],Client_id FROM Client where Company_Name like '" + 
prefixText + "%' ", con); 

        if (con.State == ConnectionState.Closed)

            con.Open();

        cmd.CommandType = CommandType.Text;

        SqlDataReader dr = cmd.ExecuteReader();

       



        while (dr.HasRows)

        {

            while (dr.Read())

            {

               
 string item = 
AjaxControlToolkit.AutoCompleteExtender.CreateAutoCompleteItem(dr["Company_Name"].ToString(),
 dr["Client_id"].ToString());

                items.Add(item);



                //items.Add(dr.GetValue(0).ToString());



            }

            dr.NextResult();

        }

        return items.ToArray();

after searching from textbox ,on any button Click



string clientid= Request.Form[hfCustomerId.UniqueID];

To Work With GridView In Outside Or Internal Event Of Any Control Except

2012-10-06T04:39:00.000-07:00

To Work With GridView In Outside Or Internal Event Of Any Control Except

protected void txtDispQty_TextChanged(object sender, EventArgs e)
    {
ltTotAmt.Text = "0";

        for (int i = 0; i < gvSaleDispatch.Rows.Count; i++)
        {
            if (((TextBox)gvSaleDispatch.Rows[i].FindControl("txtDispQty")).Text != "")
            {
                if (Convert.ToDouble(((TextBox)gvSaleDispatch.Rows[i].FindControl("txtDispQty")).Text) > Convert.ToDouble(((Label)gvSaleDispatch.Rows[i].FindControl("lblOrdQty")).Text))
                {
                    ((TextBox)gvSaleDispatch.Rows[i].FindControl("txtDispQty")).Text = "";
                    CloseWindow = "alert('Dispatch Quantity cant be greater than Ordered Quantity....');";
                    ClientScript.RegisterStartupScript(this.GetType(), "CloseWindow", CloseWindow, true);

                }
                else if (Convert.ToDouble(((TextBox)gvSaleDispatch.Rows[i].FindControl("txtDispQty")).Text) > Convert.ToDouble(((Label)gvSaleDispatch.Rows[i].FindControl("lblAvailStock")).Text))
                {
                    ((TextBox)gvSaleDispatch.Rows[i].FindControl("txtDispQty")).Text = "";
                    CloseWindow = "alert('Dispatch Quantity cant be greater than Available Stock....');";
                    ClientScript.RegisterStartupScript(this.GetType(), "CloseWindow", CloseWindow, true);
                }
                else
                {
                    ((Label)gvSaleDispatch.Rows[i].FindControl("lbltot")).Text = String.Format("{0:0.00}", (Convert.ToDouble(((TextBox)gvSaleDispatch.Rows[i].FindControl("txtDispQty")).Text) * Convert.ToDouble(((Label)gvSaleDispatch.Rows[i].FindControl("lblRate")).Text)));
                    ltTotAmt.Text = String.Format("{0:0.00}", (Convert.ToDouble(ltTotAmt.Text) + Convert.ToDouble(((Label)gvSaleDispatch.Rows[i].FindControl("lbltot")).Text)));
                }
            }

        }
        ltTotPayableAmt.Text = ltTotAmt.Text;
}

Bind DropDown Under GridView

2012-09-17T02:08:00.000-07:00

Bind DropDown Under GridView

lets go from basic...

How to bind dropdown?

Normaly We Bind A Drop Downdown In Asp.net Page Like below....

.aspx

<asp:DropDownList ID="DropDownListGroup" runat="server"
DataTextField="GroupNm" DataValueField="GroupID" Height="18px"
style="margin-bottom: 0px" Width="205px">
</asp:DropDownList>

.cs
        SqlDataAdapter adp2 = new SqlDataAdapter("select * from Group", con);
        DataSet ds2 = new DataSet();
        adp2.Fill(ds2);
        DropDownListGroup.DataSource = ds2;
        DropDownListGroup.DataBind();
        DropDownListGroup.Items.Insert(0, "---Select---");

but in case of Grid View Thing are bit different..

You need to workout in RowDataBound Click Event

1.Bind DropDown Under GridView In Item Template

if (e.Row.RowType == DataControlRowType.DataRow)
     {
              DropDownList drdList = (DropDownList)e.Row.FindControl("DropDownListGroup");
             SqlDataAdapter adp = new SqlDataAdapter("select * from MST_Group", con);
             DataSet ds = new DataSet();
             adp.Fill(ds);
             drdList.DataSource = ds;
             drdList.DataBind();
             drdList.Items.Insert(0, "---Select---");

             }

2.Bind DropDown Under GridView In EditItem Template

if (e.Row.RowType == DataControlRowType.DataRow)
     {
         if ((e.Row.RowState & DataControlRowState.Edit) > 0)
         {
             DropDownList drdList = (DropDownList)e.Row.FindControl("DropDownListGroup");
             SqlDataAdapter adp = new SqlDataAdapter("select * from MST_Group",con);
             DataSet ds = new DataSet();
             adp.Fill(ds);
             drdList.DataSource = ds;
             drdList.DataBind();
             drdList.Items.Insert(0, "---Select---");
         }
     }

3.Bind DropDown Under GridView In Footer Template

if (e.Row.RowType == DataControlRowType.Footer)
     {
       ((Label)e.Row.FindControl("lblQty")).Text = totqty.ToString();
       TxtTotal.Text = totqty.ToString();

   }

The type or namespace name 'Linq' does not exist in the namespace 'System.Data'

2012-08-22T02:14:00.000-07:00

The type or namespace name 'Linq' does not exist in the namespace 'System.Data' (are you missing an assembly reference?)

<add assembly="System.Data.Linq, Version=3.5.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"/>

Setting up SQL Server 2008 for an ASP.NET website on IIS 7.0

2012-08-09T23:22:00.001-07:00

Setting up SQL Server 2008 for an ASP.NET website on IIS 7.0

SQL Server 2008 Express edition with Tools has finally been released (It was launched on August 11th, but only today are the management tools available). As I’ve been building web servers today, I’ve put together this comprehensive guide to setting up your website to work with SQL Server 2008.

Step 1: Prerequisities

Firstly you need Windows 2008 Server and IIS 7.0 installed. Installing Windows Server 2008 is pretty straight-forward and I won’t cover it here (there is an excellent article here), although be aware that as you are using ASP.NET and SQL Server you cannot install server core. Installing the IIS 7.0 server role is also quite easy, (another great article here)
Install Windows PowerShell from the Features section in the Windows Server 2008 Server Manager.
Install .NET Framework 3.5 SP1 from here.
Install Windows Installer 4.5 from here.
If you have AJAX enabled sites running on ASP.NET 2.0 then Install ASP.NET AJAX Extensions 1.0 from here.
Download SQL Server 2008 Express with Tools from here. This version includes:
- SQL Server database engine – create, store, update and retrieve your data
- SQL Server Management Studio Basic – visual database management tool for creating, editing and managing databases

While this guide concentrates on the Express version of SQL Server 2008, you need to ensure that it meets the requirements in your specific environment. The SQL Server 2008 blog has an article which discusses this issue (SQL Server Express and Hosting)

Step 2: Installing SQL Server 2008

Start the install from your CD or downloaded file.
Select New SQL Server stand-alone installation of add features to an existing installation
The setup program will check that you have the necessary pre-requisities in place for the SQL Server setup support files. Click OK.
Click Install to install the SQL Server setup support files.
SQL Setup will then check that you have all the necessary pre-requisities in place for the SQL Server installation. I received a warning that Windows Firewall needs port 1433 open for remote TCP/IP connection to SQL Server. Click Next.
Nothing to do on the next step if you are using the Express Edition, other you need to enter a valid product key. Click Next.
Accept the license terms and click Next.
Select the features you want to install and cick Next. At a minimum I recommend installing the Database Engine Services and the Management Tools.
Select an instance to install your database server into and a location. In the web.config file for your ASP.NET web site, if SQL is not installed in the default instance then you need to set Data Source = SERVERNAME\INSTANCENAME for your database connection string.
SQL Setup will confirm you have enough disk space. Click Next.
Configure your service account and collation settings and click Next. Use the built-in System account and don’t change the default collation unless you have databases with special requirements.
Configure Mixed Mode authentication and provide a password for the sa account. This allows you to use either windows or sql authentication depending on your requirements. Choose which accounts have administrative privilages to the SQL Server database engine. Click Next.
Tick the checkboxes if you would like to send error reports and usage data to Microsoft, and click Next.
Setup will then check if the installation process will be blocked. Check the report and click Next.
Verify the SQL Server features to install and click Install.
Once the setup finishes, check Windows Update to see if there are any patches that need to be installed.

Step 3: Allowing TCP/IP Connections to SQL Server

By default, only the Named Pipes protocal is allowed to connect to the SQL Server. To allow TCP/IP connections, perform the following steps:

Open the SQL Server Configuration Manager under the Microsoft SQL Server 2008, Configuration Tools start menus.
Expand the SQL Server Network Configuration node and select Protocols for <InstanceName>. Double click on the TCP/IP Protocol and change it to Enabled.
Restart SQL Server for the changes to take effect.

Step 4: Attaching a Database

The SQL Server 2008 Management tools are almost identical to the SQL Server 2005 ones. Open up the Management Tools and login to your database. You will then see the following:
Right-click on the Databases node and select New Database to create a new database, or Attach to attach an existing one. If you are attaching a database then click the Addbutton, browse for your .mdf file and click OK twice to attach the database. You will be asked to also add the location of any Full-Text catalogs if they exist.

Step 5: Creating a Login for your database

By default, only Administrators have access to your database. You need to now configure your database to allow Internet users access to read and (if required) write to your data. You can either use Windows authentication or SQL Server authentication. Windows authentication uses your local server or Active Directory user account to connect, and doesn’t require a password to be kept in the web.config file. SQL Server authentication is easier to seperate your user accounts for different databases and applications easily.

To set up Windows Authentication:

On a standalone Windows 2008 Web Server, the ASP.NET service runs as the NT AUTHORITY\NETWORK SERVICE account. You need to map this account to SQL Server:

In the SQL Server Management Tools, Right click on Logins under the Security Nodeand select New Login.
Type NT AUTHORITY\NETWORK SERVICE in the Login Name box and select Windows Authentication. Click Ok.

To set up SQL Authentication:

In the SQL Server Management Tools, Right click on Logins under the Security Nodeand select New Login.
Type the name of your database user in the Login Name box and select SQL Authentication. Set a password and untick Enforce Password Policy. Click Ok.

Step 6: Assigning the user permissions to your database

Now you need to assign this login the appropriate permissions in your database. To do this, expand the Databases node and then expand Security. Right-click the Usersnode and choose New User.
Give your Login whatever name you like and in the Login Name box type in either the name of your database user if using SQL authentication or NT AUTHORITY\NETWORK SERVICE if you are using Windows authentication (or browse to select your account). Under Database Role Membership select db_datareader (and db_datawriter if your users are performing INSERT and UPDATE SQL queries).
Click OK.

Step 7: Configuring your database connection string

You can set your database connection string by either manually editing the web.config file, or using the IIS built in Connection Strings applet.

Open Internet Information Services (IIS) Manager from the Administrative Toolsstart menu.
Browse to your website and double-click on Connection Strings in the right hand pane.
Either Add a new connection string or right click an existing one to Edit.
Set the name of your server and database appropriately, and then choose the credentials to match your database user. If you are using SQL Authentication then you need to set the username and password you configured.

That’s it! I hope this guide helps, and please let me know if I’ve missed anything!

The Report Viewer Web Control HTTP Handler has not been registered in the application's web.config file

2012-06-08T04:31:00.001-07:00

Add <add verb="*" path="Reserved.ReportViewerWebControl.axd" type = "Microsoft.Reporting.WebForms.HttpHandler, Microsoft.ReportViewer.WebForms, Version=9.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" /> to the system.web/httpHandlers section of the web.config file.

If you are facing such error this may help you.just change your web config with this.

<?xml version="1.0"?>

<configuration>
    <configSections>
        <sectionGroup name="system.web.extensions"

type="System.Web.Configuration.SystemWebExtensionsSectionGroup, System.Web.Extensions,

Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35">
            <sectionGroup name="scripting"

type="System.Web.Configuration.ScriptingSectionGroup, System.Web.Extensions, Version=3.5.0.0,

Culture=neutral, PublicKeyToken=31BF3856AD364E35">
                <section name="scriptResourceHandler"

type="System.Web.Configuration.ScriptingScriptResourceHandlerSection, System.Web.Extensions,

Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" requirePermission="false"

allowDefinition="MachineToApplication"/>
                <sectionGroup name="webServices"

type="System.Web.Configuration.ScriptingWebServicesSectionGroup, System.Web.Extensions,

Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35">
                    <section name="jsonSerialization"

type="System.Web.Configuration.ScriptingJsonSerializationSection, System.Web.Extensions,

Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" requirePermission="false"

allowDefinition="Everywhere"/>
                    <section name="profileService"

type="System.Web.Configuration.ScriptingProfileServiceSection, System.Web.Extensions,

Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" requirePermission="false"

allowDefinition="MachineToApplication"/>
                    <section name="authenticationService"

type="System.Web.Configuration.ScriptingAuthenticationServiceSection, System.Web.Extensions,

Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" requirePermission="false"

allowDefinition="MachineToApplication"/>
                    <section name="roleService"

type="System.Web.Configuration.ScriptingRoleServiceSection, System.Web.Extensions,

Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" requirePermission="false"

allowDefinition="MachineToApplication"/>
                </sectionGroup>
            </sectionGroup>
        </sectionGroup>
    </configSections>
    <system.net>

    </system.net>
<appSettings/>
   <connectionStrings/>
    <system.web>
        
    <machineKey

validationKey='4C8B22744D71B73CE6B16262A97CF3862E584829229EDE45C9DF207DDF5F3507782A3F2F650608502

8628868F6AFFC25D16BE4AD8BB677637B11C892F95FE819'

decryptionKey='53EA49CFEC5C5A1E4720DE83E1CC75337674757144EB1DCB'   validation='SHA1'/>
        <compilation debug="true">
            <assemblies>
                <add assembly="System.Core, Version=3.5.0.0, Culture=neutral,

PublicKeyToken=B77A5C561934E089"/>
                <add assembly="System.Web.Extensions, Version=3.5.0.0,

Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>
                <add assembly="System.Data.DataSetExtensions, Version=3.5.0.0,

Culture=neutral, PublicKeyToken=B77A5C561934E089"/>
                <add assembly="System.Xml.Linq, Version=3.5.0.0,

Culture=neutral, PublicKeyToken=B77A5C561934E089"/>
                <add assembly="System.Design, Version=2.0.0.0, Culture=neutral,

PublicKeyToken=B03F5F7F11D50A3A"/>
                <add assembly="System.Web.Extensions.Design, Version=3.5.0.0,

Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>
                <add assembly="System.Windows.Forms, Version=2.0.0.0,

Culture=neutral, PublicKeyToken=B77A5C561934E089"/>
                <add assembly="System.Data.Linq, Version=3.5.0.0,

Culture=neutral, PublicKeyToken=b77a5c561934e089"/>
                <add assembly="Microsoft.ReportViewer.WebForms, Version=9.0.0.0,

Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A"/>
                <add assembly="Microsoft.ReportViewer.Common, Version=9.0.0.0,

Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A"/>
                <add assembly="System.Net, Version=3.5.0.0, Culture=neutral,

PublicKeyToken=B03F5F7F11D50A3A"/></assemblies>
            <buildProviders>
                <add extension=".rdlc"

type="Microsoft.Reporting.RdlBuildProvider, Microsoft.ReportViewer.Common, Version=9.0.0.0,

Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"/>
            </buildProviders>
        </compilation>
        
        <authentication mode="None"/>
        <customErrors mode="Off">
        </customErrors>
        
        <pages>
            <namespaces>
                <clear/>

                <add namespace="System"/>
                <add namespace="System.Collections"/>
                <add namespace="System.Collections.Generic"/>
                <add namespace="System.Collections.Specialized"/>
                <add namespace="System.Configuration"/>
                <add namespace="System.Text"/>
                <add namespace="System.Text.RegularExpressions"/>
                <add namespace="System.Linq"/>
                <add namespace="System.Xml.Linq"/>
                <add namespace="System.Web"/>
                <add namespace="System.Web.Caching"/>
                <add namespace="System.Web.SessionState"/>
                <add namespace="System.Web.Security"/>
                <add namespace="System.Web.Profile"/>
                <add namespace="System.Web.UI"/>
                <add namespace="System.Web.UI.WebControls"/>
                <add namespace="System.Web.UI.WebControls.WebParts"/>
                <add namespace="System.Web.UI.HtmlControls"/>
            </namespaces>
            <controls>
                <add tagPrefix="asp" namespace="System.Web.UI"

assembly="System.Web.Extensions, 
            Version=3.5.0.0, Culture=neutral,

PublicKeyToken=31BF3856AD364E35"/>
                <add tagPrefix="asp" namespace="System.Web.UI.WebControls"

assembly="System.Web.Extensions, 
                  Version=3.5.0.0, Culture=neutral,

PublicKeyToken=31BF3856AD364E35"/>
                <add tagPrefix="AjaxToolkit" namespace="AjaxControlToolkit"

assembly="AjaxControlToolkit, Version=3.5.40412.0, 
         Culture=neutral,

PublicKeyToken=28F01B0E84B6D53E"/>
            </controls>
        </pages>
        <httpHandlers>
            <remove path="*.asmx" verb="*"/>
            <add path="*.asmx" verb="*"

type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=3.5.0.0,

Culture=neutral, PublicKeyToken=31BF3856AD364E35" validate="false"/>
            <add path="*_AppService.axd" verb="*"

type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=3.5.0.0,

Culture=neutral, PublicKeyToken=31BF3856AD364E35" validate="false"/>
            <add path="ScriptResource.axd" verb="GET,HEAD"

type="System.Web.Handlers.ScriptResourceHandler, System.Web.Extensions, Version=3.5.0.0,

Culture=neutral, PublicKeyToken=31BF3856AD364E35" validate="false"/>
            <add path="Reserved.ReportViewerWebControl.axd" verb="*"

type="Microsoft.Reporting.WebForms.HttpHandler, Microsoft.ReportViewer.WebForms,

Version=9.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" validate="false"/>
        </httpHandlers>
        <httpModules>
            <add name="ScriptModule" type="System.Web.Handlers.ScriptModule,

System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>
        </httpModules>
    </system.web>
    <system.codedom>
        <compilers>
            <compiler language="c#;cs;csharp" extension=".cs"

type="Microsoft.CSharp.CSharpCodeProvider,System, Version=2.0.0.0, Culture=neutral,

PublicKeyToken=b77a5c561934e089" warningLevel="4">
                <providerOption name="CompilerVersion" value="v3.5"/>
                <providerOption name="WarnAsError" value="false"/>
            </compiler>
            <compiler language="vb;vbs;visualbasic;vbscript" extension=".vb"

type="Microsoft.VisualBasic.VBCodeProvider, System, Version=2.0.0.0, Culture=neutral,

PublicKeyToken=b77a5c561934e089" warningLevel="4">
                <providerOption name="CompilerVersion" value="v3.5"/>
                <providerOption name="OptionInfer" value="true"/>
                <providerOption name="WarnAsError" value="false"/>
            </compiler>
        </compilers>
    </system.codedom>
    <system.webServer>
        <validation validateIntegratedModeConfiguration="false"/>
        <modules>
            <remove name="ScriptModule"/>
            <add name="ScriptModule" preCondition="managedHandler"

type="System.Web.Handlers.ScriptModule, System.Web.Extensions, Version=3.5.0.0, Culture=neutral,

PublicKeyToken=31BF3856AD364E35"/>
        </modules>
        <handlers>
            <remove name="WebServiceHandlerFactory-Integrated"/>
            <remove name="ScriptHandlerFactory"/>
            <remove name="ScriptHandlerFactoryAppServices"/>
            <remove name="ScriptResource"/>
            <add name="ScriptHandlerFactory" verb="*" path="*.asmx"

preCondition="integratedMode" type="System.Web.Script.Services.ScriptHandlerFactory,

System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>
            <add name="ScriptHandlerFactoryAppServices" verb="*"

path="*_AppService.axd" preCondition="integratedMode"

type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=3.5.0.0,

Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>
            <add name="ScriptResource" verb="GET,HEAD" path="ScriptResource.axd"

preCondition="integratedMode" type="System.Web.Handlers.ScriptResourceHandler,

System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>
        </handlers>
    </system.webServer>
    <runtime>
        <assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
            <dependentAssembly>
                <assemblyIdentity name="System.Web.Extensions"

publicKeyToken="31bf3856ad364e35"/>
                <bindingRedirect oldVersion="1.0.0.0-1.1.0.0"

newVersion="3.5.0.0"/>
            </dependentAssembly>
            <dependentAssembly>
                <assemblyIdentity name="System.Web.Extensions.Design"

publicKeyToken="31bf3856ad364e35"/>
                <bindingRedirect oldVersion="1.0.0.0-1.1.0.0"

newVersion="3.5.0.0"/>
            </dependentAssembly>
        </assemblyBinding>
    </runtime>
    <system.serviceModel>
        <behaviors>
            <serviceBehaviors>
                <behavior name="ServiceBehavior">
                    <serviceMetadata httpGetEnabled="true"/>
                    <serviceDebug includeExceptionDetailInFaults="false"/>
                </behavior>
            </serviceBehaviors>
        </behaviors>
        <services>
            <service behaviorConfiguration="ServiceBehavior" name="Service">
                <endpoint address="" binding="wsHttpBinding"

contract="IService">
                    <identity>
                        <dns value="localhost"/>
                    </identity>
                </endpoint>
                <endpoint address="mex" binding="mexHttpBinding"

contract="IMetadataExchange"/>
            </service>
        </services>
    </system.serviceModel>
</configuration>

RDLC Basics

2012-05-16T23:48:00.000-07:00

Basic Example Of RDLC (Report Definition Language Client-side)

To Understand From The Basic Let Start From Here..

We have two tables

1. MasterProduct

Brand	Product	ID
Brand1	Product1	101
Brand2	Product1	102
Brand3	Product2	103
Brand1	Product2	104
Brand4	Product3	105
Brand3	Product4	106

*ID is primary key here

2. Transaction

State	Quantity	ID
State1	10	101
State2	20	103
State3	40	104
State1	60	102
State2	40	101
State4	80	106

*Here ID is foreign key reference to ID of MasterProduct Table

Now Question is:

We want the below given output where State, Product1,2,3,4 are columns if we add product then column added and if we add state then it added to state column. It takes the quantity from Transaction and show in the rows accordingly.

And If You Have Opportunity to

Use any of the data control of asp.net to show the output...I Suggest Use RDLC(report control of .net)

OUTPUT Will be:

State	Product1	Product2	Product3	Product4
State1	10+60=70
State2	40	20
State3		40
State4				80

use namespace...
using Microsoft.Reporting.WebForms;

Use function() Like

public void BindReport()
    {
        SqlCommand cmd = new SqlCommand("spTest", con);
        cmd.CommandType = CommandType.StoredProcedure;
        if (con.State == ConnectionState.Closed)
            con.Open();

        DataSet ds = new DataSet();
        SqlDataAdapter adp = new SqlDataAdapter(cmd);
        adp.Fill(ds);

        ReportDataSource rds = new ReportDataSource("DataSet1_spTest", ds.Tables[0]);

        ReportViewer1.LocalReport.DataSources.Clear();

        ReportViewer1.LocalReport.DataSources.Add(rds);

        ReportViewer1.LocalReport.Refresh();
    }

But How to add change RDLC at RUN Time??

How To Set Default Button for ENTER key Pressed Event, And How To Set Focus On A Particular Control

2012-05-16T03:25:00.003-07:00

Default Enter Key Action To Avoid PostBack In ASP.Net

This is a default property that when one presses Enter key in the textbox or any control there is a postback. So many people asked on forums
1. How to disable enter key in textbox?Or in any particular control
2. How to prevent postback or form submission when enter key is pressed in textbox in ASP.Net?

3)How to make click event fire of a particular button control when enter key is pressed.

1)What if you want to prevent postback or form submission when enter key is pressed

by JAVASCRIPT

<script type="text/javascript">
        function DisableEnterKey()
{
    if (window.event.keyCode == 13)
    {
        event.returnValue=false;
        event.cancel = true;
    }
}</script>

<body onkeydown="return DisableEnterKey()">

</body>

2) If you want default action of a button click on Enter Press

 <form id="form1"  runat="server" defaultbutton="Button1">
    <div>
    </div>
</form>

3) If you want default action of a button click on Enter Press and default focus on a textbox

 <form id="form1"  runat="server" defaultbutton="Button1" defaultfocus="TextBox1">
    <div>
    </div>
</form>

4)To Prevent Enter Press in particular text box in your from

<asp:TextBox ID="TextBox1" runat="server" onkeydown = "return (event.keyCode!=13)"></asp:TextBox>

From code behind

TextBox1.Attributes.Add("onkeydown", "return (event.keyCode!=13);");

Vijay Negi

Print Only Grid View in ASP.net

Basic of MVC in ASP.net

SQL Server Is Too Busy...

What?

Why?

Solution?

Conclusion

Find Control Under RowCommand

SQL Transaction In C#,ASP.Net

What is Async & Await in C# .net?

If you are familiar with normal ASP.net C# code then this would be easy for you to understand.just see the below code I'll explain it later (don't go with long red arrow)

In above its a simple asp.net web page code behind where someone click the Button1_Click,and then a callprocess() function get called.after this function we add "Program finish" text in a ListBox1.and increment value of a variable val to 10.

Now how do you think the code need to behave.

STEP 1>STEP 2>STEP3

WHAT you assume normally

1.int val=0 set in top and declared in last of the button click so val>=10 must fail. right?

2.Listbox add item "Program finish" in last but before it, callprocess() method comes which adding a item "Long Process finish" .so ListBox1 must have LongProcessFinsh in top and Programfinish after that .right?

BUT what realy happens?

Let me tell you everything happen exactly opposite of it.

STEP3(as callprocess() is async other code could not wait for it which has await attach to it)>STEP1>STEP2

In callprocess function the condition "if(val>-0" have value 10 in it already.and ProgramFinish is already added in Listbox1 before LongProcessFinish.

Its because we declare await inside a function (await always do a task(your async kind of task))await LongProcess();

and when you added it you must declare that function with async.

so what basicaly async/await/Task doing

Async:keyword to declare yes this is a async method

Await:this code will execute but telling other code part dont wait for me I am coming from behind.

Task:like void,we perform here our task which return type is

Void: Means nothing to return

Task: It will perform one operation, a little similar to void but the difference is there.

Task<T>: Will return a task with a T type parameter. (I hope you are familiar with the concept of T)

Deploy Website In IIS (Asp.net)

Deploy Asp.net Website In IIS Local

3)Website not accessible from other computer in network

Creating download link to a file on a file server

Convert Dataset To EXCEL or NOTEPAD

Convert Dataset to EXCEL

Convert Dataset to NOTEPAD

Could not find a part of the path 'C:\Program Files\Microsoft Visual Studio 9.0\Common7\IDE\

How to get rid from the error "Could not find a part of the path 'C:\Program Files\Microsoft Visual Studio 9.0\Common7\IDE\"?

----------------------------------------------------------------------------------------------------------------

string path="Reports/NK/MyDirectory";//path as a string Directory.Delete(path, true);//wrong way hence shows errorDirectory.Delete(Server.MapPath(path), true);//right way as he know its a directory in your own server

---------------------------------------------------------------------------------------------------------------

let me know if you still find any issue.

M S Access Date Between Query Not Giving Desired Result

String First And Last Character by Substring in C#

Add / Change Rdlc at Runtime

Working With DateTime In SQL and C#

Selection In GridView With CheckBoxes

Gradient Text Effect or Button CSS Sample

SQL Transaction In C#,ASP.Net

Autocomplete Extender AJAX

To Work With GridView In Outside Or Internal Event Of Any Control Except

Bind DropDown Under GridView

The type or namespace name 'Linq' does not exist in the namespace 'System.Data'

<add assembly="System.Data.Linq, Version=3.5.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"/>

Setting up SQL Server 2008 for an ASP.NET website on IIS 7.0

SQL Server 2008 Express edition with Tools has finally been released (It was launched on August 11th, but only today are the management tools available). As I’ve been building web servers today, I’ve put together this comprehensive guide to setting up your website to work with SQL Server 2008.

Step 1: Prerequisities

Step 2: Installing SQL Server 2008

Step 3: Allowing TCP/IP Connections to SQL Server

Step 4: Attaching a Database

Step 5: Creating a Login for your database

To set up Windows Authentication:

To set up SQL Authentication:

Step 6: Assigning the user permissions to your database

Step 7: Configuring your database connection string

The Report Viewer Web Control HTTP Handler has not been registered in the application's web.config file

RDLC Basics

How To Set Default Button for ENTER key Pressed Event, And How To Set Focus On A Particular Control

If you are familiar with normal ASP.net C# code then this would be easy for you to understand.
just see the below code I'll explain it later (don't go with long red arrow)

string path="Reports/NK/MyDirectory";//path as a string

Directory.Delete(path, true);//wrong way hence shows error

Directory.Delete(Server.MapPath(path), true);//right way as he know its a directory in your own server