Filters Using Dataset and Dataview

Using Dataset filtering the data and merging it to the same Dataset
ds = Select * from Query;
QryStr = "ID =" + 3;
DataSet dsview = new DataSet();
dsview = ds;
DataRow[] dr = dsview.Tables[1].Select(QryStr);
if (dr.Length > 0)
{
     DataTable dt = dsview.Tables[1].Select(QryStr).CopyToDataTable();
     ds.Tables[1].Clear();
    ds.Tables[1].Merge(dt);
}

Using Dataview filtering the data 

 ds = Select * from Query;
DataView dvstatus = new DataView(ds.Tables[0]);
string QryStr = string.Empty;
QryStr = "ID = 2 " + " Or ID = 3" + " Or ID = 7";
dvstatus.RowFilter = QryStr;
 if (dvstatus.Count > 0)
{
   ddlStatus.DataSource = dvstatus;
   ddlStatus.DataBind;
}



Comments

Post a Comment

Popular posts from this blog

How to retain the data annotations or class during modify a table in the database

Image
In database-first approach since there is an existing database., The entity classes are automatically created by edmx model.: If we use [MetadataType(typeof(ConceptMetadataSource))] to attach a MetadataSource file which contains all the data annotations like [HiddenInput(DisplayValue = false)] or [Display(Name = "Title")]. The data annotations will be wiped out each time the entity classes are regenerated as the code will be regenerated once we modify a table in the database Solution: All you have to do is create another partial class and use Metadatatype attribute Create a metadata class in models as below…   Create a Partial class for the metadata in models as below… The new partial class can be created in a different folder
Read more

Interview Questions

Difference between GET and POST. Which one is more secure? GET and POST methods are used for the data transfer between the web pages. GET mainly used for small data which is not secure because in case of GET method, the data which we are passing will be visible in the url so we can't keep the secure data which will be visible in the url. There is also limited data which can be passed in case of GET method (max 255 character). POST is used for transferring the huge data between the pages where we can keep the secure data and can transfer it. In case of using the POST method, the data which is transferring between the pages will not be visible so it is more secure than the GET method. Also there is no limit for POST method to post the data to the next page. POST is more secure What are Razor engines? How is it diff from ASP Engines? A. RAZOR engine is the new concept in the MVC 3 which is mainly used to create the views in the MVC applications. It created the cshtml pages for...
Read more

AJAX CONTROL

Image
1.        Goto  web confiq add following controls        < controls >   < add tagPrefix = " ccl " namespace = " AjaxContolToolkit " assembly   = " AjaxContolToolkit " />      </ controls > 2.        Go to  bin folder  ->  include project -> add ajax.dll file from AjaxControl Toolkit 3.        Add  toolsciptmanager  to default.aspx            < asp : ToolkitScriptManager ID ="ToolkitScriptManager1" runat ="server">         </ asp : ToolkitScriptManager > 4.        Create a function < script type = "text/javascript" >     function panelclick()     {    alert( "click" );  ...
Read more