Autogenerate ID

using System.Configuration;
using System.Data;
using System.IO;


protected void generatedStudID()
    {
        con.Open();

        cmd = new SqlCommand("select MAX(Sr_No) from  TABLENAME", con);

   
        int i = Convert.ToInt32(cmd.ExecuteScalar());
        con.Close();
        i++;
        strID = ID + Year + z + i.ToString();


    }

Solve DNS NOT Found problem in local system

1. Go to control panel

2. Click here Network and sharing center

3. Click Access Type Local Area Connection

4.Go to property

5. Select  4( TCP / IPV4 )

6. Set DNS 

                      8    8  8  8
                      8    8  4  4

CHECL IMAGE URL IS NULL OR NOT

 <div id="Div1" runat="server" visible='<%# Eval("pic") != DBNull.Value %>'>
 
  <asp:Image ID="Image1"     ImageUrl='<%# "/pic/" + Eval("pic") %>' runat="server" style="height:355px; width: 486px;"></asp:Image>

  </div> 

Blog code in asp.net c#

ASPX CODE

 <style>
* {
    box-sizing: border-box;
}

/* Add a gray background color with some padding */
body {
    font-family: Arial;
    padding: 20px;
    background: #f1f1f1;
}

/* Header/Blog Title */
.header {
    padding: 30px;
    font-size: 40px;
    text-align: center;
    background: white;
}

/* Create two unequal columns that floats next to each other */
/* Left column */
.leftcolumn { 
    float: left;
    width: 75%;
}

/* Right column */
.rightcolumn {
    float: left;
    width: 25%;
    padding-left: 20px;
}

/* Fake image */
.fakeimg {
    background-color: #aaa;
    width: 100%;
    padding: 20px;
}

/* Add a card effect for articles */
.card {
     background-color: white;
     padding: 20px;
     margin-top: 20px;
}

/* Clear floats after the columns */
.row:after {
    content: "";
    display: table;
    clear: both;
}

/* Footer */
.footer {
    padding: 20px;
    text-align: center;
    background: #ddd;
    margin-top: 20px;
}

/* Responsive layout - when the screen is less than 800px wide, make the two columns stack on top of each other instead of next to each other */
@media screen and (max-width: 800px) {
    .leftcolumn, .rightcolumn { 
        width: 100%;
        padding: 0;
    }
}
</style>





   <div class="container bgwhite" style="border-top: 10px solid #4f6584;">
      <div class="row"  style="padding: 50px 0 30px 0;" >
   
 <div class="card">



   
         <asp:Repeater ID="Repeater1" runat="server">
   
    <ItemTemplate >   

      <h2> <asp:Label ID="Label2" runat="server" Text='<%# Eval ("title") %>' style="width: 486px;"></asp:Label></h2><br /> 


       <div id="Div1" runat="server" visible='<%# Eval("pic") != DBNull.Value %>'>
 
  <asp:Image ID="Image1"     ImageUrl='<%# "/pic/" + Eval("pic") %>' runat="server" style="height:355px; width: 486px;"></asp:Image>

  </div> 


      <br />

     <p>  <asp:Label ID="Label3" runat="server" Text='<%# Eval ("article") %>'>'></asp:Label>   </p>
 

   <hr />
 
    </ItemTemplate>

    </asp:Repeater>


     </div>
 </div></div>



CS CODE


       SqlCommand cmd = new SqlCommand("select * from TABLE ORDER BY id  DESC ", con);
            DataSet ds = new DataSet();
            SqlDataAdapter da = new SqlDataAdapter(cmd);
            da.Fill(ds);
            Repeater1.DataSource = ds;
            Repeater1.DataBind();
         
               

How to use OL tag in Repeater control

How to use  OL  tag in Repeater control




 <ol>
               <asp:Repeater ID="repearter" runat="server">
                    <ItemTemplate>
                     <a href='/publish/<%#Eval("filename") %>'>
                        <li>
                       
                      <span class="auto-style2" style="color:#333"><b>    <%# DataBinder.Eval(Container.DataItem, "title")%> </b> </span>  <br />

                        <asp:Label ID="lblTitle" runat="server" Text='<%# Eval("authorname") %>'></asp:Label>
                       
                       
                       
                        </li>
                        </a>
                        <br />
                         <hr /><br />
                    </ItemTemplate>
                </asp:Repeater>

        </Ol>

Data list with column

 <asp:DataList ID="dlstmovie" runat="server" 
 RepeatColumns="4"   
 RepeatDirection="Horizontal" 
 Width="100%"
  CellPadding="4"
  CellSpacing="4" 
  OnItemCommand="dlstmovie_ItemCommand">

 <ItemTemplate>
     
     
 <asp:Label ID="Label3" runat="server" Visible="false" Text='<%#Eval("pyear") %>'>'> 

 </asp:Label>


 <asp:Button ID="but1" runat="server"   Width="114px"  CommandName="but1_Click"

  CssClass="contact-form"   Text='<%#Eval("pyear") %>'/>
                     
     
    </ItemTemplate>




c# code




  protected void show()
    {
       
        cn = new SqlConnection(cs);
        cn.Open();

        cm = new SqlCommand("select  pyear from publishtb group by pyear  ORDER BY pyear asc", cn);
        DataSet ds = new DataSet();
        SqlDataAdapter da = new SqlDataAdapter(cm);
        da.Fill(ds);

        dlstmovie.DataSource = ds;
        dlstmovie.DataBind();
        cn.Close();





    }

Gridview Image Link

 <asp:TemplateField HeaderText="View Certificate" >
                        <ItemTemplate>
                            <a onclick="javascript:window.open('<%# String.Format("/portal/upload/{0}",Eval("certificate")) %>','PORTAL','left=20,top=20,width=500,height=500,toolbar=0,reizable=0');" target="_blank">
                                Show
                            </a>
                        </ItemTemplate>

                    </asp:TemplateField>