Sunday 25 November 2012

In Text Only Numeric Value is inter&&In Text Only Char Are inter Value



<head runat="server">
  <script type="text/javascript">
        function FilterInput (event) {
            var keyCode = ('which' in event) ? event.which : event.keyCode;
            isNumeric = (keyCode >= 48 && keyCode <= 57) ||
                        (keyCode >= 96  && keyCode <= 105 );
            modifiers = (event.altKey || event.ctrlKey || event.shiftKey);
            return !isNumeric || modifiers;
        }
   
 </script>


 <script type="text/javascript">
        function isNumeric(keyCode)
        {
           // return ((keyCode >= 48 && keyCode <= 57) || keyCode == 8)
            return (((keyCode >= 48 && keyCode <= 57)||(keyCode >= 96
&& keyCode <= 105) ) || keyCode == 8)
        }
    </script>
    <title>Untitled Page</title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
    <h2>In Text Only Numeric Value is inter</h2>
      <asp:TextBox ID="TextBox1"   onkeydown = "return
isNumeric(event.keyCode);"     autocomplete="off" runat="server"
MaxLength="3"></asp:TextBox>
  <h2>In Text Only Char Are inter Value </h2>
       <asp:TextBox ID="TextBox2" onkeydown="return FilterInput
(event)" runat="server"></asp:TextBox>
    </div>
    </form>
</body>

Al Validation ,reg expression,valid no.

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

<!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">
    <script src="img/themes/calendar.js" type="text/javascript"></script>
    <%-- <script src="Images/ProtectImage.js" type="text/javascript"></script>  --%>
    <link href="img/themes/forest.css" rel="stylesheet" type="text/css" />
    <link href="img/themes/layouts/small.css" rel="stylesheet" type="text/css" />
    <script src="img/themes/calendar-en.js" type="text/javascript"></script>
    <title></title>
 

 <script type="text/javascript">
       function isNumeric(keyCode) {
           // return ((keyCode >= 48 && keyCode <= 57) || keyCode == 8)
           return (((keyCode >= 48 && keyCode <= 57) || (keyCode >= 96
             && keyCode <= 105)) || keyCode == 8)
       }
    </script>

    <style type="text/css">
        .style1
        {
            width: 61%;
        }
        .style2
        {
        }
        .style3
        {
            color: #FF0000;
        }
        .style4
        {
            width: 25px;
        }
        .style5
        {
            width: 25px;
            height: 21px;
        }
        .style6
        {
            height: 21px;
            width: 219px;
        }
        .style7
        {
            width: 25px;
            height: 31px;
        }
        .style8
        {
            height: 31px;
            width: 219px;
        }
        .style9
        {
            width: 25px;
            height: 23px;
        }
        .style10
        {
            height: 23px;
            width: 219px;
        }
        .style11
        {
            width: 25px;
            height: 30px;
        }
        .style12
        {
            height: 30px;
            width: 219px;
        }
        .style13
        {
            width: 219px;
        }
        .style14
        {
            width: 1384px;
        }
        .style15
        {
            height: 26px;
            width: 1384px;
        }
    </style>
