Saturday, November 3, 2018

how to auto refresh asp.net Grid view |Sradha Webcreations

auto update e-commerce website customer  order in admin panel | Auto refresh asp.net Grid view ,  Auto Refresh Asp.net repeater control, Datalist Control

  Default.aspx page 

  • add script manager 
  • add update panel 
  • set timer control also set Interval="1000" 

<asp:ScriptManager ID="ScriptManager1" runat="server"></asp:ScriptManager>
               
                <asp:UpdatePanel ID="UpdatePanel1" runat="server">
                    <ContentTemplate>
                          <asp:Timer ID="Timer1" runat="server" OnTick="Timer1_Tick" Interval="1000"></asp:Timer>
  <asp:Repeater ID="Repeater1" runat="server">
              <HeaderTemplate>  
                  
                                <table style=" width:100%;  line-height:30px" >  
                            <tr style="background-color:#990000; color:#ffffff; font-weight:bold; font-size:18px">  
                               <%-- <th scope="col" style="width: 04px; visibility:hidden">UserId 
                                </th> --%> 
                                 <th scope="col" style="width: 04px" >UserId 
                                </th> 
                                <th scope="col" style="width: 120px"><div style="margin-left:10px">Date &Time  </div>
                                </th>  
                                <th scope="col" style="width: 100px">Order ID
                                </th>  
                                <th scope="col" style="width: 80px">Full Order
                                </th>  
                              <%--  <th scope="col" style="width: 120px">Update Order
                                </th>  --%>
                               
                            </tr>  
                    </HeaderTemplate>    
                              
                      <ItemTemplate>
                          
                          <tr>
                              <%--<td><asp:Label ID="Labelid" Visible="false"  runat="server" Text='<%# Eval("UserId") %>'></asp:Label></td>--%>
                              <td><asp:Label ID="Labelid"   runat="server" Text='<%# Eval("UserId") %>'></asp:Label></td>
                              <td><asp:Label ID="LabelDT" runat="server" Text='<%# Eval("DT") %>'></asp:Label></td>
                              <td><asp:Label ID="Labeladdress" runat="server" Text='<%# Eval("OrderID") %>'></asp:Label></td>
                              <td><a href="AdminFullOrder.aspx?Userid=<%#Eval("Userid")%>" style="color:#cc0000;font-weight:bold" >View Full Order</a></td>
                                <%--  <td><a href="#" style="color:#cc0000; font-weight:bold">Update Order</a></td>--%>
                                   
                              </tr>
                                                 
                        </ItemTemplate>
                      <FooterTemplate>  
                        </table>  
                    </FooterTemplate>   
               

         </asp:Repeater>
</ContentTemplate>

                    </asp:UpdatePanel>

                    

Default.aspx.cs page
  protected void Timer1_Tick(object sender, EventArgs e)
    {
        Repeater1.DataBind();
    }

how to set auto refresh in asp.net grid view control
how to
set auto refresh in asp.net Repeater control
how to
set auto refresh in asp.net Datalist control
how to
set auto refresh in asp.net List view control


http://sradhawebcreations.com/

#SradhaWebCreations
Contact : +91-9040573923, +91-7008182025
http://sradhawebcreations.com/
http://sradhawebcreations.blogspot.in/
https://facebook.com/sradhawebcreations
https://www.facebook.com/Sradhawebeducation/

Friday, November 2, 2018

how to add edit and Delete image in asp.net Grid view Command Field | Sradha Webcreations

hoe to add Edit , Delete , Update & Cancel icon Image in asp.net Grid View Command Field

use this code in grid view 


 <asp:TemplateField>
                 <EditItemTemplate>
                     <asp:ImageButton ID="btnUpdate" runat="server" CommandName="Update" ImageUrl="~/image/thik.jpg" ToolTip="Update" />
                     <asp:ImageButton ID="btnCancel" runat="server" CommandName="Cancel" ImageUrl="~/image/crush.jpg" ToolTip="Cancel" />
                 </EditItemTemplate>
                 <ItemTemplate>
                     <asp:ImageButton ID="btnEdit" runat="server" CommandName="Edit" ImageUrl="~/image/edit.jpg" ToolTip="Edit Qty" />
                     <asp:ImageButton ID="btnDelete" runat="server" CommandName="Delete" ImageUrl="~/image/delete.jpg" ToolTip="Delte Item" />
                 </ItemTemplate>
             </asp:TemplateField>

