to load file or load file dialog
drag and drop openfiledialog
and under the button click method 
write:
openFileDialog1.filter="all jpg giles (*.jpg) |*.jpg";
if(opefileDialog1.showDialog()==dialogResult.ok)
{
txtFilename.text=openFiledialog.fileName;
pictureBox1.imageLocation=openFileDialog1.fileName;
}else
{
}

for database creation  goto tools->options->database tools->data  connection
copy the server name and paste on creation
for database creation
String connectionstr="Data Source=servername; Initial Catalog=db name;Integrated Security=true;";
using system.data.sqlClient;
//////////////connecting to database
sqlConnection con=newsqlConnection(connectionstr);
string sql="insertinto tblUser values(@name,@email,@address)";
SqlCommand cmd=new SqlCommand(sql,con);
cmd.parameters.addwithValue("@name",txtName.text);
cmd.parameters.addwithValue("@email",txtEmail.text);
cmd.parameters.addwithValue("@address",txtAddress.text);
try
{
con.open();
int i=cmd.executeNonQuery();///////on insert update delete
if(i>0)
{
messageBox.show("rows affected "+i.toString());
}
}
finally
{
con.close();
}
/////////////datatable collection of single table
//////////dataset collections of tables
///while fetching data from database
sqlConnection con=newsqlConnection(connectionstr);
string sql="select * from tbl_user";
SqlCommand cmd=new SqlCommand(sql,con);
SqlDataadapter da=new SqlDataAdapter(cmd);
DataTable dt=new DataTable();
da.fill(dt);
return dt;
////////on view or form page 
DataTable dt=blu.Getall();
dataGridview1.dataSource=dt;
/////////quick action
use quick action using right click on particular item to get quick method etc
//check data rows count
data.rows.count>0
//////////////getting particular data from grid view
dataGeridView1.currentRow.cell[0].value.toString();
////////loading data to combobox
cboCategory.datasource=dt;
cboCategory.DisplayMember="Category";
cboCategory.valueMember="categoryid";
///////setting particular data to particular field
txtName.text=dt.rows[0]["productname"].toString();
////////enable disable button
btnDelete.enabled=false;
/////adding row to datatable
DataRow dr=dt.NewRow();
dr["categoryName"]="Choose Category";
dt.rows.insertAt(0,dr);
///////////on app.config file setting the connection parameter under <appSettings>
<add key="myConnection" value="Data Source=servername; Initial Catalog=db name;Integrated Security=true;";/>
</appSettings>
on the connection class 
AppSettingsReadear aps=new AppSettingsReader();
String constr=aps.getValue("myConnection",typeof(System.String)).toString();
////////if fields are passed as array sqlParameter[] param
the execution is cmd.parameters.addRange(param);
and CommandType cmdtype is passed to the parameter
cmd.commandType=cmdyype;
Type dataset
////////class and method to be initialize is given on the type dataset page after dragging the table 
type dataset is a item on dotnet create table and drop on it and its gives the name of class and creates method to get initially
to create other method to insert update delete
right click on get method and goto add query and select required from the list
get current date
DateTime.today.toshortdateString();
to show popup dialog 
selectCustomer frm=new selectcustomer();
DialogResult dr=frm.showDialog();
to declare ok on dialog reslut
this.dialogResult=DialogResult.ok
this.close();

remmber display member and value member while loading combo box
to check keys
e.keyCodes==keys.Enter
for looping the selected datagridviewrow
for(datagridviewrow dr in datagridview.selectedrows)
{

}
 Saving data to database from datagridview

Linq
to initialize the db using linq
DBBroadwayDataContext db=new DBBroadwayDatacontext();///it carries everything like connection string etc
.apsx
 we can use component of dotnet as we use in desktop app and we can apply css classes and ids as cssClass="" 
Master page doesnot run but holds all common items needs on website
the dynamic content goes under the content placeholder
app_code folder is used so that the code be run on runtime
in desktop app config file holds key value pair for the connection string but in web 
it is set as name and connectionstring under add tag and connectionstring is loaded as
string con=webconfigurationManager.connectionString["myconnection"].connectionString;
in the page load section of the page
if(!IsPostBack)
{
gridview1.datasource=dt;
gridview1.databind();/////to display on the web page
}
multiview component holds multi views like edit update delete section and we can set to button to load view one after another like 
multiview.activeIndex=0/1/2 etc;

creating the session 
Session.Add("userid",userid.toString());
fetching session
Session["userid"].toString();

/////////load id from gridview 
 int id = Convert.ToInt32(GridView1.SelectedDataKey.Value.ToString()); 