</head>
<body>
    <form id="form1" runat="server">
    <div>
   
        <table class="style1">
            <tr>
                <td class="style2" colspan="2">
                   
                    <span class="style3">&nbsp;&nbsp; Registration Form &nbsp;</span></td>
            </tr>
            <tr>
                <td class="style9">
                    Name
                </td>
                <td class="style10">
                    <asp:TextBox ID="TextBox4" runat="server"></asp:TextBox>
                    <td class="style14">
                        <asp:RequiredFieldValidator ID="RequiredFieldValidator5" runat="server"
                      ErrorMessage="*" ControlToValidate="TextBox4" ForeColor="#FF0066"></asp:RequiredFieldValidator>
                   
                    </td>
                  </td>
              

            </tr>
            <tr>
                <td class="style4">
                    LoginId</td>
                <td class="style13">
                    <asp:TextBox ID="TextBox3" runat="server"
                         ></asp:TextBox>
                    <td class="style14">                    
                    <asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server"
                      ErrorMessage="*" ControlToValidate="TextBox3" ForeColor="#FF0066"></asp:RequiredFieldValidator>
                        <asp:RegularExpressionValidator ID="RegularExpressionValidator1" runat="server" ControlToValidate="TextBox3"
                                ErrorMessage="LoginId is only alphabets and Underscore" Font-Names="Arial" Font-Size="Small"
                                Height="17px" Style="position: static;" ValidationExpression="^[a-zA-Z]\w{3,14}$"
                                Width="300px" ForeColor="#FF0066"></asp:RegularExpressionValidator>
                   
                   
                   
                    </td>
                </td>     
               
            </tr>
            <tr>
                <td class="style4">
                    EmailId</td>
                <td class="style13">
                    <asp:TextBox ID="txtEmail" runat="server"></asp:TextBox>
                    <td class="style15">
                            <asp:RequiredFieldValidator
                                ID="RequiredFieldValidator2" runat="server" ControlToValidate="txtEmail"
                                ErrorMessage="RequiredFieldValidator" Style="position: relative; vertical-align: top;
                                text-align: left; left: -2px; top: 1px; width: 8px;" Height="18px"
                                ForeColor="#FF0066">*</asp:RequiredFieldValidator>
                               <asp:RegularExpressionValidator ID="RegularExpressionValidator2" runat="server" ControlToValidate="txtEmail"
                                ErrorMessage="Email not in proper format" Font-Names="Arial" Font-Size="Small"
                                Height="17px" Style="position: static;" ValidationExpression="\w+([-+.']\w+)*@\w+([-.]\w+)*\.\w+([-.]\w+)*"
                                Width="156px" ForeColor="#FF0066"></asp:RegularExpressionValidator>
                                                                                                      
                  </td>
                </td>
            </tr>
            <tr>
                <td class="style5">
                    Phoneno</td>
                <td class="style6">
                    <asp:TextBox ID="TextBox1" onkeydown = "return isNumeric(event.keyCode);" autocomplete="off" runat="server"></asp:TextBox>
                    <td class="style14">
                      <asp:RequiredFieldValidator ID="RequiredFieldValidator3" runat="server"
                      ErrorMessage="*" ControlToValidate="TextBox1" ForeColor="#FF0066"></asp:RequiredFieldValidator> 
                   
                    </td>
                </td>
            </tr>
            <tr>
                <td class="style7">
                    Services</td>
                <td class="style8">
                    <asp:CheckBoxList ID="CheckBoxList1" runat="server" Height="54px" Width="294px">
                        <asp:ListItem>vbvbv</asp:ListItem>
                        <asp:ListItem>dds</asp:ListItem>
                        <asp:ListItem>cvcxxcx</asp:ListItem>
                    </asp:CheckBoxList>
                    <%-- <td>
                     <asp:RequiredFieldValidator ID="RequiredFieldValidator6" runat="server"
                      ErrorMessage="*" ControlToValidate="CheckBoxList1" ForeColor="#FF0066"></asp:RequiredFieldValidator>
                    </td>--%>
                </td>
            </tr>
            <tr>
                <td class="style4">
                    DOB</td>
                <td class="style13">
                    <asp:TextBox ID="TxtDate" runat="server"></asp:TextBox>
                    <asp:Button ID="trigger2" runat="server" Text="----"  ToolTip="Please clik here"/>
                          <script type="text/javascript">//<![CDATA[
                              Zapatec.Calendar.setup({
                                  firstDay: 1,
                                  weekNumbers: false,
                                  showOthers: true,
                                  electric: false,
                                  inputField: "TxtDate",
                                  button: "trigger2",
                                  ifFormat: "%m/%d/%Y",
                                  daFormat: "%Y/%m/%d"
                              });

                                      //]]></script>
                       

                    </td>
                    <td class="style14">
                        &nbsp;</td>
            </tr>
            <tr>
                <td class="style4">
                    Photo</td>
                <td class="style13">
                    <asp:FileUpload ID="imgUpload" runat="server" />
                    <td class="style14">
                      <asp:RequiredFieldValidator ID="RequiredFieldValidator4" runat="server"
                      ErrorMessage="*" ControlToValidate="imgUpload" ForeColor="#FF0066"></asp:RequiredFieldValidator>
                    </td>
                </td>
            </tr>
            <tr>
                <td class="style11">
                </td>
                <td class="style12">
                    <asp:Button ID="Button1" runat="server" Text="Save" onclick="Button1_Click" />
                    <asp:Button ID="Button2" runat="server" Text="Exit" />
                </td>
            </tr>
            <tr>
                <td class="style9">
                </td>
                <td class="style10">
                </td>
            </tr>
            <tr>
                <td class="style4">
                    &nbsp;</td>
                <td class="style13">
                    &nbsp;</td>
            </tr>
            <tr>
                <td class="style4">
                    &nbsp;</td>
                <td class="style13">
                    &nbsp;</td>
            </tr>
        </table>
   
    </div>
    </form>