delete this code in grid view 

 <%-- <asp:CommandField HeaderText="Cart Order"   ShowEditButton="True" EditText="add Qunatity" ItemStyle-Width="100" >
<ItemStyle Width="100px"></ItemStyle>
                                 </asp:CommandField>
                                   <asp:CommandField HeaderText="Delete Order" ShowDeleteButton="True" DeleteText="Delete Item" ItemStyle-Width="100"  >
<ItemStyle Width="100px"></ItemStyle>
                                 </asp:CommandField>--%>


        




how to add Delete icon image in asp.net grid view Command Field
how to add Edit icon image in asp.net grid view Command Field
how to add Cancel icon image in asp.net grid view Command Field
how to add Update icon image in asp.net grid view Command Field



http://sradhawebcreations.com/

#SradhaWebCreations
Contact : +91-9040573923, +91-7008182025
http://sradhawebcreations.com/
http://sradhawebcreations.blogspot.in/
https://facebook.com/sradhawebcreations
https://www.facebook.com/Sradhawebeducation/



Wednesday, October 17, 2018

e-commerce website designing services in odisha | android mobile app development services in odisha | Sradha Webcreations

e-commerce website designing services in odisha 
 android mobile app development services in odisha


e-commerce website is the best & easy way to reach customer .
Starting an e-commerce business is never an easy job. but it your online store never close so any user customer visit at any time in your online store.




This can help you to increase your customer. it also help customer to locate the product Quicker, Eliminate travel time and cost, provide Comparison shopping, enable Deals, Bargains, Coupons and Group Buying, Provide Abundant information about product etc.


e-commerce website create market for Niche Products and remain Open all time. It also overcome geographical limitations. One of the most tangible positives of e-commerce is the lowered cost .





we also deal with e-commerce mobile app. After installing the mobile app user can easily order his/her product through mobile . no need to use computer (pc).we also promote your online store .


https://odishafoodmart.com/
by 
http://sradhawebcreations.com/

#SradhaWebCreations Contact : +91-9040573923, +91-7008182025 http://sradhawebcreations.com/ http://sradhawebcreations.blogspot.in/ https://facebook.com/sradhawebcreations https://www.facebook.com/Sradhawebeducation/

Thursday, August 30, 2018

pest control Services in odisha | Sradha Webcreations | Manaswini Pest Control Services




Manaswini Pest Control Services

More Than10 Years Of WorkExperience






Manaswini Pest Control Services provider all House hold pest Control in Twin Cities. We are well known for our efficient services and on time delivery. We offer innovative pest control solutions for both residential and commercial spaces.

 

Ø     Termite Control (Post & Pre)

Ø     Rodent Control

Ø     Fly Control

ØCockroach Control

ØWeed Control

ØLizard Control

ØMosquitoes Control

ØBug Buster Service

 

Our Prices & Special Discounts
 NOW OFFERING THE BEST CASH DISCOUNT IN THE AREA 7% OFF !!!

 


by
http://sradhawebcreations.com/
+91-9937614595, +91-9348139624, +91-9668330437
Infront of Ultra Hospital,Near Axis Bank , Jagatpur Cuttack-754021, Odisha.

 


Sunday, August 26, 2018

how to store images in image datatype in sql server | Sradha WebCreations

how to store images in image datatype in sql server


HttpHandler.aspx
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="HttpHandler.aspx.cs" Inherits="HttpHandler" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
    <div>

       Enter ID&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;  <asp:TextBox ID="TextBox1" runat="server"></asp:TextBox><br />
       Enter Name&nbsp;&nbsp; <asp:TextBox ID="TextBox2" runat="server"></asp:TextBox><br />
        Select image&nbsp;  <asp:FileUpload ID="FileUpload1" runat="server" /><br />
       &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
       <asp:Button ID="Button1" runat="server" Text="Save" onclick="Button1_Click" /><br />

       <asp:Image ID="Image1"  runat="server" Height="137px" Width="130px" /><br />
       
        <asp:DropDownList ID="TextBox3" runat="server">
        </asp:DropDownList>
       
        <asp:Button ID="Button2" runat="server" Text="Search" onclick="Button2_Click" />

    </div>
    </form>