for pagination
set pagesize from properties to display numbers of item and set allowpaging true
on the pageindexchanging event
gridview1.pageIndex=e.newPageIndex;
loadgrid();
/////////////////////////////////////////////////////
Multiview gridview
in the web.config file
<connectionStrings>
    <add name="myconnection" connectionString="Data Source=(LocalDB)\MSSQLLocalDB; Integrated Security=True; Initial Catalog=DBBroadway;"/>
  </connectionStrings>
string con=webconfigurationManager.connectionString["myconnection"].connectionString;
on the multiple views inside the single multiviewitem views are passed and on the button it is set that
multiview1.activeViewIndex=1/2/3 etc;
/////////////////////////
HOw to get userid from selected row from gridview
 int userid = Convert.ToInt32(GridView1.SelectedDataKey.Value.ToString());
//storing userid in session
        Session.Add("storeuserid", userid.ToString());
//fetching from session
Session["storeuserid"]
//////enabling pagination
Allow paging=true from the property of grid
set page size for display per page
on the pageindexchanging event on the property panel of grid 
gridview1.pageIndex=e.newPageIndex;
loadgrid();
//////////////////////////
master grid Customize grid
•	add template field from edit columns option of the grid and select template field and give the name
•	and also untick the auto generated fields or set false on property on auto generated column
•	Add item template inside the template field to populate data item template is like td in the table and under the text of label                                                                              or other any component value filed is set as text='<%#Eval("categoryname");%>' if any grid is needed inside anny grid then it is drawn insite the item template we can directly apply datasource on the gridview as <asp:GridView ID="GridView2" runat="server" DataSource='<%getProbyCatid(Convert.ToInt32( Eval("CategoryId"))) %>' ></asp:GridView>
Multiple delete 
•	use bound field from edit columns and add bound field to bind data from property panel directly template filed lets us to populate data customly with item template but bound filed carries data filed prom property we must set it.
How to loop all row of grid and multiple delete
foreach (GridViewRow dr in GridView1.Rows)
        {
            if (dr.RowType == DataControlRowType.DataRow)//checking datarow
            {
                CheckBox delete = (CheckBox)dr.FindControl("chkDelete");//finding checkbox
                if(delete!=null)
                {
                    if(delete.Checked==true)
                    {
                        int productid =Convert.ToInt32( dr.Cells[1].Text.ToString());

                        int i = blp.DeleteProductbyProductId(productid);

                    }
                }
            }
        }
///////////
Add footer template if needed directly under the item template

Slider
use textbox for text input and fileupload for upload image and file
How to upload image in folder and name to database using c#
use repeater to loop through all images
and use header teplate to start all div and section and 
item template for contain image and footer template for ending divs and sections
as below

                            <asp:Repeater ID="Repeater2"      runat="server">
                                <HeaderTemplate>
                                      <div id="slider">
                                </HeaderTemplate>
                                <ItemTemplate>
                                     <a href="#">
                                        <img src="images/slideshow/<%#Eval("Photo") %>" alt="01" title="<%#Eval("Description") %>" /></a>
                                </ItemTemplate>
                                <FooterTemplate>
                                      </div>
                                </FooterTemplate>
                            </asp:Repeater>
///////////////////////////
and on master.aspx.cs
public void LoadSlider()
    {
        Repeater2.DataSource = bls.GetAllSlider();
        Repeater2.DataBind();
    }
////////////////////////////////////////////////////////
how to upload file to the folder in site
int i = bls.CreateSlider(txtDescription.Text, FileUpload1.FileName);
        if(i>0)
        {
FileUpload1.SaveAs(Server.MapPath("~/Images/slideshow/"+ FileUpload1.FileName));
        }
/////////////////////////////////////
datalist  fo repeat data as list
  <asp:DataList ID="DataList1" runat="se rver" RepeatColumns="3">
        <ItemTemplate>
            <div class="product_box margin_r40">
        <div class="thumb_wrapper"><a href="work_detail.html"><img src="images/Gallery/<%#Eval("Photo") %>" alt="image 1" /></a></div>
        <h3><%#Eval("Title") %></h3>
        <p><%#Eval("Description") %></p>
    </div>
        </ItemTemplate>
    </asp:DataList>
/////////////////////
URL Routing Project
Send redirect
Response.Redirect();

Asp dotnet accordion
install asp dotnet accordion
drag and drop  accordion  then insert pane  inside accordion then accordion pane  and inside accordion pane 
 put header and content to display header and corresponding content