</body>
</html>

Runtime

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Data;

/// <summary>
/// Summary description for Runtype
/// </summary>
public class Runtype
{
    SPMS serv1 = new SPMS();
    public DataTable dtrip = new DataTable();
    public DataTable regtable = new DataTable();

    public Runtype()

    {
        //
        // TODO: Add constructor logic here
        //
    }
    //Regtable fdhhfhfddfhhfdhfhfhfd

    public void intiregtable()
    {
        try
        {
            {
                regtable.Columns.Add("name");
                regtable.Columns.Add("loginid");
                regtable.Columns.Add("Emailid");
                regtable.Columns.Add("phoneno");
                regtable.Columns.Add("services");
                regtable.Columns.Add("photo");
                regtable.Columns.Add("dob");
            
            }
            regtable.Rows.Add(regtable.NewRow());

        }
        catch (Exception ex)
        {

        }


    }
    public long SaveimageRecord(DataSet ds1,byte[] t)

    {
        long Recid = 0;
        try
        {

            Recid = serv1.AddNewRegRecords(ds1, t);
        }
        catch (Exception ex)
        {

        }
        return Recid;

    }

    public void intitable()
    {
        try
        {
            {
                dtrip.Columns.Add("Title");
                dtrip.Columns.Add("Firstname");
                dtrip.Columns.Add("Middlename");
            }
            dtrip.Rows.Add(dtrip.NewRow());

        }
        catch (Exception ex)
        {

        }

    }

    public long SaveRecords(DataSet ds1)

    {
       long Recid=0;
        try
        {
        
            Recid = serv1.AddNewRecords(ds1);
         }
       catch (Exception ex)
        {

        }
        return Recid ;

    }

    public long UpdateRecords(DataSet ds1,int j)

    {
        long Recid = 0;
        try
        {

            Recid = serv1.UpdateRecords(ds1 ,j);


        }
        catch (Exception ex)
        {

        }
        return Recid;

    }


    public long DeleteRecords( int j)

    {
       long Recid = 0;
        try
        {

            Recid = serv1.DeletetripRecord(j);


        }
        catch (Exception ex)
        {

        }
        return Recid;

    }
    public DataSet GetData()
    {
        DataSet Ds1 = new DataSet();
        try
        {
     
            Ds1 = serv1.GetRecordTripDetail();
  
        }
        catch (Exception ex)
        {


        }
        return Ds1;

    }

    public DataSet GetCountryName()
    {
        DataSet Ds1 = new DataSet();
        try
        {

            Ds1 = serv1.GetContryMaster();

        }
        catch (Exception ex)
        {


        }
        return Ds1;

    }
    public DataSet GetDataByRecid(int ictr)
    {
        DataSet Ds1 = new DataSet();
        try
        {

            Ds1 = serv1.GetDatabyRecid( ictr);


        }
        catch (Exception ex)
        {


        }
        return Ds1;

    }

    public DataSet GetStateName(int ictr)