</body>
</html>

HttpHandler.aspx.cs
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Data.SqlClient;
using System.Data;
using System.Web.UI.WebControls;
using System.Configuration;

public partial class HttpHandler : System.Web.UI.Page
{
    //static SqlConnection con = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=E:\websites\HttpHandlerDemo\App_Data\Database.mdf;Integrated Security=True;User Instance



Wednesday, August 22, 2018

how to upload file in web server using file zilla | Sradha WebCreations

how to upload html , CSS, folders, pictures, js files, web.config file, global.ashx file other file in web server using file zilla


Enter the host name , enter user name, password, account name….then click on connect..

now file zilla is connected to server , select your domain name double click on it


Open the website folder… present in the system.  Select the files and folders from your system drag and drop that file to the filezilla server loacation area.

After drop that files in the server location area of filezilla…right click on the first file …click on process to queue….


After successfully transfer the files to server open the web site…



http://pasupatigroup.com/




how to save image in binary format in asp.net & Sql Server | sradha Webcreations

how to save image in binary format  in asp.net & Sql Server also retrieve same images 


ImageSave.aspx
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="ImageSave.aspx.cs" Inherits="ImageSave" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
    <table>
<tr>
<td>
    SomeText</td>
<td>
    <asp:TextBox ID="TextBoxSomeText" runat="server"></asp:TextBox>
</td>
</tr>
<tr>
<td>
Image Name:
</td>
<td>
<asp:TextBox ID="txtImageName" runat="server"></asp:TextBox>
</td>
</tr>
<tr>
<td>
Upload Image:
</td>
<td>
<asp:FileUpload ID="fileuploadImage" runat="server" />
</td>
</tr>
<tr>
<td>
</td>
<td>
<asp:Button ID="btnUpload" runat="server" Text="Upload" onclick="btnUpload_Click" />
</td>
</tr>
</table>
    </div>
    <div>
<!--<asp:gridview id="GridView1" runat="server" autogeneratecolumns="False">
       <columns>

           <asp:boundfield datafield="ImagePath" headertext="Header Text"></asp:boundfield>
           <asp:templatefield headertext="Image Form DataBase">

               <itemtemplate>
                   <img alt="Image" height="70px" src="<%# "ImageHandler.ashx?Id="+ Eval("id") %>" width="70px"/>
               </itemtemplate>
           </asp:templatefield>

       </columns>
   </asp:gridview>-->


   <asp:DataList ID="Datalist1" runat="server"  Width="100px" RepeatColumns="1">
   <ItemTemplate>
   <img alt="Image" height="70px" src="<%# "ImageHandler.ashx?Id="+ Eval("id") %>" width="70px"/>
   </ItemTemplate>
      </asp:DataList>
</div>
    </form>
</body>
</html>

ImageSave.aspx.cs
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.Security;

public partial class ImageSave : System.Web.UI.Page
{
    string strcon = ConfigurationManager.ConnectionStrings["dbconnection"].ConnectionString;
    protected void Page_Load(object sender, EventArgs e)
    {
        LoadData();
    }
    private void LoadData()
    {
        string returnValue = string.Empty;

        //Get the databse connection string from web.config file

        string conString = ConfigurationManager.ConnectionStrings["dbConnection"].ConnectionString;
        SqlConnection sqlConn = new SqlConnection(conString);
        SqlDataReader sqlDr = null;
        try
        {

            SqlCommand sqlCmd = new SqlCommand("GetImageInfoFromDB", sqlConn);
            sqlCmd.CommandType = CommandType.StoredProcedure;

            sqlConn.Open();
            sqlDr = sqlCmd.ExecuteReader();
            //Bind gridView

            //GridView1.DataSource = sqlDr;
            //GridView1.DataBind();

            Datalist1.DataSource = sqlDr;
            Datalist1.DataBind();
        }

        catch (Exception ex)
        {
            //Handle Error

        }
        finally
        {

            if (sqlDr != null && !sqlDr.IsClosed)
            {

                sqlDr.Close(); //close sqldatareader

            }

            sqlConn.Close();
        }
    }

