SQL Server

Enable Windows Defender via Group Policy - "This App Is Turned Off By Group Policy'

noreply@blogger.com (Sujay Sharma) — Sun, 21 Feb 2016 13:33:00 +0000

Windows Defender This Program Is Blocked By Group Policy or This App Is Turned Off By Group Policy in Microsoft Windows 10 / Microsoft Windows 8 / Microsoft Windows 7 .

Enable Microsoft Windows Defender via Group Policy -

Step 1. Open Run Command or press Windows key + R and type regedit click OK . As Shown fig.

Step 2. After click on OK button Registry Editor will be open .
Click On HKEY_LOCAL_MACHINE As Shown in Fig.

Step 3. Click On Software As Shown in Fig..

Step 4. Click on Policies ,Select Microsoft, Select Windows Defender As Shown in Fig..

Step 5. After delete As Shown in Fig.

Step 6 . Open Microsoft Windows Defender As Shown in Fig..

and now click on Start Button.

Speed Up Your Computer - Use Pendrive As Ram In Windows 7, Windows 8, Windows 10

noreply@blogger.com (Sujay Sharma) — Wed, 10 Feb 2016 13:05:00 +0000

We can use pen drive like RAM for speed up your computer (Windows 7, Windows 8, Windows 10 ) but how to proceed ? It is very easy...........

1. First of all Insert Your Pen Drive.

After insert Pen Drive ,

2. Right click on Pen Drive , select properties as shown in fig.....

3. Now Properties window will appear, then click on ReadyBoost as shown in fig...

4. select use this drive as shown in fig....

Click on apply and ok.

Tutorials - Table in Microsoft SQL Server

noreply@blogger.com (Sujay Sharma) — Tue, 17 Nov 2015 08:41:00 +0000

How to create table in Microsoft SQL Server ?

If u want to store any data in Microsoft SQL Server database then u will have to create a table. So to create a table u should to keep a unique name of that table. In a table combination of column and row, each column define in bracket which content what type of data u insert. To creating a table in Microsoft SQL Server by heading syntax CREATE TABLE “table name” statement.

For example:

Below is an example to create a table in Microsoft SQL Server name “CUSTOMER” which contain his detail, and in which his fields/data cannot be NULL.

CREATE TABLE CUSTOMERS

(

ID INT NOT NULL,

NAME VARCHAR (20) NOT NULL,

AGE INT NOT NULL,

ADDRESS CHAR (25) ,

SALARY DECIMAL (18, 2),

PRIMARY KEY (ID)

);

Execute a table.

To execute a table in Microsoft SQL Server, first you will select a query like below

And then press F5 or press the execute button which located in top left in Microsoft SQL Server.

Insert a data in Microsoft SQL Server table.

There are two basis ways to insert a data in Microsoft SQL Server table with the help of INSERT INTO syntax. In 1^st, u will define the column name while writing the syntax to inserting the data in Microsoft SQL Server.

Example

INSERT INTO TABLE_NAME (column1, column2, column3,...columnN)]

VALUES (value1, value2, value3,...valueN);

INSERT INTO CUSTOMERS (ID,NAME,AGE,ADDRESS,SALARY)

VALUES (1, 'Ramesh', 32, 'Ahmedabad', 2000.00 );

And in 2^nd You will directly put the values in that particular table.

Example

INSERT INTO TABLE_NAME VALUES (value1,value2,value3,...valueN);

INSERT INTO CUSTOMERS

VALUES (7, 'Muffy', 24, 'Indore', 10000.00 );

How to view column of table in Microsoft SQL Server ?

By the select command you can view a column which you have created in Microsoft SQL Server.

Syntax:

Select * from “table name”

Example:

select * from customers

How to delete a table from Microsoft SQL Server ?

By the Microsoft SQL Server drop statement you can delete the table along with all the data and command given on that particular table.

But make sure you have to delete the table and all its command; because once you have deleted the table then you’ll not recover the data which were saved in table.

Syntax:

DROP TABLE table_name;

E.g.;

DROP TABLE Customers;

select and press F5 .

Microsoft Edge : Windows 10

noreply@blogger.com (Sujay Sharma) — Sat, 03 Oct 2015 19:25:00 +0000

Microsoft Edge is a web browser developed by Microsoft , it replaced Internet Explorer as default browser on Windows 10. In Microsoft Edge .......1. You can make a web note on webpages. For make a note ...Click on make a web note button ......