    {
        DataSet Ds1 = new DataSet();
        try
        {

            Ds1 = serv1.GetStateName(ictr);


        }
        catch (Exception ex)
        {


        }
        return Ds1;

    } 


}

SPMS PAGE

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Data;
using System.Data.SqlClient;
using System.Transactions;

/// <summary>
/// Summary description for SPMS
/// </summary>
public class SPMS
{
    string cnnstr = System.Configuration.ConfigurationManager.AppSettings["vskcon"];
    SqlConnection CNN = new SqlConnection();
    public SPMS()
    {
        CNN.ConnectionString = cnnstr;
    }

  //**********************************************************************
    public long AddNewRegRecords(DataSet ds,byte[] d)

    {
        SqlTransaction SQLT = null;
        int recId = 0;
        bool Berror = false;
        SqlCommand CMD = new SqlCommand();
        try
        {
            try
            {
                if (CNN.State == ConnectionState.Closed)
                    CNN.Open();
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
            }
            SQLT = CNN.BeginTransaction();
            CMD.Transaction = SQLT;
            CMD.Connection = CNN;
            DataTable dttripstart = new DataTable();
            dttripstart = ds.Tables[0];
            CMD.CommandType = CommandType.StoredProcedure;
            CMD.CommandText = "SaveregRec";
            CMD.Parameters.Clear();
            CMD.Parameters.AddWithValue("@name", dttripstart.Rows[0]["name"]);
            CMD.Parameters.AddWithValue("@loginId", dttripstart.Rows[0]["loginid"]);
            CMD.Parameters.AddWithValue("@Email", dttripstart.Rows[0]["Emailid"]);
            CMD.Parameters.AddWithValue("@phoneno", dttripstart.Rows[0]["phoneno"]);
            CMD.Parameters.AddWithValue("@services", dttripstart.Rows[0]["services"]);
            CMD.Parameters.AddWithValue("@photo",d);
            CMD.Parameters.AddWithValue("@Dob", dttripstart.Rows[0]["dob"]);
            SqlParameter SQLPar = new SqlParameter();
            SQLPar = CMD.Parameters.Add("RETURN_VALUE", SqlDbType.BigInt);
            SQLPar.Direction = ParameterDirection.ReturnValue;

            recId = CMD.ExecuteNonQuery();
            //int i = (int)CMD.Parameters["RETURN_VALUE"].Value;
            if (recId == 0)
            {
                Berror = true;

            }

            if (Berror == true)
            {
                CMD.Transaction.Rollback();
                return 0;
            }
            else
            {
                CMD.Transaction.Commit();

            }

        }
        catch (Exception ex)
        {
        }
        finally
        {
            if (CNN.State != ConnectionState.Closed)
                CNN.Close();
        }
        return recId;

    }
   


    public long AddNewRecords(DataSet ds)
    {
        SqlTransaction SQLT = null;
        int recId = 0;
        bool Berror = false;
        SqlCommand CMD = new SqlCommand();
        try
        {
              try
            {
                if (CNN.State == ConnectionState.Closed)
                    CNN.Open();
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
            }
            SQLT = CNN.BeginTransaction();
            CMD.Transaction = SQLT;
            CMD.Connection = CNN;
            DataTable dttripstart = new DataTable();
            dttripstart = ds.Tables[0];
            CMD.CommandType = CommandType.StoredProcedure;
            CMD.CommandText = "SaveAddressRecord1";
            CMD.Parameters.Clear();
            CMD.Parameters.AddWithValue("@title", dttripstart.Rows[0]["Title"]);
            CMD.Parameters.AddWithValue("@Firstname", dttripstart.Rows[0]["Firstname"]);
            CMD.Parameters.AddWithValue("@Middlename", dttripstart.Rows[0]["Middlename"]);
            SqlParameter SQLPar = new SqlParameter();
            SQLPar = CMD.Parameters.Add("RETURN_VALUE", SqlDbType.BigInt);
            SQLPar.Direction = ParameterDirection.ReturnValue;

            recId = CMD.ExecuteNonQuery();
           //int i = (int)CMD.Parameters["RETURN_VALUE"].Value;
            if (recId == 0)
            {
                Berror = true;

            }

            if (Berror == true)
            {
                CMD.Transaction.Rollback();
                return 0;
            }
            else
            {
                CMD.Transaction.Commit();

            }

        }
        catch (Exception ex)
        {
        }
        finally
        {
            if (CNN.State != ConnectionState.Closed)
                CNN.Close();
        }
        return recId;

    }
    public long UpdateRecords(DataSet ds,int i)

