Tutorials

SQL server 2008 Save,Edit,Delete and Search from Datagridview Vb.net 2008

Submitted by princenathan on
Imports System.Data Imports System.Data.SqlClient Public Class frmRID Dim sCommand As SqlCommand Dim sAdapter As SqlDataAdapter Dim sBuilder As SqlCommandBuilder Dim sDs As DataSet Dim sTable As DataTable Private Sub cnew_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cnew.Click Call main() Con.Open()

Connect to SQL Server 2008 through TCP / IP Using VB.NET 2008 Project

Submitted by princenathan on
Hi this is Vb.net connect sql server using TCP/IP before run this program you need to install a vb.net 2008 and sql server 2008 here in example code: Hi you need to do this click all program/ ms sql server 2008 / configuration tool then click SQL server configuration manager select you server name then rigth click properties you need to enable a TCP and IP add then Restart

How to Store Data Under %appdata% Using Visual Basic .NET

Submitted by admin on

Sometimes we need to store some data or files under %appdata%. If you are using Windows 7 you can find this folder under C:\Users\Username\AppData.

AppData is a folder used to store information like cookies, Libraries, program settings, temporary files, templates, etc.

By using this folder you are certain that your settings are being protected by Windows.

To access this folder, all you have to do is use the following code:

Solved: Saving changes is not permitted. The changes you have made...

Submitted by admin on

If you are working with SQL Server Management Studio Tools and encounter the following error when modifying one of your tables:

“Saving changes is not permitted. The changes you have made require the following tables to be dropped and re-created. You have either made changes to a table that can't be re-created or enabled the option Prevent saving changes that require the table to be re-created.”

All you have to do is unchecked the “Prevent saving changes that require the table to be re-created” under the tools menu.

Follow the screenshot below to disable it.

PHP Operators

Submitted by admin on

In every programming language, operators play an important role. It can be use in comparison statements like IF statement, loops statement like WHILE loops, assigning a value to a variable and a lot more.

How to Rename SQL Server Database and the Database Filename (.mdf file)

Submitted by admin on

In this tutorial I will teach you on how to rename an SQL Server Database and its filename.

For this purpose, we will use "LibSys" database on my SQL Server Management tools and rename it to "LibrarySystem". Remember that we have to rename the following:

  • Filename
  • Logical name
  • Database name

As opposed to other tutorial, they only rename either Logical name or Filename of the database. In the case of this tutorial, we will rename all of them.