Fetch data Week Wise from SQL Server database and display using C# .Net

Question

In database i have a column named TaskdateTasknameTid of table tbltask if i open my gridview It must display this week assigned tasknames ie if my taskdate contains any records between 6th october and 11th it must display those records in gridview if i open that gridview next week from it must display next week records alone

Azim · Accepted Answer

You need to create the Stored Procedure and write this Select Query in itSELECT  FROM tbltaskWHERE Taskdate BETWEEN DATEADDWK DATEDIFFWK 0 Taskdate 0 AND DATEADDWK DATEDIFFWK 0 Taskdate  1 0 It will take the records between todays date and 6 days If any record is available between these two dates then it will be shown in the GridView

Shubh4m · Answer

Please refer this codeHTMLltaspGridView ID34GridView134 runat34server34 AutoGenerateColumns34false34gt    ltColumnsgt        ltaspBoundField DataField34TaskId34 HeaderText34Task Id34 gt        ltaspBoundField DataField34TaskDate34 HeaderText34Task Date34 gt        ltaspBoundField DataField34TaskName34 HeaderText34Task Name34 gt    ltColumnsgtltaspGridViewgtNamespacesusing SystemConfigurationusing SystemDataSqlClientusing SystemDataCprotected void PageLoadobject sender EventArgs e    if thisIsPostBack            thisPopulateGridView    private void PopulateGridView    string constr  ConfigurationManagerConnectionStrings34constr34ConnectionString    using SqlConnection con  new SqlConnectionconstr            using SqlCommand cmd  new SqlCommand34Select  from Task where Taskdate gt dateaddday 2datepartdw getdate CONVERTdateTi

Fetch data Week Wise from SQL Server database and display using C# .Net

Company

Explore

Follow us

Contact Us