how to write Prime number logic in sql server 2008

In this program i am going to give you code how to write prime number in sql server 2008.
prime number divisible by itself and by one.that we call as prime number.
i have shown here using while and if loop to check whether given number is prime or not

ALTER procedure [dbo].[prime_number]
(@@val int)
as
begin
declare @int int;
set @int=2;
while(@int < @@val)
          begin
if (@@val % @int=0)
            begin
            set @int=9;
break;
         end
          else
       set @int=@int + 1;
end
if (@int=9)
begin
print 'number is not prime number'
end
else
print  'NUMBER is prime number'
end

even and odd number in sql server 2008 with code

how to check number is even or odd in sql server using procedure.
it is very simple  to find out even or odd number .just create procedure and write
given functionality or logic in sql server 2008



ALTER procedure [dbo].[even_odd]
(@@val int)
as
begin
if (@@val%2=0)
begin
print 'even number'
end
else
print 'odd number'

end

delete record with checkbox checked event in gridview with code

in this program i am going show you how to  delete record on checkbox changed event when you

have taken checkbox into gridview .
on check box checked record will be deleted.


    protected void chkval_CheckedChanged(object sender, EventArgs e)
    {

        CheckBox chk = (CheckBox)sender; //will make checked checkbox true
      
           GridViewRow row = (GridViewRow)chk.NamingContainer; //will hit row
            Boolean ischecked =((CheckBox)(row.FindControl("chkval"))).Checked ;
//will find  checkbox which has selected or checked
           if (ischecked)
            {
                txtnm.Text = ((Label)(row.FindControl("lblNm"))).Text;
                delete(txtnm.Text);
            }
            else
           {

           }
           bind();
    }


now check for delete function from  where we are passing value from checked event.

  public void delete(string nm)
    {
       con.Open();
       SqlCommand cmd = new SqlCommand("delete from  stud where nm='"+nm+"'", con);
       int i= cmd.ExecuteNonQuery();
       con.Close();
       if (i > 0)
       {
           string deletevalue = "<script>alert(record deleted succesfully);</script>";
      Page.ClientScript.RegisterStartupScript(this.GetType(), "Script", deletevalue,false);
         
       }
       else
       {

       }
    }
now after click on checkbox value will be deleted from  respective table and database.

   <asp:GridView runat="server" ID="grd" AutoGenerateColumns ="false" >
    <Columns >
    <asp:TemplateField headertext ="Id">
    <ItemTemplate >
    <%#Eval("id")%></ItemTemplate>
    </asp:TemplateField>
      <asp:TemplateField headertext ="Name">
    <ItemTemplate >
   <asp:Label runat="server" ID="lblNm" Text='<%#Eval("nm")%>'></asp:Label></ItemTemplate>
    </asp:TemplateField>
      <asp:TemplateField headertext ="Select">
    <ItemTemplate >
    <%#Eval("lnm")%></ItemTemplate>
    </asp:TemplateField>
    <asp:TemplateField headertext ="Select">
    <ItemTemplate >
    <asp:CheckBox ID="chkval" runat="server" AutoPostBack="true" OnCheckedChanged="chkval_CheckedChanged" />
 </ItemTemplate>
    </asp:TemplateField>
   
       <asp:TemplateField headertext ="Lname">
    <ItemTemplate >
   <input type =text   id="txtAdd" value ='<%# "Mr  " +Eval("nm")+" "+ Eval("lnm") %>'/></ItemTemplate>
    </asp:TemplateField>
   
    </Columns>
    </asp:GridView>


   public void bind()
    {
        con.Open();
        SqlCommand cmd1 = new SqlCommand("select *  from stud", con);
        SqlDataAdapter sda = new SqlDataAdapter(cmd1);
        DataSet ds = new DataSet();
        sda.Fill(ds);
        ViewState["viewds"] = ds;
        grd.DataSource = ds;
        grd.DataBind();
        con.Close();
    }

CheckedChanged | checkBox | notworking | gridview in c# | Solution

 just add

 if (!IsPostBack)
        {
            bind();
        }
        else
        {

        }


on page load it  will work .
here i have shown how to emb ed cheked changed event in gridview when you are using gridview .

inside the gridview
 <asp:TemplateField headertext ="Select">
    <ItemTemplate >
    <asp:CheckBox ID="chkval" runat="server" AutoPostBack="true" OnCheckedChanged="chkval_CheckedChanged" />
 </ItemTemplate>
    </asp:TemplateField>

protected void chkval_CheckedChanged(object sender, EventArgs e)
    { //your code
    }