Go to DotNetFunda.com
<<= Please see left side tutorials menu.


Silverlight Tutorials | Report a Bug in the Tutorial

Found interesting? Add this to:

| More

asp:ObjectDataSource control
ObjectDataSource enables user to define their own custom classes to bind data to the controls.
 
ObjectDataSource enables user to define their own custom classes to bind data to the controls. To use a class as an ObjectDataSource that class must have their own Insert, Delete, Update, and Select method. One important point that must be noted that ObjectDataSource doesn't support batch updation of the data, so the update method must support updation of the record one by one.

Some Important Properties of ObjectDataSource Control
InsertMethod, InsertParameters Gets or sets the name of the method and its parameter to perform insert operation.
UpdateMethod, UpdateParameters Gets or sets the name of the method and its parameter to perform update operation.
DeleteMethod, DeleteParameters Gets or sets the name of the method and its parameter to perform delete operation.
SelectMethod, SelectParameters Gets or sets the name of the method and its parameter to perform select operation.
ConvertNullToDBNull true/false. Used to indicate whether null parameter passed to the method should be converted to System.DBNull.
DataObjectTypeName Gets or sets the class name that is used to perform insert, update, delete, and select operation.
EnablePaging true/false. True if paging is supported by the method.
FilterExpression, FilterParameters Gets or sets the filter expression and filter parameter to filter the select operation.
SelectCountMethod Gets or sets the method name that is used to count the selected records (selected by SelectMethod method).
SortParameterName Gets or sets the name of the input parameter used to sort selected record.
StartRowIndexParameterName Works only if EnablePaging=true. Gets or sets the name of the parameter of select method that is used as starting record from where to retrieve records.
ConvertNullToDBNull true/false. Used to indicate whether null parameter passed to the method should be converted to System.DBNull.
DEMO : ObjectDataSource Show Source Code
AutoIDNameAddressPhoneCity
2345aaaa
2333abcdefghijlmnopqrstuvwxyzaaa
2335Baas dddfsdf
2329czcczczczczczczxczcczcz
2315daaa
2342dereer
2343dereer
2344dereer
2317dfasfdasasdfasfadfsdsafasdfadsf
2336dfgdgdshsdh
2341dfsfd443fds
2327ffffffffffff
2346fvgjgfjfgjfgj
2331gfgvcvbvbbvc
2286ghdfnjklhk70897097
2282hjhgj876ghjhgj876hgjhgjghjhg
2310hjhikjkjjjjjj
2311jhkjjkjlkjkjlkjkjk
2321john1232381111troy
2323kegf
2328mannfdsf23213dsfdsf
2320ppppppp
2302Praveen Gurgaon78945612Gurgaon
2287qqqnjklhk70897097
1752qqqqqqtuticorinasdfasdf
2347qweqweqweqwe
2179qweweqwer14144134fdsgdsfg
1499rddfdffd
2074rajqqq
1945rajachennai222222222chennai
1472rajahyd2314ghfqwerwe
2061Rajesh142/12 ram gali9900112233ajmer
1578rajkumarGrean45454Karur
1538rajkumarashoksaralqrwe
2253Rakeshbangalore9611299277bangalore
1932RamJaipur9232332230Jaipur
1933RamJaipur9088989909Jaipur
1934Ramljkklkjl
2096ramindia123545chennai
1833RamanaReddyAmeerpet9703268938Hyderabad
1939RAT65234567890Chennai
1986rathorefdf24343dsdf
2100Raulmjn
1328ravindrakumarghghg598798798juhuh
2228rdfrdfrfff
1982reeererer
2222retertertertertertertert
2223retertertertertertertert
2224retertertertertertertert
2265rewrewrwrew
2266rewrwerwrwe
1904robinddddddd
1878rrrrrrrrrrrrrrrr
2215rtbjj0989blbl
2313rtertretwertertwertertwert
1667rtrrtrtrtrtrt
1992rtreerbangalore998659618Bangalore
2194rtreerrerterertererter
1990rtttttwsrttygtteyy
2263rttytytytytytytytytyyyuyu
1671rturtueurtzurtzuru
1432rwrwrrwrrw
1750rwererwerwerer
1948rwerwwrewrwrwrwrrwr
1739swaa
1741swaa
1318ssss
1332ss32322332
2299sasdasdasd
2192ssss
1987S23weqep
1708ssss
2283ssss
1886ssss
1630ssss
2115sasa123sa
1662sawweerr
1935sassssss
2021sadasdasdasd
1322sadasdasasdasasdas
1510sadasdasasdasdasdasd
2312sad   
2010sadfasdfasdfasdf
1361sadhanaandheri456781452andheri
1362sadhanadfa8989AFDASF
1894sadsadasdsadasdasdsadsafasfasfa
1969saerfersdsvsv133331vvdd
2155safasdfasfafafdsaf
2238safdasfsannnn516756315nhyghfghfghhh
2226sagarpatel9978265019ahmedabad
2167saiaaa
1596samanand9003992220tuty
2086samanhaw1232kursistan
2078Samsungasa121asa
1772sanjayhdgfhhdfghhdf
1830sanjaysanjaysanjaysanjay
1740saran12,asdsads sads231321312sfsdfsdfsd
1795sassas2121212ewew
1946sasabbb999jjj
1930satishpfc33333ssss
1426satishvskp81440085504vskp
2197saurabhaaaaaaaaa
2218SauravKolkata10000Kolkata
1733sdasdassadasds
2109sdsdasasss
2110sdsdasasss
2111sdsdasasss
2112sdsdasasss
1956sdsd??szDasd
1809sdsdf45rsdf
2113sdsdasasss
2195sdadadasdaasdaasda
2234sdassafdsasfdsfsafsdf
1458sddfdfdfdfdfdfd
1459sddfdfdfdfdfdfd
1462sddfdfdfdfdfdfd
1464sddfdfdfdfdfdfd
1330sddssaasaadd4343434343ddsdds
1379sdfsdfsdfsfd
1616sdfsdfsdfsdf
1661sdfdsfsdfsdf
1478sdfsdfsdfsdfsdfsdf
1571sdfasdfsafasd
2291sdfdsfdsfadf
1500sdfsadfsfdasfd
1392sdfsdfsdfsdf
2340sdfsfsdfsf
1451sdfsdfsdfsdf
1501sdfsadfsfdasfd3
1735sdfsdfsdfssdf
1924sdfdsfsdfsdf
1791sdfsdfsdfsdf
1793sdfyffhfgh
1725sdfhahahahahahabnmbnm
1697sdfsdfsdfsdf
1685sdfafsdfasdsfaffasdfasd
1686sdfafsdfasdsfaffasdfasd
1349sdfaasdfsdfaafsd
2098sdfasdfasdfasdffas
1393sdfgsdfg345345sdfg
2117sdfssdfsdfsdf
1974SDFSDSDFSD234234ASDFSDF
2187sdfsdfsdfsdafsdf
2035sdfsdfsdfsdfsdfsdfsdfdsf
1644sdfsdfasdfasd4534543asfsdfsdf
1973sdggsdgsdgsdgsd
1424SDNSDVSDFBJKVF1DSFASDAFSDAFFSDFAFDSAFSDFAFSDA
2275sdsdsdsdsdsdsdsdssdsd
2273sdsdsdsdsdsdsdsdssdsd
2276sdsdsdsdsdsdsdsdssdsd
2278sdsdsdsdsdsdsdsdssdsd
2271sdsdsdsdsdsdsdsdssdsd
2272sdsdsdsdsdsdsdsdssdsd
2274sdsdsdsdsdsdsdsdssdsd
2277sdsdsdsdsdsdsdsdssdsd
2279sdsdsdsdsdsdsdsdssdsd
2280sdsdsdsdsdsdsdsdssdsd
1669sdsdsdsdsdsdsdsd
1497sdsffdgfdg23344fdgfgf
1327sdvsdvsdvsdvsdvsdv
1796seemagdhsdghdfdshgdggh
1348sersdf4545454aafsd
2210setlimanila1234manila
2013sfdsfsd344dasfs
2190sfdsfsfdsf3343fd
1517sfssfsf122222
1555sfsafaala
1779shabkol3535chen
2209shariquepulgate9970848286pune
1658shilpapune213556vbbbbbbfg
1798shilpaetrter35435464365fdsfsdg
1316Shjreebangalore0989876787 
1325shreebangalore8766786868pune
1938shrikanthabsiguda9985822222hyd
1895shuchitabangalore  
2045Siju 9447367717Kochi
1611sowmyajayanagar45678899bangalore
2307sriaaaaaaaa9999999999aaaaaaaaa
1329Srikanthbnmbnmdfbn
2053srinivashyderabad9703268937hyderabad
2012srinivashyderabad867876786hyderabad
2212srinivassrinivassrinivassrinivas
1866srinivasameerpet687687768976hyderabad
1542srinivas chowdaryguntur786867868767hyderabad
2054srinivas chowdaryhyderabad9703268937hyderabad
1993srinivas chowdaryguntur'76868767865hyderabad
1346srinivasansfds13432sdfds
1344srinivasanasdadad
2180srinu12398833333333hyd
1486srtyysssasas
1543ssaa33ff
1663sssdffdfdf
1455ssssssss
2094sssaassaas
1531ssssdsds23232sdsd
2290ssssssssshhhhhhhhhhh555555555555555lllllllllll
1931sssssssssssssssssssssss33333333ssssssss
2161stuffwhowhatwhere
2042Subhadeepasad9985654778Kolkaa
2293suniluppal988875424hyd
1341sunilhyd555555555hhhhhhhhh
2027sunilzeea
2284sureshAddressPhoneCity
1617swehyd5555hyd
1903swwsafdasdfasdfdsf
1888tttt
1826tttt
2007TTTT
2325tttt
1889tfsdaffsdffsd
2036tdtreyttyrytytreytre
1922testtest12323garde
1423testtesttesttest
2309testtesttestTEST
1528testttt
1687TestTRest2356666Test
2204testwqeweeqwe
1880testtesttesttest
1711TestTest909099090090pune
2319test88 djo dr102-193-1292Loa
2305testtesttesttest
1597testfszfsffsfsffsfsf
2149TestTestTestTest
2231testtest55555555test
1634testtesttesttest
1386testtest3454543trest
2139testtest123123test
2141testtesttesttest
2164testjkdkjdfsfgfgfdgfgdhdfjk
1339TestTtTtgtt
1744testtest99999999city
1861testtesttesttest
2022Test`TestTestTest
1893test1test2test3test4
2171testetestetesteteste
1926TESTETESTE91189050BELEM
2173testetestetesteteste
2032Testingzeea
1736testtetesttesttest
1836tiyak12k12k12
2292trrdffdfds
1358trytuytuytu
1601tryryrytrtyryttryrytry
1530tttttttt
1704tthhhhh
2193ttryrtytrytrytrytrtrhytrytr
2132tttdsfds4353ff
1608tttttssss343cxcxc
2257TYTYTYT   
2189tyukghjksdf45676 
1485tyutyufghfghfg6646hfghf
1817uiasdfasdfadf
1789uioioioiiuo
1683USAnjomwqfUSAUSA
1777USAiubuhlsbUSAUSA
1670USAtjvghhmUSAUSA
2102UshaDelhi00Delhi
1967uttuutdtuddgdfgdfg
1968utuutduuddugdgd
1609uuuussss445454545bvbvbv
1610uuuussss445454545bvbvbv
1626uuuuu7uuuuu88888iokiii
1981uyyyy66hh
1400uyyyueateatatea
1848vddd
1722varora4545454chennai
1727varora4545454chennai
2099Varun123 Main228-2222Here and Now
1646varunmig94kp
2072vcvcxvxcvcx
2120vffff
2118vffff
2119vffff
2121vffff
2245vijayameerpet9948969626hyderabad
2153vilasBangalore7474747474Bangalore
2039vimalnoida8800615290noida
2077wwww
2060wwww
2339wefsdfsfsf
2174wergergergregregreg
2188werwerwerwe343434efwer
2348wqweqweqweqwe
2133wrwrewrwaaaaaaaaaa
2244xvxcvxcv43xcvxcv
2260xvxcvxvxcvxcv
2322xxx111111111ttttt
2075yuiuyiuyiuiuyi
2126YuorajPune-149090pune
2146yuvipune-149999pune
2205yuytuytutyutyutyuytu
2029yuyuzeea
2064zenosahaya84942trere
2145zxsasss
Parameter of SelectMethod
Show record WHERE AutoID greater than
                    
// GridView Control ///////////////////////////////
<asp:GridView ID="GridView1" DataSourceID="ObjectDataSource1" runat="server" CellPadding="4" ForeColor="#333333" GridLines="None"
 PageSize="10">
    <FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
    <RowStyle BackColor="#F7F6F3" ForeColor="#333333" />
    <EditRowStyle BackColor="#999999" />
    <SelectedRowStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333" />
    <PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" />
    <HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
    <AlternatingRowStyle BackColor="White" ForeColor="#284775" />
</asp:GridView>


// ObjectDataSource Control ///////////////////////////////
<asp:ObjectDataSource ID="ObjectDataSource1" runat="server"
  TypeName="ObjectDataSourceSample" SelectMethod="Load">
  <SelectParameters>
    <asp:ControlParameter ControlID="txtGreater" PropertyName="Text" Name="greaterThan" Type="int32" />
  </SelectParameters>
</asp:ObjectDataSource>    
                       

// Parameter of SelectMethod ///////////////////////////////
Show record WHERE AutoID greater than <br />
<asp:TextBox ID="txtGreater" runat="Server" Text="3" Columns="5"></asp:TextBox>
<asp:CompareValidator ID="Cm" runat="server" ControlToValidate="txtGreater" Text="Numeric only" Display="Dynamic" Operator="DataTypeCheck" Type="integer"></asp:CompareValidator>
<asp:Button ID="btnSubmit" runat="Server" Text="Submit" />                       

    
    /// Load records ///////////////////////////////
    public DataSet Load(int greaterThan)
    {
        DataSet dSet = new DataSet();
        string connStr = ConfigurationManager.ConnectionStrings["ConectionString"].ToString();
        using (SqlConnection conn = new SqlConnection(connStr))
        {
            conn.Open();
            
            SqlDataAdapter dAd = new SqlDataAdapter("SELECT * FROM Sample WHERE AutoID > "+ greaterThan +" ORDER BY Name", conn);
            dAd.Fill(dSet, "SampleTable");
        }
        return dSet;
    }            
                    




About Us | The Team | Advertise | Contact Us | Testimonials | Privacy Policy | Terms of Use | Link Exchange | Members | Go Top
General Notice: If you found plagiarised (copied) contents on this page, please let us know the original source along with your correct email id (to communicate) for further action.
Copyright © DotNetFunda.Com. All Rights Reserved. Copying or mimicking the site design and layout is prohibited. Logos, company names used here if any are only for reference purposes and they may be respective owner's right or trademarks. | 9/3/2010 4:11:43 AM