    {
        SqlTransaction SQLT = null;
        int recId = 0;
        bool Berror = false;
        SqlCommand CMD = new SqlCommand();
        try
        {
            try
            {
                if (CNN.State == ConnectionState.Closed)
                    CNN.Open();
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
            }
            SQLT = CNN.BeginTransaction();
            CMD.Transaction = SQLT;
            CMD.Connection = CNN;
            DataTable dttripstart = new DataTable();
            dttripstart = ds.Tables[0];
            CMD.CommandType = CommandType.StoredProcedure;
            CMD.CommandText = "updaterecord23";
            CMD.Parameters.Clear();
            CMD.Parameters.AddWithValue("@id", i);
            CMD.Parameters.AddWithValue("@title", dttripstart.Rows[0]["Title"]);
            CMD.Parameters.AddWithValue("@Firstname",dttripstart.Rows[0]["Firstname"]);
            CMD.Parameters.AddWithValue("@Middlename", dttripstart.Rows[0]["Middlename"]);
            SqlParameter SQLPar = new SqlParameter();
            SQLPar = CMD.Parameters.Add("RETURN_VALUE", SqlDbType.BigInt);
          SQLPar.Direction = ParameterDirection.ReturnValue;
            recId = CMD.ExecuteNonQuery();
            //int i = (int)CMD.Parameters["RETURN_VALUE"].Value;
            if (recId == 0)
            {
                Berror = true;

            }

            if (Berror == true)
            {
                CMD.Transaction.Rollback();
                return 0;
            }
            else
            {
                CMD.Transaction.Commit();

            }

        }
        catch (Exception ex)
        {
        }
        finally
        {
            if (CNN.State != ConnectionState.Closed)
                CNN.Close();
        }
        return recId;

    }

    public  DataSet GetRecordTripDetail()
    {
        DataSet dsGlobal = new DataSet();
        try
        {
            SqlDataAdapter adapGlobal = new SqlDataAdapter();
            SqlCommand cmd = new SqlCommand();
          try
            {
                if (CNN.State == ConnectionState.Closed)
                    CNN.Open();
            }
            catch (Exception ex)
            {
                CNN.Close();

            }
            if (CNN.State == ConnectionState.Closed)
                CNN.Open();
            cmd.Connection = CNN;
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.Clear();
            cmd.CommandText = "jktveiwdata1";
            adapGlobal.SelectCommand = cmd;
            adapGlobal.Fill(dsGlobal);
        }
        catch (Exception ex)
        {
        }
        finally
        {
            CNN.Close();

        }

        return dsGlobal;


    }
    public DataSet GetContryMaster()

    {
        DataSet dsGlobal = new DataSet();
        try
        {
            SqlDataAdapter adapGlobal = new SqlDataAdapter();
            SqlCommand cmd = new SqlCommand();
            try
            {
                if (CNN.State == ConnectionState.Closed)
                    CNN.Open();
            }
            catch (Exception ex)
            {
                CNN.Close();

            }
            if (CNN.State == ConnectionState.Closed)
                CNN.Open();
            cmd.Connection = CNN;
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.Clear();
            cmd.CommandText = "GetCountryName";
            adapGlobal.SelectCommand = cmd;
            adapGlobal.Fill(dsGlobal);
        }
        catch (Exception ex)
        {
        }
        finally
        {
            CNN.Close();

        }

        return dsGlobal;


    }