After click on make a web note button ...... You get option
1. Pen 2. Highlighter 3. Eraser 4. You can type 5. take clip 6. save and 7. share your note.

2. Hub.....

Select Hub to view your favourite, reading list, browsing history, and current downloads.

3. Reading View...

In reading view you get clean and simple layout , you are reading front and center, change the reading view style and font size according to you from more setting option.

Microsoft SQL Server 2016 : Attach a database by using Transact-SQL

noreply@blogger.com (Sujay Sharma) — Sat, 03 Oct 2015 17:48:00 +0000

Attach a database in SQL Server Management Studio 2016.

Before attaching the database

1 . Copy (two file e.g. the ‘database.MDF‘ file which contains the primary data, and the ‘database.LDF‘ file which logs) and
2. Paste "C:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\DATA" -(copy the file into the default location for data files)

Now we are ready to attach them.

3. Open SQL Server Management Studio....Click on connect button
4. Press Ctrl+N or Click on new query From the Standard bar...

CREATE DATABASE AdventureWorks2012
ON
(FILENAME='C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\AdventureWorks2012_Data.mdf')
LOG ON
(FILENAME='C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\AdventureWorks2012_log.ldf')
FOR ATTACH

5. Copy above code and paste. After paste code click on execute or press F5

Database is now attached.. the result is

Microsoft SQL Server 2016 : Attach a database by using SQL Server Management Studio

noreply@blogger.com (Sujay Sharma) — Sat, 03 Oct 2015 16:27:00 +0000

Attach a database in SQL Server Management Studio 2016.

Before attaching the database

1 . Copy (two file e.g. the ‘database.MDF‘ file which contains the primary data, and the ‘database.LDF‘ file which logs) and
2. Paste "C:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\DATA" -according to your Microsoft SQL Server folder.

Now we are ready to attach them.

3. Open SQL Server Management Studio....Click on connect button and then expand that instance.

4. Right-click Databases and click Attach.

5. Click ADD button ..

6. Select your database for attach ...and click Ok button

7. and click Ok button

Database is now attached to the SQL instance. ......

How to Add My Computer / This PC on Microsoft Windows 10 Taskbar

noreply@blogger.com (Sujay Sharma) — Fri, 28 Aug 2015 21:01:00 +0000

Tutorials for Customize and Configure the Taskbar in Microsoft Windows 10. This is very easy for add my computer or this pc in Microsoft Windows10 taskbar.

1. Right Click On My Computer or This PC and Select Create Shortcut as shown in figure...

After Click on Create Shortcut as shown in figure

After Rename , Drag this shortcut on taskbar and drop it.

Use Of Picture Password in Microsoft windows 10

noreply@blogger.com (Sujay Sharma) — Fri, 28 Aug 2015 19:57:00 +0000

Now Use Of Picture Password in Microsoft windows 10. In Microsoft windows 10 Picture Password is a new way to protect your touchscreen PC.

New features in Microsoft Windows 10 with Start Menu, Cortana, and Microsoft Edge.

1. Click on Start Menu , Click on Setting as shown in figure....

2. After Click on Setting , Click On Account as shown in figure....

3.Now Click On Sign-in Option as shown in figure , after click on add (Picture password)

4. After click on add enter your password for microsoft windows 10 account as shown in figure .......

5. After enter your password for Microsoft windows 10 account choose your picture for use of picture password as shown in figure .......

6. After choose your picture for Microsoft windows 10 account picture password as shown in figure.
follow the instruction on screen.....

Now you have three option for create your picture password for Microsoft windows 10 account as shown in figure....1. Clicks , 2. Circle / Taps and 3. Straight lines

After complete the instruction on screen , you have done.

Enjoy Microsoft Windows 10 Picture Password.

How To Remove Unwanted Startup Programs Microsoft windows 7, Microsoft windows 8.1, Microsoft windows 10

noreply@blogger.com (Sujay Sharma) — Mon, 18 May 2015 09:26:00 +0000

How To Remove Unwanted Startup Programs Microsoft windows 7, Microsoft windows 8.1, Microsoft windows 10 OR
How to Manage or Disable Startup Programs in Microsoft windows 7, Microsoft windows 8.1, Microsoft windows 10 OR
How to Enable and Disable Startup Programs in Microsoft windows 7, Microsoft windows 8.1, Microsoft windows 10 OR
How to remove unwanted startup programs in Microsoft windows 7, Microsoft windows 8.1, Microsoft windows 10 OR