    protected void btnUpload_Click(object sender, EventArgs e)
    {
        //Condition to check if the file uploaded or not
        if (fileuploadImage.HasFile)
        {
            //getting length of uploaded file
            int length = fileuploadImage.PostedFile.ContentLength;
            //create a byte array to store the binary image data
            byte[] imgbyte = new byte[length];
            //store the currently selected file in memeory
            HttpPostedFile img = fileuploadImage.PostedFile;
            //set the binary data
            img.InputStream.Read(imgbyte, 0, length);
            string imagename = txtImageName.Text;

            img.InputStream.Read(imgbyte, 0, length);
            string SomeText = TextBoxSomeText.Text;
            //use the web.config to store the connection string
            SqlConnection connection = new SqlConnection(strcon);
            connection.Open();
            SqlCommand cmd = new SqlCommand("INSERT INTO Image_Binary (SomeText,ImagePath,Image_Blob) VALUES (@SomeText,@ImagePath,@Image_Blob)", connection);
           
            cmd.Parameters.Add("@SomeText",SqlDbType.VarChar,50).Value=SomeText;
            cmd.Parameters.Add("@imagePath", SqlDbType.VarChar, 50).Value = imagename;
            cmd.Parameters.Add("@image_Blob", SqlDbType.Image).Value = imgbyte;
            int count = cmd.ExecuteNonQuery();
            connection.Close();
            if (count == 1)
            {
              //  BindGridData();
                txtImageName.Text = string.Empty;
                ScriptManager.RegisterStartupScript(this, this.GetType(), "alertmessage", "javascript:alert('" + imagename + " image inserted successfully')", true);
            }
        }
    }
   
}
ImageHandler.ashx
<%@ WebHandler Language="C#" Class="ImageHandler" %>

using System;
using System.Web;
using System.Data.SqlClient;
using System.Data;
using System.Configuration;


public class ImageHandler : IHttpHandler
{

    public void ProcessRequest(HttpContext context)
    {
        // context.Response.ContentType = "text/plain";
        //context.Response.Write("Hello World");

        string strId = context.Request.QueryString["Id"];
        if (!string.IsNullOrEmpty(strId))
        {
            SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["dbConnection"].ConnectionString);
            SqlDataReader sqlDr = null;
            try
            {
                conn.Open(); //open database connection

                SqlCommand sqlCmd = new SqlCommand("GetImageFromDB", conn);
                sqlCmd.CommandType = CommandType.StoredProcedure;

                //Add the parameter to SQLCommand object
                sqlCmd.Parameters.AddWithValue("@id", strId);
                sqlDr = sqlCmd.ExecuteReader();
                sqlDr.Read();
                context.Response.BinaryWrite((Byte[])sqlDr[3]);
                context.Response.End();

            }

            catch (Exception ex)
            {
                //Handle error If occured
            }
            finally
            {

                if (sqlDr != null && !sqlDr.IsClosed)
                {

                    sqlDr.Close(); //close SqlDataReader

                }

                conn.Close();//close database connection

            }
        }

    }
  
    public bool IsReusable
    {

        get
        {

            return false;

        }

    }

}

 Create 1 Procedures
Connect to ImageSave.aspx.cs for all data retrive from data base
SqlCommand sqlCmd = new SqlCommand("GetImageInfoFromDB", sqlConn);
CREATE PROCEDURE GetImageInfoFromDB

AS

BEGIN
 SELECT  id,SomeText,ImagePath,Image_Blob FROM dbo.Image_Binary
END



Create second procedure
Connect To ImageHandler.ashx for single data retrive

SqlCommand sqlCmd = new SqlCommand("GetImageFromDB", conn);

CREATE PROCEDURE GetImageFromDB(@id int)

AS

BEGIN



 SELECT  id,SomeText,ImagePath,Image_Blob FROM dbo.Image_Binary WHERE id = @id



END

After that  ImageHandler.ashx is called in ImageSave.aspx  datalist view/ grid view page
   <asp:DataList ID="Datalist1" runat="server"  Width="100px" RepeatColumns="1">
   <ItemTemplate>
   <img alt="Image" height="70px" src="<%# "ImageHandler.ashx?Id="+ Eval("id") %>" width="70px"/>
   </ItemTemplate>
      </asp:DataList>


 #SradhaWebCreations
Contact : +91-9040573923, +91-7008182025 http://sradhawebcreations.com/ http://sradhawebcreations.blogspot.in/ https://facebook.com/sradhawebcreations https://www.facebook.com/Sradhawebeducation/