ShamsiTech

INSERT INTO tbl1 SELECT s . id , s . Name , s . Fname FROM tbl2 s        LEFT JOIN tbl1 d ON ( d . id = s . id ) WHERE d . id IS NULL

In this Article we learn Basic LINQ Queries in Asp.Net . 1-       Fill Gridview record: public void showgridview()     {         DataClassesDataContext dc = new DataClassesDataContext ();         var q =         from a in dc.GetTable< bio >()         select a;         GridView1.DataSource = q;         GridView1.DataBind();        }                             2-       Search record: public void SearchQuery()     {         DataClassesDataContext dc = new DataClassesDataContext ();      ...

Definition : BindingNavigator control Provide user interface with a simple data navigation and manipulation on the form . it is used for Binding the Database Tables values to the control (Datagridview,Text Box, label etc.). BindingNavigator with the BindingSource enable users to move through data records on a form and interact with the records. There are few buttons in binding Navigator listed below: 1.       Move First--------------- à Go first record of the table 2.       Move Next--------------- à Go Next record of the table with respect to current record. 3.       Move Previous---------- à Go previous record of the table. 4.       Move Last---------------- à Go Last record of the table. 5.       Delete---------------------- à Delete selected row (record). 6.       Add New-------------------- à Add New Row. 7. ...

In this article we generate textbox at runtime.we give the quantity of textbox which we want to generate in textbox.it will generate textbox . Step 1: Open visual studio--->File--->New--->Project---->WindowsFormApplication                              Step 2: Drag panel1 , panel2,textBox1 and button from a toolbox window.                                                 Step 3: Now Doubble click on click me button and write the following code:        try             {                 int txtno = int .Parse(txt1.Text);             ...

Select a . Name as TblName , Sum ( b . Rows ) as RowsCount from Sys . Tables as a , Sys . Partitions as b where a . Object_Id = b . Object_Id Group By a . Name Order By Sum ( Rows ) Desc