How to change Startup Programs in Microsoft windows 7, Microsoft windows 8.1, Microsoft windows 10

You don't want to start automatically program then follow steps...........

Press windows + R key and type msconfig then press ok.

now select startup tab

now select Unwanted Startup Programs

now click on apply and ok

now restart windows

click on restart. After restart window Unwanted Startup Program removed.

How To Get Data Recovery From Deleted Data Or Formatted Hard Disk

noreply@blogger.com (Sujay Sharma) — Thu, 02 Apr 2015 06:07:00 +0000

I am using Classic GetDataBack software for data recovery . Download Data Recovery Software here. After download and install , Open it…..

After getdataback recovery software open automatically detect your hard disk …

After Click your drive …..Recovery Software.

You see in figure , total hard disk drive in your computer… Recovery Software. After this select your drive for data
recovery .

After select your drive Recovery software working this type .. as shown in figure

wait for next process , don’t click anywhere on Recover Software as shown in figure. After complete process

Now search your deleted data or formatted data from your Recovery software. select delete for recovery data
for deleted data as shown in figure..

Now you get your lost data from Recovery software. As shown in figure.

If you are using “classic GetDataBack” in my next blog classic GetDataBack recovery software.

Programming Example Websites

noreply@blogger.com (Sujay Sharma) — Thu, 02 Apr 2015 06:05:00 +0000

Know More : Microsoft ASP.Net Microsoft VB.Net Microsoft C#.Net Microsoft Silverlight XML Microsoft WPF Microsoft WCF Ajax Microsoft SQL Server Download Game

