Machine Test * DATABASE CONNECTIVITY IN WEBFORM *

                                             *   DATABASE CONNECTIVITY IN WEBFORM  *

        1 ) Include database library 

           a )  SQL Server   -- SQLCLIENT

           b ) Exel / Access  -- OLEDB

           c ) XML              -- XML


        Step 1 :- open dotnet -- file -- new website -- Add new page -- Default.aspx

    Q ) How to connect database in dotnet

        Step 2 :- server explorer -- right click on Data Connection -- add connection -- Data                                               Source(Microsoft  SQL Server (SqlClient)) -- write your Server name ( .\SQLEXPRESS                 -- select or enterDataBase Name ( VNIT ) -- Test Coonection ( test connection succed) -- ok .

                 Check where your data connection :- server explorer  [ > ]

    Compulsary  Step for Database Handling 

 1)  Using Library 

       using System.Data.SqlClient;

 2)   SqlConnection cn ;   // read only connection code

       SqlCommand cm ;    // read only query

       SqlDataReader dr ;    // read only data

  3)  page Load 

{

        if (!IsPostBack)

        {

        }

}

  Q ) How to Find Database Connection Location and use connection code 

     Step :-  Design-- dataconnection -- table -- Drag table in design -- [ > ]  --  select Configure Data               Source --  [ + ] -- copy connection code -- and paste on string path ="connection code paste here" 

   * @ is a database finder 

   * then use connnection code before @ use it compulsary 

     ex :- string path = @"Data Source=.\SQLEXPRESS;Initial Catalog=vnit;Integrated Security=True";

              cn=new sqlconnection(path) ;

              cn.open( ) ;

   Types of query 

  1 ) Non Query :- nonquery refleting the table (INSERT,UPDATE,DELETE)

  2 ) EXECUTE READER :- only reading record ( SELECT )


 *  Parameter  Query accepting all types of record.


Q )  How to use Parameter Query

     String  k = " Insert into Demobb(name,city,mobile)values(@name1,@city1,@mobile1)"

         cm=new sqlcommand(k,cn );

         cm.parameter.addwithvalue("name1",txtname.text);   // pass parameter

         cm.parameter.addwithvalue("city1",txtcity.text);

         cm.parameter.addwithvalue("mobile1",txtmobile.text);

        cm.executenonquery( );



      

Comments

Post a Comment

Popular posts from this blog

DATA CONTROL ( Gridview , Repeater , Formview , DataList , Detailsview , Listview )

  GRIDVIEW SOURCE CODE :      <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"              Height="279px" Width="610px">             <Columns>                 <asp:TemplateField HeaderText="roll">                 <ItemTemplate>                     <asp:TextBox ID="txtroll" runat="server" Text='<%# Eval("roll") %>'></asp:TextBox>                 </ItemTemplate>                 </asp:TemplateField>                 <asp:TemplateField HeaderText="name">                 <ItemTemplate>               ...
Read more

Z 5 ) MVC (Model view Controller)

Image
  MVC (Model view Controller)    Model View Controller   The first version of  MVC is called MVED(Model View Editor) MVC is to multi layer architecture  Model         (class and variables) View          (.cshtml) Controller   (Logic building) MVC is directly operate html page in this reason it is called light weight environment. MVC Block Diagrame   .NET Framework  ASP.NET MVC ASP.Net Webform Benefits of MVC application It is manage complex application Direct control use in html It provide test driven development testing to (url http/data)
Read more

Z 8 ) MVC HTMLHELPER METHOD AND ACTIONLINK (how to use css ,atrributes,style in css)

Image
  HTML HELPER METHODS IN ASP.NET MVC 5 In ASP.NET MVC Framework, helper methods: Ø  Are extension methods to the Html Helper class, can be called only from views. Ø  An HTML helper is a method that is used to render html content in a view. Ø  Simplifies the process of creating a view. Ø  Allows generating HTML markup that you can reuse across the Web application. Some of the commonly used helper methods while developing an MVC application are as follows: Ø  Html.ActionLink() Ø  Html.BeginForm() and Html.EndForm() Ø  Html.Label() Ø  Html.TextBox() Ø  Html.TextArea() Ø  Html.Password() Ø  Html.CheckBox()
Read more