    public DataSet GetDatabyRecid(int ik)
    {

        DataSet ds = new DataSet();
        SqlCommand cmd = new SqlCommand();
        SqlDataAdapter da = new SqlDataAdapter();
        try
        {
            cmd.Connection = CNN;
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.CommandText = "GetRecordsByRecId";
            cmd.Parameters.AddWithValue("@RecId", ik);
            da = new SqlDataAdapter(cmd);
            da.Fill(ds);
            if (ds.Tables.Count > 0)
            {
                return ds;

            }

        }
        catch (Exception ex)
        {
            CNN.Close();
            return ds;
        }
        return ds;

    }


    public DataSet GetStateName(int ik)

    {

        DataSet ds = new DataSet();
        SqlCommand cmd = new SqlCommand();
        SqlDataAdapter da = new SqlDataAdapter();
        try
        {
            cmd.Connection = CNN;
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.CommandText = "GetSateName";
            cmd.Parameters.AddWithValue("@Recid", ik);
            da = new SqlDataAdapter(cmd);
            da.Fill(ds);
            if (ds.Tables.Count > 0)
            {
                return ds;

            }

        }
        catch (Exception ex)
        {
            CNN.Close();
            return ds;
        }
        return ds;

    }

    public long DeletetripRecord(int ik)
    {
        SqlTransaction SQLT = null;

        int recId = 0;
        bool Berror = false;
        SqlCommand CMD = new SqlCommand();
        try
        {
            //CNN.ConnectionString = cnnstr;

            try
            {
                if (CNN.State == ConnectionState.Closed)
                    CNN.Open();
            }
            catch (Exception ex)
            {
                throw ex;

            }
            finally
            {
            }
            // CNN.Open();
            SQLT = CNN.BeginTransaction();
            CMD.Transaction = SQLT;
            CMD.Connection = CNN;
            //DataTable dttripstart = new DataTable();
            //dttripstart = ds.Tables[0];
            CMD.CommandType = CommandType.StoredProcedure;
            CMD.CommandText = "DelEeg11";
            CMD.Parameters.Clear();
            CMD.Parameters.AddWithValue("@RecId", ik);
            //CMD.Parameters.AddWithValue("@Starttrip", dttripstart.Rows[0]["TripStart"]);
            //CMD.Parameters.AddWithValue("@endtrip", dttripstart.Rows[0]["TripEnd"]);
            SqlParameter SQLPar = new SqlParameter();
            SQLPar = CMD.Parameters.Add("RETURN_VALUE", SqlDbType.BigInt);
            SQLPar.Direction = ParameterDirection.ReturnValue;

            recId = CMD.ExecuteNonQuery();
            int i = (int)CMD.Parameters["RETURN_VALUE"].Value;
            if (i == 0)
            {
                Berror = true;

            }

            if (Berror == true)
            {
                CMD.Transaction.Rollback();
                return 0;
            }
            else
            {
                CMD.Transaction.Commit();

            }

        }
        catch (Exception ex)
        {
        }
        finally
        {
            if (CNN.State != ConnectionState.Closed)
                CNN.Close();
        }
        return recId;




    }

}

.csPage

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.IO;
using System.Data;