MSDN

   ^{Microsoft C#.Net}      ^{^{Microsoft VB.Net}}
^{^{^{Microsoft Silverlight      ^{Microsoft WPF}}}}
^{^{^{^{Microsoft WCF}}}}
^{^{^{^{^{Microsoft SQL Server}}}}}^{^{^{^{^Codeplex}}}}
^{AjaxXML                                                                        Microsoft ASP.Net
                                                                      Tutorials point
                                                                                                                          Code project}

w3schools

Know More : Microsoft ASP.Net Microsoft VB.Net Microsoft C#.Net Microsoft Silverlight XML Microsoft WPF Microsoft WCF Ajax Microsoft SQL Server Download Game

Compare Validator In ASP.Net

noreply@blogger.com (Sujay Sharma) — Thu, 24 Jun 2010 04:28:00 +0000

Know More : Microsoft ASP.Net Microsoft VB.Net Microsoft C#.Net Microsoft Sliverlight XML Microsoft WPF Microsoft WCF Ajax Microsoft SQL Server

This control is used to perform comparison between a value entered with another value. The other value can be a number or a value entered into another control. If you want to compare a specific data entry control with another data entry control, set the ControlToCompare property to specify the control to compare with.You can compare the value of a data entry control to a constant value. In this case ,you specify the constant value to compare with a setting the ValueToCompare.Let’s start in Microsoft Visual Studio 2010 , Create a new website name it compare validator for textbox . After this, drag button,label, textbox ,compare validator controls from toolbox you see in figure.

After drag controls from toolbox , now go to properties of compare validator. I have set the comparison validator’s ControlToValidate property to textbox2 , and its ControlToCompare property to Textbox1.I have also set the type property to integer and the operator property to LessThan.You can compare to a constant value just use the ValueToCompare property.And as with other validation controls,you set the ControlToValidate property to set the control whose data you want to validates,and place the error message in the ErrorMessage property.As shown in figure..

Now press F5 or select debug from debug menu , a debug window will be open and select “Run without debugging” your web page will be open in default browser.

In figure , you can see the comparison validator displaying its error message when the user corrects the situation in one or the other textboxes and the text box loses the focus, the comparison validator will test the data again.Thanks.

Know More : Microsoft ASP.Net Microsoft VB.Net Microsoft C#.Net Microsoft Sliverlight XML Microsoft WPF Microsoft WCF Ajax Microsoft SQL Server

Range Validator In ASP.Net

noreply@blogger.com (Sujay Sharma) — Sun, 20 Jun 2010 16:15:00 +0000

Know More : Microsoft ASP.Net Microsoft VB.Net Microsoft C#.Net Microsoft Sliverlight XML Microsoft WPF Microsoft WCF Ajax Microsoft SQL Server

You use “Range Validator” control to check if the value of a data-entry control is in a specified range of values , Range validator test if the value of a data entry control is inside a specified range of values.You use three main properties here- the ControlToValidate property contains the data entry control to validate,and the MinimumValue and MaximumValue value properties specify the minimum and maximum values of the valid range,the error message in the ErrorMessage property which makes simply sure that the user have entered data into data-entry control. If the data has not changed from that value when validation occurs, the control displays its error message.The Range Validator in the validation controls example makes sure that the user has entered a class rank in the top textbox.Let’s start in Microsoft Visual Studio 2010 , Create a new website name it range validator for textbox . After this, drag button,label, textbox ,range validator controls from toolbox you see in figure.

After drag controls from toolbox , now go to properties of Range Validator. Here i given this control the error message “Student name should be 25 char(minimum)”. Using its errormessage property. I also have set the controlTo validate property of this control to Textbox1 ,also set maximum value 250, minimum value 25 also select type string as shown in figure..

Now press F5 or select debug from debug menu , a debug window will be open and select “Run without debugging” your web page will be open in default browser. If the user doesn’t entry any data into the textbox and then clicks the button ,which sends the page back to the server, the Range validator displays its error message and stop the page from being sent to the server as you see in figure.The user can enter text in the textbox and try again ,all without a round trip to the server.Thanks.

Know More : Microsoft ASP.Net Microsoft VB.Net Microsoft C#.Net Microsoft Sliverlight XML Microsoft WPF Microsoft WCF Ajax Microsoft SQL Server

Required Field Validator In Asp.Net

noreply@blogger.com (Sujay Sharma) — Sun, 20 Jun 2010 06:55:00 +0000

Know More : Microsoft ASP.Net Microsoft VB.Net Microsoft C#.Net Microsoft Sliverlight XML Microsoft WPF Microsoft WCF Ajax Microsoft SQL Server

The Simple validation control is the “Required Field Validator” control , which makes simply sure that the user have entered data into data-entry control. If the data has not changed from that value when validation occurs, the control displays its error message.The Required Field Validator in the validation controls example makes sure that the user has entered a class rank in the top textbox.Let’s start in Microsoft Visual Studio 2010 , Create a new website name it required field validator for textbox . After this, drag label, textbox ,required field validator controls from toolbox you see in figure.

After drag controls from toolbox , now go to properties of required field validator. Here i given this control the error message “Student name can not be blank.” using its errormessage property. I also have set the controlTo validate property of this control to Textbox1 as shown in figure..

Now press F5 or select debug from debug menu , a debug window will be open and select “Run without debugging” your web page will be open in default browser. If the user doesn’t entry any data into the textbox and then clicks the button ,which sends the page back to the server, the required field validator displays its error message and stop the page from being sent to the server as you see in figure.The user can enter text in the textbox and try again ,all without a round trip to the server.

Thanks.

Know More : Microsoft ASP.Net Microsoft VB.Net Microsoft C#.Net Microsoft Sliverlight XML Microsoft WPF Microsoft WCF Ajax Microsoft SQL Server

Timer In VB.net

noreply@blogger.com (Sujay Sharma) — Wed, 16 Jun 2010 14:48:00 +0000

Know More : Microsoft ASP.Net Microsoft VB.Net Microsoft C#.Net Microsoft Sliverlight XML Microsoft WPF Microsoft WCF Ajax Microsoft SQL Server

Timer are also very useful control, because they let you periodic events and they do not appear in a window at run time.At design time,they appear in the component tray underneath the form you have added them to. Let’s start in Visual Studio 2010 , Create a new project and name it “ Digital Clock ”. After this, drag label, timer from toolbox on the form1. As shown in figure.

There is a timer at work behind the scenes in the timer which shows a clock using label control.This control is a useful one for,among other things,creating clocks. Now double click on blank form1 and type in form_load event or copy and paste..                         Timer1.Enabled = True          and now back to from 1 designer press shift+ F7 button or go to view menu and select designer. Double click on timer1. Copy code and paste     Label1.Text = TimeOfDay    like this..
Private Sub Timer1_Tick(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Timer1.Tick
       Label1.Text = TimeOfDay
   End Sub
You Can also Convert VB.Net To C# , Python, Ruby . Now press F5 button or select debug from debug menu , the output will be shown in figure. Enjoy your digital clock. Thanks.

Know More : Microsoft ASP.Net Microsoft VB.Net Microsoft C#.Net Microsoft Sliverlight XML Microsoft WPF Microsoft WCF Ajax Microsoft SQL Server

TextBox Text Changed Events In VB.Net

noreply@blogger.com (Sujay Sharma) — Wed, 16 Jun 2010 13:18:00 +0000

Know More : ASP.Net VB.Net C#.Net Sliverlight XML WPF WCF Ajax
Let’s start in visual studio 2010, when the user changes the text in a textbox , a textchanged event occurs, just as it does when the user types in a standard textbox .You can read the new text in the textbox with the text property ; for example ,here is how we display the new text in the textbox every time the user changes that text by typing. Create a new project in vs2010 name it textchanged events in visual basic.net . Drag two textboxes from toolbox on form1 as shown in figure..
After double click on textbox1, textchanged event. copy code and paste it to textbox1_textchanged event like this.
Private Sub TextBox1_TextChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles TextBox1.TextChanged
TextBox2.Text = TextBox1.Text
End Sub
You Can also Convert VB.Net To C# , Python, Ruby . And now press f5 button or select debug from debug menu , your output as shown in figure and type anything in textbox1 , your type word is show in second textbox . Thanks.

Know More : ASP.Net VB.Net C#.Net Sliverlight XML WPF WCF Ajax

TextBox Digit Or Numeric Only In VB.Net

noreply@blogger.com (Sujay Sharma) — Wed, 16 Jun 2010 11:15:00 +0000

Know More : ASP.Net VB.Net C#.Net Sliverlight XML WPF WCF Ajax
Let’s start in Visual Studio 2010 , Create a new project and name it “Textbox digit only”. After this, drag textbox from toolbox on the form1 also drag label name it mobile no. As shown in figure do this..
Copy and paste code on textbox keypress event..
If (e.KeyChar < "0" OrElse e.KeyChar > "9") Then
            If (e.KeyChar <> Microsoft.VisualBasic.ChrW(8) AndAlso e.KeyChar <> "DEL") Then
                e.Handled = True
                MessageBox.Show("Enter digit only.", "Sujay Application", MessageBoxButtons.OK)
            End If
        End If
You Can also Convert VB.Net To C# , Python, Ruby

Now press F5 button or select debug from debug menu.Thanks.
Know More : ASP.Net VB.Net C#.Net Sliverlight XML WPF WCF Ajax

Date Time Format In VB.Net

noreply@blogger.com (Sujay Sharma) — Mon, 14 Jun 2010 10:57:00 +0000

Know More : ASP.Net VB.Net C#.Net Sliverlight XML WPF WCF Ajax
The format function makes easy to format dates into strings, including times.Using format to display dates and times. As shown figure.

Copy and paste here ..

Format Expression	Example
Format(Now, "M-d-yy")	1-1-10
Format(Now, "M/d/yy")	1/1/10
Format(Now, "MM – dd – yy")	01 – 01 – 10
Format(Now, "dddd,MMMM d,yyy")	Friday,January 1, 2010
Format(Now, "d MMM,yyy")	1 Jan,2010
Format(Now, "hh:mm:ss MM/dd/yy")	01:00:00 01/01/10
Format(Now, "hh:mm:ss tt MM-dd-yy")	01:00:00 AM 01/01/10

Thanks.
Know More : ASP.Net VB.Net C#.Net Sliverlight XML WPF WCF Ajax

Accessing Data With The Server Explorer In ASP.Net

noreply@blogger.com (Sujay Sharma) — Mon, 14 Jun 2010 10:17:00 +0000

Know More : ASP.Net VB.Net C#.Net Sliverlight XML WPF WCF Ajax
Let’s start in Microsoft Visual Studio 2010 and Microsoft SQL Server 2008,To work with a database, you need a connection to that database. In Microsoft Visual Basic.Net , the server explorer lets you work with connections to various data sources. To display the server explorer if it is not already visible, use view | server explorer menu item , or press Ctrl + Alt + S. As shown in figure.

where i have docked it to the left edge of the visual basic IDE(By Clicking the thumbnail icon). This tool lets you create and examine data connections , including connections to web servers ; you can see connections to various databases in the server explorer already. In this easy example , I am going to display the data from the Employee table in the Microsoft SQL Server’s AdventureWorks – HumanResources sample database , So we’ll need a connection to that database. To create that connection , right click the data connection icon in the server explorer and select the “add connection” item.Doing so opens the data link properties dialog box you see in figure.

After complete your database connection. Now drag table from server explorer on the form as shown in figure.

Now , run the application or press f5 button | start debugging from debug menu , you can see the result in figure.Thanks.

Know More : ASP.Net VB.Net C#.Net Sliverlight XML WPF WCF Ajax

ComboBox DataBinding with XML in C#.net

noreply@blogger.com (Sujay Sharma) — Tue, 08 Jun 2010 13:32:00 +0000

Know More : ASP.Net VB.Net C#.Net Sliverlight XML WPF WCF Ajax
Let’s Start ComboBox DataBinding with XML in C-sharp with Visual Studio 2010\2008\2005. This is very simple. Firstly you have to a xml file for this.Now in visual studio 2010 we create a new project name “Xml to Combobox”. As shown in figure..

After drag combobox control on form 1. Double click on form , declare namespace using System.Xml; also change your xml file path.As shown in figure..

copy code and paste form_load……….
{// Declare a variable of type XmlTextReader
     XmlTextReader xtr = null;
     // Declare a string that holds the name of the file
     string fileName = "D:\\AC_backup\\product.xml";
     try {
         // Initialize the XmlTextReader variable with the name of the file
         xtr = new XmlTextReader(fileName);
         xtr.WhitespaceHandling = WhitespaceHandling.None;
         // Scan the XML file
         while (xtr.Read())
         {
             // every time you find an element, find out what type it is
             switch (xtr.NodeType)
             {
                 case XmlNodeType.Text:
                     // If you find text, put it in the combo box' list
                     this.comboBox1.Items.Add(xtr.Value);
                     break;
             }
         }
         // For this example, select the first item
         this.comboBox1.SelectedIndex = 0;
     }
     finally
     {
         // Close the XmlTextReader
         if (xtr != null)
             xtr.Close();
     }
        }
Now press f5 button , the form will be open and also ComboBox DataBinding with XML completed. Thanks.
Know More : ASP.Net VB.Net C#.Net Sliverlight XML WPF WCF Ajax

GridView Filtering with DropDownList Or Textbox In ASP.NET Without Any Code(VB.Net \ C#.Net)

noreply@blogger.com (Sujay Sharma) — Sat, 29 May 2010 11:03:00 +0000

Know More : ASP.Net VB.Net C#.Net Sliverlight XML WPF WCF Ajax
Let’s start with visual studio 2010\2008\2005\2003.
Go to file menu and select new website as shown in figure..

Next..
If you select your web location “HTTP” then use this step – by- step as shown in figure..

Next..

After your web form is open like this..
Select design mode as shown in figure..

Now in design mode, drag DropDownList, Textbox, GridView, also two SqlDataSource controls from toolbox as shown in figure..

Now Configure SqlDataSource1 as shown in figure..

Select your database connection if you have already created.

Or use new sql connection.After click new connection ' add connection form open' like this use step shown in figure.

After connection created. Now data binding DropDownList control like this ..

After binding DropDownList control , Now Configure SqlDataSource2 control for GridView, for filtering with DropDownList Or Textbox control as shown in figure…

After click on Ok button, Now binding GridView control with SqlDataSource2 like this.

After binding , Now start debugging from debug menu or press f5 button, After debug your application shown in figure ……

After click on Ok button your output like this in browser…

After select Employee Id from DropDownList , change the value in Gridview and also you can use textbox control like DropDownList control. Thanks.
Know More : ASP.Net VB.Net C#.Net Sliverlight XML WPF WCF Ajax

Print , Windows Desktop Application Or According To You.

noreply@blogger.com (Sujay Sharma) — Thu, 27 May 2010 03:49:00 +0000

Know More : ASP.Net VB.Net C#.Net Sliverlight XML WPF WCF Ajax
You can print , complete windows desktop application or as you want to print your design like shop bill print , school fee receipt etc. For print your application or your document design, you need to print control in visual studio toolbox “Print form”. This control is not default control for visual studio( in some edition) , you have to download this control from Microsoft site Or search in Google (Type in Google “Visual Basic Power Packs”) or click here to download “”.You can use this control in VB.Net or C#.net application.After complete installation of “Visual Basic Power Packs”. Open Visual studio , and watch in toolbox, as shown in figure..

Now drag and drop printform control on form. You can design your application as you want after complete your design , you can give print command on button or context menu or menu or as you want. I am using button control for print command.
Imports System.Threading.Thread
Imports System.IO

Public Class retail_print

    Private Sub ButtonX1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles LabelX1.Click
        PrintForm1.PrintAction = Printing.PrintAction.PrintToPreview
        PrintForm1.Print()
    End Sub
End Class
Now start debugging from debug menu or press f5 button, After debug your application Output as shown in figure ……

Thanks.
Know More : ASP.Net VB.Net C#.Net Sliverlight XML WPF WCF Ajax

How to read and write text file (.txt) in VB.net

noreply@blogger.com (Sujay Sharma) — Wed, 26 May 2010 17:12:00 +0000

Know More : ASP.Net VB.Net C#.Net Sliverlight XML WPF WCF Ajax
Let’s start ..In visual studio 2010\2008\2005\2003 edition, Firstly design your desktop application as shown in figure..

For design, you have drag some controls like one textbox or richtextbox,one Label and three buttons and rename it on form design also set textbox multiline properties true as shown in above figure..after do that go to form view code , first declare namespace like this…….
Imports System.IO
Public Class Form1
    Dim fsteream As New FileStream("C:\Example.txt", FileMode.OpenOrCreate, FileAccess.ReadWrite)
    Dim sw As New StreamWriter(fsteream)
    Private Sub Reset_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Reset.Click
        TextBoxX1.Text = ""
    End Sub
    Public Sub writedata(ByVal Data As String, ByVal sw As StreamWriter)
        sw.WriteLine(Data)
        sw.WriteLine("")
        sw.Flush()
    End Sub
    Public Sub readdata(ByVal r As StreamReader)
        TextBoxX1.Text = r.ReadToEnd
    End Sub
    Private Sub Write_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Write.Click
        sw.BaseStream.Seek(0, SeekOrigin.End)
        writedata(TextBoxX1.Text, sw)
        Read.Enabled = True
        Write.Enabled = False
        TextBoxX1.Text = ""
    End Sub
    Private Sub Read_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Read.Click
        Dim sr As New StreamReader(fsteream)
        sr.BaseStream.Seek(0, SeekOrigin.Begin)
        readdata(sr)
        Read.Enabled = False
        Write.Enabled = True
    End Sub
    Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
    End Sub
End Class
Now start debugging from debug menu or press f5 button, After debug your application Output as shown in figure ……

after type, click on “write” button and also click on read button.Now your text file is complete for read and write.Thanks.
Know More : ASP.Net VB.Net C#.Net Sliverlight XML WPF WCF Ajax

Round Value in VB.Net (E.g."3.9")

noreply@blogger.com (Sujay Sharma) — Sat, 22 May 2010 11:35:00 +0000

Know More : ASP.Net VB.Net C#.Net Sliverlight XML WPF WCF Ajax

Imports System
Imports System.Data
Imports System.Diagnostics
Public Class Form1

    Private Sub ButtonX1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ButtonX1.Click

        Dim d As Decimal = CDec(TextBoxX1.Text)
        TextBoxX2.Text = Math.Round(d)

    End Sub
End Class
Thanks.
Know More : ASP.Net VB.Net C#.Net Sliverlight XML WPF WCF Ajax

Insert a XML file in SQL server "Database" with C#.net

noreply@blogger.com (Sujay Sharma) — Sat, 22 May 2010 10:30:00 +0000

Know More : ASP.Net VB.Net C#.Net Sliverlight XML WPF WCF Ajax

using System;
using System.Data;
using System.Xml;
using System.Windows.Forms;
using System.Data.SqlClient;
using System.IO;

namespace Xml_to_database_insert
{
    public partial class Form1 : Form
    {
        DataTable dt;
        DataRow dr;
        public Form1()
        {
            InitializeComponent();
        }

        private void buttonX1_Click(object sender, EventArgs e)
        {
            string l = "D:\\RAPL\\RAPLStaff.xml"; // your xml file path.
            DataSet dtk = new DataSet();
            FileStream fstr = new
       FileStream("D:\\RAPL\\RAPLStaff.xml", FileMode.Open,
FileAccess.Read);
            dtk.ReadXml(fstr);

            // string myfile = "c:\\D.xml";
            oleDbDataAdapter1.Update(dtk);
            MessageBox.Show("Data loaded");
        }
    }
}
Know More : ASP.Net VB.Net C#.Net Sliverlight XML WPF WCF Ajax