IEEE Press
445 Hoes Lane
Piscataway, NJ 08854
IEEE Press Editorial Board
Ekram Hossain, Editor in Chief
Jón Atli Benediktsson | David Alan Grier | Elya B. Joffe |
Xiaoou Li | Peter Lian | Andreas Molisch |
Saeid Nahavandi | Jeffrey Reed | Diomidis Spinellis |
Sarah Spurgeon | Ahmet Murat Tekalp |
Copyright © 2020 by The Institute of Electrical and Electronics Engineers, Inc. All rights reserved.
Published by John Wiley & Sons, Inc., Hoboken, New Jersey.
Published simultaneously in Canada.
No part of this publication may be reproduced, stored in a retrieval system, or transmitted in any form or by any means, electronic, mechanical, photocopying, recording, scanning, or otherwise, except as permitted under Section 107 or 108 of the 1976 United States Copyright Act, without either the prior written permission of the Publisher, or authorization through payment of the appropriate per‐copy fee to the Copyright Clearance Center, Inc., 222 Rosewood Drive, Danvers, MA 01923, (978) 750‐8400, fax (978) 750‐4470, or on the web at www.copyright.com. Requests to the Publisher for permission should be addressed to the Permissions Department, John Wiley & Sons, Inc., 111 River Street, Hoboken, NJ 07030, (201) 748‐6011, fax (201) 748‐6008, or online at http://www.wiley.com/go/permission.
Limit of Liability/Disclaimer of Warranty: While the publisher and author have used their best efforts in preparing this book, they make no representations or warranties with respect to the accuracy or completeness of the contents of this book and specifically disclaim any implied warranties of merchantability or fitness for a particular purpose. No warranty may be created or extended by sales representatives or written sales materials. The advice and strategies contained herein may not be suitable for your situation. You should consult with a professional where appropriate. Neither the publisher nor author shall be liable for any loss of profit or any other commercial damages, including but not limited to special, incidental, consequential, or other damages.
For general information on our other products and services or for technical support, please contact our Customer Care Department within the United States at (800) 762‐2974, outside the United States at (317) 572‐3993 or fax (317) 572‐4002.
Wiley also publishes its books in a variety of electronic formats. Some content that appears in print may not be available in electronic formats. For more information about Wiley products, visit our web site at www.wiley.com.
Library of Congress Cataloging‐in‐Publication Data
Names: Bai, Ying, 1956– author.
Title: SQL server database programming with visual basic.net : concepts, designs and implementations / Ying Bai, Department of Computer Science and Engineering, Johnson C. Smith University Charlotte, North Carolina.
Description: First edition. | Hoboken, NJ : John Wiley & Sons, Inc., [2020] | Series: Wiley IEEE | Includes bibliographical references and index.
Identifiers: LCCN 2020016203 (print) | LCCN 2020016204 (ebook) | ISBN 9781119608509 (paperback) | ISBN 9781119608516 (adobe pdf) | ISBN 9781119608608 (epub)
Subjects: LCSH: SQL server. | Client/server computing. | Database management. | Visual Basic (Computer program language)
Classification: LCC QA76.9.C55 S7525 2020 (print) | LCC QA76.9.C55 (ebook) | DDC 005.75/85–dc23
LC record available at https://lccn.loc.gov/2020016203
LC ebook record available at https://lccn.loc.gov/2020016204
Cover Design: Wiley
Cover Image: © Hoxton/Martin Barraud/Getty Images
This book is dedicated to my wife, Yan Wang
and my daughter, Susan (Xue) Bai.
Dr. YING BAI is a Professor in the Department of Computer Science and Engineering at Johnson C. Smith University. His special interests include: artificial intelligent controls, soft‐computing, mix‐language programming, fuzzy logic controls, robotic controls, robots calibrations, and database programming.
His industry experience includes positions as software and senior software engineer at companies such as Motorola MMS, Schlumberger ATE Technology, Immix TeleCom, and Lam Research.
Since 2003, Dr. Bai has published fifteen (15) books with publishers such as Prentice Hall, CRC Press LLC, Springer, Cambridge University Press, and Wiley IEEE Press. Two of them were translated into other languages. The Russian translation of his first book titled Applications Interface Programming Using Multiple Languages was published by Prentice Hall in 2005. The Chinese translation of his eigth book titled Practical Database Programming with Visual C#.NET was published by Tsinghua University Press in China in 2011. Most books are about software programming, serial port programming, fuzzy logic controls in industrial applications, microcontroller controls and programming, as well as classical and modern controls on microcontrollers.
During recent years, Dr. Bai has also published about sixty (60) academic research papers in IEEE Trans. Journals and International conferences.