public partial class Registreation : System.Web.UI.Page
{
    Runtype run = new Runtype();
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!Page.IsPostBack)
        {
            //GetDataItem();
            //id = Convert.ToInt32(Page.Request.QueryString["id"]);


            //if (id > 0)
            //{
            //    DataSet Ds = new DataSet();
            //    Ds = run.GetDataByRecid(id);
            //    TextBox1.Text = Ds.Tables[0].Rows[0]["Title"].ToString();
            //    TextBox2.Text = Ds.Tables[0].Rows[0]["Firstname"].ToString();
            //    TextBox3.Text = Ds.Tables[0].Rows[0]["MiddleName"].ToString();
            //}


        }

    }
    protected void Button1_Click(object sender, EventArgs e)
    {
      

        putdata();
        FileUpload img = (FileUpload)imgUpload;
        Byte[] imgByte = null;
        if (img.HasFile && img.PostedFile != null)
        {
            //To create a PostedFile
            HttpPostedFile File = imgUpload.PostedFile;
            //Create byte Array with file len
            imgByte = new Byte[File.ContentLength];
            //force the control to load data in array
            File.InputStream.Read(imgByte, 0, File.ContentLength);
        }
        byte[] d = imgByte;

        Savedata(run.regtable, d);

      
      
    }
    public void Savedata(DataTable dt,byte[] t)
    {
        DataSet Ds = new DataSet();
        Ds.Tables.Add(dt);
        run.SaveimageRecord(Ds,t);
    }
   
    public void putdata()

    {
       
        run.intiregtable();
        run.regtable.Rows[0]["name"] = TextBox4.Text;
        run.regtable.Rows[0]["loginid"] = TextBox3.Text;
        run.regtable.Rows[0]["Emailid"] = txtEmail.Text;
        run.regtable.Rows[0]["phoneno"] = TextBox1.Text;
        run.regtable.Rows[0]["services"] = TextBox1.Text;
        //run.regtable.Rows[0]["photo"] = imgByte;
        run.regtable.Rows[0]["dob"] = TxtDate.Text;
    }
 
}

Tuesday 20 November 2012

Automatically Generate Sr. No. in Gridview


<asp:TemplateField HeaderText="S No.">
                    <ItemStyle HorizontalAlign="Center" Width="50px" />
                    <ItemTemplate>
                        <asp:Label ID="Sno" runat="server" Text='<%# CType(Container, GridViewRow).RowIndex + 1%>'></asp:Label>
                    </ItemTemplate>
                    <HeaderStyle HorizontalAlign="Left" Width="35px" />
                </asp:TemplateField>

CODE For Select Distinct Value Grom Column and Assign To Grid View

Dim MyView As DataView = New
DataView(dtEmail.DefaultView.
ToTable("dtEmail", True, "Email"))

Merge To Dataset and copy Of Two Dataset

Dim ds1 As New System.Data.DataSet
            Dim ds2 As New System.Data.DataSet
            ds1 = oblGF.jktview()
            ds2 = oblGF.jktview2()
            ds1.Tables(0).TableName = "FistTable"
            ds2.Tables(0).TableName = "SecoundTable"
            ds2.Tables.Add(ds1.Tables(0).
Copy)
            'This is code for Merge to Dataset
            'ds1.Merge(ds2, True, MissingSchemaAction.Add)
            Dim ds3 As New DataSet
            ds3 = ds2

Code For Disable Back Button

<html xmlns="http://www.w3.org/1999/xhtml" >
<head id="Head1" runat="server">
<title>Untitled Page</title>

 <script type = "text/javascript" >
       function preventBack()
       {window.history.forward();}
        setTimeout("preventBack()", 10);
        window.onunload=function(){
null};
 </script>

 <script type="text/javascript">

    function openWindow() {
        //Open a new window with no toolbar
        window.open("http://localhost:4033/pjkt/HowtodisableBACKbutoonOfBroser1.aspx","mywindow","status=1,
toolbar=0");

        }
</script>
<script type="text/javascript">

    function openWindow1() {
        //Open a new window with no toolbar
        window.open("http://localhost:4033/pjkt/CUSTOMPaginginGRidViev.aspx","mywindow","status=1,
toolbar=8");

        }
</script>
<%--<script type = "text/javascript" >
function disableBackButton()
{
window.history.forward();
window.history.backward();
}
setTimeout("disableBackButton()", 0);
</script>--%>
</head>
<body onload="disableBackButton()">
<form id="form1" runat="server">
<div>
This is First page <br />
<br />
Go to Second page
<br />
    <asp:Button ID="Button1" runat="server" Text="Go To second Page
But NotDisable the Back Button " />
<br />

 <input type="button" value="Open Page With Hide Tool Bar"
onclick="openWindow()"/>
 <br />
  <input type="button" value="Open Page Disable The back button"
onclick="openWindow1()"/>
    </div>
</form>
</body>
</html>