C#_C#简单连接sql数据库的方法,本文实例讲述了C#简单连接sql
按任意键退出");Console.ReadKey();} }} 更多关于C#相关内容感兴趣的读者可查看本站专题:《C#中XML文件操作技巧汇总》、《C#常见控件用法教程》、《WinForm控件用法总结》、《C#数据结构与算法教程》、《C#面向对象程序设计入门教程》及《C#程序设计之线程使用技巧总结》 ,rightwords varchar(30),sign) values('" + a[0] + "'。
)";//sqlCmd.ExecuteScalar();while (a[0] != null) {sqlCmd.CommandText ="insert into wordlist(wrongwords,rightwords,'" + a[1] + "',1 )";sqlCmd.ExecuteScalar();a[0] = null;a[1] = null;words.getwords(ref a);}words.fileclose();Console.WriteLine();//打印所有记录}catch (SqlException e){Console.WriteLine(e.Message);}finally{conn.Close();}Console.WriteLine("程序结束, using System;using System.Collections.Generic;using System.Text;//数据库操作对象库using System.Data;using System.Data.SqlClient;using worddic;namespace testDB{ class Program {static void Main(string[] args){//char[] array = new char[2] ;string [] a = new string[2];FileOp words = new FileOp();words.openfile("worddic.txt");words.getwords(ref a);/IT之家 Console.WriteLine("请输入Data Source:");string data_source = Console.ReadLine();Console.WriteLine("请输入Initial Catalog:");string initial_catalog = Console.ReadLine();Console.WriteLine("请输入user id:");string user_id = Console.ReadLine();Console.WriteLine("请输入pass word:");string pword = Console.ReadLine();//连接字符串string strConn ="Data Source="+data_source+";Initial Catalog="+initial_catalog+";User;Password="+pword+"";//YourPwd替换为你设置的sa账户密码IT之家/string strConn = "Data Source=HYPER-V-WIN2003\\SQLSRV2005;Initial Catalog=Mytest;User ID=sa;Password=sa";SqlConnection conn = null;SqlCommand sqlCmd = null;try{//创建connection对象conn = new SqlConnection(strConn);//打开数据库连接conn.Open();//创建Transac Sql命令对象sqlCmd = conn.CreateCommand();//创建建表语句//sqlCmd.CommandText = "create table wordlist(wrongwords varchar(30),sign char(20),。
相关热词:
本站内容来源于网络,如有侵权请与我们联系,我们会及时删除,我们深感抱歉!
注:本站所有信息仅供用于网络技术学习参考,学习中请遵循相关法律法规!
本文地址: https://v30.fanwenzhu.com/jiaob/c/9036.shtml
